expired mysql connection ?

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=gcdmg-mysql-2@m.gmane.org

Re: expired mysql connection ?

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 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 =A0InnoDB: Starting shutdown...
> 13586 090503 18:07:06 =A0InnoDB: 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 w=
as
> 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: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dmdykman@gmail=
..com
>
>



--=20
- michael dykman
- mdykman@gmail.com

- All models are wrong. Some models are useful.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg