Mailchimp duplicate campaign log records

[alasdaircr]

Hi,

Is anyone else seeing duplicate records in the campaign log after a campaign sync via MailChimp?

Here is an example set of records after I cleared all the mail_chimp_log_marker rows, and campaign_log_records and waited for a resync

Sent    2016-10-24 16:10:00    2016-11-02 18:23:12
Sent    2016-10-24 16:10:00    2016-11-02 18:23:12
Sent    2016-10-24 16:10:00    2016-11-02 18:23:12
Sent    2016-10-24 16:10:00    2016-11-02 18:23:12
Sent    2016-10-24 16:10:00    2016-11-02 18:23:13
Sent    2016-10-24 16:10:00    2016-11-02 18:23:13
Sent    2016-10-24 16:10:00    2016-11-02 18:23:13
Sent    2016-10-24 16:10:00    2016-11-02 18:23:13
Sent    2016-10-24 16:10:00    2016-11-02 18:23:14 

These all have the same string_data - i.e they are the same sent record for one recipient.

It's as if there's a race condition and multiple syncs are being called for the same campaign_id at the same time?

[alasdaircr]

When the "MailChimp Sync" scheduled task runs, it creates 67

MailChimp: updateCampaignLogFromMailChimp

jobs, which is the correct number of matching campaigns.

[alasdaircr]

Any ideas?

[tanya]

Hi. Duplicates are only with Sent Types? 67 records - very weird. How many records mail_chimp_log_marker Sent typed with mc_campaign_id the same as campaign mail_chimp_campaign_id column?

[alasdaircr]

No, 67 is fine that's the number of Mailchimp campaigns I have.

There is no duplication in the mail_chimp_log_marker table, I have 67 records there - which is the correct number.

In campaing_log_record there is duplication of ALL actions, the same number of duplicate for each action. E.g. if there's 10 duplicate Sent records there is 10 duplicate Clicked records

[tanya]

problem is only with 1 campaign? Really exists duplicates in Clicked? (Sent has not duplicate checking because it checks once end in normal way duplicates can not be met, but Clicked has checking on duplicates - and it is very interecting)

[alasdaircr]

Hi yes it's the same problem for all campaigns. The number of duplicates varies massivley.

I have an example where one I have 250 log records for one contact and one campaign...

They clicked 25 times, but this has been duplicated 10 times.

SELECT `action`,count(*) FROM `campaign_log_record`
WHERE `campaign_id` = '581a2621b8ccb753f' AND `parent_id` = '54b7f2c884f25'
GROUP BY `action`;

Clicked    250
Opened    10
Sent    10 

Something very strange is happening! The code is too complex for me to understand where the fault may exist.

Do you use Mailchimp / have any knowledge of this happening for anyone else? This is a pretty important thing for us to have working.