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 msl...@email.cz ---------- Původní zpráva ---------- Od: tessa <tm.lus...@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."
