[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=245390#comment-245390 ] 

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

Suspended due to lack of activity. This issue will be automatically re-opened if the reporter posts a comment. If you are not the reporter and would like this re-opened please create a new issue instead. If the new issue is related to this one a link will be created during the triage process. Further information on issue tracker usage can be found in the Asterisk Issue Guidlines [1].

[1] https://wiki.asterisk.org/wiki/display/AST/Asterisk+Issue+Guidelines

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