Loop on Insert Leads into Hopper

[lmoreira]

Hi Guys,

I'm using Vicidial VERSION: 2.14-825a BUILD: 210812-1609. After this update, we got random loop on insert lead into hopper. So, in couples minutes vicidial_hopper table gets hundred thousands rows and system performance degraded. It happened on different campaigns, and different list. So, I could not figure out the cause.

Any help??

This process was in loop since 08:37 until server been rebooted.

Code: Select all

2021-08-27 08:37:45|AST_VDauto_dial|2379934|1127XXX300|MDDYT|XLAST|15|hopper insert|
2021-08-27 08:37:45|AST_VDauto_dial|2379934|1127XXX300|MDDYT|XLAST|15|hopper insert|
2021-08-27 08:37:45|AST_VDauto_dial|2379934|1127XXX300|MDDYT|XLAST|15|hopper insert|
2021-08-27 08:37:45|AST_VDauto_dial|2379934|1127XXX300|MDDYT|XLAST|15|hopper insert|
2021-08-27 08:37:45|AST_VDauto_dial|2379934|1127XXX300|MDDYT|XLAST|15|hopper insert|
2021-08-27 08:37:45|AST_VDauto_dial|2379934|1127XXX300|MDDYT|XLAST|15|hopper insert|
2021-08-27 08:37:45|AST_VDauto_dial|2379934|1127XXX300|MDDYT|XLAST|15|hopper insert|
2021-08-27 08:37:45|AST_VDauto_dial|2379934|1127XXX300|MDDYT|XLAST|15|hopper insert|
2021-08-27 08:37:45|AST_VDauto_dial|2379934|1127XXX300|MDDYT|XLAST|15|hopper insert|
2021-08-27 08:37:45|AST_VDauto_dial|2379934|1127XXX300|MDDYT|XLAST|15|hopper insert|
2021-08-27 08:37:45|AST_VDauto_dial|2379934|1127XXX300|MDDYT|XLAST|15|hopper insert|
2021-08-27 08:37:45|AST_VDauto_dial|2379934|1127XXX300|MDDYT|XLAST|15|hopper insert|
2021-08-27 08:37:45|AST_VDauto_dial|2379934|1127XXX300|MDDYT|XLAST|15|hopper insert|
2021-08-27 08:37:45|AST_VDauto_dial|2379934|1127XXX300|MDDYT|XLAST|15|hopper insert|

[mflorell]

Are you doing Extended Auto-Alt-Dialing? If so, might be this issue,
http://www.vicidial.org/VICIDIALmantis/view.php?id=1323

[lmoreira]

Are you doing Extended Auto-Alt-Dialing? If so, might be this issue,
http://www.vicidial.org/VICIDIALmantis/view.php?id=1323

Yep, It seams the same... but the loop trigger stills unknown.

[mflorell]

I've made a small change in svn/trunk revision 3507 to possibly fix this, please upgrade and give it a try and let me know if the problem continues.

[lmoreira]

It still happening on this version. Loop stops when alt_number is deleted from lead_id.

So, this is the log exactly when loop started:

Code: Select all

2021-08-30 09:38:48||     dead call vac deleted|41773|SENT|2382104|V8300937550002382104|1630327116|1||OUT|40|5|45|40|45|0E0||
2021-08-30 09:38:48||SELECT result FROM vicidial_cpd_log where callerid='V8300937550002382104' order by cpd_id desc limit 1;||
2021-08-30 09:38:48||SELECT list_id,called_count from vicidial_list where lead_id='2382104' limit 1;||
2021-08-30 09:38:48||     dead NA call added to log 1630327076.132879|2382104|8XXXXX95210|SENT|NA|1|1|0|
2021-08-30 09:38:48||     dead call vac lead marked NA|2382104|8XXXXX95210|SENT||
2021-08-30 09:38:48||SELECT auto_alt_dial,auto_alt_dial_statuses,use_internal_dnc,use_campaign_dnc,use_other_campaign_dnc,call_quota_lead_ranking,call_limit_24hour_method,cal
l_limit_24hour_scope,call_limit_24hour,call_limit_24hour_override FROM vicidial_campaigns where campaign_id='MDD';|ALT_AND_ADDR3_AND_EXTENDED| ERI A ADC PDROP AB AA B N NA DC
 -|NA|2382104|NONE|
