| Summary: | ASTERISK-29015: res_pjsip_pubsub: ps_subscription_persistence Alembic does not include generator_data | ||
| Reporter: | Alex Odrov (AlexOdrov) | Labels: | |
| Date Opened: | 2020-07-30 14:22:37 | Date Closed: | |
| Priority: | Minor | Regression? | |
| Status: | Open/New | Components: | Resources/res_odbc Resources/res_pjsip_pubsub |
| Versions: | 13.35.0 16.15.0 | Frequency of Occurrence | Constant |
| Related Issues: | |||
| Environment: | Attachments: | ||
| Description: | We are using PJSIP Realtime with PostgreSQL 9.6. After the upgrade from 13.29 we have the next error:
res_odbc.c:550 ast_odbc_print_errors: SQL Execute returned an error: 42703: ERROR: column "generator_data" of relation "ps_subscription_persistence" does not exist; We've checked files in both alembic directory "/src/asterisk-13.35/contrib/ast-db-manage/config/versions" and SQL directory "/src/asterisk-13.35/contrib/realtime/postgresql/" but there's no column "generator_data" in "ps_subscription_persistence". It looks like generator_data is missed alembic and in SQL files. | ||
| Comments: | By: Asterisk Team (asteriskteam) 2020-07-30 14:22:38.788-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. Please note that log messages and other files should not be sent to the Sangoma Asterisk Team unless explicitly asked for. All files should be placed on this issue in a sanitized fashion as needed. 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]. Please note that once your issue enters an open state it has been accepted. As Asterisk is an open source project there is no guarantee or timeframe on when your issue will be looked into. If you need expedient resolution you will need to find and pay a suitable developer. Asking for an update on your issue will not yield any progress on it and will not result in a response. All updates are posted to the issue when they occur. By: Joshua C. Colp (jcolp) 2020-07-30 14:31:33.905-0500 While an issue, does having subscription persistence in realtime provide value to you? By: Alex Odrov (AlexOdrov) 2020-07-30 14:57:09.263-0500 No, we don't use subscription persistence data. We use this table to take the load off AstDB, | ||