From d6a642eca57123ce663039defc2c5e7eeb9de4f8 Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Sun, 20 Jul 2008 10:32:02 +0000 Subject: [PATCH] ebl fix #1034 by setting big timeout on mysql connections git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/branches/Branch-2.4@7402 91ce42f0-d328-0410-95d8-f526ca767f89 --- bacula/src/cats/mysql.c | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/bacula/src/cats/mysql.c b/bacula/src/cats/mysql.c index c0068b1b1d..e4aefd9e60 100644 --- a/bacula/src/cats/mysql.c +++ b/bacula/src/cats/mysql.c @@ -205,6 +205,10 @@ db_open_database(JCR *jcr, B_DB *mdb) Dmsg3(100, "opendb ref=%d connected=%d db=%p\n", mdb->ref_count, mdb->connected, mdb->db); + /* Set connection timeout to 8 days specialy for batch mode */ + sql_query(mdb, "SET wait_timeout=691200"); + sql_query(mdb, "SET interactive_timeout=691200"); + V(mutex); return 1; } -- 2.39.5