All work

Select view

Select search mode

 
50 of 222

Exception is thrown when UserGroup count is over Elasticsearch's 'index.max_result_window' setting

Fixed

Description

Workaround Increase "'index.max_result_window" to a higher value through either

  • the "Additional Index Configurations" property of "Elasticsearch 6/7" in System Settings then Reindex! or

  • through the Elasticsearch Settings REST API:

https://www.elastic.co/guide/en/elasticsearch/reference/7.17/indices-update-settings.html
https://www.elastic.co/guide/en/elasticsearch/reference/7.17/index-modules.html

https://www.elastic.co/guide/en/elasticsearch/reference/6.5/indices-update-settings.html
https://www.elastic.co/guide/en/elasticsearch/reference/6.5/index-modules.html

Steps to Reproduce:

  1. Go to Control Panel > Configuration > Server Administration > Script. Paste and execute this groovy script to create 10K User Groups. (It took about 7 min for the user groups to be created)

  1. Go to Control Panel > Configuration > System Setting > Foundation > Elasticsearch. Uncheck "Log exceptions only" and Save.

  2. Go to Control Panel > Users > User Groups

  3. (After is fixed) Click on page 501 of the search container

Expected Result:
User Groups would be shown with no error.

Actual Result:
No User Groups are shown and an exception is thrown in the logs:

Testing:
Reproduced in 7.0.x - bd606dc002774835d7e3688912e73e1a76948ca6
Reproduced in master - e567dd03399c2c6c1b042345d122589367ea16c2

Attachments

1
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Labels

Fix Priority

3

Bug Type

Default

Story Points

Components

Affects versions

Priority

Zendesk Support

Created May 5, 2017 at 9:42 AM
Updated March 21, 2024 at 2:03 PM
Resolved May 25, 2023 at 12:01 PM

Activity

Show:

Tibor LipuszMay 26, 2023 at 2:02 AM

Solution notes: this is requiring a dev feature flag to be enabled currently as we are still testing the implementation ().

BrookeMay 25, 2023 at 12:01 PM
Edited

PASSED Manual Testing following the steps in the description.

Fixed on:

Tomcat 9.0.73 + MySQL 5.7 Portal master GIT ID: 31f798632f3cf22c68a3862c93f3631515ddb931

After going to page 501, User Groups are shown with no error.

Tibor LipuszMay 6, 2019 at 3:47 AM

Reproduced on master@758f055954410ca7c1d8ba46b18fdd28ea9c611e

Sharry ShiFebruary 19, 2019 at 2:40 AM

Not be Reproduced on:
Tomcat 8.0.53 + MySQL 5.6. Portal 7.0.x-private GIT ID: 31c7d9c08087339ba369a35e14a123676d7b9ef3.

No exception and user group loaded.

Sharry ShiFebruary 19, 2019 at 2:39 AM
Edited

Reproduced on:
Tomcat 9.0.10 + MySQL 5.7. Portal master GIT ID: 4dda6fa7afb54feef301333920a523f214b8e05c.
Tomcat 9.0.10 + MySQL 5.7. Portal 7.1.x GIT ID: ee3cc2d128e09e039854f643acc4d3963069dfc0.

No User Groups are shown and an exception is thrown in the logs.
Note Elasticsearch is under System Setting > Search on 7.1+