[MDEV-10099] encryption.innodb_onlinealter_encryption fails sporadically in buildbot Created: 2016-05-22  Updated: 2017-05-10  Resolved: 2017-05-10

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB, Storage Engine - XtraDB, Tests
Affects Version/s: 10.1, 10.2
Fix Version/s: 10.1.23, 10.2.6

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
blocks MDEV-7069 Fix buildbot failures in main server ... Stalled

 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-precise-amd64/builds/6276/steps/test_5/logs/stdio

encryption.innodb_onlinealter_encryption 'innodb_plugin' w4 [ fail ]
 
        Test ended at 2016-05-21 17:42:36
 
 
 
CURRENT_TEST: encryption.innodb_onlinealter_encryption
 
--- /usr/share/mysql/mysql-test/suite/encryption/r/innodb_onlinealter_encryption.result	2016-05-21 15:55:56.000000000 +0300
 
+++ /run/shm/var/4/log/innodb_onlinealter_encryption.reject	2016-05-21 17:42:36.487743604 +0300
 
@@ -124,7 +124,7 @@
 
 # t1 yes on expecting NOT FOUND
 
 NOT FOUND /foobar/ in t1.ibd
 
 # t2 ... on expecting NOT FOUND
 
-NOT FOUND /temp/ in t2.ibd
 
+FOUND /temp/ in t2.ibd
 
 # t3 ... on expecting NOT FOUND
 
 NOT FOUND /barfoo/ in t3.ibd
 
 # t4 ... on expecting NOT FOUND
 
@@ -161,7 +161,7 @@
 
 # t1 yes on expecting NOT FOUND
 
 NOT FOUND /foobar/ in t1.ibd
 
 # t2 ... on expecting NOT FOUND
 
-NOT FOUND /temp/ in t2.ibd
 
+FOUND /temp/ in t2.ibd
 
 # t3 ... on expecting NOT FOUND
 
 NOT FOUND /barfoo/ in t3.ibd
 
 # t4 ... on expecting NOT FOUND
 
 
 
mysqltest: Result length mismatch



 Comments   
Comment by Sergey Vojtovich [ 2016-11-17 ]

Another crashing failure: http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-centos5-amd64/builds/4009/steps/test/logs/stdio

encryption.innodb_onlinealter_encryption 'xtradb' w3 [ fail ]
 
        Test ended at 2016-11-17 04:10:48
 
 
 
CURRENT_TEST: encryption.innodb_onlinealter_encryption
 
mysqltest: At line 99: query 'ALTER TABLE t3 ADD KEY (a), ADD KEY c(c)' failed: 2013: Lost connection to MySQL server during query
 
 
 
The result from queries just before the failure was:
 
< snip >
 
# t2 ... on expecting NOT FOUND
 
NOT FOUND /temp/ in t2.ibd
 
# t3 ... on expecting NOT FOUND
 
NOT FOUND /barfoo/ in t3.ibd
 
# t4 ... on expecting NOT FOUND
 
NOT FOUND /repeat/ in t4.ibd
 
# t5 ... on expecting NOT FOUND
 
NOT FOUND /author/ in t5.ibd
 
# t6 ... on expecting NOT FOUND
 
NOT FOUND /mangled/ in t6.ibd
 
# t7 ... on expecting NOT FOUND
 
NOT FOUND /mysql/ in t7.ibd
 
ALTER TABLE t1 ADD COLUMN b int default 2;
 
ALTER TABLE t2 ADD COLUMN b int default 2;
 
ALTER TABLE t7 ADD COLUMN b int default 2;
 
ALTER TABLE t1 ADD KEY a(a), ADD KEY b(b);
 
ALTER TABLE t2 ADD KEY a(a), ADD KEY b(b);
 
ALTER TABLE t3 ADD COLUMN c int default 5;
 
ALTER TABLE t4 ADD COLUMN c int default 5;
 
ALTER TABLE t3 ADD KEY (a), ADD KEY c(c);
 
 
 
