randgen team mailing list archive

["John H. Embretsen" <773237@xxxxxxxxxxxxxxxxxx>]

** Changed in: randgen
       Status: Fix Committed => Fix Released

-- 
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):
  Fix Released

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.

To manage notifications about this bug go to:
https://bugs.launchpad.net/randgen/+bug/773237/+subscriptions