Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INFO [alembic.runtime.migration] Running upgrade -> 1ccbf5788b3c, empty message
- Traceback (most recent call last):
- File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1243, in _execute_context
- self.dialect.do_execute(
- File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 550, in do_execute
- cursor.execute(statement, parameters)
- File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 170, in execute
- result = self._query(query)
- File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 328, in _query
- conn.query(q)
- File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 732, in _read_query_result
- result.read()
- File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 684, in _read_packet
- packet.check_error()
- File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- pymysql.err.InternalError: (1075, 'Incorrect table definition; there can be only one auto column and it must be defined as a key')
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "manage.py", line 12, in <module>
- manager.run()
- File "/usr/local/lib/python3.8/dist-packages/flask_script/__init__.py", line 417, in run
- result = self.handle(argv[0], argv[1:])
- File "/usr/local/lib/python3.8/dist-packages/flask_script/__init__.py", line 386, in handle
- res = handle(*args, **config)
- File "/usr/local/lib/python3.8/dist-packages/flask_script/commands.py", line 216, in __call__
- return self.run(*args, **kwargs)
- File "/usr/local/lib/python3.8/dist-packages/flask_migrate/__init__.py", line 95, in wrapped
- f(*args, **kwargs)
- File "/usr/local/lib/python3.8/dist-packages/flask_migrate/__init__.py", line 280, in upgrade
- command.upgrade(config, revision, sql=sql, tag=tag)
- File "/usr/local/lib/python3.8/dist-packages/alembic/command.py", line 276, in upgrade
- script.run_env()
- File "/usr/local/lib/python3.8/dist-packages/alembic/script/base.py", line 475, in run_env
- util.load_python_file(self.dir, "env.py")
- File "/usr/local/lib/python3.8/dist-packages/alembic/util/pyfiles.py", line 90, in load_python_file
- module = load_module_py(module_id, path)
- File "/usr/local/lib/python3.8/dist-packages/alembic/util/compat.py", line 177, in load_module_py
- spec.loader.exec_module(module)
- File "<frozen importlib._bootstrap_external>", line 783, in exec_module
- File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
- File "migrations/env.py", line 96, in <module>
- run_migrations_online()
- File "migrations/env.py", line 90, in run_migrations_online
- context.run_migrations()
- File "<string>", line 8, in run_migrations
- File "/usr/local/lib/python3.8/dist-packages/alembic/runtime/environment.py", line 839, in run_migrations
- self.get_context().run_migrations(**kw)
- File "/usr/local/lib/python3.8/dist-packages/alembic/runtime/migration.py", line 362, in run_migrations
- step.migration_fn(**kw)
- File "/opt/osp/migrations/versions/1ccbf5788b3c_.py", line 21, in upgrade
- op.drop_index('id', table_name='roles_users')
- File "<string>", line 8, in drop_index
- File "<string>", line 3, in drop_index
- File "/usr/local/lib/python3.8/dist-packages/alembic/operations/ops.py", line 1089, in drop_index
- return operations.invoke(op)
- File "/usr/local/lib/python3.8/dist-packages/alembic/operations/base.py", line 345, in invoke
- return fn(self, operation)
- File "/usr/local/lib/python3.8/dist-packages/alembic/operations/toimpl.py", line 93, in drop_index
- operations.impl.drop_index(
- File "/usr/local/lib/python3.8/dist-packages/alembic/ddl/impl.py", line 288, in drop_index
- self._exec(schema.DropIndex(index))
- File "/usr/local/lib/python3.8/dist-packages/alembic/ddl/impl.py", line 134, in _exec
- return conn.execute(construct, *multiparams, **params)
- File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 988, in execute
- return meth(self, multiparams, params)
- File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/ddl.py", line 72, in _execute_on_connection
- return connection._execute_ddl(self, multiparams, params)
- File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1045, in _execute_ddl
- ret = self._execute_context(
- File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1247, in _execute_context
- self._handle_dbapi_exception(
- File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1466, in _handle_dbapi_exception
- util.raise_from_cause(sqlalchemy_exception, exc_info)
- File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/util/compat.py", line 399, in raise_from_cause
- reraise(type(exception), exception, tb=exc_tb, cause=cause)
- File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/util/compat.py", line 153, in reraise
- raise value.with_traceback(tb)
- File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1243, in _execute_context
- self.dialect.do_execute(
- File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 550, in do_execute
- cursor.execute(statement, parameters)
- File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 170, in execute
- result = self._query(query)
- File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 328, in _query
- conn.query(q)
- File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 517, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 732, in _read_query_result
- result.read()
- File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1075, in read
- first_packet = self.connection._read_packet()
- File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 684, in _read_packet
- packet.check_error()
- File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 220, in check_error
- err.raise_mysql_exception(self._data)
- File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 109, in raise_mysql_exception
- raise errorclass(errno, errval)
- 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')
- SQL:
- ROP INDEX id ON roles_users]
- Background on this error at: http://sqlalche.me/e/2j85)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement