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: schemachange/mixed-versions failed #87477

Closed
cockroach-teamcity opened this issue Sep 7, 2022 · 6 comments
Closed

roachtest: schemachange/mixed-versions failed #87477

cockroach-teamcity opened this issue Sep 7, 2022 · 6 comments
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)
Milestone

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Sep 7, 2022

roachtest.schemachange/mixed-versions failed with artifacts on master @ 2372698da1dfacb90f60c6a63f2c1298d1db16b8:

		  |   304.0s        2            0.0            0.0      0.0      0.0      0.0      0.0 txnRbk
		  |   305.0s        2            0.0            0.5      0.0      0.0      0.0      0.0 opOk
		  |   305.0s        2            0.0            0.0      0.0      0.0      0.0      0.0 txnCmtErr
		  |   305.0s        2            0.0            0.1      0.0      0.0      0.0      0.0 txnOk
		  |   305.0s        2            0.0            0.0      0.0      0.0      0.0      0.0 txnRbk
		  |   306.0s        2            0.0            0.5      0.0      0.0      0.0      0.0 opOk
		  | _elapsed___errors__ops/sec(inst)___ops/sec(cum)__p50(ms)__p95(ms)__p99(ms)_pMax(ms)
		  |   306.0s        2            0.0            0.0      0.0      0.0      0.0      0.0 txnCmtErr
		  |   306.0s        2            0.0            0.1      0.0      0.0      0.0      0.0 txnOk
		  |   306.0s        2            0.0            0.0      0.0      0.0      0.0      0.0 txnRbk
		  |   307.0s        2            0.0            0.5      0.0      0.0      0.0      0.0 opOk
		  |   307.0s        2            0.0            0.0      0.0      0.0      0.0      0.0 txnCmtErr
		  |   307.0s        2            0.0            0.1      0.0      0.0      0.0      0.0 txnOk
		  |   307.0s        2            0.0            0.0      0.0      0.0      0.0      0.0 txnRbk
		  |   308.0s        2            0.0            0.5      0.0      0.0      0.0      0.0 opOk
		  |   308.0s        2            0.0            0.0      0.0      0.0      0.0      0.0 txnCmtErr
		  |   308.0s        2            0.0            0.1      0.0      0.0      0.0      0.0 txnOk
		  |   308.0s        2            0.0            0.0      0.0      0.0      0.0      0.0 txnRbk
		  |   309.0s        2            0.0            0.5      0.0      0.0      0.0      0.0 opOk
		  |   309.0s        2            0.0            0.0      0.0      0.0      0.0      0.0 txnCmtErr
		  |   309.0s        2            0.0            0.1      0.0      0.0      0.0      0.0 txnOk
		  |   309.0s        2            0.0            0.0      0.0      0.0      0.0      0.0 txnRbk
		  |   310.0s        2            0.0            0.5      0.0      0.0      0.0      0.0 opOk
		  |   310.0s        2            0.0            0.0      0.0      0.0      0.0      0.0 txnCmtErr
		  |   310.0s        2            0.0            0.1      0.0      0.0      0.0      0.0 txnOk
		  |   310.0s        2            0.0            0.0      0.0      0.0      0.0      0.0 txnRbk
		  |   311.0s        2            0.0            0.5      0.0      0.0      0.0      0.0 opOk
		  | _elapsed___errors__ops/sec(inst)___ops/sec(cum)__p50(ms)__p95(ms)__p99(ms)_pMax(ms)
		  |   311.0s        2            0.0            0.0      0.0      0.0      0.0      0.0 txnCmtErr
		  |   311.0s        2            0.0            0.1      0.0      0.0      0.0      0.0 txnOk
		  |   311.0s        2            0.0            0.0      0.0      0.0      0.0      0.0 txnRbk
		  |   312.0s        2            0.0            0.5      0.0      0.0      0.0      0.0 opOk
		  |   312.0s        2            0.0            0.0      0.0      0.0      0.0      0.0 txnCmtErr
		  |   312.0s        2            0.0            0.1      0.0      0.0      0.0      0.0 txnOk
		  |   312.0s        2            0.0            0.0      0.0      0.0      0.0      0.0 txnRbk
		  |   313.0s        2            0.0            0.5      0.0      0.0      0.0      0.0 opOk
		  |   313.0s        2            0.0            0.0      0.0      0.0      0.0      0.0 txnCmtErr
		  |   313.0s        2            0.0            0.1      0.0      0.0      0.0      0.0 txnOk
		  |   313.0s        2            0.0            0.0      0.0      0.0      0.0      0.0 txnRbk
		  |   314.0s        2            0.0            0.5      0.0      0.0      0.0      0.0 opOk
		  |   314.0s        2            0.0            0.0      0.0      0.0      0.0      0.0 txnCmtErr
		  |   314.0s        2            0.0            0.1      0.0      0.0      0.0      0.0 txnOk
		  |   314.0s        2            0.0            0.0      0.0      0.0      0.0      0.0 txnRbk
		Wraps: (4) SSH_PROBLEM
		Wraps: (5) Node 1. Command with error:
		  | ``````
		  | ./workload run schemachange --verbose=1 --tolerate-errors=true --max-ops 100 --concurrency 5 {pgurl:1-4}
		  | ``````
		Wraps: (6) exit status 255
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) errors.SSH (5) *hintdetail.withDetail (6) *exec.ExitError

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

