Advanced Dies with serious warnings

[slinky]

For reasons I can't explain Dynamics died without reason and I got the following error messages in email and also when someone tries accessing the files area where dynamics is installed. That URL is below and I get a vBulletin error message. Unfortunately this is crticial since dynamics is also a main category in our menu system. Hopefully someone has a solution quickly...


Database error in vBulletin 3.7.1:

Invalid SQL:
SELECT user.*, entries.entryid, entries.title, entries.catid, entries.userid, entries.username, entries.views, open, entries.valid, entries.dateline, hasattach, votenum, votetotal, entries.iconid, caticon, icon.title as icontitle, icon.iconpath, IF(user.options & 512, 1, 0) AS invisible, entries.posts AS posts, avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision, customfields.* , NOT ISNULL(subscribeentry.entryid) AS issubscribed, entries.lastpostid, entries.lastpostdateline, entries.lastpostuserid, entries.lastpostusername, NOT ISNULL(favorites.entryid) AS isfavorite, pagetext, pagetext_parsed, hasimages, attachment.attachmentid, attachment.hasthumb, attachment.filename, attachment.dateline AS attachdateline, extension, attachment.userid AS attachuserid
FROM adv_dyna_entries AS entries

LEFT JOIN adv_dyna_categories AS categories ON (entries.catid = categories.catid)
LEFT JOIN icon AS icon ON (entries.iconid = icon.iconid)
LEFT JOIN user AS user ON (entries.userid = user.userid)
LEFT JOIN avatar as avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar as customavatar ON (customavatar.userid = user.userid)
LEFT JOIN adv_dyna_cfields_entries AS customfields ON (entries.entryid = customfields.eid)
LEFT JOIN adv_dyna_subscribeentry AS subscribeentry ON (entries.entryid = subscribeentry.entryid AND 380 = subscribeentry.userid) LEFT JOIN adv_dyna_favorites AS favorites ON (favorites.entryid = entries.entryid AND favorites.userid = 380) LEFT JOIN adv_dyna_entries_pages AS entries_pages ON (entries.entryid = entries_pages.entryid AND entries_pages.pagenumber = 1) LEFT JOIN adv_dyna_entryparsed AS entryparsed ON (entries.entryid = entryparsed.entryid AND entryparsed.languageid = 0 AND entryparsed.styleid = 21 AND entryparsed.pagenumber = 1)LEFT JOIN adv_dyna_attachments AS attachment ON (entries.attachid = attachment.attachmentid)
WHERE entries.valid = 1 AND draft = 0 AND entries.entryid IN(1,10,13,7,2,9,4,3,11,6,5,8)
ORDER BY RAND()
LIMIT 5;

MySQL Error : Got error 28 from storage engine
Error Number : 1030
Request Date : Friday, August 29th 2008 @ 10:31:38 AM
Error Date : Friday, August 29th 2008 @ 10:31:38 AM
Script : http://www.mysite.com/files/
Referrer : http://www.mysite.com/forums/showthread.php?t=1598
IP Address : 123.4.5.6
Username : username
Classname : vB_Database
MySQL Version : 4.1.22-standard

[aproape]

Hi there slinky,

Your main indication/error here I think is:

"Got error 28 from storage engine"

which.. normally.. signifies that MySQL has ran out of diskspace [physically] to write data/manage the tables.

Can you check and confirm?

Just thought this might help..


Cheers,
aproape

[slinky]

aproape - Thanks much for the reply but that's not the case. I've got an unlimited (well, mostly) account on my own dedicated server and it doesn't seem to be a size related problem. cpanel is also reporting no problems and I'd usually get a warning for size space. I can also make posts in the forum...

[aproape]

Hi there slinky,

Are there any limitations of some sorts on the database settings/space? Temporary tables or folders.. ? Maybe the /tmp is stored on a different partition or has other limits?

[the Cpanel could alert you on free space but this can be configured to also happen only on /home or other places/partitions which do _not_ include MySQL data.. ]

The forum tables are stored in separate tables and the result could _sligthly_ vary..

Even if there is a lot of space left, the query you are executing may need to create temporary tables and such during its execution, which will obviously require extra space.

Check this MySQL official support forum as well - for a quick explanation:

http://forums.mysql.com/read.php?21,...6967#msg-36967

Let us know if that helped.. hmm..


Cheers,
aproape

[Brian]

That error does mean that something to do with MySQL on your server is out of space. If you're sure you're physical drives are fine then you may want to try emptying your /tmp directory.

[slinky]

Yes... thanks guys. This is the problem. Unfortunately I'm seeing from WHM a tmpDSK usage as follows:

/usr/tmpDSK 485M 460M 142K 100% /tmp

Now the problem is how to clean it up. I just see a lot of user session files in the tmp directory and can't figure out how it gets to 460M. I'm also not sure how to clean this up without deleting something important, as there are always files in use in the tmp directory that could be important.

Thanks SO MUCH for the quick responses guys... truly amazing, really. Glad it wasn't a VBadvanced issue but now I've got to figure out the best way to proceed...

[slinky]

I just wanted to thank you guys for IMMEDIATE support - and I mean, lightning quick within moments of posting here. You were right - some of my caching was filling up the tmp directory and now it needed to be moved to a new partition. Unfortunately cpanel wasn't exactly on the spot with a warning! All should hopefully be restored quickly...