Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.2, 10.3, 10.4
-
None
Description
repeatable on 10.2-10.4, but not on 10.5
./mtr encryption.tempfiles,cbc,innodb,none encryption.innodb-checksum-algorithm --mysqld=--innodb-thread-concurrency=32
|
encryption.tempfiles 'cbc,innodb,none' [ pass ] 986
|
|
MTR's internal check of the test case 'encryption.tempfiles' failed.
|
This means that the test case does not preserve the state that existed
|
before the test case was executed. Most likely the test case did not
|
do a proper clean-up. It could also be caused by the previous test run
|
by this thread, if the server wasn't restarted.
|
This is the diff of the states of the servers before and after the
|
test case was executed:
|
mysqltest: Logging to '/d1/git/10.4/mysql-test/var/tmp/check-mysqld_1.log'.
|
mysqltest: Results saved in '/d1/git/10.4/mysql-test/var/tmp/check-mysqld_1.result'.
|
mysqltest: Connecting to server localhost:16000 (socket /d1/git/10.4/mysql-test/var/tmp/mysqld.1.sock) as 'root', connection 'default', attempt 0 ...
|
mysqltest: ... Connected.
|
mysqltest: Start processing test commands from './include/check-testcase.test' ...
|
mysqltest: ... Done processing test commands.
|
--- /d1/git/10.4/mysql-test/var/tmp/check-mysqld_1.result 2020-11-27 15:38:06.776000000 +0000
|
+++ /d1/git/10.4/mysql-test/var/tmp/check-mysqld_1.reject 2020-11-27 15:38:08.060000000 +0000
|
@@ -362,7 +362,7 @@
|
INNODB_TABLE_LOCKS ON
|
INNODB_TEMP_DATA_FILE_PATH ibtmp1:12M:autoextend
|
INNODB_THREAD_CONCURRENCY 32
|
-INNODB_THREAD_SLEEP_DELAY 10000
|
+INNODB_THREAD_SLEEP_DELAY 4
|
INNODB_TMPDIR
|
INNODB_TRX_PURGE_VIEW_UPDATE_ONLY_DEBUG OFF
|
INNODB_TRX_RSEG_N_SLOTS_DEBUG 0
|
|
mysqltest: Result length mismatch
|
|
not ok
|
|
encryption.innodb-checksum-algorithm '32k,cbc,innodb' [ fail ]
|
Test ended at 2020-11-27 15:38:13
|
|
CURRENT_TEST: encryption.innodb-checksum-algorithm
|
mysqltest: At line 4: query 'SET @saved_file_per_table = @@global.innodb_file_per_table' failed: 1193: Unknown system variable 'innodb_file_per_table'
|
|
The result from queries just before the failure was:
|
SET @saved_file_per_table = @@global.innodb_file_per_table;
|
|
2020-11-27 15:38:11 0 [ERROR] InnoDB: Corrupted page [page id: space=0, page number=0] of datafile './ibdata1' could not be found in the doublewrite buffer.
|
2020-11-27 15:38:11 0 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[1605] with error Data structure corruption
|
2020-11-27 15:38:12 0 [Note] InnoDB: Starting shutdown...
|
2020-11-27 15:38:12 0 [ERROR] Plugin 'InnoDB' init function returned error.
|
2020-11-27 15:38:12 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
|