<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:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@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:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
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;}
span.E-MailFormatvorlage17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.head
{mso-style-name:head;}
span.note
{mso-style-name:note;}
span.warn
{mso-style-name:warn;}
span.E-MailFormatvorlage21
{mso-style-type:personal-reply;
font-family:"Verdana","sans-serif";
color:windowtext;}
.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 lang=DE link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Do you index PowerPoint documents for the index?<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>If so, disable PowerPoint indexing in opencms-search.xml by removing the document type from your index configuration. <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>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.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>The good news is that I have been able to fix this for the upcoming 8.0.1 release.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p> </o:p></span></p><div><p class=MsoNormal><span lang=EN-US>Kind Regards,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Alex.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>-------------------<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Alexander Kandzior<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Alkacon Software GmbH - The OpenCms Experts <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>http://www.alkacon.com - http://www.opencms.org <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p></div><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><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"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> opencms-dev-bounces@opencms.org [mailto:opencms-dev-bounces@opencms.org] <b>On Behalf Of </b>Jeniffer Bastos de Souza<br><b>Sent:</b> Tuesday, May 17, 2011 11:12 PM<br><b>To:</b> opencms-dev@opencms.org<br><b>Subject:</b> [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 lang=EN-US>Hi everyone.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>I hope you guys can help me.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>I have a main search in my site where the visitant can search anything that he want.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>All my documents, files and other things in VFS are indexed in a index called buscaPrincipalOnLineIndex and buscaPrincipalOffLineIndex.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>OK.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>When any user tried to publish any document that uses the main index I received this message: <o:p></o:p></span></p><p class=MsoNormal><span class=head><span lang=EN-US>Updating search index "buscaPrincipalOffLineIndex"</span></span><span lang=EN-US><br><span class=note>( 1 ) Indexing file</span> /sites/default/turismo/multimidia/radio_turismo/20110510.html ... <br><span class=warn>failedTimeout while indexing file /sites/default/turismo/multimidia/radio_turismo/20110510.html, abandoning thread</span><br><span class=head>... finished updating search index "buscaPrincipalOffLineIndex"</span></span><span class=head><o:p></o:p></span></p><p class=MsoNormal><span class=head><span lang=EN-US><o:p> </o:p></span></span></p><p class=MsoNormal><span class=head><span lang=EN-US>It happened with online and offline index. This log is just an example.<o:p></o:p></span></span></p><p class=MsoNormal><span class=head><span lang=EN-US><o:p> </o:p></span></span></p><p class=MsoNormal><span class=head><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.<o:p></o:p></span></span></p><p class=MsoNormal><span class=head><span lang=EN-US><o:p> </o:p></span></span></p><p class=MsoNormal><span class=head><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)<o:p></o:p></span></span></p><p class=MsoNormal><span class=head><span lang=EN-US><o:p> </o:p></span></span></p><p class=MsoNormal><span class=head><span lang=EN-US>I remember that the logs pointed to an error when executing a select statement. <o:p></o:p></span></span></p><p class=MsoNormal><span class=head><span lang=EN-US><o:p> </o:p></span></span></p><p class=MsoNormal><span class=head><span lang=EN-US>I attached a print screen, maybe it can help.<o:p></o:p></span></span></p><p class=MsoNormal><span class=head><span lang=EN-US><o:p> </o:p></span></span></p><p class=MsoNormal><span class=head><span lang=EN-US>Would the database or one of it's tables/registers corrupted?<o:p></o:p></span></span></p><p class=MsoNormal><span class=head><span lang=EN-US>Windows could lock the index files?<o:p></o:p></span></span></p><p class=MsoNormal><span class=head><span lang=EN-US><o:p> </o:p></span></span></p><p class=MsoNormal><span class=head><span lang=EN-US>I can't restart Windows or repair the tables because the </span></span><span lang=EN-US>environment<span class=head> where OpenMCS runs is on my client and I don't have full access and all permissions to do that.<o:p></o:p></span></span></p><p class=MsoNormal><span class=head><span lang=EN-US><o:p> </o:p></span></span></p><p class=MsoNormal><span class=head><span lang=EN-US>My site runs on:<o:p></o:p></span></span></p><p class=MsoNormal><span class=head><span lang=EN-US>Windows Server 2008;<o:p></o:p></span></span></p><p class=MsoNormal><span class=head><span lang=EN-US>Java 6;<o:p></o:p></span></span></p><p class=MsoNormal><span class=head><span lang=EN-US>Tomcat 6.0.20;<o:p></o:p></span></span></p><p class=MsoNormal><span class=head><span lang=EN-US>OpenCMS 7.5.2;<o:p></o:p></span></span></p><p class=MsoNormal><span class=head><span lang=EN-US>Postgres 8.4.5;<o:p></o:p></span></span></p><p class=MsoNormal><span class=head><span lang=EN-US><o:p> </o:p></span></span></p><p class=MsoNormal><span class=head><span lang=EN-US>Thanks in advance.<o:p></o:p></span></span></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>