cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hugi Thordarson <h...@karlmenn.is>
Subject MariaDB: "Table was not locked with LOCK TABLES" (mutithreaded code)
Date Wed, 02 Mar 2016 12:22:58 GMT
Hi all,
when I’m running multithreaded code (at least I think that’s the trigger, since this seems
to mostly happen when I have a long running background task talking to the DB in a different
thread) I tend to get these errors:

Table ‘…' was not locked with LOCK TABLES.

I just wanted to check if anyone else has encountered this issue, before I start digging in.
Google has some suggestions for how to fix this when writing plain SQL, but I’m not sure
how to handle locking when using Cayenne.

Here’s a stack trace:

Exception in thread "pool-1-thread-1" org.apache.cayenne.CayenneRuntimeException: [v.4.0.M3-SNAPSHOT
Oct 12 2015 13:17:37] Commit Exception
	at org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:776)
	at org.apache.cayenne.access.DataContext.commitChanges(DataContext.java:693)
	at strimillinn.core.dictionary.DictionaryListener.handleEntryChange(DictionaryListener.java:129)
	at strimillinn.core.dictionary.DictionaryPopulator.lambda$null$4(DictionaryPopulator.java:55)
	at strimillinn.core.dictionary.DictionaryPopulator$$Lambda$8/21061839.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.BatchUpdateException: Table 'fd_commit' was not locked with LOCK TABLES
	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1819)
	at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1281)
	at org.apache.cayenne.access.jdbc.BatchAction.runAsBatch(BatchAction.java:125)
	at org.apache.cayenne.access.jdbc.BatchAction.performAction(BatchAction.java:90)
	at org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAction.java:97)
	at org.apache.cayenne.access.DataNode.performQueries(DataNode.java:306)
	at org.apache.cayenne.access.DataDomainFlushAction.runQueries(DataDomainFlushAction.java:234)
	at org.apache.cayenne.access.DataDomainFlushAction.flush(DataDomainFlushAction.java:155)
	at org.apache.cayenne.access.DataDomain.onSyncFlush(DataDomain.java:643)
	at org.apache.cayenne.access.DataDomain$2.perform(DataDomain.java:608)
	at org.apache.cayenne.access.DataDomain$2.perform(DataDomain.java:605)
	at org.apache.cayenne.tx.DefaultTransactionManager.performInTransaction(DefaultTransactionManager.java:45)
	at org.apache.cayenne.access.DataDomain.onSyncNoFilters(DataDomain.java:605)
	at org.apache.cayenne.access.DataDomain$DataDomainSyncFilterChain.onSync(DataDomain.java:760)
	at org.apache.cayenne.lifecycle.postcommit.PostCommitFilter.onSync(PostCommitFilter.java:87)
	at org.apache.cayenne.access.DataDomain$DataDomainSyncFilterChain.onSync(DataDomain.java:760)
	at org.apache.cayenne.lifecycle.postcommit.PostCommitFilter.onSync(PostCommitFilter.java:87)
	at org.apache.cayenne.access.DataDomain$DataDomainSyncFilterChain.onSync(DataDomain.java:760)
	at org.apache.cayenne.access.DataDomain.onSync(DataDomain.java:586)
	at org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:744)
	at org.apache.cayenne.access.DataContext.commitChanges(DataContext.java:693)
	at strimillinn.core.db.listeners.CommitListener.onPostCommit(CommitListener.java:43)
	at org.apache.cayenne.lifecycle.postcommit.PostCommitFilter.notifyListeners(PostCommitFilter.java:114)
	at org.apache.cayenne.lifecycle.postcommit.PostCommitFilter.onSync(PostCommitFilter.java:89)
	at org.apache.cayenne.access.DataDomain$DataDomainSyncFilterChain.onSync(DataDomain.java:760)
	at org.apache.cayenne.access.DataDomain.onSync(DataDomain.java:586)
	at org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:744)
	... 7 more
Caused by: java.sql.SQLException: Table 'fd_commit' was not locked with LOCK TABLES
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2535)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1911)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2145)
	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1777)

Cheers,
- hugi


Mime
View raw message