Mysql-Server not starting
- Reply: Juan Manuel Palacios : "Re: Mysql-Server not starting"
- Go to: [ bottom of page ] [ top of archives ] [ this month ]
Date: Thu, 10 Oct 2024 20:08:08 UTC
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