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/[EMAIL PROTECTED] > 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/[EMAIL PROTECTED] > 2008-11-23 17:40:26 [DEBUG] sofia.c:2129 sofia_handle_sip_i_state() > Channel > sofia/internal/[EMAIL PROTECTED] entering state [terminated] > 2008-11-23 17:40:26 [NOTICE] sofia.c:2545 sofia_handle_sip_i_state() > Hangup > sofia/internal/[EMAIL PROTECTED] [CS_EXECUTE] > [ORIGINATOR_CANCEL] > > ...... ....... ..... > > 2008-11-23 23:14:20 [DEBUG] switch_ivr_bridge.c:353 > audio_bridge_thread() > BRIDGE THREAD DONE [sofia/internal/[EMAIL PROTECTED] > ....... > 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.??? _______________________________________________ Freeswitch-users mailing list [email protected] http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
