Skip to content

roachtest: acceptance/version-upgrade failed #58329

@cockroach-teamcity

Description

@cockroach-teamcity

(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:

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    C-test-failureBroken test (automatically or manually discovered).O-roachtestO-robotOriginated from a bot.release-blockerIndicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions