Announcement

Announcement Module
Collapse
No announcement yet.

mysql_upgrade fails

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • mysql_upgrade fails

    mysql_upgrade fails if enforce_storage_engine=InnoDB.

    Is this a bug or it should work this way?

  • #2
    https://bugs.launchpad.net/percona-server/+bug/1218664

    Comment


    • #3
      Hi,

      Can you tell us which PS server version you are using? You are right about that bug but there is workaround at the last comment. Have you tried to run mysql_upgrade with --skip-grant-tables and check? Please let us know. Thanks.

      Comment


      • #4
        Percona-XtraDB-Cluster-galera-3-3.3-1.207.rhel6.x86_64
        Percona-XtraDB-Cluster-shared-56-5.6.15-25.4.731.rhel6.x86_64
        Percona-XtraDB-Cluster-server-56-5.6.15-25.4.731.rhel6.x86_64
        Percona-Server-shared-compat-5.5.35-rel33.0.611.rhel6.x86_64
        Percona-XtraDB-Cluster-client-56-5.6.15-25.4.731.rhel6.x86_64

        Percona docs should have reference to related bugs.
        We were able to fix database by replacing corrupt mysql tables.
        Database started and then we were able to perform complete mysqldump.

        Comment

        Working...
        X