BIND 10 #2972: MySqlLeaseMgrTest.checkVersion in lib/dhcpsrv fails in some environments

[BIND 10 Development]

#2972: MySqlLeaseMgrTest.checkVersion in lib/dhcpsrv fails in some environments
-------------------------------------+-------------------------------------
                   Reporter:  tmark  |                 Owner:
                       Type:         |                Status:  new
  defect                             |             Milestone:  DHCP
                   Priority:         |  Outstanding Tasks
  medium                             |              Keywords:
                  Component:         |             Sensitive:  0
  dhcpdb                             |           Sub-Project:  DHCP
               CVSS Scoring:         |  Estimated Difficulty:  0
            Defect Severity:         |           Total Hours:  0
  Medium                             |
Feature Depending on Ticket:         |
        Add Hours to Ticket:  0      |
                  Internal?:  0      |
-------------------------------------+-------------------------------------
 The unit test fails on some VMs (notably 2 Debian6 VMs) but not all. The
 test fail with a status of MYSQL_NO_DATA in the result set fetch in
 MySqlLeaseMgr::getVersion().
 This appears to be due to the use of autocommit and the read of the
 version table occuring before the insert of its data has been flushed.  By
 added a "start transaction" at the beginning of the create statement in
 schema_copy.h and a "commit" to the end, the test passes.  Explicit
 transactions cause InnoDB to flush its modfication logs immediately.

 Note this test does not fail in all environments.

-- 
Ticket URL: <http://bind10.isc.org/ticket/2972>
BIND 10 Development <http://bind10.isc.org>
BIND 10 Development