<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi Bou,<br>
<br>
You are right, those columns were added this year and the schema
was not updated in the cassandra file also. I have committed the
fix for that file.<br>
I will investigate also why it crashed in this case, as it
shouldn't crash in any case.<br>
<br>
Thanks and regards,<br>
Anca Vamanu<br>
<br>
<br>
On 08/24/2012 09:07 PM, Boudewyn Ligthart wrote:<br>
</div>
<blockquote
cite="mid:D8261FE064C78B44B77EF7C4569D6CBF0D11DDC3@DB3PRD0510MB380.eurprd05.prod.outlook.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<meta name="Generator" content="Microsoft Word 14 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
mso-fareast-language:EN-US;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span
style="color:black;mso-fareast-language:EN-GB">An update on
this issue:<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="color:black;mso-fareast-language:EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="color:black;mso-fareast-language:EN-GB">The schema
that is used by the cassandra module seems to be missing a
few fields, the correct schema for location should be:<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="color:black;mso-fareast-language:EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="color:black;mso-fareast-language:EN-GB">*************************<o:p></o:p></span></p>
<p class="MsoNormal"><i><span
style="font-size:10.0pt;color:black;mso-fareast-language:EN-GB">callid(string)
cflags(int) contact(string) cseq(int) expires(timestamp)
flags(int) last_modified(int) methods(int) path(string)
q(double) received(string) socket(string)
user_agent(string) username(string) ruid(string)
instance(string)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span
style="font-size:10.0pt;color:black;mso-fareast-language:EN-GB">username<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span
style="font-size:10.0pt;color:black;mso-fareast-language:EN-GB">contact<o:p></o:p></span></i></p>
<p class="MsoNormal"><span
style="color:black;mso-fareast-language:EN-GB">*************************<o:p></o:p></span></p>
<p class="MsoNormal"><i><span
style="font-size:10.0pt;color:black;mso-fareast-language:EN-GB"><o:p> </o:p></span></i></p>
<p class="MsoNormal"><span
style="color:black;mso-fareast-language:EN-GB">The two
fields : ruid and instance where missing, please append the
documentation. (utils/kamctl/dbcassandra/openser/location)<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="color:black;mso-fareast-language:EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="color:black;mso-fareast-language:EN-GB">Thanks,<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="color:black;mso-fareast-language:EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="color:black;mso-fareast-language:EN-GB">Bou<o:p></o:p></span></p>
<p class="MsoNormal"><b><span
style="color:black;mso-fareast-language:EN-GB"><o:p> </o:p></span></b></p>
<p class="MsoNormal"><b><span
style="color:black;mso-fareast-language:EN-GB"><br>
<br>
</span></b><span style="color:#1F497D"><o:p></o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:EN-GB"
lang="EN-US">From:</span></b><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:EN-GB"
lang="EN-US"> <a class="moz-txt-link-abbreviated" href="mailto:sr-users-bounces@lists.sip-router.org">sr-users-bounces@lists.sip-router.org</a>
[<a class="moz-txt-link-freetext" href="mailto:sr-users-bounces@lists.sip-router.org">mailto:sr-users-bounces@lists.sip-router.org</a>] <b>On
Behalf Of </b>Boudewyn Ligthart<br>
<b>Sent:</b> 22 August 2012 16:34<br>
<b>To:</b> <a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
<b>Subject:</b> [SR-Users] Kamailio Crash using
Cassandra 1.1.2 during SIP unregister<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hi,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Kamailio crash using Cassandra 1.1.2 during
SIP unregister (registering works fine)<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The version of Kamailio is the latest GIT
version:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">version:
kamailio 3.4.0-dev3 (x86_64/linux) 10327c<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">flags:
STATS: Off, USE_IPV6, USE_TCP, USE_TLS, TLS_HOOKS,
USE_RAW_SOCKS, DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK,
SHM_MEM, SHM_MMAP, PKG_MALLOC, F_MALLOC, USE_FUTEX,
FAST_LOCK-ADAPTIVE_WAIT, USE_DNS_CACHE, USE_DNS_FAILOVER,
USE_NAPTR, USE_DST_BLACKLIST, HAVE_RESOLV_RES<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">ADAPTIVE_WAIT_LOOPS=1024,
MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16, MAX_URI_SIZE
1024, BUF_SIZE 65535, DEFAULT PKG_SIZE 4MB<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">poll
method support: poll, epoll_lt, epoll_et, sigio_rt,
select.<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">id:
10327c<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">compiled
on 14:53:11 Aug 22 2012 with gcc 4.6.3<o:p></o:p></span></i></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">BT of Core :<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">Using
host libthread_db library
"/lib/x86_64-linux-gnu/libthread_db.so.1".<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">Core was
generated by `kamailio -ddddd'.<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">Program
terminated with signal 11, Segmentation fault.<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">#0
fm_free (qm=0x7fa55daf7010, p=0xd22317971716b6a) at
mem/f_malloc.c:527<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">527
if(unlikely(f->u.nxt_free!=NULL)) {<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">(gdb) bt<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">#0
fm_free (qm=0x7fa55daf7010, p=0xd22317971716b6a) at
mem/f_malloc.c:527<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">#1
0x00007fa55d35ac53 in db_free_columns (_r=0x7fa55db38c30)
at db_res.c:86<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">#2
0x00007fa55d83f87d in db_cassa_query (_h=<optimized
out>, _k=0x7fa55adc6aac, _op=<optimized out>,
_v=<optimized out>, _c=0x7fff72ef0e30,
_n=<optimized out>,<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">
_nc=16, _o=0x7fa55afca990, _r=0x7fff72ef0f10) at
dbcassa_base.cpp:659<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">#3
0x00007fa55adb58eb in db_load_urecord (_c=0x7fa55db218d0,
_d=0x7fa5576eee38, _aor=0x7fff72ef11b0) at udomain.c:592<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">#4
0x00007fa55adb93cd in get_urecord (_d=<optimized
out>, _aor=0x7fff72ef11b0, _r=0x7fff72ef1200) at
udomain.c:1017<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">#5
0x00007fa55ab91698 in lookup (_m=0x7fa55db40c48,
_d=0x7fa5576eee38, _uri=<optimized out>) at
lookup.c:156<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">#6
0x00007fa55ab957f2 in w_lookup (_m=0x7fa55db40c48,
_d=0x7fa5576eee38 "\350\355nW\245\177", _uri=<optimized
out>) at reg_mod.c:437<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">#7
0x000000000041c624 in do_action (h=0x7fff72ef17f0,
a=0x7fa55db23098, msg=0x7fa55db40c48) at action.c:1153<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">#8
0x000000000041b493 in run_actions (h=0x7fff72ef17f0,
a=0x7fa55db23098, msg=0x7fa55db40c48) at action.c:1646<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">#9
0x0000000000423a24 in run_actions_safe (h=<optimized
out>, a=<optimized out>, msg=<optimized
out>) at action.c:1710<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">#10
0x00000000004d79a0 in rval_get_int (h=0x7fff72ef2790,
msg=<optimized out>, i=0x7fff72ef1c30,
rv=<optimized out>, cache=<optimized out>) at
rvalue.c:920<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">#11
0x00000000004dc82c in rval_expr_eval_int
(h=0x7fff72ef2790, msg=0x7fa55db40c48, res=0x7fff72ef1c30,
rve=0x7fa55db23218) at rvalue.c:1914<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">#12
0x00000000004dc8f9 in rval_expr_eval_int
(h=0x7fff72ef2790, msg=0x7fa55db40c48, res=0x7fff72ef20d0,
rve=0x7fa55db238e8) at rvalue.c:1922<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">#13
0x000000000041cb66 in do_action (h=0x7fff72ef2790,
a=0x7fa55db26d38, msg=0x7fa55db40c48) at action.c:1123<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">#14
0x000000000041b493 in run_actions (h=0x7fff72ef2790,
a=0x7fa55db26d38, msg=0x7fa55db40c48) at action.c:1646<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">#15
0x000000000041c7e1 in do_action (h=0x7fff72ef2790,
a=0x7fa55db15b38, msg=0x7fa55db40c48) at action.c:763<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">#16
0x000000000041b493 in run_actions (h=0x7fff72ef2790,
a=0x7fa55db118c8, msg=0x7fa55db40c48) at action.c:1646<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">#17
0x0000000000423ab0 in run_top_route (a=0x7fa55db118c8,
msg=0x7fa55db40c48, c=<optimized out>) at
action.c:1731<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">#18
0x00000000004b39ee in receive_msg (buf=<optimized
out>, len=<optimized out>, rcv_info=<optimized
out>) at receive.c:209<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">#19
0x000000000054de1a in udp_rcv_loop () at udp_server.c:544<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">#20
0x0000000000478879 in main_loop () at main.c:1635<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">#21
0x000000000041b002 in main (argc=<optimized out>,
argv=<optimized out>) at main.c:2548<o:p></o:p></span></i></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Bou<o:p></o:p></p>
</div>
</blockquote>
<br>
<br>
</body>
</html>