Mysql error 1030: Got Error 5 from table handler?

Discussion in 'vBulletin' started by plebebo, Nov 23, 2005.

  1. plebebo

    plebebo Neophyte

    4
    0
    +0
    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,4330)
    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
     
  2. AWS

    AWS Long Time Gone

    2,898
    742
    +305
    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.
     
  3. AWS

    AWS Long Time Gone

    2,898
    742
    +305
    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.
     
  4. plebebo

    plebebo Neophyte

    4
    0
    +0
    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
     
Verification:
Draft saved Draft deleted