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

[Kamal Wickramanayake (JIRA)]

Kamal Wickramanayake created ASTERISK-28128:
-----------------------------------------------

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