You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@jackrabbit.apache.org by mahesh <ma...@gmail.com> on 2011/12/13 07:50:14 UTC
Database blocks are observed while doing document upload in
jackrabbit with 3 cluster nodes.
Hi,
We have dms module in our application and we are using jackrabbit for DMS
related operations.
We have 3 clusters in place and using Database journal sync mechanism.
Currently we are facing issue of Database blocks due to large number of
document upload and modification in documents (check-out, check-in).
Because of which user are not able to use DMS functionality until the
database blocks are removed and it usually takes around 30 mins.
Below is the repository.xml that we use in cluster environment.
________________________________________________________________
<?xml version="1.0" encoding="ISO-8859-1"?>
<Repository>
<DataSources>
<DataSource name="dnaDmsPool">
</DataSource>
</DataSources>
<Cluster id="Cluster1">
<Journal
class="org.apache.jackrabbit.core.journal.MSSqlDatabaseJournal">
</Journal>
</Cluster>
<DataStore class="org.apache.jackrabbit.core.data.FileDataStore">
</DataStore>
<FileSystem class="org.apache.jackrabbit.core.fs.db.MSSqlFileSystem">
</FileSystem>
<Security appName="com.axxia.dms">
<AccessManager
class="org.apache.jackrabbit.core.security.simple.SimpleAccessManager"/>
</Security>
<Workspaces rootPath="${rep.home}/workspaces" defaultWorkspace="a"/>
<Workspace name="${wsp.name}">
<FileSystem class="org.apache.jackrabbit.core.fs.db.MSSqlFileSystem">
</FileSystem>
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.pool.MSSqlPersistenceManager">
</PersistenceManager>
<SearchIndex
class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
</SearchIndex>
</Workspace>
<Versioning rootPath="${rep.home}/versions">
<FileSystem class="org.apache.jackrabbit.core.fs.db.MSSqlFileSystem">
</FileSystem>
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.pool.MSSqlPersistenceManager">
</PersistenceManager>
</Versioning>
</Repository>
________________________________________________________________
SQL blocks through profiler.
<blocked-process-report monitorLoop="212092">
<blocked-process>
<process id="process84b4c8" taskpriority="0" logused="0"
waitresource="RID: 9:1:1651466:0" waittime="2062" ownerId="18093814"
transactionname="implicit_transaction"
lasttranstarted="2011-12-13T05:07:34.200" XDES="0xe213348" lockMode="U"
schedulerid="1" kpid="10804" status="suspended" spid="154" sbid="0" ecid="0"
priority="0" transcount="2" lastbatchstarted="2011-12-13T05:07:34.200"
lastbatchcompleted="2011-12-13T05:07:34.200" clientapp="dms"
hostname="Cluster1" hostpid="123" loginname="" isolationlevel="read
committed (2)" xactid="18093814" currentdb="9" lockTimeout="4294967295"
clientoption1="671088672" clientoption2="128058">
<executionStack>
<frame line="1" stmtstart="16"
sqlhandle="0x0200000013087d0e70c4d03fc52efaa06e11c68d0e562668"/>
<frame line="1"
sqlhandle="0x0200000061e9ba2bdd1a481f1001803d4e77cc4f4f2f0b5e"/>
</executionStack>
<inputbuf>
update XX_DMS_JRNL_GLOBAL_REVISION set REVISION_ID = REVISION_ID + 1
</inputbuf>
</process>
</blocked-process>
<blocking-process>
<process status="sleeping" spid="158" sbid="0" ecid="0" priority="0"
transcount="1" lastbatchstarted="2011-12-13T05:07:34.883"
lastbatchcompleted="2011-12-13T05:07:34.910" clientapp="dms"
hostname="Cluster2" hostpid="123" loginname="" isolationlevel="read
committed (2)" xactid="18093795" currentdb="9" lockTimeout="4294967295"
clientoption1="671088672" clientoption2="128058">
<executionStack/>
<inputbuf>
select REVISION_ID, JOURNAL_ID, PRODUCER_ID, REVISION_DATA from
XX_DMS_JRNL_JOURNAL where REVISION_ID > 301810 order by REVISION_ID
</inputbuf>
</process>
</blocking-process>
</blocked-process-report>
<blocked-process-report monitorLoop="182686">
<blocked-process>
<process id="process84ab68" taskpriority="0" logused="0"
waitresource="RID: 9:1:1651466:0" waittime="2343" ownerId="16318105"
transactionname="implicit_transaction"
lasttranstarted="2011-12-12T12:47:07.513" XDES="0x17c77000" lockMode="U"
schedulerid="1" kpid="10408" status="suspended" spid="358" sbid="0" ecid="0"
priority="0" transcount="2" lastbatchstarted="2011-12-12T12:47:07.513"
lastbatchcompleted="2011-12-12T12:47:07.513" clientapp="dms"
hostname="Cluster1" hostpid="123" loginname="" isolationlevel="read
committed (2)" xactid="16318105" currentdb="9" lockTimeout="4294967295"
clientoption1="671088672" clientoption2="128058">
<executionStack>
<frame line="1" stmtstart="16"
sqlhandle="0x0200000013087d0e70c4d03fc52efaa06e11c68d0e562668"/>
<frame line="1"
sqlhandle="0x0200000061e9ba2bdd1a481f1001803d4e77cc4f4f2f0b5e"/>
</executionStack>
<inputbuf>
update XX_DMS_JRNL_GLOBAL_REVISION set REVISION_ID = REVISION_ID + 1
</inputbuf>
</process>
</blocked-process>
<blocking-process>
<process status="suspended" waitresource="RID: 9:1:1651466:0"
waittime="2562" spid="354" sbid="0" ecid="0" priority="0" transcount="2"
lastbatchstarted="2011-12-12T12:47:07.300"
lastbatchcompleted="2011-12-12T12:47:07.293"
clientapp="dna1.4_Testing_01_dms" hostname="Cluster2" hostpid="123"
loginname="" isolationlevel="read committed (2)" xactid="16318004"
currentdb="9" lockTimeout="4294967295" clientoption1="671088672"
clientoption2="128058">
<executionStack>
<frame line="1" stmtstart="16"
sqlhandle="0x0200000013087d0e70c4d03fc52efaa06e11c68d0e562668"/>
<frame line="1"
sqlhandle="0x0200000061e9ba2bdd1a481f1001803d4e77cc4f4f2f0b5e"/>
</executionStack>
<inputbuf>
update AXDNA_DMS_JRNL_GLOBAL_REVISION set REVISION_ID = REVISION_ID + 1
</inputbuf>
</process>
</blocking-process>
</blocked-process-report>
--
View this message in context: http://jackrabbit.510166.n4.nabble.com/Database-blocks-are-observed-while-doing-document-upload-in-jackrabbit-with-3-cluster-nodes-tp4189044p4189044.html
Sent from the Jackrabbit - Dev mailing list archive at Nabble.com.