Suddenly, I can't get alembic (1.3.3?). alembic history does work, but my
most recent migration crashes with an enormous stack-trace (as usual):
here's my current pretty-simple migration script:
"""Citation datasource optional
Revision ID: f5a6e316ee8d
Revises: 2a181e783d96
Create Date: 2020-03-26 08:54:59.547135
"""
# revision identifiers, used by Alembic.
revision = 'f5a6e316ee8d'
down_revision = '2a181e783d96'
branch_labels = None
depends_on = None
from alembic import op
import sqlalchemy as sa
def upgrade():
op.alter_column('citation', 'id_datasource',
existing_Type=sa.INTEGER(),
nullable=True)
pass
def downgrade():
op.alter_column('citation', 'id_datasource',
existing_Type=sa.INTEGER(),
nullable=False)
pass
Here's the last stanza of the stack trace:
File
"/home/rschottland/.local/share/virtualenvs/astorb_db-u7fxujye/lib/python3.7/site-packages/sqlalchemy/sql/base.py",
line 289, in _validate_dialect_kwargs
"named <dialectname>_<argument>, got '%s'" % k
TypeError: Additional arguments should be named <dialectname>_<argument>,
got 'index'
The whole 69 line stack trace is attached.
This is the 30th migration for this database going back to 2015. Nothing
like this has occurred before. Could my alembic package be corrupted? The
previous (successful) igration was only 3 days ago.
Any thoughts on this would be appreciated.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy-alembic" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy-alembic/619800be-2eb5-4728-a695-5000c3668646%40googlegroups.com.
Traceback (most recent call last):
File
"/home/rschottland/.local/share/virtualenvs/astorb_db-u7fxujye/bin/alembic",
line 8, in <module>
sys.exit(main())
File
"/home/rschottland/.local/share/virtualenvs/astorb_db-u7fxujye/lib/python3.7/site-packages/alembic/config.py",
line 575, in main
CommandLine(prog=prog).main(argv=argv)
File
"/home/rschottland/.local/share/virtualenvs/astorb_db-u7fxujye/lib/python3.7/site-packages/alembic/config.py",
line 569, in main
self.run_cmd(cfg, options)
File
"/home/rschottland/.local/share/virtualenvs/astorb_db-u7fxujye/lib/python3.7/site-packages/alembic/config.py",
line 549, in run_cmd
**dict((k, getattr(options, k, None)) for k in kwarg)
File
"/home/rschottland/.local/share/virtualenvs/astorb_db-u7fxujye/lib/python3.7/site-packages/alembic/command.py",
line 515, in current
script.run_env()
File
"/home/rschottland/.local/share/virtualenvs/astorb_db-u7fxujye/lib/python3.7/site-packages/alembic/script/base.py",
line 489, in run_env
util.load_python_file(self.dir, "env.py")
File
"/home/rschottland/.local/share/virtualenvs/astorb_db-u7fxujye/lib/python3.7/site-packages/alembic/util/pyfiles.py",
line 98, in load_python_file
module = load_module_py(module_id, path)
File
"/home/rschottland/.local/share/virtualenvs/astorb_db-u7fxujye/lib/python3.7/site-packages/alembic/util/compat.py",
line 173, in load_module_py
spec.loader.exec_module(module)
File "<frozen importlib._bootstrap_external>", line 728, in exec_module
File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
File "./env.py", line 29, in <module>
from astorb_db import db # import the prospective (new) schema
File "/home/rschottland/projects/gitlab/astorb_db/alembic/astorb_db.py", line
1175, in <module>
class Citation(db.Model):
File
"/home/rschottland/.local/share/virtualenvs/astorb_db-u7fxujye/lib/python3.7/site-packages/flask_sqlalchemy/model.py",
line 67, in __init__
super(NameMetaMixin, cls).__init__(name, bases, d)
File
"/home/rschottland/.local/share/virtualenvs/astorb_db-u7fxujye/lib/python3.7/site-packages/flask_sqlalchemy/model.py",
line 121, in __init__
super(BindMetaMixin, cls).__init__(name, bases, d)
File
"/home/rschottland/.local/share/virtualenvs/astorb_db-u7fxujye/lib/python3.7/site-packages/sqlalchemy/ext/declarative/api.py",
line 75, in __init__
_as_declarative(cls, classname, cls.__dict__)
File
"/home/rschottland/.local/share/virtualenvs/astorb_db-u7fxujye/lib/python3.7/site-packages/sqlalchemy/ext/declarative/base.py",
line 131, in _as_declarative
_MapperConfig.setup_mapping(cls, classname, dict_)
File
"/home/rschottland/.local/share/virtualenvs/astorb_db-u7fxujye/lib/python3.7/site-packages/sqlalchemy/ext/declarative/base.py",
line 160, in setup_mapping
cfg_cls(cls_, classname, dict_)
File
"/home/rschottland/.local/share/virtualenvs/astorb_db-u7fxujye/lib/python3.7/site-packages/sqlalchemy/ext/declarative/base.py",
line 190, in __init__
self._setup_table()
File
"/home/rschottland/.local/share/virtualenvs/astorb_db-u7fxujye/lib/python3.7/site-packages/sqlalchemy/ext/declarative/base.py",
line 538, in _setup_table
**table_kw
File
"/home/rschottland/.local/share/virtualenvs/astorb_db-u7fxujye/lib/python3.7/site-packages/flask_sqlalchemy/model.py",
line 99, in __table_cls__
return sa.Table(*args, **kwargs)
File "<string>", line 2, in __new__
File
"/home/rschottland/.local/share/virtualenvs/astorb_db-u7fxujye/lib/python3.7/site-packages/sqlalchemy/util/deprecations.py",
line 128, in warned
return fn(*args, **kwargs)
File
"/home/rschottland/.local/share/virtualenvs/astorb_db-u7fxujye/lib/python3.7/site-packages/sqlalchemy/sql/schema.py",
line 506, in __new__
metadata._remove_table(name, schema)
File
"/home/rschottland/.local/share/virtualenvs/astorb_db-u7fxujye/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py",
line 68, in __exit__
compat.reraise(exc_type, exc_value, exc_tb)
File
"/home/rschottland/.local/share/virtualenvs/astorb_db-u7fxujye/lib/python3.7/site-packages/sqlalchemy/util/compat.py",
line 153, in reraise
raise value
File
"/home/rschottland/.local/share/virtualenvs/astorb_db-u7fxujye/lib/python3.7/site-packages/sqlalchemy/sql/schema.py",
line 501, in __new__
table._init(name, metadata, *args, **kw)
File
"/home/rschottland/.local/share/virtualenvs/astorb_db-u7fxujye/lib/python3.7/site-packages/sqlalchemy/sql/schema.py",
line 600, in _init
self._init_items(*args)
File
"/home/rschottland/.local/share/virtualenvs/astorb_db-u7fxujye/lib/python3.7/site-packages/sqlalchemy/sql/schema.py",
line 117, in _init_items
spwd(self)
File
"/home/rschottland/.local/share/virtualenvs/astorb_db-u7fxujye/lib/python3.7/site-packages/sqlalchemy/sql/base.py",
line 457, in _set_parent_with_dispatch
self.dispatch.after_parent_attach(self, parent)
File
"/home/rschottland/.local/share/virtualenvs/astorb_db-u7fxujye/lib/python3.7/site-packages/sqlalchemy/event/attr.py",
line 322, in __call__
fn(*args, **kw)
File
"/home/rschottland/.local/share/virtualenvs/astorb_db-u7fxujye/lib/python3.7/site-packages/sqlalchemy/sql/schema.py",
line 2106, in _set_table
**self._unvalidated_dialect_kw
File
"/home/rschottland/.local/share/virtualenvs/astorb_db-u7fxujye/lib/python3.7/site-packages/sqlalchemy/sql/schema.py",
line 3144, in __init__
**dialect_kw
File
"/home/rschottland/.local/share/virtualenvs/astorb_db-u7fxujye/lib/python3.7/site-packages/sqlalchemy/sql/schema.py",
line 2723, in __init__
self._validate_dialect_kwargs(dialect_kw)
File
"/home/rschottland/.local/share/virtualenvs/astorb_db-u7fxujye/lib/python3.7/site-packages/sqlalchemy/sql/base.py",
line 289, in _validate_dialect_kwargs
"named <dialectname>_<argument>, got '%s'" % k
TypeError: Additional arguments should be named <dialectname>_<argument>, got
'index'
