[MDEV-16896] encryption.innodb-checksum-algorithm failed in buildbot, apparently server crashed Created: 2018-08-03  Updated: 2020-03-24  Resolved: 2019-02-03

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB, Tests
Affects Version/s: 10.4.1, 10.0.38, 10.2.20, 10.3.12
Fix Version/s: 10.4.3, 10.1.38, 10.2.22, 10.3.13

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Marko Mäkelä
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
is caused by MDEV-17957 Make Innodb_checksum_algorithm strict... Closed
Relates
relates to MDEV-22027 Assertion oldest_lsn >= log_sys.last_... Closed

 Description   

Log is not available anymore, and due to all spam that InnoDB writes into the error log, the actual failure didn't fit into the buildbot database, see below.

encryption.innodb-checksum-algorithm '4k,cbc,xtradb' w3 [ fail ]
 
        Test ended at 2018-06-20 16:05:54
 
 
 
CURRENT_TEST: encryption.innodb-checksum-algorithm
 
mysqltest: At line 116: query 'ALTER TABLE tce_$checksum IMPORT TABLESPACE' failed: 2013: Lost connection to MySQL server during query
 
 
 
The result from queries just before the failure was:
 
< snip >
 
ALTER TABLE t_innodb IMPORT TABLESPACE;
 
update t_innodb set b=substr(b,1);
 
ALTER TABLE tpe_innodb IMPORT TABLESPACE;
 
update tpe_innodb set b=substr(b,1);
 
ALTER TABLE tp_innodb IMPORT TABLESPACE;
 
update tp_innodb set b=substr(b,1);
 
SET GLOBAL innodb_checksum_algorithm=strict_none;
 
ALTER TABLE tce_innodb DISCARD TABLESPACE;
 
ALTER TABLE tc_innodb DISCARD TABLESPACE;
 
ALTER TABLE te_innodb DISCARD TABLESPACE;
 
ALTER TABLE t_innodb DISCARD TABLESPACE;
 
ALTER TABLE tpe_innodb DISCARD TABLESPACE;
 
ALTER TABLE tp_innodb DISCARD TABLESPACE;
 
restore: tce_innodb .ibd and .cfg files
 
restore: tc_innodb .ibd and .cfg files
 
restore: te_innodb .ibd and .cfg files
 
restore: t_innodb .ibd and .cfg files
 
restore: tpe_innodb .ibd and .cfg files
 
restore: tp_innodb .ibd and .cfg files
 
ALTER TABLE tce_innodb IMPORT TABLESPACE;
 
 
 
More results from queries before failure can be found in /usr/local/mariadb-10.1.35-linux-i686/mysql-test/var/3/log/innodb-checksum-algorithm.log
 
 
 
 
 
Server [mysqld.1 - pid: 26716, winpid: 26716, exit: 256] failed during test run
 
Server log from this test:
 
----------SERVER LOG START-----------
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Creating #1 encryption thread id 2701130560 total threads 4.
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Creating #2 encryption thread id 2692737856 total threads 4.
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Creating #3 encryption thread id 2684345152 total threads 4.
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Creating #4 encryption thread id 2675952448 total threads 4.
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Sync to disk of '"test"."tce_crc32"' started.
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Stopping purge
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Writing table metadata to './test/tce_crc32.cfg'
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Table '"test"."tce_crc32"' flushed to disk
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Sync to disk of '"test"."tc_crc32"' started.
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Writing table metadata to './test/tc_crc32.cfg'
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Table '"test"."tc_crc32"' flushed to disk
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Sync to disk of '"test"."te_crc32"' started.
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Writing table metadata to './test/te_crc32.cfg'
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Table '"test"."te_crc32"' flushed to disk
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Sync to disk of '"test"."t_crc32"' started.
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Writing table metadata to './test/t_crc32.cfg'
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Table '"test"."t_crc32"' flushed to disk
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Sync to disk of '"test"."tpe_crc32"' started.
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Writing table metadata to './test/tpe_crc32.cfg'
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Table '"test"."tpe_crc32"' flushed to disk
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Sync to disk of '"test"."tp_crc32"' started.
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Writing table metadata to './test/tp_crc32.cfg'
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Table '"test"."tp_crc32"' flushed to disk
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Deleting the meta-data file './test/tce_crc32.cfg'
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Deleting the meta-data file './test/tc_crc32.cfg'
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Deleting the meta-data file './test/te_crc32.cfg'
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Deleting the meta-data file './test/t_crc32.cfg'
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Deleting the meta-data file './test/tpe_crc32.cfg'
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Deleting the meta-data file './test/tp_crc32.cfg'
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Resuming purge
 
