I have deleted all tables of the tacker database and run the command for created schema. It's updating till "8a7ca803e0d0 -> c47a733f425a" and after that giving following error :
File "/usr/local/lib/python3.6/site-packages/tacker/db/migration/alembic_migrations/versions/c47a733f425a_add_vnflcm_subscription.py", line 60, in upgrade
sa.Computed(noti_str)),
AttributeError: module 'sqlalchemy' has no attribute 'Computed'
== Complete output ==
[root@localhost ~(keystone_admin)]# tacker-db-manage --config-file /etc/tacker/tacker.conf upgrade head
INFO [alembic.runtime.migration] Context impl MySQLImpl.
INFO [alembic.runtime.migration] Will assume non-transactional DDL.
INFO [alembic.runtime.migration] Running upgrade -> 1c6b0d82afcd, add tables for tacker framework
INFO [alembic.runtime.migration] Running upgrade 1c6b0d82afcd -> 81ffa86020d, rpc_proxy
INFO [alembic.runtime.migration] Running upgrade 81ffa86020d -> 4c31092895b8, empty message
INFO [alembic.runtime.migration] Running upgrade 4c31092895b8 -> 13c0e0661015, add description to vnf
INFO [alembic.runtime.migration] Running upgrade 13c0e0661015 -> 5958429bcb3c, modify datatype of value
INFO [alembic.runtime.migration] Running upgrade 5958429bcb3c -> 12a57080b277, Add Service related dbs
INFO [alembic.runtime.migration] Running upgrade 12a57080b277 -> 12a57080b278, Alter devices
INFO [alembic.runtime.migration] Running upgrade 12a57080b278 -> 2774a42c7163, remove service related
INFO [alembic.runtime.migration] Running upgrade 2774a42c7163 -> 24bec5f211c7, Alter value in deviceattributes
INFO [alembic.runtime.migration] Running upgrade 24bec5f211c7 -> 5246a6bd410f, multisite_vim
INFO [alembic.runtime.migration] Running upgrade 5246a6bd410f -> acf941e54075, Add error_reason to device
INFO [alembic.runtime.migration] Running upgrade acf941e54075 -> f958f58e5daa, uuid consistency
INFO [alembic.runtime.migration] Running upgrade f958f58e5daa -> 6e56d4474b2a, blob-to-json-text
INFO [alembic.runtime.migration] Running upgrade 6e56d4474b2a -> c7cde2f45f82, set-description-to-text
INFO [alembic.runtime.migration] Running upgrade c7cde2f45f82 -> b07673bb8654, set-status-type-tenant-id-length
INFO [alembic.runtime.migration] Running upgrade b07673bb8654 -> 354de64ba129, set-mandatory-columns-not-null
INFO [alembic.runtime.migration] Running upgrade 354de64ba129 -> 5f88e86b35c7, make VNFD/VNF/VIM name mandatory
INFO [alembic.runtime.migration] Running upgrade 5f88e86b35c7 -> 22f5385a3d3f, Add status to vims
INFO [alembic.runtime.migration] Running upgrade 22f5385a3d3f -> d4f265e8eb9d, add default to vim
INFO [alembic.runtime.migration] Running upgrade d4f265e8eb9d -> 22f5385a3d4f, remove proxydb related
INFO [alembic.runtime.migration] Running upgrade 22f5385a3d4f -> 22f5385a3d50, rename device db tables
INFO [alembic.runtime.migration] Running upgrade 22f5385a3d50 -> 2ff0a0e360f1, audit support
INFO [alembic.runtime.migration] Running upgrade 2ff0a0e360f1 -> 941b5a6fff9e, enable soft delete
INFO [alembic.runtime.migration] Running upgrade 941b5a6fff9e -> 4ee19c8a6d0a, audit_support_events
INFO [alembic.runtime.migration] Running upgrade 4ee19c8a6d0a -> 507122918800, adds_VNFFG
INFO [alembic.runtime.migration] Running upgrade 507122918800 -> 0ae5b1ce3024, unique_constraint_name
INFO [alembic.runtime.migration] Running upgrade 0ae5b1ce3024 -> 8f7145914cb0, remove infra_driver column
INFO [alembic.runtime.migration] Running upgrade 8f7145914cb0 -> 0ad3bbce1c18, create of Network service tables
INFO [alembic.runtime.migration] Running upgrade 0ad3bbce1c18 -> 0ad3bbce1c19, increase_vim_password_size
INFO [alembic.runtime.migration] Running upgrade 0ad3bbce1c19 -> 000632983ada, add template_source column
INFO [alembic.runtime.migration] Running upgrade 000632983ada -> e8918cda6433, add_attributes_to_vnffg
INFO [alembic.runtime.migration] Running upgrade e8918cda6433 -> ef14f8026327, add default onboarded template source
INFO [alembic.runtime.migration] Running upgrade ef14f8026327 -> c256228ed37c, unique constraint on name and id
INFO [alembic.runtime.migration] Running upgrade c256228ed37c -> e7993093baf1, add unique constraint on deleted_at
INFO [alembic.runtime.migration] Running upgrade e7993093baf1 -> 31acbaeb8299, change_vim_shared_property_to_false
INFO [alembic.runtime.migration] Running upgrade 31acbaeb8299 -> f5c1c3b0f6b4, set default value for deleted_at
INFO [alembic.runtime.migration] Running upgrade f5c1c3b0f6b4 -> e9a1e47fb0b5, add onboarded status for vnffgd and nsd
INFO [alembic.runtime.migration] Running upgrade e9a1e47fb0b5 -> 5d490546290c, add_name_to_classifiers
INFO [alembic.runtime.migration] Running upgrade 5d490546290c -> 4747cc26b9c6, add support vnffg to ns database
INFO [alembic.runtime.migration] Running upgrade 4747cc26b9c6 -> 13ecc2dd6f7f, Change nullable value of path_id
INFO [alembic.runtime.migration] Running upgrade 13ecc2dd6f7f -> cd04a8335c18, mgmt_url to mgmt_ip_address
INFO [alembic.runtime.migration] Running upgrade cd04a8335c18 -> 9d425296f2c3, add db tables for vnf packages
INFO [alembic.runtime.migration] Running upgrade 9d425296f2c3 -> abbef484b34c, modify_unique_constraint_on_vnf_packages_user_data
INFO [alembic.runtime.migration] Running upgrade abbef484b34c -> 975e28392888, Add unique constraints on vnfd_id,deleted in vnf_package_vnfd
INFO [alembic.runtime.migration] Running upgrade 975e28392888 -> 985e28392890, VNF instance management changes
INFO [alembic.runtime.migration] Running upgrade 985e28392890 -> d2e39e01d540, add size column to vnf_packages table
INFO [alembic.runtime.migration] Running upgrade d2e39e01d540 -> e06fbdc90a32, add db tables for add artifacts
INFO [alembic.runtime.migration] Running upgrade e06fbdc90a32 -> f9bc96967462, add_vnf_pkg_id_to_vnf_instances
INFO [alembic.runtime.migration] Running upgrade f9bc96967462 -> 745e3e9fe5e2, add_vnf_metadata_to_vnflcm_db
INFO [alembic.runtime.migration] Running upgrade 745e3e9fe5e2 -> aaf461c8844c, change type for vnf_resources and vnf_instantiated_info table
INFO [alembic.runtime.migration] Running upgrade aaf461c8844c -> 8a7ca803e0d0, add_vnfc_info_to_instantiated_vnf_info
INFO [alembic.runtime.migration] Running upgrade 8a7ca803e0d0 -> c47a733f425a, add_vnflcm_subscription
Traceback (most recent call last):
File "/usr/local/bin/tacker-db-manage", line 10, in <module>
sys.exit(main())
File "/usr/local/lib/python3.6/site-packages/tacker/db/migration/cli.py", line 178, in main
CONF.command.func(config, CONF.command.name)
File "/usr/local/lib/python3.6/site-packages/tacker/db/migration/cli.py", line 68, in do_upgrade
do_alembic_command(config, cmd, revision, sql=CONF.command.sql)
File "/usr/local/lib/python3.6/site-packages/tacker/db/migration/cli.py", line 47, in do_alembic_command
getattr(alembic_command, cmd)(config, *args, **kwargs)
File "/usr/lib/python3.6/site-packages/alembic/command.py", line 298, in upgrade
script.run_env()
File "/usr/lib/python3.6/site-packages/alembic/script/base.py", line 489, in run_env
util.load_python_file(self.dir, "env.py")
File "/usr/lib/python3.6/site-packages/alembic/util/pyfiles.py", line 98, in load_python_file
module = load_module_py(module_id, path)
File "/usr/lib/python3.6/site-packages/alembic/util/compat.py", line 173, in load_module_py
spec.loader.exec_module(module)
File "<frozen importlib._bootstrap_external>", line 678, in exec_module
File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
File "/usr/local/lib/python3.6/site-packages/tacker/db/migration/alembic_migrations/env.py", line 84, in <module>
run_migrations_online()
File "/usr/local/lib/python3.6/site-packages/tacker/db/migration/alembic_migrations/env.py", line 76, in run_migrations_online
context.run_migrations()
File "<string>", line 8, in run_migrations
File "/usr/lib/python3.6/site-packages/alembic/runtime/environment.py", line 846, in run_migrations
self.get_context().run_migrations(**kw)
File "/usr/lib/python3.6/site-packages/alembic/runtime/migration.py", line 518, in run_migrations
step.migration_fn(**kw)
File "/usr/local/lib/python3.6/site-packages/tacker/db/migration/alembic_migrations/versions/c47a733f425a_add_vnflcm_subscription.py", line 60, in upgrade
sa.Computed(noti_str)),
AttributeError: module 'sqlalchemy' has no attribute 'Computed'
I have deleted all tables of the tacker database and run the command for created schema. It's updating till "8a7ca803e0d0 -> c47a733f425a" and after that giving following error :
File "/usr/local/ lib/python3. 6/site- packages/ tacker/ db/migration/ alembic_ migrations/ versions/ c47a733f425a_ add_vnflcm_ subscription. py", line 60, in upgrade Computed( noti_str) ),
sa.
AttributeError: module 'sqlalchemy' has no attribute 'Computed'
== Complete output ==
[root@localhost ~(keystone_admin)]# tacker-db-manage --config-file /etc/tacker/ tacker. conf upgrade head runtime. migration] Context impl MySQLImpl. runtime. migration] Will assume non-transactional DDL. runtime. migration] Running upgrade -> 1c6b0d82afcd, add tables for tacker framework runtime. migration] Running upgrade 1c6b0d82afcd -> 81ffa86020d, rpc_proxy runtime. migration] Running upgrade 81ffa86020d -> 4c31092895b8, empty message runtime. migration] Running upgrade 4c31092895b8 -> 13c0e0661015, add description to vnf runtime. migration] Running upgrade 13c0e0661015 -> 5958429bcb3c, modify datatype of value runtime. migration] Running upgrade 5958429bcb3c -> 12a57080b277, Add Service related dbs runtime. migration] Running upgrade 12a57080b277 -> 12a57080b278, Alter devices runtime. migration] Running upgrade 12a57080b278 -> 2774a42c7163, remove service related runtime. migration] Running upgrade 2774a42c7163 -> 24bec5f211c7, Alter value in deviceattributes runtime. migration] Running upgrade 24bec5f211c7 -> 5246a6bd410f, multisite_vim runtime. migration] Running upgrade 5246a6bd410f -> acf941e54075, Add error_reason to device runtime. migration] Running upgrade acf941e54075 -> f958f58e5daa, uuid consistency runtime. migration] Running upgrade f958f58e5daa -> 6e56d4474b2a, blob-to-json-text runtime. migration] Running upgrade 6e56d4474b2a -> c7cde2f45f82, set-description -to-text runtime. migration] Running upgrade c7cde2f45f82 -> b07673bb8654, set-status- type-tenant- id-length runtime. migration] Running upgrade b07673bb8654 -> 354de64ba129, set-mandatory- columns- not-null runtime. migration] Running upgrade 354de64ba129 -> 5f88e86b35c7, make VNFD/VNF/VIM name mandatory runtime. migration] Running upgrade 5f88e86b35c7 -> 22f5385a3d3f, Add status to vims runtime. migration] Running upgrade 22f5385a3d3f -> d4f265e8eb9d, add default to vim runtime. migration] Running upgrade d4f265e8eb9d -> 22f5385a3d4f, remove proxydb related runtime. migration] Running upgrade 22f5385a3d4f -> 22f5385a3d50, rename device db tables runtime. migration] Running upgrade 22f5385a3d50 -> 2ff0a0e360f1, audit support runtime. migration] Running upgrade 2ff0a0e360f1 -> 941b5a6fff9e, enable soft delete runtime. migration] Running upgrade 941b5a6fff9e -> 4ee19c8a6d0a, audit_support_ events runtime. migration] Running upgrade 4ee19c8a6d0a -> 507122918800, adds_VNFFG runtime. migration] Running upgrade 507122918800 -> 0ae5b1ce3024, unique_ constraint_ name runtime. migration] Running upgrade 0ae5b1ce3024 -> 8f7145914cb0, remove infra_driver column runtime. migration] Running upgrade 8f7145914cb0 -> 0ad3bbce1c18, create of Network service tables runtime. migration] Running upgrade 0ad3bbce1c18 -> 0ad3bbce1c19, increase_ vim_password_ size runtime. migration] Running upgrade 0ad3bbce1c19 -> 000632983ada, add template_source column runtime. migration] Running upgrade 000632983ada -> e8918cda6433, add_attributes_ to_vnffg runtime. migration] Running upgrade e8918cda6433 -> ef14f8026327, add default onboarded template source runtime. migration] Running upgrade ef14f8026327 -> c256228ed37c, unique constraint on name and id runtime. migration] Running upgrade c256228ed37c -> e7993093baf1, add unique constraint on deleted_at runtime. migration] Running upgrade e7993093baf1 -> 31acbaeb8299, change_ vim_shared_ property_ to_false runtime. migration] Running upgrade 31acbaeb8299 -> f5c1c3b0f6b4, set default value for deleted_at runtime. migration] Running upgrade f5c1c3b0f6b4 -> e9a1e47fb0b5, add onboarded status for vnffgd and nsd runtime. migration] Running upgrade e9a1e47fb0b5 -> 5d490546290c, add_name_ to_classifiers runtime. migration] Running upgrade 5d490546290c -> 4747cc26b9c6, add support vnffg to ns database runtime. migration] Running upgrade 4747cc26b9c6 -> 13ecc2dd6f7f, Change nullable value of path_id runtime. migration] Running upgrade 13ecc2dd6f7f -> cd04a8335c18, mgmt_url to mgmt_ip_address runtime. migration] Running upgrade cd04a8335c18 -> 9d425296f2c3, add db tables for vnf packages runtime. migration] Running upgrade 9d425296f2c3 -> abbef484b34c, modify_ unique_ constraint_ on_vnf_ packages_ user_data runtime. migration] Running upgrade abbef484b34c -> 975e28392888, Add unique constraints on vnfd_id,deleted in vnf_package_vnfd runtime. migration] Running upgrade 975e28392888 -> 985e28392890, VNF instance management changes runtime. migration] Running upgrade 985e28392890 -> d2e39e01d540, add size column to vnf_packages table runtime. migration] Running upgrade d2e39e01d540 -> e06fbdc90a32, add db tables for add artifacts runtime. migration] Running upgrade e06fbdc90a32 -> f9bc96967462, add_vnf_ pkg_id_ to_vnf_ instances runtime. migration] Running upgrade f9bc96967462 -> 745e3e9fe5e2, add_vnf_ metadata_ to_vnflcm_ db runtime. migration] Running upgrade 745e3e9fe5e2 -> aaf461c8844c, change type for vnf_resources and vnf_instantiate d_info table runtime. migration] Running upgrade aaf461c8844c -> 8a7ca803e0d0, add_vnfc_ info_to_ instantiated_ vnf_info runtime. migration] Running upgrade 8a7ca803e0d0 -> c47a733f425a, add_vnflcm_ subscription bin/tacker- db-manage" , line 10, in <module> exit(main( )) lib/python3. 6/site- packages/ tacker/ db/migration/ cli.py" , line 178, in main command. func(config, CONF.command.name) lib/python3. 6/site- packages/ tacker/ db/migration/ cli.py" , line 68, in do_upgrade alembic_ command( config, cmd, revision, sql=CONF. command. sql) lib/python3. 6/site- packages/ tacker/ db/migration/ cli.py" , line 47, in do_alembic_command alembic_ command, cmd)(config, *args, **kwargs) python3. 6/site- packages/ alembic/ command. py", line 298, in upgrade run_env( ) python3. 6/site- packages/ alembic/ script/ base.py" , line 489, in run_env load_python_ file(self. dir, "env.py") python3. 6/site- packages/ alembic/ util/pyfiles. py", line 98, in load_python_file py(module_ id, path) python3. 6/site- packages/ alembic/ util/compat. py", line 173, in load_module_py loader. exec_module( module) _bootstrap_ external> ", line 678, in exec_module _bootstrap> ", line 219, in _call_with_ frames_ removed lib/python3. 6/site- packages/ tacker/ db/migration/ alembic_ migrations/ env.py" , line 84, in <module> migrations_ online( ) lib/python3. 6/site- packages/ tacker/ db/migration/ alembic_ migrations/ env.py" , line 76, in run_migrations_ online run_migrations( ) python3. 6/site- packages/ alembic/ runtime/ environment. py", line 846, in run_migrations get_context( ).run_migration s(**kw) python3. 6/site- packages/ alembic/ runtime/ migration. py", line 518, in run_migrations migration_ fn(**kw) lib/python3. 6/site- packages/ tacker/ db/migration/ alembic_ migrations/ versions/ c47a733f425a_ add_vnflcm_ subscription. py", line 60, in upgrade Computed( noti_str) ),
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
Traceback (most recent call last):
File "/usr/local/
sys.
File "/usr/local/
CONF.
File "/usr/local/
do_
File "/usr/local/
getattr(
File "/usr/lib/
script.
File "/usr/lib/
util.
File "/usr/lib/
module = load_module_
File "/usr/lib/
spec.
File "<frozen importlib.
File "<frozen importlib.
File "/usr/local/
run_
File "/usr/local/
context.
File "<string>", line 8, in run_migrations
File "/usr/lib/
self.
File "/usr/lib/
step.
File "/usr/local/
sa.
AttributeError: module 'sqlalchemy' has no attribute 'Computed'