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/1234567890@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@xxx.xxx.xxx.xxx 2008-11-23 17:40:26 [DEBUG] sofia.c:2129 sofia_handle_sip_i_state() Channel sofia/internal/1234567890@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@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@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.???
_______________________________________________ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org 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.