Not the answer you need?
Register and ask your own question!

mysql_upgrade fails

jaiguptajaigupta ContributorCurrent User Role Beginner
mysql_upgrade fails if enforce_storage_engine=InnoDB.

Is this a bug or it should work this way?

Comments

  • niljoshiniljoshi MySQL Sage Inactive User Role Beginner
    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.
  • jaiguptajaigupta Contributor Current User Role Beginner
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.