OperationalError: (2006, 'MySQL server has gone away')
Roger Haase <crosseyedpenguin-/[email protected]>
| Newsgroups | gmane.comp.python.webware |
|---|---|
| Message-ID | <[email protected]> |
Hi, I am testing a new server with Fedora Core 6 and Middlekit-Webware 9.2 and MySQL 5.0. When the new server is idle for 5 (or more) hours I get abends with OperationalError: (2006, 'MySQL server has gone away'). Restarting the webkit AppServer eliminates the immediate problem. I have not seen this problem on a lightly loaded server with Fedora Core 4, MySQL 4.1, and Webware 9.1. The Webkit AppServer is restarted by cron daily in both cases. In both cases the result of a call to Middlekit MySQLObjectStore is saved in the Sitepage module at load time for use by all servlets. Where should I be setting a timeout parameter for the Middlekit-MySql connection? Is 24 hours an unreasonable time limit? Roger __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV