<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi, Jayesh!<br>
<br>
It seems like the problem appears while parsing the string got from
the database, so after opensips is restarted. The patch attached
should give us more information about the error.<br>
<br>
Regards,<br>
<pre class="moz-signature" cols="72">--
Răzvan Crainea
OpenSIPS Developer</pre>
<br>
On 12/07/2011 12:37 PM, Jayesh Nambiar wrote:
<blockquote
cite="mid:CALvF6vBMUF23CVQ+ki2yWamxw568k8zpefz-YoK5tohyGOPR5Q@mail.gmail.com"
type="cite">This is the string what I see when I query the dialog
table for vars:<br>
<br>
accX_flags# |accX_db#( 2 1<br>
1000000001 1002<br>
12013386166<br>
919833171405 0 203.153.53.158 203.153.53.136 0 17 0 2 IP India -
Mobile 919 9198 2 1 2 4 0.0150 0.0130 0 0.0000 0.0226 1.0000 6 1 6
1 1 2 2 2<br>
Aal Izz Well<br>
Aal Izz Well 1 3 1.2.3.4|accX_leg# |accX_core# INVITE/
100eb870-9e3599cb-13c4-50029-3b71-60de50d0-3b71\#
97.208.30.751120+1+31850054+b8c0a68/
100f7670-9e3599cb-13c4-50029-3b71-3c625412-3b71 200 O á=ÃN
|accX_created#Ã=ÃN |<br>
<br>
--- Jayesh<br>
<br>
<div class="gmail_quote">On Wed, Dec 7, 2011 at 4:00 PM, Razvan
Crainea <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:razvancrainea@opensips.org">razvancrainea@opensips.org</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div bgcolor="#FFFFFF" text="#000000"> Hi, Jayesh!<br>
<br>
And what is the string in the database? You can see it in
the database after you kill opensips with the following
command:<br>
<br>
<tt>select vars from dialog;</tt>
<div class="im"><br>
<br>
Regards,<br>
<pre cols="72">--
Răzvan Crainea
OpenSIPS Developer</pre>
<br>
</div>
<div>
<div class="h5"> On 12/07/2011 12:24 PM, Jayesh Nambiar
wrote:
<blockquote type="cite">Hi Razvan,<br>
Applied the patch and re-tested it. Here the logs that
you are interested in specifically:<br>
<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: Dumping var name:
<accX_flags> value: <#026><br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: compare char 22 - 0 - 11<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: compare char 0 - 1 - 12<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: compare char 0 - 2 - 13<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: compare char 0 - 3 - 14<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: Serialized string
<accX_flags##026> (16)<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 0) char: a hex: 61<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 1) char: c hex: 63<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 2) char: c hex: 63<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 3) char: X hex: 58<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 4) char: _ hex: 5F<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 5) char: f hex: 66<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 6) char: l hex: 6C<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 7) char: a hex: 61<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 8) char: g hex: 67<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 9) char: s hex: 73<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 10) char: # hex: 23<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 11) char: #026 hex: 16<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 12) char: #000 hex: 00<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 13) char: #000 hex: 00<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 14) char: #000 hex: 00<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: 15) char: | hex: 7C<br>
Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]:
DBG:dialog:write_pair: Dumping var name:
<accX_db> value: <(><br>
<br>
Apart from this, I have pasted everything in syslog
after opensips shutdown in the paste-bin here:<br>
<a moz-do-not-send="true"
href="http://pastebin.com/gx0ZxFLb" target="_blank">http://pastebin.com/gx0ZxFLb</a><br>
<br>
Let me know if there is anything more to test.<br>
<br>
--- Jayesh<br>
<br>
<div class="gmail_quote">On Wed, Dec 7, 2011 at 3:36
PM, Razvan Crainea <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:razvancrainea@opensips.org"
target="_blank">razvancrainea@opensips.org</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> Sorr, I
forgot to attach it. Here it is.
<div><br>
<br>
Regards,<br>
<pre cols="72">--
Răzvan Crainea
OpenSIPS Developer</pre>
<br>
</div>
<div>
<div> On 12/07/2011 11:59 AM, Jayesh Nambiar
wrote:
<blockquote type="cite">Hi Razvan,<br>
I don't see the patch attached !!<br>
<br>
--- Jayesh<br>
<br>
<div class="gmail_quote">On Wed, Dec 7,
2011 at 2:57 PM, Razvan Crainea <span
dir="ltr"><<a
moz-do-not-send="true"
href="mailto:razvancrainea@opensips.org"
target="_blank">razvancrainea@opensips.org</a>></span>
wrote:<br>
<blockquote class="gmail_quote"
style="margin:0 0 0
.8ex;border-left:1px #ccc
solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
Hi, Jayesh !<br>
<br>
The root of the problem is the
accX_flags dialog variable isn't
properly serialized. What I'm trying
to find out is why this happens,
that's why I will need some extra
debug as I can't figure out the
problem there. So please apply this
last patch and try again. It should
be applied after the previous patch
I've sent you, so you won't need
another fresh checkout.<br>
This time there will be a lot of
dumped info in the log, so I would
really appreciate if you could send
them over pastebin. The only part
that I will be interested in is
between these lines:
<div><br>
<br>
<tt>DBG:dialog:write_pair: Dumping
var name: <accX_flags>
value: <#026></tt><br>
<br>
</div>
and
<div><br>
<br>
<tt>DBG:dialog:write_pair: Dumping
var name: <accX_db> value:
<(></tt><br>
<br>
</div>
Thank you very much for testing! <br>
<div> Regards,<br>
<pre cols="72">--
Răzvan Crainea
OpenSIPS Developer</pre>
<br>
</div>
<div>
<div> On 12/06/2011 07:57 PM,
Jayesh Nambiar wrote:
<blockquote type="cite">Hi
Razvan,<br>
I just did a fresh download
from <a
moz-do-not-send="true"
href="http://opensips.org/pub/opensips/latest/src/"
target="_blank">http://opensips.org/pub/opensips/latest/src/</a>.
I did apply the patch
successfully and I still have
the problem of CDR not being
recorded after restart. Here
is the syslog pasted after
opensips was being shut down:<br>
<br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[
<div>15700]:
DBG:dialog:dialog_update_db:
inserting new dialog
0x7f3d323bd5f8<br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair:
Dumping var name:
<accX_flags> value:
<#026><br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair:
Serialized string
<accX_flags##026> (16)<br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair:
Dumping var name:
<accX_db> value:
<(><br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair:
Serialized string
<accX_db#(> (263)<br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair:
Dumping var name:
<accX_leg> value:
<><br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair:
Serialized string
<accX_leg#> (14)<br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair:
Dumping var name:
<accX_core> value:
<#006><br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair:
escaping char 53<br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair:
Serialized string
<accX_core##006> (165)<br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair:
Dumping var name:
<accX_created> value:
<<95>+ÃN><br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair:
Serialized string
<accX_created#<95>+ÃN>
(22)<br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_dialog_vars:
var string is
<accX_flags##026>(480)<br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair:
Dumping var name:
<carrierChannels>
value: <1002><br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair:
Serialized string
<carrierChannels#1002|>
(21)<br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair:
Dumping var name:
<carrierChannels>
value: <1003><br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair:
Serialized string
<carrierChannels#1003|>
(21)<br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair:
Dumping var name:
<carrierChannels>
value: <1007><br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_pair:
Serialized string
<carrierChannels#1007|>
(21)<br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:dialog:write_dialog_profiles:
profile string is
<carrierChannels#1002|carrierChannels#1003|carrierChannels#1007|>(63)<br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:db_mysql:has_stmt_ctx:
ctx found for dialog<br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:db_mysql:db_mysql_do_prepared_query:
conn=0x810858 (tail=8454488)
MC=0x8101b8<br>
Dec 6 20:20:13 dev
/usr/local/sbin/opensips[15700]:
DBG:db_mysql:db_mysql_do_prepared_query:
set values for the statement
run<br>
<br>
I hope this will help you
figure out something more
relevant.
<div>
<div> <img
moz-do-not-send="true"
src="http://images/cleardot.gif"></div>
</div>
<span><font color="#888888"><br>
<br>
--- Jayesh</font></span>
<div>
<div><br>
<br>
<div class="gmail_quote">On
Tue, Dec 6, 2011 at
7:56 PM, Razvan
Crainea <span
dir="ltr"><<a
moz-do-not-send="true"
href="mailto:razvancrainea@opensips.org" target="_blank">razvancrainea@opensips.org</a>></span>
wrote:<br>
<blockquote
class="gmail_quote"
style="margin:0 0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex">
<div
bgcolor="#FFFFFF">
Hi, Jayesh!<br>
<br>
Can you post your
dlg_db_handler.c
file on pastebin?
I think you are
using an old
version of the
dialog module, and
that's why you
have this problem.
<div><br>
<br>
Regards,<br>
<pre cols="72">--
Răzvan Crainea
OpenSIPS Developer</pre>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</blockquote>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</blockquote>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</blockquote>
</body>
</html>