Slave_open_temp_tables fails to decrement on the slave w/ binlog off if master is killed
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Invalid
|
Undecided
|
Unassigned | |||
5.6 |
Fix Released
|
Medium
|
Laurynas Biveinis | |||
5.7 |
Fix Released
|
Medium
|
Laurynas Biveinis |
Bug Description
The fix [1] has been merged to PS 5.6 incorrectly: the part which decrements Slave_open_
To repeat, add mysql-test/
[1]
commit e1f5cb000cf42e3
Author: Venkatesh Duggirala <email address hidden>
Date: Tue Mar 18 18:40:47 2014 +0530
Bug#18364070: Backporting Bug#18236612 to Mysql-5.6
Problem: When Slave SQL thread detects that Master was restarted
with the help of information sent by Master through 'FormatDescription'
event, slave SQL drops all the opened temporary tables inorder to have
proper cleanup. While slave SQL thread is dropping the temporary tables,
it is not decrementing Slave_open_
Fix: Set slave_open_
[2]
diff --git a/sql/sql_base.cc b/sql/sql_base.cc
index be8ed86..70dd46f 100644
--- a/sql/sql_base.cc
+++ b/sql/sql_base.cc
@@ -1572,8 +1581,7 @@ bool close_temporary
}
thd-
- if (thd->slave_thread)
- modify_
+ mysql_mutex_
DBUG_
}
tags: | added: merge-regression |
https:/ /github. com/percona/ percona- server/ pull/445, https:/ /github. com/percona/ percona- server/ pull/446