Return-Path: 
 <users-return-19370-apmail-jackrabbit-users-archive=jackrabbit.apache.org@jackrabbit.apache.org>
X-Original-To: apmail-jackrabbit-users-archive@minotaur.apache.org
Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id AA7CBE199
	for <apmail-jackrabbit-users-archive@minotaur.apache.org>;
 Fri, 25 Jan 2013 15:57:43 +0000 (UTC)
Received: (qmail 2263 invoked by uid 500); 25 Jan 2013 15:57:43 -0000
Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org
Received: (qmail 1948 invoked by uid 500); 25 Jan 2013 15:57:41 -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 1906 invoked by uid 99); 25 Jan 2013 15:57:40 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 25 Jan 2013 15:57:40 +0000
X-ASF-Spam-Status: No, hits=2.2 required=5.0
	tests=HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: local policy)
Received: from [80.156.216.33] (HELO ms-01.signal-iduna.de) (80.156.216.33)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 25 Jan 2013 15:57:35 +0000
Received: from app300970.system.local (app300970.system.local [172.19.11.40])
	by ms-01.signal-iduna.de (8.14.5/8.14.5) with ESMTP id r0PFv8wQ030379
	for <users@jackrabbit.apache.org>; Fri, 25 Jan 2013 16:57:08 +0100
In-Reply-To: 
 <OF84FDE8AE.3B47DE01-ONC1257AF7.003F208D-C1257AF7.0051114F@signal-iduna.de>
To: users@jackrabbit.apache.org
Subject: Antwort: bad performance in a clustered environment under heavy load
MIME-Version: 1.0
X-KeepSent: 53C39691:9A2BB067-C1257AFE:00494541;
 type=4; name=$KeepSent
X-Mailer: Lotus Notes Release 7.0.4 March 23, 2009
From: Detlev.Zuehlke@signal-iduna.de
Message-ID: 
 <OF53C39691.9A2BB067-ONC1257AFE.00494541-C1257AFE.0057A09C@signal-iduna.de>
Date: Fri, 25 Jan 2013 16:57:07 +0100
X-MIMETrack: Serialize by Router on HMB00N70/Signal-Iduna at 25.01.2013
 16:57:08,
	Serialize complete at 25.01.2013 16:57:08
Content-Type: multipart/alternative;
 boundary="=_alternative 0057A099C1257AFE_="
X-Virus-Checked: Checked by ClamAV on apache.org

--=_alternative 0057A099C1257AFE_=
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello all,

our database admins fount a bottleneck and tried to remove it. They=20
discovered that the database serves was forced to create the files for the=
=20
transaction log too frequently and increased the maximum size of these=20
files.
The performance is much better after this.=20

Mit freundlichen Gr=FC=DFen

Detlev Z=FChlke

SIGNAL IDUNA Gruppe
AES5-97350
Neue Rabenstra=DFe 15-19
20354 Hamburg

Tel.:    (040) 4124-2954
Fax:    (040) 4124-4902954
email: detlev.zuehlke@signal-iduna.de



Detlev.Zuehlke@signal-iduna.de=20
18.01.2013 15:46
Bitte antworten an
users@jackrabbit.apache.org


An
users@jackrabbit.apache.org
Kopie

Thema
bad performance in a clustered environment under heavy load






Hello all,

we experience a problem with jackrabbit (Version 2.2.5) in a clustered=20
environment.

The Situation:
We are running a webaplication in a clustered environment (12 nodes,=20
WebSphere Platform 7.0.0.25) and are using the deployment model "Shared=20
J2EE Resource".

So in fact we have a jackrabbit cluster with 12 nodes.

We use a DB2 UDB as persistent storage with the following configuration:
    <DataSources>
        <DataSource name=3D"ds1">
            <param name=3D"driver" value=3D"com.ibm.db2.jcc.DB2Driver"/>
            <param name=3D"url" value=3D"jdbc:db2://xxxxxxxxxxxxxxxxx"/>
            <param name=3D"user" value=3D"xxxxxxxxxxxxx"/>
            <param name=3D"password" value=3D"xxxxxx"/>
            <param name=3D"databaseType" value=3D"db2"/>
            <param name=3D"maxPoolSize" value=3D"80"/>
        </DataSource>
    </DataSources>

    <FileSystem class=3D"org.apache.jackrabbit.core.fs.db.DbFileSystem">
        <param name=3D"dataSourceName" value=3D"ds1"/>
        <param name=3D"schemaObjectPrefix" value=3D"J_R_FS_"/>
    </FileSystem>

    <DataStore class=3D"org.apache.jackrabbit.core.data.db.DbDataStore">
        <param name=3D"dataSourceName" value=3D"ds1"/>
        <param name=3D"schemaObjectPrefix" value=3D"J_R_"/>
        <param name=3D"minRecordLength" value=3D"1024"/>
        <param name=3D"maxConnections" value=3D"3"/>
        <param name=3D"copyWhenReading" value=3D"true"/>
        <param name=3D"tablePrefix" value=3D""/>
    </DataStore>

    <Workspaces rootPath=3D"${rep.home}/workspaces" defaultWorkspace=3D"blu=
bb"
/>
    <Workspace name=3D"${wsp.name}">
        <FileSystem class=3D
"org.apache.jackrabbit.core.fs.local.LocalFileSystem">
            <param name=3D"path" value=3D"${wsp.home}"/>
        </FileSystem>
        <PersistenceManager class=3D
