Loading...

This issue belongs to an archived project. You can view it, but you can't modify it. Learn more

XML

Word

Printable

Details

Type: Bug
Resolution: Done
Priority: Critical
Fix Version/s: 1.4.0, 1.3.1
Affects Version/s: None
Component/s: datasource
Labels:
None

Sprint:
DV Sprint 55, DV Sprint 56, DV Sprint 58
Story Points:
1

Description

An attempt to set the isolation level on pg 42.2.8 resulted in an exception SQLSTATE 0a000 - unsupported - which causes the connection pool to mark the connection as broken:

2019-11-25 23:07:50.125  WARN 43993 --- [ProcessorQueue6] com.zaxxer.hikari.pool.ProxyConnection   : HikariPool-1 - Connection org.postgresql.jdbc.PgConnection@2ffebc7e marked as broken because of SQLSTATE(0A000), ErrorCode(0)

org.postgresql.util.PSQLException:
        at org.postgresql.jdbc.PgConnection.setTransactionIsolation(PgConnection.java:851) ~[postgresql-42.2.8.jar:42.2.8]
        at com.zaxxer.hikari.pool.ProxyConnection.setTransactionIsolation(ProxyConnection.java:407) ~[HikariCP-3.2.0.jar:na]
        at com.zaxxer.hikari.pool.HikariProxyConnection.setTransactionIsolation(HikariProxyConnection.java) ~[HikariCP-3.2.0.jar:na]
        at org.teiid.translator.jdbc.JDBCBaseExecution.<init>(JDBCBaseExecution.java:72) ~[translator-jdbc-12.3.0.jar:12.3.0]

Attachments

Activity

People

Assignee:: Steven Hawkins

Reporter:: Steven Hawkins

Archiver:: Aitik Dandapat

Dates

Created:: 2019/11/26 9:58 AM

Updated:: 2021/10/25 4:14 PM

Resolved:: 2020/01/16 2:11 PM

Archived:: 2023/05/16 10:14 AM

Time Tracking

Estimated:

Remaining:

Logged:

4h 30m

Calling setTransactionIsolation on pg driver causes the connection to be closed