Send data tab takes 22 minutes to load
- wpsolrKeymaster4 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.
leomoonParticipant4 years, 9 months ago #12537Following 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.
leomoonParticipant4 years, 9 months ago #12569That 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?
You must be logged in to reply to this topic.