API tools faq
paste
Advertisement
AnnaRadeva

PSQLException

AnnaRadeva
Nov 20th, 2015
85
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 41.11 KB | None | 0 0
raw download clone embed print report
  1. 2015-11-20 15:26:34,503 ERROR [liquibase] (ForkJoinPool.commonPool-worker-1) {t=cs.dev, u=System@cs.dev} Change Set com/sirma/itt/patch/changelog.xml::seip-1.20.0-12::bbonev failed. Error: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "idx_lock_id"
  2. Detail: Key (lockedinstanceid)=(emf:a0c9e1f2-d4d7-4304-9fc1-251625552e8b) already exists.: liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "idx_lock_id"
  3. Detail: Key (lockedinstanceid)=(emf:a0c9e1f2-d4d7-4304-9fc1-251625552e8b) already exists.
  4. at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:316)
  5. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  6. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)
  7. at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1227)
  8. at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1210)
  9. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:550)
  10. at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:43)
  11. at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)
  12. at liquibase.Liquibase.update(Liquibase.java:200)
  13. at liquibase.Liquibase.update(Liquibase.java:181)
  14. at liquibase.Liquibase.update(Liquibase.java:174)
  15. at com.sirma.itt.seip.db.patch.DatabasePatcher.patchDatabase(DatabasePatcher.java:47)
  16. at com.sirma.itt.seip.db.patch.PatchDbService.patchSchema(PatchDbService.java:89)
  17. at com.sirma.itt.seip.db.patch.PatchDbService.runSchemaPatchesForAllTenants(PatchDbService.java:64)
  18. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  19. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  20. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  21. at java.lang.reflect.Method.invoke(Method.java:497)
  22. at org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
  23. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  24. at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437)
  25. at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:82)
  26. at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:93)
  27. at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
  28. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  29. at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)
  30. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  31. at org.jboss.as.ejb3.tx.EjbBMTInterceptor.handleInvocation(EjbBMTInterceptor.java:103)
  32. at org.jboss.as.ejb3.tx.BMTInterceptor.processInvocation(BMTInterceptor.java:58)
  33. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  34. at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437)
  35. at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73)
  36. at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83)
  37. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  38. at org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45)
  39. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  40. at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
  41. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  42. at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
  43. at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:52)
  44. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  45. at org.jboss.as.ejb3.component.singleton.SingletonComponentInstanceAssociationInterceptor.processInvocation(SingletonComponentInstanceAssociationInterceptor.java:53)
  46. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  47. at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
  48. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  49. at org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:43)
  50. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  51. at org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:100)
  52. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  53. at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)
  54. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  55. at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:66)
  56. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  57. at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
  58. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  59. at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:54)
  60. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  61. at org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64)
  62. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  63. at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356)
  64. at org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:634)
  65. at org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:61)
  66. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  67. at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356)
  68. at org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80)
  69. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  70. at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
  71. at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:195)
  72. at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:185)
  73. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  74. at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
  75. at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:73)
  76. at com.sirma.itt.seip.db.patch.PatchDbService$$$view6.runSchemaPatchesForAllTenants(Unknown Source)
  77. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  78. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  79. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  80. at java.lang.reflect.Method.invoke(Method.java:497)
  81. at org.jboss.weld.util.reflection.Reflections.invokeAndUnwrap(Reflections.java:434)
  82. at org.jboss.weld.bean.proxy.EnterpriseBeanProxyMethodHandler.invoke(EnterpriseBeanProxyMethodHandler.java:127)
  83. at org.jboss.weld.bean.proxy.EnterpriseTargetBeanInstance.invoke(EnterpriseTargetBeanInstance.java:56)
  84. at org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:100)
  85. at com.sirma.itt.seip.db.patch.PatchDbService$Proxy$_$$_Weld$EnterpriseProxy$.runSchemaPatchesForAllTenants(Unknown Source)
  86. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  87. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  88. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  89. at java.lang.reflect.Method.invoke(Method.java:497)
  90. at com.sirma.itt.seip.util.CDI.invokeMethod(CDI.java:241)
  91. at com.sirma.itt.seip.runtime.boot.MethodComponentInstance.start(MethodComponentInstance.java:54)
  92. at com.sirma.itt.seip.tenant.security.interceptor.RunAsTenantComponentDecorator.executeInTenantContext(RunAsTenantComponentDecorator.java:80)
  93. at com.sirma.itt.seip.tenant.security.interceptor.RunAsTenantComponentDecorator.lambda$start$9(RunAsTenantComponentDecorator.java:61)
  94. at com.sirma.itt.seip.tenant.security.interceptor.RunAsTenantComponentDecorator$$Lambda$166/179087150.accept(Unknown Source)
  95. at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
  96. at java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193)
  97. at java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:948)
  98. at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:512)
  99. at java.util.stream.ForEachOps$ForEachTask.compute(ForEachOps.java:291)
  100. at java.util.concurrent.CountedCompleter.exec(CountedCompleter.java:731)
  101. at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:289)
  102. at java.util.concurrent.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1056)
  103. at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1689)
  104. at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:157)
  105. Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "idx_lock_id"
  106. Detail: Key (lockedinstanceid)=(emf:a0c9e1f2-d4d7-4304-9fc1-251625552e8b) already exists.
  107. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
  108. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
  109. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
  110. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
  111. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:406)
  112. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:398)
  113. at sun.reflect.GeneratedMethodAccessor255.invoke(Unknown Source)
  114. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  115. at java.lang.reflect.Method.invoke(Method.java:497)
  116. at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:453)
  117. at com.sun.proxy.$Proxy86.execute(Unknown Source)
  118. at org.jboss.jca.adapters.jdbc.WrappedStatement.execute(WrappedStatement.java:157)
  119. at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314)
  120. ... 100 more
  121.  
  122. 2015-11-20 15:26:34,507 INFO [liquibase] (ForkJoinPool.commonPool-worker-1) {t=cs.dev, u=System@cs.dev} Successfully released change log lock
  123. 2015-11-20 15:26:34,508 WARN [com.sirma.itt.seip.tenant.security.interceptor.RunAsTenantComponentDecorator] (ForkJoinPool.commonPool-worker-1) {t=cs.dev, u=System@cs.dev} Could not execute component PatchDbService.runSchemaPatchesForAllTenants for tenant cs.dev: java.lang.IllegalStateException: Bean method class com.sirma.itt.seip.db.patch.PatchDbService.runSchemaPatchesForAllTenants invoke failed!
  124. at com.sirma.itt.seip.util.CDI.invokeMethod(CDI.java:243)
  125. at com.sirma.itt.seip.runtime.boot.MethodComponentInstance.start(MethodComponentInstance.java:54)
  126. at com.sirma.itt.seip.tenant.security.interceptor.RunAsTenantComponentDecorator.executeInTenantContext(RunAsTenantComponentDecorator.java:80)
  127. at com.sirma.itt.seip.tenant.security.interceptor.RunAsTenantComponentDecorator.lambda$start$9(RunAsTenantComponentDecorator.java:61)
  128. at com.sirma.itt.seip.tenant.security.interceptor.RunAsTenantComponentDecorator$$Lambda$166/179087150.accept(Unknown Source)
  129. at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
  130. at java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193)
  131. at java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:948)
  132. at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:512)
  133. at java.util.stream.ForEachOps$ForEachTask.compute(ForEachOps.java:291)
  134. at java.util.concurrent.CountedCompleter.exec(CountedCompleter.java:731)
  135. at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:289)
  136. at java.util.concurrent.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1056)
  137. at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1689)
  138. at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:157)
  139. Caused by: java.lang.reflect.InvocationTargetException
  140. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  141. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  142. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  143. at java.lang.reflect.Method.invoke(Method.java:497)
  144. at com.sirma.itt.seip.util.CDI.invokeMethod(CDI.java:241)
  145. ... 14 more
  146. Caused by: com.sirma.itt.seip.exception.RollbackedException: liquibase.exception.MigrationFailedException: Migration failed for change set com/sirma/itt/patch/changelog.xml::seip-1.20.0-12::bbonev:
  147. Reason: liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "idx_lock_id"
  148. Detail: Key (lockedinstanceid)=(emf:a0c9e1f2-d4d7-4304-9fc1-251625552e8b) already exists.
  149. at com.sirma.itt.seip.db.patch.DatabasePatcher.patchDatabase(DatabasePatcher.java:49)
  150. at com.sirma.itt.seip.db.patch.PatchDbService.patchSchema(PatchDbService.java:89)
  151. at com.sirma.itt.seip.db.patch.PatchDbService.runSchemaPatchesForAllTenants(PatchDbService.java:64)
  152. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  153. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  154. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  155. at java.lang.reflect.Method.invoke(Method.java:497)
  156. at org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
  157. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  158. at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437)
  159. at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:82)
  160. at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:93)
  161. at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
  162. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  163. at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)
  164. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  165. at org.jboss.as.ejb3.tx.EjbBMTInterceptor.handleInvocation(EjbBMTInterceptor.java:103)
  166. at org.jboss.as.ejb3.tx.BMTInterceptor.processInvocation(BMTInterceptor.java:58)
  167. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  168. at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437)
  169. at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73)
  170. at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83)
  171. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  172. at org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45)
  173. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  174. at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
  175. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  176. at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
  177. at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:52)
  178. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  179. at org.jboss.as.ejb3.component.singleton.SingletonComponentInstanceAssociationInterceptor.processInvocation(SingletonComponentInstanceAssociationInterceptor.java:53)
  180. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  181. at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
  182. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  183. at org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:43)
  184. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  185. at org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:100)
  186. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  187. at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)
  188. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  189. at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:66)
  190. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  191. at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
  192. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  193. at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:54)
  194. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  195. at org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64)
  196. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  197. at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356)
  198. at org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:634)
  199. at org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:61)
  200. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  201. at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356)
  202. at org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80)
  203. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  204. at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
  205. at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:195)
  206. at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:185)
  207. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  208. at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
  209. at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:73)
  210. at com.sirma.itt.seip.db.patch.PatchDbService$$$view6.runSchemaPatchesForAllTenants(Unknown Source)
  211. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  212. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  213. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  214. at java.lang.reflect.Method.invoke(Method.java:497)
  215. at org.jboss.weld.util.reflection.Reflections.invokeAndUnwrap(Reflections.java:434)
  216. at org.jboss.weld.bean.proxy.EnterpriseBeanProxyMethodHandler.invoke(EnterpriseBeanProxyMethodHandler.java:127)
  217. at org.jboss.weld.bean.proxy.EnterpriseTargetBeanInstance.invoke(EnterpriseTargetBeanInstance.java:56)
  218. at org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:100)
  219. at com.sirma.itt.seip.db.patch.PatchDbService$Proxy$_$$_Weld$EnterpriseProxy$.runSchemaPatchesForAllTenants(Unknown Source)
  220. ... 19 more
  221. Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set com/sirma/itt/patch/changelog.xml::seip-1.20.0-12::bbonev:
  222. Reason: liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "idx_lock_id"
  223. Detail: Key (lockedinstanceid)=(emf:a0c9e1f2-d4d7-4304-9fc1-251625552e8b) already exists.
  224. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:586)
  225. at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:43)
  226. at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)
  227. at liquibase.Liquibase.update(Liquibase.java:200)
  228. at liquibase.Liquibase.update(Liquibase.java:181)
  229. at liquibase.Liquibase.update(Liquibase.java:174)
  230. at com.sirma.itt.seip.db.patch.DatabasePatcher.patchDatabase(DatabasePatcher.java:47)
  231. ... 89 more
  232. Caused by: liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "idx_lock_id"
  233. Detail: Key (lockedinstanceid)=(emf:a0c9e1f2-d4d7-4304-9fc1-251625552e8b) already exists.
  234. at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:316)
  235. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  236. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)
  237. at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1227)
  238. at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1210)
  239. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:550)
  240. ... 95 more
  241. Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "idx_lock_id"
  242. Detail: Key (lockedinstanceid)=(emf:a0c9e1f2-d4d7-4304-9fc1-251625552e8b) already exists.
  243. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
  244. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
  245. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
  246. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
  247. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:406)
  248. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:398)
  249. at sun.reflect.GeneratedMethodAccessor255.invoke(Unknown Source)
  250. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  251. at java.lang.reflect.Method.invoke(Method.java:497)
  252. at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:453)
  253. at com.sun.proxy.$Proxy86.execute(Unknown Source)
  254. at org.jboss.jca.adapters.jdbc.WrappedStatement.execute(WrappedStatement.java:157)
  255. at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314)
  256. ... 100 more
  257.  
  258. 2015-11-20 15:26:34,512 ERROR [com.sirma.itt.seip.runtime.boot.RuntimeStartup] (SystemThread-1) {t=system.tenant, u=systemadmin} Component PatchDbService.runSchemaPatchesForAllTenants throw an exception on startup: com.sirma.itt.seip.runtime.boot.StartupException: Component PatchDbService.runSchemaPatchesForAllTenants failed to start
  259. at com.sirma.itt.seip.tenant.security.interceptor.RunAsTenantComponentDecorator.start(RunAsTenantComponentDecorator.java:69)
  260. at com.sirma.itt.seip.runtime.boot.RuntimeStartup.startComponent(RuntimeStartup.java:286)
  261. at com.sirma.itt.seip.runtime.boot.RuntimeStartup.invokeOrScheduleComponent(RuntimeStartup.java:272)
  262. at com.sirma.itt.seip.runtime.boot.RuntimeStartup.lambda$startComponents$8(RuntimeStartup.java:250)
  263. at com.sirma.itt.seip.runtime.boot.RuntimeStartup$$Lambda$23/1560941616.apply(Unknown Source)
  264. at java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193)
  265. at java.util.stream.SortedOps$SizedRefSortingSink.end(SortedOps.java:352)
  266. at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:513)
  267. at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:502)
  268. at java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708)
  269. at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
  270. at java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:499)
  271. at com.sirma.itt.seip.runtime.boot.RuntimeStartup.startComponents(RuntimeStartup.java:252)
  272. at com.sirma.itt.seip.runtime.boot.RuntimeStartup.loadPhase(RuntimeStartup.java:186)
  273. at com.sirma.itt.seip.runtime.boot.RuntimeStartup.lambda$createSteps$2(RuntimeStartup.java:125)
  274. at com.sirma.itt.seip.runtime.boot.RuntimeStartup$$Lambda$137/1920898001.execute(Unknown Source)
  275. at com.sirma.itt.seip.runtime.boot.RuntimeStartup.loadApplicationAfterDeployment(RuntimeStartup.java:106)
  276. at com.sirma.itt.seip.runtime.boot.RuntimeStartup$$Lambda$133/5380370.run(Unknown Source)
  277. at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  278. at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  279. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  280. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  281. at java.lang.Thread.run(Thread.java:745)
  282. at com.sirma.itt.seip.security.context.ThreadFactories$SystemThread.run(ThreadFactories.java:92)
  283. Suppressed: java.lang.IllegalStateException: Bean method class com.sirma.itt.seip.db.patch.PatchDbService.runSchemaPatchesForAllTenants invoke failed!
  284. at com.sirma.itt.seip.util.CDI.invokeMethod(CDI.java:243)
  285. at com.sirma.itt.seip.runtime.boot.MethodComponentInstance.start(MethodComponentInstance.java:54)
  286. at com.sirma.itt.seip.tenant.security.interceptor.RunAsTenantComponentDecorator.executeInTenantContext(RunAsTenantComponentDecorator.java:80)
  287. at com.sirma.itt.seip.tenant.security.interceptor.RunAsTenantComponentDecorator.lambda$start$9(RunAsTenantComponentDecorator.java:61)
  288. at com.sirma.itt.seip.tenant.security.interceptor.RunAsTenantComponentDecorator$$Lambda$166/179087150.accept(Unknown Source)
  289. at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
  290. at java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193)
  291. at java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:948)
  292. at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:512)
  293. at java.util.stream.ForEachOps$ForEachTask.compute(ForEachOps.java:291)
  294. at java.util.concurrent.CountedCompleter.exec(CountedCompleter.java:731)
  295. at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:289)
  296. at java.util.concurrent.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1056)
  297. at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1689)
  298. at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:157)
  299. Caused by: java.lang.reflect.InvocationTargetException
  300. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  301. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  302. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  303. at java.lang.reflect.Method.invoke(Method.java:497)
  304. at com.sirma.itt.seip.util.CDI.invokeMethod(CDI.java:241)
  305. ... 14 more
  306. Caused by: com.sirma.itt.seip.exception.RollbackedException: liquibase.exception.MigrationFailedException: Migration failed for change set com/sirma/itt/patch/changelog.xml::seip-1.20.0-12::bbonev:
  307. Reason: liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "idx_lock_id"
  308. Detail: Key (lockedinstanceid)=(emf:a0c9e1f2-d4d7-4304-9fc1-251625552e8b) already exists.
  309. at com.sirma.itt.seip.db.patch.DatabasePatcher.patchDatabase(DatabasePatcher.java:49)
  310. at com.sirma.itt.seip.db.patch.PatchDbService.patchSchema(PatchDbService.java:89)
  311. at com.sirma.itt.seip.db.patch.PatchDbService.runSchemaPatchesForAllTenants(PatchDbService.java:64)
  312. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  313. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  314. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  315. at java.lang.reflect.Method.invoke(Method.java:497)
  316. at org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
  317. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  318. at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437)
  319. at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:82)
  320. at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:93)
  321. at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
  322. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  323. at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)
  324. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  325. at org.jboss.as.ejb3.tx.EjbBMTInterceptor.handleInvocation(EjbBMTInterceptor.java:103)
  326. at org.jboss.as.ejb3.tx.BMTInterceptor.processInvocation(BMTInterceptor.java:58)
  327. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  328. at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437)
  329. at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73)
  330. at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83)
  331. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  332. at org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45)
  333. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  334. at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
  335. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  336. at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
  337. at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:52)
  338. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  339. at org.jboss.as.ejb3.component.singleton.SingletonComponentInstanceAssociationInterceptor.processInvocation(SingletonComponentInstanceAssociationInterceptor.java:53)
  340. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  341. at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
  342. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  343. at org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:43)
  344. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  345. at org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:100)
  346. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  347. at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)
  348. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  349. at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:66)
  350. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  351. at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
  352. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  353. at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:54)
  354. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  355. at org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64)
  356. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  357. at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356)
  358. at org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:634)
  359. at org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:61)
  360. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  361. at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356)
  362. at org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80)
  363. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  364. at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
  365. at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:195)
  366. at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:185)
  367. at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
  368. at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
  369. at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:73)
  370. at com.sirma.itt.seip.db.patch.PatchDbService$$$view6.runSchemaPatchesForAllTenants(Unknown Source)
  371. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  372. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  373. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  374. at java.lang.reflect.Method.invoke(Method.java:497)
  375. at org.jboss.weld.util.reflection.Reflections.invokeAndUnwrap(Reflections.java:434)
  376. at org.jboss.weld.bean.proxy.EnterpriseBeanProxyMethodHandler.invoke(EnterpriseBeanProxyMethodHandler.java:127)
  377. at org.jboss.weld.bean.proxy.EnterpriseTargetBeanInstance.invoke(EnterpriseTargetBeanInstance.java:56)
  378. at org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:100)
  379. at com.sirma.itt.seip.db.patch.PatchDbService$Proxy$_$$_Weld$EnterpriseProxy$.runSchemaPatchesForAllTenants(Unknown Source)
  380. ... 19 more
  381. Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set com/sirma/itt/patch/changelog.xml::seip-1.20.0-12::bbonev:
  382. Reason: liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "idx_lock_id"
  383. Detail: Key (lockedinstanceid)=(emf:a0c9e1f2-d4d7-4304-9fc1-251625552e8b) already exists.
  384. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:586)
  385. at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:43)
  386. at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)
  387. at liquibase.Liquibase.update(Liquibase.java:200)
  388. at liquibase.Liquibase.update(Liquibase.java:181)
  389. at liquibase.Liquibase.update(Liquibase.java:174)
  390. at com.sirma.itt.seip.db.patch.DatabasePatcher.patchDatabase(DatabasePatcher.java:47)
  391. ... 89 more
  392. Caused by: liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "idx_lock_id"
  393. Detail: Key (lockedinstanceid)=(emf:a0c9e1f2-d4d7-4304-9fc1-251625552e8b) already exists.
  394. at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:316)
  395. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  396. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)
  397. at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1227)
  398. at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1210)
  399. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:550)
  400. ... 95 more
  401. Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "idx_lock_id"
  402. Detail: Key (lockedinstanceid)=(emf:a0c9e1f2-d4d7-4304-9fc1-251625552e8b) already exists.
  403. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
  404. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
  405. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
  406. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
  407. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:406)
  408. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:398)
  409. at sun.reflect.GeneratedMethodAccessor255.invoke(Unknown Source)
  410. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  411. at java.lang.reflect.Method.invoke(Method.java:497)
  412. at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:453)
  413. at com.sun.proxy.$Proxy86.execute(Unknown Source)
  414. at org.jboss.jca.adapters.jdbc.WrappedStatement.execute(WrappedStatement.java:157)
  415. at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314)
  416. ... 100 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!