Howto re-index database

[jbyars]

On my test box the procedure on: https://trac.openmicroscopy.org.uk/ome/wiki/OmeroSearch worked fine. Now on the production 4.3.4 neither java program seems to work.

I have search set to:
comero.search.batch=100
omero.search.cron=0,30 * * * * ?

I have cleared /OMERO/FullText and I have made sure PersistentEventLogLoader.currend_id is set to zero. I start the server back up and it does not appear to index. The segments_1 and segments.gen files are created and that's about it. The Indexer-0.log shows creating FullText and initializing the FullTextAnalyzer, but then nothing after
INFO [ ome.security.basic.CurrentDetails] (3-thread-2) Adding log:INSERT,class ome.model.meta.Session,14334

How do you force a full reindex on 4.3.4? I can create tags and assign tags to images. I just can't search by tag.

[jmoore]

Can you show us the output of

Code: Select all

bin/omero admin diagnostics


as well as

Code: Select all

bin/omero config get


minus any passwords, of course.

Thanks.
~Josh

[jbyars]

Please disregard guys. I missed one Persistent entry in the configuration table in the db. After I killed that indexing restarted properly. Is it always safe to do?

Code: Select all

delete from configuration where name like 'Persistent%';

[jmoore]

At the moment (i.e. for versions 4.3.4 and before), yes. But I can't guarantee that no one or nothing won't start using a configuration value with a similar name. Cheers, ~Josh