Skip to content
This repository was archived by the owner on Aug 30, 2024. It is now read-only.
This repository was archived by the owner on Aug 30, 2024. It is now read-only.

MidoNet Data Migration issue "Table 'neutron.midonet_tasks' doesn't exist" #41

@332054781

Description

@332054781

i upgrade midonet and migraion old data to new data ,but is error ,log :
File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 800, in _emit_insert_statements
execute(statement, 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/elements.py", line 323, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
compiled_sql, distilled_params
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 1337, in _handle_dbapi_exception
util.raise_from_cause(newraise, 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/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 174, in execute
self.errorhandler(self, exc, value)
File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
sqlalchemy.exc.ProgrammingError: (_mysql_exceptions.ProgrammingError) (1146, "Table 'neutron.midonet_tasks' doesn't exist") [SQL: u'INSERT INTO midonet_tasks (type, tenant_id, data_type, data, resource_id, transaction_id, created_at) VALUES (%s, %s, %s, %s, %s, %s, %s)'] [parameters: ('CREATE', None, 'SECURITYGROUP', '{"tenant_id": "07c1b996b4574aec8ab2a32a250b9345", "description": "Default security group", "id": "faa404f7-37a0-4952-9d3f-3ca91966710b", "security_group_rules": [{"remote_group_id": null, "direction": "egress", "remote_ip_prefix": null, "protocol": null, "ethertype": "IPv6", "tenant_id": "07c1b996b4574aec8ab2a32a250b9345", "port_range_max": null, "port_range_min": null, "id": "2131d613-d379-4f52-bfc7-93df1743c2dd", "security_group_id": "faa404f7-37a0-4952-9d3f-3ca91966710b"}, {"remote_group_id": "faa404f7-37a0-4952-9d3f-3ca91966710b", "direction": "ingress", "remote_ip_prefix": null, "protocol": null, "ethertype": "IPv6", "tenant_id": "07c1b996b4574aec8ab2a32a250b9345", "port_range_max": null, "port_range_min": null, "id": "4c83fe7d-4de1-4b9e-af5e-d8c8a4cbb504", "security_group_id": "faa404f7-37a0-4952-9d3f-3ca91966710b"}, {"remote_group_id": "faa404f7-37a0-4952-9d3f-3ca91966710b", "direction": "ingress", "remote_ip_prefix": null, "protocol": null, "ethertype": "IPv4", "tenant_id": "07c1b996b4574aec8ab2a32a250b9345", "port_range_max": null, "port_range_min": null, "id": "95cad49c-e35a-4de9-9e5e-e71a129a6748", "security_group_id": "faa404f7-37a0-4952-9d3f-3ca91966710b"}, {"remote_group_id": null, "direction": "egress", "remote_ip_prefix": null, "protocol": null, "ethertype": "IPv4", "tenant_id": "07c1b996b4574aec8ab2a32a250b9345", "port_range_max": null, "port_range_min": null, "id": "a7cccfa8-0476-4f1c-98f0-a8dbe84b4043", "security_group_id": "faa404f7-37a0-4952-9d3f-3ca91966710b"}], "name": "default"}', 'faa404f7-37a0-4952-9d3f-3ca91966710b', 'req-2dc4ae84-8fb7-4592-abd0-1581d3a558b3', datetime.datetime(2016, 6, 21, 10, 3, 28, 675278))]

please tell me how to fix it

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions