Re: Could not execute Delete_rows event
after reporting this bug, I was told in IRC that it was probably just data drift. I couldn't dispute that at that time, so I left it. Now I find almost exactly the same problem, except chances are microscopic that it's data drift this time. I cloned a slave by stopping the original slave, rsyncing the datadir and binary logs over and starting it in the new location with the same my.cnf. Within hours the new slave stopped with the following error, while the original machien has been humming along for months.

Could not execute Update_rows event on table yomamma.albums; Can't find record in 'albums', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.002006, end_log_pos 680669835

That seems too much of a coincidence to be data drift, right?

Launchpad bug id: 865108

Re: Could not execute Delete_rows event
Well, is it data drift or not?
You need to compare the table between the master and the slave to check.
Or at least check if the row that the replication is complaining about is indeed missing on the slave.

If the row is missing, the problem seems to be data drift, and the bug happened earlier, it is necessary to track down which event was replicated incorrectly to cause this.

If the row is missing, it seems to be a problem with the replication of a specific event, ideally we need the relevant binlog and table data to reproduce.

There has been no response in the LP bug report, and we don't have any information to analyze here, so closing it as incomplete.

Hello,

I just experienced this issue with MariaDB 5.5.40. One node fell over with the same error, but the other kept on chugging along. What information is needed? I have the mysqlbinlog output, the exact query, and log crash information. I can also guarantee that this is not resolved.

Hi,

First of all, what do you mean by node? Are you running a Galera cluster or traditional replication? Please describe your replication topology.
Investigation paths can be quite different depending on the answer, so I won't start asking next questions until we know which path to choose.

The environment uses Galera WAN replication through an IPsec VPN with 100ms latency. We have have three nodes, one in each datacenter:

• MariaDB 5.5.40 in datacenter A.
• MariaDB 5.5.40 in datacenter B.
• Galera Arbitrator 25.3.5.rXXXX in datacenter C.

Thanks.

Then, if you don't mind, please create a separate bug report. While the error looks the same (it's generic by nature), it has nothing to do with the reasons of the original report, whatever they were. Galera works quite differently from the traditional replication, e.g. the main suspect "data drift" that was mentioned in earlier comments to this report can hardly apply to your case.

In the new report, please provide the exact error that you got, preferably a wide quote from the error log and the structure of the table on which it happened. Then the assignee of the report will ask additional questions.