2018-06-20 16:05:48 2692737856 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=14] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:48 2675952448 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=123] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:48 2684345152 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=63] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:48 2701130560 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=197] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:48 2701130560 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=205] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:48 2692737856 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=15] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:48 2675952448 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=124] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:48 2684345152 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=64] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Importing tablespace for table 'test/tce_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: "test"."tce_crc32" autoinc value set to 2
 
2018-06-20 16:05:48 2701130560 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=213] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:48 2684345152 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=65] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:48 2675952448 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=125] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:48 2692737856 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=16] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:48 2701130560 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=221] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:48 2692737856 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=17] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:48 2675952448 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=126] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:48 2684345152 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=66] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:48 2701130560 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=229] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Importing tablespace for table 'test/tc_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:48 2684345152 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=67] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:48 2692737856 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=18] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:48 2675952448 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=127] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: "test"."tc_crc32" autoinc value set to 2
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Importing tablespace for table 'test/te_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: "test"."te_crc32" autoinc value set to 2
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Importing tablespace for table 'test/t_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:48 2701130560 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=237] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: "test"."t_crc32" autoinc value set to 2
 
2018-06-20 16:05:48 2684345152 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=68] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:48 2675952448 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=128] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:48 2692737856 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=19] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Importing tablespace for table 'test/tpe_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: "test"."tpe_crc32" autoinc value set to 2
 
2018-06-20 16:05:48 2701130560 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=245] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:48 2692737856 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=20] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:48 2684345152 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=69] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:48 2675952448 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=129] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Importing tablespace for table 'test/tp_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:48 2701130560 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=253] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: "test"."tp_crc32" autoinc value set to 2
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Importing tablespace for table 'test/tce_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: "test"."tce_crc32" autoinc value set to 2
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Importing tablespace for table 'test/tc_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: "test"."tc_crc32" autoinc value set to 2
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Importing tablespace for table 'test/te_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:48 2965061440 [Note] InnoDB: "test"."te_crc32" autoinc value set to 2
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Importing tablespace for table 'test/t_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: "test"."t_crc32" autoinc value set to 2
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Importing tablespace for table 'test/tpe_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: "test"."tpe_crc32" autoinc value set to 2
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Importing tablespace for table 'test/tp_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: "test"."tp_crc32" autoinc value set to 2
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Importing tablespace for table 'test/tce_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=10, page number=0] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=10, page number=1] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=10, page number=2] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=10, page number=3] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=10, page number=3] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=10, page number=4] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=10, page number=4] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=10, page number=5] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=10, page number=0] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=10, page number=0] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=10, page number=0] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: "test"."tce_crc32" autoinc value set to 2
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Importing tablespace for table 'test/tc_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=11, page number=0] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=11, page number=1] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=11, page number=2] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=11, page number=3] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=11, page number=3] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=11, page number=4] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=11, page number=4] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=11, page number=5] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: "test"."tc_crc32" autoinc value set to 2
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Importing tablespace for table 'test/te_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=12, page number=0] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=12, page number=1] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=12, page number=2] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=12, page number=3] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=12, page number=4] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: "test"."te_crc32" autoinc value set to 2
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Importing tablespace for table 'test/t_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=13, page number=0] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=13, page number=1] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=13, page number=2] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=13, page number=3] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=13, page number=4] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: "test"."t_crc32" autoinc value set to 2
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Importing tablespace for table 'test/tpe_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=14, page number=0] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: "test"."tpe_crc32" autoinc value set to 2
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Importing tablespace for table 'test/tp_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_innodb" but the page [page id: space=15, page number=0] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "innodb" to silently accept such pages or rewrite all pages so that they contain "innodb" checksum.
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: "test"."tp_crc32" autoinc value set to 2
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Importing tablespace for table 'test/tce_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: "test"."tce_crc32" autoinc value set to 2
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Importing tablespace for table 'test/tc_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: "test"."tc_crc32" autoinc value set to 2
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Importing tablespace for table 'test/te_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: "test"."te_crc32" autoinc value set to 2
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Importing tablespace for table 'test/t_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: "test"."t_crc32" autoinc value set to 2
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Importing tablespace for table 'test/tpe_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: "test"."tpe_crc32" autoinc value set to 2
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Importing tablespace for table 'test/tp_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: "test"."tp_crc32" autoinc value set to 2
 
