List:General Discussion« Previous MessageNext Message »
From:Randomcoder Date:May 4 2009 3:21am
Subject:expired mysql connection ?
View as plain text  
Hi,

I run a Perl program on a test run of about 4 hours and my database 
connection expired/broke down.
Here is the error I got :

DBI connect('project','root',...) failed: Can't connect to local MySQL 
server through socket '/var/lib/mysql/mysql.sock' (2) at 
/usr/local/lib/perl5/site_perl/5.10.0/DBIx/Class/Storage/DBI.pm line 840
DBIx::Class::ResultSet::find_or_create(): DBI Connection failed: Can't 
connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' 
(2) at Test.pm line 239


Interestingly enough , that was about 18:07 and looking at 
/var/log/mysqld.log at 18:07 I see

13583 090503 18:07:03 [Note] /usr/libexec/mysqld: Normal shutdown
13584
13585 090503 18:07:04  InnoDB: Starting shutdown...
13586 090503 18:07:06  InnoDB: Shutdown completed; log sequence number 0 
2051649362

I am not into configuration issues of mysql but could you please help me 
to configure it so that it
doesn't behave this way ?
I should mention that the shutdown was not due to a command of mine , I 
was walking in the park when that happened actually.
Also if you can , please tell me the configurations you've made for that 
not to happen so I can replicate them on my test machine also(not mouse).

Thank you,
Stefan
Thread
expired mysql connection ?Randomcoder4 May
  • Re: expired mysql connection ?Michael Dykman4 May