openstack team mailing list archive

[David Kranz <david.kranz@xxxxxxxxxx>]

I ran into this a few hours ago. It seems you have to do

glance-manage version_control 0
glance-manage db_sync

before restarting glance-registry. After I did that all was well.

 -David

On 4/13/2012 5:03 PM, Lee Thompson wrote:
> 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 <http://images.id> AS 
> images_id, images.name <http://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 <http://images.id> AS 
> images_id, images.name <http://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'
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~openstack
> Post to     : openstack@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openstack
> More help   : https://help.launchpad.net/ListHelp