Report: Error code breaking circular replication

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
mimai
Posts: 24
Joined: Wed Aug 01, 2007 3:01 am

Report: Error code breaking circular replication

Post by mimai » Sat Mar 15, 2008 7:28 am

Circular replication was broken with the following code:
080314 14:07:57 [ERROR] Slave: 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 '1',BaseUnits = '0',SubstitutionCode = '',SubstOnlyIf = '0' WHERE CodeNum = '183'' at line 1' on query. Default database: 'opendental'. Query: 'UPDATE procedurecode SET descript = 'malar and/or isting = '1',BaseUnits = '0',SubstitutionCode = '',SubstOnlyIf = '0' WHERE CodeNum = '183'&', Error_code: 1064
080314 14:07:57 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000023' position 165925385

This has happened twice. Please check.

User avatar
jordansparks
Site Admin
Posts: 5744
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Report: Error code breaking circular replication

Post by jordansparks » Sat Mar 15, 2008 10:32 pm

What version?
Jordan Sparks, DMD
http://www.opendental.com

mimai
Posts: 24
Joined: Wed Aug 01, 2007 3:01 am

Re: Report: Error code breaking circular replication

Post by mimai » Sun Mar 16, 2008 4:02 pm

Sorry, Version 5.5.14

User avatar
jordansparks
Site Admin
Posts: 5744
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Report: Error code breaking circular replication

Post by jordansparks » Tue Mar 18, 2008 6:36 am

I wish I could see the whole query because it looks fine other than that strange character after the 183. Look to see if you have any duplicate ProcCode entries related to CodeNum 183, like maybe same ProcCode on each db, but with two different CodeNums. I'm not really sure. Let me know what you find out.
Jordan Sparks, DMD
http://www.opendental.com

Post Reply