2021-08-30 09:38:48||SELECT alt_phone,gmt_offset_now,state,list_id,phone_code,postal_code FROM vicidial_list where lead_id='2382104';|||
2021-08-30 09:38:48||SELECT address3,gmt_offset_now,state,list_id,phone_code,postal_code FROM vicidial_list where lead_id='2382104';|||
2021-08-30 09:38:48||SELECT count(*) FROM vicidial_list_alt_phones where lead_id='2382104';|1|
2021-08-30 09:38:48||SELECT alt_phone_id,phone_number,active,phone_code FROM vicidial_list_alt_phones where lead_id='2382104' and alt_phone_count='1';|8XXXXX7113|1||
2021-08-30 09:38:48||SELECT count(*) FROM vicidial_dnc where phone_number='8XXXXX7113';|0||
2021-08-30 09:38:48||SELECT count(*) FROM vicidial_campaign_dnc where phone_number='8XXXXX7113' and campaign_id='MDD';|0||
2021-08-30 09:38:48|--    VDH record inserted: |1|   |INSERT INTO vicidial_hopper SET lead_id='2382104',campaign_id='MDD',status='READY',list_id='202101285',gmt_offset_now='-
3.00',state='',alt_dial='XLAST',user='',priority='15',source='A';|XLAST|1183685||
2021-08-30 09:38:48||SELECT alt_phone_id,phone_number,active,phone_code FROM vicidial_list_alt_phones where lead_id='2382104' and alt_phone_count='1';|8XXXXX7113|1||
2021-08-30 09:38:48||SELECT count(*) FROM vicidial_dnc where phone_number='8XXXXX7113';|0||
2021-08-30 09:38:48||SELECT count(*) FROM vicidial_campaign_dnc where phone_number='8XXXXX7113' and campaign_id='MDD';|0||
2021-08-30 09:38:48|--    VDH record inserted: |1|   |INSERT INTO vicidial_hopper SET lead_id='2382104',campaign_id='MDD',status='READY',list_id='202101285',gmt_offset_now='-
3.00',state='',alt_dial='XLAST',user='',priority='15',source='A';|XLAST|1183685||
2021-08-30 09:38:48||SELECT alt_phone_id,phone_number,active,phone_code FROM vicidial_list_alt_phones where lead_id='2382104' and alt_phone_count='1';|8XXXXX7113|1||
2021-08-30 09:38:48||SELECT count(*) FROM vicidial_dnc where phone_number='8XXXXX7113';|0||
2021-08-30 09:38:48||SELECT count(*) FROM vicidial_campaign_dnc where phone_number='8XXXXX7113' and campaign_id='MDD';|0||
2021-08-30 09:38:48|--    VDH record inserted: |1|   |INSERT INTO vicidial_hopper SET lead_id='2382104',campaign_id='MDD',status='READY',list_id='202101285',gmt_offset_now='-
3.00',state='',alt_dial='XLAST',user='',priority='15',source='A';|XLAST|1183685||
2021-08-30 09:38:48||SELECT alt_phone_id,phone_number,active,phone_code FROM vicidial_list_alt_phones where lead_id='2382104' and alt_phone_count='1';|8XXXXX7113|1||
2021-08-30 09:38:48||SELECT count(*) FROM vicidial_dnc where phone_number='8XXXXX7113';|0||
2021-08-30 09:38:48||SELECT count(*) FROM vicidial_campaign_dnc where phone_number='8XXXXX7113' and campaign_id='MDD';|0||
2021-08-30 09:38:48|--    VDH record inserted: |1|   |INSERT INTO vicidial_hopper SET lead_id='2382104',campaign_id='MDD',status='READY',list_id='202101285',gmt_offset_now='-3.00',state='',alt_dial='XLAST',user='',priority='15',source='A';|XLAST|1183685||


[lmoreira]

UPDATE:
Florell, after your fix, loop stills occur, but for a minute or so, then all come back to normal again. We reset hooper and hopper is loaded how it supposed to be.