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: scbench/randomload/nodes=3/ops=10000/conc=20 failed #63685

Closed
cockroach-teamcity opened this issue Apr 14, 2021 · 0 comments
Closed
Labels
C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot.

Comments

@cockroach-teamcity
Copy link
Member

roachtest.scbench/randomload/nodes=3/ops=10000/conc=20 failed with artifacts on ricky-test-upgrade-roachprod @ 54211ed8213a53ed455b859d3b157539618d6e8b:

		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "22:17:10.808007",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE schema4636.table5546 ALTER COLUMN \"col5025_5029\" DROP STORED"
		  |  ],
		  |  "expectedExecErrors": "42611",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: column \"col5025_5029\" is not a computed column (SQLSTATE 42611)",
		  |  "txStatus": "TxStatusRollbackSuccess"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "22:17:10.827683",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER VIEW schema5711.view5712 RENAME TO schema5711.view5713"
		  |  ],
		  |  "expectedExecErrors": "3F000,42P01",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: relation \"schema5711.view5712\" does not exist (SQLSTATE 42P01)",
		  |  "txStatus": "TxStatusRollbackSuccess"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "22:17:10.333341",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE schema707.table4268 ALTER COLUMN \"col4149_4163\" SET DATA TYPE REGNAMESPACE"
		  |  ],
		  |  "expectedExecErrors": "0A000",
		  |  "expectedCommitErrors": "",
		  |  "message": "ROLLBACK; Successfully got expected execution error: ERROR: ALTER COLUMN TYPE from string to regnamespace is only supported experimentally (SQLSTATE 0A000)",
		  |  "txStatus": "TxStatusRollbackSuccess"
		  | }
		  | {
		  |  "workerId": 0,
		  |  "clientTimestamp": "22:17:09.940416",
		  |  "ops": [
		  |   "BEGIN",
		  |   "ALTER TABLE schema3399.table5025 ALTER COLUMN \"col5025_5029\" SET DATA TYPE CHAR"
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Received an unexpected execution error: ERROR: ALTER COLUMN TYPE from name to char is only supported experimentally (SQLSTATE 0A000)",
		  |  "txStatus": "TxStatusRollbackSuccess"
		  | }
		Wraps: (4) exit status 20
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *main.withCommandDetails (4) *exec.ExitError
Reproduce

To reproduce, try:

# From https://go.crdb.dev/p/roachstress, perhaps edited lightly.
caffeinate ./roachstress.sh scbench/randomload/nodes=3/ops=10000/conc=20

Same failure on other branches

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot.
Projects
None yet
Development

No branches or pull requests

2 participants