MySQL v8.0 Neither found #innodb_redo subdirectory, nor ib_logfile* files in /var/db/mysql/

Ofloo

Ofloo

Not sure what to make of this, ..

Code: 
2023-01-10T07:43:28.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2023-01-10T07:43:29.145355Z 0 [System] [MY-010116] [Server] /usr/local/libexec/mysqld (mysqld 8.0.31) starting as process 99601
2023-01-10T07:43:29.202193Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-01-10T07:43:29.341280Z 1 [ERROR] [MY-013862] [InnoDB] Neither found #innodb_redo subdirectory, nor ib_logfile* files in /var/db/mysql/
2023-01-10T07:43:29.341337Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-01-10T07:43:29.342855Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-01-10T07:43:29.343160Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-01-10T07:43:29.343199Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-01-10T07:43:29.345437Z 0 [System] [MY-010910] [Server] /usr/local/libexec/mysqld: Shutdown complete (mysqld 8.0.31)  Source distribution.
2023-01-10T07:43:29.6NZ mysqld_safe mysqld from pid file /var/db/mysql/mimir.pid ended
 
Just running after few months and indeed after a power cut this happened, .. but it could be after a upgrade as well, it's not a critical system it runs mysql just for zabbix server.

Alain De Vos, I think mysql_secure_installation requires the server to run, it's not running. If I remove all mysql directories like /var/db/mysql, there's an other one I can't think of but I know it is there find / -iname -type d "mysql" should find it. But that's not the point I don't think that will work. Reinstall and remove all mysql directories will work of course.
 
Ofloo said:
Just running after few months and indeed after a power cut this happend, ..
Click to expand...
UFS or ZFS? Power cuts can and will corrupt the filesystem, especially when they're being written to at the moment the power goes out.
 
Well it's a bhyve system the host system has zfs the system it self has ufs. I think it might be corruption though while ago something odd happend all vms suddenly froze never done that before all filesystems had become readonly for reasons unknown. After system reboot it didn't happen again. So maybe that's the reason why.
 
You must log in or register to reply here.
Back
Top