More results from queries before failure can be found in /usr/local/mariadb-10.2.3-linux-x86_64/mysql-test/var/3/log/innodb_onlinealter_encryption.log
 
 
 
 
 
Server [mysqld.1 - pid: 569, winpid: 569, exit: 256] failed during test run
 
Server log from this test:
 
----------SERVER LOG START-----------
 
2016-11-17  4:10:28 1352082752 [Note] InnoDB: Tablespace ID 9 name test/t1:Tablespace encrypted scheme encrypted
 
2016-11-17  4:10:28 1352082752 [Note] InnoDB: Tablespace ID 10 name test/t2:Default tablespace encryption mode scheme encrypted
 
2016-11-17  4:10:28 1352082752 [Note] InnoDB: Tablespace ID 11 name test/t3:Tablespace encrypted scheme encrypted
 
2016-11-17  4:10:28 1352082752 [Note] InnoDB: Tablespace ID 12 name test/t4:Default tablespace encryption mode scheme encrypted
 
2016-11-17  4:10:28 1352082752 [Note] InnoDB: Tablespace ID 13 name test/t5:Tablespace encrypted scheme encrypted
 
2016-11-17  4:10:28 1352082752 [Note] InnoDB: Tablespace ID 14 name test/FTS_000000000000001a_BEING_DELETED:Default tablespace encryption mode scheme encrypted
 
2016-11-17  4:10:28 1352082752 [Note] InnoDB: Tablespace ID 15 name test/FTS_000000000000001a_BEING_DELETED_CACHE:Default tablespace encryption mode scheme encrypted
 
2016-11-17  4:10:28 1352082752 [Note] InnoDB: Tablespace ID 16 name test/FTS_000000000000001a_CONFIG:Default tablespace encryption mode scheme encrypted
 
2016-11-17  4:10:28 1352082752 [Note] InnoDB: Tablespace ID 17 name test/FTS_000000000000001a_DELETED:Default tablespace encryption mode scheme encrypted
 
2016-11-17  4:10:28 1352082752 [Note] InnoDB: Tablespace ID 18 name test/FTS_000000000000001a_DELETED_CACHE:Default tablespace encryption mode scheme encrypted
 
2016-11-17  4:10:28 1352082752 [Note] InnoDB: Tablespace ID 19 name test/FTS_000000000000001a_0000000000000023_INDEX_1:Default tablespace encryption mode scheme encrypted
 
2016-11-17  4:10:28 1352082752 [Note] InnoDB: Tablespace ID 20 name test/FTS_000000000000001a_0000000000000023_INDEX_2:Default tablespace encryption mode scheme encrypted
 
2016-11-17  4:10:28 1352082752 [Note] InnoDB: Tablespace ID 21 name test/FTS_000000000000001a_0000000000000023_INDEX_3:Default tablespace encryption mode scheme encrypted
 
2016-11-17  4:10:28 1352082752 [Note] InnoDB: Tablespace ID 22 name test/FTS_000000000000001a_0000000000000023_INDEX_4:Default tablespace encryption mode scheme encrypted
 
2016-11-17  4:10:28 1352082752 [Note] InnoDB: Tablespace ID 23 name test/FTS_000000000000001a_0000000000000023_INDEX_5:Default tablespace encryption mode scheme encrypted
 
2016-11-17  4:10:28 1352082752 [Note] InnoDB: Tablespace ID 24 name test/FTS_000000000000001a_0000000000000023_INDEX_6:Default tablespace encryption mode scheme encrypted
 
2016-11-17  4:10:28 1352082752 [Note] InnoDB: Tablespace ID 25 name test/t6:Default tablespace encryption mode scheme encrypted
 
2016-11-17  4:10:28 1352082752 [Note] InnoDB: Tablespace ID 26 name test/FTS_0000000000000026_BEING_DELETED:Default tablespace encryption mode scheme encrypted
 
2016-11-17  4:10:28 1352082752 [Note] InnoDB: Tablespace ID 27 name test/FTS_0000000000000026_BEING_DELETED_CACHE:Default tablespace encryption mode scheme encrypted
 
