Hi again, I would like to share an idea to solve the problem of this delay: First, Create an script (php etc), which insert all the CDR data to mysql database,
then i call that script using system command passing all CDR values, with use of `screen` command, so that `screen` (runs in background) performs database entry, and without waiting, our javascript can continue and exit, thus ends the call. Is it advisable or not? or any other idea? Thanks, msp Michael Jerris wrote: > > 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 > > -- View this message in context: http://www.nabble.com/False-call-running-so-long..-tp20678102p20702663.html Sent from the Freeswitch-users mailing list archive at Nabble.com. _______________________________________________ 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
