MySQL server has gone away?

MySQL server has gone away?

am 09.11.2006 09:11:39 von rod082

Hello, can anybody tell me why this Mysql error
happens in some times and not all of the times:

DBD::mysql::db selectrow_array failed: MySQL server
has gone away at filename.pm line 62.




____________________________________________________________ ________________________
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail beta.
http://new.mail.yahoo.com

Re: MySQL server has gone away?

am 09.11.2006 09:34:13 von jon.molin

On 11/9/06, rami doqa wrote:
> Hello, can anybody tell me why this Mysql error
> happens in some times and not all of the times:
>
> DBD::mysql::db selectrow_array failed: MySQL server
> has gone away at filename.pm line 62.

Your script loses connection to the mysql server sometimes (aka mysql
morning sickness). Try using:
$dbh->{mysql_auto_reconnect} = 1;

/Jon

Re: MySQL server has gone away?

am 09.11.2006 23:00:15 von dkasak

rami doqa wrote:

> Hello, can anybody tell me why this Mysql error
> happens in some times and not all of the times:
>
> DBD::mysql::db selectrow_array failed: MySQL server
> has gone away at filename.pm line 62.
>

For me, that usually means the database has crashed :(
Check your MySQL logs to see if it's having ... 'issues'.

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@nusconsulting.com.au
website: http://www.nusconsulting.com.au