生产环境MySQL8.0.21 gtid主从同步,每周因为同一张表必报一次1032,该表是定时任务,检测系统与各主机间的是否能连通,所以该表只进行update操作,binlog为row格式。
这是程序中的SQL:update RESOURCE_PLATFORM_REF t set t.isconnect=’’ ,t.created_time=now() where t.resource_id=’’ and t.platform_ip=’’
各位大佬给解答一下如何才能解决此问题
Last_SQL_Errno: 1032
Last_SQL_Error: Coordinator stopped because there were error(s) in the worker(s). The most recent failure being: Worker 1 failed executing transaction ‘55c02165-2b06-11eb-981f-fa163eb9e040:59226840’ at master log binlog.000437, end_log_pos 851377797. See error log and/or
performance_schema.replication_applier_status_by_worker table for more details about this failure or others, if any.
mysqlbinlog --no-defaults -v -v --base64-output=DECODE-ROWS binlog.000437 | grep -A ‘15’ 851377797
#210318 4:10:14 server id 83 end_log_pos 851377797 CRC32 0xf74ca5a5 Update_rows: table id 183879 flags: STMT_END_F