By hpotar on

Hello everyone,

I have a funny problem with Drupal. Everything is working well so far, except for this problem. Very often, I get this error:

error: Lost connection to MySQL server during query
query: SELECT * FROM system where type = 'theme' AND status = '1' ORDER BY name in mysite/includes/database.mysql.inc on line 75.

It's almost always the same error. It happens when I try to change some admin options. Sometimes the error disappears when I hit "refresh", sometimes it doesn't. Another funny error (probably related to the same problem) is that I keep getting disconnected from my website. I have to re-login very often. I don't know what is going on, but these mystery errors are occurring often enough that I'm writing about them to Drupal.

Details:
Login error: I can best pin it down to this phenomenon: If I'm in the administration pages and save a new modification and return to the homepage, I have to re-login very often. The site forgets that I've already logged-in. Equally often, I get the "connection lost, line 75 error for trying the same thing. At this stage, I'm unable to click "back" and try to pursue other links as if I'm already logged in.

More specifically, if I'm in the taxonomy section and try to translate the page I get the same line 75 error. If I try to create a new user, I get the same line 75 error. For taxonomy, there's no chance of the error disappearing even with refresh. I remember getting the same error a few other times as well, but can't pin it down. The funny thing is that the translation has been successful anyways. (I clicked on "translate" anyways and got a whole list of lines that were translated, and the error at the bottom of the page)
Is there anybody out there experiencing this problem? Is the problem with a setting on the MySQL server and how the web-server is configured with MySQL? Or is it a Drupal thing? I'm using Drupal v 4.2.0. Any solutions, suggestions, follow-up questions would be very much appreciated.
Thanks a bunch
hpotar

Comments

eureka’s picture

eureka commented

I have the problem too:


user error: Lost connection to MySQL server during query query: UPDATE drtest_sessions SET uid = 0, hostname = '212.119.37.210', session = '', timestamp = 1073848860 WHERE sid = '0a010cff3ac7d85f73a3fd35455c2121' in /usr/vhome/e/e/-/ee-studio.com/www/drtest/includes/database.mysql.inc on line 90.

------NeT-FRee-GeeK------

Hutchison’s picture

Hutchison commented

I would say its a problem with using mysql_pconnect (wild guess), but Drupal uses mysql_connect. So, you shouldn't have a problem there.

Are you on a shared hosting server or on a local server?

Here are my phpinfo settings for my mySQL section. Maybe it helps?

mysql
MySQL Support	enabled
Active Persistent Links 	0
Active Links 	0
Client API version 	4.0.15
MYSQL_MODULE_TYPE 	external
MYSQL_SOCKET 	/var/lib/mysql/mysql.sock
MYSQL_INCLUDE 	-I/usr/include/mysql
MYSQL_LIBS 	-L/usr/lib -lmysqlclient

Directive	Local Value	Master Value
mysql.allow_persistent	On	On
mysql.connect_timeout	-1	-1
mysql.default_host	no value	no value
mysql.default_password	no value	no value
mysql.default_port	no value	no value
mysql.default_socket	no value	no value
mysql.default_user	no value	no value
mysql.max_links	Unlimited	Unlimited
mysql.max_persistent	Unlimited	Unlimited
mysql.trace_mode	Off	Off
multiplex’s picture

multiplex commented

Everytime I run cron.php I get this:


Fatal error: Lost connection to MySQL server during query query: INSERT INTO watchdog (uid, type, message, link, location, hostname, timestamp) VALUES (0, 'error', 'warning: mysql_query() [<a href=\'http://www.php.net/function.mysql-query\'>function.mysql-query</a>]: Unable to save result set in .../database.mysql.inc on line 73.', '', '/cron.php', '--ip--', 1096234559) in .../includes/database.mysql.inc on line 90

I've pinned it down and it seems that the "search index update" hook is the one causing all the trouble, I've changed MySQL variables, but doesn't seem to have any effect. I would really appreciate some help on this because my search isn't working because of this problem...
-------------
:? MultipleX

laurik_610’s picture

laurik_610 commented

I have a problem whit my serrver and MYSQL. Change to a more current version MYSQL. But now I can not connect to or BD. Are You know if I have to set something on my server?

bilgehan’s picture

bilgehan commented

I configured cron job yesterday and when I click the "modules" link in "administror" I get the same error. I can navigate without problem in other parts of the site. The error is:

Lost connection to MySQL server during query query: UPDATE sessions SET uid = 1, hostname = '81.33.156.174', session = 'og_last|N;messages|a:0:{}watchdog_overview_filter|s:3:\"all\";', timestamp = 1121444519 WHERE sid = 'f50b3587d8359fd0ce860af63fb5ea1f' in /datos/home/ispanyal/public_html/includes/database.mysql.inc on line 66.

How can I fix this? I don't understand what's the relation of cron job with this. Somebody knows the answer?
Thanks in advance

charlener’s picture

charlener commented

I get it when I run cron from a browser window. any ideas?