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
• Status: Closed
• Category: MySQL Enterprise Monitor: Server
• Severity: S3 (Non-critical)
• Version: 1.2.0.7481
• OS: Any
• Assigned to: Darren Oldag
• CPU Architecture: Any

[10 Sep 2007 6:02] Bill Weber

Description:
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