[JIRA] (JJDBC-15) PostGreSQL: InputOutputError upon Logout, autoCommit enabled

[Martin Hitschel (Jira)]

Martin Hitschel ( https://shibboleth.atlassian.net/secure/ViewProfile.jspa?accountId=60ad392346b55100698aa768 ) *created* an issue

Plugin - JDBC StorageService ( https://shibboleth.atlassian.net/browse/JJDBC?atlOrigin=eyJpIjoiYTRlYTAyN2U4ZTc5NGExMDk2MzJiZTg3ZGU2NGZiM2YiLCJwIjoiaiJ9 ) / Bug ( https://shibboleth.atlassian.net/browse/JJDBC-15?atlOrigin=eyJpIjoiYTRlYTAyN2U4ZTc5NGExMDk2MzJiZTg3ZGU2NGZiM2YiLCJwIjoiaiJ9 ) JJDBC-15 ( https://shibboleth.atlassian.net/browse/JJDBC-15?atlOrigin=eyJpIjoiYTRlYTAyN2U4ZTc5NGExMDk2MzJiZTg3ZGU2NGZiM2YiLCJwIjoiaiJ9 ) PostGreSQL: InputOutputError upon Logout, autoCommit enabled ( https://shibboleth.atlassian.net/browse/JJDBC-15?atlOrigin=eyJpIjoiYTRlYTAyN2U4ZTc5NGExMDk2MzJiZTg3ZGU2NGZiM2YiLCJwIjoiaiJ9 )

Issue Type: Bug Affects Versions: 1.0.3 Assignee: Rod Widdowson ( https://shibboleth.atlassian.net/secure/ViewProfile.jspa?accountId=59fb32bbc24efb3c4ed3c977 ) Created: 11/Aug/22 4:37 AM Priority: Trivial Reporter: Martin Hitschel ( https://shibboleth.atlassian.net/secure/ViewProfile.jspa?accountId=60ad392346b55100698aa768 )

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

Logs say: Caused by: org.postgresql.util.PSQLException: Cannot commit when *autoComm*it is enabled.

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

( https://shibboleth.atlassian.net/browse/JJDBC-15#add-comment?atlOrigin=eyJpIjoiYTRlYTAyN2U4ZTc5NGExMDk2MzJiZTg3ZGU2NGZiM2YiLCJwIjoiaiJ9 ) Add Comment ( https://shibboleth.atlassian.net/browse/JJDBC-15#add-comment?atlOrigin=eyJpIjoiYTRlYTAyN2U4ZTc5NGExMDk2MzJiZTg3ZGU2NGZiM2YiLCJwIjoiaiJ9 )

Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.core&referrer=utm_source%3DNotificationLink%26utm_medium%3DEmail ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailNotificationLink&mt=8 ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100204- sha1:f3df60f )
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shibboleth.net/pipermail/commits/attachments/20220811/8e35fe54/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-static-comment-icon-9f6ac3da-8eba-4338-b352-a784c75320cb
Type: image/png
Size: 1084 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220811/8e35fe54/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-static-trivial-fbed70f1-745a-4755-a883-56301d8d1d20
Type: image/png
Size: 563 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220811/8e35fe54/attachment-0005.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-avatar-3e3139a1-c342-4fbd-b55c-4f9f76b676e1
Type: image/png
Size: 425 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220811/8e35fe54/attachment-0006.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-static-footer-desktop-logo-3bd389fc-65e0-4399-800d-f4ed219072a8
Type: image/png
Size: 10805 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220811/8e35fe54/attachment-0007.png>