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.

Sign up for GitHub

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

Jump to bottom

roachtest: alterpk-bank failed #85877

Closed
cockroach-teamcity opened this issue Aug 10, 2022 · 7 comments · Fixed by #86192
Closed

roachtest: alterpk-bank failed #85877

cockroach-teamcity opened this issue Aug 10, 2022 · 7 comments · Fixed by #86192
Assignees
@Xiang-Gu
Labels
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. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Milestone
22.2

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Aug 10, 2022 •
edited by cockroach-jira-scripts
Loading

roachtest.alterpk-bank failed with artifacts on master @ f53c21f9fe0fe07ba32d2f28ac4bd2c4bc2ed50b:

		  | 	main/pkg/cmd/roachtest/monitor.go:105
		  | golang.org/x/sync/errgroup.(*Group).Go.func1
		  | 	golang.org/x/sync/errgroup/external/org_golang_x_sync/errgroup/errgroup.go:74
		  | runtime.goexit
		  | 	GOROOT/src/runtime/asm_amd64.s:1571
		Wraps: (2) output in run_052031.886571090_n4_workload_run_bank
		Wraps: (3) ./workload run bank --duration=1m0s {pgurl:1-3} returned
		  | stderr:
		  | I220810 05:20:33.048942 1 workload/cli/run.go:427  [-] 1  creating load generator...
		  | I220810 05:20:33.055608 1 workload/cli/run.go:458  [-] 2  creating load generator... done (took 6.666232ms)
		  |
		  | stdout:
		  | _elapsed___errors__ops/sec(inst)___ops/sec(cum)__p50(ms)__p95(ms)__p99(ms)_pMax(ms)
		  |     1.0s        0         1972.2         1985.6      3.8      6.3      8.4     44.0 transfer
		  |     2.0s        0         1968.1         1976.9      3.9      6.3      8.4     13.6 transfer
		  |     3.0s        0         2000.1         1984.6      3.9      6.3      8.4     13.6 transfer
		  |     4.0s        0         1965.4         1979.8      3.9      6.3      7.3     11.5 transfer
		  |     5.0s        0         1818.7         1947.6      4.1      6.8     10.5     17.8 transfer
		Wraps: (4) secondary error attachment
		  | UNCLASSIFIED_PROBLEM: context canceled
		  | (1) UNCLASSIFIED_PROBLEM
		  | Wraps: (2) Node 4. Command with error:
		  |   | ``````
		  |   | ./workload run bank --duration=1m0s {pgurl:1-3}
		  |   | ``````
		  | Wraps: (3) context canceled
		  | Error types: (1) errors.Unclassified (2) *hintdetail.withDetail (3) *errors.errorString
		Wraps: (5) context canceled
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *secondary.withSecondaryError (5) *errors.errorString

	monitor.go:127,alterpk.go:100,test_runner.go:896: monitor failure: monitor task failed: pq: internal error: error executing StatementPhase stage 1 of 1 with 14 MutationType ops: relation "bank" (106): index "crdb_internal_index_4_name_placeholder" key suffix column ID 0 is invalid
		(1) attached stack trace
		  -- stack trace:
		  | main.(*monitorImpl).WaitE
		  | 	main/pkg/cmd/roachtest/monitor.go:115
		  | main.(*monitorImpl).Wait
		  | 	main/pkg/cmd/roachtest/monitor.go:123
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.registerAlterPK.func2
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/alterpk.go:100
		  | [...repeated from below...]
		Wraps: (2) monitor failure
		Wraps: (3) attached stack trace
		  -- stack trace:
		  | main.(*monitorImpl).wait.func2
		  | 	main/pkg/cmd/roachtest/monitor.go:171
		  | runtime.goexit
		  | 	GOROOT/src/runtime/asm_amd64.s:1571
		Wraps: (4) monitor task failed
		Wraps: (5) pq: internal error: error executing StatementPhase stage 1 of 1 with 14 MutationType ops: relation "bank" (106): index "crdb_internal_index_4_name_placeholder" key suffix column ID 0 is invalid
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *withstack.withStack (4) *errutil.withPrefix (5) *pq.Error

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

