[opencms-dev] Search index locked (maybe)

[Jeniffer Bastos de Souza]

Hi everyone.

I hope you guys can help me.

I have a main search in my site where the visitant can search anything that he want.
All my documents, files and other things in VFS are indexed in a index called buscaPrincipalOnLineIndex and buscaPrincipalOffLineIndex.

OK.

When any user tried to publish any document that uses the main index I received this message:
Updating search index "buscaPrincipalOffLineIndex"
( 1 ) Indexing file /sites/default/turismo/multimidia/radio_turismo/20110510.html ...
failedTimeout while indexing file /sites/default/turismo/multimidia/radio_turismo/20110510.html, abandoning thread
... finished updating search index "buscaPrincipalOffLineIndex"

It happened with online and offline index. This log is just an example.

Sometimes I just selected both indexes and rebuild them. Everything go back to normal. But the problem got bigger and besides not updating the index, Tomcat was not responding any request related with the main search. And this search is very demanded. After a small period of time Tomcat gets overloaded and crashes.

What could it be? My client request to remove the main search from the site, so I don't get any log to show. (The problem disappears)

I remember that the logs pointed to an error when executing a select statement.

I attached a print screen, maybe it can help.

Would the database or one of it's tables/registers corrupted?
Windows could lock the index files?

I can't restart Windows or repair the tables because the environment where OpenMCS runs is on my client and I don't have full access and all permissions to do that.

My site runs on:
Windows Server 2008;
Java 6;
Tomcat 6.0.20;
OpenCMS 7.5.2;
Postgres 8.4.5;

Thanks in advance.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20110517/7681455e/attachment.htm>