Server Going Away/Shutting Down

[Andrew]

Hey,

My friend signed up for a Base-Host plan here, for a site in which we plan to be co-admins, and so far it's been great! Vbulletin's been installed, and the uptime hasn't failed us once.

But several times in the past two days, I've gotten an error saying that the server had either gone away or had shut down:

MySQL Error : MySQL server has gone away
Error Number : 2006

Invalid SQL:

SELECT varname, text
FROM phrase
WHERE fieldname = 'vbsettings' AND
languageid IN(-1, 0, 1)
ORDER BY languageid ASC;

MySQL Error : Server shutdown in progress
Error Number : 1053

I checked vbulletin.com for the meaning of these errors, and it seems the server being offline is the fault of the server I'm on, not me or vbulletin. Needless to say, these sorts of errors could end up corrupting the database, and I don't think I'm to blame in any way because we haven't gone public with our site, and never have more than 2 members on at once. Can you guys please fix this?

[lnxcode]

This normally only happens if you start abusing mysql for quires. The server just shuts down your connection due to abuse, not that there is anything with the actual server.

I've had support check over the configs on the server, and that seems fine. However, they also did some tweaks for you, and maybe that should improve it.

[Andrew]

Ah, that makes sense. We've been customizing a lot of the pages lately, but we're nearly done with those. Thank you for your help.

[Scott]

How many visitors do you have on your VB site to cause this?

[Andrew]

Today: no more than one person, plus a Google bot for a little while.
Young Writers Online

And now I'm worried again because I got three more error messages. One happened when I was just making a post - right after logging onto the site from after dinner, so there weren't any queries for a long time before that. Then I went into maintenance and did a repair/optimize tables (several needed fixing). The next two happened while trying to make two more posts.

Invalid SQL:

SELECT user.*, subscribethread.emailupdate, subscribethread.subscribethreadid
FROM subscribethread AS subscribethread
INNER JOIN user AS user ON (subscribethread.userid = user.userid)
LEFT JOIN usergroup AS usergroup ON (usergroup.usergroupid = user.usergroupid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid)
WHERE subscribethread.threadid = 42 AND
subscribethread.emailupdate IN (1, 4) AND
subscribethread.canview = 1 AND
CONCAT(' ', IF(usertextfield.ignorelist IS NULL, '', usertextfield.ignorelist), ' ') NOT LIKE ' 1 ' AND
user.usergroupid <> 3 AND
user.userid <> 1 AND
user.lastactivity >= 1191197828 AND
(usergroup.genericoptions & 32);

MySQL Error : Server shutdown in progress
Error Number : 1053
Date : Monday, October 1st 2007 @ 07:24:46 PM
Script : Young Writers Online
Referrer : Young Writers Online
IP Address : 129.2.175.73
Username : Andy
Classname : vB_Database

[Librarian]

I got this same error message today.

Database error in vBulletin :

Invalid SQL:
SELECT varname, value, datatype FROM vb_setting;

MySQL Error : MySQL server has gone away
Error Number : 2006
Date : Monday, October 1st 2007 @ 01:45:05 PM

I find it VERY upsetting since this is the *whole reason* I moved to VPS at HostICan in the first place.

The only bit of good news is that there were only two, and no one on the forums seemed to notice.
The second message said this:

Database error in vBulletin :

Invalid SQL:

SELECT *
FROM vb_datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' adv_modules','adv_portal_cale','adv_portal_home',' adv_portal_opts','adv_portal_page','adv_portal_tps t','attachmentcache','bbcodecache','birthdaycache' ,'eventcache','iconcache','maxloggedin','rankphp', 'smiliecache','userstats');

MySQL Error : MySQL client ran out of memory
Error Number : 2008

I ****Need*** my MySQL server to be able to handle my forum volume. I've got almost 1400 members. I moved to VPS to avoid problems on shared service. Please tell me there's an easy fix.

[lnxcode]

Originally Posted by Librarian

I got this same error message today.



I find it VERY upsetting since this is the *whole reason* I moved to VPS at HostICan in the first place.

The only bit of good news is that there were only two, and no one on the forums seemed to notice.
The second message said this:


I ****Need*** my MySQL server to be able to handle my forum volume. I've got almost 1400 members. I moved to VPS to avoid problems on shared service. Please tell me there's an easy fix.

This would only impact shared hosting. VPS is a diffrent animal altogether.

[Librarian]

Originally Posted by lnxcode

This would only impact shared hosting. VPS is a diffrent animal altogether.

That's the theory anyway, right.


I'm sorry... I hit "new posts" and didn't realize this thread was under Shared when I replied.


But actually, maybe someone can explain why I got this error today when I'm on a VPS.

Actually, I know the answer to this... it's probably because I haven't got my VPS set up correctly.

sigh. There's always more work.

Now I just have to figure out what to do.

[Shazam]

Originally Posted by Librarian

That's the theory anyway, right.


I'm sorry... I hit "new posts" and didn't realize this thread was under Shared when I replied.


But actually, maybe someone can explain why I got this error today when I'm on a VPS.

Actually, I know the answer to this... it's probably because I haven't got my VPS set up correctly.

sigh. There's always more work.

Now I just have to figure out what to do.

Don't despair. There's a solution for everything. File a support ticket if all else fails.

[Librarian]

Originally Posted by Shazam

Don't despair. There's a solution for everything. File a support ticket if all else fails.

Just got three new errors so I'll go file that ticket now.


I'm usually not so easily discouraged, but I'm tired so it's getting me down.

Thanks.