encryption.innodb-checksum-algorithm '8k,cbc,xtradb' w4 [ fail ]
|
Test ended at 2017-06-22 01:05:03
|
|
CURRENT_TEST: encryption.innodb-checksum-algorithm
|
mysqltest: At line 110: query 'ALTER TABLE t_$checksum DISCARD TABLESPACE' failed: 2013: Lost connection to MySQL server during query
|
|
The result from queries just before the failure was:
|
< snip >
|
restore: t_crc32 .ibd and .cfg files
|
restore: tpe_crc32 .ibd and .cfg files
|
restore: tp_crc32 .ibd and .cfg files
|
ALTER TABLE tce_crc32 IMPORT TABLESPACE;
|
update tce_crc32 set b=substr(b,1);
|
ALTER TABLE tc_crc32 IMPORT TABLESPACE;
|
update tc_crc32 set b=substr(b,1);
|
ALTER TABLE te_crc32 IMPORT TABLESPACE;
|
update te_crc32 set b=substr(b,1);
|
ALTER TABLE t_crc32 IMPORT TABLESPACE;
|
update t_crc32 set b=substr(b,1);
|
ALTER TABLE tpe_crc32 IMPORT TABLESPACE;
|
update tpe_crc32 set b=substr(b,1);
|
ALTER TABLE tp_crc32 IMPORT TABLESPACE;
|
update tp_crc32 set b=substr(b,1);
|
SET GLOBAL innodb_checksum_algorithm=crc32;
|
ALTER TABLE tce_crc32 DISCARD TABLESPACE;
|
ALTER TABLE tc_crc32 DISCARD TABLESPACE;
|
ALTER TABLE te_crc32 DISCARD TABLESPACE;
|
ALTER TABLE t_crc32 DISCARD TABLESPACE;
|
|
More results from queries before failure can be found in /mnt/buildbot/build/mariadb-10.1.25/mysql-test/var/4/log/innodb-checksum-algorithm.log
|
|
|
Server [mysqld.1 - pid: 30197, winpid: 30197, exit: 256] failed during test run
|
Server log from this test:
|
----------SERVER LOG START-----------
|
2017-06-22 1:05:00 3072244032 [Note] /mnt/buildbot/build/mariadb-10.1.25/sql/mysqld (mysqld 10.1.25-MariaDB-debug) starting as process 30198 ...
|
2017-06-22 1:05:00 3072244032 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4162)
|
2017-06-22 1:05:00 3072244032 [Note] Plugin 'SEQUENCE' is disabled.
|
2017-06-22 1:05:00 3072244032 [Note] Plugin 'partition' is disabled.
|
2017-06-22 1:05:00 3072244032 [Note] InnoDB: innodb-page-size has been changed from the default value 16384 to 8192 .
|
innodb_open_files should not be greater than the open_files_limit.
|
2017-06-22 1:05:00 3072244032 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
|
|
2017-06-22 1:05:00 3072244032 [Note] InnoDB: Using mutexes to ref count buffer pool pages
|
2017-06-22 1:05:00 3072244032 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
|
2017-06-22 1:05:00 3072244032 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!
|
2017-06-22 1:05:00 3072244032 [Note] InnoDB: The InnoDB memory heap is disabled
|
2017-06-22 1:05:00 3072244032 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2017-06-22 1:05:00 3072244032 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
|
2017-06-22 1:05:00 3072244032 [Note] InnoDB: Compressed tables use zlib 1.2.3.4
|
2017-06-22 1:05:00 3072244032 [Note] InnoDB: Using Linux native AIO
|
2017-06-22 1:05:00 3072244032 [Note] InnoDB: Using generic crc32 instructions
|
2017-06-22 1:05:00 3072244032 [Note] InnoDB: Initializing buffer pool, size = 8.0M
|
2017-06-22 1:05:00 3072244032 [Note] InnoDB: Completed initialization of buffer pool
|
2017-06-22 1:05:00 3072244032 [Note] InnoDB: Highest supported file format is Barracuda.
|
2017-06-22 1:05:01 3072244032 [Note] InnoDB: 128 rollback segment(s) are active.
|
2017-06-22 1:05:01 3072244032 [Note] InnoDB: Waiting for purge to start
|
2017-06-22 1:05:01 3072244032 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 934005
|
2017-06-22 1:05:01 2824854336 [Note] InnoDB: Dumping buffer pool(s) not yet started
|
2017-06-22 1:05:01 3072244032 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.
|
2017-06-22 1:05:01 3072244032 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
|
2017-06-22 1:05:01 3072244032 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled.
|
2017-06-22 1:05:01 3072244032 [Note] Plugin 'XTRADB_RSEG' is disabled.
|
2017-06-22 1:05:01 3072244032 [Note] Plugin 'CHANGED_PAGE_BITMAPS' is disabled.
|
2017-06-22 1:05:01 3072244032 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
|
2017-06-22 1:05:01 3072244032 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled.
|
2017-06-22 1:05:01 3072244032 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
|
2017-06-22 1:05:01 3072244032 [Note] Plugin 'XTRADB_INTERNAL_HASH_TABLES' is disabled.
|
2017-06-22 1:05:01 3072244032 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled.
|
2017-06-22 1:05:01 3072244032 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
|
2017-06-22 1:05:01 3072244032 [Note] Plugin 'FEEDBACK' is disabled.
|
2017-06-22 1:05:01 3072244032 [Note] Plugin 'INNODB_CMP' is disabled.
|
2017-06-22 1:05:01 3072244032 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
|
2017-06-22 1:05:01 3072244032 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
|
2017-06-22 1:05:01 3072244032 [Note] Plugin 'INNODB_MUTEXES' is disabled.
|
2017-06-22 1:05:01 3072244032 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
|
2017-06-22 1:05:01 3072244032 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
|
2017-06-22 1:05:01 3072244032 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
|
2017-06-22 1:05:01 3072244032 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled.
|
2017-06-22 1:05:01 3072244032 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
|
2017-06-22 1:05:01 3072244032 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
|
2017-06-22 1:05:01 3072244032 [Note] Plugin 'XTRADB_READ_VIEW' is disabled.
|
2017-06-22 1:05:01 3072244032 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled.
|
2017-06-22 1:05:01 3072244032 [Note] Plugin 'INNODB_CHANGED_PAGES' is disabled.
|
2017-06-22 1:05:01 3072244032 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
|
2017-06-22 1:05:01 3072244032 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled.
|
2017-06-22 1:05:01 3072244032 [Warning] /mnt/buildbot/build/mariadb-10.1.25/sql/mysqld: unknown option '--loose-pam-debug'
|
2017-06-22 1:05:01 3072244032 [Note] Server socket created on IP: '127.0.0.1'.
|
2017-06-22 1:05:01 3072244032 [Note] /mnt/buildbot/build/mariadb-10.1.25/sql/mysqld: ready for connections.
|
Version: '10.1.25-MariaDB-debug' socket: '/mnt/buildbot/build/mariadb-10.1.25/mysql-test/var/tmp/4/mysqld.1.sock' port: 16000 Source distribution
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Creating #1 thread id 2805988160 total threads 4.
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Creating #2 thread id 2797595456 total threads 4.
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Creating #3 thread id 2789202752 total threads 4.
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Creating #4 thread id 2780810048 total threads 4.
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Sync to disk of '"test"."tce_crc32"' started.
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Stopping purge
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Writing table metadata to './test/tce_crc32.cfg'
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Table '"test"."tce_crc32"' flushed to disk
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Sync to disk of '"test"."tc_crc32"' started.
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Writing table metadata to './test/tc_crc32.cfg'
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Table '"test"."tc_crc32"' flushed to disk
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Sync to disk of '"test"."te_crc32"' started.
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Writing table metadata to './test/te_crc32.cfg'
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Table '"test"."te_crc32"' flushed to disk
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Sync to disk of '"test"."t_crc32"' started.
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Writing table metadata to './test/t_crc32.cfg'
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Table '"test"."t_crc32"' flushed to disk
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Sync to disk of '"test"."tpe_crc32"' started.
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Writing table metadata to './test/tpe_crc32.cfg'
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Table '"test"."tpe_crc32"' flushed to disk
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Sync to disk of '"test"."tp_crc32"' started.
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Writing table metadata to './test/tp_crc32.cfg'
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Table '"test"."tp_crc32"' flushed to disk
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Deleting the meta-data file './test/tce_crc32.cfg'
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Deleting the meta-data file './test/tc_crc32.cfg'
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Deleting the meta-data file './test/te_crc32.cfg'
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Deleting the meta-data file './test/t_crc32.cfg'
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Deleting the meta-data file './test/tpe_crc32.cfg'
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Deleting the meta-data file './test/tp_crc32.cfg'
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Resuming purge
|
2017-06-22 1:05:01 2974498624 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=447] 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.
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Importing tablespace for table 'test/tce_crc32' that was exported from host 'ubuntu-precise-i386'
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Phase I - Update all pages
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Sync to disk
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Sync to disk - done!
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Phase III - Flush changes to disk
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Phase IV - Flush complete
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: "test"."tce_crc32" autoinc value set to 2
|
2017-06-22 1:05:01 2789202752 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=13] 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.
|
2017-06-22 1:05:01 2805988160 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=61] 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.
|
2017-06-22 1:05:01 2797595456 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=421] 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.
|
2017-06-22 1:05:01 2780810048 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=395] 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.
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Importing tablespace for table 'test/tc_crc32' that was exported from host 'ubuntu-precise-i386'
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Phase I - Update all pages
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Sync to disk
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Sync to disk - done!
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Phase III - Flush changes to disk
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Phase IV - Flush complete
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: "test"."tc_crc32" autoinc value set to 2
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Importing tablespace for table 'test/te_crc32' that was exported from host 'ubuntu-precise-i386'
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Phase I - Update all pages
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Sync to disk
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Sync to disk - done!
|
2017-06-22 1:05:01 2789202752 [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.
|
2017-06-22 1:05:01 2805988160 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=62] 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.
|
2017-06-22 1:05:01 2797595456 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=466] 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.
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Phase III - Flush changes to disk
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Phase IV - Flush complete
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: "test"."te_crc32" autoinc value set to 2
|
2017-06-22 1:05:01 2789202752 [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.
|
2017-06-22 1:05:01 2805988160 [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.
|
2017-06-22 1:05:01 2797595456 [Warning] InnoDB: innodb_checksum_algorithm is set to "strict_crc32" but the page [page id: space=0, page number=469] 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.
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Importing tablespace for table 'test/t_crc32' that was exported from host 'ubuntu-precise-i386'
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Phase I - Update all pages
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Sync to disk
|
2017-06-22 1:05:01 2974498624 [Note] InnoDB: Sync to disk - done!
|
2017-06-22 1:05:02 2789202752 [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.
|
2017-06-22 1:05:02 2805988160 [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.
|
2017-06-22 1:05:02 2974498624 [Note] InnoDB: Phase III - Flush changes to disk
|
2017-06-22 1:05:02 2974498624 [Note] InnoDB: Phase IV - Flush complete
|
2017-06-22 1:05:02 2974498624 [Note] InnoDB: "test"."t_crc32" autoinc value set to 2
|
2017-06-22 1:05:02 2974498624 [Note] InnoDB: Importing tablespace for table 'test/tpe_crc32' that was exported from host 'ubuntu-precise-i386'
|
2017-06-22 1:05:02 2974498624 [Note] InnoDB: Phase I - Update all pages
|
2017-06-22 1:05:02 2974498624 [Note] InnoDB: Sync to disk
|
2017-06-22 1:05:02 2974498624 [Note] InnoDB: Sync to disk - done!
|
2017-06-22 1:05:02 2789202752 [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.
|
2017-06-22 1:05:02 2805988160 [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.
|
2017-06-22 1:05:02 2974498624 [Note] InnoDB: Phase III - Flush changes to disk
|
2017-06-22 1:05:02 2974498624 [Note] InnoDB: Phase IV - Flush complete
|
2017-06-22 1:05:02 2974498624 [Note] InnoDB: "test"."tpe_crc32" autoinc value set to 2
|
2017-06-22 1:05:02 2974498624 [Note] InnoDB: Importing tablespace for table 'test/tp_crc32' that was exported from host 'ubuntu-precise-i386'
|
2017-06-22 1:05:02 2974498624 [Note] InnoDB: Phase I - Update all pages
|
2017-06-22 1:05:02 2974498624 [Note] InnoDB: Sync to disk
|
2017-06-22 1:05:02 2974498624 [Note] InnoDB: Sync to disk - done!
|
2017-06-22 1:05:02 2789202752 [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.
|
2017-06-22 1:05:02 2805988160 [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.
|
2017-06-22 1:05:02 2974498624 [Note] InnoDB: Phase III - Flush changes to disk
|
2017-06-22 1:05:02 2974498624 [Note] InnoDB: Phase IV - Flush complete
|
2017-06-22 1:05:02 2974498624 [Note] InnoDB: "test"."tp_crc32" autoinc value set to 2
|