Skip to main content
Database Administrators

Return to Question

Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
corrected spelling and edit some words
Source Link
edit approved Oct 27, 2022 at 10:39
Ehsan HP
edit approved Oct 27, 2022 at 10:39
Ehsan HP
  • 214
  • 3
  • 9

In my Plesk Obsidian version 18.0.42 running on CentOS Linux release 7.9.2009 with mysqlMySQL version 10.2.43-MariaDB. All of a sudden database has stopped working. Mysql service never comes up on start request. On checking the logs I found the below information saying that "CORRUPT LOG RECORD FOUND". I have tried starting the mysqlMySQL using innodb_force_recovery from 1 to 6 meanwhile, all other than 6 has failed. Using 6 iI can start the service in recovery mode. I could see from logs that lots of tables of the major 4 databases including pleskPlesk database waswere corrupted. The major two databases were moodle dbDB and had critical data of 7GB and 2GB respectively.

In my Plesk Obsidian version 18.0.42 running on CentOS Linux release 7.9.2009 with mysql version 10.2.43-MariaDB. All of a sudden database has stopped working. Mysql service never comes up on start request. On checking the logs I found the below information saying that "CORRUPT LOG RECORD FOUND". I have tried starting the mysql using innodb_force_recovery from 1 to 6 meanwhile, all other than 6 has failed. Using 6 i can start the service in recovery mode. I could see from logs that lots of tables the major 4 databases including plesk database was corrupted. The major two databases were moodle db and had critical data of 7GB and 2GB respectively.

In my Plesk Obsidian version 18.0.42 running on CentOS Linux release 7.9.2009 with MySQL version 10.2.43-MariaDB. All of a sudden database stopped working. Mysql service never comes up on start request. On checking the logs I found the below information saying that "CORRUPT LOG RECORD FOUND". I have tried starting the MySQL using innodb_force_recovery from 1 to 6 meanwhile, all other than 6 has failed. Using 6 I can start the service in recovery mode. I could see from logs that lots of tables of the major 4 databases including Plesk database were corrupted. The major two databases were moodle DB and had critical data of 7GB and 2GB respectively.

Bumped by Community user
Bumped by Community user
Source Link
nisamudeen97
nisamudeen97
  • 190
  • 1
  • 3
  • 8

Mysql service stops with [ERROR] InnoDB: CORRUPT LOG RECORD FOUND

In my Plesk Obsidian version 18.0.42 running on CentOS Linux release 7.9.2009 with mysql version 10.2.43-MariaDB. All of a sudden database has stopped working. Mysql service never comes up on start request. On checking the logs I found the below information saying that "CORRUPT LOG RECORD FOUND". I have tried starting the mysql using innodb_force_recovery from 1 to 6 meanwhile, all other than 6 has failed. Using 6 i can start the service in recovery mode. I could see from logs that lots of tables the major 4 databases including plesk database was corrupted. The major two databases were moodle db and had critical data of 7GB and 2GB respectively.

2022-04-13  8:37:27 140465444636864 [Note] InnoDB: Completed initialization of buffer pool
2022-04-13  8:37:27 140464863237888 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-04-13  8:37:27 140465444636864 [Note] InnoDB: Highest supported file format is Barracuda.
2022-04-13  8:37:27 140465444636864 [Note] InnoDB: Starting crash recovery from checkpoint LSN=158872609427
2022-04-13  8:37:27 140465444636864 [ERROR] InnoDB: ############### CORRUPT LOG RECORD FOUND ##################
2022-04-13  8:37:27 140465444636864 [Note] InnoDB: Log record type 65, page 158872609792:140721128394336. Log parsing proceeded successfully up to 158872609427. Previous log record type 128, is multi 0 Recv offset 0, prev 0
2022-04-13  8:37:27 140465444636864 [Note] InnoDB: Hex dump starting 0 bytes before and ending 100 bytes after the corrupted record:
 len 100; hex 4152330034003500360029a8eb3e00380001800880068007800080018001800180018008ffffffffffffffffffffffff80018000800080008000800080008000ffffffffffffffff8000800080008000ffff8008800880088008800080008008ffff7fff; asc AR3 4 5 6 )  > 8                                                                                    ;
2022-04-13  8:37:27 140465444636864 [Note] InnoDB: Set innodb_force_recovery to ignore this error.
2022-04-13  8:37:27 140465444636864 [Warning] InnoDB: Log scan aborted at LSN 158872673280
2022-04-13  8:37:27 140465444636864 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2022-04-13  8:37:27 140465444636864 [Note] InnoDB: Starting shutdown...
2022-04-13  8:37:27 140465444636864 [ERROR] Plugin 'InnoDB' init function returned error.
2022-04-13  8:37:27 140465444636864 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

I have followed the plesk KDB doc https://support.plesk.com/hc/en-us/...s-for-the-MySQL-databases-on-Plesk-for-Linux- to resolve the case. My point is i have to proceed with risky step of removing mysql data directory. Even the plesk db was in corrupted list. But I have managed to recover it finally using the daily backups. Had to restore including psa db from backups. It was too stressful 4 hours to put everything back normal. This is the second time i am facing the same issue with this plesk server. Can some one let me know why this is happening? How can we prevent this ? Is there some method to monitor the same?