[asterisk-bugs] [JIRA] (ASTERISK-25702) PjSip realtime DB and Cache Errors since upgrade to asterisk-13.7.0 from asterisk-13.7.0-rc2

[Asterisk Team (JIRA)]

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

Asterisk Team commented on ASTERISK-25702:
------------------------------------------

The severity of this issue has been automatically downgraded from "Blocker" to "Major". The "Blocker" severity is reserved for issues which have been determined to block the next release of Asterisk. This severity can only be set by privileged users. If this issue is deemed to block the next release it will be updated accordingly during the triage process.

> PjSip realtime DB and Cache Errors since upgrade to asterisk-13.7.0 from asterisk-13.7.0-rc2
> --------------------------------------------------------------------------------------------
>
>                 Key: ASTERISK-25702
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-25702
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Channels/chan_pjsip, Core/Sorcery, Resources/res_pjsip
>    Affects Versions: 13.7.0
>         Environment: Ubuntu 15.10 Linux 4.2.0-19-generic
>            Reporter: Nic Colledge
>            Assignee: Unassigned
>      Target Release: 13.8.0
>
>         Attachments: ASTERISK-25702-13_7.diff, realtime_retrieve_regex.patch
>
>
> Hi guys,
> Recently been doing some testing with 13.7.0-rc2 and then upgraded to 13.7.0. Having an issue with the following errors showing up on the console (with 13.7.0 but NOT with -rc2) relating to realtime pjsip / sorcery cache / odbc. These errors show up frequently (I think when the phone sends a register message)...
> {noformat}
> [Jan 17 15:23:12] WARNING[45435]: res_odbc.c:649 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 23505: ERROR: duplicate key value violates unique constraint "ps_contacts_id_key"
> Key (id)=(XXXX^3B at 72a0b3ea929375c2a0524bb43378a347) already exists.;
> Error while executing the query (180)
> [Jan 17 15:23:12] WARNING[45435]: res_odbc.c:661 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk-ps-connector [asterisk-ps-connector]...
> [Jan 17 15:23:12] WARNING[45435]: res_odbc.c:765 ast_odbc_sanity_check: Connection is down attempting to reconnect...
> [Jan 17 15:23:12] NOTICE[45435]: res_odbc.c:1528 odbc_obj_connect: Connecting asterisk-ps-connector
> [Jan 17 15:23:12] NOTICE[45435]: res_odbc.c:1567 odbc_obj_connect: res_odbc: Connected to asterisk-ps-connector [asterisk-ps-connector]
> [Jan 17 15:23:12] WARNING[45435]: res_odbc.c:649 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 23505: ERROR: duplicate key value violates unique constraint "ps_contacts_id_key"
> Key (id)=(XXXX^3B at 72a0b3ea929375c2a0524bb43378a347) already exists.;
> Error while executing the query (180)
> [Jan 17 15:23:12] WARNING[45435]: res_odbc.c:661 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk-ps-connector [asterisk-ps-connector]...
> [Jan 17 15:23:12] WARNING[45435]: res_odbc.c:765 ast_odbc_sanity_check: Connection is down attempting to reconnect...
> [Jan 17 15:23:12] NOTICE[45435]: res_odbc.c:1528 odbc_obj_connect: Connecting asterisk-ps-connector
> [Jan 17 15:23:12] NOTICE[45435]: res_odbc.c:1567 odbc_obj_connect: res_odbc: Connected to asterisk-ps-connector [asterisk-ps-connector]
> [Jan 17 15:23:12] ERROR[45435]: res_pjsip_registrar.c:504 rx_task: Unable to bind contact 'sip:XXXX at X.X.X.132:5060' to AOR 'XXXX'
> [Jan 17 15:23:25] ERROR[45212]: res_sorcery_memory_cache.c:1559 sorcery_memory_cache_delete: Unable to delete object 'XXXX;@72a0b3ea929375c2a0524bb43378a347' from sorcery cache
> [Jan 17 15:24:46] WARNING[45435]: res_odbc.c:649 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 23505: ERROR: duplicate key value violates unique constraint "ps_contacts_id_key"
> Key (id)=(XXXX^3B at 72a0b3ea929375c2a0524bb43378a347) already exists.;
> {noformat}
> Note that I have replaced the endpoint / aor names and IP addresses with X's.
> I can provide configs if required but the exact same configs work without issue on the -rc2 release.
> My odbc setup nothing special using a pgsql database. with a the schema created by alembic with one minor modification to work-around ASTERISK-25686 (int / double on qualify_timeout column).
> sorcery.conf lines for contact / domain_alias / aor / auth / endpoint / identify all follow the pattern of:
> {noformat}
> contact/cache=memory_cache,expire_on_reload=yes,object_lifetime_maximum=1800
> contact=realtime,ps_contacts
> contact=config,pjsip.conf,criteria=type=contact
> {noformat}
> Please let me know if any further information is required to help with triage.
> Thanks,
> Nic.



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