[Bacula-bugs] [bacula 0001034]: Temporary MySQL table 'batch' disappears if MySQL connection times out

[<bac...@li...>]

A NOTE has been added to this issue. 
====================================================================== 
http://bugs.bacula.org/view.php?id=1034 
====================================================================== 
Reported By:                Steltek
Assigned To:                ebollengier
====================================================================== 
Project:                    bacula
Issue ID:                   1034
Category:                   Director
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     assigned
====================================================================== 
Date Submitted:             01-06-2008 16:54 UTC
Last Modified:              01-06-2008 19:21 UTC
====================================================================== 
Summary:                    Temporary MySQL table 'batch' disappears if MySQL
connection times out
Description: 
I just had a job bail out with this message:

06-Jan 13:09 server-dir JobId 84: Fatal error: sql_create.c:732
sql_create.c:732 insert INSERT INTO batch VALUES
(578407,84,'/path/','filename','P4A ORB4 IGk B h h A Byp BAA Q BHf8G2
BHQexl BHfb1A A A E','oJKoU70RjrXaw
UdZeOLFQ') failed:
Table 'bacula.batch' doesn't exist

A short investigation shows that this happens due to the MySQL
connection timing out and the table subsequently getting dropped.

The table is created as follows:
CREATE TEMPORARY TABLE batch

The TEMPORARY causes it to be dropped if the connection to MySQL is closed
(or dropped due to timeout).
====================================================================== 

---------------------------------------------------------------------- 
 Steltek - 01-06-08 16:57  
---------------------------------------------------------------------- 
Forgot to mention: In my case, the MySQL connection timed out because I
took 10 hours to mount a media and the job was pending during that time,
the default MySQL timeout value specifies 8 hours. 

---------------------------------------------------------------------- 
 ebollengier - 01-06-08 19:21  
---------------------------------------------------------------------- 
mysql> set wait_timeout=0;
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> set interactive_timeout=0;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    1390
Current database: mysql

setting timeout to 0 doesn't work as expected, IHMO, an other great
functionnality. 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
01-06-08 16:54  Steltek        New Issue                                    
01-06-08 16:57  Steltek        Note Added: 0003062                          
01-06-08 17:00  Steltek        Issue Monitored: Steltek                     
01-06-08 19:10  ebollengier    Status                   new => assigned     
01-06-08 19:10  ebollengier    Assigned To               => ebollengier     
01-06-08 19:21  ebollengier    Note Added: 0003063                          
======================================================================