/cc @cockroachdb/sql-schema

This test on roachdash | Improve this report!

Jira issue: CRDB-19360

@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 Sep 7, 2022
@cockroach-teamcity cockroach-teamcity added this to the 22.2 milestone Sep 7, 2022
@blathers-crl blathers-crl bot added the T-sql-schema-deprecated Use T-sql-foundations instead label Sep 7, 2022
@cockroach-teamcity
Copy link
Member Author

roachtest.schemachange/mixed-versions failed with artifacts on master @ e39111b2e714375faa0facc05e51e8f619a55b21:

		  |   300.0s        4            0.0            0.0      0.0      0.0      0.0      0.0 txnRbk
		  |   301.0s        4            0.0            0.5      0.0      0.0      0.0      0.0 opOk
		  | _elapsed___errors__ops/sec(inst)___ops/sec(cum)__p50(ms)__p95(ms)__p99(ms)_pMax(ms)
		  |   301.0s        4            0.0            0.0      0.0      0.0      0.0      0.0 txnCmtErr
		  |   301.0s        4            0.0            0.1      0.0      0.0      0.0      0.0 txnOk
		  |   301.0s        4            0.0            0.0      0.0      0.0      0.0      0.0 txnRbk
		  |   302.0s        4            0.0            0.5      0.0      0.0      0.0      0.0 opOk
		  |   302.0s        4            0.0            0.0      0.0      0.0      0.0      0.0 txnCmtErr
		  |   302.0s        4            0.0            0.1      0.0      0.0      0.0      0.0 txnOk
		  |   302.0s        4            0.0            0.0      0.0      0.0      0.0      0.0 txnRbk
		  |   303.0s        4            0.0            0.5      0.0      0.0      0.0      0.0 opOk
		  |   303.0s        4            0.0            0.0      0.0      0.0      0.0      0.0 txnCmtErr
		  |   303.0s        4            0.0            0.1      0.0      0.0      0.0      0.0 txnOk
		  |   303.0s        4            0.0            0.0      0.0      0.0      0.0      0.0 txnRbk
		  |   304.0s        4            0.0            0.5      0.0      0.0      0.0      0.0 opOk
		  |   304.0s        4            0.0            0.0      0.0      0.0      0.0      0.0 txnCmtErr
		  |   304.0s        4            0.0            0.1      0.0      0.0      0.0      0.0 txnOk
		  |   304.0s        4            0.0            0.0      0.0      0.0      0.0      0.0 txnRbk
		  |   305.0s        4            0.0            0.5      0.0      0.0      0.0      0.0 opOk
		  |   305.0s        4            0.0            0.0      0.0      0.0      0.0      0.0 txnCmtErr
		  |   305.0s        4            0.0            0.1      0.0      0.0      0.0      0.0 txnOk
		  |   305.0s        4            0.0            0.0      0.0      0.0      0.0      0.0 txnRbk
		  |   306.0s        4            0.0            0.5      0.0      0.0      0.0      0.0 opOk
		  | _elapsed___errors__ops/sec(inst)___ops/sec(cum)__p50(ms)__p95(ms)__p99(ms)_pMax(ms)
		  |   306.0s        4            0.0            0.0      0.0      0.0      0.0      0.0 txnCmtErr
		  |   306.0s        4            0.0            0.1      0.0      0.0      0.0      0.0 txnOk
		  |   306.0s        4            0.0            0.0      0.0      0.0      0.0      0.0 txnRbk
		  |   307.0s        4            0.0            0.5      0.0      0.0      0.0      0.0 opOk
		  |   307.0s        4            0.0            0.0      0.0      0.0      0.0      0.0 txnCmtErr
		  |   307.0s        4            0.0            0.1      0.0      0.0      0.0      0.0 txnOk
		  |   307.0s        4            0.0            0.0      0.0      0.0      0.0      0.0 txnRbk
		  |   308.0s        4            0.0            0.5      0.0      0.0      0.0      0.0 opOk
		  |   308.0s        4            0.0            0.0      0.0      0.0      0.0      0.0 txnCmtErr
		  |   308.0s        4            0.0            0.1      0.0      0.0      0.0      0.0 txnOk
		  |   308.0s        4            0.0            0.0      0.0      0.0      0.0      0.0 txnRbk
		  |   309.0s        4            0.0            0.5      0.0      0.0      0.0      0.0 opOk
		  |   309.0s        4            0.0            0.0      0.0      0.0      0.0      0.0 txnCmtErr
		  |   309.0s        4            0.0            0.1      0.0      0.0      0.0      0.0 txnOk
		  |   309.0s        4            0.0            0.0      0.0      0.0      0.0      0.0 txnRbk
		  |   310.0s        4            0.0            0.5      0.0      0.0      0.0      0.0 opOk
		  |   310.0s        4            0.0            0.0      0.0      0.0      0.0      0.0 txnCmtErr
		  |   310.0s        4            0.0            0.1      0.0      0.0      0.0      0.0 txnOk
		  |   310.0s        4            0.0            0.0      0.0      0.0      0.0      0.0 txnRbk
		Wraps: (4) SSH_PROBLEM
		Wraps: (5) Node 2. Command with error:
		  | ``````
		  | ./workload run schemachange --verbose=1 --tolerate-errors=true --max-ops 100 --concurrency 5 {pgurl:1-4}
		  | ``````
		Wraps: (6) exit status 255
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) errors.SSH (5) *hintdetail.withDetail (6) *exec.ExitError

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@ajwerner ajwerner 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 Sep 19, 2022
@ajwerner
Copy link
Contributor

