[Openstack] expected tables in database after sync

Sashan Govender sashang at gmail.com
Fri Jan 5 02:30:18 UTC 2018


Further, if i try the verification steps on the next page,
https://docs.openstack.org/newton/install-guide-rdo/glance-verify.html I
get the following error:

openstack image create "cirros"   --file cirros-0.3.4-x86_64-disk.img
 --disk-format qcow2 --container-format bare   --public
500 Internal Server Error
The server has either erred or is incapable of performing the requested
operation.
    (HTTP 500)

Looking in  /var/log/glance/api.log:
ERROR glance.common.wsgi ProgrammingError: (pymysql.err.ProgrammingError)
(1146, u"Table 'glance.images' doesn't exist")

So it's failing because there are no tables in the glance db. Which brings
me back to my original question, what is ' su -s /bin/sh -c "glance-manage
db_sync" glance' meant to do?


On Fri, Jan 5, 2018 at 11:55 AM Sashan Govender <sashang at gmail.com> wrote:

> Hi
>
> I'm going through the glance installation guide here:
> https://docs.openstack.org/newton/install-guide-rdo/glance-install.html
>
> The last step is:
>  su -s /bin/sh -c "glance-manage db_sync" glance
>
> What tables should I expect in the glance database?
> After executing that command above, this is what it currently shows:
>
> MariaDB [keystone]> use glance;
> Database changed
> MariaDB [glance]> use tables;
> ERROR 1049 (42000): Unknown database 'tables'
> MariaDB [glance]> show tables;
> Empty set (0.00 sec)
>
> MariaDB [glance]>
>
> I recall having the same issue with keystone when setting up its database.
> For a while it wasn't populated with anything, but now the keystone db has
> stuff in it after I fiddled around. I can't remember what I did though.
>
> MariaDB [mysql]> use keystone;
> 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
> MariaDB [keystone]> show tables;
> +------------------------+
> | Tables_in_keystone     |
> +------------------------+
> | access_token           |
> | assignment             |
> | config_register        |
> | consumer               |
> | credential             |
> | endpoint               |
> | endpoint_group         |
> | federated_user         |
> | federation_protocol    |
> | group                  |
> | id_mapping             |
> | identity_provider      |
>
> I expect a similar set of tables in the glance db.
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20180105/d0ff9a50/attachment.html>


More information about the Openstack mailing list