I'm having some problems with the hopper load script. It has manifested this morning when we noticed the hopper was empty.
This has been stable and running fine for almost a year now until today.
Running /usr/share/astguiclient/AST_VDhopper.pl --debug gives the following output.
- Code: Select all
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near '93.6' at line 1 at /usr/share/astguiclient/AST_VDhopper.pl line 2077.
executing: SELECT lead_id,list_id,gmt_offset_now,phone_number,state,status,modify_date,user FROM vicidial_list where called_since_last_reset='N' and (list_id='60312'
and status IN('DROP','AFTHRS','A','NA','B','AB','AA','NEW')) and lead_id NOT IN('0') and ((gmt_offset_now
5','-2.50','-2.75','99') ) ) and called_count < 7 and ( ( (status IN('DROP','XDROP')) and (last_local_call_time <
CONCAT(DATE_ADD(NOW(), INTERVAL -259200 SECOND),' ',CURTIME()) ) ) or (status NOT IN('DROP','XDROP')) ) order by last_local_call_time,
lead_id asc limit 93.6; You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right
syntax to use near '93.6' at line 1 at /usr/share/astguiclient/AST_VDhopper.pl line 2077.
Without using list mix or with just 2 lists mixed 50/50 it seems to load fine, but when adding a third list or having a low mix % (like 5%) it reappears with a vengeance.
I was wondering if anyone could shed some light on this issue?
EDIT: Also figured you might want to know what filters we have applied, well its: called_count < 7
UPDATE: following a mysqlcheck repair and reboot it appears to be loading leads again (with no load). It brought a couple of 'a client is using this table or has not closed properly' errors, could these be symptoms or causes?
UPDATE 2: It would appear that this is a symptom as the problem has cropped up again, I can reproduce it by setting the list mix to mix 4 lists with one mixed under 10% and returns to normal if I remove the list with the under 10% mix -- does anyone have any ideas?
Thanks in advance.