2016-11-17  4:10:28 1352082752 [Note] InnoDB: Tablespace ID 28 name test/FTS_0000000000000026_CONFIG:Default tablespace encryption mode scheme encrypted
 
2016-11-17  4:10:28 1352082752 [Note] InnoDB: Tablespace ID 29 name test/FTS_0000000000000026_DELETED:Default tablespace encryption mode scheme encrypted
 
2016-11-17  4:10:28 1352082752 [Note] InnoDB: Tablespace ID 30 name test/FTS_0000000000000026_DELETED_CACHE:Default tablespace encryption mode scheme encrypted
 
2016-11-17  4:10:28 1352082752 [Note] InnoDB: Tablespace ID 31 name test/FTS_0000000000000026_0000000000000031_INDEX_1:Default tablespace encryption mode scheme encrypted
 
2016-11-17  4:10:28 1352082752 [Note] InnoDB: Tablespace ID 32 name test/FTS_0000000000000026_0000000000000031_INDEX_2:Default tablespace encryption mode scheme encrypted
 
2016-11-17  4:10:28 1352082752 [Note] InnoDB: Tablespace ID 33 name test/FTS_0000000000000026_0000000000000031_INDEX_3:Default tablespace encryption mode scheme encrypted
 
2016-11-17  4:10:28 1352082752 [Note] InnoDB: Tablespace ID 34 name test/FTS_0000000000000026_0000000000000031_INDEX_4:Default tablespace encryption mode scheme encrypted
 
2016-11-17  4:10:28 1352082752 [Note] InnoDB: Tablespace ID 35 name test/FTS_0000000000000026_0000000000000031_INDEX_5:Default tablespace encryption mode scheme encrypted
 
2016-11-17  4:10:28 1352082752 [Note] InnoDB: Tablespace ID 36 name test/FTS_0000000000000026_0000000000000031_INDEX_6:Default tablespace encryption mode scheme encrypted
 
2016-11-17  4:10:28 1352082752 [Note] InnoDB: Tablespace ID 37 name test/t7:Tablespace encrypted scheme encrypted
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Tablespace ID 38 name test/#sql-ib22-3083451434:Tablespace encrypted scheme encrypted
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : Start
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : End of reading clustered index of the table and create temporary files
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : Completed
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Tablespace ID 39 name test/#sql-ib23-3083451436:Default tablespace encryption mode scheme encrypted
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : Start
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : End of reading clustered index of the table and create temporary files
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : Completed
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Tablespace ID 40 name test/#sql-ib50-3083451438:Tablespace encrypted scheme encrypted
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : Start
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : End of reading clustered index of the table and create temporary files
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : Completed
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : Start
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : End of reading clustered index of the table and create temporary files
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : Start merge-sorting index `a` (1 / 2), estimated cost : 20.0000
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : merge-sorting has estimated 4 runs
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : End of  merge-sorting index `a` (1 / 2)
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : Start building index `a` (1 / 2), estimated cost : 30.0000
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : End of building index `a` (1 / 2)
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : Start applying row log
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : End of applying row log
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : Completed
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : Start applying row log
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : End of applying row log
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : Completed
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : Start
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : End of reading clustered index of the table and create temporary files
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : Start merge-sorting index `a` (1 / 2), estimated cost : 20.0000
 
2016-11-17  4:10:47 1352082752 [Note] InnoDB: Online DDL : merge-sorting has estimated 3 runs
 
2016-11-17  4:10:48 1352082752 [Note] InnoDB: Online DDL : End of  merge-sorting index `a` (1 / 2)
 
2016-11-17  4:10:48 1352082752 [Note] InnoDB: Online DDL : Start building index `a` (1 / 2), estimated cost : 30.0000
 
2016-11-17  4:10:48 1352082752 [Note] InnoDB: Online DDL : End of building index `a` (1 / 2)
 
2016-11-17  4:10:48 1352082752 [Note] InnoDB: Online DDL : Start applying row log
 
2016-11-17  4:10:48 1352082752 [Note] InnoDB: Online DDL : End of applying row log
 
