Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.7(EOL), 10.9(EOL)
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
|
Attachments
Activity
Also seen on 10.7 and 10.9:
https://buildbot.mariadb.org/#/builders/75/builds/9723
https://buildbot.mariadb.org/#/builders/78/builds/9039
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
|
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