We are for a some time using joining the thread ODB-IndexActivation to prevent issues when accessing database without the index been ready. Original Thread: https://www.objectdb.com/forum/2401
Now we've run into issue, that in some database the Index rebuild takes a lot of time (e.g. 20 minutes) and it is done repeatedly in multiple starts of database without any indexing change.
We would need to find a way, how to diagnose both:
We’ll need some additional details to investigate this further, such as the index definition, the number of objects being indexed, and any relevant entity hierarchy.
Is it possible that two different versions of the same entity are in use? If so, this could cause the schema to be repeatedly detected as changed, triggering continuous rebuilds.
Could you also check the logs to confirm whether the index rebuild completes successfully? If the EntityManagerFactory is closed before the rebuild finishes, the process will restart the next time the application is started.