roachtest.alterpk-bank failed with artifacts on master @ 43bfc3185cb362b14e0b8a331148f0b14542a4f2:

		  | 	main/pkg/cmd/roachtest/monitor.go:105
		  | golang.org/x/sync/errgroup.(*Group).Go.func1
		  | 	golang.org/x/sync/errgroup/external/org_golang_x_sync/errgroup/errgroup.go:74
		  | runtime.goexit
		  | 	GOROOT/src/runtime/asm_amd64.s:1571
		Wraps: (2) output in run_051927.087108422_n4_workload_run_bank
		Wraps: (3) ./workload run bank --duration=1m0s {pgurl:1-3} returned
		  | stderr:
		  | I220811 05:19:28.299014 1 workload/cli/run.go:427  [-] 1  creating load generator...
		  | I220811 05:19:28.306011 1 workload/cli/run.go:458  [-] 2  creating load generator... done (took 6.996185ms)
		  |
		  | stdout:
		  | _elapsed___errors__ops/sec(inst)___ops/sec(cum)__p50(ms)__p95(ms)__p99(ms)_pMax(ms)
		  |     1.0s        0         1876.5         1889.9      3.9      6.8     11.5     39.8 transfer
		  |     2.0s        0         1962.2         1926.0      3.9      6.6      8.4     14.7 transfer
		  |     3.0s        0         1860.6         1904.2      4.2      6.8      8.4     12.1 transfer
		  |     4.0s        0         1915.1         1906.9      4.1      6.6      8.1     12.6 transfer
		  |     5.0s        0         1998.5         1925.3      3.9      6.6      8.1     11.5 transfer
		Wraps: (4) secondary error attachment
		  | UNCLASSIFIED_PROBLEM: context canceled
		  | (1) UNCLASSIFIED_PROBLEM
		  | Wraps: (2) Node 4. Command with error:
		  |   | ``````
		  |   | ./workload run bank --duration=1m0s {pgurl:1-3}
		  |   | ``````
		  | Wraps: (3) context canceled
		  | Error types: (1) errors.Unclassified (2) *hintdetail.withDetail (3) *errors.errorString
		Wraps: (5) context canceled
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *secondary.withSecondaryError (5) *errors.errorString

	monitor.go:127,alterpk.go:100,test_runner.go:896: monitor failure: monitor task failed: pq: internal error: error executing StatementPhase stage 1 of 1 with 14 MutationType ops: relation "bank" (106): index "crdb_internal_index_4_name_placeholder" key suffix column ID 0 is invalid
		(1) attached stack trace
		  -- stack trace:
		  | main.(*monitorImpl).WaitE
		  | 	main/pkg/cmd/roachtest/monitor.go:115
		  | main.(*monitorImpl).Wait
		  | 	main/pkg/cmd/roachtest/monitor.go:123
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.registerAlterPK.func2
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/alterpk.go:100
		  | [...repeated from below...]
		Wraps: (2) monitor failure
		Wraps: (3) attached stack trace
		  -- stack trace:
		  | main.(*monitorImpl).wait.func2
		  | 	main/pkg/cmd/roachtest/monitor.go:171
		  | runtime.goexit
		  | 	GOROOT/src/runtime/asm_amd64.s:1571
		Wraps: (4) monitor task failed
		Wraps: (5) pq: internal error: error executing StatementPhase stage 1 of 1 with 14 MutationType ops: relation "bank" (106): index "crdb_internal_index_4_name_placeholder" key suffix column ID 0 is invalid
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *withstack.withStack (4) *errutil.withPrefix (5) *pq.Error

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!

@cockroach-teamcity
Copy link
Member Author

