wearefrank / ladybug

Enable users of your application to debug and test it
Apache License 2.0
13 stars 8 forks source link

Ladybug fails to store any reports in Postgres database with default settings (SQLException: "Large Objects may not be used in auto-commit mode") #230

Closed MLenterman closed 5 months ago

MLenterman commented 6 months ago

No visible error is being thrown during execution of the pipelines. This error is visible in Ladybug when clicking the refresh button. Looks like reports are not being saved at all.

[PreparedStatementCallback; uncategorized SQLException for SQL [insert into LADYBUG (endTime, duration, name, soapAction, identificatie, correlationId, status, numberOfCheckpoints, estimatedMemoryUsage, storageSize, report) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [25P01]; error code [0]; Large Objects may not be used in auto-commit mode.; nested exception is org.postgresql.util.PSQLException: Large Objects may not be used in auto-commit mode.]
jacodg commented 5 months ago

https://github.com/wearefrank/ladybug/commit/356ed4c29352f765693f9575240133f823d4c75a https://github.com/frankframework/frankframework/pull/6647 https://github.com/frankframework/frankframework/pull/6648