Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

roachtest: asyncpg failed #76490

Closed
cockroach-teamcity opened this issue Feb 14, 2022 · 27 comments · Fixed by #77370
Closed

roachtest: asyncpg failed #76490

cockroach-teamcity opened this issue Feb 14, 2022 · 27 comments · Fixed by #77370
Assignees
Labels
branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). GA-blocker O-roachtest O-robot Originated from a bot. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Feb 14, 2022

roachtest.asyncpg failed with artifacts on master @ bbb473c8f304ac20fec51ff0a0d04e128383bcf6:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/asyncpg/run_1
	orm_helpers.go:191,orm_helpers.go:117,asyncpg.go:130,asyncpg.go:141,test_runner.go:779: 
		Tests run on Cockroach v22.1.0-alpha.1-1226-gbbb473c8f3
		Tests run against asyncpg v0.24.0
		134 Total Tests Run
		126 tests passed
		8 tests failed
		34 tests skipped
		96 tests ignored
		0 tests passed unexpectedly
		8 tests failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- FAIL: test_transaction.TestTransaction.test_transaction_interface_errors (unexpected)
		--- FAIL: test_transaction.TestTransaction.test_transaction_regular (unexpected)
		--- FAIL: test_transaction.TestTransaction.test_transaction_nested (unexpected)
		--- FAIL: test_timeout.TestTimeoutCoversPrepare.test_timeout_covers_prepare_01 (unexpected)
		--- FAIL: test_transaction.TestTransaction.test_nested_isolation_level (unexpected)
		--- FAIL: test_transaction.TestTransaction.test_transaction_within_manual_transaction (unexpected)
		--- FAIL: test_transaction.TestTransaction.test_isolation_level (unexpected)
		--- FAIL: test_timeout.TestTimeout.test_timeout_05 (unexpected)
		For a full summary look at the asyncpg artifacts 
		
		An updated blocklist (asyncpgBlocklist22_1) is available in the artifacts' asyncpg log
Help

See: roachtest README

See: How To Investigate (internal)

/cc @cockroachdb/sql-experience

This test on roachdash | Improve this report!

Jira issue: CRDB-13147

@cockroach-teamcity cockroach-teamcity added branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. labels Feb 14, 2022
@blathers-crl blathers-crl bot added the T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) label Feb 14, 2022
@rafiss
Copy link
Collaborator

rafiss commented Feb 14, 2022

It seems like all the failures are

ConnectionRefusedError: [Errno 111] Connect call failed ('127.0.0.1', 26257)

@cockroach-teamcity
Copy link
Member Author

roachtest.asyncpg failed with artifacts on master @ 9514f13d0190849eda12b39e272c278b82c269f4:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/asyncpg/run_1
	orm_helpers.go:191,orm_helpers.go:117,asyncpg.go:130,asyncpg.go:141,test_runner.go:779: 
		Tests run on Cockroach v22.1.0-alpha.1-1272-g9514f13d01
		Tests run against asyncpg v0.24.0
		134 Total Tests Run
		126 tests passed
		8 tests failed
		34 tests skipped
		96 tests ignored
		0 tests passed unexpectedly
		8 tests failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- FAIL: test_transaction.TestTransaction.test_isolation_level (unexpected)
		--- FAIL: test_transaction.TestTransaction.test_transaction_interface_errors (unexpected)
		--- FAIL: test_transaction.TestTransaction.test_nested_isolation_level (unexpected)
		--- FAIL: test_timeout.TestTimeoutCoversPrepare.test_timeout_covers_prepare_01 (unexpected)
		--- FAIL: test_transaction.TestTransaction.test_transaction_regular (unexpected)
		--- FAIL: test_timeout.TestTimeout.test_timeout_05 (unexpected)
		--- FAIL: test_transaction.TestTransaction.test_transaction_within_manual_transaction (unexpected)
		--- FAIL: test_transaction.TestTransaction.test_transaction_nested (unexpected)
		For a full summary look at the asyncpg artifacts 
		
		An updated blocklist (asyncpgBlocklist22_1) is available in the artifacts' asyncpg log
Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.asyncpg failed with artifacts on master @ 6d9ceec64fa120113c484d17e3f61dfd6737b221:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/asyncpg/run_1
	asyncpg.go:54,asyncpg.go:141,test_runner.go:779: pq: unknown cluster setting 'sql.catalog.unsafe_skip_system_config_trigger.enabled'
Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@RichardJCai
Copy link
Contributor