roachtest.alterpk-bank failed with artifacts on master @ 773f7d4445ce3e0e806b7a182adba70a0f270f19:

		  | 	main/pkg/cmd/roachtest/monitor.go:105
		  | golang.org/x/sync/errgroup.(*Group).Go.func1
		  | 	golang.org/x/sync/errgroup/external/org_golang_x_sync/errgroup/errgroup.go:74
		  | runtime.goexit
		  | 	GOROOT/src/runtime/asm_amd64.s:1571
		Wraps: (2) output in run_051900.878431445_n4_workload_run_bank
		Wraps: (3) ./workload run bank --duration=1m0s {pgurl:1-3} returned
		  | stderr:
		  | I220812 05:19:02.049890 1 workload/cli/run.go:427  [-] 1  creating load generator...
		  | I220812 05:19:02.058315 1 workload/cli/run.go:458  [-] 2  creating load generator... done (took 8.425349ms)
		  |
		  | stdout:
		  | _elapsed___errors__ops/sec(inst)___ops/sec(cum)__p50(ms)__p95(ms)__p99(ms)_pMax(ms)
		  |     1.0s        0         1970.6         1987.5      3.8      6.6      8.4     41.9 transfer
		  |     2.0s        0         1962.6         1975.0      3.9      6.3      7.6     11.5 transfer
		  |     3.0s        0         1900.0         1950.0      4.1      6.8     10.5     14.7 transfer
		  |     4.0s        0         1905.8         1939.0      3.9      6.8      9.4     15.7 transfer
		  |     5.0s        0         1944.1         1940.0      3.9      6.8      9.4     15.2 transfer
		Wraps: (4) secondary error attachment
		  | UNCLASSIFIED_PROBLEM: context canceled
		  | (1) UNCLASSIFIED_PROBLEM
		  | Wraps: (2) Node 4. Command with error:
		  |   | ``````
		  |   | ./workload run bank --duration=1m0s {pgurl:1-3}
		  |   | ``````
		  | Wraps: (3) context canceled
		  | Error types: (1) errors.Unclassified (2) *hintdetail.withDetail (3) *errors.errorString
		Wraps: (5) context canceled
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *secondary.withSecondaryError (5) *errors.errorString

	monitor.go:127,alterpk.go:100,test_runner.go:896: monitor failure: monitor task failed: pq: internal error: error executing StatementPhase stage 1 of 1 with 14 MutationType ops: relation "bank" (106): index "crdb_internal_index_4_name_placeholder" key suffix column ID 0 is invalid
		(1) attached stack trace
		  -- stack trace:
		  | main.(*monitorImpl).WaitE
		  | 	main/pkg/cmd/roachtest/monitor.go:115
		  | main.(*monitorImpl).Wait
		  | 	main/pkg/cmd/roachtest/monitor.go:123
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.registerAlterPK.func2
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/alterpk.go:100
		  | [...repeated from below...]
		Wraps: (2) monitor failure
		Wraps: (3) attached stack trace
		  -- stack trace:
		  | main.(*monitorImpl).wait.func2
		  | 	main/pkg/cmd/roachtest/monitor.go:171
		  | runtime.goexit
		  | 	GOROOT/src/runtime/asm_amd64.s:1571
		Wraps: (4) monitor task failed
		Wraps: (5) pq: internal error: error executing StatementPhase stage 1 of 1 with 14 MutationType ops: relation "bank" (106): index "crdb_internal_index_4_name_placeholder" key suffix column ID 0 is invalid
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *withstack.withStack (4) *errutil.withPrefix (5) *pq.Error

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!

@cockroach-teamcity
Copy link
Member Author