@fqazi can you deflake this one too? I think it's the same as #87142.

@fqazi
Copy link
Collaborator

fqazi commented Sep 19, 2022

Yes let me dig into this

@fqazi
Copy link
Collaborator

fqazi commented Sep 19, 2022

Yes the fixes in that PR address this too

craig bot pushed a commit that referenced this issue Sep 21, 2022
86277: eventpb: add storage event types r=jbowens,sumeerbhola a=nicktrav

Add the `StoreStats` event type, a per-store event emitted to the
`TELEMETRY` logging channel. This event type will be computed from the
Pebble metrics for each store.

Emit a `StoreStats` event periodically, by default, once per hour, per
store.

Touches #85589.

Release note: None.

Release justification: low risk, high benefit changes to existing
functionality.

87142: workload/mixed-version/schemachanger: re-enable mixed version workload r=fqazi a=fqazi

Fixes: #58489 #87477

Previously the mixed version schema changer workload was disabled because of the lack of version gates. These changes will do the following:

- Start reporting errors on this workload again.
- Disable trigrams in a mixed version state.
- Disable the insert part of the workload in a mixed version state (there is an optimizer on 22.1 that can cause some of the queries to fail)

Release justification: low risk only extends test coverage

87883: schedulerlatency: export Go scheduling latency metric r=irfansharif a=irfansharif

And record data into CRDB's internal time-series database. Informs
\#82743 and #87823. To export scheduling latencies to prometheus, we
choose an exponential bucketing scheme with base multiple of 1.1, and
the output range bounded to [50us, 100ms). This makes for ~70 buckets.
It's worth noting that the default histogram buckets used in Go are
not fit for our purposes. If we care about improving it, we could
consider patching the runtime.

