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

[Rusty Newton (JIRA)]

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

Rusty Newton updated ASTERISK-25702:
------------------------------------

    Assignee: Nic Colledge
      Status: Waiting for Feedback  (was: Triage)

Thanks for the report. 

Please go ahead and provide complete configs (for odbc, pgsql, relevant Asterisk modules) and sanitize as necessary.

In addition provide another Asterisk log but include the DEBUG logger channel. Make sure verbose and DEBUG are both turned up to 5.

> 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, Resources/res_pjsip
>    Affects Versions: 13.7.0
>         Environment: Ubuntu 15.10 Linux 4.2.0-19-generic
>            Reporter: Nic Colledge
>            Assignee: Nic Colledge
>
> 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)