Quick question regarding: forums.user... warning : Table is marked as crashed

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • john2k
    Senior Member
    • Jul 2000
    • 363

    Quick question regarding: forums.user... warning : Table is marked as crashed

    Been dealing with a server issue lately, or possibly datacenter failing/unstable PDU, which has been causing spontaneous reboots. Has happened a few times so far and I expect to have the source issue corrected very soon.

    After the spontaneous reboots, usually the db ends up with '# clients are using or haven't closed the table properly' type issues along with a seemingly unimportant table having crashed (usually humanverify table).

    Today, however, the users table reported crashed/corrupt:

    Code:
    forums.user
    warning  : Table is marked as crashed
    warning  : 2 clients are using or haven't closed the table properly
    error    : Checksum for key:  6 doesn't match checksum for records
    error    : Corrupt
    That was the partial result of the following command: "mysqlcheck -c forums"

    After running: "mysqlcheck -r forums" to repair, all seems good:

    Code:
    forums.user                                OK
    My question(s):

    Is the user table now fine / repaired without any corruption in the text of the database records?

    Being that the user table is relatively important, my concerns are that maybe now there could be random user records in that table with messed up information which is not detected as an error by mysqlcheck. Is that possible?

    What's the likelihood that this crash/corruption caused further undetected issues?

    I'm probably just being paranoid about it, but maybe somebody here who knows more about these things can help me better understand all of this.

    Any input / advice is much appreciated.
    ...john2k...
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 73981

    #2
    Records could be corrupted during a repair. They will no longer be usable. Those users won't be able to login and will need to register a new account. You should perform daily or weekly backups to safeguard your data. Your hosting provider can provide tools to do this.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    • john2k
      Senior Member
      • Jul 2000
      • 363

      #3
      Originally posted by Wayne Luke
      Records could be corrupted during a repair. They will no longer be usable.
      Does that apply only for tables which are crashed/corrupted?

      How about tables that were already reporting as "OK"? Would those "OK" tables be potentially corrupted when the repair operation is performed upon the entire database with the following type of command: "mysqlcheck -r database_name" ? Or, would the "OK" tables not be touched by the repair so no risk of potential corruption from the repair?

      I'm asking about that because previously I was thinking that "OK" tables were essentially untouched, but now I'm wondering if maybe running 'mysqlcheck -r' could potentially cause issues with tables that have been reporting as 'OK' when the repair operation targets the entire database.

      Originally posted by Wayne Luke
      You should perform daily or weekly backups to safeguard your data. Your hosting provider can provide tools to do this.
      I have lots of backup files. Perform the backups via Linux shell commands.

      Being that you mentioned backups, is it generally preferred to only use 'mysqlcheck -r database_name" repairs as a last resort?
      Last edited by john2k; Fri 2 Mar '18, 5:50pm.
      ...john2k...

      Comment

      • Wayne Luke
        vBulletin Technical Support Lead
        • Aug 2000
        • 73981

        #4
        Only tables marked as crashed can receive corruption. Ideally, you would be using INNODB tables with today's versions of MySQL so the likelihood of having tables that crash is severely diminished.

        You should only run repair utilities on the tables that having problems. When using MYISAM and running repairs on healthy tables, you can cause them to fail.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API

        Comment

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