```
  bucket[  0] width=0s boundary=[-Inf, 0s)
  bucket[  1] width=1ns boundary=[0s, 1ns)
  bucket[  2] width=1ns boundary=[1ns, 2ns)
  bucket[  3] width=1ns boundary=[2ns, 3ns)
  bucket[  4] width=1ns boundary=[3ns, 4ns)
  ...
  bucket[270] width=16.384µs boundary=[737.28µs, 753.664µs)
  bucket[271] width=16.384µs boundary=[753.664µs, 770.048µs)
  bucket[272] width=278.528µs boundary=[770.048µs, 1.048576ms)
  bucket[273] width=32.768µs boundary=[1.048576ms, 1.081344ms)
  bucket[274] width=32.768µs boundary=[1.081344ms, 1.114112ms)
  ...
  bucket[717] width=1h13m18.046511104s boundary=[53h45m14.046488576s, 54h58m32.09299968s)
  bucket[718] width=1h13m18.046511104s boundary=[54h58m32.09299968s, 56h11m50.139510784s)
  bucket[719] width=1h13m18.046511104s boundary=[56h11m50.139510784s, 57h25m8.186021888s)
  bucket[720] width=57h25m8.186021888s boundary=[57h25m8.186021888s, +Inf)
```

Release note: None
Release justification: observability-only PR, low-risk high-benefit; would help understand admission control out in the wild

88179: ui/cluster-ui: fix no most recent stmt for active txns r=xinhaoz a=xinhaoz

Fixes #87738

Previously, active txns could have an empty 'Most Recent Statement' column, even if their executed statement count was non-zero. This was due to the most recent query text being populated by the active stmt, which could be empty at the time of querying. This commit populates the last statement text for a txn even when it is not currently executing a query.

This commit also removes the `isFullScan` field from active txn pages, as we cannot fill this field out without all stmts in the txn.

Release note (ui change): Full scan field is removed from active txn details page.

Release note (bug fix): active txns with non-zero
executed statement count now always have populated stmt text, even when no stmt is being executed.

88334: kvserver: align Raft recv/send queue sizes r=erikgrinaker a=pavelkalinnikov

Fixes #87465

Release justification: performance fix
Release note: Made sending and receiving Raft queue sizes match. Previously the receiver could unnecessarily drop messages in situations when the sending queue is bigger than the receiving one.

Co-authored-by: Nick Travers <travers@cockroachlabs.com>
Co-authored-by: Faizan Qazi <faizan@cockroachlabs.com>
Co-authored-by: irfan sharif <irfanmahmoudsharif@gmail.com>
Co-authored-by: Xin Hao Zhang <xzhang@cockroachlabs.com>
Co-authored-by: Pavel Kalinnikov <pavel@cockroachlabs.com>
@cockroach-teamcity
Copy link
Member Author

