michaeldejong/EveNexus — Issue #20: EveNexus bug report
Author: bugreporter
Created: 2012-01-17 11:47:22+00:00
State: open

*Submitter name:* unknown
*Submitter mail:* unknown

*Bug description:*

*Full log:*

08:46:51.261 17-01-2012 INFO
08:46:51.603 17-01-2012 INFO	Creating Guice injector...
08:46:53.710 17-01-2012 INFO	Preparing exception handler...
08:46:53.711 17-01-2012 INFO	Launching application...
08:46:53.712 17-01-2012 INFO	Reading program settings...
08:46:53.738 17-01-2012 INFO	Establishing database connection...
08:46:55.704 17-01-2012 INFO	Initializing proxy settings...
08:46:55.704 17-01-2012 INFO	Checking database structure consistency...
08:46:57.860 17-01-2012 INFO	Initializing inventory manager...
08:46:58.207 17-01-2012 INFO	Calculating inventory and profits for 190 unprocessed transaction(s)
08:46:58.390 17-01-2012 INFO	Found 175 invalid matches for type: 10213, now de-matching...
08:46:58.601 17-01-2012 WARN	SQL Error: 40001, SQLState: 40001
08:46:58.601 17-01-2012 ERROR	Deadlock detected. The current transaction was rolled back. Details: "
Session #6 (user: ROOT) is waiting to lock PUBLIC.TRANSACTIONS while locking PUBLIC.TRANSACTIONMATCHES (exclusive).
Session #3 (user: ROOT) is waiting to lock PUBLIC.TRANSACTIONMATCHES while locking PUBLIC.TRANSACTIONS (exclusive)."; SQL statement:
delete from transactionmatches where buyTransactionId=? and sellTransactionId=? [40001-160]
08:46:58.601 17-01-2012 WARN	SQL Error: 40001, SQLState: 40001
08:46:58.602 17-01-2012 ERROR	Deadlock detected. The current transaction was rolled back. Details: "
Session #6 (user: ROOT) is waiting to lock PUBLIC.TRANSACTIONS while locking PUBLIC.TRANSACTIONMATCHES (exclusive).
Session #3 (user: ROOT) is waiting to lock PUBLIC.TRANSACTIONMATCHES while locking PUBLIC.TRANSACTIONS (exclusive)."; SQL statement:
delete from transactionmatches where buyTransactionId=? and sellTransactionId=? [40001-160]
08:46:58.611 17-01-2012 ERROR	Could not execute JDBC batch update
org.hibernate.exception.LockAcquisitionException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:107) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:189) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at nl.minicom.evenexus.persistence.interceptor.TransactionalInterceptor.invoke(TransactionalInterceptor.java:43) [EveNexus.exe:na]
at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) [guice-3.0.jar:na]
at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52) [guice-3.0.jar:na]
at nl.minicom.evenexus.inventory.InventoryWorker$$EnhancerByGuice$$5175c1f8.getWalletTransaction() [guice-3.0.jar:na]
at nl.minicom.evenexus.inventory.InventoryWorker.revertMostRecentTransactionsIfRequired(InventoryWorker.java:70) [EveNexus.exe:na]
at nl.minicom.evenexus.inventory.InventoryWorker$$EnhancerByGuice$$5175c1f8.CGLIB$revertMostRecentTransactionsIfRequired$0() [guice-3.0.jar:na]
at nl.minicom.evenexus.inventory.InventoryWorker$$EnhancerByGuice$$5175c1f8$$FastClassByGuice$$cc798a83.invoke() [guice-3.0.jar:na]
at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) [guice-3.0.jar:na]
at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) [guice-3.0.jar:na]
at nl.minicom.evenexus.persistence.interceptor.TransactionalInterceptor.invoke(TransactionalInterceptor.java:40) [EveNexus.exe:na]
at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) [guice-3.0.jar:na]
at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52) [guice-3.0.jar:na]
at nl.minicom.evenexus.inventory.InventoryWorker$$EnhancerByGuice$$5175c1f8.revertMostRecentTransactionsIfRequired() [guice-3.0.jar:na]
at nl.minicom.evenexus.inventory.InventoryWorker.run(InventoryWorker.java:48) [EveNexus.exe:na]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [na:1.6.0_30]
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) [na:1.6.0_30]
at java.util.concurrent.FutureTask.run(Unknown Source) [na:1.6.0_30]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) [na:1.6.0_30]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.6.0_30]
at java.lang.Thread.run(Unknown Source) [na:1.6.0_30]
Caused by: org.h2.jdbc.JdbcBatchUpdateException: Deadlock detected. The current transaction was rolled back. Details: "
Session #6 (user: ROOT) is waiting to lock PUBLIC.TRANSACTIONS while locking PUBLIC.TRANSACTIONMATCHES (exclusive).
Session #3 (user: ROOT) is waiting to lock PUBLIC.TRANSACTIONMATCHES while locking PUBLIC.TRANSACTIONS (exclusive)."; SQL statement:
delete from transactionmatches where buyTransactionId=? and sellTransactionId=? [40001-160]
at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1107) ~[h2-1.3.160.jar:1.3.160]
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
... 25 common frames omitted
08:46:58.613 17-01-2012 ERROR	Could not execute JDBC batch update
org.hibernate.exception.LockAcquisitionException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:107) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:189) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at nl.minicom.evenexus.persistence.interceptor.TransactionalInterceptor.invoke(TransactionalInterceptor.java:43) ~[EveNexus.exe:na]
at nl.minicom.evenexus.inventory.InventoryWorker.revertMostRecentTransactionsIfRequired(InventoryWorker.java:70) [EveNexus.exe:na]
at nl.minicom.evenexus.persistence.interceptor.TransactionalInterceptor.invoke(TransactionalInterceptor.java:40) ~[EveNexus.exe:na]
at nl.minicom.evenexus.inventory.InventoryWorker.run(InventoryWorker.java:48) [EveNexus.exe:na]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [na:1.6.0_30]
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) [na:1.6.0_30]
at java.util.concurrent.FutureTask.run(Unknown Source) [na:1.6.0_30]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) [na:1.6.0_30]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.6.0_30]
at java.lang.Thread.run(Unknown Source) [na:1.6.0_30]
Caused by: org.h2.jdbc.JdbcBatchUpdateException: Deadlock detected. The current transaction was rolled back. Details: "
Session #6 (user: ROOT) is waiting to lock PUBLIC.TRANSACTIONS while locking PUBLIC.TRANSACTIONMATCHES (exclusive).
Session #3 (user: ROOT) is waiting to lock PUBLIC.TRANSACTIONMATCHES while locking PUBLIC.TRANSACTIONS (exclusive)."; SQL statement:
delete from transactionmatches where buyTransactionId=? and sellTransactionId=? [40001-160]
at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1107) ~[h2-1.3.160.jar:1.3.160]
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
... 15 common frames omitted
08:46:58.708 17-01-2012 ERROR	org.hibernate.exception.LockAcquisitionException: Could not execute JDBC batch update
java.util.concurrent.ExecutionException: org.hibernate.exception.LockAcquisitionException: Could not execute JDBC batch update
at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source) ~[na:1.6.0_30]
at java.util.concurrent.FutureTask.get(Unknown Source) ~[na:1.6.0_30]
at nl.minicom.evenexus.inventory.InventoryManager.processUnprocessedTransactions(InventoryManager.java:86) ~[EveNexus.exe:na]
at nl.minicom.evenexus.core.Application.initialize(Application.java:134) [EveNexus.exe:na]
at nl.minicom.evenexus.Main.main(Main.java:58) [EveNexus.exe:na]
org.hibernate.exception.LockAcquisitionException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:107) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:189) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at nl.minicom.evenexus.persistence.interceptor.TransactionalInterceptor.invoke(TransactionalInterceptor.java:43) ~[EveNexus.exe:na]
at nl.minicom.evenexus.inventory.InventoryWorker.revertMostRecentTransactionsIfRequired(InventoryWorker.java:70) ~[EveNexus.exe:na]
at nl.minicom.evenexus.persistence.interceptor.TransactionalInterceptor.invoke(TransactionalInterceptor.java:40) ~[EveNexus.exe:na]
at nl.minicom.evenexus.inventory.InventoryWorker.run(InventoryWorker.java:48) ~[EveNexus.exe:na]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) ~[na:1.6.0_30]
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) ~[na:1.6.0_30]
at java.util.concurrent.FutureTask.run(Unknown Source) ~[na:1.6.0_30]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) ~[na:1.6.0_30]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) ~[na:1.6.0_30]
at java.lang.Thread.run(Unknown Source) ~[na:1.6.0_30]
Caused by: org.h2.jdbc.JdbcBatchUpdateException: Deadlock detected. The current transaction was rolled back. Details: "
Session #6 (user: ROOT) is waiting to lock PUBLIC.TRANSACTIONS while locking PUBLIC.TRANSACTIONMATCHES (exclusive).
Session #3 (user: ROOT) is waiting to lock PUBLIC.TRANSACTIONMATCHES while locking PUBLIC.TRANSACTIONS (exclusive)."; SQL statement:
delete from transactionmatches where buyTransactionId=? and sellTransactionId=? [40001-160]
at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1107) ~[h2-1.3.160.jar:1.3.160]
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
... 15 common frames omitted
08:46:59.761 17-01-2012 INFO	Initializing API importers...
08:46:59.769 17-01-2012 INFO	Scheduling importers for character: d4m13n
08:46:59.777 17-01-2012 INFO	Scheduling CHAR_WALLET_JOURNAL importer (characterID: 1150721935) at: Tue Jan 17 08:47:04 GMT 2012
08:46:59.780 17-01-2012 INFO	Scheduling CHAR_MARKET_ORDERS importer (characterID: 1150721935) at: Tue Jan 17 08:47:04 GMT 2012
08:46:59.783 17-01-2012 INFO	Scheduling CHAR_SKILLS importer (characterID: 1150721935) at: Tue Jan 17 08:47:04 GMT 2012
08:46:59.785 17-01-2012 INFO	Scheduling CHAR_STANDINGS importer (characterID: 1150721935) at: Tue Jan 17 08:47:04 GMT 2012
08:46:59.788 17-01-2012 INFO	Scheduling CHAR_WALLET_TRANSACTIONS importer (characterID: 1150721935) at: Tue Jan 17 08:47:04 GMT 2012
08:46:59.793 17-01-2012 INFO	Scheduling Journal reference types importer at: Tue Jan 17 21:21:37 GMT 2012
08:46:59.793 17-01-2012 INFO	Preparing program shutdown hook...
08:46:59.794 17-01-2012 INFO	Completing initialization...
08:47:04.777 17-01-2012 INFO	Running CHAR_WALLET_JOURNAL importer (characterID: 1150721935)
08:47:04.789 17-01-2012 INFO	Running CHAR_STANDINGS importer (characterID: 1150721935)
08:47:04.791 17-01-2012 INFO	Running CHAR_MARKET_ORDERS importer (characterID: 1150721935)
08:47:04.792 17-01-2012 INFO	Running CHAR_SKILLS importer (characterID: 1150721935)
08:47:04.799 17-01-2012 INFO	Running CHAR_WALLET_TRANSACTIONS importer (characterID: 1150721935)
08:47:05.320 17-01-2012 INFO	Market orders panel reloaded!
08:47:05.419 17-01-2012 INFO	Inserted 43 new journal entries.
08:47:05.440 17-01-2012 INFO	Journal panel reloaded!
08:47:06.753 17-01-2012 INFO	Inserted 15 new transactions.
08:47:06.759 17-01-2012 INFO	Calculating inventory and profits for 176 unprocessed transaction(s)
08:47:06.916 17-01-2012 INFO	Found 346 invalid matches for type: 10213, now de-matching...
08:47:06.918 17-01-2012 INFO	Dashboard panel reloaded!
08:47:06.977 17-01-2012 INFO	Transaction panel reloaded!
08:47:08.984 17-01-2012 WARN	SQL Error: 50200, SQLState: HYT00
08:47:08.985 17-01-2012 ERROR	Timeout trying to lock table "TRANSACTIONS"; SQL statement:
select this_.transactionId as transact1_15_0_, this_.characterId as characte2_15_0_, this_.clientId as clientId15_0_, this_.clientName as clientName15_0_, this_.isPersonal as isPersonal15_0_, this_.price as price15_0_, this_.quantity as quantity15_0_, this_.remaining as remaining15_0_, this_.stationId as stationId15_0_, this_.stationName as station10_15_0_, this_.taxes as taxes15_0_, this_.transactionDateTime as transac12_15_0_, this_.typeId as typeId15_0_, this_.typeName as typeName15_0_ from transactions this_ where this_.typeId=? and this_.remaining>? and this_.price? and this_.price) [guice-3.0.jar:na]
at nl.minicom.evenexus.inventory.InventoryWorker.match(InventoryWorker.java:190) [EveNexus.exe:na]
at nl.minicom.evenexus.inventory.InventoryWorker$$EnhancerByGuice$$5175c1f8.CGLIB$match$7() [guice-3.0.jar:na]
at nl.minicom.evenexus.inventory.InventoryWorker$$EnhancerByGuice$$5175c1f8$$FastClassByGuice$$cc798a83.invoke() [guice-3.0.jar:na]
at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) [guice-3.0.jar:na]
at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) [guice-3.0.jar:na]
at nl.minicom.evenexus.persistence.interceptor.TransactionalInterceptor.invoke(TransactionalInterceptor.java:40) [EveNexus.exe:na]
at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) [guice-3.0.jar:na]
at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52) [guice-3.0.jar:na]
at nl.minicom.evenexus.inventory.InventoryWorker$$EnhancerByGuice$$5175c1f8.match() [guice-3.0.jar:na]
at nl.minicom.evenexus.inventory.InventoryWorker.run(InventoryWorker.java:54) [EveNexus.exe:na]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [na:1.6.0_30]
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) [na:1.6.0_30]
at java.util.concurrent.FutureTask.run(Unknown Source) [na:1.6.0_30]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) [na:1.6.0_30]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.6.0_30]
at java.lang.Thread.run(Unknown Source) [na:1.6.0_30]
Caused by: org.h2.jdbc.JdbcBatchUpdateException: Timeout trying to lock table "TRANSACTIONMATCHES"; SQL statement:
insert into transactionmatches (quantity, buyTransactionId, sellTransactionId) values (?, ?, ?) [50200-160]
at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1107) ~[h2-1.3.160.jar:1.3.160]
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
... 25 common frames omitted
08:47:08.995 17-01-2012 WARN	SQL Error: 50200, SQLState: HYT00
08:47:08.996 17-01-2012 ERROR	Could not execute JDBC batch update
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at nl.minicom.evenexus.persistence.interceptor.TransactionalInterceptor.invoke(TransactionalInterceptor.java:43) ~[EveNexus.exe:na]
at nl.minicom.evenexus.inventory.InventoryWorker.match(InventoryWorker.java:190) [EveNexus.exe:na]
at nl.minicom.evenexus.persistence.interceptor.TransactionalInterceptor.invoke(TransactionalInterceptor.java:40) ~[EveNexus.exe:na]
at nl.minicom.evenexus.inventory.InventoryWorker.run(InventoryWorker.java:54) [EveNexus.exe:na]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [na:1.6.0_30]
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) [na:1.6.0_30]
at java.util.concurrent.FutureTask.run(Unknown Source) [na:1.6.0_30]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) [na:1.6.0_30]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.6.0_30]
at java.lang.Thread.run(Unknown Source) [na:1.6.0_30]
Caused by: org.h2.jdbc.JdbcBatchUpdateException: Timeout trying to lock table "TRANSACTIONMATCHES"; SQL statement:
insert into transactionmatches (quantity, buyTransactionId, sellTransactionId) values (?, ?, ?) [50200-160]
at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1107) ~[h2-1.3.160.jar:1.3.160]
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
... 15 common frames omitted
08:47:08.996 17-01-2012 ERROR	Timeout trying to lock table "TRANSACTIONS"; SQL statement:
select this_.transactionId as transact1_15_0_, this_.characterId as characte2_15_0_, this_.clientId as clientId15_0_, this_.clientName as clientName15_0_, this_.isPersonal as isPersonal15_0_, this_.price as price15_0_, this_.quantity as quantity15_0_, this_.remaining as remaining15_0_, this_.stationId as stationId15_0_, this_.stationName as station10_15_0_, this_.taxes as taxes15_0_, this_.transactionDateTime as transac12_15_0_, this_.typeId as typeId15_0_, this_.typeName as typeName15_0_ from transactions this_ where this_.typeId=? and this_.remaining>? and this_.price? and this_.price>? order by this_.transactionDateTime asc [50200-160]
08:47:08.998 17-01-2012 ERROR	could not execute query
org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.loader.Loader.doList(Loader.java:2536) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.loader.Loader.list(Loader.java:2271) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at nl.minicom.evenexus.inventory.InventoryWorker.queryRemainingBuyTransactions(InventoryWorker.java:236) [EveNexus.exe:na]
at nl.minicom.evenexus.persistence.interceptor.TransactionalInterceptor.invoke(TransactionalInterceptor.java:40) ~[EveNexus.exe:na]
at nl.minicom.evenexus.inventory.InventoryWorker.run(InventoryWorker.java:50) [EveNexus.exe:na]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [na:1.6.0_30]
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) [na:1.6.0_30]
at java.util.concurrent.FutureTask.run(Unknown Source) [na:1.6.0_30]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) [na:1.6.0_30]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.6.0_30]
at java.lang.Thread.run(Unknown Source) [na:1.6.0_30]
Caused by: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "TRANSACTIONS"; SQL statement:
select this_.transactionId as transact1_15_0_, this_.characterId as characte2_15_0_, this_.clientId as clientId15_0_, this_.clientName as clientName15_0_, this_.isPersonal as isPersonal15_0_, this_.price as price15_0_, this_.quantity as quantity15_0_, this_.remaining as remaining15_0_, this_.stationId as stationId15_0_, this_.stationName as station10_15_0_, this_.taxes as taxes15_0_, this_.transactionDateTime as transac12_15_0_, this_.typeId as typeId15_0_, this_.typeName as typeName15_0_ from transactions this_ where this_.typeId=? and this_.remaining>? and this_.price? and this_.price>? order by this_.transactionDateTime asc [50200-160]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) ~[h2-1.3.160.jar:1.3.160]
at org.h2.message.DbException.get(DbException.java:169) ~[h2-1.3.160.jar:1.3.160]
at org.h2.message.DbException.get(DbException.java:146) ~[h2-1.3.160.jar:1.3.160]
at org.h2.table.RegularTable.doLock(RegularTable.java:500) ~[h2-1.3.160.jar:1.3.160]
at org.h2.table.RegularTable.lock(RegularTable.java:434) ~[h2-1.3.160.jar:1.3.160]
at org.h2.table.TableFilter.lock(TableFilter.java:142) ~[h2-1.3.160.jar:1.3.160]
at org.h2.command.dml.Select.queryWithoutCache(Select.java:590) ~[h2-1.3.160.jar:1.3.160]
at org.h2.command.dml.Query.query(Query.java:298) ~[h2-1.3.160.jar:1.3.160]
at org.h2.command.dml.Query.query(Query.java:268) ~[h2-1.3.160.jar:1.3.160]
at org.h2.command.dml.Query.query(Query.java:37) ~[h2-1.3.160.jar:1.3.160]
at org.h2.command.CommandContainer.query(CommandContainer.java:82) ~[h2-1.3.160.jar:1.3.160]
at org.h2.command.Command.executeQuery(Command.java:185) ~[h2-1.3.160.jar:1.3.160]
at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96) ~[h2-1.3.160.jar:1.3.160]
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.loader.Loader.doQuery(Loader.java:802) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.loader.Loader.doList(Loader.java:2533) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
... 14 common frames omitted
08:47:09.001 17-01-2012 ERROR	org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
java.util.concurrent.ExecutionException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source) ~[na:1.6.0_30]
at java.util.concurrent.FutureTask.get(Unknown Source) ~[na:1.6.0_30]
at nl.minicom.evenexus.inventory.InventoryManager.processUnprocessedTransactions(InventoryManager.java:86) ~[EveNexus.exe:na]
at nl.minicom.evenexus.inventory.InventoryManager$2.onImportComplete(InventoryManager.java:59) [EveNexus.exe:na]
at nl.minicom.evenexus.eveapi.importers.ImportManager$1.run(ImportManager.java:102) [EveNexus.exe:na]
at java.lang.Thread.run(Unknown Source) [na:1.6.0_30]
Caused by: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at nl.minicom.evenexus.persistence.interceptor.TransactionalInterceptor.invoke(TransactionalInterceptor.java:43) ~[EveNexus.exe:na]
at nl.minicom.evenexus.inventory.InventoryWorker.match(InventoryWorker.java:190) ~[EveNexus.exe:na]
at nl.minicom.evenexus.persistence.interceptor.TransactionalInterceptor.invoke(TransactionalInterceptor.java:40) ~[EveNexus.exe:na]
at nl.minicom.evenexus.inventory.InventoryWorker.run(InventoryWorker.java:54) ~[EveNexus.exe:na]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) ~[na:1.6.0_30]
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) ~[na:1.6.0_30]
at java.util.concurrent.FutureTask.run(Unknown Source) ~[na:1.6.0_30]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) ~[na:1.6.0_30]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) ~[na:1.6.0_30]
... 1 common frames omitted
Caused by: org.h2.jdbc.JdbcBatchUpdateException: Timeout trying to lock table "TRANSACTIONMATCHES"; SQL statement:
insert into transactionmatches (quantity, buyTransactionId, sellTransactionId) values (?, ?, ?) [50200-160]
at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1107) ~[h2-1.3.160.jar:1.3.160]
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
... 15 common frames omitted
08:47:09.298 17-01-2012 INFO	Finished de-matching 346 invalid matches for type: 10213.
08:47:09.325 17-01-2012 ERROR	org.hibernate.exception.GenericJDBCException: could not execute query
java.util.concurrent.ExecutionException: org.hibernate.exception.GenericJDBCException: could not execute query
at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source) ~[na:1.6.0_30]
at java.util.concurrent.FutureTask.get(Unknown Source) ~[na:1.6.0_30]
at nl.minicom.evenexus.inventory.InventoryManager.processUnprocessedTransactions(InventoryManager.java:86) ~[EveNexus.exe:na]
at nl.minicom.evenexus.inventory.InventoryManager$2.onImportComplete(InventoryManager.java:59) [EveNexus.exe:na]
at nl.minicom.evenexus.eveapi.importers.ImportManager$1.run(ImportManager.java:102) [EveNexus.exe:na]
at java.lang.Thread.run(Unknown Source) [na:1.6.0_30]
Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.loader.Loader.doList(Loader.java:2536) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.loader.Loader.list(Loader.java:2271) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at nl.minicom.evenexus.inventory.InventoryWorker.queryRemainingSellTransactions(InventoryWorker.java:250) ~[EveNexus.exe:na]
at nl.minicom.evenexus.persistence.interceptor.TransactionalInterceptor.invoke(TransactionalInterceptor.java:40) ~[EveNexus.exe:na]
at nl.minicom.evenexus.inventory.InventoryWorker.run(InventoryWorker.java:51) ~[EveNexus.exe:na]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) ~[na:1.6.0_30]
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) ~[na:1.6.0_30]
at java.util.concurrent.FutureTask.run(Unknown Source) ~[na:1.6.0_30]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) ~[na:1.6.0_30]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) ~[na:1.6.0_30]
... 1 common frames omitted
Caused by: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "TRANSACTIONS"; SQL statement:
select this_.transactionId as transact1_15_0_, this_.characterId as characte2_15_0_, this_.clientId as clientId15_0_, this_.clientName as clientName15_0_, this_.isPersonal as isPersonal15_0_, this_.price as price15_0_, this_.quantity as quantity15_0_, this_.remaining as remaining15_0_, this_.stationId as stationId15_0_, this_.stationName as station10_15_0_, this_.taxes as taxes15_0_, this_.transactionDateTime as transac12_15_0_, this_.typeId as typeId15_0_, this_.typeName as typeName15_0_ from transactions this_ where this_.typeId=? and this_.remaining>? and this_.price>? order by this_.transactionDateTime asc [50200-160]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) ~[h2-1.3.160.jar:1.3.160]
at org.h2.message.DbException.get(DbException.java:169) ~[h2-1.3.160.jar:1.3.160]
at org.h2.message.DbException.get(DbException.java:146) ~[h2-1.3.160.jar:1.3.160]
at org.h2.table.RegularTable.doLock(RegularTable.java:500) ~[h2-1.3.160.jar:1.3.160]
at org.h2.table.RegularTable.lock(RegularTable.java:434) ~[h2-1.3.160.jar:1.3.160]
at org.h2.table.TableFilter.lock(TableFilter.java:142) ~[h2-1.3.160.jar:1.3.160]
at org.h2.command.dml.Select.queryWithoutCache(Select.java:590) ~[h2-1.3.160.jar:1.3.160]
at org.h2.command.dml.Query.query(Query.java:298) ~[h2-1.3.160.jar:1.3.160]
at org.h2.command.dml.Query.query(Query.java:268) ~[h2-1.3.160.jar:1.3.160]
at org.h2.command.dml.Query.query(Query.java:37) ~[h2-1.3.160.jar:1.3.160]
at org.h2.command.CommandContainer.query(CommandContainer.java:82) ~[h2-1.3.160.jar:1.3.160]
at org.h2.command.Command.executeQuery(Command.java:185) ~[h2-1.3.160.jar:1.3.160]
at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96) ~[h2-1.3.160.jar:1.3.160]
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.loader.Loader.doQuery(Loader.java:802) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.loader.Loader.doList(Loader.java:2533) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
... 14 common frames omitted
08:47:09.329 17-01-2012 ERROR	org.hibernate.exception.GenericJDBCException: could not execute query
java.util.concurrent.ExecutionException: org.hibernate.exception.GenericJDBCException: could not execute query
at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source) ~[na:1.6.0_30]
at java.util.concurrent.FutureTask.get(Unknown Source) ~[na:1.6.0_30]
at nl.minicom.evenexus.inventory.InventoryManager.processUnprocessedTransactions(InventoryManager.java:86) ~[EveNexus.exe:na]
at nl.minicom.evenexus.inventory.InventoryManager$2.onImportComplete(InventoryManager.java:59) [EveNexus.exe:na]
at nl.minicom.evenexus.eveapi.importers.ImportManager$1.run(ImportManager.java:102) [EveNexus.exe:na]
at java.lang.Thread.run(Unknown Source) [na:1.6.0_30]
Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.loader.Loader.doList(Loader.java:2536) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.loader.Loader.list(Loader.java:2271) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at nl.minicom.evenexus.inventory.InventoryWorker.queryRemainingBuyTransactions(InventoryWorker.java:236) ~[EveNexus.exe:na]
at nl.minicom.evenexus.persistence.interceptor.TransactionalInterceptor.invoke(TransactionalInterceptor.java:40) ~[EveNexus.exe:na]
at nl.minicom.evenexus.inventory.InventoryWorker.run(InventoryWorker.java:50) ~[EveNexus.exe:na]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) ~[na:1.6.0_30]
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) ~[na:1.6.0_30]
at java.util.concurrent.FutureTask.run(Unknown Source) ~[na:1.6.0_30]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) ~[na:1.6.0_30]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) ~[na:1.6.0_30]
... 1 common frames omitted
Caused by: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "TRANSACTIONS"; SQL statement:
select this_.transactionId as transact1_15_0_, this_.characterId as characte2_15_0_, this_.clientId as clientId15_0_, this_.clientName as clientName15_0_, this_.isPersonal as isPersonal15_0_, this_.price as price15_0_, this_.quantity as quantity15_0_, this_.remaining as remaining15_0_, this_.stationId as stationId15_0_, this_.stationName as station10_15_0_, this_.taxes as taxes15_0_, this_.transactionDateTime as transac12_15_0_, this_.typeId as typeId15_0_, this_.typeName as typeName15_0_ from transactions this_ where this_.typeId=? and this_.remaining>? and this_.price? and this_.price) [guice-3.0.jar:na]
at nl.minicom.evenexus.inventory.InventoryWorker.run(InventoryWorker.java:54) [EveNexus.exe:na]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [na:1.6.0_30]
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) [na:1.6.0_30]
at java.util.concurrent.FutureTask.run(Unknown Source) [na:1.6.0_30]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) [na:1.6.0_30]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.6.0_30]
at java.lang.Thread.run(Unknown Source) [na:1.6.0_30]
Caused by: org.h2.jdbc.JdbcBatchUpdateException: Deadlock detected. The current transaction was rolled back. Details: "
Session #271 (user: ROOT) is waiting to lock PUBLIC.TRANSACTIONMATCHES while locking PUBLIC.TRANSACTIONS (exclusive).
Session #269 (user: ROOT) is waiting to lock PUBLIC.TRANSACTIONS while locking PUBLIC.TRANSACTIONMATCHES (exclusive)."; SQL statement:
update transactions set characterId=?, clientId=?, clientName=?, isPersonal=?, price=?, quantity=?, remaining=?, stationId=?, stationName=?, taxes=?, transactionDateTime=?, typeId=?, typeName=? where transactionId=? [40001-160]
at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1107) ~[h2-1.3.160.jar:1.3.160]
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
... 16 common frames omitted
09:17:06.193 17-01-2012 ERROR	org.hibernate.exception.LockAcquisitionException: Could not execute JDBC batch update
java.util.concurrent.ExecutionException: org.hibernate.exception.LockAcquisitionException: Could not execute JDBC batch update
at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source) ~[na:1.6.0_30]
at java.util.concurrent.FutureTask.get(Unknown Source) ~[na:1.6.0_30]
at nl.minicom.evenexus.inventory.InventoryManager.processUnprocessedTransactions(InventoryManager.java:86) ~[EveNexus.exe:na]
at nl.minicom.evenexus.inventory.InventoryManager$2.onImportComplete(InventoryManager.java:59) [EveNexus.exe:na]
at nl.minicom.evenexus.eveapi.importers.ImportManager$1.run(ImportManager.java:102) [EveNexus.exe:na]
at java.lang.Thread.run(Unknown Source) [na:1.6.0_30]
Caused by: org.hibernate.exception.LockAcquisitionException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:107) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) ~[hibernate-core-3.6.2.Final.jar:3.6.2.Final]
at nl.minicom.evenexus.persistence.interceptor.TransactionalInterceptor.invoke(TransactionalInterceptor.java:43) ~[EveNexus.exe:na]
at nl.minicom.evenexus.inventory.InventoryWorker.run(InventoryWorker.java:54) ~[EveNexus.exe:na]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) ~[na:1.6.0_30]
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) ~[na:1.6.0_30]
at java.util.concurrent.FutureTask.run(Unknown Source) ~[na:1.6.0_30]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) ~[na:1.6.0_30]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) ~[na:1.6.0_30]
... 1 common frames omitted
Caused by: org.h2.jdbc.JdbcBatchUpdateException: Deadlock detected. The current transa