[Freeswitch-users] False call running so long..

[Michael Jerris]

You have just shown exactly why cdr direct to database is a bad idea.   
Most likely there was a blip in connectivity to the db and it didn't  
reconnect correctly.  This behavior would be caused by some blocking  
in your script.

Mike

On Nov 25, 2008, at 4:55 AM, shehzad p wrote:

>
> I faced a strange behavior with my freeswitch...
> Freeswitch setup is as follows:
> Any call comes to freeswitch are sent to javascript, for routing  
> based on
> some logic.
> After call completes, the same script insert the CDR values into mysql
> database.
>
> All is working fine for quite long time,
> But when I was looking in freeswitch.log file for particular call,
> I found one CDR entry with big difference in time between the call
> terminated and time of its CDR inserted into database.
>
>
> The part of freeswitch.log is as follows:
> #############################################freeswitch 
> .log#####################################################
> 2008-11-23 17:40:26 [DEBUG] switch_core_state_machine.c:140
> switch_core_standard_on_execute() sofia/internal/1234567890 at xxx.xxx.xxx.xxx
> Execute javascript(softswitch/main.js)
>
> ...............
> 2008-11-23 17:40:26 [DEBUG] sofia.c:197 sofia_event_callback() event
> [nua_i_state] status [487][Request Terminated] session:
> sofia/internal/1234567890 at xxx.xxx.xxx.xxx
> 2008-11-23 17:40:26 [DEBUG] sofia.c:2129 sofia_handle_sip_i_state()  
> Channel
> sofia/internal/1234567890 at xxx.xxx.xxx.xxx entering state [terminated]
> 2008-11-23 17:40:26 [NOTICE] sofia.c:2545 sofia_handle_sip_i_state()  
> Hangup
> sofia/internal/1234567890 at xxx.xxx.xxx.xxx [CS_EXECUTE]  
> [ORIGINATOR_CANCEL]
>
> ......           .......      .....
>
> 2008-11-23 23:14:20 [DEBUG] switch_ivr_bridge.c:353  
> audio_bridge_thread()
> BRIDGE THREAD DONE [sofia/internal/1234567890 at xxx.xxx.xxx.xxx]
> .......
> 2008-11-23 23:14:20 [INFO] main.js:150 console_log() CDR Inserted
> 2008-11-23 23:14:20 [INFO] main.js:151 console_log() ***** start  
> date    :
> 2008-11-23 17:40:26
> 2008-11-23 23:14:20 [INFO] main.js:152 console_log() ***** caller  :
> 1234567890
> ################################################################################################################
>
> This means that time difference between the call terminated and its  
> CDR
> inserted is about 5.30 hours, which is too late.
> During this time it was also listing out in 'show calls' and 'show
> channels'.
>
> Any clue for such delay.???