randgen team mailing list archive

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

Should be fixed in lp:randgen revid
john.embretsen@xxxxxxxxxx-20110513143626-n47adhpfw8uksyw2:

revno: 742
committer: John H. Embretsen <john.embretsen@xxxxxxxxxx>
branch nick: randgen-testrun
timestamp: Fri 2011-05-13 16:36:26 +0200
message:
  Fix for Bug#773237 (on Launchpad): Recovery Reporter fails when default storage engine is InnoDB and --engine is not InnoDB
  The fix implements solution option 1), i.e. it removes --loose-skip-innodb from startup options in the Recovery Reporter.
  The downside is that recovery time may increase, the upside is that the Recovery reporter works also when InnoDB is the default storage engine.


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

-- 
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 Committed

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.