++ iniset /opt/stack/octavia/octavia/db/migration/alembic.ini alembic sqlalchemy.url mysql+pymysql://root:secrete@127.0.0.1:33
06/octavia
++ local xtrace
+++ set +o
+++ grep xtrace
++ xtrace='set -o xtrace'
++ set +o xtrace
++ alembic -c /opt/stack/octavia/octavia/db/migration/alembic.ini upgrade head 
INFO  [alembic.runtime.migration] Context impl MySQLImpl.
INFO  [alembic.runtime.migration] Will assume non-transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade  -> 35dee79d5865, initial_create
INFO  [alembic.runtime.migration] Running upgrade 35dee79d5865 -> 4c094013699a, update load balancer amphora relationship
INFO  [alembic.runtime.migration] Running upgrade 4c094013699a -> 13500e2e978d, update url and name size
INFO  [alembic.runtime.migration] Running upgrade 13500e2e978d -> 4faaa983e7a9, update member address column
INFO  [alembic.runtime.migration] Running upgrade 4faaa983e7a9 -> 3a1e1cdb7b27, rename amphora host id
INFO  [alembic.runtime.migration] Running upgrade 3a1e1cdb7b27 -> 14892634e228, update vip
INFO  [alembic.runtime.migration] Running upgrade 14892634e228 -> 256852d5ff7c, add lb_network_ip to amphora
INFO  [alembic.runtime.migration] Running upgrade 256852d5ff7c -> 92fe9857279, create healthmanager table
INFO  [alembic.runtime.migration] Running upgrade 92fe9857279 -> 3e5b37a0bdb9, Add vrrp_ip and ha_ip to amphora
INFO  [alembic.runtime.migration] Running upgrade 3e5b37a0bdb9 -> 48660b6643f0, add new states for amphora
INFO  [alembic.runtime.migration] Running upgrade 48660b6643f0 -> 4fe8240425b4, update vip add subnet id
INFO  [alembic.runtime.migration] Running upgrade 4fe8240425b4 -> 298eac0640a7, Add vrrp_port_id and ha_port_id to amphora
INFO  [alembic.runtime.migration] Running upgrade 298eac0640a7 -> 357d17a6d5ac, update lb and amphora data model for active pa
ssive
INFO  [alembic.runtime.migration] Running upgrade 357d17a6d5ac -> 2351ea316465, Adding TERMINATED_HTTPS support and TLS ref ID
 char length increase
INFO  [alembic.runtime.migration] Running upgrade 2351ea316465 -> 543f5d8e4e56, Add a column busy in table amphora health
INFO  [alembic.runtime.migration] Running upgrade 543f5d8e4e56 -> 3b199c848b96, Create NO_MONITOR operational_status
INFO  [alembic.runtime.migration] Running upgrade 3b199c848b96 -> 5a3ee5472c31, add cert expiration infor in amphora table
INFO  [alembic.runtime.migration] Running upgrade 5a3ee5472c31 -> 1e4c1d83044c, Keepalived configuration datamodel
INFO  [alembic.runtime.migration] Running upgrade 1e4c1d83044c -> 6abb04f24c5, Tenant id to project id
INFO  [alembic.runtime.migration] Running upgrade 6abb04f24c5 -> 43287cd10fef, Make pool.lb_algorithm larger
Traceback (most recent call last):
  File "/bin/alembic", line 11, in <module>
    sys.exit(main())
  File "/usr/lib/python2.7/site-packages/alembic/config.py", line 471, in main 
    CommandLine(prog=prog).main(argv=argv)
  File "/usr/lib/python2.7/site-packages/alembic/config.py", line 465, in main 
    self.run_cmd(cfg, options)
  File "/usr/lib/python2.7/site-packages/alembic/config.py", line 448, in run_cmd
    **dict((k, getattr(options, k)) for k in kwarg)
  File "/usr/lib/python2.7/site-packages/alembic/command.py", line 174, in upgrade
    script.run_env()
  File "/usr/lib/python2.7/site-packages/alembic/script/base.py", line 397, in run_env
    util.load_python_file(self.dir, 'env.py')
  File "/usr/lib/python2.7/site-packages/alembic/util/pyfiles.py", line 81, in load_python_file
    module = load_module_py(module_id, path)
  File "/usr/lib/python2.7/site-packages/alembic/util/compat.py", line 79, in load_module_py
    mod = imp.load_source(module_id, path, fp)
  File "/opt/stack/octavia/octavia/db/migration/alembic_migrations/env.py", line 84, in <module>
    run_migrations_online()
  File "/opt/stack/octavia/octavia/db/migration/alembic_migrations/env.py", line 77, in run_migrations_online
    context.run_migrations()
  File "<string>", line 8, in run_migrations
  File "/usr/lib/python2.7/site-packages/alembic/runtime/environment.py", line 797, in run_migrations
    self.get_context().run_migrations(**kw)
  File "/usr/lib/python2.7/site-packages/alembic/runtime/migration.py", line 312, in run_migrations
    step.migration_fn(**kw)
  File "/opt/stack/octavia/octavia/db/migration/alembic_migrations/versions/43287cd10fef_make_pool_lb_algorithm_larger.py", li
ne 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
    return operations.invoke(alt)
  File "/usr/lib/python2.7/site-packages/alembic/operations/base.py", line 318, in invoke
    return fn(self, operation)
  File "/usr/lib/python2.7/site-packages/alembic/operations/toimpl.py", line 53, in alter_column
    **operation.kw
  File "/usr/lib/python2.7/site-packages/alembic/ddl/mysql.py", line 66, in alter_column
    else existing_autoincrement
  File "/usr/lib/python2.7/site-packages/alembic/ddl/impl.py", line 118, in _exec
    return conn.execute(construct, *multiparams, **params)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
    return meth(self, multiparams, params)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
    return connection._execute_ddl(self, multiparams, params)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 968, in _execute_ddl
    compiled
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
    context)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
    exc_info
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
    context)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 146, in execute
    result = self._query(query)
  File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 296, in _query
    conn.query(q)
  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 781, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 942, in _read_query_result
    result.read()
  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1138, in read
    first_packet = self.connection._read_packet()
  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 906, in _read_packet
    packet.check_error()
  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 367, in check_error
    err.raise_mysql_exception(self._data)
  File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 120, in raise_mysql_exception
    _check_mysql_exception(errinfo)
  File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 115, in _check_mysql_exception
    raise InternalError(errno, errorvalue)
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']
+ exit_trap
+ local r=1
++ jobs -p
+ jobs=
+ [[ -n '' ]]
+ kill_spinner
+ '[' '!' -z '' ']'
+ [[ 1 -ne 0 ]]
+ echo 'Error on exit'
Error on exit
+ [[ -z /opt/stack/logs ]]
+ /home/stack/devstack/tools/worlddump.py -d /opt/stack/logs
World dumping... see /opt/stack/logs/worlddump-2016-01-21-124841.txt for details
+ exit 1