| Summary: | ASTERISK-26183: alembic: error when using sqlalchemy version 1.1.0b2 | ||||
| Reporter: | Kevin Harwell (kharwell) | Labels: | |||
| Date Opened: | 2016-07-08 14:17:27 | Date Closed: | 2016-08-10 20:28:04 | ||
| Priority: | Minor | Regression? | No | ||
| Status: | Closed/Complete | Components: | Contrib/General | ||
| Versions: | 13.10.0 | Frequency of Occurrence | Constant | ||
| Related Issues: |
| ||||
| Environment: | alembic version 0.8.6 | Attachments: | |||
| Description: | If using version 1.1.0b2 of sqlalchemy the following error occurs when running the alembic upgrade command (relevant texts):
{noformat} INFO [alembic.runtime.migration] Context impl MySQLImpl. INFO [alembic.runtime.migration] Will assume non-transactional DDL. INFO [alembic.runtime.migration] Running upgrade -> 4da0c5f79a9c, Create tables INFO [alembic.runtime.migration] Running upgrade 4da0c5f79a9c -> 43956d550a44, Add tables for pjsip INFO [alembic.runtime.migration] Running upgrade 43956d550a44 -> 581a4264e537, adding extensions Traceback (most recent call last): File "/usr/local/bin/alembic", line 9, in <module> load_entry_point('alembic==0.8.6', 'console_scripts', 'alembic')() File "/usr/local/lib/python2.7/dist-packages/alembic/config.py", line 479, in main CommandLine(prog=prog).main(argv=argv) File "/usr/local/lib/python2.7/dist-packages/alembic/config.py", line 473, in main self.run_cmd(cfg, options) File "/usr/local/lib/python2.7/dist-packages/alembic/config.py", line 456, in run_cmd **dict((k, getattr(options, k)) for k in kwarg) File "/usr/local/lib/python2.7/dist-packages/alembic/command.py", line 174, in upgrade script.run_env() File "/usr/local/lib/python2.7/dist-packages/alembic/script/base.py", line 397, in run_env util.load_python_file(self.dir, 'env.py') File "/usr/local/lib/python2.7/dist-packages/alembic/util/pyfiles.py", line 93, in load_python_file module = load_module_py(module_id, path) File "/usr/local/lib/python2.7/dist-packages/alembic/util/compat.py", line 79, in load_module_py mod = imp.load_source(module_id, path, fp) File "config/env.py", line 73, in <module> run_migrations_online() File "config/env.py", line 66, in run_migrations_online context.run_migrations() File "<string>", line 8, in run_migrations File "/usr/local/lib/python2.7/dist-packages/alembic/runtime/environment.py", line 797, in run_migrations self.get_context().run_migrations(**kw) File "/usr/local/lib/python2.7/dist-packages/alembic/runtime/migration.py", line 312, in run_migrations step.migration_fn(**kw) File "/home/kharwell/src/asterisk/13-cert/contrib/ast-db-manage/config/versions/581a4264e537_adding_extensions.py", line 45, in upgrade sa.Column('appdata', sa.String(256), nullable=False), {noformat} ... {noformat} File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py", line 3152, in _autoincrement_column (col.name, autoinc.name) sqlalchemy.exc.ArgumentError: Only one Column may be marked autoincrement=True, found both priority and id. {noformat} | ||||
| Comments: | |||||