jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mahesh <maahi...@gmail.com>
Subject Database blocks are observed while doing document upload in jackrabbit with 3 cluster nodes.
Date Tue, 13 Dec 2011 06:50:14 GMT
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 &gt;  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.

Mime
View raw message