transfer-process-store-sql : Object has already been returned to this pool or is invalid

[marc-despland]

Hello

I trying to use Postgres to persist control-plane data for an http-pull connector
It works well with all the extension excepted for transfer-process and contract-negociation (the 2 that are using sql-lease)

both generate error at startup :

SEVERE 2023-05-29T05:33:35.801417285 StateMachineManager [transfer-process] error caught java.lang.IllegalStateException: Object has already been returned to this pool or is invalid at org.apache.commons.pool2.impl.BaseGenericObjectPool.markReturningState(BaseGenericObjectPool.java:1251) at org.apache.commons.pool2.impl.GenericObjectPool.returnObject(GenericObjectPool.java:1029) at org.eclipse.edc.sql.pool.commons.CommonsConnectionPool.returnConnection(CommonsConnectionPool.java:76) at org.eclipse.edc.sql.datasource.PooledDataSourceConnection.close(PooledDataSourceConnection.java:96) at org.eclipse.edc.connector.store.sql.transferprocess.store.SqlTransferProcessStore.lambda$nextNotLeased$1(SqlTransferProcessStore.java:84) at org.eclipse.edc.transaction.spi.NoopTransactionContext.execute(NoopTransactionContext.java:34) at org.eclipse.edc.connector.store.sql.transferprocess.store.SqlTransferProcessStore.nextNotLeased(SqlTransferProcessStore.java:70) at org.eclipse.edc.connector.transfer.process.TransferProcessManagerImpl.lambda$processTransfersInState$43(TransferProcessManagerImpl.java:715) at org.eclipse.edc.statemachine.StateProcessorImpl.process(StateProcessorImpl.java:46) at java.base/java.util.stream.ReferencePipeline$5$1.accept(ReferencePipeline.java:231) at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1625) at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509) at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499) at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:921) at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) at java.base/java.util.stream.LongPipeline.reduce(LongPipeline.java:498) at java.base/java.util.stream.LongPipeline.sum(LongPipeline.java:456) at org.eclipse.edc.statemachine.StateMachineManager.performLogic(StateMachineManager.java:118) at org.eclipse.edc.statemachine.StateMachineManager.lambda$loop$2(StateMachineManager.java:106) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at java.base/java.lang.Thread.run(Thread.java:833)

I don't understand where the problem come from, I probably missing something

build.gradle.kts.txt

[ndr-brt]

It could be related to this bug: #3088
It has been solved and it will be part of the next release (0.1.0)

[marc-despland]

Yes, pehaps, but here the database is empty
there is no lease at all

[marc-despland]

I have solve my issue :)
I have add implementation("${edcGroupId}:transaction-local:${edcVersion}") to my build.gradle.kts ... and no more error