Return-Path: 
 <users-return-5446-apmail-jackrabbit-users-archive=jackrabbit.apache.org@jackrabbit.apache.org>
Delivered-To: apmail-jackrabbit-users-archive@locus.apache.org
Received: (qmail 89003 invoked from network); 14 Nov 2007 05:12:21 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 14 Nov 2007 05:12:21 -0000
Received: (qmail 96639 invoked by uid 500); 14 Nov 2007 05:12:08 -0000
Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org
Received: (qmail 96616 invoked by uid 500); 14 Nov 2007 05:12:08 -0000
Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@jackrabbit.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@jackrabbit.apache.org>
List-Post: <mailto:users@jackrabbit.apache.org>
List-Id: <users.jackrabbit.apache.org>
Reply-To: users@jackrabbit.apache.org
Delivered-To: mailing list users@jackrabbit.apache.org
Received: (qmail 96607 invoked by uid 99); 14 Nov 2007 05:12:08 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 13 Nov 2007 21:12:08 -0800
X-ASF-Spam-Status: No, hits=2.0 required=10.0
	tests=HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of CBielen@comcastnets.com
 designates 208.78.120.142 as permitted sender)
Received: from [208.78.120.142] (HELO smtp02.comcastnets.com) (208.78.120.142)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 14 Nov 2007 05:12:11 +0000
X-IronPort-AV: E=Sophos;i="4.21,413,1188802800";
   d="scan'208,217";a="93859"
Received: from unknown (HELO LA1-CNS-FE-52.CNS.COMCASTNETS.COM) ([10.7.1.38])
  by smtp02.comcastnets.com with ESMTP; 13 Nov 2007 21:12:31 -0800
Received: from LA-CNS-EXCH.CNS.COMCASTNETS.COM ([10.7.1.51]) by
 LA1-CNS-FE-52.CNS.COMCASTNETS.COM with Microsoft SMTPSVC(6.0.3790.3959);
	 Tue, 13 Nov 2007 21:11:50 -0800
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C8267C.DC8C2827"
Subject: Error When Running consistencyCheck or Rebuilding Indexes.
Date: Tue, 13 Nov 2007 21:11:49 -0800
Message-ID: 
 <B07E9D0550FBCD438DF945950E8FC67E1649E1@LA-CNS-EXCH.CNS.COMCASTNETS.COM>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Error When Running consistencyCheck or Rebuilding Indexes.
Thread-Index: AcgmfNx7XJ6Q/n30RKm9sm3C1hZqJA==
From: "Colin Bielen" <CBielen@comcastnets.com>
To: <users@jackrabbit.apache.org>
X-OriginalArrivalTime: 14 Nov 2007 05:11:50.0457 (UTC)
 FILETIME=[DCEFEA90:01C8267C]
X-Virus-Checked: Checked by ClamAV on apache.org

------_=_NextPart_001_01C8267C.DC8C2827
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi group. I have a content import/export related issue that's stumping =
me:=20

We've written a jackrabbit importer that does a node-by-node system view =
export of approximately 200k content items from a source JCR in to an =
jboss-embedded Jackrabbit 1.3.3 repository using the Derby Bundle =
PersistenceManager.

The import seems to run and complete OK, and the jackrabbit repository =
appears to store/read/query the content correctly accross multiple =
expected (and unexpected) restarts.=20

However, when we delete the content indexes (or even just set the PM =
"consistencyCheck" option to "true") we get the following error followed =
by a failure to start the repository:

2007-11-09 20:25:41,836 ERROR =
[org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager=
] Error in bundle
ERROR XJ073: The data in this BLOB or CLOB is no longer available.  The =
BLOB/CLOB's transaction may be committed, or its connection is closed.
	at org.apache.derby.iapi.error.StandardException.newException(Unknown =
Source)
	at org.apache.derby.impl.jdbc.EmbedBlob.<init>(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedResultSet.getBlob(Unknown Source)
	at =
org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.=
checkConsistency(BundleDbPersistenceManager.java:693)
	at =
org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.=
init(BundleDbPersistenceManager.java:571)
	at =
org.apache.jackrabbit.core.persistence.bundle.DerbyPersistenceManager.ini=
t(DerbyPersistenceManager.java:265)
	at =
org.apache.jackrabbit.core.RepositoryImpl.createPersistenceManager(Reposi=
toryImpl.java:1117)
	at =
org.apache.jackrabbit.core.RepositoryImpl.access$600(RepositoryImpl.java:=
99)
	at =
org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.initialize(Reposi=
toryImpl.java:1695)
	at =
org.apache.jackrabbit.core.RepositoryImpl.initWorkspace(RepositoryImpl.ja=
va:540)
	at =
org.apache.jackrabbit.core.RepositoryImpl.initStartupWorkspaces(Repositor=
yImpl.java:379)
	at =
org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:286)=

	at =
org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:521)=

	at =
org.apache.jackrabbit.jca.JCARepositoryManager$Reference.create(JCAReposi=
toryManager.java:167)
	at =
org.apache.jackrabbit.jca.JCARepositoryManager.createRepository(JCAReposi=
toryManager.java:75)
	at =
org.apache.jackrabbit.jca.JCAManagedConnectionFactory.createRepository(JC=
AManagedConnectionFactory.java:289)
	at =
org.apache.jackrabbit.jca.JCAManagedConnectionFactory.createConnectionFac=
tory(JCAManagedConnectionFactory.java:124)
	at =
org.jboss.resource.connectionmanager.ConnectionFactoryBindingService.crea=
teConnectionFactory(ConnectionFactoryBindingService.java:128)
	at =
org.jboss.resource.connectionmanager.ConnectionFactoryBindingService.star=
tService(ConnectionFactoryBindingService.java:65)
	at =
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSuppo=
rt.java:289)
	at =
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanS=
upport.java:245)
	at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)


Has anyone else come accross this issue?  Our initial suspicion was some =
sort of database corruption but when we comment out the  <SearchIndex>=20
declaration from the workspace.xml the repository starts up fine and all =
the non-query related functions seem to work as expected.=20
We also did a node walk of the entire repository to try and flush out =
any corrupt nodes but couldn't find any and all the content appeared =
correct. =20

Any advice or insight as to what's going on would be appreciated.

Thanks!

-Colin


P.S. Here are the persistence manager options we're using:=20

<PersistenceManager =
class=3D"org.apache.jackrabbit.core.persistence.bundle.DerbyPersistenceMa=
nager">
           <param name=3D"url" =
value=3D"jdbc:derby:${wsp.home}/db;create=3Dtrue"/>
           <param name=3D"schemaObjectPrefix" value=3D"${wsp.name}_"/>
           <param name=3D"consistencyCheck" value=3D"true"/>
           <param name=3D"consistencyFix" value=3D"true"/>
           <param name=3D"derbyStorageInitialPages" value=3D"16"/>
           <param name=3D"derbyStorageMinimumRecordSize" =
value=3D"8192"/>
           <param name=3D"derbyStoragePageCacheSize" value=3D"1024"/>
           <param name=3D"derbyStoragePageReservedSpace" value=3D"20"/>
           <param name=3D"derbyStoragePageSize" value=3D"16384"/>
</PersistenceManager>


------_=_NextPart_001_01C8267C.DC8C2827--