"org.apache.jackrabbit.core.persistence.pool.BundleDbPersistenceManager">
            <param name=3D"dataSourceName" value=3D"ds1"/>
            <param name=3D"schemaObjectPrefix" value=3D"J_PM_${wsp.name}_"/>
            <param name=3D"databaseType" value=3D"db2"/>
            <param name=3D"bundleCacheSize" value=3D"8"/>
            <param name=3D"consistencyCheck" value=3D"false"/>
            <param name=3D"consistencyFix" value=3D"false"/>
            <param name=3D"minBlobSize" value=3D"4096"/>
            <param name=3D"errorHandling" value=3D""/>
            <param name=3D"blockOnConnectionLoss" value=3D"false"/>
            <param name=3D"schemaCheckEnabled" value=3D"true"/>
        </PersistenceManager>
    </Workspace>

    <Versioning rootPath=3D"${rep.home}/version">
        <FileSystem class=3D
"org.apache.jackrabbit.core.fs.local.LocalFileSystem">
            <param name=3D"path" value=3D"${rep.home}/version"/>
        </FileSystem>
        <PersistenceManager class=3D
"org.apache.jackrabbit.core.persistence.pool.BundleDbPersistenceManager">
            <param name=3D"dataSourceName" value=3D"ds1"/>
            <param name=3D"schemaObjectPrefix" value=3D"J_V_PM_"/>
            <param name=3D"databaseType" value=3D"db2"/>
            <param name=3D"bundleCacheSize" value=3D"8"/>
            <param name=3D"consistencyCheck" value=3D"false"/>
            <param name=3D"consistencyFix" value=3D"false"/>
            <param name=3D"minBlobSize" value=3D"4096"/>
            <param name=3D"errorHandling" value=3D""/>
            <param name=3D"blockOnConnectionLoss" value=3D"false"/>
            <param name=3D"schemaCheckEnabled" value=3D"true"/>
        </PersistenceManager>
    </Versioning>

    <Cluster syncDelay=3D"5">
        <Journal class=3D
"org.apache.jackrabbit.core.journal.DatabaseJournal">
            <param name=3D"dataSourceName" value=3D"ds1"/>
            <param name=3D"revision" value=3D"${rep.home}/revision.log"/>
        </Journal>
    </Cluster>

The clusterId is provided as system.property.
As soon as we provide heavy load on some (max. 4) Jackrabbit-Nodes the=20
Perfomance drops.
It looks like too many locks on tables GLOBAL_REVISION and/or=20
LOCAL_REVISIONS.

The first action we tried is to increase the (very low) value 5 (ms) for=20
the syncDelay up to 800ms (default is 5000ms).
The next action will be to update to the jackrabbit-revision 2.2.13.

Any advice the community can provide will be greatly appreciated.

If you need more detailed Information, please let me know, i will try to=20
provide it.

Also important:=20
We would also like to consult professional support for our problem.
Can you please give advice where we can find professional support for=20
Jackrabbit to get this running?


Best regards,

Detlev Z=FChlke

SIGNAL IDUNA Gruppe
AES5-97350
Neue Rabenstra=DFe 15-19
20354 Hamburg

Tel.:    (040) 4124-2954
Fax:    (040) 4124-4902954
email: detlev.zuehlke@signal-iduna.de



SIGNAL Krankenversicherung a. G., Sitz: Dortmund, HR B 2405, AG Dortmund
IDUNA Vereinigte Lebensversicherung aG f=FCr Handwerk, Handel und Gewerbe,
Sitz: Hamburg, HR B 2740, AG Hamburg
Deutscher Ring Krankenversicherungsverein a.G., Sitz: Hamburg,
HR B 4673, AG Hamburg,
SIGNAL IDUNA Allgemeine Versicherung AG, Sitz: Dortmund, HR B 19108,=20
AG Dortmund
Vorst=E4nde: Reinhold Schulte (Vorsitzender),
Dr. Karl-Josef Bierth, Marlies Hirschberg-Tafel,
Michael Johnigk, Ulrich Leitermann, Michael Petmecky,
Dr. Klaus Sticker, Prof. Dr. Markus Warg=20
Vorsitzender der Aufsichtsr=E4te: G=FCnter Kutz
SIGNAL IDUNA Gruppe Hauptverwaltungen, Internet: www.signal-iduna.de
44121 Dortmund, Hausanschrift: Joseph-Scherer-Str. 3, 44139 Dortmund
20351 Hamburg, Hausanschrift: Neue Rabenstra=DFe 15-19, 20354 Hamburg







SIGNAL Krankenversicherung a. G., Sitz: Dortmund, HR B 2405, AG Dortmund
IDUNA Vereinigte Lebensversicherung aG f=FCr Handwerk, Handel und Gewerbe,
Sitz: Hamburg, HR B 2740, AG Hamburg
Deutscher Ring Krankenversicherungsverein a.G., Sitz: Hamburg,
HR B 4673, AG Hamburg,
SIGNAL IDUNA Allgemeine Versicherung AG, Sitz: Dortmund, HR B 19108,=20
AG Dortmund
Vorst=E4nde: Reinhold Schulte (Vorsitzender),
Dr. Karl-Josef Bierth, Marlies Hirschberg-Tafel,
Michael Johnigk, Ulrich Leitermann, Michael Petmecky,
Dr. Klaus Sticker, Prof. Dr. Markus Warg=20
Vorsitzender der Aufsichtsr=E4te: G=FCnter Kutz
SIGNAL IDUNA Gruppe Hauptverwaltungen, Internet: www.signal-iduna.de
44121 Dortmund, Hausanschrift: Joseph-Scherer-Str. 3, 44139 Dortmund
20351 Hamburg, Hausanschrift: Neue Rabenstra=DFe 15-19, 20354 Hamburg
--=_alternative 0057A099C1257AFE_=--