nailgun_fixtures raises error if we run it twice

Bug #1291836 reported by Vladimir Sharshov
14
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Fuel for OpenStack
Fix Committed
Medium
Ivan Kolodyazhny

Bug Description

New ISO with latest components. Bootstrap admin node process fail with the error if i try to run bootstrap_admin_node.sh twice:

err: /Stage[main]/Nailgun::Venv/Exec[nailgun_upload_fixtures]/returns: change from notrun to 0 failed: /opt/nailgun/bin/nailgun_fixtures returned 1 instead of one of [0] at /etc/puppet/modules/nailgun/manifests/venv.pp:115

If try to run /opt/nailgun/bin/nailgun_fixtures manually y get this:
............

sqlalchemy.exc.IntegrityError: (IntegrityError) duplicate key value violates unique constraint "releases_name_key"

See full log: http://paste.openstack.org/show/73351/

Tags: nailgun
Changed in fuel:
importance: Critical → High
description: updated
Evgeniy L (rustyrobot)
description: updated
summary: - SAWarning: Unicode type received non-unicode bind param value
+ nailgun_fixtures raises error if we run it twice
Changed in fuel:
status: New → Confirmed
Changed in fuel:
assignee: Fuel Python Team (fuel-python) → Igor Kalnitsky (ikalnitsky)
Revision history for this message
Ihor Kalnytskyi (ikalnytskyi) wrote :

I think it should be fixed in puppet scripts.

The `nailgun_fixtures` script rises error because a nailgun database already has information about releases.
We have to drop it before trying upload again.

As for python team, we can provide `nailgun_dropdb` script, if needed.

Changed in fuel:
assignee: Igor Kalnitsky (ikalnitsky) → nobody
assignee: nobody → Fuel Library Team (fuel-library)
Revision history for this message
Ivan Kolodyazhny (e0ne) wrote :

It's not bug in puppet script. nailgun_fixtures should works fine if it invoked twice or more times

Changed in fuel:
importance: High → Medium
assignee: Fuel Library Team (fuel-library) → Ivan Kolodyazhny (e0ne)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to fuel-web (master)

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

Changed in fuel:
status: Confirmed → In Progress
Revision history for this message
Openstack Gerrit (openstack-gerrit) wrote : Fix merged to fuel-web (master)

Reviewed: https://review.openstack.org/86545
Committed: https://git.openstack.org/cgit/stackforge/fuel-web/commit/?id=1a9b698c4164c90436c265e0674df9b54796bfbd
Submitter: Jenkins
Branch: master

commit 1a9b698c4164c90436c265e0674df9b54796bfbd
Author: Ivan Kolodyazhny <email address hidden>
Date: Thu Apr 10 13:05:56 2014 +0300

    Fix Release PK in fixture

    Change-Id: Ic94efd47e4e30b95ac6094328fd4b504a717743b
    Closes-bug: #1291836

Changed in fuel:
status: In Progress → Fix Committed
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

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