Gonna keep an eye out on this one to see more failures.

@cockroach-teamcity
Copy link
Member Author

roachtest.asyncpg failed with artifacts on master @ a7449866f3229872d92e1de973e209838f07de35:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/asyncpg/run_1
	orm_helpers.go:190,orm_helpers.go:116,asyncpg.go:130,asyncpg.go:141,test_runner.go:779: 
		Tests run on Cockroach v22.1.0-alpha.1-1614-ga7449866f3
		Tests run against asyncpg v0.24.0
		132 Total Tests Run
		130 tests passed
		2 tests failed
		34 tests skipped
		96 tests ignored
		0 tests passed unexpectedly
		2 tests failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- FAIL: test_cursor.TestCursor.test_cursor_03 (unexpected)
		--- FAIL: test_pool.TestPool.test_pool_11 (unexpected)
		For a full summary look at the asyncpg artifacts 
		
		An updated blocklist (asyncpgBlocklist22_1) is available in the artifacts' asyncpg log
Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.asyncpg failed with artifacts on master @ 978744dbb94b03497154547ce7fa97ea3be9a401:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/asyncpg/run_1
	orm_helpers.go:190,orm_helpers.go:116,asyncpg.go:130,asyncpg.go:141,test_runner.go:779: 
		Tests run on Cockroach v22.1.0-alpha.1-1656-g978744dbb9
		Tests run against asyncpg v0.24.0
		132 Total Tests Run
		130 tests passed
		2 tests failed
		34 tests skipped
		96 tests ignored
		0 tests passed unexpectedly
		2 tests failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- FAIL: test_pool.TestPool.test_pool_11 (unexpected)
		--- FAIL: test_cursor.TestCursor.test_cursor_03 (unexpected)
		For a full summary look at the asyncpg artifacts 
		
		An updated blocklist (asyncpgBlocklist22_1) is available in the artifacts' asyncpg log
Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@rafiss
Copy link
Collaborator

rafiss commented Feb 25, 2022

lets see if the test_cursor failure is resolved when #76883 (comment) is fixed

@cockroach-teamcity
Copy link
Member Author

