[Openstack-operators] folsom -> grizzly keystone-manage db_sync error

Jonathan Proulx jon at jonproulx.com
Tue Aug 6 02:56:12 UTC 2013


It's entirely possible my problem is that I've been working for 14h so far
today...

On Ubuntu 12.04 using cloud-archieve repos I just upgraded  keystone to
grizzly from folsom, but 'keystone-manage db_sync' is failing with
something like:

sqlalchemy.exc.IntegrityError: (IntegrityError) (1452, 'Cannot add or
update a child row: a foreign key constraint fails
(`keystone`.`user_project_metadata`, CONSTRAINT
`user_project_metadata_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user`
(`id`))') 'INSERT INTO user_project_metadata (user_id, project_id, data)
VALUES (%s, %s, %s)' ('1c45965adcd341a68140f318460444db',
'98333a1a28e746fa8c629c83a818ad57', '{"roles":
["9fe2ff9ee4384b1894a90878d3e92bab"]}')

the user_id is not an id in the user table, the referenced project and role
both exist.

The first time I shruged and created a new (but disabled) user, but after
doing that I got the same error but with a different non-existant user id.

CLI is giving errors that I'm pretty sure relate to the keystone DB not
being updated:

ERROR: An unexpected error prevented the server from fulfilling your
request. (OperationalError) (1054, "Unknown column 'token.user_id' in
'field list'") 'SELECT token.id AS token_id, token.expires AS
token_expires, token.extra AS token_extra, token.valid AS token_valid,
token.user_id AS token_user_id, token.trust_id AS token_trust_id \nFROM
token \nWHERE token.valid = %s AND token.id = %s \n LIMIT %s' (1,
'801e71c762ea338a01a0142a35d9993a', 1) (HTTP 500)

Any clues on how to get my db to sync?

-Jon
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-operators/attachments/20130805/6d55c291/attachment.html>


More information about the OpenStack-operators mailing list