[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