Announcement

Collapse
No announcement yet.

Constant DB errors

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Constant DB errors

    About 3 weeks ago, the POST table went corrupt with:

    mysql error: Got error 127 from table handler
    mysql error number: 1030


    The specific errors vary. I repaired the table via mysqlcheck. Since then, every day, the same error occurs and the same table goes corrupt at least once a day. I've been repairing it daily, but it keeps corrupting. I shut down the DB yesterday and ran myisamchk on the index files of the post.myi but just a few minutes ago the errors began. Most of the time, the errors go away on their own, however, other times, users are no longer able to post and get DB errors diplayed. A few times, the postindex table corrupted as well. As far as I know, NOTHING changed to the system when the errors starting happening. I've been running vB 3.0.7 w/ mySQL 4.0.16 for some time now without a hiccup and now this. It's a dedicated Windows server and I have full control of it. The DB is maybe 700mb.

    Can anyone assist with what may be happening here? I read about the bug in mySQL 4.0.12, but that's not the version I'm running and as I mentioned, I've been running 4.0.16 for a VERY long time without issues. TIA!!

  • #2
    You should really upgrade, or get your host to upgrade to 4.0.24. I think the DB corrupution stops after 4.0.17

    What are the rest of the errors? IT really helps if we know them all.

    Comment


    • #3
      yes upgrade to MySQL 4.0.24 and read this thread http://www.vbulletin.com/forum/showthread.php?t=69803 to see how to handle such corruption
      :: Always Back Up Forum Database + Attachments BEFORE upgrading !
      :: Nginx SPDY SSL - World Flags Demo [video results]
      :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

      Comment


      • #4
        Ok, I can certainly upgrade. I guess I just don't understand why things were working so well for so long w/o any issues. I suppose this is as good a time to upgrade as any. Thanks guys!

        Comment


        • #5
          Originally posted by Zachery
          What are the rest of the errors? IT really helps if we know them all.
          Well, all the errors are 127/1030, but the descriptions vary as such, for example:

          Invalid SQL:
          SELECT post.*,
          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.dateline AS edit_dateline, editlog.reason AS edit_reason
          FROM post AS post
          LEFT JOIN deletionlog AS deletionlog ON (deletionlog.primaryid = post.postid AND deletionlog.type = 'post')
          LEFT JOIN editlog AS editlog ON (editlog.postid = post.postid)
          WHERE post.postid = 1020018

          mysql error: Got error 127 from table handler

          mysql error number: 1030


          ------------------------------------

          Invalid SQL:
          SELECT postid FROM post AS post
          LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND type = 'post')
          WHERE threadid = 15265 AND visible = 1 AND deletionlog.primaryid IS NULL
          ORDER BY dateline
          LIMIT 0, 10

          mysql error: Got error 127 from table handler

          mysql error number: 1030


          ------------------------------------

          Invalid SQL:
          SELECT filename, attachment.postid, attachment.userid, attachmentid,
          attachment.dateline, SUBSTRING(filedata, 1, 2097152) AS filedata, filesize,
          attachment.visible, mimetype, NOT ISNULL(deletionlog.primaryid) AS isdeleted,
          thread.forumid, forum.password, thread.threadid
          FROM attachment AS attachment
          LEFT JOIN attachmenttype AS attachmenttype ON(attachmenttype.extension = SUBSTRING_INDEX(attachment.filename, '.', -1))
          LEFT JOIN deletionlog AS deletionlog ON(attachment.postid = deletionlog.primaryid AND type = 'post')
          LEFT JOIN post AS post ON (post.postid = attachment.postid)
          LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)
          LEFT JOIN forum AS forum ON (forum.forumid = thread.forumid)
          WHERE attachmentid = 44206

          mysql error: Got error 127 from table handler

          mysql error number: 1030


          ------------------------------------

          Invalid SQL:
          SELECT
          IF(votenum >= 2, votenum, 0) AS votenum,
          IF(votenum >= 2 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
          post.pagetext AS preview,
          thread.threadid, thread.title AS threadtitle, lastpost, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
          lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach


          FROM thread AS thread


          LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
          WHERE thread.threadid IN (0,106909,106749,106281,104268,105935,106835,106770,106758,105958,106630,79968,96969,10645 4,43303,106525,106112,105770,106339,106422,106293,106117,105979,105933,106016,105950,10593 2,105704,105730,105347,105769,105539,105446,105714,104199,105464,104574,105583,105159,1054 34,104010)
          ORDER BY sticky DESC, lastpost DESC

          mysql error: Got error 127 from table handler

          mysql error number: 1030


          ------------------------------------

          Invalid SQL:
          SELECT post.pagetext AS preview,
          thread.threadid, thread.threadid AS postid, thread.title AS threadtitle, thread.iconid AS threadiconid,
          thread.replycount, IF(thread.views=0, thread.replycount+1, thread.views) as views, thread.sticky,
          thread.pollid, thread.open, thread.lastpost AS postdateline,
          thread.lastpost, thread.lastposter, thread.attach, thread.postusername, thread.forumid,
          user.userid AS postuserid
          , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
          FROM thread AS thread
          LEFT JOIN user AS user ON(user.userid = thread.postuserid)
          LEFT JOIN subscribethread AS subscribethread
          ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 20671)
          LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
          WHERE thread.threadid IN
          (106936, 106840, 106916, 106927, 104427, 106933, 105744, 106762, 100359, 105887, 106935, 106934, 106648, 106798, 106746, 106924, 106663, 106932, 106913, 106570, 106847, 105105, 106901, 106832, 106931)
          mysql error: Got error 127 from table handler

          mysql error number: 1030


          ------------------------------------

          Any further thoughts or should I just upgrade? Thanks again.

          Comment


          • #6
            mysql error: Got error 127 from table handler thats the only importat one

            Comment


            • #7
              Originally posted by Zachery
              mysql error: Got error 127 from table handler thats the only importat one
              I was just trying to be helpful

              Ok, I will go ahead and upgrade. I'm running php 4.3.4. Any issues with that version of php and mySQL 4.0.24?

              Comment


              • #8
                You very urgently need to upgrade php as well, there are several large security issues with 4.3.4.

                Best off with 4.3.11(php) and 4.0.24(mysql)

                Comment


                • #9
                  Originally posted by Zachery
                  You very urgently need to upgrade php as well, there are several large security issues with 4.3.4.

                  Best off with 4.3.11(php) and 4.0.24(mysql)
                  Man, you're just trying to create more work for me aren't you??

                  Ok, I will upgrade php as well. Thanks!

                  Comment


                  • #10
                    Well you don't want anyone gaining system access do you?

                    Comment


                    • #11
                      Originally posted by Zachery
                      Well you don't want anyone gaining system access do you?
                      Didn't you read above that I'm running a Windows server? I don't think the door can be opened any wider We are moving to Linux very shortly to also help mitigate performance issues.

                      Comment


                      • #12
                        Theres nothing wrong with windows, it makes an exelent server platform

                        Comment


                        • #13
                          Originally posted by Zachery
                          Theres nothing wrong with windows, it makes an exelent server platform
                          Dear Zachery Gates-

                          Someone at Jelsoft must be serving some REALLY good Kool-Aid!

                          Comment


                          • #14
                            Ok, updated both php and mySQL as recommended. Upgrade went smooth as usual. If we can make it 48hrs w/o a hiccup then we've solved the corruption issue. Will keep you posted. Thanks again!

                            Comment


                            • #15
                              Well, everything was ok until I started getting tons of Link-ID == false, connect failed errors. Are there any issues with php 4.3.11 or mySQL 4.0.24 that would cause this? I've NEVER had this error before after the forums were running. I increased max_connections from 400 to 650. Are there any variables I need to be concerned with changing with this upgrade??

                              Comment

                              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                              Working...
                              X