roachtest.asyncpg failed with artifacts on master @ 8e7248296a2b8b2a4d07dd82678c687a02d56c4f:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/asyncpg/run_1
	orm_helpers.go:190,orm_helpers.go:116,asyncpg.go:130,asyncpg.go:141,test_runner.go:779: 
		Tests run on Cockroach v22.1.0-alpha.1-1732-g8e7248296a
		Tests run against asyncpg v0.24.0
		132 Total Tests Run
		130 tests passed
		2 tests failed
		34 tests skipped
		96 tests ignored
		0 tests passed unexpectedly
		2 tests failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- FAIL: test_cursor.TestCursor.test_cursor_03 (unexpected)
		--- FAIL: test_pool.TestPool.test_pool_11 (unexpected)
		For a full summary look at the asyncpg artifacts 
		
		An updated blocklist (asyncpgBlocklist22_1) is available in the artifacts' asyncpg log
Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.asyncpg failed with artifacts on master @ eee8ef080a95bc59eb3ddc2bebf623eb78e78db9:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/asyncpg/run_1
	orm_helpers.go:190,orm_helpers.go:116,asyncpg.go:130,asyncpg.go:141,test_runner.go:779: 
		Tests run on Cockroach v22.1.0-alpha.1-1740-geee8ef080a
		Tests run against asyncpg v0.24.0
		132 Total Tests Run
		130 tests passed
		2 tests failed
		34 tests skipped
		96 tests ignored
		0 tests passed unexpectedly
		2 tests failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- FAIL: test_cursor.TestCursor.test_cursor_03 (unexpected)
		--- FAIL: test_pool.TestPool.test_pool_11 (unexpected)
		For a full summary look at the asyncpg artifacts 
		
		An updated blocklist (asyncpgBlocklist22_1) is available in the artifacts' asyncpg log
Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.asyncpg failed with artifacts on master @ 9b45e990d5ddbbd6da13e8d3e312bb251fe0233a:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/asyncpg/run_1
	orm_helpers.go:190,orm_helpers.go:116,asyncpg.go:130,asyncpg.go:141,test_runner.go:779: 
		Tests run on Cockroach v22.1.0-alpha.1-1746-g9b45e990d5
		Tests run against asyncpg v0.24.0
		132 Total Tests Run
		130 tests passed
		2 tests failed
		34 tests skipped
		96 tests ignored
		0 tests passed unexpectedly
		2 tests failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- FAIL: test_cursor.TestCursor.test_cursor_03 (unexpected)
		--- FAIL: test_pool.TestPool.test_pool_11 (unexpected)
		For a full summary look at the asyncpg artifacts 
		
		An updated blocklist (asyncpgBlocklist22_1) is available in the artifacts' asyncpg log
Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.asyncpg failed with artifacts on master @ d89e743edc44da85d9bf4e9087b451e11d3628bd:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/asyncpg/run_1
	orm_helpers.go:190,orm_helpers.go:116,asyncpg.go:130,asyncpg.go:141,test_runner.go:779: 
		Tests run on Cockroach v22.1.0-alpha.1-1763-gd89e743edc
		Tests run against asyncpg v0.24.0
		132 Total Tests Run
		130 tests passed
		2 tests failed
		34 tests skipped
		96 tests ignored
		0 tests passed unexpectedly
		2 tests failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- FAIL: test_pool.TestPool.test_pool_11 (unexpected)
		--- FAIL: test_cursor.TestCursor.test_cursor_03 (unexpected)
		For a full summary look at the asyncpg artifacts 
		
		An updated blocklist (asyncpgBlocklist22_1) is available in the artifacts' asyncpg log
Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.asyncpg failed with artifacts on master @ e151a24dc1d495bf694e1e1c3ee8acb518c1424e:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/asyncpg/run_1
	orm_helpers.go:190,orm_helpers.go:116,asyncpg.go:130,asyncpg.go:141,test_runner.go:779: 
		Tests run on Cockroach v22.1.0-alpha.1-1787-ge151a24dc1
		Tests run against asyncpg v0.24.0
		132 Total Tests Run
		130 tests passed
		2 tests failed
		34 tests skipped
		96 tests ignored
		0 tests passed unexpectedly
		2 tests failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- FAIL: test_pool.TestPool.test_pool_11 (unexpected)
		--- FAIL: test_cursor.TestCursor.test_cursor_03 (unexpected)
		For a full summary look at the asyncpg artifacts 
		
		An updated blocklist (asyncpgBlocklist22_1) is available in the artifacts' asyncpg log
Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@rafiss
Copy link
Collaborator

rafiss commented Mar 2, 2022

@RichardJCai it looks like #77059 didn't fix this, and those two tests are failing reliably. Could you verify that the failures isn't a regression, then mark them as expected to fail?

@cockroach-teamcity
Copy link
Member Author

