Go Back   Admin Zone Forums > The Software Zone > Forum Software > vBulletin

vBulletin Discuss vBulletin.

Reply
 
Thread Tools

  #1  
Old 11-23-2005, 07:33 PM
plebebo plebebo is offline
TAZ Rookie
 
Join Date: Aug 2005
Admin Experience: Intermediate
Posts: 2
plebebo is on a distinguished road
Mysql error 1030: Got Error 5 from table handler?
Has anyone heard of this before? I have been searching google for an hour now and we have over 400 missing members. Trying to find out why and what the source. I was told it is a server error.

Here's the last report I got before shutting the forum down.

Database error in vBulletin 3.0.8:

Invalid SQL:
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS
hascustomavatar, customavatar.dateline AS avatardateline,

NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS
del_userid, deletionlog.username AS del_username, deletionlog.reason AS
del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username,
editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
post_parsed.pagetext_html, post_parsed.hasimages,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid =
user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN
customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid
AND deletionlog.type = 'post')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
WHERE post.postid IN (0,2069,2079,2811,2903,2992,3120,4026,4279,4290,43 30)
ORDER BY dateline

mysql error: Got error 5 from table handler

mysql error number: 1030

Date: Thursday 24th of November 2005 12:54:20 AM
Script: http://projectpcf.com/showthread.php?t=701
Referer: https://projectpcf.com/forumdisplay.php?f=5


Here's the very first report that started this thing with error 5 from table handler:

Database error in vBulletin 3.0.8:

Invalid SQL:
SELECT user.joindate, user.userid, user.membergroupids, user.posts,
user.reputation,
user.usergroupid, user.displaygroupid, user.customtitle, user.username,
userpromotion.joinusergroupid, userpromotion.reputation AS jumpreputation,
userpromotion.posts AS jumpposts,
userpromotion.date AS jumpdate, userpromotion.type,
userpromotion.strategy,
usergroup.title, usergroup.usertitle AS ug_usertitle
FROM user AS user
LEFT JOIN userpromotion AS userpromotion ON (user.usergroupid =
userpromotion.usergroupid)
LEFT JOIN usergroup AS usergroup ON (userpromotion.joinusergroupid =
usergroup.usergroupid)
WHERE user.lastactivity >= -3567
mysql error: Got error 5 from table handler

mysql error number: 1030

Date: Thursday 24th of November 2005 12:26:40 AM
Script: http://www.projectpcf.com/cron.php?&rand=388676
Referer:
Username: HugoG
IP Address:

I have been to vbulletin.com and was told this is a rare error but it is a server error. I cannot find anything on the google searches I am preforming and my host hasnt seen this one before. The 400 plus members are completely gone from the database, from 1300 plus down to 400plus and all gone who registered from the 21st of Oct to present date. There was a mysql error on 21st of Nov and the Mysql had stopped and had to be rebooted, by my host. Those dates both being the 21st are interesting to me

I can do a restore from a backup from the 21st of Nov but will still lose some members and posts and data.

If anyone has any experience or has seen this before or can direct me to any documentation, I will be very grateful.

If I have posted this in error or should have posted this on this board, my apologies and feel free to delete.

Thanks for any help or advice or direction.

plebebo
Reply With Quote
  #2  
Old 11-23-2005, 08:08 PM
AWS's Avatar
AWS AWS is offline
Tazmanian
 
Real Name: Bob
Join Date: Jan 2004
Admin Experience: Guru
Location: Joliet, IL
Age: 59
Posts: 1,101
AWS is a jewel in the rough
Default
This error is a disk i/o error. Looks to me like it wrote the missing data to part of an array or disk that is bad or going bad. More than likely the missing data is unrecoverable.
__________________
Android Forum
Reply With Quote
  #3  
Old 11-23-2005, 08:13 PM
AWS's Avatar
AWS AWS is offline
Tazmanian
 
Real Name: Bob
Join Date: Jan 2004
Admin Experience: Guru
Location: Joliet, IL
Age: 59
Posts: 1,101
AWS is a jewel in the rough
Default
This can also be caused when the server reboots without properly shutting down mysql first as it is writing data to a table.
You could try a repair on the db.
__________________
Android Forum
Reply With Quote
  #4  
Old 11-23-2005, 08:17 PM
plebebo plebebo is offline
TAZ Rookie
 
Join Date: Aug 2005
Admin Experience: Intermediate
Posts: 2
plebebo is on a distinguished road
Default
Thank you very much for the reply. I will pass this info to our host and do the backup restore and accept the lost data. Of course, I will ask to be moved from that server as we have had intermittant mysql reboot needs, in the recent past.

I guess it re-wrote the info to the bad area or going bad area maybe when we did an optimize and repair tables, does this make logic to you?

Ok just saw your other post, I will request a repair try and see if that works.

Again, I appreciate your reply and help!

plebebo
Reply With Quote
Reply

  Admin Zone Forums > The Software Zone > Forum Software > vBulletin





Currently Active Users Viewing this Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL Server Tweaking Basics PerfectSQL Servers and Hosting 128 02-10-2014 02:31 AM
PHPBB, mySQL, and locked tables CheapyD phpBB 8 05-07-2006 04:20 AM
mysql table overhead? phoenixdown21 Servers and Hosting 4 09-29-2005 02:30 PM
Can't add a table to top of index MMM General Programming Discussions 3 04-30-2005 03:04 PM
Not sure where to post this (mysql errors) Evermeet General Programming Discussions 5 04-27-2004 09:00 PM


 

All times are GMT -4. The time now is 11:19 PM.


Powered by: vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Page generated in 0.05716801 seconds with 13 queries
The Admin Zone copyright 2003-2014 All Rights Reserved. Content published on The Admin Zone requires permission for reprint.