No announcement yet.

Mysql post errors

  • Filter
  • Time
  • Show
Clear All
new posts

  • Mysql post errors

    We were getting some Mysql errors this morning. Turned off the forum and ran the repair tables query several times and continue to get errors for "post" and "postindex".

    What are the next steps that need to be taken? Please provide step-by-step instructions. Thanks.

    post Check Warning: Table is marked as crashed and last repair failed
    post Check Warning: 1 clients is using or hasn't closed the table
    post Check Warning: Size of indexfile is: 8316928 Should be: 3863552
    post Check Error: Size of datafile is: 88949600 Should be: 88949808
    post Check Error: Corrupt
    postindex Check Warning: Table is marked as crashed and last repair
    postindex Check Status: OK
    postindex Optimize Error: Can't write indexblock, error: 122
    postindex Optimize Status: Operation failed

  • #2
    Just wanted to bump this back up. Anybody have any suggestions?


    • #3
      System error: 122 = Disk quota exceeded

      Threre's your problem. You don't have enough disk space to complete the repair operation.
      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
      Change CKEditor Colors to Match Style (for 4.1.4 and above)

      Steve Machol Photography

      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


      • #4
        Thank you Steve. That took care of it.


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