roachtest: pgjdbc failed #71564

cockroach-teamcity · 2021-10-14T12:32:13Z

roachtest.pgjdbc failed with artifacts on master @ 24d632ccabb7d03b887d399e705f7e1b6b9f7435:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/pgjdbc/run_1
	orm_helpers.go:245,orm_helpers.go:171,java_helpers.go:220,pgjdbc.go:185,pgjdbc.go:197,test_runner.go:777: 
		Tests run on Cockroach v21.2.0-alpha.00000000-4994-g24d632ccab
		Tests run against pgjdbc REL42.2.19
		5298 Total Tests Run
		4473 tests passed
		825 tests failed
		60 tests skipped
		185 tests ignored
		4 tests passed unexpectedly
		2 tests failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- PASS: org.postgresql.test.jdbc42.GetObject310Test.testGetLocalTimeInvalidType[binary = REGULAR] - https://github.com/cockroachdb/cockroach/issues/26097 (unexpected)
		--- PASS: org.postgresql.test.jdbc42.GetObject310Test.testGetLocalTimeInvalidType[binary = FORCE] - https://github.com/cockroachdb/cockroach/issues/26097 (unexpected)
		--- PASS: org.postgresql.test.jdbc2.PGTimeTest.testTimeInsertAndSelect - https://github.com/cockroachdb/cockroach/issues/41775 (unexpected)
		--- FAIL: org.postgresql.test.jdbc2.ArrayTest.testSetNullArrays[binary = FORCE] - unknown (unexpected)
		--- FAIL: org.postgresql.test.jdbc2.ArrayTest.testSetNullArrays[binary = REGULAR] - unknown (unexpected)
		--- PASS: org.postgresql.test.jdbc2.PGTimestampTest.testTimeInsertAndSelect - https://github.com/cockroachdb/cockroach/issues/41775 (unexpected)
		For a full summary look at the pgjdbc artifacts 
		
		An updated blocklist (pgjdbcBlockList21_2) is available in the artifacts' pgjdbc log

Reproduce

See: roachtest README

/cc @cockroachdb/sql-experience _{This test on roachdash | Improve this report!}

The text was updated successfully, but these errors were encountered:

rafiss · 2021-10-14T15:01:27Z

random guess, but probably the new passes are because of support for assignment casts. #70722

the testSetNullArrays failure is new, and is also because of assignment casts. cc @mgartner in case an explanation jumps out at you.

