Bug #98665 replication broken on blackhole node if binlog_rows_query_log_events on master
| Submitted: | 19 Feb 2020 12:27 | Modified: | 27 Feb 2020 12:28 |
|---|---|---|---|
| Reporter: | Zhenghu Wen (OCA) | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: Replication | Severity: | S3 (Non-critical) |
| Version: | 8.0.19, 5.7.29 | OS: | Any |
| Assigned to: | CPU Architecture: | Any |
[19 Feb 2020 12:27]
Zhenghu Wen
[19 Feb 2020 12:31]
Zhenghu Wen
master config file
Attachment: node1.cnf (application/octet-stream, text), 2.34 KiB.
[19 Feb 2020 12:32]
Zhenghu Wen
slave config file
Attachment: node3.cnf (application/octet-stream, text), 2.34 KiB.
[19 Feb 2020 14:09]
Zhenghu Wen
the same as 5.7.20+
[24 Feb 2020 6:55]
Zhenghu Wen
a. if binlog_rows_query_log_events is on the master, the dml query will write into binlog as rows_query_log_event;
b. when the slave apply this event ,it will set thd query:
int Rows_query_log_event::do_apply_event(Relay_log_info const *rli)
{
...
/* Set query for writing Rows_query log event into binlog later.*/
thd->set_query(m_rows_query, strlen(m_rows_query));
...
}
c. it is conflict with blackhole engine:
int ha_blackhole::update_row(const uchar *, uchar *) {
DBUG_TRACE;
THD *thd = ha_thd();
if (is_slave_applier(thd) && thd->query().str == NULL) return 0;
return HA_ERR_WRONG_COMMAND;
}
int ha_blackhole::delete_row(const uchar *) {
DBUG_TRACE;
THD *thd = ha_thd();
if (is_slave_applier(thd) && thd->query().str == NULL) return 0;
return HA_ERR_WRONG_COMMAND;
}
we can see in ha_blackhole::update_row and ha_blackhole::delete_row that only if thd->query().str is NULL, it will return 0 (means everything is fine)
[27 Feb 2020 12:28]
MySQL Verification Team
Hello Zhenghu, Thank you for the report. Verified as described with 8.0.19 build. Thanks, Umesh
[27 Feb 2020 12:30]
MySQL Verification Team
Test results - 8.0.19
Attachment: 98665_8.0.19.results (application/octet-stream, text), 11.84 KiB.
[27 Feb 2020 12:30]
MySQL Verification Team
I'll add 5.7 test results later on.
[4 Mar 2020 5:19]
MySQL Verification Team
Test results - 5.7.29
Attachment: 98665_5.7.29.results (application/octet-stream, text), 9.90 KiB.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.061 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.