Tests failing on 42.5.3 yet succeed on 42.5.2 #2804
Description
Describe the issue
Running the test suites in 42.5.3 fails while 42.5.2 succeeds. According to the CHANGELOG.md on tag 42.5.3, the previous version, 42.5.2 has a regression:
regression: This release has 2 known regressions which make it unusable see the notes above. We advise people to use 42.5.3 instead.
Driver Version?
Java Version?
OS Version?
CentOS 7, RHEL8
PostgreSQL Version?
All the latest minor versions of : 11, 12, 13, 14, 15
To Reproduce
./gradlew -PskipReplicationTests testExpected behaviour
Expecting tests to pass. Instead tests fail.
Logs
Test output:
PGPropertyUtilTest > propertiesConsistencyCheck() STANDARD_ERROR
Feb 14, 2023 1:51:31 PM org.postgresql.util.PGPropertyUtil convertPgPortToInt
WARNING: JDBC URL port: 0 not valid (1:65535)
Feb 14, 2023 1:51:31 PM org.postgresql.util.PGPropertyUtil convertPgPortToInt
WARNING: JDBC URL port: 65536 not valid (1:65535)
Feb 14, 2023 1:51:31 PM org.postgresql.util.PGPropertyUtil convertPgPortToInt
WARNING: JDBC URL invalid port number: abcdef
13.0sec, org.postgresql.core.AsciiStringInternerTest > testGarbageCleaning
13.0sec, 5 completed, 0 failed, 0 skipped, org.postgresql.core.AsciiStringInternerTest
FAILURE 0.0sec, org.postgresql.core.OidValuesCorrectnessTest > testValue[oidName=BOX_ARRAY, oidValue=1,020]
java.lang.AssertionError: Oid value doesn't exist for oid BOX_ARRAY;with used type: BOX_ARRAY
at org.junit.Assert.fail(Assert.java:89)
at org.junit.Assert.assertTrue(Assert.java:42)
at org.postgresql.core.OidValuesCorrectnessTest.testValue(OidValuesCorrectnessTest.java:129)
FAILURE 0.0sec, 1 completed, 1 failed, 0 skipped, org.postgresql.core.OidValuesCorrectnessTest > [oidName=BOX_ARRAY, oidValue=1,020]
FAILURE 0.6sec, 72 completed, 1 failed, 0 skipped, org.postgresql.core.OidValuesCorrectnessTest
10.1sec, org.postgresql.jdbc.ConnectionValidTest > testIsValid
10.1sec, 1 completed, 0 failed, 0 skipped, org.postgresql.jdbc.ConnectionValidTest
PgSQLXMLTest > testGetSourceXxeSAXSource STANDARD_ERROR
ERROR: 'DOCTYPE is disallowed when the feature "http://apache.org/xml/features/disallow-doctype-decl" set to true.'
JavaVersionTest > testGetRuntimeVersion STANDARD_OUT
java.version = 1.8.0_362, JavaVersion.getRuntimeVersion() = v1_8
0.6sec, 42 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc2.ArrayTest
0.6sec, 33 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc2.BatchExecuteTest > [binary = FORCE, insertRewrite = true]
1.9sec, 132 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc2.BatchExecuteTest
7.7sec, 184 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc2.BatchFailureTest
0.6sec, 15 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc2.BatchedInsertReWriteEnabledTest > [0: autoCommit=YES, binary=REGULAR]
0.5sec, 15 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc2.BatchedInsertReWriteEnabledTest > [1: autoCommit=YES, binary=FORCE]
0.5sec, 15 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc2.BatchedInsertReWriteEnabledTest > [3: autoCommit=NO, binary=FORCE]
2.0sec, 60 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc2.BatchedInsertReWriteEnabledTest
5.0sec, org.postgresql.test.jdbc2.ConnectTimeoutTest > testTimeout
5.0sec, 1 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc2.ConnectTimeoutTest
3.1sec, org.postgresql.test.jdbc2.CopyLargeFileTest > testFeedTableSeveralTimesTest
3.1sec, 1 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc2.CopyLargeFileTest
0.5sec, 32 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc2.CursorFetchTest
2.4sec, org.postgresql.test.jdbc2.DatabaseEncodingTest > testEncoding
2.7sec, org.postgresql.test.jdbc2.DatabaseEncodingTest > testUTF8Decode
5.0sec, 3 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc2.DatabaseEncodingTest
FAILURE 0.0sec, org.postgresql.test.jdbc2.DatabaseMetaDataCacheTest > testGetSQLTypeQueryCache
java.lang.AssertionError: expected:<1> but was:<0>
at org.junit.Assert.fail(Assert.java:89)
at org.junit.Assert.failNotEquals(Assert.java:835)
at org.junit.Assert.assertEquals(Assert.java:647)
at org.junit.Assert.assertEquals(Assert.java:633)
at org.postgresql.test.jdbc2.DatabaseMetaDataCacheTest.testGetSQLTypeQueryCache(DatabaseMetaDataCacheTest.java:67)
FAILURE 0.0sec, 3 completed, 1 failed, 0 skipped, org.postgresql.test.jdbc2.DatabaseMetaDataCacheTest
2.9sec, 58 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc2.DatabaseMetaDataTest > [binary = REGULAR]
3.1sec, 58 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc2.DatabaseMetaDataTest > [binary = FORCE]
6.0sec, 116 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc2.DatabaseMetaDataTest
WARNING 2.1sec, 192 completed, 0 failed, 14 skipped, org.postgresql.test.jdbc2.DateTest
5.0sec, org.postgresql.test.jdbc2.LoginTimeoutTest > testTimeoutOccurs
LoginTimeoutTest > testBadTimeout STANDARD_ERROR
Feb 14, 2023 1:52:37 PM org.postgresql.Driver timeout
WARNING: Couldnt parse loginTimeout value: {0}
5.0sec, 6 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc2.LoginTimeoutTest
1.5sec, 9 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc2.NotifyTest
0.7sec, 156 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc2.NumericTransferTest2
WARNING 0.6sec, 45 completed, 0 failed, 1 skipped, org.postgresql.test.jdbc2.PreparedStatementTest > [binary = REGULAR]
WARNING 0.7sec, 45 completed, 0 failed, 3 skipped, org.postgresql.test.jdbc2.PreparedStatementTest > [binary = FORCE]
WARNING 1.4sec, 90 completed, 0 failed, 4 skipped, org.postgresql.test.jdbc2.PreparedStatementTest
12.8sec, 2912 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc2.QuotationTest
2.9sec, 384 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc2.RefCursorFetchTest
1.6sec, 60 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc2.ResultSetMetaDataTest
0.9sec, 31 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc2.ResultSetTest > [binary = REGULAR]
1.1sec, 31 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc2.ResultSetTest > [binary = FORCE]
2.0sec, 62 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc2.ResultSetTest
1.0sec, 1 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc2.SocketTimeoutTest
2.1sec, org.postgresql.test.jdbc2.StatementTest > testCancelQueryWithBrokenNetwork
2.0sec, org.postgresql.test.jdbc2.StatementTest > testMultipleCancels
2.0sec, org.postgresql.test.jdbc2.StatementTest > testSideStatementFinalizers
4.0sec, org.postgresql.test.jdbc2.StatementTest > testSetQueryTimeoutWithSleep
3.0sec, org.postgresql.test.jdbc2.StatementTest > testSetQueryTimeoutOnPrepared
10.0sec, org.postgresql.test.jdbc2.StatementTest > testShortQueryTimeout
2.0sec, org.postgresql.test.jdbc2.StatementTest > testSetQueryTimeoutWithoutExecute
StatementTest > testFastCloses STANDARD_OUT
[testFastCloses] total counts for each sql state: {55000=1000}
28.7sec, 42 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc2.StatementTest
0.6sec, 16 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc2.TimezoneTest
5.0sec, org.postgresql.test.jdbc2.TypeCacheDLLStressTest > createDropTableAndGetTypeInfo
5.0sec, 1 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc2.TypeCacheDLLStressTest
1.6sec, 29 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc2.UpdateableResultTest
WARNING 1.2sec, 19 completed, 0 failed, 1 skipped, org.postgresql.test.jdbc3.GeneratedKeysTest > [returningInQuery = NO, binary = FORCE]
WARNING 2.4sec, 152 completed, 0 failed, 2 skipped, org.postgresql.test.jdbc3.GeneratedKeysTest
0.5sec, 33 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc3.Jdbc3CallableStatementTest
0.9sec, 50 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc4.ArrayTest
0.6sec, 1 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc4.ConnectionValidTimeoutTest > [networkTimeoutMillis=500, validationTimeoutSeconds=1, expectedMaxValidationTimeMillis=600]
1.0sec, 1 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc4.ConnectionValidTimeoutTest > [networkTimeoutMillis=1,500, validationTimeoutSeconds=1, expectedMaxValidationTimeMillis=1,100]
1.0sec, 1 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc4.ConnectionValidTimeoutTest > [networkTimeoutMillis=0, validationTimeoutSeconds=1, expectedMaxValidationTimeMillis=1,100]
0.6sec, 1 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc4.ConnectionValidTimeoutTest > [networkTimeoutMillis=500, validationTimeoutSeconds=0, expectedMaxValidationTimeMillis=600]
3.2sec, 4 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc4.ConnectionValidTimeoutTest
WARNING 0.5sec, 41 completed, 0 failed, 1 skipped, org.postgresql.test.jdbc4.jdbc41.GetObjectTest
1.0sec, 4 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc4.jdbc41.NetworkTimeoutTest
SharedTimerClassLoaderLeakTest > sharedTimerDoesNotCauseLeak STANDARD_OUT
JUnit used sun.misc.Launcher$AppClassLoader@73d16e93
SeparateClassLoaderInvokeMethod used sun.misc.Launcher$AppClassLoader@73d16e93
Gradle Test Executor 2 STANDARD_OUT
se.jiderhamn.classloader.RedefiningClassLoader[org.postgresql.test.jdbc4.jdbc41.SharedTimerClassLoaderLeakTest.sharedTimerDoesNotCauseLeak]@79744dc1 is being finalized
1.3sec, 12 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc42.GetObject310Test > [binary = REGULAR]
1.7sec, 12 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc42.GetObject310Test > [binary = FORCE]
3.0sec, 24 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc42.GetObject310Test
WARNING 0.5sec, 72 completed, 0 failed, 8 skipped, org.postgresql.test.jdbc42.LargeCountJdbc42Test
1.0sec, 1 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc42.PreparedStatement64KBindsTest > [numBinds=65,536, preferQueryMode=EXTENDED_CACHE_EVERYTHING, binaryMode=REGULAR}]
5.4sec, 48 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc42.PreparedStatement64KBindsTest
3.6sec, org.postgresql.test.jdbc42.SetObject310Test > testSetOffsetDateTime[binary = REGULAR]
4.9sec, 13 completed, 0 failed, 0 skipped, org.postgresql.test.jdbc42.SetObject310Test > [binary = REGULAR]
2.9sec, org.postgresql.test.jdbc42.SetObject310Test > testSetOffsetDateTime[binary = FORCE]
WARNING 4.4sec, 13 completed, 0 failed, 3 skipped, org.postgresql.test.jdbc42.SetObject310Test > [binary = FORCE]
WARNING 9.3sec, 26 completed, 0 failed, 3 skipped, org.postgresql.test.jdbc42.SetObject310Test
PGPropertyMaxResultBufferParserTest > [3: Test with valueToParse=35G, expectedResult=1,288,647,475] > org.postgresql.test.util.PGPropertyMaxResultBufferParserTest.testGetMaxResultBufferValue[3: Test with valueToParse=35G, expectedResult=1,288,647,475] STANDARD_ERROR
Feb 14, 2023 1:54:11 PM org.postgresql.util.PGPropertyMaxResultBufferParser adjustResultSize
WARNING: WARNING! Required to allocate 35000000000 bytes, which exceeded possible heap memory size. Assigned 1288647475 bytes as limit.
PGPropertyMaxResultBufferParserTest > [4: Test with valueToParse=1T, expectedResult=1,288,647,475] > org.postgresql.test.util.PGPropertyMaxResultBufferParserTest.testGetMaxResultBufferValue[4: Test with valueToParse=1T, expectedResult=1,288,647,475] STANDARD_ERROR
Feb 14, 2023 1:54:11 PM org.postgresql.util.PGPropertyMaxResultBufferParser adjustResultSize
WARNING: WARNING! Required to allocate 1000000000000 bytes, which exceeded possible heap memory size. Assigned 1288647475 bytes as limit.
5.1sec, org.postgresql.util.BigDecimalByteConverter2Test > testBigDecimal10_pow_131072_minus_1
5.1sec, 1 completed, 0 failed, 0 skipped, org.postgresql.util.BigDecimalByteConverter2Test
FAILURE 171.0sec, 6646 completed, 2 failed, 105 skipped, Gradle Test Run :postgresql:test
6646 tests completed, 2 failed, 105 skipped
> Task :postgresql:test FAILED
FAILURE: Build failed with an exception.