[sr-dev] location table expire/ruid problem again

Juha Heinanen jh at tutpro.com
Tue Apr 23 21:06:32 CEST 2013


Daniel-Constantin Mierla writes:

> can you capture (ngrep) the REGISTER requests for the two cases and send 
> them over? I don't have a pjsua with me right now, but I can re-inject 
> them with protoshot and reproduce, that will help to troubleshoot properly.

daniel,

the requests along with some syslog entries and comments are below.  i
removed Authorization: headers from register requests.

-- juha

T 2013/04/23 22:01:22.372754 192.98.102.10:57892 -> 192.98.102.10:5060 [AP]
REGISTER sip:192.98.102.10 SIP/2.0.
Via: SIP/2.0/TCP 192.98.102.10:57892;rport;branch=z9hG4bKPj9e911277-3bc5-4184-807f-6fa5534b1f21.
Route: <sip:192.98.102.10;transport=tcp;lr>.
Max-Forwards: 70.
From: <sip:jh at test.fi>;tag=68259460-b3cc-49e7-81f4-3e6138d5eec9.
To: <sip:jh at test.fi>.
Call-ID: 9f971272-fcf4-4312-874f-d390a448e88a.
CSeq: 28125 REGISTER.
User-Agent: PJSUA v2.1 Linux-3.2.0.4/x86_64/glibc-2.13.
Supported: outbound, path.
Contact: <sip:jh at 192.98.102.10:5068;transport=TCP;ob>;reg-id=1;+sip.instance="<urn:uuid:00000000-0000-0000-0000-000091625c08>".
Expires: 300.
Allow: PRACK, INVITE, ACK, BYE, CANCEL, UPDATE, INFO, SUBSCRIBE, NOTIFY, REFER, MESSAGE, OPTIONS.
Content-Length:  0.

Apr 23 22:01:22 siika /usr/sbin/sip-proxy[6393]: INFO: REGISTER <sip:jh at test.fi> by <jh at test.fi> from <192.98.102.10> is authorized

##
T 2013/04/23 22:01:22.501737 192.98.102.10:5060 -> 192.98.102.10:57892 [AP]
SIP/2.0 200 OK.
Via: SIP/2.0/TCP 192.98.102.10:57892;rport=57892;branch=z9hG4bKPj9e911277-3bc5-4184-807f-6fa5534b1f21.
From: <sip:jh at test.fi>;tag=68259460-b3cc-49e7-81f4-3e6138d5eec9.
To: <sip:jh at test.fi>;tag=c02670ad1171fe45d9ff9a27d6c2cb82-a4e7.
Call-ID: 9f971272-fcf4-4312-874f-d390a448e88a.
CSeq: 28125 REGISTER.
Contact: <sip:jh at 192.98.102.10:5068;transport=TCP;ob>;q=0.5;expires=300;received="sip:192.98.102.10:57892;transport=TCP";+sip.instance="<urn:uuid:00000000-0000-0000-0000-000091625c08>";reg-id=1.
Supported: outbound.
Require: outbound.
Server: OpenXg SIP Proxy  (4.1.0-dev3 (x86_64/linux)).
Content-Length: 0.
.

at this point i -KILLed pjsua and started it again.

##
T 2013/04/23 22:01:51.333822 192.98.102.10:52559 -> 192.98.102.10:5060 [AP]
REGISTER sip:192.98.102.10 SIP/2.0.
Via: SIP/2.0/TCP 192.98.102.10:52559;rport;branch=z9hG4bKPj5dc30bbd-73e3-483d-8ff8-7401cd8c49c7.
Route: <sip:192.98.102.10;transport=tcp;lr>.
Max-Forwards: 70.
From: <sip:jh at test.fi>;tag=c9c332e4-24cb-461e-a978-efb48200cf7f.
To: <sip:jh at test.fi>.
Call-ID: 0f3f745f-1846-4a3b-a1fd-b900ad896c3c.
CSeq: 2625 REGISTER.
User-Agent: PJSUA v2.1 Linux-3.2.0.4/x86_64/glibc-2.13.
Supported: outbound, path.
Contact: <sip:jh at 192.98.102.10:5068;transport=TCP;ob>;reg-id=1;+sip.instance="<urn:uuid:00000000-0000-0000-0000-000091625c08>".
Expires: 300.
Allow: PRACK, INVITE, ACK, BYE, CANCEL, UPDATE, INFO, SUBSCRIBE, NOTIFY, REFER, MESSAGE, OPTIONS.
Content-Length:  0.
.

Apr 23 22:01:51 siika /usr/sbin/sip-proxy[6399]: INFO: REGISTER <sip:jh at test.fi> by <jh at test.fi> from <192.98.102.10> is authorized
#Apr 23 22:01:51 siika /usr/sbin/sip-proxy[6399]: ERROR: db_mysql [km_dbase.c:122]: driver error on query: Duplicate entry 'uloc-5176d955-18f9-1' for key 'ruid_idx'
Apr 23 22:01:51 siika /usr/sbin/sip-proxy[6399]: ERROR: <core> [db_query.c:235]: error while submitting query
Apr 23 22:01:51 siika /usr/sbin/sip-proxy[6399]: ERROR: usrloc [ucontact.c:615]: inserting contact in db failed
Apr 23 22:01:51 siika /usr/sbin/sip-proxy[6399]: ERROR: usrloc [ucontact.c:998]: failed to update database
Apr 23 22:01:51 siika /usr/sbin/sip-proxy[6399]: ERROR: registrar [save.c:739]: failed to update contact
#
T 2013/04/23 22:01:51.441256 192.98.102.10:5060 -> 192.98.102.10:52559 [AP]
SIP/2.0 500 Server Internal Error.
Via: SIP/2.0/TCP 192.98.102.10:52559;rport=52559;branch=z9hG4bKPj5dc30bbd-73e3-483d-8ff8-7401cd8c49c7.
From: <sip:jh at test.fi>;tag=c9c332e4-24cb-461e-a978-efb48200cf7f.
To: <sip:jh at test.fi>;tag=c02670ad1171fe45d9ff9a27d6c2cb82-d6cb.
Call-ID: 0f3f745f-1846-4a3b-a1fd-b900ad896c3c.
CSeq: 2625 REGISTER.
Contact: <sip:jh at 192.98.102.10:5068;transport=TCP;ob>;q=0.5;expires=300;received="sip:192.98.102.10:52559;transport=TCP";+sip.instance="<urn:uuid:00000000-0000-0000-0000-000091625c08>";reg-id=1.
P-Registrar-Error: usrloc_contact_update failed.
Server: OpenXg SIP Proxy  (4.1.0-dev3 (x86_64/linux)).
Content-Length: 0.



More information about the sr-dev mailing list