roachtest.asyncpg failed with artifacts on master @ dbdbb93978a9ad564e07085c15807f415ccaa00a:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/asyncpg/run_1
	orm_helpers.go:190,orm_helpers.go:116,asyncpg.go:130,asyncpg.go:141,test_runner.go:866: 
		Tests run on Cockroach v22.1.0-alpha.1-1836-gdbdbb93978
		Tests run against asyncpg v0.24.0
		132 Total Tests Run
		130 tests passed
		2 tests failed
		34 tests skipped
		96 tests ignored
		0 tests passed unexpectedly
		2 tests failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- FAIL: test_pool.TestPool.test_pool_11 (unexpected)
		--- FAIL: test_cursor.TestCursor.test_cursor_03 (unexpected)
		For a full summary look at the asyncpg artifacts 
		
		An updated blocklist (asyncpgBlocklist22_1) is available in the artifacts' asyncpg log
Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.asyncpg failed with artifacts on master @ 0e1edf3ad9da29b1d3bb28fcfc0f293d700e3cb9:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/asyncpg/run_1
	orm_helpers.go:190,orm_helpers.go:116,asyncpg.go:130,asyncpg.go:141,test_runner.go:866: 
		Tests run on Cockroach v22.1.0-alpha.1-1878-g0e1edf3ad9
		Tests run against asyncpg v0.24.0
		132 Total Tests Run
		130 tests passed
		2 tests failed
		34 tests skipped
		96 tests ignored
		0 tests passed unexpectedly
		2 tests failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- FAIL: test_pool.TestPool.test_pool_11 (unexpected)
		--- FAIL: test_cursor.TestCursor.test_cursor_03 (unexpected)
		For a full summary look at the asyncpg artifacts 
		
		An updated blocklist (asyncpgBlocklist22_1) is available in the artifacts' asyncpg log
Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.asyncpg failed with artifacts on master @ 71eb44ffb1574350cf4a36143ed423f6ac0ca02b:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/asyncpg/run_1
	orm_helpers.go:190,orm_helpers.go:116,asyncpg.go:130,asyncpg.go:141,test_runner.go:866: 
		Tests run on Cockroach v22.1.0-alpha.1-1893-g71eb44ffb1
		Tests run against asyncpg v0.24.0
		132 Total Tests Run
		130 tests passed
		2 tests failed
		34 tests skipped
		96 tests ignored
		0 tests passed unexpectedly
		2 tests failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- FAIL: test_cursor.TestCursor.test_cursor_03 (unexpected)
		--- FAIL: test_pool.TestPool.test_pool_11 (unexpected)
		For a full summary look at the asyncpg artifacts 
		
		An updated blocklist (asyncpgBlocklist22_1) is available in the artifacts' asyncpg log
Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.asyncpg failed with artifacts on master @ 3b7f761f019c0457c19726bab8d14c231cd318fc:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/asyncpg/run_1
	orm_helpers.go:190,orm_helpers.go:116,asyncpg.go:130,asyncpg.go:141,test_runner.go:866: 
		Tests run on Cockroach v22.1.0-alpha.1-1911-g3b7f761f01
		Tests run against asyncpg v0.24.0
		132 Total Tests Run
		130 tests passed
		2 tests failed
		34 tests skipped
		96 tests ignored
		0 tests passed unexpectedly
		2 tests failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- FAIL: test_cursor.TestCursor.test_cursor_03 (unexpected)
		--- FAIL: test_pool.TestPool.test_pool_11 (unexpected)
		For a full summary look at the asyncpg artifacts 
		
		An updated blocklist (asyncpgBlocklist22_1) is available in the artifacts' asyncpg log
Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.asyncpg failed with artifacts on master @ c6a5a395cbecbbd5ba77c2c14e3bf68eb59eeb19:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/asyncpg/run_1
	orm_helpers.go:190,orm_helpers.go:116,asyncpg.go:130,asyncpg.go:141,test_runner.go:866: 
		Tests run on Cockroach v22.1.0-alpha.2-186-gc6a5a395cb
		Tests run against asyncpg v0.24.0
		132 Total Tests Run
		130 tests passed
		2 tests failed
		34 tests skipped
		96 tests ignored
		0 tests passed unexpectedly
		2 tests failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- FAIL: test_cursor.TestCursor.test_cursor_03 (unexpected)
		--- FAIL: test_pool.TestPool.test_pool_11 (unexpected)
		For a full summary look at the asyncpg artifacts 
		
		An updated blocklist (asyncpgBlocklist22_1) is available in the artifacts' asyncpg log
Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.asyncpg failed with artifacts on master @ e7e596ede9d3da877e313a3d39ab498a5cb7d27b:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/asyncpg/run_1
	orm_helpers.go:190,orm_helpers.go:116,asyncpg.go:130,asyncpg.go:141,test_runner.go:866: 
		Tests run on Cockroach v22.1.0-alpha.2-210-ge7e596ede9
		Tests run against asyncpg v0.24.0
		132 Total Tests Run
		130 tests passed
		2 tests failed
		34 tests skipped
		96 tests ignored
		0 tests passed unexpectedly
		2 tests failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- FAIL: test_cursor.TestCursor.test_cursor_03 (unexpected)
		--- FAIL: test_pool.TestPool.test_pool_11 (unexpected)
		For a full summary look at the asyncpg artifacts 
		
		An updated blocklist (asyncpgBlocklist22_1) is available in the artifacts' asyncpg log
Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.asyncpg failed with artifacts on master @ 5755663effbdbe8175bb74e5cdc19b2298e0a0bc:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/asyncpg/run_1
	orm_helpers.go:190,orm_helpers.go:116,asyncpg.go:130,asyncpg.go:141,test_runner.go:866: 
		Tests run on Cockroach v22.1.0-alpha.2-251-g5755663eff
		Tests run against asyncpg v0.24.0
		132 Total Tests Run
		130 tests passed
		2 tests failed
		34 tests skipped
		96 tests ignored
		0 tests passed unexpectedly
		2 tests failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- FAIL: test_cursor.TestCursor.test_cursor_03 (unexpected)
		--- FAIL: test_pool.TestPool.test_pool_11 (unexpected)
		For a full summary look at the asyncpg artifacts 
		
		An updated blocklist (asyncpgBlocklist22_1) is available in the artifacts' asyncpg log
Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.asyncpg failed with artifacts on master @ 0069e980d756ca580167eb321ac6b348b35313f0:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/asyncpg/run_1
	orm_helpers.go:190,orm_helpers.go:116,asyncpg.go:130,asyncpg.go:141,test_runner.go:866: 
		Tests run on Cockroach v22.1.0-alpha.2-315-g0069e980d7
		Tests run against asyncpg v0.24.0
		132 Total Tests Run
		130 tests passed
		2 tests failed
		34 tests skipped
		96 tests ignored
		0 tests passed unexpectedly
		2 tests failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- FAIL: test_cursor.TestCursor.test_cursor_03 (unexpected)
		--- FAIL: test_pool.TestPool.test_pool_11 (unexpected)
		For a full summary look at the asyncpg artifacts 
		
		An updated blocklist (asyncpgBlocklist22_1) is available in the artifacts' asyncpg log
Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@rafiss
Copy link
Collaborator

