Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

PostGreSQL: InputOutputError upon Logout, autoCommit enabled

Description

Upon a SAML Single Logout event, the IdP displays an "InputOutputError".

Logs say: Caused by: org.postgresql.util.PSQLException: Cannot commit when autoCommit is enabled.

Telling p:autoCommit="false" to the bean (wild guess) kept Tomcat from starting at all.

Environment

None

Activity

Rod WiddowsonAugust 17, 2022 at 1:09 PM

This has been fixed tested and a new version of the plugin released.

Rod WiddowsonAugust 16, 2022 at 7:39 PM

Customer reports sucessful testing on PostGreSQL.

I’ll cut a release tomorrow

Rod WiddowsonAugust 14, 2022 at 10:08 AM

I’ve build an example 1.0.4 it passes out tests so I’ve asked for further testing

Rod WiddowsonAugust 12, 2022 at 10:17 AM

So, on further reaserach this feels like a pure and simple bug. The Fine Manual states (anout commit() that

* This method should be * used only when auto-commit mode has been disabled.

I’m reviewing and testing the obvious bug fix. I’ll reach out to out OOB to get a test on PostGreSQL

Martin HitschelAugust 11, 2022 at 4:13 PM

Hi I can give it to the customer, I do not run postgresql either. He has a test system though grinning face with smiling eyes

Fixed

Details

Affects versions

Fix versions

Assignee

Reporter

Created August 11, 2022 at 8:37 AM
Updated August 17, 2022 at 1:09 PM
Resolved August 17, 2022 at 1:09 PM

Flag notifications