nailgun_fixtures fails if database already exists

Bug #1302400 reported by Igor Shishkin
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Fuel for OpenStack
Confirmed
Low
Evgeniy L

Bug Description

Traceback (most recent call last):
  File "/opt/nailgun/bin/nailgun_fixtures", line 9, in <module>
    load_entry_point('nailgun==0.1.0', 'console_scripts', 'nailgun_fixtures')()
  File "/opt/nailgun/lib/python2.6/site-packages/nailgun/db/sqlalchemy/fixman.py", line 206, in upload_fixtures
    upload_fixture(fileobj)
  File "/opt/nailgun/lib/python2.6/site-packages/nailgun/db/sqlalchemy/fixman.py", line 176, in upload_fixture
    db().commit()
  File "/opt/nailgun/lib/python2.6/site-packages/sqlalchemy/orm/session.py", line 656, in commit
    self.transaction.commit()
  File "/opt/nailgun/lib/python2.6/site-packages/sqlalchemy/orm/session.py", line 314, in commit
    self._prepare_impl()
  File "/opt/nailgun/lib/python2.6/site-packages/sqlalchemy/orm/session.py", line 298, in _prepare_impl
    self.session.flush()
  File "/opt/nailgun/lib/python2.6/site-packages/sqlalchemy/orm/session.py", line 1583, in flush
    self._flush(objects)
  File "/opt/nailgun/lib/python2.6/site-packages/sqlalchemy/orm/session.py", line 1654, in _flush
    flush_context.execute()
  File "/opt/nailgun/lib/python2.6/site-packages/sqlalchemy/orm/unitofwork.py", line 331, in execute
    rec.execute(self)
  File "/opt/nailgun/lib/python2.6/site-packages/sqlalchemy/orm/unitofwork.py", line 475, in execute
    uow
  File "/opt/nailgun/lib/python2.6/site-packages/sqlalchemy/orm/persistence.py", line 64, in save_obj
    table, insert)
  File "/opt/nailgun/lib/python2.6/site-packages/sqlalchemy/orm/persistence.py", line 558, in _emit_insert_statements
    execute(statement, params)
  File "/opt/nailgun/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1449, in execute
    params)
  File "/opt/nailgun/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/opt/nailgun/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
    context)
  File "/opt/nailgun/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
    context)
  File "/opt/nailgun/lib/python2.6/site-packages/sqlalchemy/engine/default.py", line 331, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.IntegrityError: (IntegrityError) duplicate key value violates unique constraint "releases_name_key"

Could you please do INSERT .... ON DUPLICATE KEY UPDATE?

Tags: nailgun
Evgeniy L (rustyrobot)
Changed in fuel:
status: New → Confirmed
milestone: none → 5.0
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.