jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <msl...@email.cz>
Subject Re: Postgres as Persistent Manager causes horrible inconsistency
Date Tue, 29 Jan 2013 14:05:15 GMT
We use 9.2 on our dev environment (for testing) and did not see any 
consistency problem. We use 9.0.x on prod/qa.
We use JBoss 7.1.1 so configuration of Jackrabbit and data source is quite 
different from JBoss 4. We use latest Postgres
JDBC driver postgresql-9.2-1002.jdbc4.jar. Running on SUSE Linux, 64bit or 
Ubuntu 64bit locally.

We store all data (even binary files) in db. We use one datasource for 
everything in repository.xml (filesystem, datastore,
persistencemanager). Datasource is defined in standalone.xml (JBoss 7.1.1) 
as described in https://community.jboss.org/wiki/JackrabbitDeploymentInAS6
AndAS7

Marek

-- 
Marek Slama
mslama@email.cz



---------- Původní zpráva ----------
Od: tessa <tm.lustig@gmail.com>
Datum: 24. 1. 2013
Předmět: Postgres as Persistent Manager causes horrible inconsistency

"dear community,

I was using Jackrabbit 2.4.2 with the embedded DerbyDB during development.
Later i tried to switch to a
PostgreSQL (9.2) for production use. The jackrabbit runs inside a Jboss
4.2.3 server with 2 defined Datasources for jackrabbit (Workspace and
Version PM)

This is the part of repository.xml
------------------------------
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.pool.
PostgreSQLPersistenceManager">





</PersistenceManager>
------------------------------

The application starts perfectly on the first initial startup, bun when
stopping and restarting the jboss server, the repository seams to be
inconsistent.

