Bug #71716 Procedure to build a slave fails if Slave_open_temp_tables>0
Submitted: 14 Feb 2014 9:42 Modified: 18 Aug 2014 19:35
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Backup Documentation Severity:S3 (Non-critical)
Version:3.9.0 OS:Any
Assigned to: Daniel So CPU Architecture:Any

[14 Feb 2014 9:42] Daniël van Eeden 
Description:
The procedure documented on http://dev.mysql.com/doc/mysql-enterprise-backup/3.9/en/advanced.slave.html should include information about temp tables. 

Related:
http://dev.mysql.com/doc/mysql-enterprise-backup/3.9/en/advanced.slave.html

How to repeat:
Setup replication. Take a backup from the slave with --slave-info while slave_open_temp_tables is not 0.

Try to use the backup to build a new slave. (replication will fail as the temp table is missing).
[19 Feb 2014 12:46] MySQL Verification Team 
Hello Daniel,

Thank you for the bug report.

Thanks,
Umesh
[15 Aug 2014 17:05] Daniel So 
A warning statement has been added to the MySQL Enterprise Backup 3.10 and 3.11 manuals, telling users it might be unsafe to use mysqlbackup on an SBR salve if temporary tables are created on the master.