[MDEV-23422] innodb_zip.restart fails in buildbot with wrong result Created: 2020-08-06  Updated: 2020-10-06  Resolved: 2020-08-10

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.5
Fix Version/s: 10.5.7

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Marko Mäkelä
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
is caused by MDEV-16678 Use MDL for innodb background threads... Closed

 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-trusty-x86/builds/18469

bb-10.5-release f35eeb791a130

 
innodb_zip.restart '16k,crc32,innodb'    w1 [ fail ]
 
        Test ended at 2020-08-05 18:27:55
 
 
 
CURRENT_TEST: innodb_zip.restart
 
--- /usr/local/mariadb-10.5.5-linux-i686/mysql-test/suite/innodb_zip/r/restart.result	2020-08-05 17:15:41.000000000 +0000
 
+++ /usr/local/mariadb-10.5.5-linux-i686/mysql-test/suite/innodb_zip/r/restart.reject	2020-08-05 18:27:55.049795974 +0000
 
@@ -506,6 +506,7 @@
 
 t7_restart.frm
 
 t7_restart.par
 
 ---- MYSQL_TMP_DIR/alt_dir/test
 
+#sql-ib30.ibd
 
 t5_restart.ibd
 
 t5_restart.ibd.bak
 
 t6_restart#p#p0.ibd
 
 
 
mysqltest: Result length mismatch



 Comments   
Comment by Marko Mäkelä [ 2020-08-07 ]

I think that these errors started to appear with MDEV-16678, due to a MDL conflict between purge and the InnoDB internal background DROP TABLE queue, which is needed at least until MDEV-21602 and MDEV-21175 have been addressed. I have been adjusting many tests for this failure, but I must have missed this one.

Comment by Marko Mäkelä [ 2020-08-10 ]

Basically, all list_files commands that can return .ibd files should be replaced with a construct that allows filtering of the extra files:

--list_files $MYSQLD_DATADIR/test
 
 
 
--list_files $MYSQLTEST_VARDIR/mysql-test-data-dir/test

must be replaced with the following:

--let $regexp=/#sql-ib[0-9a-f]+\.ibd\n//
 
 
 
--list_files_write_file $MYSQLD_DATADIR.files.txt $MYSQLD_DATADIR/test
 
--replace_regex $regexp
 
--cat_file $MYSQLD_DATADIR.files.txt
 
--remove_file $MYSQLD_DATADIR.files.txt
 
 
 
--list_files_write_file $MYSQLTEST_VARDIR/files.txt $MYSQLTEST_VARDIR/mysql-test-data-dir/test
 
--replace_regex $regexp
 
--cat_file $MYSQLTEST_VARDIR/files.txt
 
--remove_file $MYSQLTEST_VARDIR/files.txt

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