Loop on Insert Leads into Hopper

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Loop on Insert Leads into Hopper

Postby lmoreira » Fri Aug 27, 2021 8:22 am

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|
--
Luciano Moreira
Consultor ViciDial no Brasil | Web: www.logictelecom.com.br | Telegram: https://t.me/luciano_logictelecom | ViciBox V9.x
lmoreira
 
Posts: 54
Joined: Wed Oct 01, 2008 6:51 pm

Re: Loop on Insert Leads into Hopper

Postby mflorell » Fri Aug 27, 2021 9:39 am

Are you doing Extended Auto-Alt-Dialing? If so, might be this issue,
http://www.vicidial.org/VICIDIALmantis/view.php?id=1323
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Loop on Insert Leads into Hopper

Postby lmoreira » Fri Aug 27, 2021 11:31 am

mflorell wrote: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.
--
Luciano Moreira
Consultor ViciDial no Brasil | Web: www.logictelecom.com.br | Telegram: https://t.me/luciano_logictelecom | ViciBox V9.x
lmoreira
 
Posts: 54
Joined: Wed Oct 01, 2008 6:51 pm

Re: Loop on Insert Leads into Hopper

Postby mflorell » Fri Aug 27, 2021 3:30 pm

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.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Loop on Insert Leads into Hopper

Postby lmoreira » Mon Aug 30, 2021 8:00 am

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||
--
Luciano Moreira
Consultor ViciDial no Brasil | Web: www.logictelecom.com.br | Telegram: https://t.me/luciano_logictelecom | ViciBox V9.x
lmoreira
 
Posts: 54
Joined: Wed Oct 01, 2008 6:51 pm

Re: Loop on Insert Leads into Hopper

Postby lmoreira » Wed Sep 01, 2021 8:18 am

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.
--
Luciano Moreira
Consultor ViciDial no Brasil | Web: www.logictelecom.com.br | Telegram: https://t.me/luciano_logictelecom | ViciBox V9.x
lmoreira
 
Posts: 54
Joined: Wed Oct 01, 2008 6:51 pm


Return to Support

Who is online

Users browsing this forum: No registered users and 65 guests