roachtest: pgjdbc failed #57168

cockroach-teamcity · 2020-11-26T11:18:53Z

(roachtest).pgjdbc failed on master@fe5da5c2df069dc7f820f5c3e2f3e03f1cb7b661:

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:228,orm_helpers.go:154,java_helpers.go:216,pgjdbc.go:175,pgjdbc.go:188,test_runner.go:760: 
		Tests run on Cockroach v21.1.0-alpha.00000000-547-gfe5da5c2df
		Tests run against pgjdbc REL42.2.9
		5764 Total Tests Run
		4859 tests passed
		905 tests failed
		50 tests skipped
		122 tests ignored
		2 tests passed unexpectedly
		1 test failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- PASS: org.postgresql.test.jdbc2.PreparedStatementTest.testDollarQuotes[binary = FORCE] - https://github.com/cockroachdb/cockroach/issues/41777 (unexpected)
		--- FAIL: org.postgresql.test.jdbc42.SetObject310Test.testSetOffsetDateTime[binary = REGULAR] - unknown (unexpected)
		--- PASS: org.postgresql.test.jdbc2.PreparedStatementTest.testDollarQuotes[binary = REGULAR] - https://github.com/cockroachdb/cockroach/issues/41777 (unexpected)
		For a full summary look at the pgjdbc artifacts 
		
		An updated blocklist (pgjdbcBlockList21_1) is available in the artifacts' pgjdbc log

More

Artifacts: /pgjdbc

See this test on roachdash
_{powered by pkg/cmd/internal/issues}

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

cockroach-teamcity · 2020-11-27T09:23:46Z

(roachtest).pgjdbc failed on master@361215163c597bd1460bba65ca3298f37e29aacc:

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:228,orm_helpers.go:154,java_helpers.go:216,pgjdbc.go:175,pgjdbc.go:188,test_runner.go:760: 
		Tests run on Cockroach v21.1.0-alpha.00000000-561-g361215163c
		Tests run against pgjdbc REL42.2.9
		5764 Total Tests Run
		4859 tests passed
		905 tests failed
		50 tests skipped
		122 tests ignored
		2 tests passed unexpectedly
		1 test failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- PASS: org.postgresql.test.jdbc2.PreparedStatementTest.testDollarQuotes[binary = FORCE] - https://github.com/cockroachdb/cockroach/issues/41777 (unexpected)
		--- FAIL: org.postgresql.test.jdbc42.SetObject310Test.testSetOffsetDateTime[binary = REGULAR] - unknown (unexpected)
		--- PASS: org.postgresql.test.jdbc2.PreparedStatementTest.testDollarQuotes[binary = REGULAR] - https://github.com/cockroachdb/cockroach/issues/41777 (unexpected)
		For a full summary look at the pgjdbc artifacts 
		
		An updated blocklist (pgjdbcBlockList21_1) is available in the artifacts' pgjdbc log

More

Artifacts: /pgjdbc

See this test on roachdash
_{powered by pkg/cmd/internal/issues}

cockroach-teamcity · 2020-11-28T08:49:02Z

(roachtest).pgjdbc failed on master@54cdc5fec0e7dc835af7d2fc4231b52d49a71bf8:

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:228,orm_helpers.go:154,java_helpers.go:216,pgjdbc.go:175,pgjdbc.go:188,test_runner.go:760: 
		Tests run on Cockroach v21.1.0-alpha.00000000-578-g54cdc5fec0
		Tests run against pgjdbc REL42.2.9
		5764 Total Tests Run
		4856 tests passed
		908 tests failed
		50 tests skipped
		122 tests ignored
		2 tests passed unexpectedly
		4 tests failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- FAIL: org.postgresql.test.jdbc2.DatabaseEncodingTest.testTruncatedUTF8Decode - unknown (unexpected)
		--- PASS: org.postgresql.test.jdbc2.PreparedStatementTest.testDollarQuotes[binary = FORCE] - https://github.com/cockroachdb/cockroach/issues/41777 (unexpected)
		--- FAIL: org.postgresql.test.jdbc2.DatabaseEncodingTest.testBadUTF8Decode - unknown (unexpected)
		--- PASS: org.postgresql.test.jdbc2.PreparedStatementTest.testDollarQuotes[binary = REGULAR] - https://github.com/cockroachdb/cockroach/issues/41777 (unexpected)
		--- FAIL: org.postgresql.test.jdbc42.SetObject310Test.testSetOffsetDateTime[binary = REGULAR] - unknown (unexpected)
		--- FAIL: org.postgresql.test.jdbc2.DatabaseEncodingTest.testUTF8Decode - unknown (unexpected)
		For a full summary look at the pgjdbc artifacts 
		
		An updated blocklist (pgjdbcBlockList21_1) is available in the artifacts' pgjdbc log

More

Artifacts: /pgjdbc

See this test on roachdash
_{powered by pkg/cmd/internal/issues}

cockroach-teamcity · 2020-11-30T08:35:59Z

