List:General Discussion« Previous MessageNext Message »
From:Michael Dykman Date:May 4 2009 6:20pm
Subject:Re: expired mysql connection ?
View as plain text  
There really isn't enough data here for a clear diagnosis.  In my
experience, having the server 'go away' in the middle of a process is
often caused by a bug in MySQL, more often than not triggered my some
preposterous thing my client code was trying to do.

Question:  are you explicitly closing the connections that you open?
Are you releasing your statements and result sets when you are done?
You may be overloading the server's use of available resources running
a long program which might be pushing MySQL into an unstable state.

Tell me, did your MySQL server come restart after the shutdown event
or did it stay stopped?

If it did restart, was your perl program able to recognize that and
start using it again or did your application stop on first detecting
that error?

 - michael dykman

On Sun, May 3, 2009 at 11:21 PM, Randomcoder <randomcoder1@stripped> wrote:
> 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
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>



-- 
 - michael dykman
 - mdykman@stripped

 - All models are wrong.  Some models are useful.
Thread
expired mysql connection ?Randomcoder4 May
  • Re: expired mysql connection ?Michael Dykman4 May