I'm running a Magento 2 site, everyday we have a MySQL shutdown because of some corrupted data, we don't know the table causing the issue, this is what the error logs shows:

 Version: '5.7.26-0ubuntu0.18.04.1'  socket: '/tmp/tmp.c5OkKsNidi/mysqld.sock'  port: 0  (Ubuntu)
2019-05-19T06:17:30.001609Z 0 [Note] InnoDB: Buffer pool(s) load completed at 190519  6:17:29
2019-05-19T06:17:37.299075Z 2 [ERROR] InnoDB: Database page corruption on disk or a failed file read of page [page id: space=28974, page number=1]. You may have to recover from a backup.
2019-05-19T06:17:37.299098Z 2 [Note] InnoDB: Page dump in ascii and hex (16384 bytes):
 len 16384; hex asc                     u6              q.   ...   ' x         ' x   ' x      .... u6  ;
InnoDB: End of page dump

Any ideas? Doing a MySQL restart does the trick but I need to do it manually, we need to be sure the db is fixed, but we can't get the name of the table.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.