[asterisk-bugs] [JIRA] (ASTERISK-29015) PJSIP Realtime doesn't work after upgrade from 13.29

[Alex Odrov (JIRA)]

Alex Odrov created ASTERISK-29015:
-------------------------------------

             Summary: PJSIP Realtime doesn't work after upgrade from 13.29
                 Key: ASTERISK-29015
                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-29015
             Project: Asterisk
          Issue Type: Bug
      Security Level: None
          Components: Resources/res_odbc, Resources/res_pjsip_pubsub
    Affects Versions: 13.35.0
            Reporter: Alex Odrov
            Severity: Minor


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.



--
This message was sent by Atlassian JIRA
(v6.2#6252)