Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4.1, 10.0.38, 10.2.20, 10.3.12
-
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
-
-
- Closed
-
- relates to
-
-
- Closed
-
Activity
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).
No release in the 10.1 series was affected, because there had been no 10.1 release between MDEV-17957 and this fix.
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-algorithmmysqltest: 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 complete2019-02-02 10:59:36 2952182592 [Note] InnoDB: `test`.`tp_crc32` autoinc value set to 2mysqld: /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.