openstack team mailing list archive

[Lee Thompson <stagr.lee@xxxxxxxxx>]

Fresh install or upgraded install, glance-registry fails.  Dropping the
glance DB (postgreSQL) and recreating it doesn't help.  This is the error...


# cat registry.log
2012-04-13 20:58:13 20717     INFO [sqlalchemy.engine.base.Engine] SELECT
images.created_at AS images_created_at, images.updated_at AS
images_updated_at, images.deleted_at AS images_deleted_at, images.deleted
AS images_deleted, images.id AS images_id, images.name AS images_name,
images.disk_format AS images_disk_format, images.container_format AS
images_container_format, images.size AS images_size, images.status AS
images_status, images.is_public AS images_is_public, images.location AS
images_location, images.checksum AS images_checksum, images.min_disk AS
images_min_disk, images.min_ram AS images_min_ram, images.owner AS
images_owner, images.protected AS images_protected
FROM images
 LIMIT %(param_1)s
2012-04-13 20:58:13 20717     INFO [sqlalchemy.engine.base.Engine]
{'param_1': 1}
2012-04-13 20:58:13 20717     INFO [sqlalchemy.engine.base.Engine] ROLLBACK
2012-04-13 20:58:13 20717    ERROR [glance.registry.db.api]
(ProgrammingError) relation "images" does not exist
LINE 2: FROM images
             ^
 'SELECT images.created_at AS images_created_at, images.updated_at AS
images_updated_at, images.deleted_at AS images_deleted_at, images.deleted
AS images_deleted, images.id AS images_id, images.name AS images_name,
images.disk_format AS images_disk_format, images.container_format AS
images_container_format, images.size AS images_size, images.status AS
images_status, images.is_public AS images_is_public, images.location AS
images_location, images.checksum AS images_checksum, images.min_disk AS
images_min_disk, images.min_ram AS images_min_ram, images.owner AS
images_owner, images.protected AS images_protected \nFROM images \n LIMIT
%(param_1)s' {'param_1': 1}
2012-04-13 20:58:13 20717    ERROR [glance.registry.db.api] Could not
ensure database connection and consistency. Ensure database configuration
and permissions are correct and database has been migrated since last
upgrade by running 'glance-manage db_sync'