Bug #30922 Constraint Violation Exception when starting several replication agents at once
Submitted: 10 Sep 2007 6:02 Modified: 4 Sep 2008 18:49
Reporter: Bill Weber Email Updates:
Status: Closed Impact on me:
Category:MySQL Enterprise Monitor: Server Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Darren Oldag CPU Architecture:Any

[10 Sep 2007 6:02] Bill Weber
When starting many replication agents at one time, sometimes get the following error:

com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`merlin/group_members`, CONSTRAINT `group_members_fk2` FOREIGN KEY (`group_id`) REFERENCES `group_names` (`group_id`) ON DELETE CASCADE) SQL: INSERT INTO group_members VALUES (?,?) ON DUPLICATE KEY UPDATE server_id=? PARAMS: (Integer): '6' (Integer): '27' (Integer): '27' ErrorCode: 1452

How to repeat:
- setup many agents pointing to servers in a replication topology
- start all agents at once
[10 Sep 2007 20:18] Sloan Childers
I hit this fairly consistently when testing with RingSpoke.dot and replmxj.  So far this has caused one really bad behavior in the server which has been fixed.  http://bugs.mysql.com/bug.php?id=28589
[4 Sep 2008 18:49] Bill Weber
closing - haven't seen this in quite a few 2.0 builds