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

[shehzad p]

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 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.???
> 
> _______________________________________________
> Freeswitch-users mailing list
> Freeswitch-users at 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.