įor example: In DB1 you are first saving some records(data) that is sent for processing to a java application. Making use of nolock as below will avoid deadlock but there are chances that you may not get the recent records just insert in your DB.Ģ) When you are using two or more databases then the things are going to be complicated, because DB1 will be in use to operate queries within itself(related to DB1) And DB2 is requesting DB1 to fire some queries(e.g: via Triggers).
#Deadlock found when trying to get lock update
I'll extract the queries out of the transaction, so it will contain only INSERT and UPDATE sentences.ġ) Yes, a query(SELECT/INSERT/UPDATE/DELETE) can lock the database.įor Example: SELECT Query SELECT * FROM CUSTOMER
My transaction contains some SELECT before UPDATEs.
Get more info about deadlock by enabling SHOW ENGINE STATUS and getting the log. Of course, any help to check and analyze this exception is very appreciated. Could the deadlock happen because of the number of threads?. Is this right? Could it be the cause of this exception? Now, I notice that all related tables are in InnoDB engine, except one, which is in MyISAM. The transaction with Atomikos is among two databases. But, is the deadlock produced because of this query/table or another one? CustomerDAOImpl.findCustomer is a key to get the query and the lock table. I have required a PROCESS permission to check SHOW ENGINE STATUS to get mor info about the deadlock. The exception is: : : Deadlock found when trying to get lock try restarting transactionĪt .convert(AbstractEntityManagerImpl.java:1377)Īt .convert(AbstractEntityManagerImpl.java:1300)Īt .getResultList(QueryImpl.java:273)Īt .(CustomerDAOImpl.java:35)Īt .(JTAPDFWriterDAO.java:64)Īt .(PDFWriter.java:17)Īt .(CompositeItemWriter.java:51)Īt 0(Native Method)Īt (NativeMethodAccessorImpl.java:57)Īt (DelegatingMethodAccessorImpl.java:43)Īt .invoke(Method.java:606)Īt .AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)Īt .ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)Īt .ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)Īt .DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)Īt .DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)Īt .ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)Īt .JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)Īt .$Proxy28.write(Unknown Source)Īt .(SimpleChunkProcessor.java:175)Īt .(SimpleChunkProcessor.java:151)Īt .$3.doWithRetry(FaultTolerantChunkProcessor.java:329)Īt .RetryTemplate.doExecute(RetryTemplate.java:263)Īt .RetryTemplate.execute(RetryTemplate.java:193)Īt .(BatchRetryTemplate.java:217)Īt .(FaultTolerantChunkProcessor.java:422)Īt .(SimpleChunkProcessor.java:199)Īt .(ChunkOrientedTasklet.java:75)Īt .$ChunkTransactionCallback.doInTransaction(TaskletStep.java:406)Īt .$ChunkTransactionCallback.doInTransaction(TaskletStep.java:330)Īt .TransactionTemplate.execute(TransactionTemplate.java:133)Īt .$2.doInChunkContext(TaskletStep.java:271)Īt .(StepContextRepeatCallback.java:77)Īt .support.TaskExecutorRepeatTemplate$n(TaskExecutorRepeatTemplate.java:262)Īt .runWorker(ThreadPoolExecutor.java:1145)Īt $n(ThreadPoolExecutor.java:615) I need Atomikos for transactions between two databases. 
Spring ThreadPoolTaskExecutor between 10 and 20 threads. The next exception raises with this configuration:
0 kommentar(er)
