Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

As you might know, in order to assure a consistent replication state, the slave should be backup only when there are no open temporary tables:

What I am getting is:

innobackupex:: Slave open temp tables: 10
innobackupex:: Starting slave SQL thread, waiting 3 seconds, then checking Slave_open_temp_tables again (299 attempts remaining)..
.
>> log scanned up to (543379918280)
>> log scanned up to (543382186733)
innobackupex:: Slave open temp tables: 13
innobackupex:: Starting slave SQL thread, waiting 3 seconds, then checking Slave_open_temp_tables again (298 attempts remaining)...
>> log scanned up to (543383410142)
>> log scanned up to (543384217254)
innobackupex:: Slave open temp tables: 16
innobackupex:: Starting slave SQL thread, waiting 3 seconds, then checking Slave_open_temp_tables again (297 attempts remaining)..
...

innobackupex:: Starting slave SQL thread, waiting 3 seconds, then checking Slave_open_temp_tables again (1 attempts remaining)...
>> log scanned up to (543458889721)
>> log scanned up to (543459141720)
innobackupex:: Slave open temp tables: 16
innobackupex:: Starting slave SQL thread, waiting 3 seconds, then checking Slave_open_temp_tables again (0 attempts remaining)...
>> log scanned up to (543459141720)
innobackupex:: Slave open temp tables: 16
innobackupex: Error: Slave_open_temp_tables did not become zero after waiting 900 seconds at /usr/bin/innobackupex line 379.

So the question is:

  1. what cause the slave SQL thread keeps openning the temporary tables? Long running transaction, ...?
  2. Is there any way to know what the MySQL is doing with temporary tables?
share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.