This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

Error while connecting second replication server

Good day. I have a problem to connecting second replication server to existing master-replication scheme. When I connect 2 replication server it works some minutes and fails with error. Error text. Last_Errno: 1452 Last_Error: Error cannot add or update a child row: a foreign key constraint fails. At the same time first replication server works fine. What could be the problem?

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.