db_1 | ERROR: duplicate key value violates unique constraint "idx_forcedid_type_fid"
db_1 | DETAIL: Key (resource_type, forced_id)=(List, 0d33e2) already exists.
db_1 | STATEMENT: insert into HFJ_FORCED_ID (FORCED_ID, RESOURCE_PID, RESOURCE_TYPE, PID) values ($1, $2, $3, $4)
fhir_1 | 2019-06-26 17:58:16.823 [qtp2101440631-4901] INFO o.h.e.j.b.internal.AbstractBatchImpl [AbstractBatchImpl.java:201] HHH000010: On release of batch it still contained JDBC statements
fhir_1 | 2019-06-26 17:58:16.823 [qtp2101440631-4901] ERROR o.h.e.j.batch.internal.BatchingBatch [BatchingBatch.java:128] HHH000315: Exception executing batch [java.sql.BatchUpdateException: Batch entry 0 insert into HFJ_FORCED_ID (FORCED_ID, RESOURCE_PID, RESOURCE_TYPE, PID) values ('0d33e2', 20848, 'List', 20848) was aborted: ERROR: duplicate key value violates unique constraint "idx_forcedid_type_fid"
fhir_1 | Detail: Key (resource_type, forced_id)=(List, 0d33e2) already exists. Call getNextException to see other errors in the batch.], SQL: insert into HFJ_FORCED_ID (FORCED_ID, RESOURCE_PID, RESOURCE_TYPE, PID) values (?, ?, ?, ?)
fhir_1 | 2019-06-26 17:58:16.823 [qtp2101440631-4901] WARN o.h.e.jdbc.spi.SqlExceptionHelper [SqlExceptionHelper.java:137] SQL Error: 0, SQLState: 23505
fhir_1 | 2019-06-26 17:58:16.824 [qtp2101440631-4901] ERROR o.h.e.jdbc.spi.SqlExceptionHelper [SqlExceptionHelper.java:142] Batch entry 0 insert into HFJ_FORCED_ID (FORCED_ID, RESOURCE_PID, RESOURCE_TYPE, PID) values ('0d33e2', 20848, 'List', 20848) was aborted: ERROR: duplicate key value violates unique constraint "idx_forcedid_type_fid"
fhir_1 | Detail: Key (resource_type, forced_id)=(List, 0d33e2) already exists. Call getNextException to see other errors in the batch.
fhir_1 | 2019-06-26 17:58:16.824 [qtp2101440631-4901] ERROR o.h.e.jdbc.spi.SqlExceptionHelper [SqlExceptionHelper.java:142] ERROR: duplicate key value violates unique constraint "idx_forcedid_type_fid"
fhir_1 | Detail: Key (resource_type, forced_id)=(List, 0d33e2) already exists.
fhir_1 | 2019-06-26 17:58:16.830 [qtp2101440631-4901] ERROR c.u.f.r.s.i.ExceptionHandlingInterceptor [ExceptionHandlingInterceptor.java:134] Failure during REST processing
fhir_1 | ca.uhn.fhir.rest.server.exceptions.InternalErrorException: Failed to call access method: org.springframework.dao.DataIntegrityViolationException: could not execute batch; SQL [insert into HFJ_FORCED_ID (FORCED_ID, RESOURCE_PID, RESOURCE_TYPE, PID) values (?, ?, ?, ?)]; constraint [idx_forcedid_type_fid]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute batch
fhir_1 | at ca.uhn.fhir.rest.server.method.BaseMethodBinding.invokeServerMethod(BaseMethodBinding.java:272)
fhir_1 | at ca.uhn.fhir.rest.server.method.BaseOutcomeReturningMethodBinding.invokeServer(BaseOutcomeReturningMethodBinding.java:159)
fhir_1 | at ca.uhn.fhir.rest.server.method.UpdateMethodBinding.invokeServer(UpdateMethodBinding.java:44)
fhir_1 | at ca.uhn.fhir.rest.server.RestfulServer.handleRequest(RestfulServer.java:988)
fhir_1 | at ca.uhn.fhir.rest.server.RestfulServer.doPut(RestfulServer.java:348)
fhir_1 | at ca.uhn.fhir.rest.server.RestfulServer.service(RestfulServer.java:1594)
fhir_1 | at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
fhir_1 | at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:873)
fhir_1 | at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1623)
fhir_1 | at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:214)
fhir_1 | at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)
fhir_1 | at org.ebaysf.web.cors.CORSFilter.handleNonCORS(CORSFilter.java:437)
fhir_1 | at org.ebaysf.web.cors.CORSFilter.doFilter(CORSFilter.java:172)
fhir_1 | at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1602)
fhir_1 | at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:540)
fhir_1 | at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)
fhir_1 | at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
fhir_1 | at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
fhir_1 | at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)
fhir_1 | at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1700)
fhir_1 | at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
fhir_1 | at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1345)
fhir_1 | at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)
fhir_1 | at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:480)
fhir_1 | at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1667)
fhir_1 | at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)
fhir_1 | at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1247)
fhir_1 | at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
fhir_1 | at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:220)
fhir_1 | at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:152)
fhir_1 | at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
fhir_1 | at org.eclipse.jetty.server.Server.handle(Server.java:505)
fhir_1 | at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:370)
fhir_1 | at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:267)
fhir_1 | at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:305)
fhir_1 | at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
fhir_1 | at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117)
fhir_1 | at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:698)
fhir_1 | at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:804)
fhir_1 | at java.base/java.lang.Thread.run(Thread.java:834)
fhir_1 | Caused by: java.lang.reflect.InvocationTargetException: null
fhir_1 | at jdk.internal.reflect.GeneratedMethodAccessor110.invoke(Unknown Source)
fhir_1 | at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
fhir_1 | at java.base/java.lang.reflect.Method.invoke(Method.java:566)
fhir_1 | at ca.uhn.fhir.rest.server.method.BaseMethodBinding.invokeServerMethod(BaseMethodBinding.java:267)
fhir_1 | ... 39 common frames omitted
fhir_1 | Caused by: org.springframework.dao.DataIntegrityViolationException: could not execute batch; SQL [insert into HFJ_FORCED_ID (FORCED_ID, RESOURCE_PID, RESOURCE_TYPE, PID) values (?, ?, ?, ?)]; constraint [idx_forcedid_type_fid]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute batch
fhir_1 | at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:296)
fhir_1 | at ca.uhn.fhir.jpa.config.HapiFhirHibernateJpaDialect.convertHibernateAccessException(HapiFhirHibernateJpaDialect.java:105)
fhir_1 | at ca.uhn.fhir.jpa.config.HapiFhirHibernateJpaDialect.convertHibernateAccessException(HapiFhirHibernateJpaDialect.java:65)
fhir_1 | at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:253)
fhir_1 | at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:536)
fhir_1 | at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:746)
fhir_1 | at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:714)
fhir_1 | at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:533)
fhir_1 | at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:304)
fhir_1 | at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
fhir_1 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
fhir_1 | at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
fhir_1 | at com.sun.proxy.$Proxy156.update(Unknown Source)
fhir_1 | at ca.uhn.fhir.jpa.provider.r4.JpaResourceProviderR4.update(JpaResourceProviderR4.java:155)
fhir_1 | ... 43 common frames omitted
fhir_1 | Caused by: org.hibernate.exception.ConstraintViolationException: could not execute batch
fhir_1 | at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112)
fhir_1 | at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
fhir_1 | at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
fhir_1 | at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:129)
fhir_1 | at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:105)
fhir_1 | at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:147)
fhir_1 | at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.getBatch(JdbcCoordinatorImpl.java:201)
fhir_1 | at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3155)
fhir_1 | at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3696)
fhir_1 | at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:90)
fhir_1 | at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)
fhir_1 | at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:478)
fhir_1 | at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:356)
fhir_1 | at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
fhir_1 | at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1484)
fhir_1 | at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:515)
fhir_1 | at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3355)
fhir_1 | at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2526)
fhir_1 | at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:473)
fhir_1 | at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:178)
fhir_1 | at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:39)
fhir_1 | at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:271)
fhir_1 | at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:104)
fhir_1 | at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:532)
fhir_1 | ... 52 common frames omitted
fhir_1 | Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into HFJ_FORCED_ID (FORCED_ID, RESOURCE_PID, RESOURCE_TYPE, PID) values ('0d33e2', 20848, 'List', 20848) was aborted: ERROR: duplicate key value violates unique constraint "idx_forcedid_type_fid"
fhir_1 | Detail: Key (resource_type, forced_id)=(List, 0d33e2) already exists. Call getNextException to see other errors in the batch.
fhir_1 | at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:148)
fhir_1 | at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2184)
fhir_1 | at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:481)
fhir_1 | at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:840)
fhir_1 | at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1538)
fhir_1 | at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:223)
fhir_1 | at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:223)
fhir_1 | at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:119)
fhir_1 | ... 72 common frames omitted
fhir_1 | Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "idx_forcedid_type_fid"
fhir_1 | Detail: Key (resource_type, forced_id)=(List, 0d33e2) already exists.
fhir_1 | at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
fhir_1 | at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
fhir_1 | ... 78 common frames omitted
fhir_1 | 2019-06-26 17:58:16.830 [qtp2101440631-4901] INFO fhir.access [LoggingInterceptor.java:156] ERROR - update - List/0d33e2