[Bug 1846548] Re: Glance manage db_sync fails with MySQL 8

2019-10-04 Thread James Page
Successful db sync from glance with MySQL 8: 2019-10-04 10:21:14.023 10552 INFO alembic.runtime.migration [-] Context impl MySQLImpl. 2019-10-04 10:21:14.024 10552 INFO alembic.runtime.migration [-] Will assume non-transactional DDL. 2019-10-04 10:21:14.034 10552 INFO alembic.runtime.migration [

[Bug 1846548] Re: Glance manage db_sync fails with MySQL 8

2019-10-04 Thread James Page
** Changed in: sqlalchemy (Ubuntu) Status: New => Triaged ** Changed in: sqlalchemy (Ubuntu) Importance: Undecided => High ** Changed in: glance (Ubuntu) Status: Triaged => Incomplete -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscr

[Bug 1846548] Re: Glance manage db_sync fails with MySQL 8

2019-10-04 Thread James Page
sqlalchemy should be automatically quoting reserved works, however the version in eoan does not have full support for mysql8 yet. Rather than fixup glance, we should pick the relevant commits into the sqlalchemy package: https://github.com/sqlalchemy/sqlalchemy/commit/d08d27b897569ff8f18ca869b00a

[Bug 1846548] Re: Glance manage db_sync fails with MySQL 8

2019-10-03 Thread Corey Bryant
** Changed in: glance (Ubuntu) Status: New => Triaged ** Changed in: glance (Ubuntu) Importance: Undecided => High -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1846548 Title: Glance mana

[Bug 1846548] Re: Glance manage db_sync fails with MySQL 8

2019-10-03 Thread David Ames
Upstream patch proposed: https://review.opendev.org/686461 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1846548 Title: Glance manage db_sync fails with MySQL 8 To manage notifications about this

[Bug 1846548] Re: Glance manage db_sync fails with MySQL 8

2019-10-03 Thread David Ames
The following patch allows glance to create its database. It seems subsequent queries must be quoted correctly as the service functions once the DB is created. https://paste.ubuntu.com/p/yZ7yJwHsqQ/ Index: glance/glance/db/sqlalchemy/alembic_migrations/add_images_tables.py ===