Need advice on multiple VICIDIAL server environment

[caspar]

agiout.2007-05-02:
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi|Perl Environment Dump:
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi|0|CLOSER1---------------park----------999-----00
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi| -- accountcode =
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi| -- callerid = unknown
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi| -- calleridname = unknown
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi| -- callingani2 = 0
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi| -- callingpres = 35
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi| -- callingtns = 0
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi| -- callington = 0
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi| -- channel = Zap/2-1
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi| -- context = default
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi| -- dnid = 9595
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi| -- enhanced = 0.0
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi| -- extension = 1234
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi| -- language = en
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi| -- priority = 2
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi| -- rdnis = unknown
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi| -- request = agi-VDAD_LO_closer_inbound.agi
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi| -- type = Zap
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi| -- uniqueid = 1178108503.3558
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi|AGI Variables: |1178108503.3558|Zap/2-1|1234|Zap||
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi|interrupt_digit |0|
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi|digit |3| TotalDTMF |3|
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi|digit |1| TotalDTMF |31|
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi|digit |4| TotalDTMF |314|
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi|digit |1| TotalDTMF |3141|
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi|digit || TotalDTMF |3141|
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi|+++++ INBOUND CALL VDCL STARTED : |CLOSER1|-3141|2007-05-02 14:21:43
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi||select LAST_INSERT_ID() LIMIT 1;|401|
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi|callerID changed: Y0502142143000000401
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi||INSERT INTO vicidial_auto_calls (server_ip,campaign_id,status,lead_id,uniqueid,callerid,channel,phone_code,phone_number,call_time,call_type,stage) values('196.37.34.216','CLOSER1','LIVE','401','1178108503.3558','Y0502142143000000401','Zap/2-1','00','','2007-05-02 14:21:43','IN','LIVE-0')|
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi||INSERT INTO vicidial_log (uniqueid,lead_id,campaign_id,call_date,start_epoch,status,phone_code,phone_number,user,processed) values('1178108503.3558','401','CLOSER1','2007-05-02 14:21:43','1178108503','XFER','00','','3141','N')|
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi|-- VDAD : |401|3141|insert to vicidial_log: 1178108503.3558
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi||INSERT INTO vicidial_closer_log (lead_id,campaign_id,call_date,start_epoch,status,phone_code,phone_number,user,processed) values('401','CLOSER1','2007-05-02 14:21:43','1178108503','QUEUE','00','','VDCL','N')|
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi|-- VDCL : |401|insert to vicidial_closer_log
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi||INSERT INTO vicidial_xfer_log (lead_id,campaign_id,call_date,phone_code,phone_number,user,closer) values('401','CLOSER1','2007-05-02 14:21:43','00','','3141','VDXL')|
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi|-- VDXL : |401|insert to vicidial_xfer_log
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='196.37.34.216' and campaign_id = 'CLOSER1' and call_time < "2007-05-02 14:21:43" and lead_id != '401';|
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi|-- VDAD get agent: |0E0|CLOSER1|UPDATE vicidial_live_agents set status='QUEUE',lead_id='401',uniqueid='1178108503.3558', channel='Zap/2-1', callerid='Y0502142143000000401' where status IN('CLOSER','READY') and server_ip='196.37.34.216' and campaign_id LIKE "%CLOSER%" and closer_campaigns LIKE "% CLOSER1 %" and last_update_time > '19700101015955' order by random_id limit 1;|
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi|NNNNN No available agent found
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip!='196.37.34.216' and campaign_id = 'CLOSER1' and call_time < "2007-05-02 14:21:43" and lead_id != '401';|
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi|-- VDAD get agent: |360|0|1|update of vla table: CLOSER1|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='401',uniqueid='1178108503.3558', channel='Zap/2-1', callerid='Y0502142143000000401', call_server_ip='196.37.34.216' where status IN('CLOSER','READY') and server_ip!='196.37.34.216' and campaign_id LIKE "%CLOSER%" and closer_campaigns LIKE "% CLOSER1 %" and last_update_time > '19700101015955' order by random_id limit 1;|
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi||SELECT conf_exten,user,extension,server_ip FROM vicidial_live_agents where status = 'QUEUE' and server_ip!='196.37.34.216' and campaign_id LIKE "%CLOSER%" and callerid='Y0502142143000000401' and channel='Zap/2-1' order by last_call_time limit 1;|
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi|-- VDCL XFER REMOTE: |1|update of vac table: Y0502142143000000401
|UPDATE vicidial_auto_calls set status='CLOSER', stage='CLOSER-0' where callerid='Y0502142143000000401';|
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi|-- VDXL vicidial_xfer_log update: |1|401|admin
|UPDATE vicidial_xfer_log set closer='admin' where lead_id = '401' order by call_date desc limit 1;|
2007-05-02 14:21:43|agi-VDAD_LO_closer_inbound.agi|-- closer log : |1|update of vcl table: 401
|UPDATE vicidial_closer_log set user='admin' where lead_id='401' order by call_date desc limit 1;|

action_full.2007-05-02:
2007-05-02 14:22:33|0|1|
Action: Hangup
Channel: Zap/3-1

|
2007-05-02 14:22:33|1||Response: Error
Message: No such channel

|
2007-05-02 14:22:33|2||Response: Goodbye
Message: Thanks for all the fish.

|

Both servers are still time sync.

[caspar]

I have upgraded now to VICIDIAL 2.0.3, but I am still experiencing the same problems.