-
Notifications
You must be signed in to change notification settings - Fork 4.1k
roachtest: acceptance/version-upgrade failed #58329
Copy link
Copy link
Closed
Labels
C-test-failureBroken test (automatically or manually discovered).Broken test (automatically or manually discovered).O-roachtestO-robotOriginated from a bot.Originated from a bot.release-blockerIndicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked.Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked.
Description
(roachtest).acceptance/version-upgrade failed on release-note-script-update@f6d6d786999d2d4103e65705dcfd7cbf706cf259:
| runtime.goexit()
| /usr/local/go/src/runtime/asm_amd64.s:1374 +0x1 fp=0xc000d0dfa0 sp=0xc000d0df98 pc=0x4890e1
| created by github.com/cockroachdb/cockroach/pkg/workload/cli.runRun.func2
| /go/src/github.com/cockroachdb/cockroach/pkg/workload/cli/run.go:416 +0x111
| /bin/bash: line 1: 22031 Aborted (core dumped) bash -c "./workload run schemachange --verbose=1 --tolerate-errors=true --max-ops 10 --concurrency 2 'postgres://root@127.0.0.1:26257?sslmode=disable' 'postgres://root@127.0.0.1:26259?sslmode=disable' 'postgres://root@127.0.0.1:26261?sslmode=disable' 'postgres://root@127.0.0.1:26263?sslmode=disable'"
| Error: COMMAND_PROBLEM: exit status 134
| (1) COMMAND_PROBLEM
| Wraps: (2) Node 1. Command with error:
| | ```
| | ./workload run schemachange --verbose=1 --tolerate-errors=true --max-ops 10 --concurrency 2 {pgurl:1-4}
| | ```
| Wraps: (3) exit status 134
| Error types: (1) errors.Cmd (2) *hintdetail.withDetail (3) *exec.ExitError
|
| stdout:
| BEGIN
| BEGIN
| CREATE VIEW schema11.view9 AS SELECT public.table1.col1_0, public.table1.col1_2, public.table1.col1_11, public.table1.col1_7, public.table1.col1_8, public.table1.col1_5, public.table1.col1_10, public.table1.col1_12, public.table1.col1_6, public.table1.col1_9 FROM public.table1;
| ALTER VIEW schema11.view9 RENAME TO schema11.view10;
| CREATE TYPE public.enum11 AS ENUM ('fs', 'dd', 'dfdf', 'fsfsa', 'afa', 'dds');
| ALTER TABLE public.table6 RENAME TO public.table12;
| CREATE SCHEMA schema13 AUTHORIZATION root;
| COMMIT;
| BEGIN
| DROP VIEW schema11.view10 RESTRICT;
| ALTER TABLE public.table1 ALTER COLUMN "col1_1" DROP DEFAULT;
| ALTER TABLE public.table1 ALTER COLUMN "col1_2" SET DATA TYPE STRING;
| ROLLBACK; expected SQLSTATE(S) 0A000,42846, and got ERROR: ALTER COLUMN TYPE from inet to string is only supported experimentally (SQLSTATE 0A000)
| BEGIN
| DROP TABLE public.table1 RESTRICT;
| ROLLBACK; expected SQLSTATE(S) 2BP01, and got ERROR: cannot drop relation "table1" because view "view10" depends on it (SQLSTATE 2BP01)
| BEGIN
| CREATE TABLE public.table14 (col14_0 TIME NULL, col14_1 "char" NOT NULL, col14_2 BOX2D NOT NULL, col14_3 BYTES NULL, col14_4 FLOAT8 NOT NULL, col14_5 TIMETZ NOT NULL, col14_6 INT4 NOT NULL, col14_7 REGPROC NOT NULL, col14_8 NAME NOT NULL, col14_9 DECIMAL NOT NULL, col14_10 UUID, col14_11 TIMESTAMP NOT NULL, col14_12 INT2 NULL, PRIMARY KEY (col14_1, col14_11 DESC, col14_4 DESC, col14_7 DESC, col14_9, col14_2 ASC, col14_8 ASC, col14_5, col14_6), UNIQUE (col14_0 ASC, col14_7 DESC, col14_9 ASC, col14_2, col14_1, col14_3 DESC, col14_11 DESC, col14_6, col14_5 DESC), INDEX (col14_9 ASC, col14_7 ASC, col14_1, col14_0 ASC, col14_4, col14_10, col14_6, col14_3 DESC, col14_8 ASC, col14_11, col14_12 ASC, col14_2), INDEX (col14_2 ASC), INDEX (col14_0 ASC, col14_4 ASC, col14_11, col14_12, col14_2, col14_10 ASC, col14_1 DESC, col14_3, col14_8 ASC, col14_6 DESC, col14_7 DESC, col14_9), FAMILY (col14_12), FAMILY (col14_4), FAMILY (col14_2, col14_0), FAMILY (col14_10, col14_6, col14_3, col14_11), FAMILY (col14_5), FAMILY (col14_7), FAMILY (col14_1, col14_8), FAMILY (col14_9));
| ALTER TABLE public.table14 ALTER COLUMN "col14_10" SET NOT NULL;
| CREATE SEQUENCE IF NOT EXISTS public.seq15 OWNED BY public.table1.col1_2;
| ROLLBACK; ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_WRITE_TOO_OLD - WriteTooOld flag converted to WriteTooOldError): "sql txn" meta={id=cdc3e6ad key=/Table/SystemConfigSpan/Start pri=0.02564741 epo=0 ts=1609253874.332114696,1 min=1609253874.232465263,0 seq=24} lock=true stat=PENDING rts=1609253874.232465263,0 wto=false max=1609253874.233606146,0 (SQLSTATE 40001)
| _elapsed___errors__ops/sec(inst)___ops/sec(cum)__p50(ms)__p95(ms)__p99(ms)_pMax(ms)
| 1.0s 1 9.2 11.0 22.0 35.7 75.5 75.5 opOk
| 1.0s 1 0.8 1.0 604.0 604.0 604.0 604.0 txnOk
| 1.0s 1 2.5 3.0 0.8 19.9 19.9 19.9 txnRbk
| BEGIN
| SELECT 'validating all objects';
| ALTER INDEX public.table1@"index1_14" RENAME TO "index1_14";
| INSERT INTO public.table12 () VALUES ();
| ***FAIL; Expected no errors, but got ERROR: at or near ")": syntax error (SQLSTATE 42601)
| BEGIN
| ALTER TABLE public.table16 ALTER COLUMN IrrelevantColumnName DROP STORED;
| ROLLBACK; expected SQLSTATE(S) 42P01, and got ERROR: relation "public.table16" does not exist (SQLSTATE 42P01)
Wraps: (4) exit status 20
Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *main.withCommandDetails (4) *exec.ExitError
More
Artifacts: /acceptance/version-upgrade
Related:
-
roachtest: acceptance/version-upgrade failed: invalid attempted write of database descriptor #58307 roachtest: acceptance/version-upgrade failed A-schema-descriptors C-bug C-test-failure O-roachtest branch-release-20.2
-
roachtest: acceptance/version-upgrade failed #58139 roachtest: acceptance/version-upgrade failed C-test-failure O-roachtest O-robot branch-release-20.1
-
roachtest: acceptance/version-upgrade failed #53812 roachtest: acceptance/version-upgrade failed C-test-failure O-roachtest O-robot branch-release-19.2
See this test on roachdash
powered by pkg/cmd/internal/issues
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
C-test-failureBroken test (automatically or manually discovered).Broken test (automatically or manually discovered).O-roachtestO-robotOriginated from a bot.Originated from a bot.release-blockerIndicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked.Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked.