Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3.17
-
PROD
Description
Online backup database failed with Database page corruption detected at page 11:
2019-11-24 01:46:29 Copying ./p_octt/b2b_mvno_comment.ibd to /poctt/bak/POCTT/mypoctt.ONLINE.20191124014505/p_octt/b2b_mvno_comment.ibd
2019-11-24 01:46:29 Database page corruption detected at page 11, retrying...
2019-11-24 01:46:29 Database page corruption detected at page 11, retrying...
2019-11-24 01:46:30 Database page corruption detected at page 11, retrying...
2019-11-24 01:46:30 Database page corruption detected at page 11, retrying...
2019-11-24 01:46:30 Database page corruption detected at page 11, retrying...
2019-11-24 01:46:30 Database page corruption detected at page 11, retrying...
2019-11-24 01:46:30 Database page corruption detected at page 11, retrying...
2019-11-24 01:46:30 >> log scanned up to (207609946303)
2019-11-24 01:46:30 Database page corruption detected at page 11, retrying...
2019-11-24 01:46:30 Database page corruption detected at page 11, retrying...
2019-11-24 01:46:30 Error: failed to read page after 10 retries. File ./p_octt/b2b_mvno_comment.ibd seems to be corrupted.
Table isn't encrypted, problem started after import from old version of MySQL. We tried reimport table, but problem continue with another table...
I check mysqld.log and there is note, that user who run backup was failed connection:
2019-11-24 0:45:12 21 [Warning] Aborted connection 21 to db: 'unconnected' user: 'mybackup' host: 'localhost' (Got an error reading communication packets)
This error occurred for every ONLINE backup run