./bin/gmg dbupdate sqlalchemy.exc.ProgrammingError

[Noah]

Hi there,


Is there an easy way to fix this?

$ pip install --upgrade sqlalchemy
Collecting sqlalchemy
  Downloading SQLAlchemy-1.3.17-cp38-cp38-manylinux2010_x86_64.whl (1.3 MB)
     |████████████████████████████████| 1.3 MB 9.8 MB/s
Installing collected packages: sqlalchemy
Successfully installed sqlalchemy-1.3.17

$ python -V
Python 3.8.2


$ ./bin/gmg dbupdate
/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/PyLD-1.0.5-py3.8.egg/pyld/jsonld.py:577: 
SyntaxWarning: "is" with a literal. Did you mean "=="?
/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/PyLD-1.0.5-py3.8.egg/pyld/jsonld.py:577: 
SyntaxWarning: "is" with a literal. Did you mean "=="?
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade  -> 52bf0ccbedc1, 
initial revision
INFO  [alembic.runtime.migration] Running upgrade 52bf0ccbedc1 -> 
101510e3a713, #5382 Removes graveyard items from collections
Traceback (most recent call last):
  File 
"/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/SQLAlchemy-1.1.18-py3.8-linux-x86_64.egg/sqlalchemy/engine/base.py", 
line 1178, in _execute_context
    self.dialect.do_execute(
  File 
"/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/SQLAlchemy-1.1.18-py3.8-linux-x86_64.egg/sqlalchemy/engine/default.py", 
line 470, in do_execute
    cursor.execute(statement, parameters)
psycopg2.errors.UndefinedColumn: column cons.consrc does not exist
LINE 4:                 cons.consrc as src
                        ^
HINT:  Perhaps you meant to reference the column "cons.conkey" or the 
column "cons.conbin".


The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "./bin/gmg", line 11, in <module>
    load_entry_point('mediagoblin', 'console_scripts', 'gmg')()
  File 
"/srv/pics.enabled.com/mediagoblin/mediagoblin/gmg_commands/__init__.py", 
line 149, in main_cli
    args.func(args)
  File 
"/srv/pics.enabled.com/mediagoblin/mediagoblin/gmg_commands/dbupdate.py", 
line 236, in dbupdate
    run_dbupdate(app_config, global_config)
  File 
"/srv/pics.enabled.com/mediagoblin/mediagoblin/gmg_commands/dbupdate.py", 
line 167, in run_dbupdate
    run_alembic_migrations(db, app_config, global_config)
  File 
"/srv/pics.enabled.com/mediagoblin/mediagoblin/gmg_commands/dbupdate.py", 
line 136, in run_alembic_migrations
    res = command.upgrade(cfg, 'heads')
  File 
"/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/alembic-1.4.2-py3.8.egg/alembic/command.py", 
line 298, in upgrade
    script.run_env()
  File 
"/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/alembic-1.4.2-py3.8.egg/alembic/script/base.py", 
line 489, in run_env
    util.load_python_file(self.dir, "env.py")
  File 
"/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/alembic-1.4.2-py3.8.egg/alembic/util/pyfiles.py", 
line 98, in load_python_file
    module = load_module_py(module_id, path)
  File 
"/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/alembic-1.4.2-py3.8.egg/alembic/util/compat.py", 
line 184, 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 
"/srv/pics.enabled.com/mediagoblin/mediagoblin/db/migrations/env.py", 
line 63, in <module>
    run_migrations_online()
  File 
"/srv/pics.enabled.com/mediagoblin/mediagoblin/db/migrations/env.py", 
line 58, in run_migrations_online
    context.run_migrations()
  File "<string>", line 8, in run_migrations
  File 
"/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/alembic-1.4.2-py3.8.egg/alembic/runtime/environment.py", 
line 846, in run_migrations
    self.get_context().run_migrations(**kw)
  File 
"/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/alembic-1.4.2-py3.8.egg/alembic/runtime/migration.py", 
line 520, in run_migrations
    step.migration_fn(**kw)
  File 
"/srv/pics.enabled.com/mediagoblin/mediagoblin/db/migrations/versions/101510e3a713_removes_graveyard_items_from_.py", 
line 31, in upgrade
    gmr_table = inspect_table(metadata, "core__generic_model_reference")
  File 
"/srv/pics.enabled.com/mediagoblin/mediagoblin/db/migration_tools.py", 
line 290, in inspect_table
    return Table(table_name, metadata, autoload=True,
  File 
"/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/SQLAlchemy-1.1.18-py3.8-linux-x86_64.egg/sqlalchemy/sql/schema.py", 
line 439, in __new__
    metadata._remove_table(name, schema)
  File 
"/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/SQLAlchemy-1.1.18-py3.8-linux-x86_64.egg/sqlalchemy/util/langhelpers.py", 
line 66, in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
  File 
"/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/SQLAlchemy-1.1.18-py3.8-linux-x86_64.egg/sqlalchemy/util/compat.py", 
line 187, in reraise
    raise value
  File 
"/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/SQLAlchemy-1.1.18-py3.8-linux-x86_64.egg/sqlalchemy/sql/schema.py", 
line 434, in __new__
    table._init(name, metadata, *args, **kw)
  File 
"/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/SQLAlchemy-1.1.18-py3.8-linux-x86_64.egg/sqlalchemy/sql/schema.py", 
line 512, in _init
    self._autoload(
  File 
"/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/SQLAlchemy-1.1.18-py3.8-linux-x86_64.egg/sqlalchemy/sql/schema.py", 
line 524, in _autoload
    autoload_with.run_callable(
  File 
"/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/SQLAlchemy-1.1.18-py3.8-linux-x86_64.egg/sqlalchemy/engine/base.py", 
line 1534, in run_callable
    return callable_(self, *args, **kwargs)
  File 
"/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/SQLAlchemy-1.1.18-py3.8-linux-x86_64.egg/sqlalchemy/engine/default.py", 
line 371, in reflecttable
    return insp.reflecttable(
  File 
"/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/SQLAlchemy-1.1.18-py3.8-linux-x86_64.egg/sqlalchemy/engine/reflection.py", 
line 623, in reflecttable
    self._reflect_check_constraints(
  File 
"/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/SQLAlchemy-1.1.18-py3.8-linux-x86_64.egg/sqlalchemy/engine/reflection.py", 
line 836, in _reflect_check_constraints
    constraints = self.get_check_constraints(table_name, schema)
  File 
"/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/SQLAlchemy-1.1.18-py3.8-linux-x86_64.egg/sqlalchemy/engine/reflection.py", 
line 532, in get_check_constraints
    return self.dialect.get_check_constraints(
  File "<string>", line 2, in get_check_constraints
  File 
"/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/SQLAlchemy-1.1.18-py3.8-linux-x86_64.egg/sqlalchemy/engine/reflection.py", 
line 54, in cache
    ret = fn(self, con, *args, **kw)
  File 
"/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/SQLAlchemy-1.1.18-py3.8-linux-x86_64.egg/sqlalchemy/dialects/postgresql/base.py", 
line 2950, in get_check_constraints
    c = connection.execute(sql.text(CHECK_SQL), table_oid=table_oid)
  File 
"/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/SQLAlchemy-1.1.18-py3.8-linux-x86_64.egg/sqlalchemy/engine/base.py", 
line 945, in execute
    return meth(self, multiparams, params)
  File 
"/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/SQLAlchemy-1.1.18-py3.8-linux-x86_64.egg/sqlalchemy/sql/elements.py", 
line 263, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File 
"/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/SQLAlchemy-1.1.18-py3.8-linux-x86_64.egg/sqlalchemy/engine/base.py", 
line 1048, in _execute_clauseelement
    ret = self._execute_context(
  File 
"/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/SQLAlchemy-1.1.18-py3.8-linux-x86_64.egg/sqlalchemy/engine/base.py", 
line 1184, in _execute_context
    self._handle_dbapi_exception(
  File 
"/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/SQLAlchemy-1.1.18-py3.8-linux-x86_64.egg/sqlalchemy/engine/base.py", 
line 1400, in _handle_dbapi_exception
    util.raise_from_cause(
  File 
"/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/SQLAlchemy-1.1.18-py3.8-linux-x86_64.egg/sqlalchemy/util/compat.py", 
line 203, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File 
"/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/SQLAlchemy-1.1.18-py3.8-linux-x86_64.egg/sqlalchemy/util/compat.py", 
line 186, in reraise
    raise value.with_traceback(tb)
  File 
"/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/SQLAlchemy-1.1.18-py3.8-linux-x86_64.egg/sqlalchemy/engine/base.py", 
line 1178, in _execute_context
    self.dialect.do_execute(
  File 
"/srv/pics.enabled.com/mediagoblin/lib/python3.8/site-packages/SQLAlchemy-1.1.18-py3.8-linux-x86_64.egg/sqlalchemy/engine/default.py", 
line 470, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedColumn) 
column cons.consrc does not exist
LINE 4:                 cons.consrc as src
                        ^
HINT:  Perhaps you meant to reference the column "cons.conkey" or the 
column "cons.conbin".
 [SQL: "\n            SELECT\n                cons.conname as name,\n 
             cons.consrc as src\n            FROM\n 
pg_catalog.pg_constraint cons\n            WHERE\n 
cons.conrelid = %(table_oid)s AND\n                cons.contype = 'c'\n 
      "] [parameters: {'table_oid': 17479}]