API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 27th, 2015
240
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.95 KB | None | 0 0
raw download clone embed print report
  1. 2015-01-28 12:05:49,082 DEBUG [manager-akka.actor.default-dispatcher-2] (SqlExceptionHelper.java:139) - could not execute statement [n/a]
  2. org.postgresql.util.PSQLException: ERROR: deadlock detected
  3. Detail: Process 32229 waits for ShareLock on transaction 214354; blocked by process 32232.
  4. Process 32232 waits for ExclusiveLock on tuple (0,13) of relation 81150 of database 81034; blocked by process 32229.
  5. Hint: See server log for query details.
  6. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
  7. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
  8. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
  9. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559)
  10. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
  11. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363)
  12. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:187)
  13. at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:62)
  14. at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3281)
  15. at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:3183)
  16. at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3525)
  17. at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:159)
  18. at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:463)
  19. at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:349)
  20. at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350)
  21. at org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:67)
  22. at org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1191)
  23. at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1675)
  24. at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:380)
  25. at io.transwarp.manager.master.persistence.dao.impl.DaoImpl.list(DaoImpl.java:80)
  26. at io.transwarp.manager.master.manager.service.ServiceManager.handleImpactService(ServiceManager.java:576)
  27. at io.transwarp.manager.master.manager.service.ServiceManager.updateService(ServiceManager.java:567)
  28. at io.transwarp.manager.master.manager.service.ServiceManager$$FastClassBySpringCGLIB$$88bd6597.invoke(<generated>)
  29. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
  30. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:708)
  31. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  32. at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98)
  33. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262)
  34. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95)
  35. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  36. at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)
  37. at io.transwarp.manager.master.persistence.utils.ConcurrentOperationFailureInterceptor.performOperation(ConcurrentOperationFailureInterceptor.java:54)
  38. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  39. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  40. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  41. at java.lang.reflect.Method.invoke(Method.java:606)
  42. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)
  43. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)
  44. at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:68)
  45. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)
  46. at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
  47. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  48. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:644)
  49. at io.transwarp.manager.master.manager.service.ServiceManager$$EnhancerBySpringCGLIB$$70fe07e2.updateService(<generated>)
  50. at io.transwarp.manager.master.manager.service.ServiceDispatcher$UpdateServiceHandler.handle(ServiceDispatcher.java:233)
  51. at io.transwarp.manager.master.manager.BaseDispatcher$1.call(BaseDispatcher.java:72)
  52. at akka.dispatch.Futures$$anonfun$future$1.apply(Future.scala:94)
  53. at scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24)
  54. at scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24)
  55. at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41)
  56. at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:401)
  57. at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)
  58. at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)
  59. at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)
  60. at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)
  61. 2015-01-28 12:05:49,083 WARN [manager-akka.actor.default-dispatcher-2] (SqlExceptionHelper.java:144) - SQL Error: 0, SQLState: 40P01
  62. 2015-01-28 12:05:49,083 ERROR [manager-akka.actor.default-dispatcher-2] (SqlExceptionHelper.java:146) - ERROR: deadlock detected
  63. Detail: Process 32229 waits for ShareLock on transaction 214354; blocked by process 32232.
  64. Process 32232 waits for ExclusiveLock on tuple (0,13) of relation 81150 of database 81034; blocked by process 32229.
  65. Hint: See server log for query details.
  66. 2015-01-28 12:05:49,084 INFO [manager-akka.actor.default-dispatcher-2] (AbstractBatchImpl.java:208) - HHH000010: On release of batch it still contained JDBC statements
  67. 2015-01-28 12:05:49,091 ERROR [pool-4-thread-17] (RestException.java:27) - org.hibernate.exception.LockAcquisitionException: could not execute statement
  68. at org.hibernate.dialect.PostgreSQL81Dialect$2.convert(PostgreSQL81Dialect.java:416)
  69. at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
  70. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
  71. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
  72. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:190)
  73. at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:62)
  74. at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3281)
  75. at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:3183)
  76. at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3525)
  77. at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:159)
  78. at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:463)
  79. at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:349)
  80. at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350)
  81. at org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:67)
  82. at org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1191)
  83. at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1675)
  84. at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:380)
  85. at io.transwarp.manager.master.persistence.dao.impl.DaoImpl.list(DaoImpl.java:80)
  86. at io.transwarp.manager.master.manager.service.ServiceManager.handleImpactService(ServiceManager.java:576)
  87. at io.transwarp.manager.master.manager.service.ServiceManager.updateService(ServiceManager.java:567)
  88. at io.transwarp.manager.master.manager.service.ServiceManager$$FastClassBySpringCGLIB$$88bd6597.invoke(<generated>)
  89. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
  90. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:708)
  91. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  92. at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98)
  93. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262)
  94. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95)
  95. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  96. at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)
  97. at io.transwarp.manager.master.persistence.utils.ConcurrentOperationFailureInterceptor.performOperation(ConcurrentOperationFailureInterceptor.java:54)
  98. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  99. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  100. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  101. at java.lang.reflect.Method.invoke(Method.java:606)
  102. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)
  103. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)
  104. at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:68)
  105. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)
  106. at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
  107. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  108. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:644)
  109. at io.transwarp.manager.master.manager.service.ServiceManager$$EnhancerBySpringCGLIB$$70fe07e2.updateService(<generated>)
  110. at io.transwarp.manager.master.manager.service.ServiceDispatcher$UpdateServiceHandler.handle(ServiceDispatcher.java:233)
  111. at io.transwarp.manager.master.manager.BaseDispatcher$1.call(BaseDispatcher.java:72)
  112. at akka.dispatch.Futures$$anonfun$future$1.apply(Future.scala:94)
  113. at scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24)
  114. at scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24)
  115. at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41)
  116. at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:401)
  117. at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)
  118. at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)
  119. at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)
  120. at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)
  121. Caused by: org.postgresql.util.PSQLException: ERROR: deadlock detected
  122. Detail: Process 32229 waits for ShareLock on transaction 214354; blocked by process 32232.
  123. Process 32232 waits for ExclusiveLock on tuple (0,13) of relation 81150 of database 81034; blocked by process 32229.
  124. Hint: See server log for query details.
  125. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
  126. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
  127. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
  128. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559)
  129. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
  130. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363)
  131. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:187)
  132. ... 48 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!