List:General Discussion« Previous MessageNext Message »
From:Varshavchick Alexander Date:April 15 2004 7:29am
Subject:4.0.18 repeatedly restarts
View as plain text  
Hello,

After upgrating mysql 4.0.7 to 4.0.18/FreeBSD 4.6.2, the mysqld restarts
each time it receives a remote connect from another client machine. Here
is what is written into the log:

040415 08:51:00  mysqld started
040415  8:51:00  Warning: setrlimit returned ok, but didn't change limits.
Max open files is 22154 (request: 25010)
040415  8:51:00  Warning: Changed limits: max_connections: 5000  table_cache: 8572
040415  8:51:01  InnoDB: Started
/usr/local/mysql40/libexec/mysqld: ready for connections.
Version: '4.0.18-log'  socket: '/tmp/mysql4.sock'  port: 3310

Number of processes running now: 0
040415 08:51:15  mysqld restarted
040415  8:51:15  Warning: setrlimit returned ok, but didn't change limits.
Max open files is 22154 (request: 25010)


What the client gets is the error
ERROR 2013: Lost connection to MySQL server during query


Connections from the same server, both using unix socket or tcp port, get
through without any problems.

The mysql 4.0.18 was compiled from ports with the linuxthreads option.
4.0.7 is working fine on the same machine. Any help will be greatly
apprecialted.

Thanks

----
Alexander Varshavchick, Metrocom Joint Stock Company
Phone: (812)118-3322, 118-3115(fax)
Thread
4.0.18 repeatedly restartsVarshavchick Alexander15 Apr