Re: data base problems :(
Posted: 02 Feb 2011, 19:21
I can see it Laura.mrs maggot;15260 wrote:i still cant post (unless it shows up here now)
Page 4 of 5
Re: data base problems :(
Posted: 02 Feb 2011, 20:00
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!
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!
Re: data base problems :(
Posted: 02 Feb 2011, 20:51
Thanks Justin.
Re: data base problems :(
Posted: 02 Feb 2011, 22:07
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
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
Re: data base problems :(
Posted: 02 Feb 2011, 23:08
Justin;15264 wrote: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.
Re: data base problems :(
Posted: 02 Feb 2011, 23:15
Paul;15194 wrote: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.
Re: data base problems :(
Posted: 02 Feb 2011, 23:43
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.
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.
Re: data base problems :(
Posted: 03 Feb 2011, 21:50
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.
Re: data base problems :(
Posted: 04 Feb 2011, 21:01
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
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
Re: data base problems :(
Posted: 04 Feb 2011, 22:47
Justin;15389 wrote: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.