R
R
RuRoman2022-04-20 16:45:40
linux
RuRoman, 2022-04-20 16:45:40

MySQL crashed and not picked up, what should I do?

After restarting the server, mysql does not rise, the restart gives an error:

InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864 bytes
InnoDB: than specified in the .cnf file 0 50331648 bytes!
InnoDB: Possible causes for this error:
 (a) Incorrect log file is used or log file size is changed
 (b) In case default size is used this log file is from 10.0
 (c) Log file is corrupted or there was not enough disk space
 In case (b) you need to set innodb_log_file_size = 48M
[ERROR] Plugin 'InnoDB' init function returned error.
[ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
[Note] Plugin 'FEEDBACK' is disabled.
[ERROR] Unknown/unsupported storage engine: InnoDB
[ERROR] Aborting

Answer the question

In order to leave comments, you need to log in

1 answer(s)
J
justhostRU, 2022-04-23
@justhostRU

First, you can check the disk.
is there free disk space?
what are the mount options?
Then try restoring from a backup.
remember if you updated mysql? do not upgrade the DBMS without backups!

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question