db upgrade fails in "add_availability_zones_table"

Bug #1489827 reported by Csaba Henk
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack Shared File Systems Service (Manila)
Fix Released
Critical
Igor Malinovskiy

Bug Description

Action performed:

- tree updated from e48fbd8 to 9b77e13
- $ manila-manage db sync

Got:

$ manila-manage db sync
...
2015-08-27 18:25:22.753 INFO alembic.runtime.migration [-] Running upgrade 579c267fbb4d -> 1f0bd302c1a6, add_availability_zones_table
2015-08-27 18:25:24.45 CRITICAL manila [-] DBDuplicateEntry: (pymysql.err.IntegrityError) (1062, u"Duplicate entry 'nova-False' for key 'az_name_uc'") [SQL: u'INSERT INTO availability_zones (created_at, deleted, id, name) VALUES (%s, %s, %s, %s)'] [parameters: ((datetime.datetime(2015, 8, 27, 18, 25, 23, 978815), 'False', 'b6b489bf-4ac8-4c3b-abb0-42f4eb5f4373', u'nova'), (datetime.datetime(2015, 8, 27, 18, 25, 23, 978912), 'False', '01fbbe32-c9b0-4f96-a845-1af3ecfc3527', u'nova'), (datetime.datetime(2015, 8, 27, 18, 25, 23, 979013), 'False', '2f321348-bdee-45bd-bc70-a07a037d494e', u'nova'), (datetime.datetime(2015, 8, 27, 18, 25, 23, 979098), 'False', '36c805f3-f0ae-4083-a77d-a9db0d49600c', u'nova'), (datetime.datetime(2015, 8, 27, 18, 25, 23, 979202), 'False', '691ee1b1-25d4-4664-b298-494229dc975c', u'nova'), (datetime.datetime(2015, 8, 27, 18, 25, 23, 979297), 'False', '8cb3a720-ca3f-47f7-83bb-8c6cb9e377e9', u'nova'), (datetime.datetime(2015, 8, 27, 18, 25, 23, 979389), 'False', '6fc85a21-5d32-40eb-992c-24c48a56ab4e', u'nova'))]
...

Please find the full run dump attached.

Revision history for this message
Csaba Henk (chenk) wrote :
description: updated
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to manila (master)

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

Changed in manila:
assignee: nobody → Igor Malinovskiy (imalinovskiy)
status: New → In Progress
Changed in manila:
importance: Undecided → Critical
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to manila (master)

Reviewed: https://review.openstack.org/218239
Committed: https://git.openstack.org/cgit/openstack/manila/commit/?id=fa1537814007a7b9492bb73eb629558c06d629da
Submitter: Jenkins
Branch: master

commit fa1537814007a7b9492bb73eb629558c06d629da
Author: Igor Malinovskiy <email address hidden>
Date: Tue Sep 1 12:31:01 2015 +0300

    Fix data copying issue in DB migration 1f0bd302c1a6

    Fix data copying issue and add data checks in unit
    tests for this migration.

    Change-Id: I50429e07d108dae75026b8370f7df056362f4b4e
    Closes-Bug: #1489827

Changed in manila:
status: In Progress → Fix Committed
Thierry Carrez (ttx)
Changed in manila:
milestone: none → liberty-3
status: Fix Committed → Fix Released
Thierry Carrez (ttx)
Changed in manila:
milestone: liberty-3 → 1.0.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.