Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save bgirardot/3cad9a02ff813a6d66c47e81023957fb to your computer and use it in GitHub Desktop.
Save bgirardot/3cad9a02ff813a6d66c47e81023957fb to your computer and use it in GitHub Desktop.
./venv/bin/python3.6 manage.py db upgrade errors
(venv) bg@bg-VirtualBox:~/tasking-manager$ ./venv/bin/python3.6 manage.py db upgrade
/home/bg/tasking-manager/venv/lib/python3.6/site-packages/flask_sqlalchemy/__init__.py:839: FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
'SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and '
INFO [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO [alembic.runtime.migration] Will assume transactional DDL.
INFO [alembic.runtime.migration] Running upgrade -> 8aa8f8d6a0c3, empty message
INFO [alembic.runtime.migration] Running upgrade 8aa8f8d6a0c3 -> a7c617755721, empty message
INFO [alembic.runtime.migration] Running upgrade a7c617755721 -> 48c3aed123cf, empty message
INFO [alembic.runtime.migration] Running upgrade 48c3aed123cf -> 0aaac86a48dc, empty message
INFO [alembic.runtime.migration] Running upgrade 0aaac86a48dc -> c4670f3bb828, empty message
INFO [alembic.runtime.migration] Running upgrade c4670f3bb828 -> b5b8370f9262, empty message
INFO [alembic.runtime.migration] Running upgrade b5b8370f9262 -> 9f5b73af01db, empty message
Traceback (most recent call last):
File "/home/bg/tasking-manager/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context
context)
File "/home/bg/tasking-manager/venv/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 470, in do_execute
cursor.execute(statement, parameters)
psycopg2.ProgrammingError: column "tsv" of relation "project_info" does not exist
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "manage.py", line 27, in <module>
manager.run()
File "/home/bg/tasking-manager/venv/lib/python3.6/site-packages/flask_script/__init__.py", line 412, in run
result = self.handle(sys.argv[0], sys.argv[1:])
File "/home/bg/tasking-manager/venv/lib/python3.6/site-packages/flask_script/__init__.py", line 383, in handle
res = handle(*args, **config)
File "/home/bg/tasking-manager/venv/lib/python3.6/site-packages/flask_script/commands.py", line 216, in __call__
return self.run(*args, **kwargs)
File "/home/bg/tasking-manager/venv/lib/python3.6/site-packages/flask_migrate/__init__.py", line 244, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
File "/home/bg/tasking-manager/venv/lib/python3.6/site-packages/alembic/command.py", line 174, in upgrade
script.run_env()
File "/home/bg/tasking-manager/venv/lib/python3.6/site-packages/alembic/script/base.py", line 416, in run_env
util.load_python_file(self.dir, 'env.py')
File "/home/bg/tasking-manager/venv/lib/python3.6/site-packages/alembic/util/pyfiles.py", line 93, in load_python_file
module = load_module_py(module_id, path)
File "/home/bg/tasking-manager/venv/lib/python3.6/site-packages/alembic/util/compat.py", line 68, in load_module_py
module_id, path).load_module(module_id)
File "<frozen importlib._bootstrap_external>", line 399, in _check_name_wrapper
File "<frozen importlib._bootstrap_external>", line 823, in load_module
File "<frozen importlib._bootstrap_external>", line 682, in load_module
File "<frozen importlib._bootstrap>", line 251, in _load_module_shim
File "<frozen importlib._bootstrap>", line 675, in _load
File "<frozen importlib._bootstrap>", line 655, in _load_unlocked
File "<frozen importlib._bootstrap_external>", line 678, in exec_module
File "<frozen importlib._bootstrap>", line 205, in _call_with_frames_removed
File "migrations/env.py", line 99, in <module>
run_migrations_online()
File "migrations/env.py", line 92, in run_migrations_online
context.run_migrations()
File "<string>", line 8, in run_migrations
File "/home/bg/tasking-manager/venv/lib/python3.6/site-packages/alembic/runtime/environment.py", line 807, in run_migrations
self.get_context().run_migrations(**kw)
File "/home/bg/tasking-manager/venv/lib/python3.6/site-packages/alembic/runtime/migration.py", line 321, in run_migrations
step.migration_fn(**kw)
File "/home/bg/tasking-manager/migrations/versions/9f5b73af01db_.py", line 24, in upgrade
op.drop_column('project_info', 'tsv')
File "<string>", line 8, in drop_column
File "<string>", line 3, in drop_column
File "/home/bg/tasking-manager/venv/lib/python3.6/site-packages/alembic/operations/ops.py", line 1643, in drop_column
return operations.invoke(op)
File "/home/bg/tasking-manager/venv/lib/python3.6/site-packages/alembic/operations/base.py", line 318, in invoke
return fn(self, operation)
File "/home/bg/tasking-manager/venv/lib/python3.6/site-packages/alembic/operations/toimpl.py", line 81, in drop_column
**operation.kw
File "/home/bg/tasking-manager/venv/lib/python3.6/site-packages/alembic/ddl/impl.py", line 175, in drop_column
self._exec(base.DropColumn(table_name, column, schema=schema))
File "/home/bg/tasking-manager/venv/lib/python3.6/site-packages/alembic/ddl/impl.py", line 118, in _exec
return conn.execute(construct, *multiparams, **params)
File "/home/bg/tasking-manager/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 945, in execute
return meth(self, multiparams, params)
File "/home/bg/tasking-manager/venv/lib/python3.6/site-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/bg/tasking-manager/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1002, in _execute_ddl
compiled
File "/home/bg/tasking-manager/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1189, in _execute_context
context)
File "/home/bg/tasking-manager/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1402, in _handle_dbapi_exception
exc_info
File "/home/bg/tasking-manager/venv/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/home/bg/tasking-manager/venv/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 186, in reraise
raise value.with_traceback(tb)
File "/home/bg/tasking-manager/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context
context)
File "/home/bg/tasking-manager/venv/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 470, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) column "tsv" of relation "project_info" does not exist
[SQL: 'ALTER TABLE project_info DROP COLUMN tsv']
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment