Advertisement
Guest User

Untitled

a guest
Jan 27th, 2021
15
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.00 KB | None | 0 0
  1. INFO [alembic.runtime.migration] Running upgrade -> 1ccbf5788b3c, empty message
  2. Traceback (most recent call last):
  3. File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1243, in _execute_context
  4. self.dialect.do_execute(
  5. File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 550, in do_execute
  6. cursor.execute(statement, parameters)
  7. File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 170, in execute
  8. result = self._query(query)
  9. File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 328, in _query
  10. conn.query(q)
  11. File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 517, in query
  12. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  13. File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 732, in _read_query_result
  14. result.read()
  15. File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1075, in read
  16. first_packet = self.connection._read_packet()
  17. File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 684, in _read_packet
  18. packet.check_error()
  19. File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 220, in check_error
  20. err.raise_mysql_exception(self._data)
  21. File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 109, in raise_mysql_exception
  22. raise errorclass(errno, errval)
  23. pymysql.err.InternalError: (1075, 'Incorrect table definition; there can be only one auto column and it must be defined as a key')
  24.  
  25. The above exception was the direct cause of the following exception:
  26.  
  27. Traceback (most recent call last):
  28. File "manage.py", line 12, in <module>
  29. manager.run()
  30. File "/usr/local/lib/python3.8/dist-packages/flask_script/__init__.py", line 417, in run
  31. result = self.handle(argv[0], argv[1:])
  32. File "/usr/local/lib/python3.8/dist-packages/flask_script/__init__.py", line 386, in handle
  33. res = handle(*args, **config)
  34. File "/usr/local/lib/python3.8/dist-packages/flask_script/commands.py", line 216, in __call__
  35. return self.run(*args, **kwargs)
  36. File "/usr/local/lib/python3.8/dist-packages/flask_migrate/__init__.py", line 95, in wrapped
  37. f(*args, **kwargs)
  38. File "/usr/local/lib/python3.8/dist-packages/flask_migrate/__init__.py", line 280, in upgrade
  39. command.upgrade(config, revision, sql=sql, tag=tag)
  40. File "/usr/local/lib/python3.8/dist-packages/alembic/command.py", line 276, in upgrade
  41. script.run_env()
  42. File "/usr/local/lib/python3.8/dist-packages/alembic/script/base.py", line 475, in run_env
  43. util.load_python_file(self.dir, "env.py")
  44. File "/usr/local/lib/python3.8/dist-packages/alembic/util/pyfiles.py", line 90, in load_python_file
  45. module = load_module_py(module_id, path)
  46. File "/usr/local/lib/python3.8/dist-packages/alembic/util/compat.py", line 177, in load_module_py
  47. spec.loader.exec_module(module)
  48. File "<frozen importlib._bootstrap_external>", line 783, in exec_module
  49. File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
  50. File "migrations/env.py", line 96, in <module>
  51. run_migrations_online()
  52. File "migrations/env.py", line 90, in run_migrations_online
  53. context.run_migrations()
  54. File "<string>", line 8, in run_migrations
  55. File "/usr/local/lib/python3.8/dist-packages/alembic/runtime/environment.py", line 839, in run_migrations
  56. self.get_context().run_migrations(**kw)
  57. File "/usr/local/lib/python3.8/dist-packages/alembic/runtime/migration.py", line 362, in run_migrations
  58. step.migration_fn(**kw)
  59. File "/opt/osp/migrations/versions/1ccbf5788b3c_.py", line 21, in upgrade
  60. op.drop_index('id', table_name='roles_users')
  61. File "<string>", line 8, in drop_index
  62. File "<string>", line 3, in drop_index
  63. File "/usr/local/lib/python3.8/dist-packages/alembic/operations/ops.py", line 1089, in drop_index
  64. return operations.invoke(op)
  65. File "/usr/local/lib/python3.8/dist-packages/alembic/operations/base.py", line 345, in invoke
  66. return fn(self, operation)
  67. File "/usr/local/lib/python3.8/dist-packages/alembic/operations/toimpl.py", line 93, in drop_index
  68. operations.impl.drop_index(
  69. File "/usr/local/lib/python3.8/dist-packages/alembic/ddl/impl.py", line 288, in drop_index
  70. self._exec(schema.DropIndex(index))
  71. File "/usr/local/lib/python3.8/dist-packages/alembic/ddl/impl.py", line 134, in _exec
  72. return conn.execute(construct, *multiparams, **params)
  73. File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 988, in execute
  74. return meth(self, multiparams, params)
  75. File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/ddl.py", line 72, in _execute_on_connection
  76. return connection._execute_ddl(self, multiparams, params)
  77. File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1045, in _execute_ddl
  78. ret = self._execute_context(
  79. File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1247, in _execute_context
  80. self._handle_dbapi_exception(
  81. File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1466, in _handle_dbapi_exception
  82. util.raise_from_cause(sqlalchemy_exception, exc_info)
  83. File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/util/compat.py", line 399, in raise_from_cause
  84. reraise(type(exception), exception, tb=exc_tb, cause=cause)
  85. File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/util/compat.py", line 153, in reraise
  86. raise value.with_traceback(tb)
  87. File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1243, in _execute_context
  88. self.dialect.do_execute(
  89. File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 550, in do_execute
  90. cursor.execute(statement, parameters)
  91. File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 170, in execute
  92. result = self._query(query)
  93. File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 328, in _query
  94. conn.query(q)
  95. File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 517, in query
  96. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  97. File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 732, in _read_query_result
  98. result.read()
  99. File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1075, in read
  100. first_packet = self.connection._read_packet()
  101. File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 684, in _read_packet
  102. packet.check_error()
  103. File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 220, in check_error
  104. err.raise_mysql_exception(self._data)
  105. File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 109, in raise_mysql_exception
  106. raise errorclass(errno, errval)
  107. qlalchemy.exc.InternalError: (pymysql.err.InternalError) (1075, 'Incorrect table definition; there can be only one auto column and it must be defined as a key')
  108. SQL:
  109. ROP INDEX id ON roles_users]
  110. Background on this error at: http://sqlalche.me/e/2j85)
  111.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement