当upgrade失败后，如何回退到之前的迁移版本

最新推荐文章于 2023-02-06 22:46:10 发布

github_38596081

最新推荐文章于 2023-02-06 22:46:10 发布

阅读量721

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/github_38596081/article/details/102466957

版权

本文介绍了在数据库迁移过程中，如果upgrade步骤遇到错误导致失败，如何检查当前版本，回退到之前的数据库迁移版本，并重新执行migrate和upgrade的详细步骤。

摘要由CSDN通过智能技术生成

migrate后upgrade失败后的报错：

(vpp_agent_venv3.7) [root@localhost source]# python app-migrate.py db migrate
INFO  [alembic.runtime.migration] Context impl MySQLImpl.
INFO  [alembic.runtime.migration] Will assume non-transactional DDL.
INFO  [alembic.autogenerate.compare] Detected removed index 'ix_in_router_manager_room_id' on 'in_router_manager'
INFO  [alembic.autogenerate.compare] Detected removed foreign key (room_id)(id) on table in_router_manager
INFO  [alembic.autogenerate.compare] Detected removed column 'in_router_manager.room_id'
  Generating /srv/web_develop/vpp_agent_dev/agent/source/migrations/versions/8400cd3396af_.py ... done
(vpp_agent_venv3.7) [root@localhost source]# python app-migrate.py db upgrade
INFO  [alembic.runtime.migration] Context impl MySQLImpl.
INFO  [alembic.runtime.migration] Will assume non-transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade 48a794328fe9 -> 8400cd3396af, empty message
Traceback (most recent call last):
  File "/srv/vpp_agent_venv3.7/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
    context)
  File "/srv/vpp_agent_venv3.7/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 509, in do_execute
    cursor.execute(statement, parameters)
  File "/srv/vpp_agent_venv3.7/lib/python3.7/site-packages/pymysql/cursors.py", line 170, in execute
    result = self._query(query)
  File "/srv/vpp_agent_venv3.7/lib/python3.7/site-packages/pymysql/cursors.py", line 328, in _query
    conn.query(q)
  File "/srv/vpp_agent_venv3.7/lib/python3.7/site-packages/pymysql/connections.py", line 516, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/srv/vpp_agent_venv3.7/lib/python3.7/site-packages/pymysql/connections.py", line 727, in _read_query_result
    result.read()
  File "/srv/vpp_agent_venv3.7/lib/python3.7/site-packages/pymysql/connections.py", line 1066, in read
    first_packet = self.connection._read_packet()
  File "/srv/vpp_agent_venv3.7/lib/python3.7/site-packages/pymysql/connections.py", line 683, in _read_packet
    packet.check_error()
  File "/srv/vpp_agent_ven