<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; "><DIV><SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; ">Justin,<BR class="Apple-interchange-newline"></SPAN></SPAN> </DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>I had the memory setting left to the default setup, which is as I understand 64MB, thus I changed it via setting up the optional variable </DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV> CATALINA_OPTS="-Xms256m -Xmx512m"</DIV><DIV><BR class="khtml-block-placeholder"></DIV>making the memory heap allocated to tomcat between 256m and 512m seem to have done the trick and fixed it all up just nicely.<DIV><BR class="khtml-block-placeholder"></DIV><DIV>Thanks for the suggestion mate...</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Gaith Bader</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV><BR><DIV><DIV>On 23/06/2006, at 1:37 AM, <<A href="mailto:justin.spies@sbcglobal.net">justin.spies@sbcglobal.net</A>> <<A href="mailto:justin.spies@sbcglobal.net">justin.spies@sbcglobal.net</A>> wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite"><DIV style="font-family:times new roman, new york, times, serif;font-size:12pt"><DIV style="font-family: times new roman,new york,times,serif; font-size: 12pt;">Gaith,<BR>I'm not sure that this will help as the error is not 100% the same. I have installed OpenCMS into a PostgreSQL database as well (8.1 running on Windows) and found that the installation needed quite a bit more memory than OpenCMS does for normal ops. I've setup my OpenCMS system with 256MB of heap for standard ops, but had to set it to 768MB for the install. I also had major memory issues when loading multiple digital photos (trying to load 900 photos at about 1.5MB each)<BR><BR>What are your current memory settings?<BR><BR><BR>-- Justin Spies<BR><BR><DIV style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- Original Message ----<BR>From: Gaith Bader <<A href="mailto:gaithb@cse.unsw.edu.au">gaithb@cse.unsw.edu.au</A>><BR>To: The OpenCms mailing list <<A href="mailto:opencms-dev@opencms.org">opencms-dev@opencms.org</A>><BR>Sent: Wednesday, June 21, 2006 11:30:05 PM<BR>Subject: [opencms-dev] OpenCms 6.2.1 installation problem with PostgreSQL 8.1.4<BR><BR>Hello everybody,<DIV><BR class="khtml-block-placeholder"></DIV><DIV>due to work requirements I was asked to move development of our OpenCms to a PostgreSQL database instead of the usual mySQL</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>I decided to do a clean install of Tomcat, PostgreSQL and OpenCms, when I go through the setup wizard of the OpenCms, I chose ProstgreSQL as the database, chose postgres database for installation, everything goes just fine, it starts installing and importing modules, then around 5 minutes into the setup it finishes the installation telling me the Status is ok (with the green tick) however, looking at the output this is what shows up just before it finishes:</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>-----------------------------</DIV><DIV style="margin: 0px;">2656:<SPAN class="Apple-tab-span" style="white-space: pre;"> </SPAN></DIV><DIV style="margin: 0px;">2655:<SPAN class="Apple-tab-span" style="white-space: pre;"> </SPAN>Shutdown completed, total uptime was 00:06:13.</DIV><DIV style="margin: 0px;">2654:<SPAN class="Apple-tab-span" style="white-space: pre;"> </SPAN>Shutting down OpenCms, version 6.2.1 in web application "opencms"</DIV><DIV style="margin: 0px;">2653:<SPAN class="Apple-tab-span" style="white-space: pre;"> </SPAN></DIV><DIV style="margin: 0px;">2652:<SPAN class="Apple-tab-span" style="white-space: pre;"> </SPAN></DIV><DIV style="margin: 0px;">2651:<SPAN class="Apple-tab-span" style="white-space: pre;"> </SPAN>The OpenCms system used for the setup will now shut down.</DIV><DIV style="margin: 0px;">2650:<SPAN class="Apple-tab-span" style="white-space: pre;"> </SPAN>The setup is finished!</DIV><DIV style="margin: 0px;">2649:<SPAN class="Apple-tab-span" style="white-space: pre;"> </SPAN></DIV><DIV style="margin: 0px;">2648:<SPAN class="Apple-tab-span" style="white-space: pre;"> </SPAN></DIV><DIV style="margin: 0px;">2647:<SPAN class="Apple-tab-span" style="white-space: pre;"> </SPAN>Admin@Offline>exit</DIV><DIV style="margin: 0px;">2646:<SPAN class="Apple-tab-span" style="white-space: pre;"> </SPAN>Admin@Offline></DIV><DIV style="margin: 0px;">2645:<SPAN class="Apple-tab-span" style="white-space: pre;"> </SPAN>java.lang.OutOfMemoryError: Java heap space</DIV><DIV style="margin: 0px;">2644:<SPAN class="Apple-tab-span" style="white-space: pre;"> </SPAN>( 42 / 56 ) Importing /demopages/search-demo/example-documents/Alkacon_OpenCms_6_Business.pdf ... Exception while calling method "importModulesFromSetupBean".</DIV><DIV>------------------------------<BR><DIV> <SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;"><SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;"><DIV><BR class="khtml-block-placeholder"></DIV><DIV>As you can see on line 2645 it says (java.lang.OutOfMemoryError: Java heap space) it is giving an out of memory error. checking around, it seems that this is supposed to be a mySQL limitation, where you should make the <FONT class="Apple-style-span" face="Courier" size="3"><SPAN class="Apple-style-span" style="font-size: 13px;">max_allowed_packet larger around 16MB, but usually that error happen when trying to import a large module or files into opencms after installation, also I could not find any reference to it in connection with PostgreSQL!</SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" face="Courier" size="3"><SPAN class="Apple-style-span" style="font-size: 13px;"><BR class="khtml-block-placeholder"></SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" face="Courier" size="3"><SPAN class="Apple-style-span" style="font-size: 13px;">Even though, in the setup output it says the setup is finished and all is fine, when you do try to go to opencms/index.jsp it is not found, and a lot of the pages naturally are not found either, since the setup cut off before it installed them all.</SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" face="Courier" size="3"><SPAN class="Apple-style-span" style="font-size: 13px;"><BR class="khtml-block-placeholder"></SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" face="Courier" size="3"><SPAN class="Apple-style-span" style="font-size: 13px;">Has anybody encountered this problem? any suggestions, to how to go around it and fix it?</SPAN></FONT></DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>I appreciate any help you can give,</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Relevant environment setup:</DIV><DIV>OSX 10.4.6 (powePC)</DIV><DIV>Tomcat 5.5.17</DIV><DIV>PostgreSQL 8.1.4</DIV><DIV>OpenCms 6.2.1</DIV><DIV>Physical memory : 1GB </DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Cheers,</DIV><DIV>Gaith</DIV><DIV>-----------------------------------</DIV><DIV>Gaith Bader</DIV><DIV style="margin: 0px;">Computer Systems Officer</DIV><DIV style="margin: 0px;">School of Computer Science and Engineering</DIV><DIV style="margin: 0px;">The University of New South Wales</DIV><DIV>-----------------------------------</DIV><BR class="Apple-interchange-newline"></SPAN></SPAN> </DIV><DIV><BR class="khtml-block-placeholder"></DIV></DIV><DIV><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 target="_blank" href="http://lists.opencms.org/mailman/listinfo/opencms-dev">http://lists.opencms.org/mailman/listinfo/opencms-dev</A></DIV></DIV><BR></DIV></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">_______________________________________________</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">This mail is sent to you from the opencms-dev mailing list</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">To change your list options, or to unsubscribe from the list, please visit</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="http://lists.opencms.org/mailman/listinfo/opencms-dev">http://lists.opencms.org/mailman/listinfo/opencms-dev</A></DIV> </BLOCKQUOTE></DIV><BR></DIV></BODY></HTML>