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: acceptance/version-upgrade failed #58329

Closed
cockroach-teamcity opened this issue Dec 29, 2020 · 1 comment
Closed

roachtest: acceptance/version-upgrade failed #58329

cockroach-teamcity opened this issue Dec 29, 2020 · 1 comment
Labels
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.

Comments

@cockroach-teamcity
Copy link
Member

(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

@irfansharif
Copy link
Contributor

Dup of #58489, only created an issue cause the branch name started off with "release-".

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. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked.
Projects
None yet
Development

No branches or pull requests

2 participants