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"}}]
Was this topic helpful?
Document Information
Modified date:
02 November 2020
UID
ibm10745707