keystone-manage db_sync might fail

Bug #1297290 reported by Scott Devoid
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack Identity (keystone)
Expired
Undecided
Unassigned
openstack-manuals
Invalid
Wishlist
Scott Devoid

Bug Description

Change to step 5. Create the database tables for the Identity Service

Add an additional note after the db_sync command that this command may return a critical error and fail to fully migrate an empty repository. This is probably due to the fact that the upgrade scripts do not guard against transaction failures returned from the SQL server. You need to run this command multiple times and check "keystone-manage db_version". If it does not reach version 34, the upgrade scripts have not completed for Havana builds.

-----------------------------------
Built: 2014-03-18T18:59:18 00:00
git SHA: b4f5cdc33b9248aa9c9768e2deccbc3a1a04cc3f
URL: http://docs.openstack.org/havana/install-guide/install/apt/content/keystone-install.html
source File: file:/home/jenkins/workspace/openstack-install-deploy-guide-ubuntu/doc/install-guide/section_keystone-install.xml
xml:id: keystone-install

Tom Fifield (fifieldt)
Changed in openstack-manuals:
status: New → Confirmed
importance: Undecided → Wishlist
status: Confirmed → Triaged
milestone: none → icehouse
tags: added: install-guide
Revision history for this message
Matt Kassawara (ionosphere80) wrote :

I haven't seen this issue with new installations. Were you upgrading from a prior release?

Revision history for this message
Scott Devoid (scott-devoid) wrote :

Nope. I dropped the keystone database that I used for development, created the new database then ran db_sync. This was with a MySQL Percona cluster.

Changed in openstack-manuals:
status: Triaged → In Progress
Revision history for this message
Andreas Jaeger (jaegerandi) wrote :

This looks to me more like a bug in Percona than anything else, this is a quite normal setup and I'd like to see this analyzed as bug first before we add documentation to it. Let's report it against keystone.

summary: - Install the Identity Service in OpenStack Installation Guide for Ubuntu
- 12.04 (LTS)  - havana
+ keystone-manage db_sync might fail
Revision history for this message
Dolph Mathews (dolph) wrote :

What caused the transaction failures? I've never seen this behavior, either.

Changed in keystone:
status: New → Incomplete
Revision history for this message
Scott Devoid (scott-devoid) wrote :

Transaction hangs for a long time then aborts. I don't have the logs anymore and the database that this was running on is now up to date and running in production.

Dolph Mathews (dolph)
tags: added: sql
Revision history for this message
Tom Fifield (fifieldt) wrote :
Tom Fifield (fifieldt)
Changed in openstack-manuals:
assignee: nobody → Scott Devoid (scott-devoid)
Revision history for this message
Scott Devoid (scott-devoid) wrote :

@fifieldt Why am I assigned? I thought we were waiting on keystone dev's to respond?

Revision history for this message
Dolph Mathews (dolph) wrote :

Scott: Hello, from keystoneland! I assume Tom assigned this bug to you in openstack-manuals because you opened a review against openstack-manuals to address the issue (in fact, a bot should have done so previously, but apparently to failed for whatever reason). Regarding a response, correct me if I'm mistaken, but there doesn't appear to be enough information here to begin a debugging effort, nor is it clear that the issue is reproducible, especially given that it's an unconfirmed and isolated incident without corresponding logs (in the event of a critical failure, there certainly should have been a backtrace produced that we could begin to work from). If there's a clear issue with the migration process, we need to identify and fix it.

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Change abandoned on openstack-manuals (master)

Change abandoned by Andreas Jaeger (<email address hidden>) on branch: master
Review: https://review.openstack.org/89395
Reason: As discussed: This is a bug that needs to be discussed first. If then a documentation change is needed, either restore the patch or create a new one.

Tom Fifield (fifieldt)
Changed in openstack-manuals:
status: In Progress → Incomplete
milestone: icehouse → none
Revision history for this message
Launchpad Janitor (janitor) wrote :

[Expired for Keystone because there has been no activity for 60 days.]

Changed in keystone:
status: Incomplete → Expired
Revision history for this message
Tom Fifield (fifieldt) wrote :

My hope is that this was just a bug in Havana or before and all is fixed in Icehouse/Juno now

Changed in openstack-manuals:
status: Incomplete → Invalid
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.