API Software Gateway Replication

[Suneel Kamisetty]

Hi Team,

We are facing replication issues in our API software gateway servers frequently around ssg and oauth databases. Here's the error message for reference.

This exception are logging on both the gateway nodes.

Last_Error: Could not execute Update_rows event on table ssg.service_metrics; Can't find record in 'service_metrics', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log ssg-bin.000001, end_log_pos 13387112


              Last_SQL_Error: Could not execute Delete_rows event on table otk_db.oauth_token; Can't find record in 'oauth_token', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.000075, end_log_pos 329061302


Can you please suggest how we can fix this issue permanently.

Thanks,
Suneel

[Charles Lilienkamp]

Suneel,
 For service metrics you can disable it from being replicated its not required.
https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=107121

For oauth you may want to check your jdbc driver make sure its not localhost but node1,node2 or else the breakage is probably from to heavy of an impact which will cause cross talking concerns..
Thanks..