OpenStack Compute (nova)

  1. Bug #1214720
  2. Comment #6

Comment 6 for bug 1214720

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to nova (master)

Reviewed: https://review.openstack.org/43056
Committed: http://github.com/openstack/nova/commit/b36826ef3ddeafcf5f16034bccd971de800f677a
Submitter: Jenkins
Branch: master

commit b36826ef3ddeafcf5f16034bccd971de800f677a
Author: Chang Bo Guo <email address hidden>
Date: Sat Aug 24 09:02:47 2013 -0700

    Add DeleteFromSelect to avoid database's limit

    nova-manage db archive_deleted_rows fails if max_rows is a large
    number. Database has a limit of maximum sql variables in one SQL
    statement. It is more efficient to insert(select) directly and then
    delete(same select) without ever returning the selected rows back to
    Python. This also can avoid database's limit.

    Closes-Bug: #1214720

    Change-Id: I29e3a5ce14c59dd2979e45e8d31fc3df04c70266