Re: Random Error
A little more searching also uncovered this, which appears to be right up your alley: http://dev.mysql.com/doc/refman/4.1/en/gone-away.html On 8/16/06, Dan Buettner <[EMAIL PROTECTED]> wrote: At first blush, I'd look into a few different possibilities - - An idle connection timeout is being enforced on a persistent connection pool - Too many individual connections are overwhelming a Windows server (see http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server-on-windows.html) - Flaky networking between db server and "client" (web server most likely in this case). Could be physical or logical (or both). Dan On 8/16/06, Mike Blezien <[EMAIL PROTECTED]> wrote: > It's PHP I believe, oscommerce web site, MySQL 4.0.27. this is for an associate > of ours and I am not much of a PHP programmer, strickly Perl :) > > Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Random Error
At first blush, I'd look into a few different possibilities - - An idle connection timeout is being enforced on a persistent connection pool - Too many individual connections are overwhelming a Windows server (see http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server-on-windows.html) - Flaky networking between db server and "client" (web server most likely in this case). Could be physical or logical (or both). Dan On 8/16/06, Mike Blezien <[EMAIL PROTECTED]> wrote: It's PHP I believe, oscommerce web site, MySQL 4.0.27. this is for an associate of ours and I am not much of a PHP programmer, strickly Perl :) Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Random Error
It's PHP I believe, oscommerce web site, MySQL 4.0.27. this is for an associate of ours and I am not much of a PHP programmer, strickly Perl :) Mike - Original Message - From: "Dan Buettner" <[EMAIL PROTECTED]> To: "Mike Blezien" <[EMAIL PROTECTED]> Cc: "MySQL List" Sent: Wednesday, August 16, 2006 3:24 PM Subject: Re: Random Error Mike, can you provide more details? OS platform, networking overview, types of apps experiencing this error (PHP app, mysql cli, etc), does it happen with local as well as network connections, etc. This will help us help you. Dan On 8/16/06, Mike Blezien <[EMAIL PROTECTED]> wrote: Hello, occassionally we come accross this error: 2013 - Lost connection to MySQL server during query not all the time, but now and then, no real pattern that we can see of find in the logs. but appear to happen mainly with SELECT's is there a way to fix this or trace it down to a cause? TIA Mike(mickalo)Blezien === Thunder Rain Internet Publishing Providing Internet Solution that Work http://www.thunder-rain.com === -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Random Error
Mike, can you provide more details? OS platform, networking overview, types of apps experiencing this error (PHP app, mysql cli, etc), does it happen with local as well as network connections, etc. This will help us help you. Dan On 8/16/06, Mike Blezien <[EMAIL PROTECTED]> wrote: Hello, occassionally we come accross this error: 2013 - Lost connection to MySQL server during query not all the time, but now and then, no real pattern that we can see of find in the logs. but appear to happen mainly with SELECT's is there a way to fix this or trace it down to a cause? TIA Mike(mickalo)Blezien === Thunder Rain Internet Publishing Providing Internet Solution that Work http://www.thunder-rain.com === -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]