Remote MySQL connection fails after 5-6 hours

HI All,

Need help desperatly... I am running MySQL 3.23.52-3 under Linux RH 8.0 with Perl DBD 2.1017-3 and Perl DBI 1.30-1. The queries are made from Perl CGI scripts running under Apache with PerlRun, to a second Linux machine on the same LAN, on which MySQL is running. At first all goes well, but after 5-6 hours (60,000-100,000 queries) the MySQL Linux server freezes completely. The Apache server starts spitting out "no route to host". Any suggestion? I have traced the DBI interface and everything seems to work fine. When both Apache and MySQL server are on same machine, all works perfectly well...

Thanks for the help

Luc


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Remote MySQL connection fails after 5-6 hours

On Tue, 16 Sep 2003, Luc Prieur wrote:

>
> Need help desperatly... I am running MySQL 3.23.52-3 under Linux RH 8.0
> with Perl DBD 2.1017-3 and Perl DBI 1.30-1. The queries are made from
> Perl CGI scripts running under Apache with PerlRun, to a second Linux
> machine on the same LAN, on which MySQL is running. At first all goes
> well, but after 5-6 hours (60,000-100,000 queries) the MySQL Linux
> server freezes completely. The Apache server starts spitting out "no

If you look in /var/log/messages is there anything that might give you an
idication as to what might be causing the problem sometimes before a
system locks-up it will start spewing oops messages to the log file which
might get synced to disc before it becomes unresponsive.

> route to host". Any suggestion? I have traced the DBI interface and

You will start getting the no route to host (assuming both systems are in
the same subnet (and the switch does not go down)) when the other system
stops responding to arp requets, and you are not going to see that unless
your interface is taken down or your system is locked up to the point
where it is not processing arp requests.

You might want to try running a different kernel and see if that helps.

> everything seems to work fine. When both Apache and MySQL server are on
> same machine, all works perfectly well...

IP stack / NIC driver bug on the MySQL server system? Flaky hardware
might also do it.


Rudy


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Remote MySQL connection fails after 5-6 hours

On Tue, 16 Sep 2003, Luc Prieur wrote:

>
> Need help desperatly... I am running MySQL 3.23.52-3 under Linux RH 8.0
> with Perl DBD 2.1017-3 and Perl DBI 1.30-1. The queries are made from
> Perl CGI scripts running under Apache with PerlRun, to a second Linux
> machine on the same LAN, on which MySQL is running. At first all goes
> well, but after 5-6 hours (60,000-100,000 queries) the MySQL Linux
> server freezes completely. The Apache server starts spitting out "no

If you look in /var/log/messages is there anything that might give you an
idication as to what might be causing the problem sometimes before a
system locks-up it will start spewing oops messages to the log file which
might get synced to disc before it becomes unresponsive.

> route to host". Any suggestion? I have traced the DBI interface and

You will start getting the no route to host (assuming both systems are in
the same subnet (and the switch does not go down)) when the other system
stops responding to arp requets, and you are not going to see that unless
your interface is taken down or your system is locked up to the point
where it is not processing arp requests.

You might want to try running a different kernel and see if that helps.

> everything seems to work fine. When both Apache and MySQL server are on
> same machine, all works perfectly well...

IP stack / NIC driver bug on the MySQL server system? Flaky hardware
might also do it.


Rudy


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org