[MDEV-20523] rpl.create_or_replace_mix, rpl.create_or_replace_statement failed in buildbot with wrong result Created: 2019-09-07  Updated: 2023-11-22  Resolved: 2023-11-17

Status: Closed
Project: MariaDB Server
Component/s: Replication, Tests
Affects Version/s: 10.1, 10.2, 10.3, 10.4, 10.5, 10.7, 10.9
Fix Version/s: 10.4.33, 10.5.24, 10.6.17, 10.11.7, 11.0.5, 11.1.4, 11.2.3

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Kristian Nielsen
Resolution: Fixed Votes: 0
Labels: temporary-table-replication


 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-stretch-ppc64le/builds/4612

10.1 91fdb931fa2f734d54acadeb3e9c860a

 
rpl.create_or_replace_mix 'mix,xtradb'   w3 [ fail ]
 
        Test ended at 2019-08-20 13:47:41
 
 
 
CURRENT_TEST: rpl.create_or_replace_mix
 
--- /usr/share/mysql/mysql-test/suite/rpl/r/create_or_replace_mix.result	2019-08-20 09:51:45.000000000 -0400
 
+++ /dev/shm/var/3/log/create_or_replace_mix.reject	2019-08-20 13:47:40.911615613 -0400
 
@@ -257,7 +257,5 @@
 
 master-bin.000001	#	Query	#	#	DROP TEMPORARY TABLE IF EXISTS `test`.`t7` /* generated by server */
 
 master-bin.000001	#	Gtid	#	#	GTID #-#-#
 
 master-bin.000001	#	Query	#	#	use `test`; create temporary table t9 (i int)
 
-master-bin.000001	#	Gtid	#	#	GTID #-#-#
 
-master-bin.000001	#	Query	#	#	use `test`; DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `t9`
 
 drop table t2;
 
 include/rpl_end.inc
 
 
 
mysqltest: Result length mismatch

http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest/builds/19920

10.2 39e5b76ef1e68c0aed0b0f6941d517a9

 
rpl.create_or_replace_statement 'innodb,stmt' w2 [ fail ]
 
        Test ended at 2019-09-06 22:39:14
 
 
 
CURRENT_TEST: rpl.create_or_replace_statement
 
--- /mnt/buildbot/build/mariadb-10.2.27/mysql-test/suite/rpl/r/create_or_replace_statement.result	2019-09-06 20:43:20.000000000 -0400
 
+++ /mnt/buildbot/build/mariadb-10.2.27/mysql-test/suite/rpl/r/create_or_replace_statement.reject	2019-09-06 22:39:13.775706398 -0400
 
@@ -274,7 +274,5 @@
 
 master-bin.000001	#	Query	#	#	DROP TEMPORARY TABLE IF EXISTS `test`.`t7` /* generated by server */
 
 master-bin.000001	#	Gtid	#	#	GTID #-#-#
 
 master-bin.000001	#	Query	#	#	use `test`; create temporary table t9 (i int)
 
-master-bin.000001	#	Gtid	#	#	GTID #-#-#
 
-master-bin.000001	#	Query	#	#	use `test`; DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `t9`
 
 drop table t2;
 
 include/rpl_end.inc
 
 
 
mysqltest: Result length mismatch



 Comments   
Comment by Alice Sherepa [ 2020-10-29 ]

on 10.1-10.5, mostly on bld-p9-rhel7 http://buildbot.askmonty.org/buildbot/builders/kvm-deb-stretch-ppc64le/builds/7209/steps/mtr/logs/stdio

Comment by Angelique Sklavounos (Inactive) [ 2022-06-06 ]

Also seen on 10.7 and 10.9:
https://buildbot.mariadb.org/#/builders/75/builds/9723
https://buildbot.mariadb.org/#/builders/78/builds/9039

Comment by Kristian Nielsen [ 2023-11-17 ]

Reproduces reliably with below patch. I will fix.

diff --git a/sql/temporary_tables.cc b/sql/temporary_tables.cc
 
index 05e32d78b7f..c2872535d8d 100644
 
--- a/sql/temporary_tables.cc
 
+++ b/sql/temporary_tables.cc
 
@@ -530,6 +530,7 @@ bool THD::close_temporary_tables()
 
   // Write DROP TEMPORARY TABLE query log events to binary log.
 
   if (mysql_bin_log.is_open())
 
   {
 
+my_sleep(150000);
 
     error= log_events_and_free_tmp_shares();
 
   }
 
   else

Comment by Kristian Nielsen [ 2023-11-17 ]

Pushed to 10.4

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