roachtest: psycopg failed

[cockroach-teamcity]

(roachtest).psycopg failed on master@de91557c0634ab3797356d445ba39e37d45d8205:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/psycopg/run_1
	orm_helpers.go:228,orm_helpers.go:154,psycopg.go:122,psycopg.go:135,test_runner.go:760: 
		Tests run on Cockroach v21.1.0-alpha.1-400-gde91557c06
		Tests run against psycopg 2_8_6
		452 Total Tests Run
		450 tests passed
		2 tests failed
		320 tests skipped
		3 tests ignored
		0 tests passed unexpectedly
		1 test failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- FAIL: tests.test_module.ExceptionsTestCase.test_9_6_diagnostics (unexpected)
		For a full summary look at the psycopg artifacts 
		
		An updated blocklist (psycopgBlockList21_1) is available in the artifacts' psycopg log

More

Artifacts: /psycopg

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

[arulajmani]

This test wasn't run earlier because our previous pg version was 9.5 was less than the version above which this test is run (9.6). After the version bump, this test needs to be explicitly skipped for CRDB, for the same reason as test_9_3_diagnostics, which is skipped for CRDB. Therefore, this failure is expected after the version bump.

I've opened up a PR here: psycopg/psycopg2#1211 to change this upstream. @rafiss, since you're the one most familiar w this stuff, is there anything else I need to do here or are we in the green?

[rafiss]

Thanks @arulajmani ! the last step here will be to change the version of psycopg2 that we test with in roachtest/psycopg,go

Though we would probably need to wait for the next release of psycopg2. In the meantime, we can just mark this test as failing in psycopg_blocklist.go

[cockroach-teamcity]

(roachtest).psycopg failed on master@eda9189cecbbc279f1857f6e6b992bdfd363397e:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/psycopg/run_1
	orm_helpers.go:228,orm_helpers.go:154,psycopg.go:122,psycopg.go:135,test_runner.go:760: 
		Tests run on Cockroach v21.1.0-alpha.1-429-geda9189cec
		Tests run against psycopg 2_8_6
		452 Total Tests Run
		450 tests passed
		2 tests failed
		320 tests skipped
		3 tests ignored
		0 tests passed unexpectedly
		1 test failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- FAIL: tests.test_module.ExceptionsTestCase.test_9_6_diagnostics (unexpected)
		For a full summary look at the psycopg artifacts 
		
		An updated blocklist (psycopgBlockList21_1) is available in the artifacts' psycopg log

More

Artifacts: /psycopg

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

[cockroach-teamcity]

(roachtest).psycopg failed on master@46919380225dba7122130c338744b561d7eb6c56:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/psycopg/run_1
	orm_helpers.go:228,orm_helpers.go:154,psycopg.go:122,psycopg.go:135,test_runner.go:760: 
		Tests run on Cockroach v21.1.0-alpha.1-455-g4691938022
		Tests run against psycopg 2_8_6
		452 Total Tests Run
		450 tests passed
		2 tests failed
		320 tests skipped
		3 tests ignored
		0 tests passed unexpectedly
		1 test failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- FAIL: tests.test_module.ExceptionsTestCase.test_9_6_diagnostics (unexpected)
		For a full summary look at the psycopg artifacts 
		
		An updated blocklist (psycopgBlockList21_1) is available in the artifacts' psycopg log

More

Artifacts: /psycopg

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