Bug #32212 Temporary table makes roll-forward impossible

Submitted:	9 Nov 2007 8:48	Modified:	10 Oct 2008 6:17
Reporter:	Holger Thiel	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Backup	Severity:	S4 (Feature request)
Version:	5.0.46	OS:	Linux (Cent OS 5)
Assigned to:		CPU Architecture:	Any
Tags:	recovery, roll-forward, temporary table

Description:
If you want to make a recovery with binlogs you cannot roll forward if you use temporary tables. 

If you take a backup while temporary tables are in use operation fail at recovery because sql-commandos refer to tables which are not existing.

There is no possibility to get information about the existence of temporary table if the server is no slave. On a slave there is the status "Slave_open_temp_tables". On normal server there is not such a variable,

How to repeat:
- 1. CREATE  TEMPORARY
- 2. BACKUP
- 3. Use temporary table with writing to binlog
- 4. Recover with Backup
- 5. Roll-Forward with Binlog

Suggested fix:
A status variable which shows the existence of temporary tables.

Thank you for the reasonable feature request.

This is a duplicate of bug #33574

Page generated in 0.051 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.