Mysql-Server not starting

From: Udo Pokojski <freebsd_at_upokojski.de>
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