[opencms-dev] RES: Search index locked (maybe)

[Jeniffer Bastos de Souza]

Hi Deiverson.

I'm not using a custom index.

It's just a simple index implemented by CmsVfsIndexer.

That another suggestion that you gave, out of the email list, I assume as my correction.

I created another index and rebuild it.
Maybe with the crash of database server some tables/registers could be corrupted. So the reference for this indexes could be damage or lost. I can't be sure because de database is administrated by other team and we don't talk too much, unfortunately.

Thanks for helping me!

De: deiversonbh at gmail.com [mailto:deiversonbh at gmail.com] Em nome de Deiverson Silveira
Enviada em: terça-feira, 17 de maio de 2011 19:09
Para: The OpenCms mailing list
Cc: Jeniffer Bastos de Souza
Assunto: Re: [opencms-dev] Search index locked (maybe)

Hi Jeniffer,

Try test with index default CmsVfsIndexer, If the same problem occurs! You can a real need to use this index custom? Perhaps with the CmsVfsIndexer resolved.

Seu tomcat/postgresql/JVM está usando tunning?!

Recomendo postar no http://www.solutioncms.com/forum o problema, que o pessoal pode ajudar!

Cordialmente,

Deiverson Silveira

--
www.solutioncms.com<http://www.solutioncms.com/>
The Brazilian
Official Provider OpenCms


2011/5/17 Jeniffer Bastos de Souza <jeniffer.souza at itlab.com.br<mailto:jeniffer.souza at itlab.com.br>>
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.



_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/mailman/listinfo/opencms-dev



--
www.solutioncms.com<http://www.solutioncms.com>
The Brazilian
Official Provider OpenCms

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20110518/6fb72c26/attachment.htm>