Was just hovering around this bug and thought of trying it.
I couldn't get any of the TC to crash PS-5.6 server.
Interesting fact is
mysql> USE test;
mysql> SET GLOBAL innodb_checksum_algorithm=strict_crc32;
mysql> CREATE TABLE t (f INT) ENGINE=InnoDB;
generates following warning:
Version: '5.6.26-73.2-debug' socket: '/opt/projects/codebase/installed/5.6/mysql.sock' port: 29993 Source distribution
2015-09-21 10:33:45 7718 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=9] contains a valid checksum "innodb". Accepting the page as valid. C
hange innodb_checksum_algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
................
Seems like the issue is fixed by the bug that is addressed below.
As per the commit message mis-matching checksum use to crash the server before.
Was just hovering around this bug and thought of trying it.
I couldn't get any of the TC to crash PS-5.6 server.
Interesting fact is
mysql> USE test; checksum_ algorithm= strict_ crc32;
mysql> SET GLOBAL innodb_
mysql> CREATE TABLE t (f INT) ENGINE=InnoDB;
generates following warning:
Version: '5.6.26-73.2-debug' socket: '/opt/projects/ codebase/ installed/ 5.6/mysql. sock' port: 29993 Source distribution checksum_ algorithm is set to "strict_crc32" but the page [page id: space=0, page number=9] contains a valid checksum "innodb". Accepting the page as valid. C checksum_ algorithm to "crc32" to silently accept such pages or rewrite all pages so that they contain "crc32" checksum.
2015-09-21 10:33:45 7718 [Warning] InnoDB: innodb_
hange innodb_
................
Seems like the issue is fixed by the bug that is addressed below.
As per the commit message mis-matching checksum use to crash the server before.
commit 0bf409d175fe674 e73c92492a68af9 dd69278377
Author: Thirunarayanan Balathandayuthapani <email address hidden>
Date: Wed Apr 8 13:38:21 2015 +0530
Fix Bug#20568464 MITIGATE THE STRICTNESS OF STRICT_* MODES
OF INNODB_ CHECKSUM_ ALGORITHM