Activity log for bug #1536876

Date Who What changed Old value New value Message
2016-01-22 02:49:26 Gerard Braad bug added bug
2016-01-22 02:49:26 Gerard Braad attachment added console-out.txt https://bugs.launchpad.net/bugs/1536876/+attachment/4554426/+files/console-out.txt
2016-01-22 02:50:02 Gerard Braad attachment added local.conf https://bugs.launchpad.net/octavia/+bug/1536876/+attachment/4554427/+files/local.conf
2016-01-22 02:50:20 Gerard Braad attachment added alembic-log.txt https://bugs.launchpad.net/octavia/+bug/1536876/+attachment/4554428/+files/alembic-log.txt
2016-01-22 03:53:58 Gerard Braad description When deploying DevStack with neutron-lbaas and octavia it fails on the alembic database migrations of octavia. The output reads: File "/opt/stack/octavia/octavia/db/migration/alembic_migrations/versions/43287cd10fef_make_pool_lb_algorithm_larger.py", line 33, in upgrade existing_type=sa.String(255)) File "<string>", line 8, in alter_column File "<string>", line 3, in alter_column File "/usr/lib/python2.7/site-packages/alembic/operations/ops.py", line 1414, in alter_column File "<string>", line 8, in alter_column The issue is reproducible after ./unstack.sh and after removing the mysql databases and rerunning ./stack.sh When deploying DevStack with neutron-lbaas and octavia it fails on the alembic database migrations of octavia. The output reads:   File "/opt/stack/octavia/octavia/db/migration/alembic_migrations/versions/43287cd10fef_make_pool_lb_algorithm_larger.py", line 33, in upgrade     existing_type=sa.String(255))   File "<string>", line 8, in alter_column   File "<string>", line 3, in alter_column   File "/usr/lib/python2.7/site-packages/alembic/operations/ops.py", line 1414, in alter_column   File "<string>", line 8, in alter_column The issue is reproducible after ./unstack.sh and after removing the mysql databases and rerunning ./stack.sh sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1832, u"Cannot change column 'lb_algorithm': used in a foreign key constraint 'fk_pool_algorithm_name'") [SQL: u'ALTER TABLE pool MODIFY lb_algorithm VARCHAR(255) NOT NULL']
2016-01-22 03:54:27 Gerard Braad description When deploying DevStack with neutron-lbaas and octavia it fails on the alembic database migrations of octavia. The output reads:   File "/opt/stack/octavia/octavia/db/migration/alembic_migrations/versions/43287cd10fef_make_pool_lb_algorithm_larger.py", line 33, in upgrade     existing_type=sa.String(255))   File "<string>", line 8, in alter_column   File "<string>", line 3, in alter_column   File "/usr/lib/python2.7/site-packages/alembic/operations/ops.py", line 1414, in alter_column   File "<string>", line 8, in alter_column The issue is reproducible after ./unstack.sh and after removing the mysql databases and rerunning ./stack.sh sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1832, u"Cannot change column 'lb_algorithm': used in a foreign key constraint 'fk_pool_algorithm_name'") [SQL: u'ALTER TABLE pool MODIFY lb_algorithm VARCHAR(255) NOT NULL'] When deploying DevStack with neutron-lbaas and octavia it fails on the alembic database migrations of octavia. The output reads:   File "/opt/stack/octavia/octavia/db/migration/alembic_migrations/versions/43287cd10fef_make_pool_lb_algorithm_larger.py", line 33, in upgrade     existing_type=sa.String(255))   File "<string>", line 8, in alter_column   File "<string>", line 3, in alter_column   File "/usr/lib/python2.7/site-packages/alembic/operations/ops.py", line 1414, in alter_column   File "<string>", line 8, in alter_column sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1832, u"Cannot change column 'lb_algorithm': used in a foreign key constraint 'fk_pool_algorithm_name'") [SQL: u'ALTER TABLE pool MODIFY lb_algorithm VARCHAR(255) NOT NULL'] The issue is reproducible after ./unstack.sh and after removing the mysql databases and rerunning ./stack.sh
2016-01-22 04:07:58 Gerard Braad description When deploying DevStack with neutron-lbaas and octavia it fails on the alembic database migrations of octavia. The output reads:   File "/opt/stack/octavia/octavia/db/migration/alembic_migrations/versions/43287cd10fef_make_pool_lb_algorithm_larger.py", line 33, in upgrade     existing_type=sa.String(255))   File "<string>", line 8, in alter_column   File "<string>", line 3, in alter_column   File "/usr/lib/python2.7/site-packages/alembic/operations/ops.py", line 1414, in alter_column   File "<string>", line 8, in alter_column sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1832, u"Cannot change column 'lb_algorithm': used in a foreign key constraint 'fk_pool_algorithm_name'") [SQL: u'ALTER TABLE pool MODIFY lb_algorithm VARCHAR(255) NOT NULL'] The issue is reproducible after ./unstack.sh and after removing the mysql databases and rerunning ./stack.sh When deploying DevStack with neutron-lbaas and octavia it fails on the alembic database migrations of octavia. The output reads:   File "/opt/stack/octavia/octavia/db/migration/alembic_migrations/versions/43287cd10fef_make_pool_lb_algorithm_larger.py", line 33, in upgrade     existing_type=sa.String(255))   File "<string>", line 8, in alter_column   File "<string>", line 3, in alter_column   File "/usr/lib/python2.7/site-packages/alembic/operations/ops.py", line 1414, in alter_column   File "<string>", line 8, in alter_column sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1832, u"Cannot change column 'lb_algorithm': used in a foreign key constraint 'fk_pool_algorithm_name'") [SQL: u'ALTER TABLE pool MODIFY lb_algorithm VARCHAR(255) NOT NULL'] The issue is reproducible after ./unstack.sh and after removing the mysql databases and rerunning ./stack.sh Current versions of components: octavia 820829d36baf23cfc502fe20929687fb4ae44d4e neutron-lbaas 860d7b73b315227cf993cb81ac5ed66e964bd4e4 neutron c068c3f3c115fde79b8a9aec9e13838744c85ad1
2016-01-22 06:51:13 Banashankar octavia: assignee Banashankar (bkalebe)
2016-01-22 08:19:08 OpenStack Infra octavia: status New In Progress
2016-01-26 18:40:11 Nir Magnezi bug added subscriber Nir Magnezi
2016-01-27 01:02:52 OpenStack Infra octavia: status In Progress Fix Released