[asterisk-bugs] [JIRA] (ASTERISK-29015) res_pjsip_pubsub: ps_subscription_persistence Alembic does not include generator_data

[Alex Odrov (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-29015?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=251575#comment-251575 ] 

Alex Odrov commented on ASTERISK-29015:
---------------------------------------

No, we don't use subscription persistence data. We use this table it to take the load off AstDB,

> res_pjsip_pubsub: ps_subscription_persistence Alembic does not include generator_data
> -------------------------------------------------------------------------------------
>
>                 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
>            Assignee: 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)