2016-11-17  4:10:48 1352082752 [Note] InnoDB: Online DDL : Completed
 
2016-11-17  4:10:48 1352082752 [Note] InnoDB: Online DDL : Start applying row log
 
2016-11-17  4:10:48 1352082752 [Note] InnoDB: Online DDL : End of applying row log
 
2016-11-17  4:10:48 1352082752 [Note] InnoDB: Online DDL : Completed
 
2016-11-17  4:10:48 1352082752 [Note] InnoDB: Tablespace ID 41 name test/#sql-ib24-3083451440:Tablespace encrypted scheme encrypted
 
2016-11-17  4:10:48 1352082752 [Note] InnoDB: Online DDL : Start
 
2016-11-17  4:10:48 1352082752 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files
 
2016-11-17  4:10:48 1352082752 [Note] InnoDB: Online DDL : End of reading clustered index of the table and create temporary files
 
2016-11-17  4:10:48 1352082752 [Note] InnoDB: Online DDL : Completed
 
2016-11-17  4:10:48 1352082752 [Note] InnoDB: Tablespace ID 42 name test/#sql-ib25-3083451442:Default tablespace encryption mode scheme encrypted
 
2016-11-17  4:10:48 1352082752 [Note] InnoDB: Online DDL : Start
 
2016-11-17  4:10:48 1352082752 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files
 
2016-11-17  4:10:48 1352082752 [Note] InnoDB: Online DDL : End of reading clustered index of the table and create temporary files
 
2016-11-17  4:10:48 1352082752 [Note] InnoDB: Online DDL : Completed
 
2016-11-17  4:10:48 1352082752 [Note] InnoDB: Online DDL : Start
 
2016-11-17  4:10:48 1352082752 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=12, page number=14], I/O length: 16384 bytes
 
2016-11-17  4:10:48 1299028288 [ERROR] InnoDB: trying to read page [page id: space=12, page number=14] in nonexisting or being-dropped tablespace
 
2016-11-17  4:10:48 1299028288 [ERROR] [FATAL] InnoDB: Unable to read page [page id: space=12, page number=14] into the buffer pool after 100 attempts. The most probable cause of this error may be that the table has been corrupted. Or, the table was compressed with with an algorithm that is not supported by this instance. If it is not a decompress failure, you can try to fix this problem by using innodb_force_recovery. Please see http://dev.mysql.com/doc/refman/5.7/en/ for more details. Aborting...
 
2016-11-17 04:10:48 0x4d6d9940  InnoDB: Assertion failure in thread 1299028288 in file ut0ut.cc line 949
 
InnoDB: We intentionally generate a memory trap.
 
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
 
InnoDB: If you get repeated assertion failures or crashes, even
 
InnoDB: immediately after the mysqld startup, there may be
 
InnoDB: corruption in the InnoDB tablespace. Please refer to
 
InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html
 
InnoDB: about forcing recovery.
 
161117  4:10:48 [ERROR] mysqld got signal 6 ;
 
This could be because you hit a bug. It is also possible that this binary
 
or one of the libraries it was linked against is corrupt, improperly built,
 
or misconfigured. This error can also be caused by malfunctioning hardware.
 
 
 
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
 
 
 
We will try our best to scrape up some info that will hopefully help
 
diagnose the problem, but since we have already crashed, 
something is definitely wrong and this may fail.
 
 
 
Server version: 10.2.3-MariaDB-log
 
key_buffer_size=1048576
 
read_buffer_size=131072
 
max_used_connections=1
 
max_threads=153
 
thread_count=2
 
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 62976 K  bytes of memory
 
Hope that's ok; if not, decrease some variables in the equation.
 
 
 
Thread pointer: 0x0x0
 
Attempting backtrace. You can use the following information to find out
 
where mysqld died. If you see no messages after this, something went
 
terribly wrong...
 
stack_bottom = 0x0 thread_stack 0x48c00
 
/usr/local/mariadb-10.2.3-linux-x86_64/bin/mysqld(my_print_stacktrace+0x2e)[0xddc7fe]
 
