data base problems :(

[Ian M]

i still cant post (unless it shows up here now)

I can see it Laura.

[Justin]

Awaiting contact from the host company now. I've asked for a full explanation as to how this has happened, when the problems will be rectified and what will be done to avoid this happening again in the future. I would prefer not to change hosts again as other than this situation the service has been superb and downtime has been zero but if I cannot be given certain guarantees I will be forced to make changes.

This is an incredibly frustrating time for all of us, please accept my apologies on behalf of the host company and reassurance that I will be doing everything I can to get us running properly again asap!

[Ian M]

Thanks Justin.

[smitch6]

Thanks Justin
i speak from experience that its hard work when it goes wrong
i've spent 2 whole days trying to get mine back
my forum is up and working ok but my chat room is still down
the software is supplied by the chinese and its their new year so they are all away

such bad support

my hosting comp have been brill helping out but they can't do the chat unfortunately
but mine just blipped the other day for no reason and the whole lot went down

well weird

[JSR]

Awaiting contact from the host company now. I've asked for a full explanation as to how this has happened, when the problems will be rectified and what will be done to avoid this happening again in the future. I would prefer not to change hosts again as other than this situation the service has been superb and downtime has been zero but if I cannot be given certain guarantees I will be forced to make changes.

This is an incredibly frustrating time for all of us, please accept my apologies on behalf of the host company and reassurance that I will be doing everything I can to get us running properly again asap!

I'm curious to know what the problem is. Unless they've upgraded something without telling you, it's hard to imagine what would cause it to suddenly play up like this - especially as it's now been a few days.

[JSR]

same here. 5 pm's in the inbox and can not read them

this is what I can see when trying to go in to my inbox:




Database error in vBulletin 4.1.0:

Invalid SQL:

SELECT pm.*, pmtext.*
, icon.title AS icontitle, icon.iconpath
FROM vb_pm AS pm
LEFT JOIN vb_pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN vb_icon AS icon ON(icon.iconid = pmtext.iconid)
WHERE pm.userid=4 AND pm.folderid=0

ORDER BY pmtext.dateline DESC
LIMIT 0, 50;

MySQL Error : Can't create/write to file '/tmp/#sql_56a7_0.MYI' (Errcode: 28)
Error Number : 1
Request Date : Monday, January 31st 2011 @ 09:18:36 PM
Error Date : Monday, January 31st 2011 @ 09:18:36 PM
Script : http://www.dyesubforum.co.uk/vbforum/private.php
Referrer : http://www.dyesubforum.co.uk/vbforum/forum.php
IP Address : 86.30.255.145
Username : Paul
Classname : vB_Database
MySQL Version : 5.0.91-community

That error looks suspiciously similar to the error posted here : http://www.vbulletin.com/forum/showthre ... base-Error.

The problem in that instance appears to be caused by insufficient MySQL space, or insufficient /tmp space. I wonder if MySQL is on a different partition to the rest of the website?

Edit -

I see Justin already has this information from the same forum, re: http://www.vbulletin.com/forum/showthre ... base-Error, although the "help" he's getting is a touch on the arrogant side. It's the server's fault and "if the host don't fix it, they shouldn't be hosting". The host can't be expected to account for the flaws in every piece of software that might potentially be installed on their servers. I've run a few different forum platforms in the past (not vBulletin), and none have ever had /tmp space problems.

[Justin]

We thought the issue was with the /tmp space but upon checking found this to be more than adequate. It then looked to be the number of inodes so this was increased greatly and the /tmp partition was formatted. All errors went away and I thought we were back to normal but it quickly appeared tables were being corrupted (as they still are) I'm expecting a full explanation from our host company and will resolve matters as quickly as I possibly can whatever this takes.
The support given on the VB forum as you've seen has been less than useful but this has always been the case no matter what platform I use.

[Justin]

All issues should now have been resolved, I am awaiting an explanation and will detail when I get this. Please let me know if you notice anything different/strange.

[Justin]

For anyone who's interested in the techy stuff.....

It was a lack of space in the /tmp folder that was causing the problems, this was supposedly rectified some days back but it appears the changes weren't saved by a technician and had to be done again. Changes have been made to ensure this cannot happen again

[JSR]

For anyone who's interested in the techy stuff.....

It was a lack of space in the /tmp folder that was causing the problems, this was supposedly rectified some days back but it appears the changes weren't saved by a technician and had to be done again. Changes have been made to ensure this cannot happen again

I'm curious to know what size it was and what size it was increased to.