---------------server.log of Jboss 4.2.3 --------------
03:17:49,566 INFO [STDOUT] 2013-01-24 03:17:49.565 INFO [main]
RepositoryImpl.java:256 Starting repository...
03:17:49,569 INFO [STDOUT] 2013-01-24 03:17:49.568 INFO [main]
LocalFileSystem.java:164 LocalFileSystem initialized at path
/mnt/docstore/hodrepo/repository
03:17:49,718 INFO [STDOUT] 2013-01-24 03:17:49.718 INFO [main]
LocalFileSystem.java:164 LocalFileSystem initialized at path
/mnt/docstore/hodrepo/version
03:17:49,993 INFO [STDOUT] 2013-01-24 03:17:49.992 INFO [main]
ConsistencyCheckerImpl.java:243 version: checked 113 bundles.
03:17:50,028 INFO [STDOUT] 2013-01-24 03:17:50.027 INFO [main]
RepositoryImpl.java:2001 initializing workspace 'default'...
03:17:50,029 INFO [STDOUT] 2013-01-24 03:17:50.028 INFO [main]
LocalFileSystem.java:164 LocalFileSystem initialized at path
/mnt/docstore/hodrepo/workspaces/default
03:17:50,102 INFO [STDOUT] 2013-01-24 03:17:50.101 ERROR [main]
ConsistencyCheckerImpl.java:358 NodeState
'e180fe8f-2936-4657-9de4-ecfa6f974dab' is not referenced by its parent node
'cafebabe-cafe-babe-cafe-babecafebabe'
03:17:50,103 INFO [STDOUT] 2013-01-24 03:17:50.103 INFO [main]
ConsistencyCheckerImpl.java:367 NodeState
'e180fe8f-2936-4657-9de4-ecfa6f974dab' adds itself to its parent node
'cafebabe-cafe-babe-cafe-babecafebabe' with a new name 'b35b5c50'
03:17:50,198 INFO [STDOUT] 2013-01-24 03:17:50.197 INFO [main]
ConsistencyCheckerImpl.java:243 default: checked 82 bundles.
03:17:51,331 INFO [STDOUT] 2013-01-24 03:17:51.330 INFO [main]
SearchIndex.java:570 Running consistency check...
03:17:51,338 INFO [STDOUT] 2013-01-24 03:17:51.337 INFO [main]
ConsistencyCheck.java:158 progress: 10%
03:17:51,343 INFO [STDOUT] 2013-01-24 03:17:51.342 INFO [main]
ConsistencyCheck.java:158 progress: 20%
03:17:51,348 INFO [STDOUT] 2013-01-24 03:17:51.347 INFO [main]
ConsistencyCheck.java:158 progress: 30%
03:17:51,364 INFO [STDOUT] 2013-01-24 03:17:51.363 INFO [main]
ConsistencyCheck.java:158 progress: 40%
03:17:51,669 INFO [STDOUT] 2013-01-24 03:17:51.668 INFO [main]
ConsistencyCheck.java:158 progress: 50%
03:17:51,672 INFO [STDOUT] 2013-01-24 03:17:51.671 INFO [main]
ConsistencyCheck.java:188 progress: 60%
03:17:51,673 INFO [STDOUT] 2013-01-24 03:17:51.672 INFO [main]
ConsistencyCheck.java:188 progress: 70%
03:17:51,674 INFO [STDOUT] 2013-01-24 03:17:51.673 INFO [main]
ConsistencyCheck.java:188 progress: 80%
03:17:51,675 INFO [STDOUT] 2013-01-24 03:17:51.674 INFO [main]
ConsistencyCheck.java:188 progress: 90%
03:17:51,687 INFO [STDOUT] 2013-01-24 03:17:51.687 INFO [main]
ConsistencyCheck.java:188 progress: 100%
03:17:51,688 INFO [STDOUT] 2013-01-24 03:17:51.688 INFO [main]
ConsistencyCheck.java:107 No errors found.
03:17:51,689 INFO [STDOUT] 2013-01-24 03:17:51.688 INFO [main]
SearchIndex.java:592 Index initialized:
/mnt/docstore/hodrepo/repository/index Version: 3
03:17:51,841 INFO [STDOUT] 2013-01-24 03:17:51.840 INFO [main]
SearchIndex.java:570 Running consistency check...
03:17:51,848 INFO [STDOUT] 2013-01-24 03:17:51.847 INFO [main]
ConsistencyCheck.java:158 progress: 10%
03:17:51,856 INFO [STDOUT] 2013-01-24 03:17:51.855 INFO [main]
ConsistencyCheck.java:158 progress: 19%
03:17:51,864 INFO [STDOUT] 2013-01-24 03:17:51.863 INFO [main]
ConsistencyCheck.java:158 progress: 29%
03:17:51,872 INFO [STDOUT] 2013-01-24 03:17:51.871 INFO [main]
ConsistencyCheck.java:158 progress: 38%
03:17:51,880 INFO [STDOUT] 2013-01-24 03:17:51.880 INFO [main]
ConsistencyCheck.java:158 progress: 48%
03:17:51,884 INFO [STDOUT] 2013-01-24 03:17:51.884 INFO [main]
ConsistencyCheck.java:188 progress: 60%
03:17:51,886 INFO [STDOUT] 2013-01-24 03:17:51.885 INFO [main]
ConsistencyCheck.java:188 progress: 69%
03:17:51,887 INFO [STDOUT] 2013-01-24 03:17:51.886 INFO [main]
ConsistencyCheck.java:188 progress: 79%
03:17:51,888 INFO [STDOUT] 2013-01-24 03:17:51.887 INFO [main]
ConsistencyCheck.java:188 progress: 88%
03:17:51,889 INFO [STDOUT] 2013-01-24 03:17:51.889 INFO [main]
ConsistencyCheck.java:188 progress: 98%
03:17:51,890 INFO [STDOUT] 2013-01-24 03:17:51.889 INFO [main]
ConsistencyCheck.java:107 No errors found.
03:17:51,890 INFO [STDOUT] 2013-01-24 03:17:51.890 INFO [main]
SearchIndex.java:592 Index initialized:
/mnt/docstore/hodrepo/workspaces/default/index Version: 3
03:17:51,891 INFO [STDOUT] 2013-01-24 03:17:51.891 INFO [main]
RepositoryImpl.java:2005 workspace 'default' initialized
03:17:51,898 INFO [STDOUT] 2013-01-24 03:17:51.898 INFO [main]
RepositoryImpl.java:452 SecurityManager = class
org.apache.jackrabbit.core.DefaultSecurityManager
03:17:51,899 INFO [STDOUT] 2013-01-24 03:17:51.898 INFO [main]
RepositoryImpl.java:2001 initializing workspace 'security'...
03:17:51,900 INFO [STDOUT] 2013-01-24 03:17:51.899 INFO [main]
LocalFileSystem.java:164 LocalFileSystem initialized at path
/mnt/docstore/hodrepo/workspaces/security
03:17:51,959 INFO [STDOUT] 2013-01-24 03:17:51.958 ERROR [main]
ConsistencyCheckerImpl.java:358 NodeState
'e180fe8f-2936-4657-9de4-ecfa6f974dab' is not referenced by its parent node
'cafebabe-cafe-babe-cafe-babecafebabe'
03:17:51,960 INFO [STDOUT] 2013-01-24 03:17:51.959 INFO [main]
ConsistencyCheckerImpl.java:367 NodeState
'e180fe8f-2936-4657-9de4-ecfa6f974dab' adds itself to its parent node
'cafebabe-cafe-babe-cafe-babecafebabe' with a new name '8709b4e5'
03:17:52,092 INFO [STDOUT] 2013-01-24 03:17:52.092 INFO [main]
ConsistencyCheckerImpl.java:243 security: checked 82 bundles.
03:17:52,194 INFO [STDOUT] 2013-01-24 03:17:52.193 INFO [main]
SearchIndex.java:570 Running consistency check...
03:17:52,201 INFO [STDOUT] 2013-01-24 03:17:52.201 INFO [main]
ConsistencyCheck.java:158 progress: 32%
03:17:52,204 INFO [STDOUT] 2013-01-24 03:17:52.203 INFO [main]
ConsistencyCheck.java:158 progress: 39%
03:17:52,206 INFO [STDOUT] 2013-01-24 03:17:52.205 INFO [main]
ConsistencyCheck.java:158 progress: 47%
03:17:52,208 INFO [STDOUT] 2013-01-24 03:17:52.207 INFO [main]
ConsistencyCheck.java:188 progress: 82%
03:17:52,208 INFO [STDOUT] 2013-01-24 03:17:52.208 INFO [main]
ConsistencyCheck.java:188 progress: 89%
03:17:52,209 INFO [STDOUT] 2013-01-24 03:17:52.209 INFO [main]
ConsistencyCheck.java:188 progress: 97%
03:17:52,210 INFO [STDOUT] 2013-01-24 03:17:52.209 INFO [main]
ConsistencyCheck.java:107 No errors found.
03:17:52,210 INFO [STDOUT] 2013-01-24 03:17:52.210 INFO [main]
SearchIndex.java:592 Index initialized:
/mnt/docstore/hodrepo/workspaces/security/index Version: 3
03:17:52,211 INFO [STDOUT] 2013-01-24 03:17:52.210 INFO [main]
RepositoryImpl.java:2005 workspace 'security' initialized
03:17:52,212 INFO [STDOUT] 2013-01-24 03:17:52.212 INFO [main]
DefaultSecurityManager.java:172 init: use Repository Login-Configuration
for Jackrabbit
03:17:52,255 INFO [STDOUT] 2013-01-24 03:17:52.253 ERROR [main]
RepositoryImpl.java:366 failed to start Repository: failed to
build path of e180fe8f-2936-4657-9de4-ecfa6f974dab:
cafebabe-cafe-babe-cafe-babecafebabe has no child entry for
e180fe8f-2936-4657-9de4-ecfa6f974dab
javax.jcr.ItemNotFoundException: failed to build path of
e180fe8f-2936-4657-9de4-ecfa6f974dab: cafebabe-cafe-babe-cafe-babecafebabe
has no child entry for e180fe8f-2936-4657-9de4-ecfa6f974dab
----------------------------------------------------

between initial start and the restart, there are only 15 minutes. Could it
be a problem of the postgresql server version? 
Is 9.2 too new? 
Should i step back to an older version of jackrabbit?

I am really looking forward for your help or any hint :-)

kind regards

Tessa



--
View this message in context: http://jackrabbit.510166.n4.nabble.com/
Postgres-as-Persistent-Manager-causes-horrible-inconsistency-tp4657460.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com."
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message