[Openstack] Quantum MySQL master <-> master replication often fails

Thu, 19 Sep 2013 13:32:39 -0700

Hi guys,
for my prod environment I'm deploying two MySQL servers on two controllers.
MySQL is configured in active/ active replication…. BUT what I've noticed is that replication often fails because of Quantum foreign keys, when I delete a network for instance:
                   Last_Error: Error 'Cannot delete or update a parent row: a foreign key constraint fails (`quantum`.`ports`, CONSTRAINT `ports_ibfk_1` FOREIGN KEY (`network_id`) REFERENCES `networks` (`id`))' on query. Default database: 'quantum'. Query: 'DELETE FROM networks WHERE networks.id = 'f33591d2-2008-4893-b1bb-51649b745af2'

you guys ever face that issue?
thanks !

-- 



Razique Mahroua / Engineering
+336 77 73 23 90/ [email protected]

Cloud I.T. Canada Office: 1-855-200-0320 / Fax: 1-866-227-2174 
231 Shearson Cres – Suite 109B. Cambridge, ON. N1T 1J5
http://www.clouditcanada.com


   
This e-mail message may contain confidential or legally privileged information and is intended only for the use of the intended recipient(s). Any unauthorized disclosure, dissemination, distribution, copying or the taking of any action in reliance on the information herein is prohibited. E-mails are not secure and cannot be guaranteed to be error free as they can be intercepted, amended, or contain viruses. Anyone who communicates with us by e-mail is deemed to have accepted these risks. Cloud I.T. Canada is not responsible for errors or omissions in this message and denies any responsibility for any damage arising from the use of e-mail. Any opinion and other statement contained in this message and any attachment are solely those of the author and do not necessarily represent those of the company. 


_______________________________________________
Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
Post to     : [email protected]
Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack

Reply via email to