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

[Joshua Colp (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-25702?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Joshua Colp updated ASTERISK-25702:
-----------------------------------

    Status: Open  (was: Triage)

> 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
>            Severity: Blocker
>      Target Release: 13.8.0
>
>         Attachments: ASTERISK-25702-13_7.diff
>
>
> 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)