<div dir="ltr">Hello,<div><br></div><div>By any chance are you using a VIP sitting on top of a DB cluster as your database connection in designate.conf?</div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Jul 1, 2015 at 9:10 AM, Jaime Fernández <span dir="ltr"><<a href="mailto:jjjaime@gmail.com" target="_blank">jjjaime@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div>I've followed instructions at <a href="http://designate.readthedocs.org/en/latest/getting-started.html#development-environment" target="_blank">http://designate.readthedocs.org/en/latest/getting-started.html#development-environment</a> to build and launch designate in a redhat 6.5 VM.<br><br></div>I was able to install it (with some minor changes) but when trying to start designate, the first command failed:<br><b style="font-weight:normal"><span style="font-size:12px;font-family:"Courier New";color:rgb(0,0,0);background-color:transparent;font-weight:normal;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">designate-manage database sync<br></span></b><br><br>In the first execution, designate raises this error:<br><b style="font-weight:normal"><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:12px;font-family:"Courier New";color:rgb(0,0,0);background-color:transparent;font-weight:normal;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">2015-06-30 12:04:08.874 26704 INFO migrate.versioning.api [designate-manage - - - - -] 46 -> 47... </span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:12px;font-family:"Courier New";color:rgb(0,0,0);background-color:transparent;font-weight:normal;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">2015-06-30 12:04:09.456 26704 CRITICAL designate [designate-manage - - - - -] OperationalError: (OperationalError) no such column: reverse_name u'UPDATE recordsets SET reverse_name=reverse(<a href="http://recordsets.name" target="_blank">recordsets.name</a>)' ()</span></p></b><br></div><div>If I reexecute this command, it changes slightly but it fails in the same step (46 -> 47):<br><b style="font-weight:normal"><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:12px;font-family:"Courier New";color:rgb(0,0,0);background-color:transparent;font-weight:normal;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">2015-06-30 12:04:23.359 26715 INFO migrate.versioning.api [designate-manage - - - - -] 46 -> 47... </span></p><span style="font-size:12px;font-family:"Courier New";color:rgb(0,0,0);background-color:transparent;font-weight:normal;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">2015-06-30 12:04:23.365 26715 CRITICAL designate [designate-manage - - - - -] OperationalError: (OperationalError) duplicate column name: reverse_name u"\nALTER TABLE domains ADD reverse_name VARCHAR(255) DEFAULT ''" ()</span></b><br> </div><br>It looks like a problem in the database scripts. Any fix for this?<br><br><br></div><div>Today I installed devstack in a Ubuntu VM, with designate support, and it does work. Apparently both are using the same source code for designate. Could it be related to the operating system? <b style="font-weight:normal"><span style="font-size:12px;font-family:"Courier New";color:rgb(0,0,0);background-color:transparent;font-weight:normal;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap"></span></b></div></div>
<br>__________________________________________________________________________<br>
OpenStack Development Mailing List (not for usage questions)<br>
Unsubscribe: <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" rel="noreferrer" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br>
<a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" rel="noreferrer" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br>
<br></blockquote></div><br></div>