Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@jackrabbit.apache.org
MIME-Version: 1.0
Message-ID: <trinity-8aa7e7e9-fc58-4275-8537-b18b31a984ed-1474026168304@3capp-webde-bs53>
From: ZeroCool86@web.de
To: users@jackrabbit.apache.org
Cc: kishore.ohal@lrn.com
Subject: Re: JcrMappingException: Could not create node - Lock wait timeout
 exceeded; try restarting transaction Help Needed
Content-Type: text/plain; charset=UTF-8
Date: Fri, 16 Sep 2016 13:42:48 +0200
Importance: normal
Sensitivity: Normal
In-Reply-To: <9770f970-faee-6b66-74b4-46437eb740f7@dig.de>
References: <8EAE81C762E74E4F89EB0E3EED902B4CAA02BE82@MUM2K8MBX01.corp.lrn.com>,
 <9770f970-faee-6b66-74b4-46437eb740f7@dig.de>
Content-Transfer-Encoding: quoted-printable
archived-at: Fri, 16 Sep 2016 11:43:04 -0000

Hi,
=20
we set our journal in a separate DB to reduce the risk of Lock Problems du=
e our normal Content Databases=2E We faced the same problem when we use the=
 journal and content in same database due lot of revisions in a cluster env=
ironment=2E The Journal Revision Updates blocked our normal read/write cont=
ent Tasks=2E
=20
Regards, Michael
=20
=C2=A0

-------- Weitergeleitete Nachricht --------
Betreff:JcrMappingException: Could not create node - Lock wait timeout exc=
eeded; try restarting transaction Help Needed
Datum:Wed, 14 Sep 2016 17:44:09 +0000
Von:Kishore Ohal <kishore=2Eohal@lrn=2Ecom>[kishore=2Eohal@lrn=2Ecom]
Antwort an:users@jackrabbit=2Eapache=2Eorg[users@jackrabbit=2Eapache=2Eorg=
]
An:users@jackrabbit=2Eapache=2Eorg[users@jackrabbit=2Eapache=2Eorg] <users=
@jackrabbit=2Eapache=2Eorg>[users@jackrabbit=2Eapache=2Eorg] =C2=A0
Hi ,

While performing database operations from our application we are getting b=
elow error(using Apache Jackrabbit 2=2E8=2E2 and MYSQL)

Caused by: org=2Ejcrom=2EJcrMappingException: Could not create node
        at org=2Ejcrom=2Edao=2EAbstractJcrDAO=2Ecreate(AbstractJcrDAO=2Eja=
va:337)

Caused by: javax=2Ejcr=2ERepositoryException: org=2Eapache=2Ejackrabbit=2E=
core=2Estate=2EItemStateException: Unable to create log entry: Unable to lo=
ck global revision table=2E
        at org=2Eapache=2Ejackrabbit=2Ecore=2Eversion=2EInternalVersionMan=
agerBase=2EinternalCreateVersionHistory(InternalVersionManagerBase=2Ejava:4=
61)

Caused by: org=2Eapache=2Ejackrabbit=2Ecore=2Estate=2EItemStateException: =
Unable to create log entry: Unable to lock global revision table=2E
        at org=2Eapache=2Ejackrabbit=2Ecore=2Estate=2ESharedItemStateManag=
er$Update=2Ebegin(SharedItemStateManager=2Ejava:575)

Caused by: org=2Eapache=2Ejackrabbit=2Ecore=2Ecluster=2EClusterException: =
Unable to create log entry: Unable to lock global revision table=2E
        at org=2Eapache=2Ejackrabbit=2Ecore=2Ecluster=2EClusterNode$Worksp=
aceUpdateChannel=2EupdateCreated(ClusterNode=2Ejava:639)
        at org=2Eapache=2Ejackrabbit=2Ecore=2Estate=2ESharedItemStateManag=
er$Update=2Ebegin(SharedItemStateManager=2Ejava:573)


Caused by: org=2Eapache=2Ejackrabbit=2Ecore=2Ejournal=2EJournalException: =
Unable to lock global revision table=2E
        at org=2Eapache=2Ejackrabbit=2Ecore=2Ejournal=2EDatabaseJournal=2E=
doLock(DatabaseJournal=2Ejava:495)
        at org=2Eapache=2Ejackrabbit=2Ecore=2Ejournal=2EAbstractJournal=2E=
internalLockAndSync(AbstractJournal=2Ejava:317)

Caused by: java=2Esql=2ESQLException: Lock wait timeout exceeded; try rest=
arting transaction
        at com=2Emysql=2Ejdbc=2ESQLError=2EcreateSQLException(SQLError=2Ej=
ava:1084)
        at com=2Emysql=2Ejdbc=2EMysqlIO=2EcheckErrorPacket(MysqlIO=2Ejava:=
4232)
        at com=2Emysql=2Ejdbc=2EMysqlIO=2EcheckErrorPacket(MysqlIO=2Ejava:=
4164)


mysql> show open tables where in_use>0;
+--------------+-------------------------+--------+-------------+
| Database     | Table                   | In_use | Name_locked |
+--------------+-------------------------+--------+-------------+
| courseauthor | JOURNAL_GLOBAL_REVISION |      1 |           0 |
+--------------+-------------------------+--------+-------------+
1 row in set (0=2E00 sec)

processlist
| Query       |    18 | Searching rows for update                         =
                    | update JOURNAL_GLOBAL_REVISION set REVISION_ID =3D RE=
VISION_ID + 1 |


mysql> SELECT @@GLOBAL=2Etx_isolation, @@tx_isolation, @@session=2Etx_isol=
ation;
+-----------------------+-----------------+------------------------+
| @@GLOBAL=2Etx_isolation | @@tx_isolation  | @@session=2Etx_isolation |
+-----------------------+-----------------+------------------------+
| REPEATABLE-READ       | REPEATABLE-READ | REPEATABLE-READ        |
+-----------------------+-----------------+------------------------+
1 row in set (0=2E00 sec)


mysql> SELECT @@GLOBAL=2Etx_isolation, @@tx_isolation, @@session=2Etx_isol=
ation;
+-----------------------+-----------------+------------------------+
| @@GLOBAL=2Etx_isolation | @@tx_isolation  | @@session=2Etx_isolation |
+-----------------------+-----------------+------------------------+
| REPEATABLE-READ       | REPEATABLE-READ | REPEATABLE-READ        |
+-----------------------+-----------------+------------------------+
1 row in set (0=2E00 sec)

It will a great help if can give a solution as it is stopping our applicat=
ion=2E

Regards,
Kishore