Merge "Fix db migration for mariadb >= 10.2.8"

manila/db/migrations/alembic/versions/e8ea58723178_remove_host_from_driver_private_data.py

@@ -38,10 +38,17 @@ COLUMN_HOST = 'host'
 DEFAULT_HOST = 'unknown'
 COLUMN_ENTITY = 'entity_uuid'
 COLUMN_KEY = 'key'
+MYSQL_ENGINE = 'mysql'
 
 
 def upgrade():
+    bind = op.get_bind()
+    engine = bind.engine
     try:
+        if (engine.name == MYSQL_ENGINE):
+            op.drop_constraint('PRIMARY', TABLE_NAME, type_='primary')
+            op.create_primary_key('DRIVERS_PRIVATE_PK', TABLE_NAME,
+                                  ['entity_uuid', 'key'])
         op.drop_column(TABLE_NAME, COLUMN_HOST)
     except Exception:
         LOG.error("Column '%s' could not be dropped", COLUMN_HOST)

releasenotes/notes/bug-1749184-eb06929e76a14fce.yaml

@@ -0,0 +1,5 @@
+---
+fixes:
+  - The database migration has been adjusted to work with mariadb >= 10.2.8
+    by ensuring that a primary key constraint is first dropped and re-added
+    when a column is removed that is part of it