[maxwatson]

4 years, 1 month ago in reply to: WordPress database error on step 2.2 #18774

Yes, right…should I try to manually insert some data in the table, maybe that changes something?

[maxwatson]

4 years, 1 month ago in reply to: Remove 10000 limit when using elasticsearch #18773

This limit appears only on store categories (or other pages like brands or product tags) with over 10K products.
Pagination from tab 2.1 works perfect, if I set 12 or 48 products per page, I get that number on the front also.
For search results I didn’t notice this limitation because until now I didn’t have such a big number of results.

Also in tab 2.1 Replace front-end archives I’ve checked only Search, but it applies the query to product categories also, is this normal?
I see Warning: permalinks must be activated, but I don’t know where to activate them.

I’ve tried modifying index.max_result_window in ES to 500000, but nothing changes.

[maxwatson]

4 years, 1 month ago in reply to: WordPress database error on step 2.2 #18769

Ok, I’ve dropped the table again and checked only post types to index, and no more errors (the table wasn’t created in the database).
So I’ve checked Products to index – no errors.
But when I’ve checked products category to index, that’s when the errors reappeared.
What can be wrong with product categories? Currently there are 1624 categories in the store.

[maxwatson]

4 years, 1 month ago in reply to: Remove 10000 limit when using elasticsearch #18737

For example if I access directly the search url like this:

index_name/_search?scroll=1m

I get
“hits” : {
“total” : {
“value” : 195382,
“relation” : “eq”
},

Without scroll=1m parameter I get

“hits” : {
“total” : {
“value” : 10000,
“relation” : “gte”
},

So how can I add this scroll parameter to the plugin?

[maxwatson]

4 years, 1 month ago in reply to: Remove 10000 limit when using elasticsearch #18735

In error.log I’m getting this error:

[error] 22638#0: *2675819 FastCGI sent in stderr: “PHP message: WPSOLR message: {“error”:{“root_cause”:[{“type”:”illegal_argument_exception”,”reason”:”Result window is too large, from + size must be less than or equal to: [10000] but was [17528]. See the scroll api for a more efficient way to request large data sets. This limit can be set by changing the [index.max_result_window] index level setting.”}],”type”:”search_phase_execution_exception”,”reason”:”all shards failed”,”phase”:”query”,”grouped”:true,”failed_shards”:[{“shard”:0,”index”:”XXX”,”node”:”fwq0djM1XXXizUMgOkT3A”,”reason”:{“type”:”illegal_argument_exception”,”reason”:”Result window is too large, from + size must be less than or equal to: [10000] but was [17528]. See the scroll api for a more efficient way to request large data sets. This limit can be set by changing the [index.max_result_window] index level setting.”}}],”caused_by”:{“type”:”illegal_argument_exception”,”reason”:”Result window is too large, from + size must be less than or equal to: [10000] but was [17528]. See the scro…PHP message: WPSOLR trace:

[maxwatson]

4 years, 1 month ago in reply to: Remove 10000 limit when using elasticsearch #18734

Also the weird thing is that I’ve set No. of values to be displayed by filters: 0 for unlimited values and I’m still getting 10 results in sidebar filters.
I’ve replaced front-end archives for: Search Home/Blog Categories Tags Post types

[maxwatson]

4 years, 1 month ago in reply to: WordPress database error on step 2.2 #18733

Yes, this is how I’m doing it.
But after the table is dropped, another one is being created, and the error re-appears, only when accessing tab 2.2 Data

[maxwatson]

4 years, 1 month ago in reply to: WordPress database error on step 2.2 #18731

I have the same problem, and it doesn’t fix the problem for me, any other ideas?
Thanks!

[maxwatson]

4 years, 1 month ago in reply to: Remove 10000 limit when using elasticsearch #18730

Yes, for categories I already have pagination activated, 12 products per page.

[maxwatson]

4 years, 1 month ago in reply to: Remove 10000 limit when using elasticsearch #18727

Currently I have WPSOLR PRO 21.8, how can I get the beta release?
The problem is that the category products are limited to 10K, which is a problem for bigger categories.
Also I think facets filtering is affected by this also, because some terms don’t appear in filters.

[maxwatson]

4 years, 1 month ago in reply to: Remove 10000 limit when using elasticsearch #18725

I see they recommend here using ‘scroll’, but how and where can I apply this to WPSOLR?