Hi, "Willie Vu" <[EMAIL PROTECTED]> writes:
> > 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 do you know, how MySQL locks a database? Does it lock the complete table or just rows or is using some other mechanism to handle concurrent access? Martin --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
