<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=iso-8859-1"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"Pré-formatação HTML Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.Pr-formataoHTMLChar
{mso-style-name:"Pré-formatação HTML Char";
mso-style-priority:99;
mso-style-link:"Pré-formatação HTML";
font-family:Consolas;
color:black;}
span.EstiloDeEmail19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body bgcolor=white lang=PT-BR link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I Joseph, thanks for reply.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>My rebuild mode was already set to auto.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I created a new index for my main search and set this "force unlock" to always.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I tested and seems to be running fine.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Just to test, I decided to use the main search with the old index, the problematic one.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>It's running fine too.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>It puzzles me.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>The main search became out for a week or less and now when I test it works fine. It's just "auto fixed"?<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Anyway, I'll follow up this situation. If the old index start to act strange I'll change for the new one with this configuration.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Thank you! <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'>De:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'> opencms-dev-bounces@opencms.org [mailto:opencms-dev-bounces@opencms.org] <b>Em nome de </b>Joseph ABENA<br><b>Enviada em:</b> quarta-feira, 18 de maio de 2011 10:07<br><b>Para:</b> The OpenCms mailing list<br><b>Assunto:</b> Re: [opencms-dev] Search index locked (maybe)<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='font-family:"Calibri","sans-serif"'>Hello Jenifer,<br><br>Into the OpenCms administration => Search management <br><br>- Check the settings (index sources ...) of </span><span lang=EN-US style='font-family:"Calibri","sans-serif"'>buscaPrincipalOnLineIndex and buscaPrincipalOffLineIndex </span><span style='font-family:"Calibri","sans-serif"'><br>- check the <b>rebuild mode</b> of </span><span lang=EN-US style='font-family:"Calibri","sans-serif"'>buscaPrincipalOnLineIndex and buscaPrincipalOffLineIndex and set it to <b>auto </b>if it's not the case<br><br>Or <br><br></span><o:p></o:p></p><pre><span style='font-size:12.0pt;font-family:"Calibri","sans-serif"'>You can also make a change to the <b><i>opencms-search.xml </i></b>file to force OpenCms to remove a lock on the search index even when doing an incremental indexing.<o:p></o:p></span></pre><pre><span style='font-size:12.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></pre><pre><span style='font-size:12.0pt;font-family:"Calibri","sans-serif"'>By replacing the line<o:p></o:p></span></pre><pre><span style='font-size:12.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></pre><pre><b><i><span style='font-size:12.0pt;font-family:"Calibri","sans-serif"'><forceunlock></span></i></b><b><i><span style='font-size:12.0pt;font-family:"Calibri","sans-serif";color:#000099'>onlyfull</span></i></b><b><i><span style='font-size:12.0pt;font-family:"Calibri","sans-serif"'></forceunlock></span></i></b><span style='font-size:12.0pt;font-family:"Calibri","sans-serif"'><o:p></o:p></span></pre><pre><span style='font-size:12.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></pre><pre><span style='font-size:12.0pt;font-family:"Calibri","sans-serif"'>with<o:p></o:p></span></pre><pre><span style='font-size:12.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></pre><pre><b><i><span style='font-size:12.0pt;font-family:"Calibri","sans-serif"'><forceunlock></span></i></b><b><i><span style='font-size:12.0pt;font-family:"Calibri","sans-serif";color:#000099'>always</span></i></b><b><i><span style='font-size:12.0pt;font-family:"Calibri","sans-serif"'></forceunlock></span></i></b><span style='font-size:12.0pt;font-family:"Calibri","sans-serif"'><o:p></o:p></span></pre><pre><span style='font-size:12.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></pre><pre><span style='font-size:12.0pt;font-family:"Calibri","sans-serif"'>and restart tomcat after the change.</span><span style='font-family:"Calibri","sans-serif"'><o:p></o:p></span></pre><p class=MsoNormal><span style='font-family:"Calibri","sans-serif"'><br>Kind regards<br>----------<br><b>Joseph</b><br><a href="http://www.abena09.com/joseph">www.abena09.com/joseph</a></span><br><br>On 17/05/2011 23:08, Deiverson Silveira wrote: <o:p></o:p></p><p class=MsoNormal>Hi Jeniffer, <o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>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.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Seu tomcat/postgresql/JVM está usando tunning?!<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Recomendo postar no <a href="http://www.solutioncms.com/forum">http://www.solutioncms.com/forum</a> o problema, que o pessoal pode ajudar!<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Cordialmente,<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Deiverson Silveira<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>-- <i><o:p></o:p></i></p><div><div><div><p class=MsoNormal><i><a href="http://www.solutioncms.com/" target="_blank">www.solutioncms.com</a><o:p></o:p></i></p></div></div><div><div><div><div><p class=MsoNormal><i>The Brazilian <o:p></o:p></i></p><div><div><p class=MsoNormal><i>Official Provider OpenCms<o:p></o:p></i></p></div></div></div></div></div></div></div></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>2011/5/17 Jeniffer Bastos de Souza <<a href="mailto:jeniffer.souza@itlab.com.br">jeniffer.souza@itlab.com.br</a>><o:p></o:p></p><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>Hi everyone.</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>I hope you guys can help me.</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>I have a main search in my site where the visitant can search anything that he want.</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>All my documents, files and other things in VFS are indexed in a index called buscaPrincipalOnLineIndex and buscaPrincipalOffLineIndex.</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>OK.</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>When any user tried to publish any document that uses the main index I received this message: </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>Updating search index "buscaPrincipalOffLineIndex"<br>( 1 ) Indexing file /sites/default/turismo/multimidia/radio_turismo/20110510.html ... <br>failedTimeout while indexing file /sites/default/turismo/multimidia/radio_turismo/20110510.html, abandoning thread<br>... finished updating search index "buscaPrincipalOffLineIndex"</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>It happened with online and offline index. This log is just an example.</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>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.</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>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)</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>I remember that the logs pointed to an error when executing a select statement. </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>I attached a print screen, maybe it can help.</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>Would the database or one of it's tables/registers corrupted?</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>Windows could lock the index files?</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>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.</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>My site runs on:</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>Windows Server 2008;</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>Java 6;</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>Tomcat 6.0.20;</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>OpenCMS 7.5.2;</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>Postgres 8.4.5;</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>Thanks in advance.</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US> </span><o:p></o:p></p></div></div><p class=MsoNormal><br><br>_______________________________________________<br>This mail is sent to you from the opencms-dev mailing list<br>To change your list options, or to unsubscribe from the list, please visit<br><a href="http://lists.opencms.org/mailman/listinfo/opencms-dev" target="_blank">http://lists.opencms.org/mailman/listinfo/opencms-dev</a><o:p></o:p></p></div><p class=MsoNormal><br><br clear=all><br>-- <i><o:p></o:p></i></p><div><div><div><p class=MsoNormal><i><a href="http://www.solutioncms.com" target="_blank">www.solutioncms.com</a><o:p></o:p></i></p></div></div><div><div><div><div><p class=MsoNormal><i>The Brazilian <o:p></o:p></i></p><div><div><p class=MsoNormal><i>Official Provider OpenCms<o:p></o:p></i></p></div></div></div></div></div></div></div><p class=MsoNormal><o:p> </o:p></p></div><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><p class=MsoNormal><o:p> </o:p></p></div></body></html>