mysql-test/extra/binlog_tests/tmp_table.test does not disconnect temp table connections, intermittently failing following tests

Bug #1676705 reported by Laurynas Biveinis
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.5
New
Undecided
Unassigned
5.6
Fix Released
Low
Laurynas Biveinis
5.7
Fix Released
Low
Laurynas Biveinis

Bug Description

On 5.6 trunk:

binlog.binlog_stm_tmp_table 'stmt' w4 [ pass ] 596
binlog.binlog_stm_user_variables 'stmt' w4 [ fail ]
        Test ended at 2017-03-23 09:20:58

CURRENT_TEST: binlog.binlog_stm_user_variables
--- /mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/centos6-32/mysql-test/suite/binlog/r/binlog_stm_user_variables.result 2017-03-22 15:06:23.821000038 +0300
+++ /mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/centos6-32/build/mysql-test/var/4/log/binlog_stm_user_variables.reject 2017-03-23 16:20:57.373000225 +0300
@@ -133,6 +133,8 @@
 @positive,
 @positive)
 master-bin.000001 # Query # # COMMIT
+master-bin.000001 # Query # # use `test`; DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp1_foo`
+master-bin.000001 # Query # # use `test`; DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp2_foo`
 master-bin.000001 # Query # # BEGIN
 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (-9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808,-9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808)
 master-bin.000001 # Query # # COMMIT

mysqltest: Result content mismatch

Tags: ci upstream
summary: - mysql-test/extra/binlog_tests/tmp_table.test does not drop tmp1_foo and
- tmp2_foo, intermittently failing following tests
+ mysql-test/extra/binlog_tests/tmp_table.test does not disconnect temp
+ table connections, intermittently failing following tests
tags: added: ci upstream
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2251

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.