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: tpccbench/nodes=9/cpu=4/chaos/partition failed #44293

Closed
cockroach-teamcity opened this issue Jan 23, 2020 · 0 comments · Fixed by #44452
Closed

roachtest: tpccbench/nodes=9/cpu=4/chaos/partition failed #44293

cockroach-teamcity opened this issue Jan 23, 2020 · 0 comments · Fixed by #44452
Assignees
@andreimatei
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.
Milestone
20.1

Comments

@cockroach-teamcity
Copy link
Member

(roachtest).tpccbench/nodes=9/cpu=4/chaos/partition failed on release-2.1@0f056a5fbfc2b8774f8567a97432900b13a408e6:

		  - error with attached stack trace:
		    main.(*monitor).wait.func2
		    	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/cluster.go:2245
		    runtime.goexit
		    	/usr/local/go/src/runtime/asm_amd64.s:1357
		  - monitor task failed:
		  - error with attached stack trace:
		    main.execCmd
		    	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/cluster.go:399
		    main.(*cluster).RunL
		    	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/cluster.go:1855
		    main.(*cluster).RunE
		    	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/cluster.go:1847
		    main.loadTPCCBench
		    	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tpcc.go:628
		    main.runTPCCBench.func1
		    	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tpcc.go:718
		    main.(*monitor).Go.func1
		    	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/cluster.go:2180
		    github.com/cockroachdb/cockroach/vendor/golang.org/x/sync/errgroup.(*Group).Go.func1
		    	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/vendor/golang.org/x/sync/errgroup/errgroup.go:57
		    runtime.goexit
		    	/usr/local/go/src/runtime/asm_amd64.s:1357
		  - error with embedded safe details: %s returned:
		    stderr:
		    %s
		    stdout:
		    %s
		    -- arg 1: <string>
		    -- arg 2: <string>
		    -- arg 3: <string>
		  - /home/agent/work/.go/src/github.com/cockroachdb/cockroach/bin/roachprod run teamcity-1705485-1579761996-70-n10cpu4:10 -- ./workload fixtures load tpcc --warehouses=2000 --scatter --checks=false --partitions=3 {pgurl:1} returned:
		    stderr:
		    
		    stdout:
		    I200123 11:09:06.752471 1 ccl/workloadccl/cliccl/fixtures.go:279  starting restore of 9 tables
		    W200123 11:09:06.752954 1 ccl/workloadccl/fixture.go:461  error retrieving automatic stats cluster setting: pq: unknown setting: "sql.stats.automatic_collection.enabled"
		    I200123 11:09:08.264662 80 ccl/workloadccl/fixture.go:547  loaded 7.8 MiB table item in 1.511488336s (100000 rows, 0 index entries, 5.1 MiB)
		    I200123 11:11:27.165485 78 ccl/workloadccl/fixture.go:547  loaded 2.7 GiB table order in 2m20.412286271s (60000000 rows, 60000000 index entries, 19 MiB)
		    I200123 11:11:28.534830 75 ccl/workloadccl/fixture.go:547  loaded 2.0 MiB table district in 2m21.781287504s (20000 rows, 0 index entries, 14 KiB)
		    I200123 11:15:23.180034 74 ccl/workloadccl/fixture.go:547  loaded 106 KiB table warehouse in 6m16.426483332s (2000 rows, 0 index entries, 288 B)
		    I200123 11:17:11.816113 79 ccl/workloadccl/fixture.go:547  loaded 254 MiB table new_order in 8m5.062600632s (18000000 rows, 0 index entries, 537 KiB)
		    I200123 11:26:13.322374 77 ccl/workloadccl/fixture.go:547  loaded 8.5 GiB table history in 17m6.569191455s (60000000 rows, 120000000 index entries, 8.5 MiB)
		    I200123 11:35:34.896821 76 ccl/workloadccl/fixture.go:547  loaded 34 GiB table customer in 26m28.143130226s (60000000 rows, 60000000 index entries, 22 MiB)
		    I200123 11:43:53.747284 81 ccl/workloadccl/fixture.go:547  loaded 63 GiB table stock in 34m46.993933428s (200000000 rows, 200000000 index entries, 31 MiB)
		    I200123 11:52:41.174227 82 ccl/workloadccl/fixture.go:547  loaded 46 GiB table order_line in 43m34.42112064s (600008449 rows, 600008449 index entries, 18 MiB)
		    I200123 11:52:41.464879 1 ccl/workloadccl/cliccl/fixtures.go:286  restored 155 GiB bytes in 9 tables (took 43m34.712244556s, 60.57 MiB/s)
		    Error: Could not postload: could not partition tables: Couldn't exec "\n\t\t\tALTER INDEX item@replicated_idx_0\n\t\t\tCONFIGURE ZONE USING num_replicas = COPY FROM PARENT, constraints = '{\"+rack=0\":1}', lease_preferences = '[[+rack=0]]'": pq: syntax error at or near "from"
		    Error:  exit status 1:
		  - exit status 1
More

Artifacts: /tpccbench/nodes=9/cpu=4/chaos/partition
Related:

See this test on roachdash
powered by pkg/cmd/internal/issues
@cockroach-teamcity cockroach-teamcity added branch-release-2.1 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 Jan 23, 2020
@cockroach-teamcity cockroach-teamcity added this to the 20.1 milestone Jan 23, 2020
This was referenced Jan 24, 2020
Closed
Closed
@nvanbenschoten nvanbenschoten mentioned this issue Jan 28, 2020
Merged
craig bot pushed a commit that referenced this issue Jan 28, 2020
@yuzefovich @nvanbenschoten
Merge #44426 #44452
1917a12 
44426: colexec: fix set up of merge joiner benchmark r=yuzefovich a=yuzefovich

Previously, the setup of the merge joiner benchmark was incomplete - for
example, the "distincter" was not instantiated. We recently ran into
a problem of nil "distincter", probably, because of batch size
randomization. The issue is now fixed.

Fixes: #44413.

Release note: None

44452: roachtest: set MinVersion on tpccbench/nodes=9/cpu=4/chaos/partition r=nvanbenschoten a=nvanbenschoten

Closes #44293.
Closes #44259.

`COPY FROM PARENT` wasn't supported until v19.1.

Co-authored-by: Yahor Yuzefovich <[email protected]>
Co-authored-by: Nathan VanBenschoten <[email protected]>
@craig craig bot closed this as completed in 1648b6c Jan 28, 2020
@craig craig bot closed this as completed in #44452 Jan 28, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@andreimatei andreimatei

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
Milestone
20.1
Development

Successfully merging a pull request may close this issue.

roachtest: set MinVersion on tpccbench/nodes=9/cpu=4/chaos/partition nvanbenschoten/cockroach
2 participants
@andreimatei @cockroach-teamcity