Unusual Temporal UI behavior

[Manish_Baraskar]

Hi @antonio.perez @tihomir

Problem Faced : We had faced issue with elastic search, visibility index got corrupted or deleted sometimes after container recreation in some scenario.

What we want to achieve : We want Mysql as visibility not the elastic search.

Versions:
MySQL : v8.0
Elastic-Search : v7.16.2

Please refer the link on which I have already posted the query:

Workflows not visible on UI after docker restart

Hi Thiomir/Maxim, In our testing environment some how docker was stopped and that’s why we have to take restart for it and when we did it we found that most of the workflows were vanished from temporal UI but were present in database. So is there any way to bring them back to temporal UI and along with this we found that querying based on search attribute is also not working that’s why signalling is not happening to respective workflows. Is there any auto purging policy in temporal like after …

1. We were doing a POC for setting Mysql as visibility, we are doing this because we faced issue while using elastic search as store because whenever container for elastic gets recreated after that we are not able to filter/query workflow based on custom search attribute. Search Attributes exits but query returns no results.

2. We have configured DB=mysql8 and ES_ENABLE=false (disable ES)

3. Issue is not related to delay in reflecting a workflow status.

4. If I look the workflow ID its status is shown as running.

5. When I go to details history for the same workflow ID all the executions are done and showing status as completed. But main page always shows as running state.

6. Refer the attached screenshot.