Send data tab takes 22 minutes to load

  • wpsolr
    Keymaster
    4 years, 9 months ago #12534

    by manually starting indexing over and over again

    You can select the products only on the indexing page, or any other post type or taxonomy.

    I have tests with WooCommerce attributes, and tags and categories. I could not detect your issue.

    2) Can you just select the taxonomy with an error, then set a batch size of one and select “debug”. It will display the current select query and the current term_id. Try to check the term in error.

    wpsolr
    Keymaster
    4 years, 9 months ago #12535

    I found the issue. Working on it.

    leomoon
    Participant
    4 years, 9 months ago #12537

    Following your instructions, I started debugged indexing of only taxonomy 1 at the time. It actually works for a while, but then, when it encounters a term that has post_modified date, it fails with that error above. The first 100 or so terms had null for post_modified and they were indexed ok. I saved here a query that grabs a few terms that get indexed well and then it goes into those that don’t. The first one that fails is the one with has date_modified field of non-null value.

    https://1drv.ms/t/s!Ah6mDhPS2VbWiKpiQ8bppdZT1cwoHw

    leomoon
    Participant
    4 years, 9 months ago #12538

    Here is the output of the whole indexing process:

    https://1drv.ms/t/s!Ah6mDhPS2VbWiKpjjP3g1WKtwlhq3g

    wpsolr
    Keymaster
    leomoon
    Participant
    4 years, 9 months ago #12569

    That works well now – thanks, especially because of the speed by which you resolve these.

    There is one more issue left. For some reason, the _stock_status_s field, which I index as text, sortable in order to be able to put in-stock books first sometimes gets sent for indexing as having multiple values. I could not find a pattern, but here is a fragment of the debug info:

    https://1drv.ms/t/s!Ah6mDhPS2VbWiKpkHIKUeVYFTYewlQ

    Both of these have status out of stock, but the first one, has [outofstock, outofstock] and the second one has just [outofstock].
    I checked the database, I checked product->data contents for this failing SKU (59747), but nowhere is stock_status anything but a single string ‘outofstock’. I am not sure why it gets multiplied before it gets sent for indexing?

Viewing 6 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic.