Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.19
-
None
-
Debian Linux 3.10.0 x86_64
Description
The following messages appears in syslog about once in an hour:
Dec 20 15:54:33 www mysqld: 2016-12-20 15:54:33 140047920658176 [Note] InnoDB: Log sequence number at the start 759654123 and the end 0 do not match.
Dec 20 15:54:33 www mysqld: 2016-12-20 15:54:33 140047920658176 [Note] InnoDB: Log sequence number at the start 759654123 and the end 0 do not match.
Dec 20 15:54:33 www mysqld: 2016-12-20 15:54:33 140047920658176 [Note] InnoDB: Log sequence number at the start 2785176653 and the end 0 do not match.
Dec 20 15:54:33 www mysqld: 2016-12-20 15:54:33 140047920658176 [Note] InnoDB: Log sequence number at the start 735407746 and the end 0 do not match.
Dec 20 15:54:33 www mysqld: 2016-12-20 15:54:33 140047920658176 [Note] InnoDB: Log sequence number at the start 1336596246 and the end 0 do not match.
Dec 20 15:54:33 www mysqld: 2016-12-20 15:54:33 140047920658176 [Note] InnoDB: Log sequence number at the start 3570592028 and the end 0 do not match.
Scenario is unknown.
Please let me know whether it's a bug or configuration issue.
It looks like the error appears on simple SELECT all records request from InnoDB `page_compressed`=1 table with the following structure:
This table contains 37k of records. It has been created earlier in MySQL 5.1, upgraded to MariaDB and altered to page compressed version. Current data length = 23Mb, index length 0, data free 4Mb, avg row length 704, row format dynamic, version 10.