jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Oschwald <r...@symentis.com>
Subject JackRabbit 2.0.0 Communications link failure
Date Thu, 11 Nov 2010 09:15:38 GMT
Hi folks,

I use JackRabbit 2.0.0-core in one of my Spring projects with MySQL. 
I get the following messages if I do not use the repository for a longer time:

ERROR org.apache.jackrabbit.core.persistence.bundle.ConnectionRecoveryManager - could not
execute statement, reason: Communications link failure
The last packet successfully received from the server was 31,174,813 milliseconds ago.  The
last packet sent successfully to the server was 0 milliseconds ago., state/code: 08S01/0

and after a while:
ERROR org.apache.jackrabbit.core.persistence.bundle.ConnectionRecoveryManager - could not
execute statement, reason: The last packet successfully received from the server was 39,618,240
milliseconds ago.  The last packet sent successfully to the server was 39,618,240 milliseconds
ago. is longer than the server configured value of 'wait_timeout'. You should consider either
expiring and/or testing connection validity before use in your application, increasing the
server configured values for client timeouts, or using the Connector/J connection property
'autoReconnect=true' to avoid this problem., state/code: 08S01/0

I read few notes on the internet, some of them are really scaring saying the repository might
be corrupted.

So I exported/imported the repository to a new deployment but receive exactly the same messages.
In my app, I do not recognize any problems.

Here is my repository.xml file. Maybe I got a configuration problem?

<Repository>
    <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
      <param name="path" value="/jcr_repo/content/repository"/>
    </FileSystem>

    <DataStore class="org.apache.jackrabbit.core.data.FileDataStore">
  	  <param name="path" value="/jcr_repo/content/repository/datastore"/>
	</DataStore>

    <Security appName="Jackrabbit">
        <SecurityManager class="org.apache.jackrabbit.core.security.simple.SimpleSecurityManager"
workspaceName="security">
        </SecurityManager>

        <AccessManager class="org.apache.jackrabbit.core.security.simple.SimpleAccessManager">
        </AccessManager>

        <LoginModule class="org.apache.jackrabbit.core.security.simple.SimpleLoginModule">
           <param name="anonymousId" value="anonymous"/>
           <param name="adminId" value="xxx"/>
        </LoginModule>
    </Security>

    <Workspaces rootPath="/jcr_repo/content/workspaces" defaultWorkspace="default"/>
    
    <Workspace name="${wsp.name}">
        <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
            <param name="path" value="${wsp.home}"/>
        </FileSystem>

	<PersistenceManager class="org.apache.jackrabbit.core.persistence.bundle.MySqlPersistenceManager">
	      <param name="driver" value="com.mysql.jdbc.Driver" />
	      <param name="url" value="jdbc:mysql://localhost:3306/myapp_jcr" />
	      <param name="schema" value="mysql"/><!-- db type -->
	      <param name="user" value="yyy"/>
	      <param name="password" value="ZZZ" />
	      <param name="schemaObjectPrefix" value="${wsp.name}_" />
	      <param name="externalBLOBs" value="true" /> <!-- store binary data in filesystem
-->
	</PersistenceManager>

        <SearchIndex class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
            <param name="path" value="${wsp.home}/index"/>
            <param name="supportHighlighting" value="true"/>
        </SearchIndex>
    </Workspace>

    <Versioning rootPath="/jcr_repo/content/version">
        <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
            <param name="path" value="/jcr_repo/content/version" />
        </FileSystem>

	<PersistenceManager class="org.apache.jackrabbit.core.persistence.bundle.MySqlPersistenceManager">
              <param name="driver" value="com.mysql.jdbc.Driver" />
  	      <param name="url" value="jdbc:mysql://localhost:3306/myapp_jcr" />
  	      <param name="user" value="yyy"/>
  	      <param name="password" value="ZZZ" />
              <param name="schemaObjectPrefix" value="version_" />
	</PersistenceManager>
    </Versioning>

    <SearchIndex class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
        <param name="path" value="/jcr_repo/content/repository/index"/>
        <param name="supportHighlighting" value="true"/>
    </SearchIndex>
</Repository>
Mime
View raw message