roachtest.alterpk-bank failed with artifacts on master @ 0dd438d3dc0b42543890455945a7a6b42811def1:

		  | 	main/pkg/cmd/roachtest/monitor.go:105
		  | golang.org/x/sync/errgroup.(*Group).Go.func1
		  | 	golang.org/x/sync/errgroup/external/org_golang_x_sync/errgroup/errgroup.go:74
		  | runtime.goexit
		  | 	GOROOT/src/runtime/asm_amd64.s:1571
		Wraps: (2) output in run_051908.255917710_n4_workload_run_bank
		Wraps: (3) ./workload run bank --duration=1m0s {pgurl:1-3} returned
		  | stderr:
		  | I220813 05:19:09.463758 1 workload/cli/run.go:427  [-] 1  creating load generator...
		  | I220813 05:19:09.469810 1 workload/cli/run.go:458  [-] 2  creating load generator... done (took 6.052707ms)
		  |
		  | stdout:
		  | _elapsed___errors__ops/sec(inst)___ops/sec(cum)__p50(ms)__p95(ms)__p99(ms)_pMax(ms)
		  |     1.0s        0         2002.2         2014.6      3.7      6.6     10.0     37.7 transfer
		  |     2.0s        0         2006.6         2010.6      3.8      6.3      7.9     23.1 transfer
		  |     3.0s        0         2114.8         2045.3      3.7      6.0      8.1     17.8 transfer
		  |     4.0s        0         2084.3         2055.1      3.8      6.0      7.6     11.0 transfer
		  |     5.0s        0         2016.2         2047.3      3.7      6.8     11.0     18.9 transfer
		Wraps: (4) secondary error attachment
		  | UNCLASSIFIED_PROBLEM: context canceled
		  | (1) UNCLASSIFIED_PROBLEM
		  | Wraps: (2) Node 4. Command with error:
		  |   | ``````
		  |   | ./workload run bank --duration=1m0s {pgurl:1-3}
		  |   | ``````
		  | Wraps: (3) context canceled
		  | Error types: (1) errors.Unclassified (2) *hintdetail.withDetail (3) *errors.errorString
		Wraps: (5) context canceled
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *secondary.withSecondaryError (5) *errors.errorString

	monitor.go:127,alterpk.go:100,test_runner.go:896: monitor failure: monitor task failed: pq: internal error: error executing StatementPhase stage 1 of 1 with 14 MutationType ops: relation "bank" (106): index "crdb_internal_index_4_name_placeholder" key suffix column ID 0 is invalid
		(1) attached stack trace
		  -- stack trace:
		  | main.(*monitorImpl).WaitE
		  | 	main/pkg/cmd/roachtest/monitor.go:115
		  | main.(*monitorImpl).Wait
		  | 	main/pkg/cmd/roachtest/monitor.go:123
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.registerAlterPK.func2
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/alterpk.go:100
		  | [...repeated from below...]
		Wraps: (2) monitor failure
		Wraps: (3) attached stack trace
		  -- stack trace:
		  | main.(*monitorImpl).wait.func2
		  | 	main/pkg/cmd/roachtest/monitor.go:171
		  | runtime.goexit
		  | 	GOROOT/src/runtime/asm_amd64.s:1571
		Wraps: (4) monitor task failed
		Wraps: (5) pq: internal error: error executing StatementPhase stage 1 of 1 with 14 MutationType ops: relation "bank" (106): index "crdb_internal_index_4_name_placeholder" key suffix column ID 0 is invalid
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *withstack.withStack (4) *errutil.withPrefix (5) *pq.Error

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!

@cockroach-teamcity
Copy link
Member Author

