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

Bug #1676705 reported by Laurynas Biveinis on 2017-03-28
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

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

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  Edit
Everyone can see this information.

Other bug subscribers