[MDEV-16896] encryption.innodb-checksum-algorithm failed in buildbot, apparently server crashed - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
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
Component/s: Storage Engine - InnoDB, Tests
Labels:
None

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

Attachments

Issue Links

is caused by

MDEV-17957 Make Innodb_checksum_algorithm stricter for strict_* values

Closed

relates to

MDEV-22027 Assertion oldest_lsn >= log_sys.last_checkpoint_lsn failed in log_checkpoint()

Closed

Activity

People

Assignee:: Marko Mäkelä

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2018-08-03 22:51

Updated:: 2020-03-24 16:24

Resolved:: 2019-02-03 15:34