Magnum

oslo_db.exception.DBError: (psycopg2.ProgrammingError) type "docker_storage_driver" does not exist

Bug #1609776 reported by Michal Jura on 2016-08-04

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	Magnum	Fix Released	Low	Michal Jura

Bug Description

During running /usr/bin/magnum-db-manage upgrade from Master branch

2016-08-04 12:15:35.945 | ++/opt/stack/magnum/devstack/lib/magnum:init_magnum:252 /usr/bin/magnum-db-manage upgrade
2016-08-04 12:15:37.212 | INFO [alembic.runtime.migration] Context impl PostgresqlImpl.
2016-08-04 12:15:37.212 | INFO [alembic.runtime.migration] Will assume transactional DDL.
2016-08-04 12:15:37.236 | INFO [alembic.runtime.migration] Running upgrade -> 2581ebaf0cb2, initial migration
2016-08-04 12:15:37.664 | INFO [alembic.runtime.migration] Running upgrade 2581ebaf0cb2 -> 3bea56f25597, Multi Tenant Support
2016-08-04 12:15:37.710 | INFO [alembic.runtime.migration] Running upgrade 3bea56f25597 -> 5793cd26898d, Add bay status
2016-08-04 12:15:37.711 | INFO [alembic.runtime.migration] Running upgrade 5793cd26898d -> 3a938526b35d, Add docker volume size column
2016-08-04 12:15:37.713 | INFO [alembic.runtime.migration] Running upgrade 3a938526b35d -> 35cff7c86221, add private network to baymodel
2016-08-04 12:15:37.714 | INFO [alembic.runtime.migration] Running upgrade 35cff7c86221 -> 1afee1db6cd0, Add master flavor
2016-08-04 12:15:37.715 | INFO [alembic.runtime.migration] Running upgrade 1afee1db6cd0 -> 2d1354bbf76e, ssh authorized key
2016-08-04 12:15:37.717 | INFO [alembic.runtime.migration] Running upgrade 2d1354bbf76e -> 29affeaa2bc2, rename-bay-master-address
2016-08-04 12:15:37.718 | INFO [alembic.runtime.migration] Running upgrade 29affeaa2bc2 -> 2ace4006498, rename-bay-minions-address
2016-08-04 12:15:37.719 | INFO [alembic.runtime.migration] Running upgrade 2ace4006498 -> 456126c6c9e9, create baylock table
2016-08-04 12:15:37.755 | INFO [alembic.runtime.migration] Running upgrade 456126c6c9e9 -> 4ea34a59a64c, add-discovery-url-to-bay
2016-08-04 12:15:37.757 | INFO [alembic.runtime.migration] Running upgrade 4ea34a59a64c -> e772b2598d9, add-container-command
2016-08-04 12:15:37.758 | INFO [alembic.runtime.migration] Running upgrade e772b2598d9 -> 2d8657c0cdc, add bay uuid
2016-08-04 12:15:37.759 | INFO [alembic.runtime.migration] Running upgrade 2d8657c0cdc -> 4956f03cabad, add cluster distro
2016-08-04 12:15:37.760 | INFO [alembic.runtime.migration] Running upgrade 4956f03cabad -> 592131657ca1, Add coe column to BayModel
2016-08-04 12:15:37.762 | INFO [alembic.runtime.migration] Running upgrade 592131657ca1 -> 3b6c4c42adb4, Add unique constraints
2016-08-04 12:15:38.236 | INFO [alembic.runtime.migration] Running upgrade 3b6c4c42adb4 -> 2b5f24dd95de, rename service port
2016-08-04 12:15:38.238 | INFO [alembic.runtime.migration] Running upgrade 2b5f24dd95de -> 59e7664a8ba1, add_container_status
2016-08-04 12:15:38.240 | INFO [alembic.runtime.migration] Running upgrade 59e7664a8ba1 -> 156ceb17fb0a, add_bay_status_reason
2016-08-04 12:15:38.241 | INFO [alembic.runtime.migration] Running upgrade 156ceb17fb0a -> 1c1ff5e56048, rename_container_image_id
2016-08-04 12:15:38.242 | INFO [alembic.runtime.migration] Running upgrade 1c1ff5e56048 -> 53882537ac57, add host column to pod
2016-08-04 12:15:38.244 | INFO [alembic.runtime.migration] Running upgrade 53882537ac57 -> 14328d6a57e3, add master count to bay
2016-08-04 12:15:38.245 | INFO [alembic.runtime.migration] Running upgrade 14328d6a57e3 -> 421102d1f2d2, create x509keypair table
2016-08-04 12:15:38.402 | INFO [alembic.runtime.migration] Running upgrade 421102d1f2d2 -> 6f21dc998bb, Add master_addresses to bay
2016-08-04 12:15:38.404 | INFO [alembic.runtime.migration] Running upgrade 6f21dc998bb -> 966a99e70ff, add-proxy
2016-08-04 12:15:38.408 | INFO [alembic.runtime.migration] Running upgrade 966a99e70ff -> 6f21dc920bb, Add cert_uuuid to bay
2016-08-04 12:15:38.411 | INFO [alembic.runtime.migration] Running upgrade 6f21dc920bb -> 5518af8dbc21, Rename cert_uuid
2016-08-04 12:15:38.417 | INFO [alembic.runtime.migration] Running upgrade 5518af8dbc21 -> 4e263f236334, Add registry_enabled
2016-08-04 12:15:38.419 | INFO [alembic.runtime.migration] Running upgrade 4e263f236334 -> 3be65537a94a, add_network_driver_baymodel_column
2016-08-04 12:15:38.420 | INFO [alembic.runtime.migration] Running upgrade 3be65537a94a -> 1481f5b560dd, add labels column to baymodel table
2016-08-04 12:15:38.421 | INFO [alembic.runtime.migration] Running upgrade 1481f5b560dd -> 1d045384b966, add-insecure-baymodel-attr
2016-08-04 12:15:38.423 | INFO [alembic.runtime.migration] Running upgrade 1d045384b966 -> 27ad304554e2, adding magnum_service functionality
2016-08-04 12:15:38.591 | INFO [alembic.runtime.migration] Running upgrade 27ad304554e2 -> 5ad410481b88, rename-insecure
2016-08-04 12:15:38.593 | INFO [alembic.runtime.migration] Running upgrade 5ad410481b88 -> 2ae93c9c6191, add public column to baymodel table
2016-08-04 12:15:38.595 | INFO [alembic.runtime.migration] Running upgrade 2ae93c9c6191 -> 33ef79969018, Add memory to container
2016-08-04 12:15:38.597 | INFO [alembic.runtime.migration] Running upgrade 33ef79969018 -> 417917e778f5, Add server_type column to baymodel
2016-08-04 12:15:38.767 | INFO [alembic.runtime.migration] Running upgrade 417917e778f5 -> 5977879072a7, add-env-to-container
2016-08-04 12:15:38.769 | INFO [alembic.runtime.migration] Running upgrade 5977879072a7 -> 40f325033343, add bay_create_timeout to bay
2016-08-04 12:15:38.771 | INFO [alembic.runtime.migration] Running upgrade 40f325033343 -> adc3b7679ae, add registry_trust_id to bay
2016-08-04 12:15:38.773 | INFO [alembic.runtime.migration] Running upgrade adc3b7679ae -> 57fbdf2327a2, remove baylock
2016-08-04 12:15:38.776 | INFO [alembic.runtime.migration] Running upgrade 57fbdf2327a2 -> 05d3e97de9ee, add volume driver
2016-08-04 12:15:38.779 | INFO [alembic.runtime.migration] Running upgrade 05d3e97de9ee -> bb42b7cad130, remove node object
2016-08-04 12:15:38.782 | INFO [alembic.runtime.migration] Running upgrade bb42b7cad130 -> 5d4caa6e0a42, create trustee for each bay
2016-08-04 12:15:38.785 | INFO [alembic.runtime.migration] Running upgrade 5d4caa6e0a42 -> ee92b41b8809, Introduce Quotas
2016-08-04 12:15:38.907 | INFO [alembic.runtime.migration] Running upgrade ee92b41b8809 -> 049f81f6f584, remove_ssh_authorized_key_from_baymodel
2016-08-04 12:15:38.908 | INFO [alembic.runtime.migration] Running upgrade 049f81f6f584 -> e647f5931da8, add insecure_registry to baymodel
2016-08-04 12:15:38.910 | INFO [alembic.runtime.migration] Running upgrade e647f5931da8 -> ef08a5e057bd, remove pod object
2016-08-04 12:15:38.913 | INFO [alembic.runtime.migration] Running upgrade ef08a5e057bd -> d072f58ab240, modify x509keypair table
2016-08-04 12:15:38.916 | INFO [alembic.runtime.migration] Running upgrade d072f58ab240 -> a1136d335540, Add docker storage driver column
2016-08-04 12:15:38.924 | Traceback (most recent call last):
2016-08-04 12:15:38.925 | File "/usr/bin/magnum-db-manage", line 10, in <module>
2016-08-04 12:15:38.925 | sys.exit(main())
2016-08-04 12:15:38.925 | File "/opt/stack/magnum/magnum/cmd/db_manage.py", line 67, in main
2016-08-04 12:15:38.925 | CONF.command.func()
2016-08-04 12:15:38.925 | File "/opt/stack/magnum/magnum/cmd/db_manage.py", line 29, in do_upgrade
2016-08-04 12:15:38.925 | migration.upgrade(CONF.command.revision)
2016-08-04 12:15:38.925 | File "/opt/stack/magnum/magnum/db/migration.py", line 36, in upgrade
2016-08-04 12:15:38.925 | return get_backend().upgrade(version)
2016-08-04 12:15:38.925 | File "/opt/stack/magnum/magnum/db/sqlalchemy/migration.py", line 57, in upgrade
2016-08-04 12:15:38.925 | get_manager().upgrade(version)
2016-08-04 12:15:38.925 | File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/migration_cli/manager.py", line 67, in upgrade
2016-08-04 12:15:38.925 | results.append(plugin.upgrade(revision))
2016-08-04 12:15:38.925 | File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/migration_cli/ext_alembic.py", line 55, in upgrade
2016-08-04 12:15:38.925 | return alembic.command.upgrade(self.config, version or 'head')
2016-08-04 12:15:38.925 | File "/usr/lib/python2.7/site-packages/alembic/command.py", line 174, in upgrade
2016-08-04 12:15:38.925 | script.run_env()
2016-08-04 12:15:38.925 | File "/usr/lib/python2.7/site-packages/alembic/script/base.py", line 407, in run_env
2016-08-04 12:15:38.925 | util.load_python_file(self.dir, 'env.py')
2016-08-04 12:15:38.925 | File "/usr/lib/python2.7/site-packages/alembic/util/pyfiles.py", line 93, in load_python_file
2016-08-04 12:15:38.925 | module = load_module_py(module_id, path)
2016-08-04 12:15:38.925 | File "/usr/lib/python2.7/site-packages/alembic/util/compat.py", line 79, in load_module_py
2016-08-04 12:15:38.925 | mod = imp.load_source(module_id, path, fp)
2016-08-04 12:15:38.925 | File "/opt/stack/magnum/magnum/db/sqlalchemy/alembic/env.py", line 54, in <module>
2016-08-04 12:15:38.925 | run_migrations_online()
2016-08-04 12:15:38.925 | File "/opt/stack/magnum/magnum/db/sqlalchemy/alembic/env.py", line 51, in run_migrations_online
2016-08-04 12:15:38.925 | context.run_migrations()
2016-08-04 12:15:38.925 | File "<string>", line 8, in run_migrations
2016-08-04 12:15:38.925 | File "/usr/lib/python2.7/site-packages/alembic/runtime/environment.py", line 797, in run_migrations
2016-08-04 12:15:38.925 | self.get_context().run_migrations(**kw)
2016-08-04 12:15:38.925 | File "/usr/lib/python2.7/site-packages/alembic/runtime/migration.py", line 312, in run_migrations
2016-08-04 12:15:38.925 | step.migration_fn(**kw)
2016-08-04 12:15:38.925 | File "/opt/stack/magnum/magnum/db/sqlalchemy/alembic/versions/a1136d335540_add_docker_storage_driver_column.py", line 35, in upgrade
2016-08-04 12:15:38.925 | nullable=True))
2016-08-04 12:15:38.925 | File "<string>", line 8, in add_column
2016-08-04 12:15:38.925 | File "<string>", line 3, in add_column
2016-08-04 12:15:38.925 | File "/usr/lib/python2.7/site-packages/alembic/operations/ops.py", line 1535, in add_column
2016-08-04 12:15:38.925 | return operations.invoke(op)
2016-08-04 12:15:38.925 | File "/usr/lib/python2.7/site-packages/alembic/operations/base.py", line 318, in invoke
2016-08-04 12:15:38.926 | return fn(self, operation)
2016-08-04 12:15:38.926 | File "/usr/lib/python2.7/site-packages/alembic/operations/toimpl.py", line 123, in add_column
2016-08-04 12:15:38.926 | schema=schema
2016-08-04 12:15:38.926 | File "/usr/lib/python2.7/site-packages/alembic/ddl/impl.py", line 172, in add_column
2016-08-04 12:15:38.926 | self._exec(base.AddColumn(table_name, column, schema=schema))
2016-08-04 12:15:38.926 | File "/usr/lib/python2.7/site-packages/alembic/ddl/impl.py", line 118, in _exec
2016-08-04 12:15:38.926 | return conn.execute(construct, *multiparams, **params)
2016-08-04 12:15:38.926 | File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
2016-08-04 12:15:38.926 | return meth(self, multiparams, params)
2016-08-04 12:15:38.926 | File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
2016-08-04 12:15:38.926 | return connection._execute_ddl(self, multiparams, params)
2016-08-04 12:15:38.926 | File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 968, in _execute_ddl
2016-08-04 12:15:38.926 | compiled
2016-08-04 12:15:38.926 | File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
2016-08-04 12:15:38.926 | context)
2016-08-04 12:15:38.926 | File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
2016-08-04 12:15:38.926 | util.raise_from_cause(newraise, exc_info)
2016-08-04 12:15:38.926 | File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
2016-08-04 12:15:38.926 | reraise(type(exception), exception, tb=exc_tb, cause=cause)
2016-08-04 12:15:38.926 | File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2016-08-04 12:15:38.927 | context)
2016-08-04 12:15:38.927 | File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2016-08-04 12:15:38.927 | cursor.execute(statement, parameters)
2016-08-04 12:15:38.927 | oslo_db.exception.DBError: (psycopg2.ProgrammingError) type "docker_storage_driver" does not exist
2016-08-04 12:15:38.927 | LINE 1: ...R TABLE baymodel ADD COLUMN docker_storage_driver docker_sto...
2016-08-04 12:15:38.927 | ^
2016-08-04 12:15:38.927 | [SQL: 'ALTER TABLE baymodel ADD COLUMN docker_storage_driver docker_storage_driver']
2016-08-04 12:15:38.981 | +/opt/stack/magnum/devstack/lib/magnum:init_magnum:1 exit_trap
2016-08-04 12:15:38.988 | +./stack.sh:exit_trap:480 local r=1
2016-08-04 12:15:38.995 | ++./stack.sh:exit_trap:481 jobs -p
2016-08-04 12:15:39.001 | +./stack.sh:exit_trap:481 jobs=
2016-08-04 12:15:39.007 | +./stack.sh:exit_trap:484 [[ -n '' ]]
2016-08-04 12:15:39.012 | +./stack.sh:exit_trap:490 kill_spinner
2016-08-04 12:15:39.018 | +./stack.sh:kill_spinner:376 '[' '!' -z '' ']'
2016-08-04 12:15:39.024 | +./stack.sh:exit_trap:492 [[ 1 -ne 0 ]]
2016-08-04 12:15:39.029 | +./stack.sh:exit_trap:493 echo 'Error on exit'
2016-08-04 12:15:39.029 | Error on exit
2016-08-04 12:15:39.034 | +./stack.sh:exit_trap:494 generate-subunit 1470312049 891 fail
2016-08-04 12:15:39.277 | +./stack.sh:exit_trap:495 [[ -z /opt/stack/logs ]]
2016-08-04 12:15:39.282 | +./stack.sh:exit_trap:498 /tmp/devstack/tools/worlddump.py -d /opt/stack/logs
2016-08-04 12:15:40.463 | +./stack.sh:exit_trap:504 exit 1

