[OpenSIPS-Devel] [ opensips-Bugs-3374156 ] CDR corrupted if OpenSIPS restarts

SourceForge.net noreply at sourceforge.net
Thu Aug 4 17:46:05 CEST 2011


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: Closed
>Resolution: Fixed
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 at 184.106.2 |        |          |            | 0000-00-00 00:00:00 | 817046729 |
+----+--------+----------------------------------+----------------------------------------------------------------------------------------------------------------------------------+--------+----------+------------+---------------------+-----------+

----------------------------------------------------------------------

>Comment By: Razvan Crainea (razvancrainea)
Date: 2011-08-04 18:46

Message:
Ok, I'm closing this bug report now.

Thanks and regards,
Razvan

----------------------------------------------------------------------

Comment By: rrevels (ryanrevels)
Date: 2011-08-04 18:45

Message:
Yes, that works.
Thank you very much.

----------------------------------------------------------------------

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-1e01c3 at st2.stsip.net | 200 | OK | 2011-08-04
14:08:20 | 172 | 2 | 2011-08-04 14:08:18 |
sip:19494888938 at st2.stsip.net:5060;transport=UDP | 19494888938 |
sip:9127587486 at st2.stsip.net:5060 | From | 19494888938 |
sip:10020\#19127587486 at 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-1e01c3 at st2.stsip.net | 200 | OK | 2011-08-04
14:08:20 | 172 | 2 | 2011-08-04 14:08:18 |
sip:19494888938 at st2.stsip.net:5060;transport=UDP | 19494888938 |
sip:9127587486 at st2.stsip.net:5060 | From | 19494888938 |
sip:10020#19127587486 at 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-1e01c3 at st2.stsip.net | 200      | OK        
| 2011-08-04 14:08:20 |      172 |         2 | 2011-08-04 14:08:18 |
sip:19414888938 at st2.stsip.net:5060;transport=UDP | 19494888938 |
sip:5127587486 at st2.stsip.net:5060 | From         | 19494888938 |
sip:10020\#19127587486 at 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



More information about the Devel mailing list