On Mon, 2003-11-10 at 05:25, Frank Barknecht wrote: > Hallo, > Stephan Diehl hat gesagt: // Stephan Diehl wrote: > > > I've seen this as well (I think there was already a discussion a while back > > about this). I'm using my own object wrapper, so it's safe to say that it has > > nothing to do with SQLObjects or MiddleKit. > > But, I've only see the MySQL error early mornings, so I concluded that some > > stale connection might be the reason. What I find a bit worrying is that you > > get a segfault as well. > > Have you tried to build the python client mysqlstuff from source? > > Tried now, but it didn't help. I might have to live with this problem, > but then I would need a way to restart the AppServer with a "kill -9 > allAppServerPIDs" beforehand automatically...
The only way I found to prevent these stale connections is to explicitly build a new one for every group of DB operations. That of course throws away any connection pooling you can do. You may also want to look at David Rushby's resilient DBPool and see if you can make more progress than I in implementing a MySQL version. The message can be found here: http://sourceforge.net/mailarchive/message.php?msg_id=5761200 -- Thomas E Jenkins <[EMAIL PROTECTED]> ------------------------------------------------------- This SF.Net email sponsored by: ApacheCon 2003, 16-19 November in Las Vegas. Learn firsthand the latest developments in Apache, PHP, Perl, XML, Java, MySQL, WebDAV, and more! http://www.apachecon.com/ _______________________________________________ Webware-discuss mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/webware-discuss
