← Back to team overview

randgen team mailing list archive

[Bug 773237] Re: Recovery Reporter fails when default storage engine is InnoDB and --engine is not InnoDB

 

Philip, thanks for the comment. I am OK with going for option 1) too. I
can do the change myself.

-- 
You received this bug notification because you are a member of Random
Query Generator Team, which is subscribed to Random Query Generator.
https://bugs.launchpad.net/bugs/773237

Title:
  Recovery Reporter fails when default storage engine is InnoDB and
  --engine is not InnoDB

Status in SQL Generator for testing SQL servers (MySQL, JavaDB, PostgreSQL):
  New

Bug description:
  The Recovery Reporter is incompatible with MySQL Server 5.5 and newer,
  where the default storage engine is InnoDB instead of MyISAM, in cases
  where --engine (the RQG option) is not set to be InnoDB.

  Recovery fails with STATUS_DATABASE_CORRUPTION because the server
  could not start on recovery, due to the following fatal error:

      [ERROR] Unknown/unsupported storage engine: InnoDB

  The reason is that if --engine=MyISAM (or something else that is not
  InnoDB) the Recovery Reporter adds "--loose-skip-innodb" to the
  server's command line options on recovery startup.

  Possible solutions:
    1) Remove --loose-skip-innodb from startup options in the Recovery Reporter.
    2) Remove --loose-skip-innodb from startup options in the Recovery Reporter if MySQL version is 5.5 or greater.
    3) Add --default-storage-engine=$engine whenever --engine is not set to InnoDB.


References