roachtest.alterpk-bank failed with artifacts on master @ 0dd438d3dc0b42543890455945a7a6b42811def1:

		  | 	main/pkg/cmd/roachtest/monitor.go:105
		  | golang.org/x/sync/errgroup.(*Group).Go.func1
		  | 	golang.org/x/sync/errgroup/external/org_golang_x_sync/errgroup/errgroup.go:74
		  | runtime.goexit
		  | 	GOROOT/src/runtime/asm_amd64.s:1571
		Wraps: (2) output in run_063243.462992858_n4_workload_run_bank
		Wraps: (3) ./workload run bank --duration=1m0s {pgurl:1-3} returned
		  | stderr:
		  | I220813 06:32:44.645239 1 workload/cli/run.go:427  [-] 1  creating load generator...
		  | I220813 06:32:44.653116 1 workload/cli/run.go:458  [-] 2  creating load generator... done (took 7.877139ms)
		  |
		  | stdout:
		  | _elapsed___errors__ops/sec(inst)___ops/sec(cum)__p50(ms)__p95(ms)__p99(ms)_pMax(ms)
		  |     1.0s        0         1859.1         1874.1      3.9      7.1     10.0     44.0 transfer
		  |     2.0s        0         1901.7         1887.9      3.9      6.8      8.9     12.1 transfer
		  |     3.0s        0         1974.0         1916.5      3.9      6.3      8.1     14.2 transfer
		  |     4.0s        0         2078.9         1957.1      3.8      6.3      7.6     12.6 transfer
		  |     5.0s        0         1977.1         1961.1      3.9      6.6      8.9     12.1 transfer
		Wraps: (4) secondary error attachment
		  | UNCLASSIFIED_PROBLEM: context canceled
		  | (1) UNCLASSIFIED_PROBLEM
		  | Wraps: (2) Node 4. Command with error:
		  |   | ``````
		  |   | ./workload run bank --duration=1m0s {pgurl:1-3}
		  |   | ``````
		  | Wraps: (3) context canceled
		  | Error types: (1) errors.Unclassified (2) *hintdetail.withDetail (3) *errors.errorString
		Wraps: (5) context canceled
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *secondary.withSecondaryError (5) *errors.errorString

	monitor.go:127,alterpk.go:100,test_runner.go:896: monitor failure: monitor task failed: pq: internal error: error executing StatementPhase stage 1 of 1 with 14 MutationType ops: relation "bank" (106): index "crdb_internal_index_4_name_placeholder" key suffix column ID 0 is invalid
		(1) attached stack trace
		  -- stack trace:
		  | main.(*monitorImpl).WaitE
		  | 	main/pkg/cmd/roachtest/monitor.go:115
		  | main.(*monitorImpl).Wait
		  | 	main/pkg/cmd/roachtest/monitor.go:123
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.registerAlterPK.func2
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/alterpk.go:100
		  | [...repeated from below...]
		Wraps: (2) monitor failure
		Wraps: (3) attached stack trace
		  -- stack trace:
		  | main.(*monitorImpl).wait.func2
		  | 	main/pkg/cmd/roachtest/monitor.go:171
		  | runtime.goexit
		  | 	GOROOT/src/runtime/asm_amd64.s:1571
		Wraps: (4) monitor task failed
		Wraps: (5) pq: internal error: error executing StatementPhase stage 1 of 1 with 14 MutationType ops: relation "bank" (106): index "crdb_internal_index_4_name_placeholder" key suffix column ID 0 is invalid
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *withstack.withStack (4) *errutil.withPrefix (5) *pq.Error

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!

@cockroach-teamcity
Copy link
Member Author

