[Openstack] glance-registry fails to start with latest ubuntu pkgs

2012-04-13 Thread Lee Thompson 
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 20717ERROR [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 20717ERROR [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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~openstack
More help   : https://help.launchpad.net/ListHelp

Re: [Openstack] glance-registry fails to start with latest ubuntu pkgs

2012-04-13 Thread David Kranz 

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 20717ERROR [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 20717ERROR [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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~openstack
More help   : https://help.launchpad.net/ListHelp



___
Mailing list: https://launchpad.net/~openstack
Post to : openstack@lists.launchpad.net
Unsubscribe : https://launchpad.net/~openstack
More help   : https://help.launchpad.net/ListHelp

Re: [Openstack] glance-registry fails to start with latest ubuntu pkgs

2012-04-13 Thread Thompson Lee 
Works!

On Apr 13, 2012, at 5:59 PM, David Kranz wrote:

 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 20717ERROR [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 20717ERROR [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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~openstack
More help   : https://help.launchpad.net/ListHelp