[MDEV-12748] innodb_zip.wl6501_1 fails in buildbot with Unknown storage engine 'InnoDB' Created: 2017-05-09  Updated: 2017-06-21  Due: 2017-06-01  Resolved: 2017-06-21

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.2
Fix Version/s: 10.2.6

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None


 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest2-big/builds/759/steps/test_1/logs/stdio

innodb_zip.wl6501_1 'innodb'             w2 [ fail ]
 
        Test ended at 2017-05-08 19:08:36
 
 
 
CURRENT_TEST: innodb_zip.wl6501_1
 
mysqltest: At line 228: query 'select count(*) from t1' failed: 1286: Unknown storage engine 'InnoDB'
 
 
 
The result from queries just before the failure was:
 
< snip >
 
3
 
select count(*) from t4;
 
count(*)
 
3
 
select count(*) from t5;
 
count(*)
 
3
 
select count(*) from t6;
 
count(*)
 
3
 
set session debug="+d,ib_trunc_crash_during_drop_index_temp_table";
 
Warnings:
 
Warning	1287	'@@debug' is deprecated and will be removed in a future release. Please use '@@debug_dbug' instead
 
"---debug ib_trunc_crash_during_drop_index_temp_table point---"
 
# Write file to make mysql-test-run.pl expect crash and restart
 
# Run the crashing query
 
truncate table t5;
 
ERROR HY000: Lost connection to MySQL server during query
 
# Restart the MySQL server
 
select count(*) from t1;



 Comments   
Comment by Jan Lindström (Inactive) [ 2017-05-09 ]

If this repeats after MDEV-12720 recovery fails with "Generic error" for ROW_FORMAT=compressed i.e. commit b3939a35aa5e67d6204810e3e8c150772e60c422 please get back.

Comment by Jan Lindström (Inactive) [ 2017-05-09 ]

With latest version can't repeat:

jan@jan-laptop-asus:~/mysql/10.2-orig/mysql-test$ ./mtr --vardir=/dev/shm innodb_zip.wl6501_1 --repeat=20
 
Logging: ./mtr  --vardir=/dev/shm innodb_zip.wl6501_1 --repeat=20
 
vardir: /dev/shm
 
Checking leftover processes...
 
Removing old var directory...
 
couldn't chmod(0777, /dev/shm): Operation not permitted at /usr/share/perl/5.24/File/Find.pm line 511.
 
Couldn't remove directory '/dev/shm': Permission denied at /usr/share/perl/5.24/File/Find.pm line 511.
 
Creating var directory '/dev/shm'...
 
Checking supported features...
 
MariaDB Version 10.2.6-MariaDB-debug
 
 - SSL connections supported
 
 - binaries are debug compiled
 
Collecting tests...
 
Installing system database...
 
 
 
==============================================================================
 
 
 
TEST                                      RESULT   TIME (ms) or COMMENT
 
--------------------------------------------------------------------------
 
 
 
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
 
innodb_zip.wl6501_1 'innodb'             [ pass ]  76866
 
innodb_zip.wl6501_1 'innodb'             [ pass ]  79404
 
innodb_zip.wl6501_1 'innodb'             [ pass ]  78946
 
innodb_zip.wl6501_1 'innodb'             [ pass ]  78544
 
innodb_zip.wl6501_1 'innodb'             [ pass ]  83392
 
innodb_zip.wl6501_1 'innodb'             [ pass ]  85788
 
innodb_zip.wl6501_1 'innodb'             [ pass ]  84697
 
innodb_zip.wl6501_1 'innodb'             [ pass ]  81712
 
innodb_zip.wl6501_1 'innodb'             [ pass ]  79476
 
innodb_zip.wl6501_1 'innodb'             [ pass ]  81910
 
innodb_zip.wl6501_1 'innodb'             [ pass ]  80776
 
innodb_zip.wl6501_1 'innodb'             [ pass ]  81565
 
innodb_zip.wl6501_1 'innodb'             [ pass ]  80546
 
innodb_zip.wl6501_1 'innodb'             [ pass ]  80882
 
innodb_zip.wl6501_1 'innodb'             [ pass ]  80519
 
innodb_zip.wl6501_1 'innodb'             [ pass ]  81370
 
innodb_zip.wl6501_1 'innodb'             [ pass ]  81789
 
innodb_zip.wl6501_1 'innodb'             [ pass ]  82283
 
innodb_zip.wl6501_1 'innodb'             [ pass ]  86641
 
innodb_zip.wl6501_1 'innodb'             [ pass ]  84401
 
--------------------------------------------------------------------------
 
The servers were restarted 0 times
 
Spent 1631.507 of 1645 seconds executing testcases
 
 
 
Completed: All 20 tests were successful.

Comment by Elena Stepanova [ 2017-06-21 ]

It didn't happen after MDEV-12720.

Generated at Thu Feb 08 08:00:09 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.