From 4a5da930e8baf1b370a6aab32fedb7f7bfb40930 Mon Sep 17 00:00:00 2001 From: wangbo Date: Mon, 12 May 2014 15:18:03 +0800 Subject: [PATCH] Reorg table ml2_port_bindings when db migration For DB2, there are restrictions on table access after ALTER TABLE statements containing REORG-recommended operations. Table will be placed in "reorg pending" state after some continuous alter table operations. Need run reorg table to make the table available. More info refer to: http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp ?topic=%2Fcom.ibm.db2.udb.admin.doc%2Fdoc%2Fc0023297.htm Change-Id: I7fdd61bb4d636d7a3260c0b23152f1f3083cdcfd Fixes: bug #1318498 --- .../versions/50d5ba354c23_ml2_binding_vif_details.py | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/neutron/db/migration/alembic_migrations/versions/50d5ba354c23_ml2_binding_vif_details.py b/neutron/db/migration/alembic_migrations/versions/50d5ba354c23_ml2_binding_vif_details.py index f89be7c11..4182eea1a 100644 --- a/neutron/db/migration/alembic_migrations/versions/50d5ba354c23_ml2_binding_vif_details.py +++ b/neutron/db/migration/alembic_migrations/versions/50d5ba354c23_ml2_binding_vif_details.py @@ -65,6 +65,8 @@ def upgrade(active_plugins=None, options=None): " vif_details = '{\"port_filter\": false}'" " WHERE cap_port_filter = false") op.drop_column('ml2_port_bindings', 'cap_port_filter') + if op.get_bind().engine.name == 'ibm_db_sa': + op.execute("CALL SYSPROC.ADMIN_CMD('REORG TABLE ml2_port_bindings')") def downgrade(active_plugins=None, options=None): @@ -93,3 +95,5 @@ def downgrade(active_plugins=None, options=None): " cap_port_filter = true" " WHERE vif_details LIKE '%\"port_filter\": true%'") op.drop_column('ml2_port_bindings', 'vif_details') + if op.get_bind().engine.name == 'ibm_db_sa': + op.execute("CALL SYSPROC.ADMIN_CMD('REORG TABLE ml2_port_bindings')") -- 2.45.2