(roachtest).pgjdbc failed on master@76935fd62c5a76f88b754cd3f9a5bfb3ccf1d8c2:

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:228,orm_helpers.go:154,java_helpers.go:216,pgjdbc.go:175,pgjdbc.go:188,test_runner.go:760: 
		Tests run on Cockroach v21.1.0-alpha.00000000-582-g76935fd62c
		Tests run against pgjdbc REL42.2.9
		5764 Total Tests Run
		4859 tests passed
		905 tests failed
		50 tests skipped
		122 tests ignored
		2 tests passed unexpectedly
		1 test failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- PASS: org.postgresql.test.jdbc2.PreparedStatementTest.testDollarQuotes[binary = FORCE] - https://github.com/cockroachdb/cockroach/issues/41777 (unexpected)
		--- FAIL: org.postgresql.test.jdbc42.SetObject310Test.testSetOffsetDateTime[binary = REGULAR] - unknown (unexpected)
		--- PASS: org.postgresql.test.jdbc2.PreparedStatementTest.testDollarQuotes[binary = REGULAR] - https://github.com/cockroachdb/cockroach/issues/41777 (unexpected)
		For a full summary look at the pgjdbc artifacts 
		
		An updated blocklist (pgjdbcBlockList21_1) is available in the artifacts' pgjdbc log

More

Artifacts: /pgjdbc

See this test on roachdash
_{powered by pkg/cmd/internal/issues}

solongordon · 2020-11-30T19:16:02Z

Hmm, I wonder if something fixed testDollarQuotes on master recently? Seems like it fails reliably on 20.2 and earlier.

cockroach-teamcity · 2020-12-01T11:49:00Z

(roachtest).pgjdbc failed on master@22906f72e795f9f2c69828e65194f4177833ffbb:

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:228,orm_helpers.go:154,java_helpers.go:216,pgjdbc.go:175,pgjdbc.go:188,test_runner.go:760: 
		Tests run on Cockroach v21.1.0-alpha.00000000-620-g22906f72e7
		Tests run against pgjdbc REL42.2.9
		5764 Total Tests Run
		4856 tests passed
		908 tests failed
		50 tests skipped
		122 tests ignored
		2 tests passed unexpectedly
		4 tests failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- FAIL: org.postgresql.test.jdbc2.DatabaseEncodingTest.testBadUTF8Decode - unknown (unexpected)
		--- FAIL: org.postgresql.test.jdbc2.DatabaseEncodingTest.testTruncatedUTF8Decode - unknown (unexpected)
		--- PASS: org.postgresql.test.jdbc2.PreparedStatementTest.testDollarQuotes[binary = REGULAR] - https://github.com/cockroachdb/cockroach/issues/41777 (unexpected)
		--- PASS: org.postgresql.test.jdbc2.PreparedStatementTest.testDollarQuotes[binary = FORCE] - https://github.com/cockroachdb/cockroach/issues/41777 (unexpected)
		--- FAIL: org.postgresql.test.jdbc2.DatabaseEncodingTest.testUTF8Decode - unknown (unexpected)
		--- FAIL: org.postgresql.test.jdbc42.SetObject310Test.testSetOffsetDateTime[binary = REGULAR] - unknown (unexpected)
		For a full summary look at the pgjdbc artifacts 
		
		An updated blocklist (pgjdbcBlockList21_1) is available in the artifacts' pgjdbc log

More

Artifacts: /pgjdbc

See this test on roachdash
_{powered by pkg/cmd/internal/issues}

otan · 2020-12-01T11:52:04Z

the most recent failure with UTF8 decode seems to be related to an error dropping a relation, which failed, so the next test fails:


testUTF8Decode(org.postgresql.test.jdbc2.DatabaseEncodingTest)  Time elapsed: 277.541 sec  <<< ERROR!
org.postgresql.util.PSQLException: ERROR: job 611948106879139841 could not be loaded: job with ID 611948106879139841 does not exist
  Hint: The job may not have succeeded.
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2505)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2241)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:310)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:447)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:368)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:309)
	at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:295)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:272)
	at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:246)
	at org.postgresql.test.TestUtil.dropTable(TestUtil.java:583)
	at org.postgresql.test.TestUtil.createTable(TestUtil.java:409)
	at org.postgresql.test.jdbc2.DatabaseEncodingTest.setUp(DatabaseEncodingTest.java:42)

see: https://teamcity.cockroachdb.com/repository/download/Cockroach_Nightlies_WorkloadNightly/2483915:id/pgjdbc/run_1/logs/unredacted/report/pgjdbc-results/surefire-reports/org.postgresql.test.jdbc2.Jdbc2TestSuite.txt

any ideas? cc @lucy-zhang

