API tools faq
paste
Advertisement
Mgkrp

Untitled

Mgkrp
Dec 4th, 2018
100
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.29 KB | None | 0 0
raw download clone embed print report
  1. 2018-12-04 07:36:00,415 +0000 [WEB-1] [ErrorPageFilter] ERROR Forwarding to error page from request [/notification/curacao] due to exception [PreparedStatementCallback; SQL [SELECT ID FROM PURCHASE WHERE ID = ? AND JURISDICTION_ID = ? FO
  2. R UPDATE NOWAIT]; ERROR: could not obtain lock on row in relation "purchase"; nested exception is org.postgresql.util.PSQLException: ERROR: could not obtain lock on row in relation "purchase"]
  3. org.springframework.dao.CannotAcquireLockException: PreparedStatementCallback; SQL [SELECT ID FROM PURCHASE WHERE ID = ? AND JURISDICTION_ID = ? FOR UPDATE NOWAIT]; ERROR: could not obtain lock on row in relation "purchase"; nested excep
  4. tion is org.postgresql.util.PSQLException: ERROR: could not obtain lock on row in relation "purchase"
  5. at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:258)
  6. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
  7. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:655)
  8. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:690)
  9. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:717)
  10. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:767)
  11. at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForObject(NamedParameterJdbcTemplate.java:211)
  12. at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForObject(NamedParameterJdbcTemplate.java:226)
  13. at com.panbet.payment.skeleton.dao.LockProviderPostgres.lockRequestForProcess(LockProviderPostgres.java:56)
  14. at com.panbet.payment.skeleton.dao.LockProviderPostgres.lockPurchase(LockProviderPostgres.java:34)
  15. at com.panbet.payment.bankcard.ecommpay.service.notification.strategies.PurchaseNotificationProcessStrategy.lockTransaction(PurchaseNotificationProcessStrategy.java:70)
  16. at com.panbet.payment.bankcard.ecommpay.service.notification.NotificationController.lambda$processNotification$2(NotificationController.java:73)
  17. at com.panbet.payment.bankcard.ecommpay.service.utils.Transactor.exec(Transactor.java:16)
  18. at com.panbet.payment.bankcard.ecommpay.service.utils.Transactor$$FastClassBySpringCGLIB$$1ae199cd.invoke(<generated>)
  19. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
  20. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:736)
  21. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  22. at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
  23. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
  24. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
  25. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  26. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:671)
  27. at com.panbet.payment.bankcard.ecommpay.service.utils.Transactor$$EnhancerBySpringCGLIB$$f283d6f1.exec(<generated>)
  28. at com.panbet.payment.bankcard.ecommpay.service.notification.NotificationController.processNotification(NotificationController.java:70)
  29. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  30. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  31. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  32. at java.lang.reflect.Method.invoke(Method.java:498)
  33. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
  34. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
  35. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
  36. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:849)
  37. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:760)
  38. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  39. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
  40. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
  41. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
  42. at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
  43. at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
  44. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
  45. at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
  46. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  47. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  48. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  49. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  50. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  51. at com.panbet.payment.bankcard.ecommpay.service.notification.LoggingFilter.doFilter(LoggingFilter.java:47)
  52. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  53. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  54. at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
  55. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  56. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  57. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  58. at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)
  59. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  60. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  61. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  62. at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
  63. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  64. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  65. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  66. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
  67. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  68. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  69. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  70. at org.springframework.boot.web.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:130)
  71. at org.springframework.boot.web.support.ErrorPageFilter.access$000(ErrorPageFilter.java:66)
  72. at org.springframework.boot.web.support.ErrorPageFilter$1.doFilterInternal(ErrorPageFilter.java:105)
  73. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  74. at org.springframework.boot.web.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:123)
  75. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  76. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  77. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
  78. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  79. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496)
  80. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
  81. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
  82. at ch.qos.logback.access.tomcat.LogbackValve.invoke(LogbackValve.java:256)
  83. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
  84. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
  85. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
  86. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  87. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)
  88. at org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:2350)
  89. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  90. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  91. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  92. at java.lang.Thread.run(Thread.java:748)
  93. Caused by: org.postgresql.util.PSQLException: ERROR: could not obtain lock on row in relation "purchase"
  94. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)
  95. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)
  96. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)
  97. at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)
  98. at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356)
  99. at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168)
  100. at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:116)
  101. at sun.reflect.GeneratedMethodAccessor69.invoke(Unknown Source)
  102. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  103. at java.lang.reflect.Method.invoke(Method.java:498)
  104. at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114)
  105. at com.sun.proxy.$Proxy96.executeQuery(Unknown Source)
  106. at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:698)
  107. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:639)
  108. ... 85 common frames omitted
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!