IBM Support

Mysql Replication Failed

Troubleshooting


Problem

Mysql Replication Failed

Symptom

Panaces Metadata replication Failed with Last_Errno: 1064
? Last_Error: Error 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'updaq\0~\0(\0\0\0\0sq\0~\0+????????????????\0\0\0uq\0~\0.\0\0\0 ?' at line 1' on query. Default database: 'panaces'. Query: 'updaq\0~\0(\0\0\0\0sq\0~\0+????????????????\0\0\0uq\0~\0.\0\0\0 ?'

?SOLUTION:
?After changing the follwing values, replication is working fine

?mysql> set session max_allowed_packet=16777216;
?mysql> set global max_allowed_packet=16777216;

[{"Business Unit":{"code":"BU051","label":"N\/A"},"Product":{"code":"SUPPORT","label":"IBM Worldwide Support"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB33","label":"N\/A"}}]

Document Information

More support for:
IBM Worldwide Support

Software version:
All Versions

Document number:
745707

Modified date:
02 November 2020

UID

ibm10745707

Page Feedback