MySQL server shutdown & lost connection errors [#108193]

I am not sure if this is a support request or bug, but this is a copy of the forum topic http://drupal.org/node/108182

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

These are more errors that just appeared on my site on a blank page:

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

Comments

Comment #1

Eagle-i commented 10 January 2007 at 16:19

Some followup:

I discovered that this problem occurred after poormanscron.php invoked a cron. The setting was every 60 minutes. That is now changed to every 2 hours and it had this problem one more time. After that it hasn't done that for about 7 1/2 hours.

Any idea what the problem might be?