/usr/local/mariadb-10.2.3-linux-x86_64/bin/mysqld(handle_fatal_signal+0x4c2)[0x7cad62]
 
/lib64/libpthread.so.0[0x347a00e4c0]
 
/lib64/libc.so.6(gsignal+0x35)[0x3479830215]
 
/lib64/libc.so.6(abort+0x110)[0x3479831cc0]
 
/usr/local/mariadb-10.2.3-linux-x86_64/bin/mysqld[0xb5b9e0]
 
/usr/local/mariadb-10.2.3-linux-x86_64/bin/mysqld[0xb6099c]
 
/usr/local/mariadb-10.2.3-linux-x86_64/bin/mysqld[0xbad11d]
 
/usr/local/mariadb-10.2.3-linux-x86_64/bin/mysqld[0xc3e8fc]
 
/usr/local/mariadb-10.2.3-linux-x86_64/bin/mysqld[0xc438e6]
 
/lib64/libpthread.so.0[0x347a006367]
 
/lib64/libc.so.6(clone+0x6d)[0x34798d2f7d]
 
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
 
information that should help you find out what is causing the crash.
 
Writing a core file
 
----------SERVER LOG END-------------

Comment by Daniel Black [ 2017-04-07 ]

Reproduced here too - 10.1 at commit ea4146229c7d4ca13eae1bc01a3a8d8b8ed42c8a. For mysql-test/unstable-tests?

10:27:18 ];mtr: spent 0:10:55 on 1640 tests. 0:24:58 (3754 tests) leftencryption.innodb_onlinealter_encryption 'ctr,xtradb' w9 [ fail ]
 
10:27:18         Test ended at 2017-04-07 00:27:18
 
10:27:18 
10:27:18 CURRENT_TEST: encryption.innodb_onlinealter_encryption
 
10:27:18 --- /source/mysql-test/suite/encryption/r/innodb_onlinealter_encryption.result	2017-04-07 00:09:42.696502348 +0000
 
10:27:18 +++ /source/mysql-test/suite/encryption/r/innodb_onlinealter_encryption.reject	2017-04-07 00:27:18.368102484 +0000
 
10:27:18 @@ -126,7 +126,7 @@
 
10:27:18  # t1 yes on expecting NOT FOUND
 
10:27:18  NOT FOUND /foobar/ in t1.ibd
 
10:27:18  # t2 ... on expecting NOT FOUND
 
10:27:18 -NOT FOUND /temp/ in t2.ibd
 
10:27:18 +FOUND /temp/ in t2.ibd
 
10:27:18  # t3 ... on expecting NOT FOUND
 
10:27:18  NOT FOUND /barfoo/ in t3.ibd
 
10:27:18  # t4 ... on expecting NOT FOUND
 
10:27:18 
10:27:18 mysqltest: Result length mismatch
 
10:27:18 
10:27:18  - saving '/build/build/mysql-test/var/9/log/encryption.innodb_onlinealter_encryption-ctr,xtradb/' to '/build/build/mysql-test/var/log/encryption.innodb_onlinealter_encryption-ctr,xtradb/'

Comment by Jan Lindström (Inactive) [ 2017-04-28 ]

10.1:

commit 765a43605a42c069ede604826ede2d93d72c4fdd
Author: Jan Lindström <jan.lindstrom@mariadb.com>
Date: Wed Apr 26 15:19:16 2017 +0300

MDEV-12253: Buffer pool blocks are accessed after they have been freed

Problem was that bpage was referenced after it was already freed
from LRU. Fixed by adding a new variable encrypted that is
passed down to buf_page_check_corrupt() and used in
buf_page_get_gen() to stop processing page read.

This patch should also address following test failures and
bugs:

MDEV-12419: IMPORT should not look up tablespace in
PageConverter::validate(). This is now removed.

MDEV-10099: encryption.innodb_onlinealter_encryption fails
sporadically in buildbot

MDEV-11420: encryption.innodb_encryption-page-compression
failed in buildbot

MDEV-11222: encryption.encrypt_and_grep failed in buildbot on P8