roachtest.alterpk-bank failed with artifacts on master @ d25cb57ccd9bc643ce9058ebd2057cab36b69ad5:

		  | golang.org/x/sync/errgroup.(*Group).Go.func1
		  | 	golang.org/x/sync/errgroup/external/org_golang_x_sync/errgroup/errgroup.go:74
		  | runtime.goexit
		  | 	GOROOT/src/runtime/asm_amd64.s:1571
		Wraps: (2) output in run_051933.725790420_n4_workload_run_bank
		Wraps: (3) ./workload run bank --duration=1m0s {pgurl:1-3} returned
		  | stderr:
		  | I220814 05:19:34.959171 1 workload/cli/run.go:427  [-] 1  creating load generator...
		  | I220814 05:19:34.967095 1 workload/cli/run.go:458  [-] 2  creating load generator... done (took 7.923234ms)
		  |
		  | stdout:
		  | _elapsed___errors__ops/sec(inst)___ops/sec(cum)__p50(ms)__p95(ms)__p99(ms)_pMax(ms)
		  |     1.0s        0         1953.2         1969.0      3.8      6.6      8.4     39.8 transfer
		  |     2.0s        0         1865.4         1917.2      4.1      7.1      8.9     12.6 transfer
		  |     3.0s        0         1891.1         1908.5      4.1      6.8      8.9     18.9 transfer
		  |     4.0s        0         1877.8         1900.8      4.1      6.8      8.9     15.2 transfer
		  |     5.0s        0         1750.3         1870.7      4.2      7.6     11.0     18.9 transfer
		  |     6.0s        0         1633.6         1831.2      4.7      8.4     12.6     17.8 transfer
		Wraps: (4) secondary error attachment
		  | UNCLASSIFIED_PROBLEM: context canceled
		  | (1) UNCLASSIFIED_PROBLEM
		  | Wraps: (2) Node 4. Command with error:
		  |   | ``````
		  |   | ./workload run bank --duration=1m0s {pgurl:1-3}
		  |   | ``````
		  | Wraps: (3) context canceled
		  | Error types: (1) errors.Unclassified (2) *hintdetail.withDetail (3) *errors.errorString
		Wraps: (5) context canceled
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *secondary.withSecondaryError (5) *errors.errorString

	monitor.go:127,alterpk.go:100,test_runner.go:896: monitor failure: monitor task failed: pq: internal error: error executing StatementPhase stage 1 of 1 with 14 MutationType ops: relation "bank" (106): index "crdb_internal_index_4_name_placeholder" key suffix column ID 0 is invalid
		(1) attached stack trace
		  -- stack trace:
		  | main.(*monitorImpl).WaitE
		  | 	main/pkg/cmd/roachtest/monitor.go:115
		  | main.(*monitorImpl).Wait
		  | 	main/pkg/cmd/roachtest/monitor.go:123
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.registerAlterPK.func2
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/alterpk.go:100
		  | [...repeated from below...]
		Wraps: (2) monitor failure
		Wraps: (3) attached stack trace
		  -- stack trace:
		  | main.(*monitorImpl).wait.func2
		  | 	main/pkg/cmd/roachtest/monitor.go:171
		  | runtime.goexit
		  | 	GOROOT/src/runtime/asm_amd64.s:1571
		Wraps: (4) monitor task failed
		Wraps: (5) pq: internal error: error executing StatementPhase stage 1 of 1 with 14 MutationType ops: relation "bank" (106): index "crdb_internal_index_4_name_placeholder" key suffix column ID 0 is invalid
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *withstack.withStack (4) *errutil.withPrefix (5) *pq.Error

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!

@cockroach-teamcity
Copy link
Member Author

