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/ razique.mahroua at clouditcanada.com 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. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.openstack.org/pipermail/openstack/attachments/20130919/5976ad39/attachment.html> -------------- next part -------------- A non-text attachment was scrubbed... Name: logo.jpg Type: image/jpeg Size: 8016 bytes Desc: not available URL: <http://lists.openstack.org/pipermail/openstack/attachments/20130919/5976ad39/attachment.jpg> -------------- next part -------------- A non-text attachment was scrubbed... Name: facebook.png Type: image/png Size: 554 bytes Desc: not available URL: <http://lists.openstack.org/pipermail/openstack/attachments/20130919/5976ad39/attachment.png> -------------- next part -------------- A non-text attachment was scrubbed... Name: twitter.png Type: image/png Size: 592 bytes Desc: not available URL: <http://lists.openstack.org/pipermail/openstack/attachments/20130919/5976ad39/attachment-0001.png> -------------- next part -------------- A non-text attachment was scrubbed... Name: linkedin.png Type: image/png Size: 631 bytes Desc: not available URL: <http://lists.openstack.org/pipermail/openstack/attachments/20130919/5976ad39/attachment-0002.png> -------------- next part -------------- A non-text attachment was scrubbed... Name: skype.png Type: image/png Size: 800 bytes Desc: not available URL: <http://lists.openstack.org/pipermail/openstack/attachments/20130919/5976ad39/attachment-0003.png>
