mc-magento
mc-magento copied to clipboard
mailchimp
Frequent deadlocks on mailchimp_ecommerce_sync_data
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
- install and use
Steps to reproduce
- 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
Hello @seansan
Could you share your batch amounts configured in the extension?
Kind Regards,
everywhere 50
On Thu, Sep 3, 2020 at 6:41 PM Santiagoebizmarts [email protected] 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 https://github.com/mailchimp/mc-magento/issues/1190#issuecomment-686614938, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAE7I233QLCTXZFEP2NC4YDSD7BKVANCNFSM4QU4AI2A .
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
I sent all debug and all data
no response ..
On Wed, Nov 4, 2020 at 1:39 PM Stefano [email protected] 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 https://github.com/mailchimp/mc-magento/issues/1190#issuecomment-721708056, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAE7I277ISPIFVD5Q3XG2JDSOFDPFANCNFSM4QU4AI2A .