roachtest.schemachange/mixed-versions failed with artifacts on master @ 726cf22b9f06b766d857b4617dec0df18d1e5cd0:

		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/mixed_version_schemachange.go:141
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.registerSchemaChangeMixedVersions.func1
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/mixed_version_schemachange.go:39
		  | main.(*testRunner).runTest.func2
		  | 	main/pkg/cmd/roachtest/test_runner.go:928
		  | runtime.goexit
		  | 	GOROOT/src/runtime/asm_amd64.s:1594
		Wraps: (2) output in run_052931.525687850_n1_workload_run_schemachange
		Wraps: (3) ./workload run schemachange --verbose=1 --max-ops 100 --concurrency 5 {pgurl:1-4} returned
		  | stderr:
		  | I220922 05:29:32.746122 1 workload/cli/run.go:427  [-] 1  creating load generator...
		  | I220922 05:29:32.824443 1 workload/cli/run.go:458  [-] 2  creating load generator... done (took 78.320681ms)
		  | I220922 05:29:32.844412 102 workload/pgx_helpers.go:79  [-] 3  pgx logger [error]: Exec logParams=map[args:[] err:ERROR: relation "InvalidObjectName.table1" does not exist (SQLSTATE 42P01) pid:1559545 sql:INSERT INTO "InvalidObjectName".table1 (IrrelevantColumnName) VALUES ("IrrelevantValue") time:933.156µs]
		  | I220922 05:29:32.872353 101 workload/pgx_helpers.go:79  [-] 4  pgx logger [error]: Exec logParams=map[args:[] err:ERROR: at or near "not": syntax error (SQLSTATE 42601) pid:5207589 sql:CREATE TABLE public.table2 (col2_3 TIME NOT NULL, col2_4 INTERVAL NOT NULL, col2_5 INT2 NOT NULL, col2_6 TIME NOT NULL, col2_7 REGTYPE, col2_8 TIMETZ NOT NULL, col2_9 STRING AS (CASE WHEN col2_7 IS NULL THEN e'!\x10Nb\x05TeL\x14':::STRING ELSE e'\x03':::STRING END) STORED, col2_10 STRING NOT NULL AS (CASE WHEN col2_4 IS NULL THEN e'I\x0bg!':::STRING ELSE '':::STRING END) VIRTUAL, PRIMARY KEY (col2_5 DESC), UNIQUE (col2_10, col2_5, col2_6, col2_7 ASC, col2_8) STORING (col2_4), INDEX (col2_10 DESC, col2_7 DESC, col2_4 DESC, col2_8) STORING (col2_6) NOT VISIBLE, UNIQUE (col2_7, col2_4 ASC, col2_10 DESC, col2_6 DESC, col2_5 ASC) STORING (col2_8), INDEX ((CASE WHEN col2_7 IS NULL THEN e'qa^Yd\x17':::STRING ELSE e'\'':::STRING END) DESC, col2_3 ASC, col2_6 ASC, col2_7 ASC, col2_9 DESC, col2_10 ASC, col2_4 DESC), INDEX (col2_8, col2_7 ASC, col2_10 ASC, (col2_5 + (-12104):::INT8), col2_3 DESC, col2_9, col2_6, col2_5 ASC) STORING (col2_4), INDEX (col2_7 DESC, col2_5 DESC) STORING (col2_3, col2_4, col2_8, col2_9) NOT VISIBLE, INDEX (col2_4, col2_8 ASC, col2_9 ASC, col2_5, col2_3 DESC, (CASE WHEN col2_4 IS NULL THEN e'\x13\x01H5i':::STRING ELSE e'M\x1dr\b>#':::STRING END) DESC), UNIQUE (col2_10 DESC, col2_5, col2_3, col2_8 DESC), INDEX (col2_4 ASC) STORING (col2_6, col2_8)) time:998.075µs]
		  | Error: ***UNEXPECTED ERROR; Received an unexpected execution error.
		  |  Dumping state before death:
		  | Expected errors: 
		  | Potential errors: 
		  | Expected commit errors: 
		  | Potential commit errors: 
		  | ===========================
		  | Executed queries for generating errors: QUERY ["SELECT EXISTS (SELECT * FROM [SHOW REGIONS FROM DATABASE])" []] :false
		  | QUERY ["SELECT EXISTS (\n\tSELECT table_name\n    FROM information_schema.tables \n   WHERE table_schema = $1\n     AND table_name = $2\n   )" ["public" "table2"]] :false
		  | QUERY ["SELECT EXISTS (\n\tSELECT schema_name\n\t\tFROM information_schema.schemata\n   WHERE schema_name = $1\n\t)" ["public"]] :true
		  |
		  | ===========================
		  | Previous statements [QUERY: CREATE TABLE public.table2 (col2_3 TIME NOT NULL, col2_4 INTERVAL NOT NULL, col2_5 INT2 NOT NULL, col2_6 TIME NOT NULL, col2_7 REGTYPE, col2_8 TIMETZ NOT NULL, col2_9 STRING AS (CASE WHEN col2_7 IS NULL THEN e'!\x10Nb\x05TeL\x14':::STRING ELSE e'\x03':::STRING END) STORED, col2_10 STRING NOT NULL AS (CASE WHEN col2_4 IS NULL THEN e'I\x0bg!':::STRING ELSE '':::STRING END) VIRTUAL, PRIMARY KEY (col2_5 DESC), UNIQUE (col2_10, col2_5, col2_6, col2_7 ASC, col2_8) STORING (col2_4), INDEX (col2_10 DESC, col2_7 DESC, col2_4 DESC, col2_8) STORING (col2_6) NOT VISIBLE, UNIQUE (col2_7, col2_4 ASC, col2_10 DESC, col2_6 DESC, col2_5 ASC) STORING (col2_8), INDEX ((CASE WHEN col2_7 IS NULL THEN e'qa^Yd\x17':::STRING ELSE e'\'':::STRING END) DESC, col2_3 ASC, col2_6 ASC, col2_7 ASC, col2_9 DESC, col2_10 ASC, col2_4 DESC), INDEX (col2_8, col2_7 ASC, col2_10 ASC, (col2_5 + (-12104):::INT8), col2_3 DESC, col2_9, col2_6, col2_5 ASC) STORING (col2_4), INDEX (col2_7 DESC, col2_5 DESC) STORING (col2_3, col2_4, col2_8, col2_9) NOT VISIBLE, INDEX (col2_4, col2_8 ASC, col2_9 ASC, col2_5, col2_3 DESC, (CASE WHEN col2_4 IS NULL THEN e'\x13\x01H5i':::STRING ELSE e'M\x1dr\b>#':::STRING END) DESC), UNIQUE (col2_10 DESC, col2_5, col2_3, col2_8 DESC), INDEX (col2_4 ASC) STORING (col2_6, col2_8)), Expected Errors: , Potential Errors: ]: ERROR: at or near "not": syntax error (SQLSTATE 42601)
		  |
		  | stdout:
		  | <... some data truncated by circular buffer; go to artifacts for details ...>
		  | rors: QUERY [\"SELECT EXISTS (\\n\\tSELECT table_name\\n    FROM information_schema.tables \\n   WHERE table_schema = $1\\n     AND table_name = $2\\n   )\" [\"public\" \"table1\"]] :false\n\n===========================\nPrevious statements [QUERY: INSERT INTO \"InvalidObjectName\".table1 (IrrelevantColumnName) VALUES (\"IrrelevantValue\"), Expected Errors: 42P01, Potential Errors: ]: ERROR: relation \"InvalidObjectName.table1\" does not exist (SQLSTATE 42P01)"
		  | }
		  | {
		  |  "workerId": 2,
		  |  "clientTimestamp": "05:29:32.839892",
		  |  "ops": [
		  |   "BEGIN",
		  |   "QUERY: CREATE TABLE public.table2 (col2_3 TIME NOT NULL, col2_4 INTERVAL NOT NULL, col2_5 INT2 NOT NULL, col2_6 TIME NOT NULL, col2_7 REGTYPE, col2_8 TIMETZ NOT NULL, col2_9 STRING AS (CASE WHEN col2_7 IS NULL THEN e'!\\x10Nb\\x05TeL\\x14':::STRING ELSE e'\\x03':::STRING END) STORED, col2_10 STRING NOT NULL AS (CASE WHEN col2_4 IS NULL THEN e'I\\x0bg!':::STRING ELSE '':::STRING END) VIRTUAL, PRIMARY KEY (col2_5 DESC), UNIQUE (col2_10, col2_5, col2_6, col2_7 ASC, col2_8) STORING (col2_4), INDEX (col2_10 DESC, col2_7 DESC, col2_4 DESC, col2_8) STORING (col2_6) NOT VISIBLE, UNIQUE (col2_7, col2_4 ASC, col2_10 DESC, col2_6 DESC, col2_5 ASC) STORING (col2_8), INDEX ((CASE WHEN col2_7 IS NULL THEN e'qa^Yd\\x17':::STRING ELSE e'\\'':::STRING END) DESC, col2_3 ASC, col2_6 ASC, col2_7 ASC, col2_9 DESC, col2_10 ASC, col2_4 DESC), INDEX (col2_8, col2_7 ASC, col2_10 ASC, (col2_5 + (-12104):::INT8), col2_3 DESC, col2_9, col2_6, col2_5 ASC) STORING (col2_4), INDEX (col2_7 DESC, col2_5 DESC) STORING (col2_3, col2_4, col2_8, col2_9) NOT VISIBLE, INDEX (col2_4, col2_8 ASC, col2_9 ASC, col2_5, col2_3 DESC, (CASE WHEN col2_4 IS NULL THEN e'\\x13\\x01H5i':::STRING ELSE e'M\\x1dr\\b\u003e#':::STRING END) DESC), UNIQUE (col2_10 DESC, col2_5, col2_3, col2_8 DESC), INDEX (col2_4 ASC) STORING (col2_6, col2_8)), Expected Errors: , Potential Errors: "
		  |  ],
		  |  "expectedExecErrors": "",
		  |  "expectedCommitErrors": "",
		  |  "message": "***UNEXPECTED ERROR; Received an unexpected execution error.\n Dumping state before death:\nExpected errors: \nPotential errors: \nExpected commit errors: \nPotential commit errors: \n===========================\nExecuted queries for generating errors: QUERY [\"SELECT EXISTS (SELECT * FROM [SHOW REGIONS FROM DATABASE])\" []] :false\nQUERY [\"SELECT EXISTS (\\n\\tSELECT table_name\\n    FROM information_schema.tables \\n   WHERE table_schema = $1\\n     AND table_name = $2\\n   )\" [\"public\" \"table2\"]] :false\nQUERY [\"SELECT EXISTS (\\n\\tSELECT schema_name\\n\\t\\tFROM information_schema.schemata\\n   WHERE schema_name = $1\\n\\t)\" [\"public\"]] :true\n\n===========================\nPrevious statements [QUERY: CREATE TABLE public.table2 (col2_3 TIME NOT NULL, col2_4 INTERVAL NOT NULL, col2_5 INT2 NOT NULL, col2_6 TIME NOT NULL, col2_7 REGTYPE, col2_8 TIMETZ NOT NULL, col2_9 STRING AS (CASE WHEN col2_7 IS NULL THEN e'!\\x10Nb\\x05TeL\\x14':::STRING ELSE e'\\x03':::STRING END) STORED, col2_10 STRING NOT NULL AS (CASE WHEN col2_4 IS NULL THEN e'I\\x0bg!':::STRING ELSE '':::STRING END) VIRTUAL, PRIMARY KEY (col2_5 DESC), UNIQUE (col2_10, col2_5, col2_6, col2_7 ASC, col2_8) STORING (col2_4), INDEX (col2_10 DESC, col2_7 DESC, col2_4 DESC, col2_8) STORING (col2_6) NOT VISIBLE, UNIQUE (col2_7, col2_4 ASC, col2_10 DESC, col2_6 DESC, col2_5 ASC) STORING (col2_8), INDEX ((CASE WHEN col2_7 IS NULL THEN e'qa^Yd\\x17':::STRING ELSE e'\\'':::STRING END) DESC, col2_3 ASC, col2_6 ASC, col2_7 ASC, col2_9 DESC, col2_10 ASC, col2_4 DESC), INDEX (col2_8, col2_7 ASC, col2_10 ASC, (col2_5 + (-12104):::INT8), col2_3 DESC, col2_9, col2_6, col2_5 ASC) STORING (col2_4), INDEX (col2_7 DESC, col2_5 DESC) STORING (col2_3, col2_4, col2_8, col2_9) NOT VISIBLE, INDEX (col2_4, col2_8 ASC, col2_9 ASC, col2_5, col2_3 DESC, (CASE WHEN col2_4 IS NULL THEN e'\\x13\\x01H5i':::STRING ELSE e'M\\x1dr\\b\u003e#':::STRING END) DESC), UNIQUE (col2_10 DESC, col2_5, col2_3, col2_8 DESC), INDEX (col2_4 ASC) STORING (col2_6, col2_8)), Expected Errors: , Potential Errors: ]: ERROR: at or near \"not\": syntax error (SQLSTATE 42601)"
		  | }
		Wraps: (4) COMMAND_PROBLEM
		Wraps: (5) Node 1. Command with error:
		  | ``````
		  | ./workload run schemachange --verbose=1 --max-ops 100 --concurrency 5 {pgurl:1-4}
		  | ``````
		Wraps: (6) exit status 1
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) errors.Cmd (5) *hintdetail.withDetail (6) *exec.ExitError

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

This test on roachdash | Improve this report!

@fqazi
Copy link
Collaborator

fqazi commented Sep 23, 2022

Fixed with #88475

@fqazi fqazi closed this as completed Sep 23, 2022
@exalate-issue-sync exalate-issue-sync bot reopened this May 10, 2023
@exalate-issue-sync exalate-issue-sync bot added T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) and removed T-sql-schema-deprecated Use T-sql-foundations instead labels May 10, 2023
@rafiss rafiss closed this as completed May 10, 2023
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

No branches or pull requests

4 participants