Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7483

WHM/CPanel Server Errors - Database corruption

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.0.15-galera
    • N/A
    • OTHER
    • None
    • WHM 11.47.9980 (build 9)

    Description

      [22:27:45 server root@5997911 ~]cPs# tail /var/lib/mysql/server.brandyou.in.err
      2015-01-20 22:27:25 7fdb46fb6700 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is BINARY(4) NOT NULL but should be INT NOT NULL (type mismatch).
      2015-01-20 22:27:25 7fdb46fb6700 InnoDB: Error: Fetch of persistent statistics requested for table "photoz_wp84"."wp_wfVulnScanners" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
      2015-01-20 22:27:25 7fdb46fb6700 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is BINARY(4) NOT NULL but should be INT NOT NULL (type mismatch).
      2015-01-20 22:27:25 7fdb46fb6700 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is BINARY(4) NOT NULL but should be INT NOT NULL (type mismatch).
      2015-01-20 22:27:25 7fdb46fb6700 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is BINARY(4) NOT NULL but should be INT NOT NULL (type mismatch).
      2015-01-20 22:27:25 7fdb46fb6700 InnoDB: Error: Fetch of persistent statistics requested for table "photoz_wp84"."wp_wfLockedOut" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
      2015-01-20 22:27:25 7fdb4cbff700 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is BINARY(4) NOT NULL but should be INT NOT NULL (type mismatch).
      2015-01-20 22:27:25 7fdb4cbff700 InnoDB: Error: Fetch of persistent statistics requested for table "photoz_wp84"."wp_wfLeechers" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
      2015-01-20 22:27:25 7fdb4cbff700 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is BINARY(4) NOT NULL but should be INT NOT NULL (type mismatch).
      2015-01-20 22:27:25 7fdb4cbff700 InnoDB: Error: Fetch of persistent statistics requested for table "photoz_wp84"."wp_wfHits" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.

      Attachments

        Activity

          People

            Unassigned Unassigned
            shivam Shivam
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.