Date: Thu, 10 Oct 2024 22:08:08 +0200 From: Udo Pokojski <freebsd@upokojski.de> To: freebsd-questions@freebsd.org Subject: Mysql-Server not starting Message-ID: <2b663bca-5579-41c8-9db3-02bf87424d0f@upokojski.de>
index | next in thread | raw e-mail
Hallo, after doing an pkg update and pkg upgrade on FreeBSD 13.3, I cannot start the mysql-server. The command service mysql-server start returns no error. In the mysql error log, I can find the following messages: 2024-10-10T19:55:15.913147Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-10-10T19:55:16.148244Z 1 [ERROR] [MY-012263] [InnoDB] The Auto-extending innodb_system data file '/var/db/mysql/ibdata1' is of a different size 768 pages (rounded down to MB) than specified in the .cnf file: initial 8192 pages, max 0 (relevant if non-zero) pages! 2024-10-10T19:55:16.148370Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2024-10-10T19:55:16.149901Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2024-10-10T19:55:16.150187Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2024-10-10T19:55:16.150233Z 0 [ERROR] [MY-010119] [Server] Aborting Something seems to wrong with my my.cnf file. The only line which affects the innodb file size is: innodb_data_file_path = ibdata1:128M:autoextend I never changed this line an In have no idea how to fix the error. Any help is appreciated. Thanks in advance, Udohome | help
Want to link to this message? Use this
URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?2b663bca-5579-41c8-9db3-02bf87424d0f>