> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Frank > Barknecht > Sent: Monday, November 10, 2003 10:53 AM > To: 'Webware discuss' > Subject: Re: [Webware-discuss] 'Lost connection to MySQL server during > query' > > > Hallo, > Thomas E Jenkins hat gesagt: // Thomas E Jenkins wrote: > > > Postgres definitely does not exhibit this behavior. Since I inherited a > > lot of databases I have a fair mix of both MySQL and Postgres. I > > struggled for a long time with MySQL lost connection problems hanging > > the app server, however once I switched all the MySQL operations to use > > built on demand connections the problems have disappeared completely. > > For the Postgres DBs I still use connection sharing leaving an odd mix > > of both. > > This is good to hear. I think, I will try to migrate to Postgres. > (Now I only have to find out how or if Postgres can be made to accept > CSV-data imports with floats using a comma as decimal divider...) >
This problem could be a server timeout. mysql has a default 8-hour timeout for inactive connections. Do these errors occur after about 8 hours of inactivity? You can read more here: http://www.mysql.com/doc/en/Gone_away.html - Ben ------------------------------------------------------- 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
