Frequent deadlocks on mailchimp_ecommerce_sync_data

[seansan]

M1.9.4.x
php 7.2
Version 1.1.20

We see frequent deadlocks on mailchimp_ecommerce_sync_data

Which is strange because the mailchimp extension is the only code accessing this data .... so in effect the same extension is locking itself out?

Preconditions

1. install and use

Steps to reproduce

1. install and use

Expected result

No DB lock or at least a retry

Actual result

1213 Deadlock found when trying to get lock; try restarting transaction, query was: UPDATE mailchimp_ecommerce_sync_data SET related_id = ?, type = ?, mailchimp_store_id = ?, mailchimp_sync_error = ?, mailchimp_sync_delta = '2020-09-02 09:28:59', mailchimp_sync_modified = ?, mailchimp_sync_deleted = ?, mailchimp_token = ?, batch_id = ?, deleted_related_id = ?, mailchimp_synced_flag = ? WHERE (id='15854797')

This is

innodb_lock_wait_timeout = 3600

so even after 3600 seconds it cannot access the table

[Santiagoebizmarts]

Hello @seansan

Could you share your batch amounts configured in the extension?

Kind Regards,

[seansan]

everywhere 50

…

On Thu, Sep 3, 2020 at 6:41 PM Santiagoebizmarts ***@***.***> wrote: Hello @seansan <https://github.com/seansan> Could you share your batch amounts configured in the extension? Kind Regards, — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#1190 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAE7I233QLCTXZFEP2NC4YDSD7BKVANCNFSM4QU4AI2A> .

[ste88]

I have same problem.

M1.9.3.1
Version 1.1.20

On place order, after creation of order, the mailchimp code generates frequently exception deadlock that prevents the creation of order.

CONFIG
Customer amount to be sent for run: 100
Product amount to be sent for run: 50
Order amount to be sent for run: 50
Cart amount to be sent for run: 100

[seansan]

I sent all debug and all data no response ..

…

On Wed, Nov 4, 2020 at 1:39 PM Stefano ***@***.***> wrote: I have same problem. M1.9.3.1 Version 1.1.20 On place order, after creation of order, the mailchimp code generates frequently exception deadlock that prevents the creation of order. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#1190 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAE7I277ISPIFVD5Q3XG2JDSOFDPFANCNFSM4QU4AI2A> .

[sprankhub]

Check if #1178 helps.