rafiss commented Mar 11, 2022

looks like my change in #76834 actually fixes test_cursor_03 and test_pool_11.

@cockroach-teamcity
Copy link
Member Author

roachtest.asyncpg failed with artifacts on master @ 270eb7b3ab88fc47ba86d87f4e2113e560f047a8:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/asyncpg/run_1
	orm_helpers.go:190,orm_helpers.go:116,asyncpg.go:130,asyncpg.go:141,test_runner.go:866: 
		Tests run on Cockroach v22.1.0-alpha.2-342-g270eb7b3ab
		Tests run against asyncpg v0.24.0
		132 Total Tests Run
		130 tests passed
		2 tests failed
		34 tests skipped
		96 tests ignored
		0 tests passed unexpectedly
		2 tests failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- FAIL: test_cursor.TestCursor.test_cursor_03 (unexpected)
		--- FAIL: test_pool.TestPool.test_pool_11 (unexpected)
		For a full summary look at the asyncpg artifacts 
		
		An updated blocklist (asyncpgBlocklist22_1) is available in the artifacts' asyncpg log
Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.asyncpg failed with artifacts on master @ dc5432d65b9c38ce1ce5832e3c49d345b66145dc:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/asyncpg/run_1
	orm_helpers.go:190,orm_helpers.go:116,asyncpg.go:130,asyncpg.go:141,test_runner.go:866: 
		Tests run on Cockroach v22.1.0-alpha.2-352-gdc5432d65b
		Tests run against asyncpg v0.24.0
		132 Total Tests Run
		130 tests passed
		2 tests failed
		34 tests skipped
		96 tests ignored
		0 tests passed unexpectedly
		2 tests failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- FAIL: test_cursor.TestCursor.test_cursor_03 (unexpected)
		--- FAIL: test_pool.TestPool.test_pool_11 (unexpected)
		For a full summary look at the asyncpg artifacts 
		
		An updated blocklist (asyncpgBlocklist22_1) is available in the artifacts' asyncpg log
Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.asyncpg failed with artifacts on master @ 231fd420c61e39b6ad08c982c496d82cf1910bc5:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/asyncpg/run_1
	orm_helpers.go:190,orm_helpers.go:116,asyncpg.go:130,asyncpg.go:141,test_runner.go:866: 
		Tests run on Cockroach v22.1.0-alpha.2-356-g231fd420c6
		Tests run against asyncpg v0.24.0
		132 Total Tests Run
		130 tests passed
		2 tests failed
		34 tests skipped
		96 tests ignored
		0 tests passed unexpectedly
		2 tests failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- FAIL: test_pool.TestPool.test_pool_11 (unexpected)
		--- FAIL: test_cursor.TestCursor.test_cursor_03 (unexpected)
		For a full summary look at the asyncpg artifacts 
		
		An updated blocklist (asyncpgBlocklist22_1) is available in the artifacts' asyncpg log
Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@rafiss rafiss added GA-blocker and removed release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. labels Mar 14, 2022
@cockroach-teamcity
Copy link
Member Author

