yahoo-eng-team team mailing list archive

[Pavel Kholkin <pkholkin@xxxxxxxxxxxx>]

Public bug reported:

After ignore and pass exception the following exception could happen:

sqlalchemy.exc.InvalidRequestError: This Session's transaction has been
rolled back due to a previous exception during flush. To begin a new
transaction with this Session, first issue Session.rollback(). Original
exception was: (sqlite3.IntegrityError) UNIQUE constraint failed:
instance_info_caches.instance_uuid

We are in a transaction, we can't have an integrity failure in a
transaction, and then just continue working, we need to use a savepoint.

The problem could be reproduced e.g. in instance_info_cache_update but
also could happen in other similar places where we pass an db exception.

** Affects: nova
     Importance: Low
     Assignee: Pavel Kholkin (pkholkin)
         Status: In Progress

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1520567

Title:
  Incorrect pass exception with oslo_db.enginefacade

Status in OpenStack Compute (nova):
  In Progress

Bug description:
  After ignore and pass exception the following exception could happen:

  sqlalchemy.exc.InvalidRequestError: This Session's transaction has
  been rolled back due to a previous exception during flush. To begin a
  new transaction with this Session, first issue Session.rollback().
  Original exception was: (sqlite3.IntegrityError) UNIQUE constraint
  failed: instance_info_caches.instance_uuid

  We are in a transaction, we can't have an integrity failure in a
  transaction, and then just continue working, we need to use a
  savepoint.

  The problem could be reproduced e.g. in instance_info_cache_update but
  also could happen in other similar places where we pass an db
  exception.

To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1520567/+subscriptions