I have a somewhat recent server setup I performed on a beasty 24 core setup per each server - web/DB/asterisk >
VERSION: 2.14-661a
BUILD: 180222-0017
it has been working for awhile now no issue except the past few months the system stops loading leads into the hopper. I've determined a few lists that this happens to and made sure there were no special characters, trailing slashes, hashtags, etc. and still the system will not load these leads into the hopper. All new, never called on, no call counts, no issues from what I can tell but the hopper refuses. This is an output today after clearing the 2 lists I mentioned, reloaded them fresh, and try running just them.
here is that output:
- Code: Select all
cbpasterisk:/usr/share/astguiclient # ./AST_VDhopper.pl --debugX
----- DEBUG -----
----- SUPER DEBUG -----
TIME DEBUG: -5.00|-4|1| GMT: 20:48
SELECT list_id FROM vicidial_lists where ( (active='N') or ( (active='Y') and (e xpiration_date < "2018-08-09") ) );Inactive Lists: 80
Inactive and Expired List Leads Deleted: 0E0 |DELETE from vicidial_hopper where list_id IN('999','998','444551002','6666667','6666668','88810001','88810002','8 8810003','211221001','444551001','450001001','650001001','88810004','65655100',' 444551003','544551001','544551002','88810005','88810006','78810001','88810007',' 211221002','88810008','211221003','450001002','444551004','88810009','888100010' ,'444551005','444551006','88810010','450001003','544551003','88810011','44455100 7','9981','450001004','444551008','450001005','444551009','55554444','450001007' ,'450001008','444551010','88810012','444551011','450001010','88810013','44455101 2','450001011','88810014','88810015','450001012','88810016','450001013','4445510 14','88810017','88810018','88810019','88810020','444551015','88810021','88810022 ','88810023','450001014','444551017','88810024','444551018','88810025','9944','7 50001001','450001016','450001017','450001018','450001019','450001020','450001021 ','88810026','88810027','450001023') ;|
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2018-08-09 16:48:08' and status='ACTIVE' ;|
hopper DNC count: 0
|SELECT count(*) from vicidial_hopper where status='DNC';|
---------------Auto Hopper Level Enabled For Access---------------------
Number of Agents = 13
Number of Paused Agents = 9
Auto Dial Level = 2.5
Dial Timeout = 35
Dial Timeout Multiplier = 1.71428571428571
Auto Hopper Multipier = 1
Minimum Hopper Level = 700
Auto Hopper Level Adjustment = 95
Final Hopper Level = 700
---------------Auto Hopper Level Enabled For close---------------------
Number of Agents = 0
Number of Paused Agents = 0
Auto Dial Level = 2.4
Dial Timeout = 35
Dial Timeout Multiplier = 1.71428571428571
Auto Hopper Multipier = 1
Minimum Hopper Level = 500
Auto Hopper Level Adjustment = 0
Final Hopper Level = 500
CAMPAIGNS TO PROCESSES HOPPER FOR: 2|1
VLC Dup Check Live Calls: 2|0|2
'2426636','2398215'|"550100","450100",
Starting hopper run for Access campaign- GMT: 9am-9pm HOPPER: 700 ORDER: RAN DOM|Y|LEAD_ASCEND
|GMT-DAY-HOUR| |13.00-5-948||12.75-5-933||12.50-5-918||12.25-5-903||12.00-5 -848||11.75-5-833||11.50-5-818||11.25-5-803||11.00-5-748||10.75-5-733||10.50-5-7 18||10.25-5-703||10.00-5-648||9.75-5-633||9.50-5-618||9.25-5-603||9.00-5-548||8. 75-5-533||8.50-5-518||8.25-5-503||8.00-5-448||7.75-5-433||7.50-5-418||7.25-5-403 ||7.00-5-348||6.75-5-333||6.50-5-318||6.25-5-303||6.00-5-248||5.75-5-233||5.50-5 -218||5.25-5-203||5.00-5-148||4.75-5-133||4.50-5-118||4.25-5-103||4.00-5-48||3.7 5-5-33||3.50-5-18||3.25-5-3||3.00-4-2348||2.75-4-2333||2.50-4-2318||2.25-4-2303| |2.00-4-2248||1.75-4-2233||1.50-4-2218||1.25-4-2203||1.00-4-2148||0.75-4-2133||0 .50-4-2118||0.25-4-2103||0.00-4-2048||-0.25-4-2033||-0.50-4-2018||-0.75-4-2003|| -1.00-4-1948||-1.25-4-1933||-1.50-4-1918||-1.75-4-1903||-2.00-4-1848||-2.25-4-18 33||-2.50-4-1818||-2.75-4-1803||-3.00-4-1748||-3.25-4-1733||-3.50-4-1718||-3.75- 4-1703||-4.00-4-1648||-4.25-4-1633||-4.50-4-1618||-4.75-4-1603||-5.00-4-1548||-5 .25-4-1533||-5.50-4-1518||-5.75-4-1503||-6.00-4-1448||-6.25-4-1433||-6.50-4-1418 ||-6.75-4-1403||-7.00-4-1348||-7.25-4-1333||-7.50-4-1318||-7.75-4-1303||-8.00-4- 1248||-8.25-4-1233||-8.50-4-1218||-8.75-4-1203||-9.00-4-1148||-9.25-4-1133||-9.5 0-4-1118||-9.75-4-1103||-10.00-4-1048||-10.25-4-1033||-10.50-4-1018||-10.75-4-10 03||-11.00-4-948||-11.25-4-933||-11.50-4-918||-11.75-4-903||-12.00-4-848||-12.25 -4-833||-12.50-4-818||-12.75-4-803|
|SELECT call_time_id,call_time_name,call_time_comments,ct_default_start,ct_de fault_stop,ct_sunday_start,ct_sunday_stop,ct_monday_start,ct_monday_stop,ct_tues day_start,ct_tuesday_stop,ct_wednesday_start,ct_wednesday_stop,ct_thursday_start ,ct_thursday_stop,ct_friday_start,ct_friday_stop,ct_saturday_start,ct_saturday_s top,ct_state_call_times,ct_holidays FROM vicidial_call_times where call_time_id= '9am-9pm';|
LocalCallTime No-Call Gap: |43200|2100(21 00)|0900(09 00)|4|3|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='Access' and status ='READY';|
Processing GMT for list 444551002
Processing GMT for list 6666667
Processing GMT for list 6666668
Processing GMT for list 88810001
Processing GMT for list 88810002
Processing GMT for list 88810003
Processing GMT for list 211221001
Processing GMT for list 444551001
Processing GMT for list 450001001
Processing GMT for list 650001001
Processing GMT for list 88810004
Processing GMT for list 65655100
Processing GMT for list 444551003
Processing GMT for list 544551001
Processing GMT for list 544551002
Processing GMT for list 88810005
Processing GMT for list 88810006
Processing GMT for list 78810001
Processing GMT for list 88810007
Processing GMT for list 211221002
Processing GMT for list 88810008
Processing GMT for list 211221003
Processing GMT for list 450001002
Processing GMT for list 444551004
Processing GMT for list 88810009
Processing GMT for list 888100010
Processing GMT for list 444551005
Processing GMT for list 444551006
Processing GMT for list 88810010
Processing GMT for list 450001003
Processing GMT for list 544551003
Processing GMT for list 88810011
Processing GMT for list 444551007
Processing GMT for list 9981
Processing GMT for list 450001004
Processing GMT for list 444551008
Processing GMT for list 450001005
Processing GMT for list 444551009
Processing GMT for list 55554444
Processing GMT for list 450001007
Processing GMT for list 450001008
Processing GMT for list 444551010
Processing GMT for list 88810012
Processing GMT for list 444551011
Processing GMT for list 450001010
Processing GMT for list 88810013
Processing GMT for list 444551012
Processing GMT for list 450001011
Processing GMT for list 88810014
Processing GMT for list 88810015
Processing GMT for list 450001012
Processing GMT for list 88810016
Processing GMT for list 450001013
Processing GMT for list 444551014
Processing GMT for list 88810017
Processing GMT for list 88810018
Processing GMT for list 88810019
Processing GMT for list 88810020
Processing GMT for list 444551015
Processing GMT for list 88810021
Processing GMT for list 88810022
Processing GMT for list 88810023
Processing GMT for list 450001014
Processing GMT for list 444551017
Processing GMT for list 88810024
Processing GMT for list 444551018
Processing GMT for list 88810025
Processing GMT for list 9944
Processing GMT for list 750001001
Processing GMT for list 450001016
Processing GMT for list 450001017
Processing GMT for list 450001018
Processing GMT for list 450001019
Processing GMT for list 450001020
Processing GMT for list 450001021
Processing GMT for list 88810026
Processing GMT for list 88810027
Processing GMT for list 450001023
Processing GMT for list 450001024
Processing GMT for list 550001001
campaign lists count ACTIVE:2 | TOTAL:80
LIST ID SQL (list_id IN('450001024','550001001')) |SELECT count(*) from vicidial_hopper where campaign_id='Access' and status='READY';|
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='Access' and status IN('DONE ');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where (campaign_id='Access' and ((gmt_offset_ now NOT IN('13.00','12.75','12.50','12.25','0.00','-0.25','-0.50','-0.75','-1.00 ','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50 ','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00 ','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50 ','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','- 11.00','-11.25','-11.50','-11.75','99') ) ));|
lead filter ALLOWEDSTATES defined for Access
|and (state IN('AZ', 'CO', 'CT', 'DC', 'FL', 'GA', 'HI', 'IN', 'IL', 'ID', 'MA', 'MD', 'MN', 'MO', 'ND', 'NH', 'NJ', 'NM', 'NY', 'OH', 'PA', 'SD', 'UT', 'V A', 'WA', 'WI', 'RI', 'NV', 'WY', 'DE', 'VT','MT', ''))|
|SELECT count(*) FROM vicidial_list FORCE INDEX(list_id) where called_since _last_reset='N' and status IN('DROP','ERI','NI','N','NA','B','AB','AA','A','NEW' ) and ((list_id IN('450001024','550001001'))) and ((gmt_offset_now IN('13.00','1 2.75','12.50','12.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1 .75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4 .25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6 .75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9 .25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11. 50','-11.75','99') ) ) and (state IN('AZ', 'CO', 'CT', 'DC', 'FL', 'GA', 'HI', ' IN', 'IL', 'ID', 'MA', 'MD', 'MN', 'MO', 'ND', 'NH', 'NJ', 'NM', 'NY', 'OH', 'PA ', 'SD', 'UT', 'VA', 'WA', 'WI', 'RI', 'NV', 'WY', 'DE', 'VT','MT', '')) ;|
leads to call count: 42230
|SELECT count(*) FROM vicidial_list FORCE INDEX(list_id) where called_since _last_reset='N' and status IN('DROP','ERI','NI','N','NA','B','AB','AA','A','NEW' ) and ((list_id IN('450001024','550001001'))) and ((gmt_offset_now IN('13.00','1 2.75','12.50','12.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1 .75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4 .25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6 .75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9 .25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11. 50','-11.75','99') ) ) and (state IN('AZ', 'CO', 'CT', 'DC', 'FL', 'GA', 'HI', ' IN', 'IL', 'ID', 'MA', 'MD', 'MN', 'MO', 'ND', 'NH', 'NJ', 'NM', 'NY', 'OH', 'PA ', 'SD', 'UT', 'VA', 'WA', 'WI', 'RI', 'NV', 'WY', 'DE', 'VT','MT', '')) ;|
NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER
CAMPAIGN STATS: 1|UPDATE vicidial_campaign_stats SET dialable_leads='42230' wher e campaign_id='Access';|
hopper too low (0|700) starting hopper dump
Getting Leads to add to hopper
|SELECT lead_id,vendor_lead_code FROM vicidial_hopper where campaign_id='Ac cess';|
NO RECYCLE-LEADS INTO HOPPER DEFINED
lead call order: order by RAND()
|SELECT lead_id,list_id,gmt_offset_now,phone_number,state,status,modify_dat e,user,vendor_lead_code FROM vicidial_list where called_since_last_reset='N' and status IN('DROP','ERI','NI','N','NA','B','AB','AA','A','NEW') and ((list_id IN( '450001024','550001001'))) and lead_id NOT IN('0') and vendor_lead_code NOT IN(" 550100","450100","--99999999987654321--") and ((gmt_offset_now IN('13.00','12.75 ','12.50','12.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75' ,'-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25' ,'-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75' ,'-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25' ,'-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50', '-11.75','99') ) ) and (state IN('AZ', 'CO', 'CT', 'DC', 'FL', 'GA', 'HI', 'IN', 'IL', 'ID', 'MA', 'MD', 'MN', 'MO', 'ND', 'NH', 'NJ', 'NM', 'NY', 'OH', 'PA', ' SD', 'UT', 'VA', 'WA', 'WI', 'RI', 'NV', 'WY', 'DE', 'VT','MT', '')) order by RAND() limit 700;|
Adding to hopper: 0
DONE with this campaign
VLC Dup Check Rejected: 0
Starting hopper run for close campaign- GMT: 9am-9pm HOPPER: 500 ORDER: RAND OM|Y|LEAD_ASCEND
|GMT-DAY-HOUR| |13.00-5-948||12.75-5-933||12.50-5-918||12.25-5-903||12.00-5 -848||11.75-5-833||11.50-5-818||11.25-5-803||11.00-5-748||10.75-5-733||10.50-5-7 18||10.25-5-703||10.00-5-648||9.75-5-633||9.50-5-618||9.25-5-603||9.00-5-548||8. 75-5-533||8.50-5-518||8.25-5-503||8.00-5-448||7.75-5-433||7.50-5-418||7.25-5-403 ||7.00-5-348||6.75-5-333||6.50-5-318||6.25-5-303||6.00-5-248||5.75-5-233||5.50-5 -218||5.25-5-203||5.00-5-148||4.75-5-133||4.50-5-118||4.25-5-103||4.00-5-48||3.7 5-5-33||3.50-5-18||3.25-5-3||3.00-4-2348||2.75-4-2333||2.50-4-2318||2.25-4-2303| |2.00-4-2248||1.75-4-2233||1.50-4-2218||1.25-4-2203||1.00-4-2148||0.75-4-2133||0 .50-4-2118||0.25-4-2103||0.00-4-2048||-0.25-4-2033||-0.50-4-2018||-0.75-4-2003|| -1.00-4-1948||-1.25-4-1933||-1.50-4-1918||-1.75-4-1903||-2.00-4-1848||-2.25-4-18 33||-2.50-4-1818||-2.75-4-1803||-3.00-4-1748||-3.25-4-1733||-3.50-4-1718||-3.75- 4-1703||-4.00-4-1648||-4.25-4-1633||-4.50-4-1618||-4.75-4-1603||-5.00-4-1548||-5 .25-4-1533||-5.50-4-1518||-5.75-4-1503||-6.00-4-1448||-6.25-4-1433||-6.50-4-1418 ||-6.75-4-1403||-7.00-4-1348||-7.25-4-1333||-7.50-4-1318||-7.75-4-1303||-8.00-4- 1248||-8.25-4-1233||-8.50-4-1218||-8.75-4-1203||-9.00-4-1148||-9.25-4-1133||-9.5 0-4-1118||-9.75-4-1103||-10.00-4-1048||-10.25-4-1033||-10.50-4-1018||-10.75-4-10 03||-11.00-4-948||-11.25-4-933||-11.50-4-918||-11.75-4-903||-12.00-4-848||-12.25 -4-833||-12.50-4-818||-12.75-4-803|
|SELECT call_time_id,call_time_name,call_time_comments,ct_default_start,ct_de fault_stop,ct_sunday_start,ct_sunday_stop,ct_monday_start,ct_monday_stop,ct_tues day_start,ct_tuesday_stop,ct_wednesday_start,ct_wednesday_stop,ct_thursday_start ,ct_thursday_stop,ct_friday_start,ct_friday_stop,ct_saturday_start,ct_saturday_s top,ct_state_call_times,ct_holidays FROM vicidial_call_times where call_time_id= '9am-9pm';|
LocalCallTime No-Call Gap: |43200|2100(21 00)|0900(09 00)|4|3|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='close' and status= 'READY';|
campaign lists count ACTIVE:0 | TOTAL:0
LIST ID SQL list_id='999876543210' |SELECT count(*) from vicidial_hoppe r where campaign_id='close' and status='READY';|
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='close' and status IN('DONE' );|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where (campaign_id='close' and ((gmt_offset_n ow NOT IN('13.00','12.75','12.50','12.25','0.00','-0.25','-0.50','-0.75','-1.00' ,'-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50' ,'-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00' ,'-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50' ,'-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-1 1.00','-11.25','-11.50','-11.75','99') ) ));|
lead filter ALLOWEDSTATES defined for close
|and (state IN('AZ', 'CO', 'CT', 'DC', 'FL', 'GA', 'HI', 'IN', 'IL', 'ID', 'MA', 'MD', 'MN', 'MO', 'ND', 'NH', 'NJ', 'NM', 'NY', 'OH', 'PA', 'SD', 'UT', 'V A', 'WA', 'WI', 'RI', 'NV', 'WY', 'DE', 'VT','MT', ''))|
call count limit 65 defined for close
|and (called_count < 65)|
|SELECT count(*) FROM vicidial_list FORCE INDEX(list_id) where called_since _last_reset='N' and status IN('B','AB','AA','A','NEW') and (list_id='99987654321 0') and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','0.00','-0.25','-0.5 0','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.0 0','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.5 0','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.0 0','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-1 0.50','-10.75','-11.00','-11.25','-11.50','-11.75','99') ) ) and (state IN('AZ', 'CO', 'CT', 'DC', 'FL', 'GA', 'HI', 'IN', 'IL', 'ID', 'MA', 'MD', 'MN', 'MO', ' ND', 'NH', 'NJ', 'NM', 'NY', 'OH', 'PA', 'SD', 'UT', 'VA', 'WA', 'WI', 'RI', 'NV ', 'WY', 'DE', 'VT','MT', '')) and (called_count < 65);|
leads to call count: 0
|SELECT count(*) FROM vicidial_list FORCE INDEX(list_id) where called_since _last_reset='N' and status IN('B','AB','AA','A','NEW') and (list_id='99987654321 0') and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','0.00','-0.25','-0.5 0','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.0 0','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.5 0','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.0 0','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-1 0.50','-10.75','-11.00','-11.25','-11.50','-11.75','99') ) ) and (state IN('AZ', 'CO', 'CT', 'DC', 'FL', 'GA', 'HI', 'IN', 'IL', 'ID', 'MA', 'MD', 'MN', 'MO', ' ND', 'NH', 'NJ', 'NM', 'NY', 'OH', 'PA', 'SD', 'UT', 'VA', 'WA', 'WI', 'RI', 'NV ', 'WY', 'DE', 'VT','MT', '')) and (called_count < 65);|
NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER
NO DIALABLE LEADS FOR THIS CAMPAIGN
hopper too low (0|500) starting hopper dump
ERROR CANNOT ADD ANY LEADS TO HOPPER
SUMMARY: 2 campaigns
Access 42230 700 0
close 0 500 0
DONE. Script execution time in seconds: 1