[SR-Users] blf problem
Daniel-Constantin Mierla
miconda at gmail.com
Wed Sep 30 08:51:49 CEST 2015
Hello,
are you running the last kamailio branch 4.3 or is from packages?
Do you get a core dump file? If yes, can you send the backtrace?
Daniel
On 29/09/15 23:07, huseyin kalyoncu wrote:
> Hello Daniel,
>
> I have been having some strange crashes after upgrade to 4.3.2
>
> i did not configure for core dump but when i check the kern.log after
> crash i see this:
>
> Sep 29 22:47:19 km1 kernel: [1815465.204612] kamailio[4211]: segfault
> at 60 ip 00007f64319df2e4 sp 00007ffe99c703b8 error 4 in libc-2.19.so
> <http://libc-2.19.so>[7f643194a000+19f000]
> 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]
>
>
> On Mon, Sep 28, 2015 at 1:15 PM, huseyin kalyoncu <hkalyoncu at gmail.com
> <mailto:hkalyoncu at gmail.com>> wrote:
>
>
> Hello Daniel
>
> Sorry for the late response. Yes, when i change subs_db_mode to 3
> i see lots of error messages as below.
> 5678*002 is the subscriber for 5678*012 and 5678*011. When all
> phones idle, everything is fine all lamps are green.
> But when i make a call i see error messages and nothing changes
> with the lamps.
> Sorry for inconvenience but I had to mask public IP addresses in
> the logs.
> I am using Kamailio version 4.3.2 and Postgresql-server 9.4.3 as DB.
> root at km1:~# uname -a
> Linux km1 3.16.0-4-amd64 #1 SMP Debian 3.16.7-ckt11-1+deb8u3
> (2015-08-04) x86_64 GNU/Linux
>
> Btw i tried to separate presence server from proxy but nothing
> changes and i saw the same errors as below.
>
> Thanks
>
> Huseyin
>
>
>
> 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)
> 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]
> 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="sip:5678*002 at XXX.XXX.XX.XXX">#012 <dialog
> id="1074899713" call-id="1074899713" direction="recipient">#012
> <state>terminated</state>#012 <remote>#012
> <identity>sip:5678*011 at XXX.XXX.XX.XXX</identity>#012 <target
> uri="sip:5678*011 at XXX.XXX.XX.XXX:5060"/>#012 </remote>#012
> <local>#012
> <identity>sip:5678*002 at XXX.XXX.XX.XXX:5060</identity>#012
> <target uri="sip:5678*002 at XXX.XXX.XX.XXX:5060"/>#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'
> Sep 28 11:45:45 km1 kamailio_presence[10037]: ERROR: <core>
> [db_query.c:339]: db_do_update(): error while submitting query
> Sep 28 11:45:45 km1 kamailio_presence[10037]: ERROR: db_postgres
> [km_dbase.c:580]: db_postgres_store_result(): invalid query,
> execution aborted
> 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.
> Sep 28 11:45:45 km1 kamailio_presence[10037]: WARNING: db_postgres
> [km_dbase.c:690]: db_postgres_update(): unexpected result returned
> Sep 28 11:45:45 km1 kamailio_presence[10037]: ERROR: presence
> [presentity.c:1324]: mark_presentity_for_delete(): unsuccessful
> sql update operation
> Sep 28 11:45:45 km1 kamailio_presence[10037]: ERROR: presence
> [publish.c:169]: msg_presentity_clean(): Marking presentity
> Sep 28 11:45:47 km1 kamailio_presence[10036]: INFO: presence
> [subscribe.c:1601]: get_database_info(): No matching subscription
> dialog found in database
> Sep 28 11:45:47 km1 kamailio_presence[10036]: INFO: presence
> [subscribe.c:949]: handle_subscribe(): getting stored info
> Sep 28 11:45:55 km1 kamailio_presence[10035]: ERROR: presence
> [subscribe.c:1617]: get_database_info(): wrong sequence number
> received: 22 - stored: 22
> Sep 28 11:45:55 km1 kamailio_presence[10035]: INFO: presence
> [subscribe.c:949]: handle_subscribe(): getting stored info
> Sep 28 11:45:55 km1 kamailio_presence[10036]: INFO: presence
> [subscribe.c:1601]: get_database_info(): No matching subscription
> dialog found in database
> Sep 28 11:45:55 km1 kamailio_presence[10036]: INFO: presence
> [subscribe.c:949]: handle_subscribe(): getting stored info
> Sep 28 11:46:03 km1 kamailio_presence[10031]: ERROR: presence
> [subscribe.c:1617]: get_database_info(): wrong sequence number
> received: 22 - stored: 22
> Sep 28 11:46:03 km1 kamailio_presence[10031]: INFO: presence
> [subscribe.c:949]: handle_subscribe(): getting stored info
> Sep 28 11:46:03 km1 kamailio_presence[10033]: INFO: presence
> [subscribe.c:1601]: get_database_info(): No matching subscription
> dialog found in database
> Sep 28 11:46:03 km1 kamailio_presence[10033]: INFO: presence
> [subscribe.c:949]: handle_subscribe(): getting stored info
> Sep 28 11:46:11 km1 kamailio_presence[10034]: ERROR: presence
> [subscribe.c:1617]: get_database_info(): wrong sequence number
> received: 22 - stored: 22
> Sep 28 11:46:11 km1 kamailio_presence[10034]: INFO: presence
> [subscribe.c:949]: handle_subscribe(): getting stored info
> Sep 28 11:46:11 km1 kamailio_presence[10035]: INFO: presence
> [subscribe.c:1601]: get_database_info(): No matching subscription
> dialog found in database
> Sep 28 11:46:11 km1 kamailio_presence[10035]: INFO: presence
> [subscribe.c:949]: handle_subscribe(): getting stored info
> 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)
> 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]
> 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="sip:5678*012 at XXX.XXX.XX.XXX">#012 <dialog
> id="CLaNCoBMpzbMBIZ6wPvEFw.." call-id="CLaNCoBMpzbMBIZ6wPvEFw.."
> direction="recipient">#012 <state>terminated</state>#012
> <remote>#012
> <identity>sip:5678*002 at XXX.XXX.XX.XXX;transport=TCP</identity>#012
> <target
> uri="sip:5678*002 at 192.168.1.20:63157;transport=tcp;alias=XXX.XXX.XX.XXX~49663~2"/>#012
> </remote>#012 <local>#012
> <identity>sip:5678*012 at XXX.XXX.XX.XXX;transport=TCP</identity>#012
> <target uri="sip:5678*012 at XXX.XXX.XX.XXX;transport=TCP"/>#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'
> Sep 28 11:46:25 km1 kamailio_presence[10037]: ERROR: <core>
> [db_query.c:339]: db_do_update(): error while submitting query
> Sep 28 11:46:25 km1 kamailio_presence[10037]: ERROR: db_postgres
> [km_dbase.c:580]: db_postgres_store_result(): invalid query,
> execution aborted
> 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.
> Sep 28 11:46:25 km1 kamailio_presence[10037]: WARNING: db_postgres
> [km_dbase.c:690]: db_postgres_update(): unexpected result returned
> Sep 28 11:46:25 km1 kamailio_presence[10037]: ERROR: presence
> [presentity.c:1324]: mark_presentity_for_delete(): unsuccessful
> sql update operation
> Sep 28 11:46:25 km1 kamailio_presence[10037]: ERROR: presence
> [publish.c:169]: msg_presentity_clean(): Marking presentity
> 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)
> 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]
> 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="sip:5678*012 at XXX.XXX.XX.XXX">#012 <dialog
> id="CLaNCoBMpzbMBIZ6wPvEFw.." call-id="CLaNCoBMpzbMBIZ6wPvEFw.."
> direction="recipient">#012 <state>terminated</state>#012
> <remote>#012
> <identity>sip:5678*002 at XXX.XXX.XX.XXX;transport=TCP</identity>#012
> <target
> uri="sip:5678*002 at 192.168.1.20:63157;transport=tcp;alias=XXX.XXX.XX.XXX~49663~2"/>#012
> </remote>#012 <local>#012
> <identity>sip:5678*012 at XXX.XXX.XX.XXX;transport=TCP</identity>#012
> <target uri="sip:5678*012 at XXX.XXX.XX.XXX;transport=TCP"/>#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'
> Sep 28 11:47:05 km1 kamailio_presence[10037]: ERROR: <core>
> [db_query.c:339]: db_do_update(): error while submitting query
> Sep 28 11:47:05 km1 kamailio_presence[10037]: ERROR: db_postgres
> [km_dbase.c:580]: db_postgres_store_result(): invalid query,
> execution aborted
> 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.
> Sep 28 11:47:05 km1 kamailio_presence[10037]: WARNING: db_postgres
> [km_dbase.c:690]: db_postgres_update(): unexpected result returned
> Sep 28 11:47:05 km1 kamailio_presence[10037]: ERROR: presence
> [presentity.c:1324]: mark_presentity_for_delete(): unsuccessful
> sql update operation
> Sep 28 11:47:05 km1 kamailio_presence[10037]: ERROR: presence
> [publish.c:169]: msg_presentity_clean(): Marking presentity
>
>
>
>
> On Fri, Sep 11, 2015 at 1:16 PM, Daniel-Constantin Mierla
> <miconda at gmail.com <mailto:miconda at gmail.com>> wrote:
>
> Hello,
>
> I will adjust the tutorial to make the note about PUBLISH
> looping back and need to authorize it by IP check.
>
> Regarding "db_mode", are you referring to "subs_db_mode"
> parameter?
>
> Cheers,
> Daniel
>
>
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Book: SIP Routing With Kamailio - http://www.asipto.com
Kamailio Advanced Training, Sep 28-30, 2015, in Berlin - http://asipto.com/u/kat
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20150930/3b292f93/attachment.html>
More information about the sr-users
mailing list