MySQL server shutdown & lost connection?

By Eagle-i on 10 Jan 2007 at 04:03 UTC

The company that hosts my account can't find the problem nor recreate it so to them everything seems fine. But ..., my admin logs are littered with error messages like:

- lost connection to MySQL server
- unable to save set in ....
- Server shutdown in progress query

The servers run:
- php 4.4.3
- MySQL 4.1.21-standard

Can anyone help me solve this problem?

Here are the more descriptive error messages:

- Lost connection to MySQL server during query query: SELECT COUNT(DISTINCT(n.nid)) FROM node n LEFT JOIN comments c ON n.nid = c.nid AND (c.status = 0 OR c.status IS NULL) WHERE n.status = 1 AND (n.uid = 210 OR c.uid = 210) in /home/mysite/public_html/includes/database.mysql.inc on line 121.

- mysql_query() [function.mysql-query]: Unable to save result set in /home/mysite/public_html/includes/database.mysql.inc on line 102

- Server shutdown in progress query: SELECT DISTINCT(r.nid), r.title, r.teaser, MATCH(r.body, r.title) AGAINST ('dream/vision of and more text... t in /home/mysite/public_html/includes/database.mysql.inc on line 121

- Unknown error query: SELECT data, created, headers, expire FROM cache WHERE cid = 'menu:1:en' in /home/mysite/public_html/includes/database.mysql.inc on line 120

Tim

Comments

more errors on blank screen

Eagle-i commented 10 January 2007 at 05:07

Warning: Lost connection to MySQL server during query query: SELECT r.rid, r.name FROM role r INNER JOIN users_roles ur ON ur.rid = r.rid WHERE ur.uid = 1 in /home/mysite/public_html/includes/database.mysql.inc on line 121

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/mysite/public_html/includes/database.mysql.inc:121) in /home/mysite/public_html/includes/bootstrap.inc on line 760

Warning: Server shutdown in progress query: SELECT * FROM access WHERE status = 1 AND type = 'host' AND LOWER('my_ip_number') LIKE LOWER(mask) in /home/mysite/public_html/includes/database.mysql.inc on line 121

Warning: Lost connection to MySQL server during query query: SELECT * FROM access WHERE status = 0 AND type = 'host' AND LOWER('my_ip_number') LIKE LOWER(mask) in /home/mysite/public_html/includes/database.mysql.inc on line 121

Warning: Cannot modify header information - headers already sent by (output started at /home/mysite/public_html/includes/database.mysql.inc:121) in /home/mysite/public_html/includes/bootstrap.inc on line 562