org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [SELECT exchange FROM aggregation WHERE id = ?]; SQL state [25P02]; error code [0]; ERROR: current transaction is aborted, commands ignored until end of transaction block; nested exception is org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)[292:org.apache.servicemix.bundles.spring-jdbc:3.2.18.RELEASE_1]
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)[292:org.apache.servicemix.bundles.spring-jdbc:3.2.18.RELEASE_1]
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)[292:org.apache.servicemix.bundles.spring-jdbc:3.2.18.RELEASE_1]
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)[292:org.apache.servicemix.bundles.spring-jdbc:3.2.18.RELEASE_1]
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)[292:org.apache.servicemix.bundles.spring-jdbc:3.2.18.RELEASE_1]
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:668)[292:org.apache.servicemix.bundles.spring-jdbc:3.2.18.RELEASE_1]
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:676)[292:org.apache.servicemix.bundles.spring-jdbc:3.2.18.RELEASE_1]
        at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:731)[292:org.apache.servicemix.bundles.spring-jdbc:3.2.18.RELEASE_1]
        at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:747)[292:org.apache.servicemix.bundles.spring-jdbc:3.2.18.RELEASE_1]
        at org.apache.camel.processor.aggregate.jdbc.JdbcAggregationRepository$3.doInTransaction(JdbcAggregationRepository.java:279)[293:org.apache.camel.camel-sql:2.17.0.redhat-630371]
        at org.apache.camel.processor.aggregate.jdbc.JdbcAggregationRepository$3.doInTransaction(JdbcAggregationRepository.java:276)[293:org.apache.camel.camel-sql:2.17.0.redhat-630371]
        at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:131)[237:org.apache.servicemix.bundles.spring-tx:3.2.18.RELEASE_1]
        at org.apache.camel.processor.aggregate.jdbc.JdbcAggregationRepository.get(JdbcAggregationRepository.java:276)[293:org.apache.camel.camel-sql:2.17.0.redhat-630371]
        at org.apache.camel.processor.aggregate.jdbc.JdbcAggregationRepository.get(JdbcAggregationRepository.java:268)[293:org.apache.camel.camel-sql:2.17.0.redhat-630371]
        at org.apache.camel.processor.aggregate.AggregateProcessor.doAggregation(AggregateProcessor.java:386)[232:org.apache.camel.camel-core:2.17.0.redhat-630371]
        at org.apache.camel.processor.aggregate.AggregateProcessor.doProcess(AggregateProcessor.java:315)[232:org.apache.camel.camel-core:2.17.0.redhat-630371]
        at org.apache.camel.processor.aggregate.AggregateProcessor.process(AggregateProcessor.java:266)[232:org.apache.camel.camel-core:2.17.0.redhat-630371]
        at org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77)[232:org.apache.camel.camel-core:2.17.0.redhat-630371]
        at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:468)[232:org.apache.camel.camel-core:2.17.0.redhat-630371]
        at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:109)[232:org.apache.camel.camel-core:2.17.0.redhat-630371]
        at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:344)[232:org.apache.camel.camel-core:2.17.0.redhat-630371]
        at org.apache.camel.processor.DefaultErrorHandler.process(DefaultErrorHandler.java:60)[232:org.apache.camel.camel-core:2.17.0.redhat-630371]
        at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:171)[232:org.apache.camel.camel-core:2.17.0.redhat-630371]
      at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:468)[232:org.apache.camel.camel-core:2.17.0.redhat-630371]
        at org.apache.camel.spring.spi.TransactionErrorHandler.processByErrorHandler(TransactionErrorHandler.java:220)[238:org.apache.camel.camel-spring:2.17.0.redhat-630371]
        at org.apache.camel.spring.spi.TransactionErrorHandler.process(TransactionErrorHandler.java:101)[238:org.apache.camel.camel-spring:2.17.0.redhat-630371]
        at org.apache.camel.spring.spi.TransactionErrorHandler.process(TransactionErrorHandler.java:114)[238:org.apache.camel.camel-spring:2.17.0.redhat-630371]
        at org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77)[232:org.apache.camel.camel-core:2.17.0.redhat-630371]
        at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:468)[232:org.apache.camel.camel-core:2.17.0.redhat-630371]
        at org.apache.camel.spring.spi.TransactionErrorHandler.processByErrorHandler(TransactionErrorHandler.java:220)[238:org.apache.camel.camel-spring:2.17.0.redhat-630371]
        at org.apache.camel.spring.spi.TransactionErrorHandler$1.doInTransactionWithoutResult(TransactionErrorHandler.java:183)[238:org.apache.camel.camel-spring:2.17.0.redhat-630371]
        at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33)[237:org.apache.servicemix.bundles.spring-tx:3.2.18.RELEASE_1]
        at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:131)[237:org.apache.servicemix.bundles.spring-tx:3.2.18.RELEASE_1]
        at org.apache.camel.spring.spi.TransactionErrorHandler.doInTransactionTemplate(TransactionErrorHandler.java:176)[238:org.apache.camel.camel-spring:2.17.0.redhat-630371]
        at org.apache.camel.spring.spi.TransactionErrorHandler.processInTransaction(TransactionErrorHandler.java:136)[238:org.apache.camel.camel-spring:2.17.0.redhat-630371]
        at org.apache.camel.spring.spi.TransactionErrorHandler.process(TransactionErrorHandler.java:105)[238:org.apache.camel.camel-spring:2.17.0.redhat-630371]
        at org.apache.camel.spring.spi.TransactionErrorHandler.process(TransactionErrorHandler.java:114)[238:org.apache.camel.camel-spring:2.17.0.redhat-630371]
        at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:196)[232:org.apache.camel.camel-core:2.17.0.redhat-630371]
        at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:196)[232:org.apache.camel.camel-core:2.17.0.redhat-630371]
        at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:109)[232:org.apache.camel.camel-core:2.17.0.redhat-630371]
        at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:91)[232:org.apache.camel.camel-core:2.17.0.redhat-630371]
        at org.apache.camel.component.jms.EndpointMessageListener.onMessage(EndpointMessageListener.java:112)[244:org.apache.camel.camel-jms:2.17.0.redhat-630371]
        at org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:555)[243:org.apache.servicemix.bundles.spring-jms:3.2.18.RELEASE_1]
        at org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:515)[243:org.apache.servicemix.bundles.spring-jms:3.2.18.RELEASE_1]
        at org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:485)[243:org.apache.servicemix.bundles.spring-jms:3.2.18.RELEASE_1]
        at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:325)[243:org.apache.servicemix.bundles.spring-jms:3.2.18.RELEASE_1]
        at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:263)[243:org.apache.servicemix.bundles.spring-jms:3.2.18.RELEASE_1]
        at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:1103)[243:org.apache.servicemix.bundles.spring-jms:3.2.18.RELEASE_1]
        at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:1095)[243:org.apache.servicemix.bundles.spring-jms:3.2.18.RELEASE_1]
        at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:992)[243:org.apache.servicemix.bundles.spring-jms:3.2.18.RELEASE_1]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)[:1.8.0_201]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)[:1.8.0_201]
        at java.lang.Thread.run(Thread.java:748)[:1.8.0_201]