roachtest.alterpk-bank failed with artifacts on master @ 41db784cb97d2749b162020c2c821979094f87b1:

		  | golang.org/x/sync/errgroup.(*Group).Go.func1
		  | 	golang.org/x/sync/errgroup/external/org_golang_x_sync/errgroup/errgroup.go:74
		  | runtime.goexit
		  | 	GOROOT/src/runtime/asm_amd64.s:1571
		Wraps: (2) output in run_051934.183219552_n4_workload_run_bank
		Wraps: (3) ./workload run bank --duration=1m0s {pgurl:1-3} returned
		  | stderr:
		  | I220815 05:19:35.379777 1 workload/cli/run.go:427  [-] 1  creating load generator...
		  | I220815 05:19:35.386112 1 workload/cli/run.go:458  [-] 2  creating load generator... done (took 6.334901ms)
		  |
		  | stdout:
		  | _elapsed___errors__ops/sec(inst)___ops/sec(cum)__p50(ms)__p95(ms)__p99(ms)_pMax(ms)
		  |     1.0s        0         1942.7         1955.2      3.8      6.6      8.4     41.9 transfer
		  |     2.0s        0         1938.6         1946.9      3.9      6.3      7.6     12.1 transfer
		  |     3.0s        0         1945.4         1946.5      3.9      6.3      8.4     16.3 transfer
		  |     4.0s        0         1952.4         1947.9      3.9      6.3      7.6     11.5 transfer
		  |     5.0s        0         1888.4         1936.0      4.1      6.8      9.4     18.9 transfer
		  |     6.0s        0         1686.9         1894.5      4.5      7.9     11.5     17.8 transfer
		Wraps: (4) secondary error attachment
		  | UNCLASSIFIED_PROBLEM: context canceled
		  | (1) UNCLASSIFIED_PROBLEM
		  | Wraps: (2) Node 4. Command with error:
		  |   | ``````
		  |   | ./workload run bank --duration=1m0s {pgurl:1-3}
		  |   | ``````
		  | Wraps: (3) context canceled
		  | Error types: (1) errors.Unclassified (2) *hintdetail.withDetail (3) *errors.errorString
		Wraps: (5) context canceled
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *secondary.withSecondaryError (5) *errors.errorString

	monitor.go:127,alterpk.go:100,test_runner.go:896: monitor failure: monitor task failed: pq: internal error: error executing StatementPhase stage 1 of 1 with 14 MutationType ops: relation "bank" (106): index "crdb_internal_index_4_name_placeholder" key suffix column ID 0 is invalid
		(1) attached stack trace
		  -- stack trace:
		  | main.(*monitorImpl).WaitE
		  | 	main/pkg/cmd/roachtest/monitor.go:115
		  | main.(*monitorImpl).Wait
		  | 	main/pkg/cmd/roachtest/monitor.go:123
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.registerAlterPK.func2
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/alterpk.go:100
		  | [...repeated from below...]
		Wraps: (2) monitor failure
		Wraps: (3) attached stack trace
		  -- stack trace:
		  | main.(*monitorImpl).wait.func2
		  | 	main/pkg/cmd/roachtest/monitor.go:171
		  | runtime.goexit
		  | 	GOROOT/src/runtime/asm_amd64.s:1571
		Wraps: (4) monitor task failed
		Wraps: (5) pq: internal error: error executing StatementPhase stage 1 of 1 with 14 MutationType ops: relation "bank" (106): index "crdb_internal_index_4_name_placeholder" key suffix column ID 0 is invalid
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *withstack.withStack (4) *errutil.withPrefix (5) *pq.Error

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!

@Xiang-Gu Xiang-Gu mentioned this issue Aug 16, 2022
Merged
@cockroach-teamcity
Copy link
Member Author

roachtest.alterpk-bank failed with artifacts on master @ f4042d47fa8062a612c38d4696eb6bee9cee7c21:

		  | 	main/pkg/cmd/roachtest/monitor.go:105
		  | golang.org/x/sync/errgroup.(*Group).Go.func1
		  | 	golang.org/x/sync/errgroup/external/org_golang_x_sync/errgroup/errgroup.go:74
		  | runtime.goexit
		  | 	GOROOT/src/runtime/asm_amd64.s:1571
		Wraps: (2) output in run_052001.728964831_n4_workload_run_bank
		Wraps: (3) ./workload run bank --duration=1m0s {pgurl:1-3} returned
		  | stderr:
		  | I220816 05:20:02.945317 1 workload/cli/run.go:427  [-] 1  creating load generator...
		  | I220816 05:20:02.951472 1 workload/cli/run.go:458  [-] 2  creating load generator... done (took 6.154398ms)
		  |
		  | stdout:
		  | _elapsed___errors__ops/sec(inst)___ops/sec(cum)__p50(ms)__p95(ms)__p99(ms)_pMax(ms)
		  |     1.0s        0         2018.4         2031.1      3.8      6.0     10.5     46.1 transfer
		  |     2.0s        0         2072.7         2051.9      3.8      6.3      8.4     13.6 transfer
		  |     3.0s        0         2077.1         2060.3      3.8      5.8      9.4     15.2 transfer
		  |     4.0s        0         2018.9         2049.9      3.8      6.3      9.4     18.9 transfer
		  |     5.0s        0         2026.5         2045.2      3.8      6.3      7.9     13.6 transfer
		Wraps: (4) secondary error attachment
		  | UNCLASSIFIED_PROBLEM: context canceled
		  | (1) UNCLASSIFIED_PROBLEM
		  | Wraps: (2) Node 4. Command with error:
		  |   | ``````
		  |   | ./workload run bank --duration=1m0s {pgurl:1-3}
		  |   | ``````
		  | Wraps: (3) context canceled
		  | Error types: (1) errors.Unclassified (2) *hintdetail.withDetail (3) *errors.errorString
		Wraps: (5) context canceled
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *cluster.WithCommandDetails (4) *secondary.withSecondaryError (5) *errors.errorString

	monitor.go:127,alterpk.go:100,test_runner.go:896: monitor failure: monitor task failed: pq: internal error: error executing StatementPhase stage 1 of 1 with 14 MutationType ops: relation "bank" (106): index "crdb_internal_index_4_name_placeholder" key suffix column ID 0 is invalid
		(1) attached stack trace
		  -- stack trace:
		  | main.(*monitorImpl).WaitE
		  | 	main/pkg/cmd/roachtest/monitor.go:115
		  | main.(*monitorImpl).Wait
		  | 	main/pkg/cmd/roachtest/monitor.go:123
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.registerAlterPK.func2
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/alterpk.go:100
		  | [...repeated from below...]
		Wraps: (2) monitor failure
		Wraps: (3) attached stack trace
		  -- stack trace:
		  | main.(*monitorImpl).wait.func2
		  | 	main/pkg/cmd/roachtest/monitor.go:171
		  | runtime.goexit
		  | 	GOROOT/src/runtime/asm_amd64.s:1571
		Wraps: (4) monitor task failed
		Wraps: (5) pq: internal error: error executing StatementPhase stage 1 of 1 with 14 MutationType ops: relation "bank" (106): index "crdb_internal_index_4_name_placeholder" key suffix column ID 0 is invalid
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *withstack.withStack (4) *errutil.withPrefix (5) *pq.Error

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!

