| Summary: | ASTERISK-28128: postgresql config db upgrade fail at alembic upgrade fe6592859b85 | ||
| Reporter: | Kamal Wickramanayake (kamal) | Labels: | |
| Date Opened: | 2018-10-24 06:58:43 | Date Closed: | 2019-04-17 16:05:26 |
| Priority: | Minor | Regression? | |
| Status: | Closed/Complete | Components: | Contrib/General |
| Versions: | 16.0.0 | Frequency of Occurrence | Constant |
| Related Issues: | |||
| Environment: | Ubuntu 16.04 postgresql 9.5+173ubuntu0.2 | Attachments: | |
| Description: | 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 | ||
| Comments: | By: Asterisk Team (asteriskteam) 2018-10-24 06:58:44.951-0500 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]. By: George Joseph (gjoseph) 2018-10-24 12:58:22.275-0500 What was the state of the database before the upgrade? If it had a schema already built, what version of Asterisk was in use? By: Asterisk Team (asteriskteam) 2018-11-07 12:00:02.200-0600 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 | ||