Revision history for this message

OpenStack Infra (hudson-openstack) wrote on 2016-08-04: Fix proposed to magnum (master)

Fix proposed to branch: master
Review: https://review.openstack.org/351154

Changed in magnum:
assignee:	nobody → Michal Jura (mjura)
status:	New → In Progress

Adrian Otto (aotto) on 2016-08-05

Changed in magnum:
importance:	Undecided → Low

Revision history for this message

OpenStack Infra (hudson-openstack) wrote on 2016-08-11: Fix merged to magnum (master)

Reviewed: https://review.openstack.org/351154
Committed: https://git.openstack.org/cgit/openstack/magnum/commit/?id=e76ca364ab979e309d34ff458ef2629145a52ce2
Submitter: Jenkins
Branch: master

commit e76ca364ab979e309d34ff458ef2629145a52ce2
Author: Michal Jura <email address hidden>
Date: Thu Aug 4 14:40:10 2016 +0200

Fix for enum type docker_storage_driver

Create enum type "docker_storage_driver" for migration

    This is fixing
       oslo_db.exception.DBError: (psycopg2.ProgrammingError) type
       "docker_storage_driver" does not exist

Closes-Bug: #1609776

Change-Id: I92d427e90bd73b4114d8688d3761cabac450fc9d

Changed in magnum:
status:	In Progress → Fix Released

Revision history for this message

OpenStack Infra (hudson-openstack) wrote on 2016-08-31: Fix included in openstack/magnum 3.0.0

This issue was fixed in the openstack/magnum 3.0.0 release.

Report a bug

This report contains Public information

Everyone can see this information.

You are

Subscribing...

Edit bug mail

Other bug subscribers

Remote bug watches

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