�[0;31;1mFAILURE�[0m   0.1sec, org.postgresql.test.jdbc2.�[0;1mArrayTest�[0m > �[0;1mtestSetNullArrays�[0m[binary = REGULAR]
    org.postgresql.util.PSQLException: ERROR: invalid assignment cast: unknown -> int[]
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323)
        at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481)
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401)
        at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164)
        at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:130)
        �[0;1mat org.postgresql.test.jdbc2.ArrayTest.testSetNullArrays(ArrayTest.java:349)

Test at https://github.com/pgjdbc/pgjdbc/blob/207ce36ec2c5cce30c454afa3e51f39bbe5bd26b/pgjdbc/src/test/java/org/postgresql/test/jdbc2/ArrayTest.java#L340

  @Test
  public void testSetNullArrays() throws SQLException {
    PreparedStatement pstmt = conn.prepareStatement("INSERT INTO arrtest VALUES (?,?,?)");

    final PGConnection arraySupport = conn.unwrap(PGConnection.class);

    pstmt.setArray(1, arraySupport.createArrayOf("int4", null));
    pstmt.setObject(2, conn.createArrayOf("float8", null));
    pstmt.setObject(3, arraySupport.createArrayOf("varchar", null));

    pstmt.executeUpdate();
    pstmt.close();

    Statement stmt = conn.createStatement();
    ResultSet rs = stmt.executeQuery("SELECT intarr, decarr, strarr FROM arrtest");
    Assert.assertTrue(rs.next());

    Array arr = rs.getArray(1);
    Assert.assertNull(arr);

    arr = rs.getArray(2);
    Assert.assertNull(arr);

    arr = rs.getArray(3);
    Assert.assertNull(arr);

    rs.close();
  }

mgartner · 2021-10-14T16:22:16Z

Thanks for pointing this out. I expected some fallout from that change. I'll take a look.

cockroach-teamcity · 2021-10-15T12:47:19Z

roachtest.pgjdbc failed with artifacts on master @ 0984f873c6170ab34afe6fee4661fc5f76ac0dee:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/pgjdbc/run_1
	orm_helpers.go:245,orm_helpers.go:171,java_helpers.go:220,pgjdbc.go:185,pgjdbc.go:197,test_runner.go:777: 
		Tests run on Cockroach v21.2.0-alpha.00000000-5058-g0984f873c6-dirty
		Tests run against pgjdbc REL42.2.19
		5298 Total Tests Run
		4474 tests passed
		824 tests failed
		60 tests skipped
		185 tests ignored
		5 tests passed unexpectedly
		2 tests failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- FAIL: org.postgresql.test.jdbc2.ArrayTest.testSetNullArrays[binary = FORCE] - unknown (unexpected)
		--- FAIL: org.postgresql.test.jdbc2.ArrayTest.testSetNullArrays[binary = REGULAR] - unknown (unexpected)
		--- PASS: org.postgresql.test.jdbc2.PGTimeTest.testTimeInsertAndSelect - https://github.com/cockroachdb/cockroach/issues/41775 (unexpected)
		--- PASS: org.postgresql.test.jdbc42.GetObject310Test.testGetLocalTimeInvalidType[binary = FORCE] - https://github.com/cockroachdb/cockroach/issues/26097 (unexpected)
		--- PASS: org.postgresql.test.jdbc2.SearchPathLookupTest.testSearchPathHiddenLookup -  (unexpected)
		--- PASS: org.postgresql.test.jdbc42.GetObject310Test.testGetLocalTimeInvalidType[binary = REGULAR] - https://github.com/cockroachdb/cockroach/issues/26097 (unexpected)
		--- PASS: org.postgresql.test.jdbc2.PGTimestampTest.testTimeInsertAndSelect - https://github.com/cockroachdb/cockroach/issues/41775 (unexpected)
		For a full summary look at the pgjdbc artifacts 
		
		An updated blocklist (pgjdbcBlockList21_2) is available in the artifacts' pgjdbc log

Reproduce

See: roachtest README

/cc @cockroachdb/sql-experience _{This test on roachdash | Improve this report!}

cockroach-teamcity · 2021-10-16T12:38:36Z

roachtest.pgjdbc failed with artifacts on master @ b3af96b0686773c78325d2b8b0623a8fcd3e9bf2:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/pgjdbc/run_1
	orm_helpers.go:245,orm_helpers.go:171,java_helpers.go:220,pgjdbc.go:185,pgjdbc.go:197,test_runner.go:777: 
		Tests run on Cockroach v21.2.0-alpha.00000000-5076-gb3af96b068
		Tests run against pgjdbc REL42.2.19
		5298 Total Tests Run
		4474 tests passed
		824 tests failed
		60 tests skipped
		185 tests ignored
		5 tests passed unexpectedly
		2 tests failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- FAIL: org.postgresql.test.jdbc2.ArrayTest.testSetNullArrays[binary = REGULAR] - unknown (unexpected)
		--- PASS: org.postgresql.test.jdbc42.GetObject310Test.testGetLocalTimeInvalidType[binary = REGULAR] - https://github.com/cockroachdb/cockroach/issues/26097 (unexpected)
		--- PASS: org.postgresql.test.jdbc2.SearchPathLookupTest.testSearchPathHiddenLookup -  (unexpected)
		--- PASS: org.postgresql.test.jdbc42.GetObject310Test.testGetLocalTimeInvalidType[binary = FORCE] - https://github.com/cockroachdb/cockroach/issues/26097 (unexpected)
		--- PASS: org.postgresql.test.jdbc2.PGTimeTest.testTimeInsertAndSelect - https://github.com/cockroachdb/cockroach/issues/41775 (unexpected)
		--- FAIL: org.postgresql.test.jdbc2.ArrayTest.testSetNullArrays[binary = FORCE] - unknown (unexpected)
		--- PASS: org.postgresql.test.jdbc2.PGTimestampTest.testTimeInsertAndSelect - https://github.com/cockroachdb/cockroach/issues/41775 (unexpected)
		For a full summary look at the pgjdbc artifacts 
		
		An updated blocklist (pgjdbcBlockList21_2) is available in the artifacts' pgjdbc log

Reproduce

See: roachtest README

/cc @cockroachdb/sql-experience _{This test on roachdash | Improve this report!}

cockroach-teamcity · 2021-10-17T11:59:00Z

roachtest.pgjdbc failed with artifacts on master @ 5d972a683c531326bc0af403c6d3373d3f4b2267:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/pgjdbc/run_1
	orm_helpers.go:245,orm_helpers.go:171,java_helpers.go:220,pgjdbc.go:185,pgjdbc.go:197,test_runner.go:777: 
		Tests run on Cockroach v21.2.0-alpha.00000000-5078-g5d972a683c
		Tests run against pgjdbc REL42.2.19
		5298 Total Tests Run
		4474 tests passed
		824 tests failed
		60 tests skipped
		185 tests ignored
		5 tests passed unexpectedly
		2 tests failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- PASS: org.postgresql.test.jdbc2.SearchPathLookupTest.testSearchPathHiddenLookup -  (unexpected)
		--- PASS: org.postgresql.test.jdbc42.GetObject310Test.testGetLocalTimeInvalidType[binary = FORCE] - https://github.com/cockroachdb/cockroach/issues/26097 (unexpected)
		--- PASS: org.postgresql.test.jdbc2.PGTimeTest.testTimeInsertAndSelect - https://github.com/cockroachdb/cockroach/issues/41775 (unexpected)
		--- FAIL: org.postgresql.test.jdbc2.ArrayTest.testSetNullArrays[binary = REGULAR] - unknown (unexpected)
		--- PASS: org.postgresql.test.jdbc42.GetObject310Test.testGetLocalTimeInvalidType[binary = REGULAR] - https://github.com/cockroachdb/cockroach/issues/26097 (unexpected)
		--- PASS: org.postgresql.test.jdbc2.PGTimestampTest.testTimeInsertAndSelect - https://github.com/cockroachdb/cockroach/issues/41775 (unexpected)
		--- FAIL: org.postgresql.test.jdbc2.ArrayTest.testSetNullArrays[binary = FORCE] - unknown (unexpected)
		For a full summary look at the pgjdbc artifacts 
		
		An updated blocklist (pgjdbcBlockList21_2) is available in the artifacts' pgjdbc log

Reproduce

See: roachtest README

/cc @cockroachdb/sql-experience _{This test on roachdash | Improve this report!}

cockroach-teamcity · 2021-10-19T12:22:47Z

roachtest.pgjdbc failed with artifacts on master @ 649a8ca38cdc0883dd7a7811b189ea53af19f644:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/pgjdbc/run_1
	orm_helpers.go:245,orm_helpers.go:171,java_helpers.go:220,pgjdbc.go:185,pgjdbc.go:197,test_runner.go:777: 
		Tests run on Cockroach v22.1.0-alpha.00000000-471-g649a8ca38c
		Tests run against pgjdbc REL42.2.19
		5298 Total Tests Run
		4474 tests passed
		824 tests failed
		60 tests skipped
		185 tests ignored
		5 tests passed unexpectedly
		2 tests failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- PASS: org.postgresql.test.jdbc42.GetObject310Test.testGetLocalTimeInvalidType[binary = FORCE] - https://github.com/cockroachdb/cockroach/issues/26097 (unexpected)
		--- PASS: org.postgresql.test.jdbc2.PGTimestampTest.testTimeInsertAndSelect - https://github.com/cockroachdb/cockroach/issues/41775 (unexpected)
		--- PASS: org.postgresql.test.jdbc2.PGTimeTest.testTimeInsertAndSelect - https://github.com/cockroachdb/cockroach/issues/41775 (unexpected)
		--- FAIL: org.postgresql.test.jdbc2.ArrayTest.testSetNullArrays[binary = REGULAR] - unknown (unexpected)
		--- PASS: org.postgresql.test.jdbc42.GetObject310Test.testGetLocalTimeInvalidType[binary = REGULAR] - https://github.com/cockroachdb/cockroach/issues/26097 (unexpected)
		--- PASS: org.postgresql.test.jdbc2.SearchPathLookupTest.testSearchPathHiddenLookup -  (unexpected)
		--- FAIL: org.postgresql.test.jdbc2.ArrayTest.testSetNullArrays[binary = FORCE] - unknown (unexpected)
		For a full summary look at the pgjdbc artifacts 
		
		An updated blocklist (pgjdbcBlockList22_1) is available in the artifacts' pgjdbc log

Reproduce

See: roachtest README

/cc @cockroachdb/sql-experience _{This test on roachdash | Improve this report!}

rafiss · 2021-10-19T17:21:36Z

created #71714 to track the casting change, so I'll now update the expected failures for this test.

rafiss removed the release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. label Oct 14, 2021

rafiss mentioned this issue Oct 19, 2021

sql: regression: invalid assignment cast: unknown -> int[] #71714

Closed

rafiss mentioned this issue Oct 19, 2021

roachtest: update pgjdbc blocklist #71722

Merged

rafiss self-assigned this Oct 19, 2021

craig bot closed this as completed in 5c33d12 Oct 20, 2021

craig bot closed this as completed in #71722 Oct 20, 2021

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

roachtest: pgjdbc failed #71564

roachtest: pgjdbc failed #71564

cockroach-teamcity commented Oct 14, 2021

rafiss commented Oct 14, 2021

mgartner commented Oct 14, 2021

cockroach-teamcity commented Oct 15, 2021

cockroach-teamcity commented Oct 16, 2021

cockroach-teamcity commented Oct 17, 2021

cockroach-teamcity commented Oct 19, 2021

rafiss commented Oct 19, 2021

roachtest: pgjdbc failed #71564

roachtest: pgjdbc failed #71564

Comments

cockroach-teamcity commented Oct 14, 2021

rafiss commented Oct 14, 2021

mgartner commented Oct 14, 2021

cockroach-teamcity commented Oct 15, 2021

cockroach-teamcity commented Oct 16, 2021

cockroach-teamcity commented Oct 17, 2021

cockroach-teamcity commented Oct 19, 2021

rafiss commented Oct 19, 2021