2 This patch fixes bug #1034 about Temporary MySQL table 'batch'
3 disappears if MySQL connection times out.
5 Apply the patch to 2.2.7 (and possibly any 2.2.x version with):
8 patch -p0 <2.2.7-mysql-batch-timeout.patch
9 ./configure <your-options>
16 Index: src/cats/mysql.c
17 ===================================================================
18 --- src/cats/mysql.c (révision 6192)
19 +++ src/cats/mysql.c (copie de travail)
21 Dmsg3(100, "opendb ref=%d connected=%d db=%p\n", mdb->ref_count,
22 mdb->connected, mdb->db);
24 + /* Set connection timeout to 8 days specialy for batch mode */
25 + sql_query(mdb, "SET wait_timeout=691200");
26 + sql_query(mdb, "SET interactive_timeout=691200");