Can not connect to the server after upgrading to beta-20170406

General
#1

My JDBC url:
jdbc:postgresql://db1:26257,db2:26257,db3:26257/test_saas_open_stat?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory&loadBalanceHosts=true

I also have username and password set.

This works before. But now I got the following error:
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@5e468682 – Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
org.postgresql.util.PSQLException: ERROR: there is no transaction in progress

#2

Thanks for the report! It’s probably this change which disallowed SHOW TRANSACTION ISOLATION and SHOW TRANSACTION PRIORITY outside of transactions. It looks like some software in your stack (c3p0?) is issuing these queries as soon as it opens a connection, so we need to report the default values outside of transactions. We’ll get this fixed for the next beta.

#3

Addressed in https://github.com/cockroachdb/cockroach/pull/14747 .