> However since
> ever J2EE store has its own connections, there are separate
> SQL transactions started for each store. If the stores share
> the same tables, there could be deadlocks, if the complete
> table is locked. However I would expect, that
> two stores would never access the same rows. So a database,
> which locks only at row level should work fine.
>
> So far I did not find any deadlocks using
> Postgres/OldJDBCAdapter and separate stores for / and /history.
>
I can reproduce the problem with MySQL 4.x using Slide 2.0 Beta 1. The
configuration is simple:
<scope match="/users" store="mysql-users" />
<scope match="/" store="mysql"/>
It will cause the following exception:
09 Mar 2004 11:47:54 - org.apache.slide.store.impl.rdbms.JDBCStore - DEBUG -
Getting current connection for thread Thread[main,5,main]
09 Mar 2004 11:48:45 - org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter -
ERROR - SQL error 1205 on /: General error: Lock wait timeout exceeded; Try
restarting transaction
09 Mar 2004 11:48:45 - org.apache.slide.common.SlideException - DEBUG -
org.apache.slide.common.ServiceAccessException: Service
[EMAIL PROTECTED] access error : General error:
Lock wait timeout exceeded; Try restarting transaction
at
org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter.createException(MySqlRDBMSAd
apter.java:60)
at
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeObject(StandardRDBMS
Adapter.java:197)
at
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeObject(StandardRDBMS
Adapter.java:95)
at
org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.storeObject(AbstractRDBMSSt
ore.java:462)
at
org.apache.slide.store.AbstractStore.storeObject(AbstractStore.java:526)
at
org.apache.slide.store.ExtendedStore.storeObject(ExtendedStore.java:424)
at
org.apache.slide.structure.StructureImpl.store(StructureImpl.java:452)
at
org.apache.slide.structure.StructureImpl.create(StructureImpl.java:347)
at
org.apache.slide.common.XMLUnmarshaller.loadObjectNode(XMLUnmarshaller.java:164)
at
org.apache.slide.common.XMLUnmarshaller.loadObjectNode(XMLUnmarshaller.java:301)
at
org.apache.slide.common.XMLUnmarshaller.unmarshal(XMLUnmarshaller.java:96)
at
org.apache.slide.common.NamespaceAccessTokenImpl.importData(NamespaceAccessToken
Impl.java:267)
at org.apache.slide.common.Namespace.loadBaseData(Namespace.java:775)
at org.apache.slide.common.Domain.initNamespace(Domain.java:814)
at org.apache.slide.common.Domain.init(Domain.java:433)
at org.apache.slide.common.Domain.selfInit(Domain.java:747)
at org.apache.slide.common.Domain.accessNamespace(Domain.java:235)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
