[opencms-dev] Search index locked (maybe)

[Alexander Kandzior]

Do you index PowerPoint documents for the index?

 

If so, disable PowerPoint indexing in opencms-search.xml by removing the
document type from your index configuration. 

 

PowerPoint indexing in v7.x does not really work well, it is buggy and
causes memory leaks and these can bring the server down after some time.
Word, PDF etc. all seem to work well but not PPT. There is no quick solution
available to fix this for OpenCms 7.x.

 

The good news is that I have been able to fix this for the upcoming 8.0.1
release.

 

Kind Regards,

Alex.

-------------------

Alexander Kandzior

                                                              

Alkacon Software GmbH  - The OpenCms Experts                 

http://www.alkacon.com - http://www.opencms.org                  

 

 

From: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] On Behalf Of Jeniffer Bastos de
Souza
Sent: Tuesday, May 17, 2011 11:12 PM
To: opencms-dev at opencms.org
Subject: [opencms-dev] Search index locked (maybe)

 

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/20110518/78199a0d/attachment.htm>