[asterisk-bugs] [JIRA] (ASTERISK-28128) postgresql config db upgrade fail at alembic upgrade fe6592859b85

[George Joseph (JIRA)]

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

George Joseph updated ASTERISK-28128:
-------------------------------------

    Assignee: Kamal Wickramanayake
      Status: Waiting for Feedback  (was: Triage)

What was the state of the database before the upgrade?
If it had a schema already built, what version of Asterisk was in use?


> postgresql config db upgrade fail at alembic upgrade fe6592859b85
> -----------------------------------------------------------------
>
>                 Key: ASTERISK-28128
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-28128
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Contrib/General
>    Affects Versions: 16.0.0
>         Environment: Ubuntu 16.04
> postgresql 9.5+173ubuntu0.2
>            Reporter: Kamal Wickramanayake
>            Assignee: Kamal Wickramanayake
>            Severity: Minor
>
> Tried installing the config db by running this command:
> $ alembic -c config.ini upgrade head
> For upgrade fe6592859b85, this error occurs and no tables are created:
> INFO  [alembic.runtime.migration] Running upgrade 1d3ed26d9978 -> fe6592859b85, Fix mwi_subscribe_replaces_unsolicited
> Traceback (most recent call last):
>   File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
>     context)
>   File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
>     cursor.execute(statement, parameters)
> psycopg2.ProgrammingError: column "mwi_subscribe_replaces_unsolicited" cannot be cast automatically to type ast_bool_values
> HINT:  You might need to specify "USING mwi_subscribe_replaces_unsolicited::ast_bool_values".
> Up to the upgrade before the above upgrade, table creation works without a problem. For example, this creates tables:
> $ alembic -c config.ini upgrade 1d3ed26d9978



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