Connection timed out IO Exceptions
----------------------------------
Key: JCR-1975
URL: https://issues.apache.org/jira/browse/JCR-1975
Project: Jackrabbit Content Repository
Issue Type: Bug
Components: jackrabbit-api, jackrabbit-core, jackrabbit-jcr-commons,
jackrabbit-spi, jackrabbit-spi-commons, jackrabbit-text-extractors
Affects Versions: core 1.4.5
Environment: Linux (CentOs), Oracle XE 10g, Tomcat 6, JDK 1.6,
Magnolia Enterprise 3.6.3, JNDI
Reporter: Edgar Vonk
We are running Jackrabbit 1.4.5 as part of the Magnolia Enterprise CMS. We are
running into Jackrabbit - database connection problems on some occasions. We do
not understand why and when these happen. When they do all we can do is restart
Tomcat (with Magnolia) and then everything seems to run fine again until the
next time this happens.
We have looked into this issue together with Magnolia but have so far failed to
come up with a solution. We have not even been able to reproduce the issue. It
only happens on our production environment (where we have the database server
on a separate machine from our two app servers).
I have also reported this issue on the Magnolia form:
http://www.nabble.com/Using-Oracle-with-a-JNDI-datasource-in-Tomcat-td21114284.html
We are using a JNDI persistence manager set-up. Our Jackrabbit persistence
manager configuration looks as follows:
{code}
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.bundle.OraclePersistenceManager">
<param name="driver" value="javax.naming.InitialContext" />
<param name="url" value="java:comp/env/jdbc/magnolia" />
<param name="schemaObjectPrefix" value="${wsp.name}_" />
<param name="externalBLOBs" value="false" />
</PersistenceManager>
{code}
Our datasource in Tomcat:
{code}
<Resource
name="jdbc/magnolia"
auth="Container"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@//CHANGEME:1521/XEXDB"
username="CHANGEME"
password="CHANGEME"
maxActive="20"
maxIdle="10"
maxWait="-1" />
{code}
In the log files we see:
java.sql.SQLRecoverableException: Io exception: Connection timed out
I will upload the full log file excerpt.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
