Users not listing in search and cannot be added to environment under Access Control

[haripriyacv]

The below image shows the user exists in the user table of querybook. Able to login with the user successfully.

Below image shows user not listing when trying to add to environment.

I cant find errors in the logs. I tried curl get command and it is giving me blank data:

curl -k -i
-H "api-access-token: xxxxxxxxxxxxxxxx"
-H "Content-Type: application/json"
"https://querybook.test.com/ds/search/user/?params=%7B%22name%22%3A%22har%22%7D"
HTTP/2 200
content-type: application/json
content-length: 66
content-security-policy: frame-ancestors 'self'
date: Wed, 02 Jul 2025 09:17:49 GMT
x-envoy-upstream-service-time: 161
vary: Accept-Encoding
server: envoy

{
"data": [],
"host": "querybook-blue-web-76c4589f88-7cfwr"
}

[haripriyacv]

Hi,

Looking for some suggestions here on the above issue

[vanphuoc3012]

Hi, I faced similar issue in the past, user search api use opensearch, I reinit opensearch follow this guide: https://www.querybook.org/docs/developer_guide/reinitialize_es
and this work

[haripcv]

Thank you @vanphuoc3012,

Yes, that was the case with me as well. Whenever the indexes get deleted from Opensearch, the users and schema tables go missing.
The script fixes it.