2018-06-20 16:05:49 2684345152 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=0, page number=85] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2692737856 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=0, page number=37] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2675952448 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=0, page number=165] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Importing tablespace for table 'test/tce_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=10, page number=0] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=10, page number=1] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=10, page number=2] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=10, page number=3] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=10, page number=3] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=10, page number=4] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=10, page number=4] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=10, page number=5] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=10, page number=0] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=10, page number=0] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=10, page number=0] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: "test"."tce_crc32" autoinc value set to 2
 
2018-06-20 16:05:49 2684345152 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=0, page number=86] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Importing tablespace for table 'test/tc_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=11, page number=0] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=11, page number=1] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=11, page number=2] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=11, page number=3] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=11, page number=3] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=11, page number=4] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=11, page number=4] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=11, page number=5] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: "test"."tc_crc32" autoinc value set to 2
 
2018-06-20 16:05:49 2692737856 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=0, page number=38] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Importing tablespace for table 'test/te_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=12, page number=0] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=12, page number=1] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=12, page number=2] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=12, page number=3] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=12, page number=4] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:49 2684345152 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=0, page number=87] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2675952448 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=0, page number=173] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: "test"."te_crc32" autoinc value set to 2
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Importing tablespace for table 'test/t_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=13, page number=0] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=13, page number=1] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=13, page number=2] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=13, page number=3] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=13, page number=4] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: "test"."t_crc32" autoinc value set to 2
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Importing tablespace for table 'test/tpe_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=14, page number=0] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: "test"."tpe_crc32" autoinc value set to 2
 
2018-06-20 16:05:49 2692737856 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=0, page number=39] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Importing tablespace for table 'test/tp_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:49 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=15, page number=0] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2684345152 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=0, page number=88] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: "test"."tp_crc32" autoinc value set to 2
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Importing tablespace for table 'test/tce_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: "test"."tce_crc32" autoinc value set to 2
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Importing tablespace for table 'test/tc_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: "test"."tc_crc32" autoinc value set to 2
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Importing tablespace for table 'test/te_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: "test"."te_crc32" autoinc value set to 2
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Importing tablespace for table 'test/t_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: "test"."t_crc32" autoinc value set to 2
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Importing tablespace for table 'test/tpe_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: "test"."tpe_crc32" autoinc value set to 2
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Importing tablespace for table 'test/tp_crc32' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk - done!
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase III - Flush changes to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Phase IV - Flush complete
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: "test"."tp_crc32" autoinc value set to 2
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk of '"test"."tce_innodb"' started.
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Stopping purge
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Writing table metadata to './test/tce_innodb.cfg'
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Table '"test"."tce_innodb"' flushed to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk of '"test"."tc_innodb"' started.
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Writing table metadata to './test/tc_innodb.cfg'
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Table '"test"."tc_innodb"' flushed to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk of '"test"."te_innodb"' started.
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Writing table metadata to './test/te_innodb.cfg'
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Table '"test"."te_innodb"' flushed to disk
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Sync to disk of '"test"."t_innodb"' started.
 
2018-06-20 16:05:49 2965061440 [Note] InnoDB: Writing table metadata to './test/t_innodb.cfg'
 
2018-06-20 16:05:50 2965061440 [Note] InnoDB: Table '"test"."t_innodb"' flushed to disk
 
2018-06-20 16:05:50 2965061440 [Note] InnoDB: Sync to disk of '"test"."tpe_innodb"' started.
 
2018-06-20 16:05:50 2965061440 [Note] InnoDB: Writing table metadata to './test/tpe_innodb.cfg'
 
