Skip to content

Instantly share code, notes, and snippets.

@bodepd
Created April 12, 2012 17:38
Show Gist options
  • Save bodepd/2369518 to your computer and use it in GitHub Desktop.
Save bodepd/2369518 to your computer and use it in GitHub Desktop.
# glance-manage db_sync
# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2444
Server version: 5.5.22-0ubuntu1 (Ubuntu)
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use glance;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+------------------+
| Tables_in_glance |
+------------------+
| migrate_version |
+------------------+
1 row in set (0.00 sec)
# restart glance-api
glance-api start/running, process 5918
root@ip-10-252-37-89:/etc/puppet/modules# restart glance-registry
glance-registry start/running, process 5994
and the registry logs are churning this error:
2012-04-12 17:37:58 7175 ERROR [glance.registry.db.api] (ProgrammingError) (1146, "Table 'glance.images' doesn't exist") '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 %s' (1,)
2012-04-12 17:37:58 7175 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'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment