Page Death I Get Sometimes..., Only sometimes on auto refresh.

[CeltWolf]

Big white page, displays following error (and some other text)
mySQL query error: SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='9a6be2a53f5c65a6b2c8a31e6451bcd3' and ip_address='198.82.100.189' AND browser='Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)'

mySQL error: Lost connection to MySQL server during query
mySQL error code: 2013
Date: Sunday 11th of April 2004 11:33:35 PM

And other times I'm getting other errors I'll paste in here.

I'm using Opera 7.

[CelticRadio]

Are you still getting this error message. We had a number of issues over the weekend which should now be resolved.

To view our site properly, please use Internet Explorer. We just don't have the time right now to support other browsers.

[Aaediwen]

Mac, I don't think that's a browser issue. If it were, I have a feeling I'd be getting it every single time. I generally only get it about the same time that I notice the stream died suddenly on me while I slept (3:30 AM ET, like clockwork, according to my logs) I almost never see the SQL errors any other time in Mozilla 1.5. Besides, since when did a web browser speak SQL, that's what you've got your PHP scripts and Apache server for =)

[CeltWolf]

I still get it periodically. Only periodically. I'll try to remember to post the other error I get. Usually, reloading the page brings it right back.

[CelticRadio]

Could be a number of issues.

We just upgraded the database server to 1 GB. The webserver is next. I am hoping to bump it up to 1 GB too.

We have all of the computers reboot between 2-2:30 a.m. EST. Around that time, I could be wrong!

Yes, if anyone gets SQL errors please email me with time and page your on. Hopefully with the recent changes we made we will not see these errors. If errors continue we will have to look into why it is happening and see what upgrades or tweaks can fix it!

You are right, mysql errors would not be browser related!

[CeltWolf]

Warning: Lost connection to MySQL server during query in /home/celticr/public_html/php/forums/sources/Drivers/mySQL.php on line 64

Warning: MySQL Connection Failed: Lost connection to MySQL server during query in /home/celticr/public_html/php/forums/sources/Drivers/mySQL.php on line 64

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/celticr/public_html/php/forums/sources/Drivers/mySQL.php on line 67
ERROR: Cannot find database customers
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/celticr/public_html/php/forums/sources/Drivers/mySQL.php on line 100



There appears to be an error with the CelticRadio.net database.
You can try to refresh the page by clicking here, if this does not fix the error, you can contact the board administrator by clicking here

Got that, maybe 1130 or so. This morning, and 0900, eastern, of that I'm certain. Pretty sure it was 1130 or so. Btw, that's the REST of the error I posted. You see what I posted here, and then, in a text box, you see what I posted at first.

[CeltWolf]

Pertinent part of the most recent one:

mySQL error: Lost connection to MySQL server during query
mySQL error code: 2013
Date: Tuesday 13th of April 2004 03:34:45 PM

[CelticRadio]

Yeah, I saw this error too.

This seems to be a network problem internally. We have the DB server on a local area network, so something is happening on the network that causes the connection to be lost. Or perhaps it is on the linux box.

I am not sure if I have the time to fix this right now as I will be building a super server that has both the webserver and database server on it. THis, i believe, will resolve this problem. So if we could possible live with this for the time being until I get our servers eggs in order.

[CelticRadio]

In follow up to this, I did do a little research and found other people having issues with the mysql lost connection.

Apparently, they solved the problem by downgrading part of the linux system glibc to a lower version. We have recently upgraded this, so it seems logical this could be the root of the problem.

I think, however, I might wait and see if they come out with another new version. I hate to downgrade and have something else go wrong.

This will be fixed when we combine servers. I am thinking on going with linux-mandrake instead of redhat as I hear mandrake has better system performance.

[CeltWolf]

Not sure if you've combined servers, yet. Just noticed that I'd gotten same death again, some time between 1300 and 1530 eastern. Forgot to look until too late.