2018-06-20 16:05:50 2965061440 [Note] InnoDB: Table '"test"."tpe_innodb"' flushed to disk
 
2018-06-20 16:05:50 2965061440 [Note] InnoDB: Sync to disk of '"test"."tp_innodb"' started.
 
2018-06-20 16:05:50 2965061440 [Note] InnoDB: Writing table metadata to './test/tp_innodb.cfg'
 
2018-06-20 16:05:50 2965061440 [Note] InnoDB: Table '"test"."tp_innodb"' flushed to disk
 
2018-06-20 16:05:50 2965061440 [Note] InnoDB: Deleting the meta-data file './test/tce_innodb.cfg'
 
2018-06-20 16:05:50 2965061440 [Note] InnoDB: Deleting the meta-data file './test/tc_innodb.cfg'
 
2018-06-20 16:05:50 2965061440 [Note] InnoDB: Deleting the meta-data file './test/te_innodb.cfg'
 
2018-06-20 16:05:50 2965061440 [Note] InnoDB: Deleting the meta-data file './test/t_innodb.cfg'
 
2018-06-20 16:05:50 2965061440 [Note] InnoDB: Deleting the meta-data file './test/tpe_innodb.cfg'
 
2018-06-20 16:05:50 2965061440 [Note] InnoDB: Deleting the meta-data file './test/tp_innodb.cfg'
 
2018-06-20 16:05:50 2965061440 [Note] InnoDB: Resuming purge
 
2018-06-20 16:05:50 2692737856 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=45] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:50 2684345152 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=94] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:50 2965061440 [Note] InnoDB: Importing tablespace for table 'test/tce_innodb' that was exported from host 'ubuntu-trusty-i386'
 
2018-06-20 16:05:50 2965061440 [Note] InnoDB: Phase I - Update all pages
 
2018-06-20 16:05:50 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=16, page number=0] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:50 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=16, page number=1] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:50 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=16, page number=2] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:50 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=16, page number=3] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:50 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=16, page number=3] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:50 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=16, page number=4] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:50 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=16, page number=4] contains a valid checksum "innodb". Accepting the page as valid. Change innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
 
2018-06-20 16:05:50 2965061440 [Warning] InnoDB: innodb_checksum_algorithm is set



 Comments   
Comment by Marko Mäkelä [ 2019-02-03 ]

I think that this affects later versions than 10.1 as well. The problem appears to be a race condition in the function buf_page_is_corrupted(). The function is assuming that the value of the variable srv_checksum_algroithm cannot change during the execution. It is copying the global variable to a local variable, but in some cases, it is re-reading the global variable instead of referring to the local variable.

Here is an example failure from a 10.2-based branch.

10.2

 
CURRENT_TEST: encryption.innodb-checksum-algorithm
 
mysqltest: At line 111: query 'ALTER TABLE tpe_$checksum IMPORT TABLESPACE' failed: 2013: Lost connection to MySQL server during query
 
…
 
2019-02-02 10:59:36 2952182592 [Note] InnoDB: Phase IV - Flush complete
 
2019-02-02 10:59:36 2952182592 [Note] InnoDB: `test`.`tp_crc32` autoinc value set to 2
 
mysqld: /home/buildbot/buildbot/build/mariadb-10.2.22/storage/innobase/buf/buf0buf.cc:1159: bool buf_page_is_corrupted(bool, const byte*, const page_size_t&, const fil_space_t*): Assertion `srv_checksum_algorithm == SRV_CHECKSUM_ALGORITHM_INNODB' failed.

Comment by Marko Mäkelä [ 2019-02-03 ]

This appears to be a regression that was introduced in MDEV-17957. Before that fix, the function buf_page_is_corrupted() would read the global variable srv_checksum_algorithm only twice.

Before MDEV-17957, it should be possible to get InnoDB or XtraDB to crash by alternating between SET GLOBAL innodb_checksum_algorithm=none and one of innodb or crc32. The MDEV-17957 fix introduced more possibilities for crashing (debug assertions).

Comment by Marko Mäkelä [ 2019-02-03 ]

No release in the 10.1 series was affected, because there had been no 10.1 release between MDEV-17957 and this fix.

Generated at Thu Feb 08 08:32:22 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.