From notifications@github.com Tue Jan 13 15:52:42 2015
From: Savolainen Dmitri <notifications@github.com>
To: sr-dev@lists.kamailio.org
Subject: Re: [sr-dev] [kamailio] event on table location Duplicate entry for
 key 'ruid_idx' (#30)
Date: Tue, 13 Jan 2015 06:52:30 -0800
Message-ID: <kamailio/kamailio/issues/30/69755233@github.com>
In-Reply-To: <kamailio/kamailio/issues/30@github.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============0274941213=="

--===============0274941213==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

from my post http://sip-router.org/tracker/index.php?do=3Ddetails&task_id=3D4=
48
<q>
"Comment by Savolainen Dmitri (snen) - Friday, 04 July 2014, 12:55 GMT
Yes, it is about adding the same record twice, but it doesn't matter via kamc=
tl or via sip-endpoint. Just kamctl with permanent registration is more clear=
ly, because there is no expire. Same update with expire will try to INSERT un=
til expired (or adding not same record)"
</q>
You've fixed only MI part, but  dynamic registration from  endpoints in the u=
srloc record may be marked as CS_DIRTY with modparam("usrloc", "db_check_upda=
te", 1) and will be never CS_SYNC up to kamailio reboot or registration chang=
ed. So  we can see multiple "Duplicate entry" message every <a href=3D"http:/=
/www.kamailio.org/docs/modules/4.2.x/modules/usrloc.html#usrloc.p.timer_inter=
val">timer_interval</a>  period.    You can see my fixing suggestions in the =
initial post of http://sip-router.org/tracker/index.php?do=3Ddetails&task_id=
=3D448

---
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/issues/30#issuecomment-69755233



--===============0274941213==
Content-Type: text/html
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="attachment.html"
MIME-Version: 1.0

PHA+ZnJvbSBteSBwb3N0IDxhIGhyZWY9Imh0dHA6Ly9zaXAtcm91dGVyLm9yZy90cmFja2VyL2lu
ZGV4LnBocD9kbz1kZXRhaWxzJmFtcDt0YXNrX2lkPTQ0OCI+aHR0cDovL3NpcC1yb3V0ZXIub3Jn
L3RyYWNrZXIvaW5kZXgucGhwP2RvPWRldGFpbHMmYW1wO3Rhc2tfaWQ9NDQ4PC9hPjxicj4KPHE+
PGJyPgoiQ29tbWVudCBieSBTYXZvbGFpbmVuIERtaXRyaSAoc25lbikgLSBGcmlkYXksIDA0IEp1
bHkgMjAxNCwgMTI6NTUgR01UPGJyPgpZZXMsIGl0IGlzIGFib3V0IGFkZGluZyB0aGUgc2FtZSBy
ZWNvcmQgdHdpY2UsIGJ1dCBpdCBkb2Vzbid0IG1hdHRlciB2aWEga2FtY3RsIG9yIHZpYSBzaXAt
ZW5kcG9pbnQuIEp1c3Qga2FtY3RsIHdpdGggcGVybWFuZW50IHJlZ2lzdHJhdGlvbiBpcyBtb3Jl
IGNsZWFybHksIGJlY2F1c2UgdGhlcmUgaXMgbm8gZXhwaXJlLiBTYW1lIHVwZGF0ZSB3aXRoIGV4
cGlyZSB3aWxsIHRyeSB0byBJTlNFUlQgdW50aWwgZXhwaXJlZCAob3IgYWRkaW5nIG5vdCBzYW1l
IHJlY29yZCkiPGJyPgo8L3E+PGJyPgpZb3UndmUgZml4ZWQgb25seSBNSSBwYXJ0LCBidXQgIGR5
bmFtaWMgcmVnaXN0cmF0aW9uIGZyb20gIGVuZHBvaW50cyBpbiB0aGUgdXNybG9jIHJlY29yZCBt
YXkgYmUgbWFya2VkIGFzIENTX0RJUlRZIHdpdGggbW9kcGFyYW0oInVzcmxvYyIsICJkYl9jaGVj
a191cGRhdGUiLCAxKSBhbmQgd2lsbCBiZSBuZXZlciBDU19TWU5DIHVwIHRvIGthbWFpbGlvIHJl
Ym9vdCBvciByZWdpc3RyYXRpb24gY2hhbmdlZC4gU28gIHdlIGNhbiBzZWUgbXVsdGlwbGUgIkR1
cGxpY2F0ZSBlbnRyeSIgbWVzc2FnZSBldmVyeSA8YSBocmVmPSJodHRwOi8vd3d3LmthbWFpbGlv
Lm9yZy9kb2NzL21vZHVsZXMvNC4yLngvbW9kdWxlcy91c3Jsb2MuaHRtbCN1c3Jsb2MucC50aW1l
cl9pbnRlcnZhbCI+dGltZXJfaW50ZXJ2YWw8L2E+ICBwZXJpb2QuICAgIFlvdSBjYW4gc2VlIG15
IGZpeGluZyBzdWdnZXN0aW9ucyBpbiB0aGUgaW5pdGlhbCBwb3N0IG9mIDxhIGhyZWY9Imh0dHA6
Ly9zaXAtcm91dGVyLm9yZy90cmFja2VyL2luZGV4LnBocD9kbz1kZXRhaWxzJmFtcDt0YXNrX2lk
PTQ0OCI+aHR0cDovL3NpcC1yb3V0ZXIub3JnL3RyYWNrZXIvaW5kZXgucGhwP2RvPWRldGFpbHMm
YW1wO3Rhc2tfaWQ9NDQ4PC9hPjwvcD4KCjxwIHN0eWxlPSJmb250LXNpemU6c21hbGw7LXdlYmtp
dC10ZXh0LXNpemUtYWRqdXN0Om5vbmU7Y29sb3I6IzY2NjsiPiZtZGFzaDs8YnI+UmVwbHkgdG8g
dGhpcyBlbWFpbCBkaXJlY3RseSBvciA8YSBocmVmPSJodHRwczovL2dpdGh1Yi5jb20va2FtYWls
aW8va2FtYWlsaW8vaXNzdWVzLzMwI2lzc3VlY29tbWVudC02OTc1NTIzMyI+dmlldyBpdCBvbiBH
aXRIdWI8L2E+LjxpbWcgYWx0PSIiIGhlaWdodD0iMSIgc3JjPSJodHRwczovL2dpdGh1Yi5jb20v
bm90aWZpY2F0aW9ucy9iZWFjb24vQUYzNlpSUTRHd3JMT3NtSDNnYkI2NE8yaDVYd0g4cDZrczVu
aFNpdWdhSnBaTTREUmM4cy5naWYiIHdpZHRoPSIxIiAvPjwvcD4KPGRpdiBpdGVtc2NvcGUgaXRl
bXR5cGU9Imh0dHA6Ly9zY2hlbWEub3JnL0VtYWlsTWVzc2FnZSI+CiAgPGRpdiBpdGVtcHJvcD0i
YWN0aW9uIiBpdGVtc2NvcGUgaXRlbXR5cGU9Imh0dHA6Ly9zY2hlbWEub3JnL1ZpZXdBY3Rpb24i
PgogICAgPGxpbmsgaXRlbXByb3A9InVybCIgaHJlZj0iaHR0cHM6Ly9naXRodWIuY29tL2thbWFp
bGlvL2thbWFpbGlvL2lzc3Vlcy8zMCNpc3N1ZWNvbW1lbnQtNjk3NTUyMzMiPjwvbGluaz4KICAg
IDxtZXRhIGl0ZW1wcm9wPSJuYW1lIiBjb250ZW50PSJWaWV3IElzc3VlIj48L21ldGE+CiAgPC9k
aXY+CiAgPG1ldGEgaXRlbXByb3A9ImRlc2NyaXB0aW9uIiBjb250ZW50PSJWaWV3IHRoaXMgSXNz
dWUgb24gR2l0SHViIj48L21ldGE+CjwvZGl2Pgo=

--===============0274941213==--