Announcement

Collapse
No announcement yet.

Sudden Error Message

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

  • Sudden Error Message

    Hi guy's, forum has been running well for ages and suddenly today I start getting hundreds of e-mails about this database error. I haven't installed anything new in quite a long time. Could you give me any idea what might be causing this. Thanks a lot.

    Phil.

    Invalid SQL:

    SELECT text, headers, dateline
    FROM externalcache
    WHERE cachehash = '5ef23073eb48c7f713b6db7f085f994c' AND
    dateline >= 1245623719;

    MySQL Error : Got error 134 from storage engine
    Error Number : 1030
    Request Date : Sunday, June 21st 2009 @ 07:35:19 PM
    Error Date : Sunday, June 21st 2009 @ 07:35:19 PM
    Script : http://www.kwas.ca/forum/external.php?type=RSS2&forumids=18
    Referrer :
    IP Address : 209.85.238.19
    Username : Unregistered
    Classname : vB_Database
    MySQL Version :

  • #2
    MySQL Error : Got error 134 from storage engine


    This is the real error, let me type
    locate perror
    and then run /path/to/perror number

    brb

    Comment


    • #3
      back

      imac:~ floris$ /Applications/MAMP/Library/bin/perror 134
      MySQL error code 134: Record was already deleted (or record file crashed)
      imac:~ floris$


      shut down the database for now,
      run optimize and repair from the shell
      and do that a few times,
      open database and try again.

      Comment


      • #4
        Hi Floris, thank you. I just shut it down about 25 minutes ago and found all sorts of issues in the repair/optimize table screen. Ran the optimize and repair and all the errors have been resolved. I'll turn the forum back on and see what happens. Any thoughts on why this suddenly happened?

        Comment


        • #5
          corruption? overhead?

          Comment


          • #6
            Looks like we're good to go. Thank you very much for the replies. Keep up the great work. You guys and gals are the best!

            Phil.

            Comment


            • #7
              I am not part of the team anymore, but thanks for the positive feedback.

              Comment

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