Caused by: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433)[301:org.postgresql.jdbc42:42.2.2]
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178)[301:org.postgresql.jdbc42:42.2.2]
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)[301:org.postgresql.jdbc42:42.2.2]
        at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)[301:org.postgresql.jdbc42:42.2.2]
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)[301:org.postgresql.jdbc42:42.2.2]
        at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:155)[301:org.postgresql.jdbc42:42.2.2]
        at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:118)[301:org.postgresql.jdbc42:42.2.2]
        at sun.reflect.GeneratedMethodAccessor168.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[:1.8.0_201]
        at java.lang.reflect.Method.invoke(Method.java:498)[:1.8.0_201]
        at org.postgresql.ds.PGPooledConnection$StatementHandler.invoke(PGPooledConnection.java:428)[301:org.postgresql.jdbc42:42.2.2]
        at com.sun.proxy.$Proxy60.executeQuery(Unknown Source)[301:org.postgresql.jdbc42:42.2.2]
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)[294:org.apache.servicemix.bundles.commons-dbcp:1.4.0.3]
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)[294:org.apache.servicemix.bundles.commons-dbcp:1.4.0.3]
        at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:646)[292:org.apache.servicemix.bundles.spring-jdbc:3.2.18.RELEASE_1]
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:589)[292:org.apache.servicemix.bundles.spring-jdbc:3.2.18.RELEASE_1]
        ... 49 more
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "aggregation_pk"
  Detail: Key (id)=(1) already exists.
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433)[301:org.postgresql.jdbc42:42.2.2]
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178)[301:org.postgresql.jdbc42:42.2.2]
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)[301:org.postgresql.jdbc42:42.2.2]
        at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)[301:org.postgresql.jdbc42:42.2.2]
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)[301:org.postgresql.jdbc42:42.2.2]
        at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:155)[301:org.postgresql.jdbc42:42.2.2]
        at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:132)[301:org.postgresql.jdbc42:42.2.2]
        at sun.reflect.GeneratedMethodAccessor169.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[:1.8.0_201]
        at java.lang.reflect.Method.invoke(Method.java:498)[:1.8.0_201]
        at org.postgresql.ds.PGPooledConnection$StatementHandler.invoke(PGPooledConnection.java:428)[301:org.postgresql.jdbc42:42.2.2]
        at com.sun.proxy.$Proxy60.executeUpdate(Unknown Source)[301:org.postgresql.jdbc42:42.2.2]
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)[294:org.apache.servicemix.bundles.commons-dbcp:1.4.0.3]
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)[294:org.apache.servicemix.bundles.commons-dbcp:1.4.0.3]
        at org.springframework.jdbc.core.support.AbstractLobCreatingPreparedStatementCallback.doInPreparedStatement(AbstractLobCreatingPreparedStatementCallback.java:75)[292:org.apache.servicemix.bundles.spring-jdbc:3.2.18.RELEASE_1]
        at org.springframework.jdbc.core.support.AbstractLobCreatingPreparedStatementCallback.doInPreparedStatement(AbstractLobCreatingPreparedStatementCallback.java:55)[292:org.apache.servicemix.bundles.spring-jdbc:3.2.18.RELEASE_1]
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:589)[292:org.apache.servicemix.bundles.spring-jdbc:3.2.18.RELEASE_1]
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:617)[292:org.apache.servicemix.bundles.spring-jdbc:3.2.18.RELEASE_1]
        at org.apache.camel.processor.aggregate.jdbc.JdbcAggregationRepository.insertAndUpdateHelper(JdbcAggregationRepository.java:240)[293:org.apache.camel.camel-sql:2.17.0.redhat-630371]
        at org.apache.camel.processor.aggregate.jdbc.JdbcAggregationRepository.insert(JdbcAggregationRepository.java:235)[293:org.apache.camel.camel-sql:2.17.0.redhat-630371]
        at org.apache.camel.processor.aggregate.jdbc.JdbcAggregationRepository$1.doInTransaction(JdbcAggregationRepository.java:154)[293:org.apache.camel.camel-sql:2.17.0.redhat-630371]
        at org.apache.camel.processor.aggregate.jdbc.JdbcAggregationRepository$1.doInTransaction(JdbcAggregationRepository.java:134)[293:org.apache.camel.camel-sql:2.17.0.redhat-630371]
        at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:131)[237:org.apache.servicemix.bundles.spring-tx:3.2.18.RELEASE_1]
        at org.apache.camel.processor.aggregate.jdbc.JdbcAggregationRepository.add(JdbcAggregationRepository.java:134)[293:org.apache.camel.camel-sql:2.17.0.redhat-630371]
        at org.apache.camel.processor.aggregate.jdbc.JdbcAggregationRepository.add(JdbcAggregationRepository.java:122)[293:org.apache.camel.camel-sql:2.17.0.redhat-630371]
        at org.apache.camel.processor.aggregate.AggregateProcessor.doAggregationRepositoryAdd(AggregateProcessor.java:515)[232:org.apache.camel.camel-core:2.17.0.redhat-630371]
        at org.apache.camel.processor.aggregate.AggregateProcessor.doAggregation(AggregateProcessor.java:470)[232:org.apache.camel.camel-core:2.17.0.redhat-630371]
        ... 38 more