56815: jepsen: ignore some install errors r=andreimatei a=andreimatei Two failures. Seem to have been transient. ``` | Could not transfer artifact org.clojure:clojure:jar:1.9.0 from/to central (https://repo1.maven.org/maven2/): GET request of: org/clojure/clojure/1.9.0/clojure-1.9.0.jar from central failed | Could not find artifact org.clojure:clojure:jar:1.9.0 in clojars (https://repo.clojars.org/) | This could be due to a typo in :dependencies, file system permissions, or network issues. | If you are behind a proxy, try setting the 'http_proxy' environment variable. ``` ``` | Failed to read artifact descriptor for commons-codec:commons-codec:jar:1.6 | This could be due to a typo in :dependencies, file system permissions, or network issues. ``` Fixes #56695 Fixes #56645 Release note: None 57035: colflow: add sync protection to latency getter map r=asubiotto a=cathymw This commit adds a mutex lock to LatencyGetter, ensuring that concurrent writes to the latencyMap do not occur. Closes: #56997 Closes: #56360 Closes: #56278 Closes: #56275 Release note: None. 57262: roachtest: remove testDollarQuotes from v21.1 blocklist r=rafiss a=otan These seem to pass now, have not digged deep into why but passing is always good news. Refs #57168 Release note: None 57265: pgwire: lazily populate second timezone offset r=rafiss a=otan Looks like #55071 was too greedy -- looks like (at the very least) pgjdbc expects the second offset to only be displayed if there is a second offset. It's easy to do, so I have done so. Fixed TimeTZ along the way. Refs #57168 Release note (bug fix): Second timezone offsets for TimeTZ now correctly display over the postgres wire protocol - these were previously omitted. Release note (bug fix): Second timezone offsets are only displayed in the postgres wire protocol for TimestampTZ values. In an earlier patch for v21.1, this would always display. 57278: sql: add SHOW SURVIVAL GOAL FROM DATABASE r=ajstorm a=otan two commits in here, one is a minor fix up i thought might as well go in with this one. ---- delegate: add database name to SHOW REGIONS FROM DATABASE This seems to match behaviour I've seen from other places, e.g. SHOW ZONE CONFIGURATION. Release note (sql change): The database name is now displayed in `SHOW REGIONS FROM DATABASE`. sql: add SHOW SURVIVAL GOAL FROM DATABASE Release note (sql change): Add `SHOW SURVIVAL GOAL FROM DATABASE [database]`, which shows the survival goal for a multi-region database. 57313: licenses: Update CCL reference to Apache license r=bdarnell a=bdarnell CCL.txt contains an outdated reference to the Apache license. This edit brings it up to date with the text on https://www.cockroachlabs.com/cockroachdb-community-license/ Release note: None 57316: sql: categorize undefined column error when adding unique constraints r=ajwerner a=jayshrivastava Previously, adding a unique constraint to a table on one or more columns that do not exist would cause uncategorized error. Now, the error is categorized as pgcode.UndefinedColumn. Closes: #57314 Release note (sql change): A pgcode.UndefinedColumn will now be returned when adding a unique constraint to one or more undefined columns. 57326: authors: add kevinkokomani to authors r=otan a=kevinkokomani Release note: None Co-authored-by: Andrei Matei <andrei@cockroachlabs.com> Co-authored-by: Cathy <cathyw@cockroachlabs.com> Co-authored-by: Oliver Tan <otan@cockroachlabs.com> Co-authored-by: Ben Darnell <ben@cockroachlabs.com> Co-authored-by: Jayant Shrivastava <jayants@cockroachlabs.com> Co-authored-by: Kevin Kokomani <kokomani@cockroachlabs.com>

otan · 2020-12-01T21:48:28Z

consistent failures now resolved with the merge.

cockroach-teamcity added this to Test failures in SQL Sessions - Deprecated Nov 26, 2020

rafiss assigned solongordon Nov 30, 2020

rafiss removed the release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. label Nov 30, 2020

This was referenced Nov 30, 2020

roachtest: remove testDollarQuotes from v21.1 blocklist #57262

Merged

pgwire: lazily populate second timezone offset #57265

Merged

otan self-assigned this Nov 30, 2020

otan closed this as completed Dec 1, 2020

SQL Sessions - Deprecated automation moved this from Test failures to Done Dec 1, 2020

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

roachtest: pgjdbc failed #57168

roachtest: pgjdbc failed #57168

cockroach-teamcity commented Nov 26, 2020

cockroach-teamcity commented Nov 27, 2020

cockroach-teamcity commented Nov 28, 2020

cockroach-teamcity commented Nov 30, 2020

solongordon commented Nov 30, 2020

cockroach-teamcity commented Dec 1, 2020

otan commented Dec 1, 2020 •

edited

otan commented Dec 1, 2020

roachtest: pgjdbc failed #57168

roachtest: pgjdbc failed #57168

Comments

cockroach-teamcity commented Nov 26, 2020

cockroach-teamcity commented Nov 27, 2020

cockroach-teamcity commented Nov 28, 2020

cockroach-teamcity commented Nov 30, 2020

solongordon commented Nov 30, 2020

cockroach-teamcity commented Dec 1, 2020

otan commented Dec 1, 2020 • edited

otan commented Dec 1, 2020

otan commented Dec 1, 2020 •

edited