[OpenSIPS-Users] Presence issue

[Bogdan-Andrei Iancu]

Hi Dan,

What I failed so far was to reproduced it in a controlled environment. 
Do you have a setup, special cfg + SIP UAC , instructions to reproduce 
this issue ?

Thanks,

Bogdan-Andrei Iancu

OpenSIPS Founder and Developer
   http://www.opensips-solutions.com
OpenSIPS Bootcamp 2018
   http://opensips.org/training/OpenSIPS_Bootcamp_2018/

On 10/16/2018 02:30 PM, Dan Pascu wrote:
> On 28 Sep 2018, at 14:36, Dan Pascu wrote:
>
>> On 24 Sep 2018, at 23:14, Bogdan-Andrei Iancu wrote:
>>
>>> Hi Dan,
>>>
>>> I'm trying to hunt this issue for a while , see:
>>>
>>> https://github.com/OpenSIPS/opensips/issues/1422
>>> https://github.com/OpenSIPS/opensips/issues/1378
>>>
>>> But I never was able to reproduce it local, in order to debug it. Can you reproduce it ?
>> It happens to me for every PUBLISH received.
> So what information would you need in order to fix this?
>
>>>
>>> Best regards,
>>>
>>> Bogdan-Andrei Iancu
>>>
>>> OpenSIPS Founder and Developer
>>> http://www.opensips-solutions.com
>>> OpenSIPS Bootcamp 2018
>>> http://opensips.org/training/OpenSIPS_Bootcamp_2018/
>>>
>>> On 09/21/2018 02:16 PM, Dan Pascu wrote:
>>>> After I started to test the lastest git code from master I noticed errors like this in my logs:
>>>>
>>>>
>>>> Sep 21 13:01:41 node03 /usr/sbin/opensips[22838]: CRITICAL:db_mysql:wrapper_single_mysql_real_query: driver error (1062): Duplicate entry 'dan-test.sip2sip.info-presence-a.1537527127.22838.2.1' for key 'presentity_idx'
>>>> Sep 21 13:01:41 node03 /usr/sbin/opensips[22838]: ERROR:core:db_do_update: error while submitting query
>>>> Sep 21 13:01:41 node03 /usr/sbin/opensips[22838]: ERROR:presence:update_presentity: updating published info in database
>>>> Sep 21 13:01:41 node03 /usr/sbin/opensips[22838]: ERROR:presence:handle_publish: when updating presentity
>>>>
>>>>
>>>> I checked the presentity table and there is NO record with etag = a.1537527127.22838.2.1 in the database. I found however multiple records in the database for that particular account some of which are long expired yet not deleted from the database. The records seem to increase every time I publish presence:
>>>>
>>>> MariaDB [opensips]> select username, domain, event, etag from presentity where username = 'dan';
>>>> +----------+-------------------+----------+------------------------+
>>>> | username | domain            | event    | etag                   |
>>>> +----------+-------------------+----------+------------------------+
>>>> | dan      | test.sip2sip.info | presence | a.1537455410.31931.2.2 |
>>>> | dan      | test.sip2sip.info | presence | a.1537456928.2432.2.0  |
>>>> | dan      | test.sip2sip.info | presence | a.1537526062.20412.1.0 |
>>>> | dan      | test.sip2sip.info | presence | a.1537526092.20529.2.0 |
>>>> | dan      | test.sip2sip.info | presence | a.1537526122.20854.1.0 |
>>>> | dan      | test.sip2sip.info | presence | a.1537526997.22186.2.0 |
>>>> | dan      | test.sip2sip.info | presence | a.1537527037.22557.1.0 |
>>>> | dan      | test.sip2sip.info | presence | a.1537527072.22698.1.0 |
>>>> | dan      | test.sip2sip.info | presence | a.1537527127.22835.2.0 |
>>>> +----------+-------------------+----------+------------------------+
>>>> 9 rows in set (0.00 sec)
>>>>
>>>>
>>>> I also checked an older opensips-1.11 server and there I only have 1 record per AOR and I never see such errors in syslog:
>>>>
>>>> mysql> select username, domain, event, etag from presentity where username = 'dan';
>>>> +----------+-----------------+----------+--------------------------------+
>>>> | username | domain          | event    | etag                           |
>>>> +----------+-----------------+----------+--------------------------------+
>>>> | dan      | ag-projects.com | presence | a.1530701145.32175.100449.152  |
>>>> | dan      | sip2sip.info    | presence | a.1530701145.32185.100643.3251 |
>>>> +----------+-----------------+----------+--------------------------------+
>>>> 2 rows in set (0.00 sec)
>>>>
>>>>
>>>> I use the same SIP client in both cases, but I only see the errors on the latest opensips from master. These errors happen every time I publish presence for that account.
>>>>
>>>> In addition I noticed other presence related errors in syslog, which might or might not be related to this:
>>>>
>>>> Sep 21 13:02:08 node03 /usr/sbin/opensips[22889]: ERROR:presence:delete_phtable_query: Record not found [a.1537526997.22186.2.0]
>>>> Sep 21 13:02:08 node03 /usr/sbin/opensips[22889]: ERROR:presence:msg_presentity_clean: deleting from pres hash table
>>>> Sep 21 13:02:08 node03 /usr/sbin/opensips[22889]: ERROR:presence:delete_phtable_query: Record not found [a.1537527037.22557.1.0]
>>>> Sep 21 13:02:08 node03 /usr/sbin/opensips[22889]: ERROR:presence:msg_presentity_clean: deleting from pres hash table
>>>> Sep 21 13:02:08 node03 /usr/sbin/opensips[22889]: ERROR:presence:delete_phtable_query: Record not found [a.1537527072.22698.1.0]
>>>> Sep 21 13:02:08 node03 /usr/sbin/opensips[22889]: ERROR:presence:msg_presentity_clean: deleting from pres hash table
>>>>
>>>>
>>>> --
>>>> Dan
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Users mailing list
>>>> Users at lists.opensips.org
>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>> --
>> Dan
>>
>>
>>
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
> --
> Dan
>
>
>
>