Extremly slow syncing

  • Resolved henkesan

    (@henkesan)


    6 years, 7 months ago

    I tried to uninstall the plugin and reinstall.

    It has been syncing for ~7-8 days now and it has just finished our 1029 coupons
    It has just started the products 3/755
    Then it has all the orders to process 0/10599
    Then all the subscribers etc..
    It feels like it would take a year or so for this to finish. Something must be wrong with the syncing?

    Our site is hosted at WPEngine.
    I talked to their support they could not find anything wrong with the server/our installation

    They tried to use the WP-CLI method and run it for a couple of times.
    But it halted on an error with a blank error msg:

    “Currently running in another process
    Error:”

    Here is the latest log from the plugin:

    2019-10-24T12:13:53+00:00 DEBUG order_sync.transient :: transient set for order 23793
    2019-10-24T12:13:55+00:00 DEBUG order_sync.skip :: Order 23793 already added successfully to queue. Skipping.
    2019-10-24T12:13:55+00:00 DEBUG order_sync.transient :: transient set for order 23794
    2019-10-24T12:13:57+00:00 DEBUG order_sync.skip :: Order 23794 already added successfully to queue. Skipping.
    2019-10-24T13:07:35+00:00 ERROR api :: processCurlResponse :: Array
    (
    [info] => Array
    (
    [url] => https://us1.api.mailchimp.com/3.0/ecommerce/stores/(I removed this data for privacy)
    [content_type] => application/problem+json; charset=utf-8
    [http_code] => 404
    [header_size] => 630
    [request_size] => 367
    [filetime] => -1
    [ssl_verify_result] => 0
    [redirect_count] => 0
    [total_time] => 0.190002
    [namelookup_time] => 2.6E-5
    [connect_time] => 0.002318
    [pretransfer_time] => 0.017417
    [size_upload] => 0
    [size_download] => 196
    [speed_download] => 1031
    [speed_upload] => 0
    [download_content_length] => 196
    [upload_content_length] => -1
    [starttransfer_time] => 0.189964
    [redirect_time] => 0
    [redirect_url] =>
    [primary_ip] => (I removed this data for privacy)
    [certinfo] => Array
    (
    )

    [primary_port] => (I removed this data for privacy)
    [local_ip] => (I removed this data for privacy)
    [local_port] => (I removed this data for privacy)
    [http_version] => 2
    [protocol] => 2
    [ssl_verifyresult] => 0
    [scheme] => HTTPS
    [request_header] => GET /3.0/ecommerce/stores/(I removed this data for privacy)
    Host: us1.api.mailchimp.com
    Authorization: Basic (I removed this data for privacy)
    Accept: */*
    Accept-Encoding: deflate, gzip
    content-type: application/json
    user-agent: MailChimp for WooCommerce/2.2.4; PHP/7.3.10-1+ubuntu18.04.1+deb.sury.org+1; WordPress/5.1.3; Woo/3.7.1;

    )

    [data] => Array
    (
    [type] => http://developer.mailchimp.com/documentation/mailchimp/guides/error-glossary/
    [title] => Resource Not Found
    [status] => 404
    [detail] => The requested resource could not be found.
    [instance] => (I removed this data for privacy)
    )

    )

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author ryanhungate

    (@ryanhungate)

    6 years, 7 months ago

    @henkesan thanks for writing in. You’re correct this is not the desired speed at all, and there must be a reason for it. Let’s start by doing this.

    1. What is the version of your Mailchimp Plugin?

    2. If you’re using the CLI version, did you add the constant in your wp-config file that disables the HTTP WORKER? If so, you MUST run this in the command line all day – which requires a cron job or a process manager to constantly run this in the background.

    3. We need to know which URL is returning the 404 in order to understand if it’s a problem – or if it’s just a false positive log.

    4. Can you please disable the object caching temporarily and then see if the site starts processing things correctly?

    If you would like, we can assist you in this process by sending the log file directly to ryan (at) vextras.com and I can view these personally to help with the next steps, and also provide some more personal guidance that would be better suited over email.

    Thread Starter henkesan

    (@henkesan)

    6 years, 7 months ago

    Hi! Thanks for your reply.

    1. Latest Version 2.2.4

    2. WPEngine added the constant in the wp-config file. They just test run the command to see if the syncing was stuck or something. In order to set up a cron job I had to install something locally and use SSH. It sounded a bit complicated so I did not investigate in that any further.

    3. I will send you the full log to the email address you mentioned.

    4. How do I do that? We do not use any caching plugin. WPEngine has its own built it caching system which i dont think you can turn off without contacting support.

    Plugin Author ryanhungate

    (@ryanhungate)

    6 years, 7 months ago

    @henkesan I’ve responded through email – and have worked with the folks at WP Engine, and it turns out that they do not support the CLI version of our plugin. That means you can not install the proper cron schedule in order to run this in the background while using WP Engine.

    That being said, you should simply remove the DISABLE_HTTP_WORKER constant, and the queue should start processing through the HTTP version of the queue.

    On another note, we are releasing a new version of the plugin later this week, and it will be making use of the “Action Scheduler” which will also solve your issues you’ve experienced. We’re looking forward to the next release too so keep your eye out for the update.

    If you would be so kind as to leave us a fair review, we would be much appreciative. 🙂

    Plugin Author ryanhungate

    (@ryanhungate)

    6 years, 7 months ago

    @henkesan just wanted to ping you on this – we did end up releasing version 2.3 today – so please give that an update – and let us know if that solves your syncing issue!

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Extremly slow syncing’ is closed to new replies.