Bugs item #3374156, was opened at 2011-07-21 22:30
Message generated for change (Comment added) made by razvancrainea
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=3374156&group_id=232389
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: modules
Group: trunk
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: rrevels (ryanrevels)
Assigned to: Razvan Crainea (razvancrainea)
Summary: CDR corrupted if OpenSIPS restarts
Initial Comment:
Newest SVN of 1.7.0
If dialog is established, then Opensips is restarted while the dialog is still
active, the resulting CDR is invalid; it appears the callid,sip_code, and
sip_reason fields are all smashed into the to-tag column. Also, the duration is
incorrect. Below is an example:
+----+--------+----------------------------------+----------------------------------------------------------------------------------------------------------------------------------+--------+----------+------------+---------------------+-----------+
| id | method | from_tag | to_tag
| callid | sip_code | sip_reason | time |
duration |
+----+--------+----------------------------------+----------------------------------------------------------------------------------------------------------------------------------+--------+----------+------------+---------------------+-----------+
| 7 | INVITE | e13c394aac0b60f92b08a0ab25a6d4fc |
2566988-0-13c4-bce26-26058a7d-bce26 did2.1166.7299147 200 O (t(N ###
sip:9127587486@184.106.2 | | | |
0000-00-00 00:00:00 | 817046729 |
+----+--------+----------------------------------+----------------------------------------------------------------------------------------------------------------------------------+--------+----------+------------+---------------------+-----------+
----------------------------------------------------------------------
>Comment By: Razvan Crainea (razvancrainea)
Date: 2011-08-04 18:29
Message:
Hi Ryan,
Please check again with trunk rev #8212. I missed something in the first
commit.
Regards,
Razvan
----------------------------------------------------------------------
Comment By: rrevels (ryanrevels)
Date: 2011-08-04 18:13
Message:
Razvan,
No problem.
Instead of this:
| 269 | INVITE | 256b898-0-13c4-1e01c3-79c3d1c1-1e01c3 | did2.3629.3505 |
25833c0-0-13c4-1e01c3-1585a710-1e0...@st2.stsip.net | 200 | OK | 2011-08-04
14:08:20 | 172 | 2 | 2011-08-04 14:08:18 |
sip:19494888...@st2.stsip.net:5060;transport=UDP | 19494888938 |
sip:9127587...@st2.stsip.net:5060 | From | 19494888938 |
sip:10020\#19127587486@50.56.76.81:506 | 19127587486 64.244.179.229
123456-987654 2 out #### ####
#,#] ###] # #### #### ####
| | | | | | |
| |
It should have been:
| 269 | INVITE | 256b898-0-13c4-1e01c3-79c3d1c1-1e01c3 | did2.3629.3505 |
25833c0-0-13c4-1e01c3-1585a710-1e0...@st2.stsip.net | 200 | OK | 2011-08-04
14:08:20 | 172 | 2 | 2011-08-04 14:08:18 |
sip:19494888...@st2.stsip.net:5060;transport=UDP | 19494888938 |
sip:9127587...@st2.stsip.net:5060 | From | 19494888938 |
sip:10020#19127587486@50.56.76.81:5060 | 19127587486 | |
64.244.179.229 | 50.56.76.81 | 2011-08-04 14:08:18 | 2011-08-04 14:08:19 |
123456-987654 | 2 | out |
I hope that helps.
Thanks,
Ryan
----------------------------------------------------------------------
Comment By: Razvan Crainea (razvancrainea)
Date: 2011-08-04 17:39
Message:
Hi Ryan,
It would be interesting to see what were the correct values of each
field.
Thank you and regards,
Razvan
----------------------------------------------------------------------
Comment By: rrevels (ryanrevels)
Date: 2011-08-04 17:27
Message:
Razvan,
The default columns now populate correctly, but now my extra columns
(db_extra) are mangled. I'm adding 15 extra columns & the mangling begins
on the 6th.
Here is an example:
+-----+--------+---------------------------------------+----------------+-----------------------------------------------------+----------+------------+---------------------+----------+-----------+---------------------+--------------------------------------------------+-------------+-----------------------------------+--------------+-------------+----------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+---------+-------+----------+----------+--------+---------+-----------+
| id | method | from_tag | to_tag |
callid | sip_code | sip_reason
| time | duration | setuptime | created |
from_uri | from_user | to_uri
| bill_num_hdr | bill_num | req_uri
| dialed_num
| fwd_num | cust_ip | sv_ip
| time_inv | time_pdd | custid | trunkid | direction |
+-----+--------+---------------------------------------+----------------+-----------------------------------------------------+----------+------------+---------------------+----------+-----------+---------------------+--------------------------------------------------+-------------+-----------------------------------+--------------+-------------+----------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+---------+-------+----------+----------+--------+---------+-----------+
| 269 | INVITE | 256b898-0-13c4-1e01c3-79c3d1c1-1e01c3 | did2.3629.3505 |
25833c0-0-13c4-1e01c3-1585a710-1e0...@st2.stsip.net | 200 | OK
| 2011-08-04 14:08:20 | 172 | 2 | 2011-08-04 14:08:18 |
sip:19414888...@st2.stsip.net:5060;transport=UDP | 19494888938 |
sip:5127587...@st2.stsip.net:5060 | From | 19494888938 |
sip:10020\#19127587486@50.56.76.81:506 | 19127587486 64.244.179.229
123456-987654 2 out #### ####
#,#] ###] # #### #### ####
| | | | | | |
| |
+-----+--------+---------------------------------------+----------------+-----------------------------------------------------+----------+------------+---------------------+----------+-----------+---------------------+--------------------------------------------------+-------------+-----------------------------------+--------------+-------------+----------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+---------+-------+----------+----------+--------+---------+-----------+
Please let me know what additional details I can provide to help you
narrow down the issue.
Thanks,
Ryan
----------------------------------------------------------------------
Comment By: Razvan Crainea (razvancrainea)
Date: 2011-08-04 16:25
Message:
Hi Ryan,
I have commited a fix on svn trunk, rev 8209, that should solve this
problem. Please update your code, recompile the dialog module, and try
again. Also inform us about your results.
Thanks and regards,
Razvan
----------------------------------------------------------------------
Comment By: Razvan Crainea (razvancrainea)
Date: 2011-08-04 16:25
Message:
Hi Ryan,
I have commited a fix on svn trunk, rev 8209, that should solve this
problem. Please update your code, recompile the dialog module, and try
again. Also inform us about your results.
Thanks and regards,
Razvan
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=3374156&group_id=232389
_______________________________________________
Devel mailing list
Devel@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
