remove select for update lock from db_base_plugin

[Rossella Sblendido]

MySQL Galera does not support SELECT ... FOR UPDATE[1], since it has no concept of cross-node locking of records and results are non-deterministic.

Remove the use of SELECT FOR UPDATE in the db_base_plugin

[1]http://lists.openstack.org/pipermail/openstack-dev/2014-May/035264.html

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/100963

[Eugene Nikanorov (enikanorov)]

I would suggest to actually file a blueprint for this, as this is quite a big task for the bug.

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/122458
Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=be6c51ccd72a3cea02e5feef1b6162b451a88bd1
Submitter: Jenkins
Branch: master

commit be6c51ccd72a3cea02e5feef1b6162b451a88bd1
Author: rossella <email address hidden>
Date: Tue Sep 16 22:30:12 2014 +0000

    Remove SELECT FOR UPDATE from delete_network and delete_subnet

    delete_network and delete_subnet instead of using SELECT FOR UPDATE
    delete the ports that are allowed to be auto deleted straight away.
    Then a check is performed, if there are ports still associated
    with the network or the subnet that cannot be autodeleted,
    an exception is raised. The operation will be rolled back.

    Partial-bug: #1331564

    Change-Id: I29178204b3a220c1c6010f59272981fb1b4099fe

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/124136
Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=c86b8f224831ab9171ac638f1ed5585d903f0be9
Submitter: Jenkins
Branch: master

commit c86b8f224831ab9171ac638f1ed5585d903f0be9
Author: rossella <email address hidden>
Date: Tue Sep 23 11:02:20 2014 +0200

    Functional test IPAM DB operation

    Add a functional test to check that the IPAM logic is correct and
    that the data stored in the DB are sane.

    Partial-bug: #1331564
    Change-Id: I7776a50824184663abd37e210d08a63eb5519cea

[OpenStack Infra (hudson-openstack)]

Change abandoned by Kyle Mestery (<email address hidden>) on branch: master
Review: https://review.openstack.org/100963
Reason: This review is > 4 weeks without comment, and failed Jenkins the last time it was checked. We are abandoning this for now. Feel free to reactivate the review by pressing the restore button and leaving a 'recheck' comment to get fresh test results.