<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
are you running the last kamailio branch 4.3 or is from packages?<br>
<br>
Do you get a core dump file? If yes, can you send the backtrace?<br>
<br>
Daniel<br>
<br>
<div class="moz-cite-prefix">On 29/09/15 23:07, huseyin kalyoncu
wrote:<br>
</div>
<blockquote
cite="mid:CAPf+86Vmi7x8aJZdHkMPCGv6jQ0esVdEaMnTvK0FCGs2TRni-Q@mail.gmail.com"
type="cite">
<div dir="ltr">Hello Daniel,
<div><br>
</div>
<div>I have been having some strange crashes after upgrade to
4.3.2</div>
<div><br>
</div>
<div>i did not configure for core dump but when i check the
kern.log after crash i see this:</div>
<div><br>
</div>
<div>
<div>Sep 29 22:47:19 km1 kernel: [1815465.204612]
kamailio[4211]: segfault at 60 ip 00007f64319df2e4 sp
00007ffe99c703b8 error 4 in <a moz-do-not-send="true"
href="http://libc-2.19.so">libc-2.19.so</a>[7f643194a000+19f000]</div>
<div>Sep 29 22:47:19 km1 kernel: [1815465.413074]
kamailio[4201]: segfault at f0f0f100 ip 00007f64287c7915 sp
00007ffe99c72600 error 4 in
pua_dialoginfo.so[7f64287be000+13000]</div>
<div><br>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Mon, Sep 28, 2015 at 1:15 PM,
huseyin kalyoncu <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:hkalyoncu@gmail.com" target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:hkalyoncu@gmail.com">hkalyoncu@gmail.com</a></a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr">
<div><br>
</div>
Hello Daniel
<div><br>
</div>
<div>Sorry for the late response. Yes, when i change
subs_db_mode to 3 i see lots of error messages as
below.</div>
<div>5678*002 is the subscriber for 5678*012 and
5678*011. When all phones idle, everything is fine
all lamps are green. </div>
<div>But when i make a call i see error messages and
nothing changes with the lamps.</div>
<div>Sorry for inconvenience but I had to mask public
IP addresses in the logs. </div>
<div>I am using Kamailio version 4.3.2 and
Postgresql-server 9.4.3 as DB.</div>
<div>root@km1:~# uname -a</div>
<div>Linux km1 3.16.0-4-amd64 #1 SMP Debian
3.16.7-ckt11-1+deb8u3 (2015-08-04) x86_64 GNU/Linux</div>
<div> </div>
<div>Btw i tried to separate presence server from
proxy but nothing changes and i saw the same errors
as below.</div>
<div><br>
</div>
<div>Thanks</div>
<div><br>
</div>
<div>Huseyin </div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>
<div>1:45:45 km1 kamailio_presence[10037]: WARNING:
db_postgres [km_dbase.c:277]:
db_postgres_submit_query(): postgres result check
failed with code 7 (PGRES_FATAL_ERROR)</div>
<div>Sep 28 11:45:45 km1 kamailio_presence[10037]:
WARNING: db_postgres [km_dbase.c:281]:
db_postgres_submit_query(): postgres query command
failed, connection status 0, error [ERROR:
duplicate key value violates unique constraint
"presentity_presentity_idx"#012DETAIL: Key
(username, domain, event, etag)=(5678*002,
XXX.XXX.XX.XXX, dialog, *#-OFFLINE-#*) already
exists.#012]</div>
<div>Sep 28 11:45:45 km1 kamailio_presence[10037]:
ERROR: db_postgres [km_dbase.c:290]:
db_postgres_submit_query(): 0x7f0dd4497060
PQsendQuery Error: ERROR: duplicate key value
violates unique constraint
"presentity_presentity_idx"#012DETAIL: Key
(username, domain, event, etag)=(5678*002,
XXX.XXX.XX.XXX, dialog, *#-OFFLINE-#*) already
exists.#012 Query: update presentity set
etag='*#-OFFLINE-#*',expires=1443433545,body='<?xml
version="1.0"?>#012<dialog-info
xmlns="urn:ietf:params:xml:ns:dialog-info"
version="00000000000" state="full"
entity=<a class="moz-txt-link-rfc2396E" href="sip:5678*002@XXX.XXX.XX.XXX">"sip:5678*002@XXX.XXX.XX.XXX"</a>>#012
<dialog id="1074899713" call-id="1074899713"
direction="recipient">#012
<state>terminated</state>#012
<remote>#012
<identity><a class="moz-txt-link-freetext" href="sip:5678*011@XXX.XXX.XX.XXX">sip:5678*011@XXX.XXX.XX.XXX</a></identity>#012
<target
uri=<a class="moz-txt-link-rfc2396E" href="sip:5678*011@XXX.XXX.XX.XXX:5060">"sip:5678*011@XXX.XXX.XX.XXX:5060"</a>/>#012
</remote>#012 <local>#012
<identity><a class="moz-txt-link-freetext" href="sip:5678*002@XXX.XXX.XX.XXX:5060">sip:5678*002@XXX.XXX.XX.XXX:5060</a></identity>#012
<target
uri=<a class="moz-txt-link-rfc2396E" href="sip:5678*002@XXX.XXX.XX.XXX:5060">"sip:5678*002@XXX.XXX.XX.XXX:5060"</a>/>#012
</local>#012
</dialog>#012</dialog-info>#012'
where username='5678*002' AND
domain='XXX.XXX.XX.XXX' AND event='dialog' AND
etag='a.1442821424.10032.187.0'</div>
<div>Sep 28 11:45:45 km1 kamailio_presence[10037]:
ERROR: <core> [db_query.c:339]:
db_do_update(): error while submitting query</div>
<div>Sep 28 11:45:45 km1 kamailio_presence[10037]:
ERROR: db_postgres [km_dbase.c:580]:
db_postgres_store_result(): invalid query,
execution aborted</div>
<div>Sep 28 11:45:45 km1 kamailio_presence[10037]:
ERROR: db_postgres [km_dbase.c:581]:
db_postgres_store_result(): driver error:
PGRES_FATAL_ERROR, ERROR: duplicate key value
violates unique constraint
"presentity_presentity_idx"#012DETAIL: Key
(username, domain, event, etag)=(5678*002,
XXX.XXX.XX.XXX, dialog, *#-OFFLINE-#*) already
exists.</div>
<div>Sep 28 11:45:45 km1 kamailio_presence[10037]:
WARNING: db_postgres [km_dbase.c:690]:
db_postgres_update(): unexpected result returned</div>
<div>Sep 28 11:45:45 km1 kamailio_presence[10037]:
ERROR: presence [presentity.c:1324]:
mark_presentity_for_delete(): unsuccessful sql
update operation</div>
<div>Sep 28 11:45:45 km1 kamailio_presence[10037]:
ERROR: presence [publish.c:169]:
msg_presentity_clean(): Marking presentity</div>
<div>Sep 28 11:45:47 km1 kamailio_presence[10036]:
INFO: presence [subscribe.c:1601]:
get_database_info(): No matching subscription
dialog found in database</div>
<div>Sep 28 11:45:47 km1 kamailio_presence[10036]:
INFO: presence [subscribe.c:949]:
handle_subscribe(): getting stored info</div>
<div>Sep 28 11:45:55 km1 kamailio_presence[10035]:
ERROR: presence [subscribe.c:1617]:
get_database_info(): wrong sequence number
received: 22 - stored: 22</div>
<div>Sep 28 11:45:55 km1 kamailio_presence[10035]:
INFO: presence [subscribe.c:949]:
handle_subscribe(): getting stored info</div>
<div>Sep 28 11:45:55 km1 kamailio_presence[10036]:
INFO: presence [subscribe.c:1601]:
get_database_info(): No matching subscription
dialog found in database</div>
<div>Sep 28 11:45:55 km1 kamailio_presence[10036]:
INFO: presence [subscribe.c:949]:
handle_subscribe(): getting stored info</div>
<div>Sep 28 11:46:03 km1 kamailio_presence[10031]:
ERROR: presence [subscribe.c:1617]:
get_database_info(): wrong sequence number
received: 22 - stored: 22</div>
<div>Sep 28 11:46:03 km1 kamailio_presence[10031]:
INFO: presence [subscribe.c:949]:
handle_subscribe(): getting stored info</div>
<div>Sep 28 11:46:03 km1 kamailio_presence[10033]:
INFO: presence [subscribe.c:1601]:
get_database_info(): No matching subscription
dialog found in database</div>
<div>Sep 28 11:46:03 km1 kamailio_presence[10033]:
INFO: presence [subscribe.c:949]:
handle_subscribe(): getting stored info</div>
<div>Sep 28 11:46:11 km1 kamailio_presence[10034]:
ERROR: presence [subscribe.c:1617]:
get_database_info(): wrong sequence number
received: 22 - stored: 22</div>
<div>Sep 28 11:46:11 km1 kamailio_presence[10034]:
INFO: presence [subscribe.c:949]:
handle_subscribe(): getting stored info</div>
<div>Sep 28 11:46:11 km1 kamailio_presence[10035]:
INFO: presence [subscribe.c:1601]:
get_database_info(): No matching subscription
dialog found in database</div>
<div>Sep 28 11:46:11 km1 kamailio_presence[10035]:
INFO: presence [subscribe.c:949]:
handle_subscribe(): getting stored info</div>
<div>Sep 28 11:46:25 km1 kamailio_presence[10037]:
WARNING: db_postgres [km_dbase.c:277]:
db_postgres_submit_query(): postgres result check
failed with code 7 (PGRES_FATAL_ERROR)</div>
<div>Sep 28 11:46:25 km1 kamailio_presence[10037]:
WARNING: db_postgres [km_dbase.c:281]:
db_postgres_submit_query(): postgres query command
failed, connection status 0, error [ERROR:
duplicate key value violates unique constraint
"presentity_presentity_idx"#012DETAIL: Key
(username, domain, event, etag)=(5678*012,
XXX.XXX.XX.XXX, dialog, *#-OFFLINE-#*) already
exists.#012]</div>
<div>Sep 28 11:46:25 km1 kamailio_presence[10037]:
ERROR: db_postgres [km_dbase.c:290]:
db_postgres_submit_query(): 0x7f0dd4497060
PQsendQuery Error: ERROR: duplicate key value
violates unique constraint
"presentity_presentity_idx"#012DETAIL: Key
(username, domain, event, etag)=(5678*012,
XXX.XXX.XX.XXX, dialog, *#-OFFLINE-#*) already
exists.#012 Query: update presentity set
etag='*#-OFFLINE-#*',expires=1443433585,body='<?xml
version="1.0"?>#012<dialog-info
xmlns="urn:ietf:params:xml:ns:dialog-info"
version="00000000000" state="full"
entity=<a class="moz-txt-link-rfc2396E" href="sip:5678*012@XXX.XXX.XX.XXX">"sip:5678*012@XXX.XXX.XX.XXX"</a>>#012
<dialog id="CLaNCoBMpzbMBIZ6wPvEFw.."
call-id="CLaNCoBMpzbMBIZ6wPvEFw.."
direction="recipient">#012
<state>terminated</state>#012
<remote>#012
<identity><a class="moz-txt-link-freetext" href="sip:5678*002@XXX.XXX.XX.XXX;transport=TCP">sip:5678*002@XXX.XXX.XX.XXX;transport=TCP</a></identity>#012
<target
uri=<a class="moz-txt-link-rfc2396E" href="sip:5678*002@192.168.1.20:63157;transport=tcp;alias=XXX.XXX.XX.XXX~49663~2">"sip:5678*002@192.168.1.20:63157;transport=tcp;alias=XXX.XXX.XX.XXX~49663~2"</a>/>#012
</remote>#012 <local>#012
<identity><a class="moz-txt-link-freetext" href="sip:5678*012@XXX.XXX.XX.XXX;transport=TCP">sip:5678*012@XXX.XXX.XX.XXX;transport=TCP</a></identity>#012
<target
uri=<a class="moz-txt-link-rfc2396E" href="sip:5678*012@XXX.XXX.XX.XXX;transport=TCP">"sip:5678*012@XXX.XXX.XX.XXX;transport=TCP"</a>/>#012
</local>#012
</dialog>#012</dialog-info>#012'
where username='5678*012' AND
domain='XXX.XXX.XX.XXX' AND event='dialog' AND
etag='a.1442821424.10036.177.0'</div>
<div>Sep 28 11:46:25 km1 kamailio_presence[10037]:
ERROR: <core> [db_query.c:339]:
db_do_update(): error while submitting query</div>
<div>Sep 28 11:46:25 km1 kamailio_presence[10037]:
ERROR: db_postgres [km_dbase.c:580]:
db_postgres_store_result(): invalid query,
execution aborted</div>
<div>Sep 28 11:46:25 km1 kamailio_presence[10037]:
ERROR: db_postgres [km_dbase.c:581]:
db_postgres_store_result(): driver error:
PGRES_FATAL_ERROR, ERROR: duplicate key value
violates unique constraint
"presentity_presentity_idx"#012DETAIL: Key
(username, domain, event, etag)=(5678*012,
XXX.XXX.XX.XXX, dialog, *#-OFFLINE-#*) already
exists.</div>
<div>Sep 28 11:46:25 km1 kamailio_presence[10037]:
WARNING: db_postgres [km_dbase.c:690]:
db_postgres_update(): unexpected result returned</div>
<div>Sep 28 11:46:25 km1 kamailio_presence[10037]:
ERROR: presence [presentity.c:1324]:
mark_presentity_for_delete(): unsuccessful sql
update operation</div>
<div>Sep 28 11:46:25 km1 kamailio_presence[10037]:
ERROR: presence [publish.c:169]:
msg_presentity_clean(): Marking presentity</div>
<div>Sep 28 11:47:05 km1 kamailio_presence[10037]:
WARNING: db_postgres [km_dbase.c:277]:
db_postgres_submit_query(): postgres result check
failed with code 7 (PGRES_FATAL_ERROR)</div>
<div>Sep 28 11:47:05 km1 kamailio_presence[10037]:
WARNING: db_postgres [km_dbase.c:281]:
db_postgres_submit_query(): postgres query command
failed, connection status 0, error [ERROR:
duplicate key value violates unique constraint
"presentity_presentity_idx"#012DETAIL: Key
(username, domain, event, etag)=(5678*012,
XXX.XXX.XX.XXX, dialog, *#-OFFLINE-#*) already
exists.#012]</div>
<div>Sep 28 11:47:05 km1 kamailio_presence[10037]:
ERROR: db_postgres [km_dbase.c:290]:
db_postgres_submit_query(): 0x7f0dd4497060
PQsendQuery Error: ERROR: duplicate key value
violates unique constraint
"presentity_presentity_idx"#012DETAIL: Key
(username, domain, event, etag)=(5678*012,
XXX.XXX.XX.XXX, dialog, *#-OFFLINE-#*) already
exists.#012 Query: update presentity set
etag='*#-OFFLINE-#*',expires=1443433625,body='<?xml
version="1.0"?>#012<dialog-info
xmlns="urn:ietf:params:xml:ns:dialog-info"
version="00000000000" state="full"
entity=<a class="moz-txt-link-rfc2396E" href="sip:5678*012@XXX.XXX.XX.XXX">"sip:5678*012@XXX.XXX.XX.XXX"</a>>#012
<dialog id="CLaNCoBMpzbMBIZ6wPvEFw.."
call-id="CLaNCoBMpzbMBIZ6wPvEFw.."
direction="recipient">#012
<state>terminated</state>#012
<remote>#012
<identity><a class="moz-txt-link-freetext" href="sip:5678*002@XXX.XXX.XX.XXX;transport=TCP">sip:5678*002@XXX.XXX.XX.XXX;transport=TCP</a></identity>#012
<target
uri=<a class="moz-txt-link-rfc2396E" href="sip:5678*002@192.168.1.20:63157;transport=tcp;alias=XXX.XXX.XX.XXX~49663~2">"sip:5678*002@192.168.1.20:63157;transport=tcp;alias=XXX.XXX.XX.XXX~49663~2"</a>/>#012
</remote>#012 <local>#012
<identity><a class="moz-txt-link-freetext" href="sip:5678*012@XXX.XXX.XX.XXX;transport=TCP">sip:5678*012@XXX.XXX.XX.XXX;transport=TCP</a></identity>#012
<target
uri=<a class="moz-txt-link-rfc2396E" href="sip:5678*012@XXX.XXX.XX.XXX;transport=TCP">"sip:5678*012@XXX.XXX.XX.XXX;transport=TCP"</a>/>#012
</local>#012
</dialog>#012</dialog-info>#012'
where username='5678*012' AND
domain='XXX.XXX.XX.XXX' AND event='dialog' AND
etag='a.1442821424.10036.177.0'</div>
<div>Sep 28 11:47:05 km1 kamailio_presence[10037]:
ERROR: <core> [db_query.c:339]:
db_do_update(): error while submitting query</div>
<div>Sep 28 11:47:05 km1 kamailio_presence[10037]:
ERROR: db_postgres [km_dbase.c:580]:
db_postgres_store_result(): invalid query,
execution aborted</div>
<div>Sep 28 11:47:05 km1 kamailio_presence[10037]:
ERROR: db_postgres [km_dbase.c:581]:
db_postgres_store_result(): driver error:
PGRES_FATAL_ERROR, ERROR: duplicate key value
violates unique constraint
"presentity_presentity_idx"#012DETAIL: Key
(username, domain, event, etag)=(5678*012,
XXX.XXX.XX.XXX, dialog, *#-OFFLINE-#*) already
exists.</div>
<div>Sep 28 11:47:05 km1 kamailio_presence[10037]:
WARNING: db_postgres [km_dbase.c:690]:
db_postgres_update(): unexpected result returned</div>
<div>Sep 28 11:47:05 km1 kamailio_presence[10037]:
ERROR: presence [presentity.c:1324]:
mark_presentity_for_delete(): unsuccessful sql
update operation</div>
<div>Sep 28 11:47:05 km1 kamailio_presence[10037]:
ERROR: presence [publish.c:169]:
msg_presentity_clean(): Marking presentity</div>
</div>
<div><br>
</div>
<div><br>
</div>
<div> </div>
<div>
<div class="gmail_extra"><br>
<div class="gmail_quote"><span>On Fri, Sep 11,
2015 at 1:16 PM, Daniel-Constantin Mierla <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:miconda@gmail.com"
target="_blank">miconda@gmail.com</a>></span>
wrote:<br>
</span>
<blockquote class="gmail_quote"
style="margin:0px 0px 0px
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> Hello,<br>
<br>
<span> I will adjust the tutorial to make
the note about PUBLISH looping back and
need to authorize it by IP check.<br>
<br>
Regarding "db_mode", are you referring to
"subs_db_mode" parameter?<br>
<br>
Cheers,<br>
Daniel
<div>
<div>
<div><br>
</div>
</div>
</div>
</span></div>
</blockquote>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a>
Book: SIP Routing With Kamailio - <a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a>
Kamailio Advanced Training, Sep 28-30, 2015, in Berlin - <a class="moz-txt-link-freetext" href="http://asipto.com/u/kat">http://asipto.com/u/kat</a></pre>
</body>
</html>