<html><body bgcolor="#FFFFFF">
<p>Hello Christian,<br>
<br>
so it happened again this morning, when I was the first guy to call a page on our intranet-server.<br>
I just get the blueish "500-Server-Error"-page, no details displayed. It says I shall try again in a few minutes.<br>
I checked the opencms and tomcat log-files, but there are no entries from this morning where the incident occured.<br>
<br>
When I wait some 20 seconds or so and press F5 - it starts normally.<br>
<ul>The eviction in opencms.properties is activated with the following entries:<br>
<br>
# connections will be validated by evictor thread<br>
db.pool.default.testWhileIdle=true<br>
<br>
# number of milliseconds to sleep between runs of the evictor thread<br>
# -1 means no idle connection evictor thread will be run<br>
db.pool.default.timeBetweenEvictionRuns=3600000<br>
<br>
# number of connections tested in a run of the evictor thread<br>
db.pool.default.numTestsPerEvictionRun=3<br>
<br>
# minimum amount of time in milliseconds a connection may be idle in the pool before it is eligable for eviction<br>
db.pool.default.minEvictableIdleTime=1800000<br>
<br>
# the query to validate connections<br>
#db.pool.default.testQuery=SELECT STRUCTURE_ID FROM CMS_OFFLINE_STRUCTURE WHERE RESOURCE_PATH = '/'<br>
db.pool.default.testQuery=</ul>
<ul type="disc">
<li>But what entry do I have to choose for the last "#the query to validate connections ..."? What is meaned by the STRUCTURE_ID, respectively, how can I get that ID?<br>
I guess the eviction will work after entering that ID and restarting Tomcat, right???
<li>Do I still have to make a cron job for calling a web-page every hour or so?</ul>
<br>
Where else, besides the opencms- and tomcat-logs could I find error-messages for the error-500 page?<br>
<br>
Thank you<br>
<br>
<br>
Frank Pertack<br>
<br>
<br>
Vater Solution GmbH<br>
Liebigstraße 26<br>
24145 Kiel<br>
<br>
Telefon: +49 431 20084-210<br>
Telefax: +49 431 20084-222<br>
Mobil: +49 151 16353519<br>
mailto: fpertack@vater-gruppe.de<br>
<a href="http://www.vater-gruppe.de">http://www.vater-gruppe.de</a><br>
<br>
Amtsgericht Kiel, HRB 6403 <br>
Geschäftsführer:<br>
Klaus-Hinrich Vater<br>
Michael Wiese<br>
-----<br>
Diese Email enthält ggfs. vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese Email irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Email. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Email sind nicht gestattet.<br>
<br>
<br>
<img width="16" height="16" src="cid:1__=4EBBFF69DFBB01908f9e8a93@vater-gruppe.de" border="0" alt="Inactive hide details for Christian Steinert ---20.07.2009 07:05:56---Christian Steinert wrote: > Frank Pertack wrote:"><font color="#424282">Christian Steinert ---20.07.2009 07:05:56---Christian Steinert wrote: > Frank Pertack wrote:</font><br>
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top"><td width="1%"><img width="96" height="1" src="cid:2__=4EBBFF69DFBB01908f9e8a93@vater-gruppe.de" border="0" alt=""><br>
<font size="2" color="#5F5F5F">Von:</font></td><td width="100%"><img width="1" height="1" src="cid:2__=4EBBFF69DFBB01908f9e8a93@vater-gruppe.de" border="0" alt=""><br>
<font size="2">Christian Steinert <christian_steinert@web.de></font></td></tr>
<tr valign="top"><td width="1%"><img width="96" height="1" src="cid:2__=4EBBFF69DFBB01908f9e8a93@vater-gruppe.de" border="0" alt=""><br>
<font size="2" color="#5F5F5F">An:</font></td><td width="100%"><img width="1" height="1" src="cid:2__=4EBBFF69DFBB01908f9e8a93@vater-gruppe.de" border="0" alt=""><br>
<font size="2">The OpenCms mailing list <opencms-dev@opencms.org></font></td></tr>
<tr valign="top"><td width="1%"><img width="96" height="1" src="cid:2__=4EBBFF69DFBB01908f9e8a93@vater-gruppe.de" border="0" alt=""><br>
<font size="2" color="#5F5F5F">Datum:</font></td><td width="100%"><img width="1" height="1" src="cid:2__=4EBBFF69DFBB01908f9e8a93@vater-gruppe.de" border="0" alt=""><br>
<font size="2">20.07.2009 07:05</font></td></tr>
<tr valign="top"><td width="1%"><img width="96" height="1" src="cid:2__=4EBBFF69DFBB01908f9e8a93@vater-gruppe.de" border="0" alt=""><br>
<font size="2" color="#5F5F5F">Betreff:</font></td><td width="100%"><img width="1" height="1" src="cid:2__=4EBBFF69DFBB01908f9e8a93@vater-gruppe.de" border="0" alt=""><br>
<font size="2">Re: [opencms-dev] server is not reacting after a time of inactivity</font></td></tr>
<tr valign="top"><td width="1%"><img width="96" height="1" src="cid:2__=4EBBFF69DFBB01908f9e8a93@vater-gruppe.de" border="0" alt=""><br>
<font size="2" color="#5F5F5F">Gesendet von:</font></td><td width="100%"><img width="1" height="1" src="cid:2__=4EBBFF69DFBB01908f9e8a93@vater-gruppe.de" border="0" alt=""><br>
<font size="2">opencms-dev-bounces@opencms.org</font></td></tr>
</table>
<hr width="100%" size="2" align="left" noshade style="color:#8091A5; "><br>
<br>
<br>
<font size="4">Christian Steinert wrote: </font>
<ul>
<ul><tt><font size="4">Frank Pertack wrote:<br>
</font></tt>
<ul>
<ul><tt><font size="4">Hello list,<br>
<br>
we have a problem with our opencms intranet server (Tomcat 6.0, java 6,<br>
mysql 5.0.67, opensuse-Linux 11.1).<br>
If after a long time of inactivity somebody calls the web-page of our<br>
intranet, he will initially get a 500-Server-Error, the server doesn't<br>
respond. If he retrys after a while, the start-page is displayed normally.<br>
</font></tt></ul>
</ul>
<tt><font size="4">This is really strange - you need to provide more detail though.<br>
- Look at the apache/tomcat/opencms logs<br>
- which message is shown together with the error?<br>
<br>
</font></tt></ul>
</ul>
<font size="4">P.S. Please also look at my latest response to Brett Sheeran. Maybe you have the same problem like he has and need to activate eviction for the opencms connection pool.<br>
<br>
Kind Regards<br>
Christian</font><tt><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>
</tt><tt><a href="http://lists.opencms.org/mailman/listinfo/opencms-dev">http://lists.opencms.org/mailman/listinfo/opencms-dev</a></tt><br>
</body></html>