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>
next in thread | raw e-mail | index | archive | help
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, Udo
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?2b663bca-5579-41c8-9db3-02bf87424d0f>