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 =================================================================== --- glance.orig/glance/db/sqlalchemy/alembic_migrations/add_images_tables.py +++ glance/glance/db/sqlalchemy/alembic_migrations/add_images_tables.py @@ -134,7 +134,7 @@ def _add_image_members_table(): op.create_table('image_members', Column('id', Integer(), nullable=False), Column('image_id', String(length=36), nullable=False), - Column('member', String(length=255), nullable=False), + Column('`member`', String(length=255), nullable=False), Column('can_share', Boolean(), nullable=False), Column('created_at', DateTime(), nullable=False), Column('updated_at', DateTime(), nullable=True), @@ -147,7 +147,7 @@ def _add_image_members_table(): ForeignKeyConstraint(['image_id'], ['images.id'], ), PrimaryKeyConstraint('id'), UniqueConstraint('image_id', - 'member', + '`member`', 'deleted_at', name=deleted_member_constraint), mysql_engine='InnoDB', @@ -164,7 +164,7 @@ def _add_image_members_table(): unique=False) op.create_index('ix_image_members_image_id_member', 'image_members', - ['image_id', 'member'], + ['image_id', '`member`'], unique=False)
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/yZ7yJwHsq Q/ glance/ db/sqlalchemy/ alembic_ migrations/ add_images_ tables. py ======= ======= ======= ======= ======= ======= ======= ======= ==== orig/glance/ db/sqlalchemy/ alembic_ migrations/ add_images_ tables. py glance/ db/sqlalchemy/ alembic_ migrations/ add_images_ tables. py members_ table() : create_ table(' image_members' ,
Column( 'id', Integer(), nullable=False),
Column( 'image_ id', String(length=36), nullable=False),
Column( 'can_share' , Boolean(), nullable=False),
Column( 'created_ at', DateTime(), nullable=False),
Column( 'updated_ at', DateTime(), nullable=True), members_ table() :
ForeignKeyConst raint([ 'image_ id'], ['images.id'], ),
PrimaryKeyConst raint(' id'),
UniqueConstrain t('image_ id',
'deleted_ at',
name= deleted_ member_ constraint) ,
mysql_engine= 'InnoDB' , members_ table() :
unique= False) create_ index(' ix_image_ members_ image_id_ member' ,
'image_ members' ,
unique= False)
Index: glance/
=======
--- glance.
+++ glance/
@@ -134,7 +134,7 @@ def _add_image_
op.
- Column('member', String(length=255), nullable=False),
+ Column('`member`', String(length=255), nullable=False),
@@ -147,7 +147,7 @@ def _add_image_
- 'member',
+ '`member`',
@@ -164,7 +164,7 @@ def _add_image_
op.
- ['image_id', 'member'],
+ ['image_id', '`member`'],