Bug #58053 | rpl_seconds_behind_master fails mysqltest: At line 66 | ||
---|---|---|---|
Submitted: | 8 Nov 2010 14:32 | Modified: | 2 Oct 2012 9:52 |
Reporter: | Andrei Elkin | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Replication | Severity: | S3 (Non-critical) |
Version: | 5.6 | OS: | Any |
Assigned to: | Luis Soares | CPU Architecture: | Any |
[8 Nov 2010 14:32]
Andrei Elkin
[17 Nov 2010 11:53]
Luis Soares
This has been failing sporadically for some time now. I have observed these failures in the following trees: - mysql-next-mr-opt-backporting - mysql-next-mr-bugfixing - mysql-next-mr-wl4034 - mysql-trunk-merge - mysql-next-mr-wl4896 - daily-trunk-bugfixing - mysql-next-mr-wl2540 Another interesting fact is that rpl_seconds_behind_master failures happened only when binlog_format=statement. My initial suspicions are that, either: 1. assertions in the test that depend on timings are bad 2. or, that Query_log_event::exec_time may have unexpected value (eg, it was not properly initialized), causing seconds_behind_master to show smaller value than it should. See this snippet on rpl_slave.cc: if (!(ev->is_artificial_event() || ev->is_relay_log_event() || (ev->when == 0) || ev->get_type_code() == FORMAT_DESCRIPTION_EVENT)) { rli->last_master_timestamp= ev->when + (time_t) ev->exec_time; DBUG_ASSERT(rli->last_master_timestamp >= 0); } Nonetheless, these are just hints, need further analysis.
[24 Nov 2010 11:08]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/124843 3204 Luis Soares 2010-11-24 BUG#58053: rpl_seconds_behind_master fails mysqltest: At line 66 Made test case experimental.
[29 Nov 2010 11:12]
Bugs System
Pushed into mysql-trunk 5.6.1-m5 (revid:alexander.nozdrin@oracle.com-20101129111021-874if2qsp0i8d5ze) (version source revid:alexander.nozdrin@oracle.com-20101129111021-874if2qsp0i8d5ze) (merge vers: 5.6.1-m5) (pib:23)
[2 Oct 2012 9:52]
Jon Stephens
Fixed in 5.6.8. Closed.