<div dir="ltr">Nope, this won't be necessary.<br><br>0.8.10 - allows us to create pk on alembic_version table automatically, but only for new deployments.<br><br>I propose manually add pk on this table if it is not existing.</div><br><div class="gmail_quote"><div dir="ltr">On Tue, Jan 24, 2017 at 7:25 PM Davanum Srinivas <<a href="mailto:davanum@gmail.com">davanum@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Ann,<br class="gmail_msg">
<br class="gmail_msg">
Don't you still need alembic>=0.8.10 to be present?<br class="gmail_msg">
<br class="gmail_msg">
-- Dims<br class="gmail_msg">
<br class="gmail_msg">
On Tue, Jan 24, 2017 at 10:05 AM, Anna Taraday<br class="gmail_msg">
<<a href="mailto:akamyshnikova@mirantis.com" class="gmail_msg" target="_blank">akamyshnikova@mirantis.com</a>> wrote:<br class="gmail_msg">
> We do not backport db changes, but if the existing migration does not work<br class="gmail_msg">
> in certain circumstances, should not we fix it to make it work if it is<br class="gmail_msg">
> possible?<br class="gmail_msg">
> This will allow to deploy new deployments with Newton code on Galera.<br class="gmail_msg">
><br class="gmail_msg">
> On Tue, Jan 24, 2017 at 6:45 PM Davanum Srinivas <<a href="mailto:davanum@gmail.com" class="gmail_msg" target="_blank">davanum@gmail.com</a>> wrote:<br class="gmail_msg">
>><br class="gmail_msg">
>> Please see<br class="gmail_msg">
>> <a href="http://docs.openstack.org/project-team-guide/stable-branches.html#review-guidelines" rel="noreferrer" class="gmail_msg" target="_blank">http://docs.openstack.org/project-team-guide/stable-branches.html#review-guidelines</a><br class="gmail_msg">
>><br class="gmail_msg">
>> On Tue, Jan 24, 2017 at 9:34 AM, Davanum Srinivas <<a href="mailto:davanum@gmail.com" class="gmail_msg" target="_blank">davanum@gmail.com</a>><br class="gmail_msg">
>> wrote:<br class="gmail_msg">
>> > Newton is already shipped!<br class="gmail_msg">
>> ><br class="gmail_msg">
>> > -- Dims<br class="gmail_msg">
>> ><br class="gmail_msg">
>> > On Tue, Jan 24, 2017 at 9:23 AM, Kirill Proskurin<br class="gmail_msg">
>> > <<a href="mailto:kproskurin@mirantis.com" class="gmail_msg" target="_blank">kproskurin@mirantis.com</a>> wrote:<br class="gmail_msg">
>> >> Galera only supported since Ocata?<br class="gmail_msg">
>> >><br class="gmail_msg">
>> >> On Tue, Jan 24, 2017 at 4:30 PM, Davanum Srinivas <<a href="mailto:davanum@gmail.com" class="gmail_msg" target="_blank">davanum@gmail.com</a>><br class="gmail_msg">
>> >> wrote:<br class="gmail_msg">
>> >>><br class="gmail_msg">
>> >>> Kirill,<br class="gmail_msg">
>> >>><br class="gmail_msg">
>> >>> "If OS wants support Galera, it needs to comply with the Galera<br class="gmail_msg">
>> >>> requirements" <<< This is true for master/ocata NOT Newton.<br class="gmail_msg">
>> >>><br class="gmail_msg">
>> >>> Ihar's response is perfectly acceptable thing to do for Newton in the<br class="gmail_msg">
>> >>> community to highlight the possibility of this situation. Downstream<br class="gmail_msg">
>> >>> folks can do what they need/have to do for Newton.<br class="gmail_msg">
>> >>><br class="gmail_msg">
>> >>> Thanks,<br class="gmail_msg">
>> >>> Dims<br class="gmail_msg">
>> >>><br class="gmail_msg">
>> >>> On Tue, Jan 24, 2017 at 4:49 AM, Kirill Proskurin<br class="gmail_msg">
>> >>> <<a href="mailto:kproskurin@mirantis.com" class="gmail_msg" target="_blank">kproskurin@mirantis.com</a>> wrote:<br class="gmail_msg">
>> >>> > HI!<br class="gmail_msg">
>> >>> ><br class="gmail_msg">
>> >>> > Thing is, running Galera without enforcing it very bad idea for<br class="gmail_msg">
>> >>> > production<br class="gmail_msg">
>> >>> > use. Permissive mode was added more or less for testing purposes,<br class="gmail_msg">
>> >>> > running<br class="gmail_msg">
>> >>> > real production with it is dangerous, since it's not enforcing the<br class="gmail_msg">
>> >>> > mandatory<br class="gmail_msg">
>> >>> > Galera requirement, one of them is a "All tables must have a primary<br class="gmail_msg">
>> >>> > key".<br class="gmail_msg">
>> >>> > You cant disable a single check, you could only disable them all and<br class="gmail_msg">
>> >>> > this<br class="gmail_msg">
>> >>> > could lead to some serious problems, like data loss or corruption.<br class="gmail_msg">
>> >>> ><br class="gmail_msg">
>> >>> > If OS wants support Galera, it needs to comply with the Galera<br class="gmail_msg">
>> >>> > requirements.<br class="gmail_msg">
>> >>> ><br class="gmail_msg">
>> >>> > On Mon, Jan 23, 2017 at 9:59 PM, Ihar Hrachyshka<br class="gmail_msg">
>> >>> > <<a href="mailto:ihrachys@redhat.com" class="gmail_msg" target="_blank">ihrachys@redhat.com</a>><br class="gmail_msg">
>> >>> > wrote:<br class="gmail_msg">
>> >>> >><br class="gmail_msg">
>> >>> >> An alternative could also be, for Newton and earlier, to release a<br class="gmail_msg">
>> >>> >> note saying that operators should not run the code against<br class="gmail_msg">
>> >>> >> ENFORCING<br class="gmail_msg">
>> >>> >> galera mode. What are the reasons to enable that mode in OpenStack<br class="gmail_msg">
>> >>> >> scope that would not allow operators to live without it for another<br class="gmail_msg">
>> >>> >> cycle?<br class="gmail_msg">
>> >>> >><br class="gmail_msg">
>> >>> >> Ihar<br class="gmail_msg">
>> >>> >><br class="gmail_msg">
>> >>> >> On Mon, Jan 23, 2017 at 10:12 AM, Anna Taraday<br class="gmail_msg">
>> >>> >> <<a href="mailto:akamyshnikova@mirantis.com" class="gmail_msg" target="_blank">akamyshnikova@mirantis.com</a>> wrote:<br class="gmail_msg">
>> >>> >> > Hello everyone!<br class="gmail_msg">
>> >>> >> ><br class="gmail_msg">
>> >>> >> > Guys in our team faced an issue when they try to run alembic<br class="gmail_msg">
>> >>> >> > migrations<br class="gmail_msg">
>> >>> >> > on<br class="gmail_msg">
>> >>> >> > Galera with ENFORCING mode. [1]<br class="gmail_msg">
>> >>> >> ><br class="gmail_msg">
>> >>> >> > This was an issue with Alembic [2], which was quickly fixed by<br class="gmail_msg">
>> >>> >> > Mike<br class="gmail_msg">
>> >>> >> > Bayer<br class="gmail_msg">
>> >>> >> > (many thanks!) and new version of alembic was resealed [3].<br class="gmail_msg">
>> >>> >> > The global requirements are updated [4].<br class="gmail_msg">
>> >>> >> ><br class="gmail_msg">
>> >>> >> > I think that it is desired to fix this for Newton at least. We<br class="gmail_msg">
>> >>> >> > cannot<br class="gmail_msg">
>> >>> >> > bump<br class="gmail_msg">
>> >>> >> > requirements for Newton, so hot fix can be putting pk on this<br class="gmail_msg">
>> >>> >> > table<br class="gmail_msg">
>> >>> >> > in<br class="gmail_msg">
>> >>> >> > the<br class="gmail_msg">
>> >>> >> > first migration like proposed [5].  Any other ideas?<br class="gmail_msg">
>> >>> >> ><br class="gmail_msg">
>> >>> >> > [1] - <a href="https://bugs.launchpad.net/neutron/+bug/1655610" rel="noreferrer" class="gmail_msg" target="_blank">https://bugs.launchpad.net/neutron/+bug/1655610</a><br class="gmail_msg">
>> >>> >> > [2] - <a href="https://bitbucket.org/zzzeek/alembic/issues/406" rel="noreferrer" class="gmail_msg" target="_blank">https://bitbucket.org/zzzeek/alembic/issues/406</a><br class="gmail_msg">
>> >>> >> > [3] -<br class="gmail_msg">
>> >>> >> ><br class="gmail_msg">
>> >>> >> ><br class="gmail_msg">
>> >>> >> > <a href="http://alembic.zzzcomputing.com/en/latest/changelog.html#change-0.8.10" rel="noreferrer" class="gmail_msg" target="_blank">http://alembic.zzzcomputing.com/en/latest/changelog.html#change-0.8.10</a><br class="gmail_msg">
>> >>> >> > [4] - <a href="https://review.openstack.org/#/c/423118/" rel="noreferrer" class="gmail_msg" target="_blank">https://review.openstack.org/#/c/423118/</a><br class="gmail_msg">
>> >>> >> > [5] - <a href="https://review.openstack.org/#/c/419320/" rel="noreferrer" class="gmail_msg" target="_blank">https://review.openstack.org/#/c/419320/</a><br class="gmail_msg">
>> >>> >> ><br class="gmail_msg">
>> >>> >> ><br class="gmail_msg">
>> >>> >> > --<br class="gmail_msg">
>> >>> >> > Regards,<br class="gmail_msg">
>> >>> >> > Ann Taraday<br class="gmail_msg">
>> >>> >> ><br class="gmail_msg">
>> >>> >> ><br class="gmail_msg">
>> >>> >> ><br class="gmail_msg">
>> >>> >> ><br class="gmail_msg">
>> >>> >> > __________________________________________________________________________<br class="gmail_msg">
>> >>> >> > OpenStack Development Mailing List (not for usage questions)<br class="gmail_msg">
>> >>> >> > Unsubscribe:<br class="gmail_msg">
>> >>> >> > <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" rel="noreferrer" class="gmail_msg" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br class="gmail_msg">
>> >>> >> > <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" rel="noreferrer" class="gmail_msg" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br class="gmail_msg">
>> >>> >> ><br class="gmail_msg">
>> >>> >><br class="gmail_msg">
>> >>> >><br class="gmail_msg">
>> >>> >><br class="gmail_msg">
>> >>> >> __________________________________________________________________________<br class="gmail_msg">
>> >>> >> OpenStack Development Mailing List (not for usage questions)<br class="gmail_msg">
>> >>> >> Unsubscribe:<br class="gmail_msg">
>> >>> >> <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" rel="noreferrer" class="gmail_msg" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br class="gmail_msg">
>> >>> >> <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" rel="noreferrer" class="gmail_msg" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br class="gmail_msg">
>> >>> ><br class="gmail_msg">
>> >>> ><br class="gmail_msg">
>> >>> ><br class="gmail_msg">
>> >>> ><br class="gmail_msg">
>> >>> > --<br class="gmail_msg">
>> >>> > Best regards,<br class="gmail_msg">
>> >>> > Proskurin Kirill<br class="gmail_msg">
>> >>> ><br class="gmail_msg">
>> >>> ><br class="gmail_msg">
>> >>> ><br class="gmail_msg">
>> >>> > __________________________________________________________________________<br class="gmail_msg">
>> >>> > OpenStack Development Mailing List (not for usage questions)<br class="gmail_msg">
>> >>> > Unsubscribe:<br class="gmail_msg">
>> >>> > <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" rel="noreferrer" class="gmail_msg" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br class="gmail_msg">
>> >>> > <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" rel="noreferrer" class="gmail_msg" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br class="gmail_msg">
>> >>> ><br class="gmail_msg">
>> >>><br class="gmail_msg">
>> >>><br class="gmail_msg">
>> >>><br class="gmail_msg">
>> >>> --<br class="gmail_msg">
>> >>> Davanum Srinivas :: <a href="https://twitter.com/dims" rel="noreferrer" class="gmail_msg" target="_blank">https://twitter.com/dims</a><br class="gmail_msg">
>> >>><br class="gmail_msg">
>> >>><br class="gmail_msg">
>> >>> __________________________________________________________________________<br class="gmail_msg">
>> >>> OpenStack Development Mailing List (not for usage questions)<br class="gmail_msg">
>> >>> Unsubscribe:<br class="gmail_msg">
>> >>> <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" rel="noreferrer" class="gmail_msg" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br class="gmail_msg">
>> >>> <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" rel="noreferrer" class="gmail_msg" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br class="gmail_msg">
>> >><br class="gmail_msg">
>> >><br class="gmail_msg">
>> >><br class="gmail_msg">
>> >><br class="gmail_msg">
>> >> --<br class="gmail_msg">
>> >> Best regards,<br class="gmail_msg">
>> >> Proskurin Kirill<br class="gmail_msg">
>> >><br class="gmail_msg">
>> >><br class="gmail_msg">
>> >> __________________________________________________________________________<br class="gmail_msg">
>> >> OpenStack Development Mailing List (not for usage questions)<br class="gmail_msg">
>> >> Unsubscribe:<br class="gmail_msg">
>> >> <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" rel="noreferrer" class="gmail_msg" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br class="gmail_msg">
>> >> <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" rel="noreferrer" class="gmail_msg" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br class="gmail_msg">
>> >><br class="gmail_msg">
>> ><br class="gmail_msg">
>> ><br class="gmail_msg">
>> ><br class="gmail_msg">
>> > --<br class="gmail_msg">
>> > Davanum Srinivas :: <a href="https://twitter.com/dims" rel="noreferrer" class="gmail_msg" target="_blank">https://twitter.com/dims</a><br class="gmail_msg">
>><br class="gmail_msg">
>><br class="gmail_msg">
>><br class="gmail_msg">
>> --<br class="gmail_msg">
>> Davanum Srinivas :: <a href="https://twitter.com/dims" rel="noreferrer" class="gmail_msg" target="_blank">https://twitter.com/dims</a><br class="gmail_msg">
>><br class="gmail_msg">
>> __________________________________________________________________________<br class="gmail_msg">
>> OpenStack Development Mailing List (not for usage questions)<br class="gmail_msg">
>> Unsubscribe: <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" rel="noreferrer" class="gmail_msg" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br class="gmail_msg">
>> <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" rel="noreferrer" class="gmail_msg" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br class="gmail_msg">
><br class="gmail_msg">
> --<br class="gmail_msg">
> Regards,<br class="gmail_msg">
> Ann Taraday<br class="gmail_msg">
><br class="gmail_msg">
> __________________________________________________________________________<br class="gmail_msg">
> OpenStack Development Mailing List (not for usage questions)<br class="gmail_msg">
> Unsubscribe: <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" rel="noreferrer" class="gmail_msg" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br class="gmail_msg">
> <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" rel="noreferrer" class="gmail_msg" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br class="gmail_msg">
><br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
--<br class="gmail_msg">
Davanum Srinivas :: <a href="https://twitter.com/dims" rel="noreferrer" class="gmail_msg" target="_blank">https://twitter.com/dims</a><br class="gmail_msg">
<br class="gmail_msg">
__________________________________________________________________________<br class="gmail_msg">
OpenStack Development Mailing List (not for usage questions)<br class="gmail_msg">
Unsubscribe: <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" rel="noreferrer" class="gmail_msg" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br class="gmail_msg">
<a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" rel="noreferrer" class="gmail_msg" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br class="gmail_msg">
</blockquote></div><div dir="ltr">-- <br></div><div data-smartmail="gmail_signature"><div dir="ltr">Regards,<br>Ann Taraday</div></div>