craig bot pushed a commit that referenced this issue Aug 16, 2022
@cucaroach @rickystewart
@maryliag @Xiang-Gu
Merge #85462 #86043 #86169 #86192
aed288d 
85462: sql: unit test, benchmark and logictests for COPY r=cucaroach a=cucaroach

As a new/half supported feature COPY FROM STDIN support is under tested.
Add tests and a simple benchmark to pave the way for enhancements and
optimizations.

Assists: #81731

Release note: None

Release justification: non-production code change


86043: release: build linux-arm binary for release r=rail,jlinder a=rickystewart

Release note (build change): build *experimental* Linux ARM64 binary
Release justification: build *experimental* Linux ARM64 binary for release

86169: api: update database parameter name r=maryliag a=maryliag

Previously, we were calling the database parameter
in `SqlExecutionRequest` as `database_name`, instead
of the correct `database`.
This commit updates the parameter name to the
correct one.

Release note (bug fix): Use proper parameter name for database
on SQL api

Release justification: bug fix

86192: sql/schemachanger: fixed a ordial number bug in ALTER PRIMARY KEY r=Xiang-Gu a=Xiang-Gu

Previously, we had a bug in ALTER PRIMARY KEY such that when the new
primary key is a superset of the old primary key, we incorrectly gave
ordinal numbers to IndexColumn elements. This PR fixed it and added
a few logic tests for cases when the new primary key intersects with
the old primary key.

Fixes: #85877

Release note: None

Release justification: fixed a bug that was revealed in roachtest
failure (issue #85877)

Co-authored-by: Tommy Reilly <[email protected]>
Co-authored-by: Ricky Stewart <[email protected]>
Co-authored-by: Marylia Gutierrez <[email protected]>
Co-authored-by: Xiang Gu <[email protected]>
@craig craig bot closed this as completed in 19fb54a Aug 16, 2022
@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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@Xiang-Gu Xiang-Gu

Labels
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. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
None yet
Milestone
22.2
Development

Successfully merging a pull request may close this issue.

sql/schemachanger: fixed a ordial number bug in ALTER PRIMARY KEY Xiang-Gu/cockroach
2 participants
@cockroach-teamcity @Xiang-Gu