[asterisk-bugs] [JIRA] (ASTERISK-26183) alembic: error when using sqlalchemy version 1.1.0b2

[Kevin Harwell (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-26183?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kevin Harwell closed ASTERISK-26183.
------------------------------------

    Resolution: Fixed

> alembic: error when using sqlalchemy version 1.1.0b2
> ----------------------------------------------------
>
>                 Key: ASTERISK-26183
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-26183
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Contrib/General
>    Affects Versions: 13.10.0
>         Environment: alembic version 0.8.6
>            Reporter: Kevin Harwell
>            Severity: Minor
>
> 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}



--
This message was sent by Atlassian JIRA
(v6.2#6252)