fixing MySQL server has gone away devel
authorSandro Knauß <knauss@netzguerilla.net>
Tue, 25 Sep 2012 01:05:05 +0200
branchdevel
changeset 298 503ed1a61543
parent 297 93686b0c028b
child 299 047e4b4760aa
fixing MySQL server has gone away
iro/iro.py
iro/main.py
--- a/iro/iro.py	Thu Sep 27 14:25:41 2012 +0200
+++ b/iro/iro.py	Tue Sep 25 01:05:05 2012 +0200
@@ -36,7 +36,7 @@
     def startService(self):
         log.msg("Starting service...")
         engine = create_engine(config.main.dburl,
-               poolclass = pool.SingletonThreadPool,  pool_size=dbPool.maxthreads, )
+               poolclass = pool.SingletonThreadPool,  pool_size=dbPool.maxthreads, pool_recycle=3600)
 
         setEngine(engine)
         startPool(reactor)
--- a/iro/main.py	Thu Sep 27 14:25:41 2012 +0200
+++ b/iro/main.py	Tue Sep 25 01:05:05 2012 +0200
@@ -52,7 +52,7 @@
     config.readConfig()
 
     engine = create_engine(config.main.dburl,
-           poolclass = pool.SingletonThreadPool,  pool_size=dbPool.maxthreads, )
+           poolclass = pool.SingletonThreadPool,  pool_size=dbPool.maxthreads, pool_recycle=3600)
 
 
     root = resource.Resource()