Removed dict_table_t::is_encrypted and dict_table_t::ibd_file_missing
and replaced these with dict_table_t::file_unreadable. Table
ibd file is missing if fil_get_space(space_id) returns NULL
and encrypted if not. Removed dict_table_t::is_corrupted field.

Ported FilSpace class from 10.2 and using that on buf_page_check_corrupt(),
buf_page_decrypt_after_read(), buf_page_encrypt_before_write(),
buf_dblwr_process(), buf_read_page(), dict_stats_save_defrag_stats().

Added test cases when enrypted page could be read while doing
redo log crash recovery. Also added test case for row compressed
blobs.

btr_cur_open_at_index_side_func(),
btr_cur_open_at_rnd_pos_func(): Avoid referencing block that is
NULL.

buf_page_get_zip(): Issue error if page read fails.

buf_page_get_gen(): Use dberr_t for error detection and
do not reference bpage after we hare freed it.

buf_mark_space_corrupt(): remove bpage from LRU also when
it is encrypted.

buf_page_check_corrupt(): @return DB_SUCCESS if page has
been read and is not corrupted,
DB_PAGE_CORRUPTED if page based on checksum check is corrupted,
DB_DECRYPTION_FAILED if page post encryption checksum matches but
after decryption normal page checksum does not match. In read
case only DB_SUCCESS is possible.

buf_page_io_complete(): use dberr_t for error handling.

buf_flush_write_block_low(),
buf_read_ahead_random(),
buf_read_page_async(),
buf_read_ahead_linear(),
buf_read_ibuf_merge_pages(),
buf_read_recv_pages(),
fil_aio_wait():
Issue error if page read fails.

btr_pcur_move_to_next_page(): Do not reference page if it is
NULL.

Introduced dict_table_t::is_readable() and dict_index_t::is_readable()
that will return true if tablespace exists and pages read from
tablespace are not corrupted or page decryption failed.
Removed buf_page_t::key_version. After page decryption the
key version is not removed from page frame. For unencrypted
pages, old key_version is removed at buf_page_encrypt_before_write()

dict_stats_update_transient_for_index(),
dict_stats_update_transient()
Do not continue if table decryption failed or table
is corrupted.

dict0stats.cc: Introduced a dict_stats_report_error function
to avoid code duplication.

fil_parse_write_crypt_data():
Check that key read from redo log entry is found from
encryption plugin and if it is not, refuse to start.

PageConverter::validate(): Removed access to fil_space_t as
tablespace is not available during import.

Fixed error code on innodb.innodb test.

Merged test cased innodb-bad-key-change5 and innodb-bad-key-shutdown
to innodb-bad-key-change2. Removed innodb-bad-key-change5 test.
Decreased unnecessary complexity on some long lasting tests.

Removed fil_inc_pending_ops(), fil_decr_pending_ops(),
fil_get_first_space(), fil_get_next_space(),
fil_get_first_space_safe(), fil_get_next_space_safe()
functions.

fil_space_verify_crypt_checksum(): Fixed bug found using ASAN
where FIL_PAGE_END_LSN_OLD_CHECKSUM field was incorrectly
accessed from row compressed tables. Fixed out of page frame
bug for row compressed tables in
fil_space_verify_crypt_checksum() found using ASAN. Incorrect
function was called for compressed table.

Added new tests for discard, rename table and drop (we should allow them
even when page decryption fails). Alter table rename is not allowed.
Added test for restart with innodb-force-recovery=1 when page read on
redo-recovery cant be decrypted. Added test for corrupted table where
both page data and FIL_PAGE_FILE_FLUSH_LSN_OR_KEY_VERSION is corrupted.

Adjusted the test case innodb_bug14147491 so that it does not anymore
expect crash. Instead table is just mostly not usable.

fil0fil.h: fil_space_acquire_low is not visible function
and fil_space_acquire and fil_space_acquire_silent are
inline functions. FilSpace class uses fil_space_acquire_low
directly.

recv_apply_hashed_log_recs() does not return anything.

Generated at Thu Feb 08 07:39:40 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.