Neutron db migration failed due to "reorg pending" if engine is DB2.

Bug #1318498 reported by Wang Bo
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
neutron
Fix Released
Undecided
Wang Bo

Bug Description

Since db2 limitation, table will be in "reorg pending" state after some continuous alter table operations(add column, drop column). This means that the table is inaccessible for almost all operations until you perform a REORG.
When run neutron db upgrade, from 4ca36cfc898c to 157a5d299379, the alembic scripts in that range added 3 columns and dropped 1 column for table "ml2_port_bindings". That resulted in failure of table "ml2_port_bindings" in "reorg pending" state.
Same problem for downgrade migration.

environment: Openstack icehouse + DB2 10.5.

We can't restrict community developers how to operate tables and this only happen on DB2 but not other engines. So we could only test the alembic scripts on DB2 and fix it.

Tags: db2
Wang Bo (chestack)
Changed in neutron:
assignee: nobody → Wang Bo (chrische)
Changed in neutron:
status: New → In Progress
Matt Riedemann (mriedem)
tags: added: db2
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to neutron (master)

Reviewed: https://review.openstack.org/93271
Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=4a5da930e8baf1b370a6aab32fedb7f7bfb40930
Submitter: Jenkins
Branch: master

commit 4a5da930e8baf1b370a6aab32fedb7f7bfb40930
Author: wangbo <email address hidden>
Date: Mon May 12 15:18:03 2014 +0800

    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

Changed in neutron:
status: In Progress → Fix Committed
Thierry Carrez (ttx)
Changed in neutron:
milestone: none → juno-1
status: Fix Committed → Fix Released
Thierry Carrez (ttx)
Changed in neutron:
milestone: juno-1 → 2014.2
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.