I've upgraded our server to OMERO 5, and I saw that re-indexing could be beneficial, so I tried it. However, it's still running (I started the re-indexing procedure on the 18th...) and it has currently indexed 2 486 297 objects.
I've noticed quite a few messages of this kind:
- Code: Select all
Null returned! Purging since cannot index ome.model.containers.Project:Id_1 for ome.model.meta.EventLog:Id_59
I suppose it's because the object has been removed since then ?
How many objects will it index ?
Is it 1 for each row in the table "eventlog" (which has 8 522 503 rows in my case) ?
Also, during the upgrade, I've noticed that optimizing the database takes quite some time, due to the processing of the "eventlog" table, so I was wondering if this table could be cleared...
But if the indexer is using it, I guess it cannot be done without hindering the search function...
So I guess I should keep this table with 8 522 503 rows (and counting...) as it is now ?