roachtest.asyncpg failed with artifacts on master @ f5fc84fb5707428ae9505c5e3e90cf3f63d465ad:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/asyncpg/run_1
	orm_helpers.go:190,orm_helpers.go:116,asyncpg.go:130,asyncpg.go:141,test_runner.go:866: 
		Tests run on Cockroach v22.1.0-alpha.3-232-gf5fc84fb57
		Tests run against asyncpg v0.24.0
		132 Total Tests Run
		130 tests passed
		2 tests failed
		34 tests skipped
		96 tests ignored
		0 tests passed unexpectedly
		2 tests failed unexpectedly
		0 tests expected failed but skipped
		0 tests expected failed but not run
		---
		--- FAIL: test_pool.TestPool.test_pool_11 (unexpected)
		--- FAIL: test_cursor.TestCursor.test_cursor_03 (unexpected)
		For a full summary look at the asyncpg artifacts 
		
		An updated blocklist (asyncpgBlocklist22_1) is available in the artifacts' asyncpg log
Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

craig bot pushed a commit that referenced this issue Mar 15, 2022
76834: sql: execute batch statements in an implicit transaction r=otan a=rafiss

fixes #44803
relates to #76490

Release justification: high value bug fix to existing functionality 

### *: prepare tests for batch stmt txn change

This commit will make the next one easier to review.

### sql: execute batch statements in an implicit transaction

Release note (bug fix): Previously statements that arrived in a batch
during the simple query protocol would all execute in their own implicit
transactions. Now, we match the Postgres wire protocol, so all these
statements share the same implicit transaction. If a BEGIN is included
in a statement batch, then the existing implicit transaction is
upgraded to an explicit transaction.

### sql: add session var for old implicit txn behavior

Release note (sql change): The enable_implicit_transaction_for_batch_statements
session variable was added. It defaults to true. When it is true,
multiple statements in a single query (a.k.a. a "batch statement") will
all be run in the same implicit transaction, which matches the Postgres
wire protocol. This setting is provided for users who want to preserve
the behavior of CockroachDB versions v21.2 and earlier.

77780: roachtest: update 22.1 version map to v21.2.7 r=celiala a=Azhng

Release note: None
Release justification: non-production code change.

77781: cloud: bump orchestrator to v21.2.7 r=celiala a=Azhng

Release note: None
Release justification: non-production code change.

77803: kvserverbase: move MaxCommandSizeDefault out of kvserver r=ajwerner a=ajwerner

```
$ bazel query "somepath(//pkg/sql, //pkg/kv/kvserver)"
INFO: Empty results
Loading: 0 packages loaded
```

Release justification: non-production code changes

Release note: None

Co-authored-by: Rafi Shamim <[email protected]>
Co-authored-by: Azhng <[email protected]>
Co-authored-by: Andrew Werner <[email protected]>
craig bot pushed a commit that referenced this issue Mar 15, 2022
76834: sql: execute batch statements in an implicit transaction r=otan a=rafiss

fixes #44803
relates to #76490

Release justification: high value bug fix to existing functionality 

### *: prepare tests for batch stmt txn change

This commit will make the next one easier to review.

### sql: execute batch statements in an implicit transaction

Release note (bug fix): Previously statements that arrived in a batch
during the simple query protocol would all execute in their own implicit
transactions. Now, we match the Postgres wire protocol, so all these
statements share the same implicit transaction. If a BEGIN is included
in a statement batch, then the existing implicit transaction is
upgraded to an explicit transaction.

### sql: add session var for old implicit txn behavior

Release note (sql change): The enable_implicit_transaction_for_batch_statements
session variable was added. It defaults to true. When it is true,
multiple statements in a single query (a.k.a. a "batch statement") will
all be run in the same implicit transaction, which matches the Postgres
wire protocol. This setting is provided for users who want to preserve
the behavior of CockroachDB versions v21.2 and earlier.

Co-authored-by: Rafi Shamim <[email protected]>
@rafiss
Copy link
Collaborator

rafiss commented Mar 16, 2022

removing blocker since #77865 was backported and fixes these tests. we should still update the asyncpg_blocklist though

@rafiss rafiss closed this as completed Mar 16, 2022
craig bot pushed a commit that referenced this issue Mar 16, 2022
77370: orm: update asyncpg_blocklist r=rafiss a=RichardJCai

Release justification: ORM test only change

Release note: None

Fixes #76490

Co-authored-by: richardjcai <[email protected]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). GA-blocker O-roachtest O-robot Originated from a bot. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants