• Sven Sandberg's avatar
    BUG#38068: binlog_stm_binlog fails sporadically in pushbuild · a73626ad
    Sven Sandberg authored
    Problem: binlog_stm_binlog runs INSERT DELAYED queries, and
    then prints the contents of the binlog. Before checking the
    contents of the binlog, the test waits until the rows have
    appeared in the table. However, this is not enough, since
    INSERT DELAYED does not write rows to the binlog at the same
    time as it writes them to the table. So there is a race.
    Fix: Add a FLUSH TABLES before SHOW BINLOG EVENTS. That
    waits until the insert_delayed thread is done.
    
    
    mysql-test/extra/binlog_tests/binlog_insert_delayed.test:
      - Added FLUSH TABLES, so that SHOW BINLOG EVENTS becomes
      deterministic.
      - Added comments.
      - Removed unnecessary 'set @@session.auto_increment_increment'
      statements.
      - Removed unnecessary check that the number of rows inserted
      to the table is 11.
    mysql-test/suite/binlog/r/binlog_stm_binlog.result:
      updated result file
    a73626ad
binlog_insert_delayed.test 2.16 KB