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

[Asterisk Team (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-28128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=245233#comment-245233 ] 

Asterisk Team commented on ASTERISK-28128:
------------------------------------------

Thanks for creating a report! The issue has entered the triage process. That means the issue will wait in this status until a Bug Marshal has an opportunity to review the issue. Once the issue has been reviewed you will receive comments regarding the next steps towards resolution.

A good first step is for you to review the [Asterisk Issue Guidelines|https://wiki.asterisk.org/wiki/display/AST/Asterisk+Issue+Guidelines] if you haven't already. The guidelines detail what is expected from an Asterisk issue report.

Then, if you are submitting a patch, please review the [Patch Contribution Process|https://wiki.asterisk.org/wiki/display/AST/Patch+Contribution+Process].

> 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
>            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)