Could not execute Delete_rows event on table ACT_RU_TIMER_JOB; Can't find record in 'ACT_RU_TIMER_JOB', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.000006, end_log_pos 26052399

Flowable Engine
#1

We are using Flowable for simple approval application and we are replicating MySQL data between 2 DC’s. However the replication failed and got below error. Any suggestions or alternatives.

Could not execute Delete_rows event on table ACT_RU_TIMER_JOB; Can’t find record in ‘ACT_RU_TIMER_JOB’, Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event’s master log mysql-bin.000006, end_log_pos 26052399

#2

Hey @nanu.mbp,

I don’t see what we can do about this from Flowable side. It seems like your data is corrupted. You will need to rollback to one of your backups.

Cheers,
Filip

#3

Thanks @filiphr

To execute deadletter jobs, we used schedulers. schedulers were running parallelly in multiple DC’s… hence we got error… we decided to execute scheduler in one DC… we are good now :slight_smile: