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

[Nic Colledge (JIRA)]

Nic Colledge created ASTERISK-25702:
---------------------------------------

             Summary: 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


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)...

[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.;

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:

contact/cache=memory_cache,expire_on_reload=yes,object_lifetime_maximum=1800
contact=realtime,ps_contacts
contact=config,pjsip.conf,criteria=type=contact

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)