roachtest: tpchbench/tpch/nodes=3/cpu=4/sf=1 failed

[cockroach-teamcity]

(roachtest).tpchbench/tpch/nodes=3/cpu=4/sf=1 failed on master@b7d098425ff43372784ed7c34ee25e5e5fc1a58b:

		    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-1829260-1585208956-13-n4cpu4:4 -- ./workload run querybench --db=tpch --concurrency=1 --query-file=tpch --num-runs=3 --max-ops=72 {pgurl:1-3} --histograms=perf/stats.json --histograms-max-latency=8m20s returned:
		    stderr:
		    Error: failed to prepare query "SELECT s_suppkey, s_name, s_address, s_phone, total_revenue FROM supplier, revenue0 WHERE s_suppkey = supplier_no AND total_revenue = ( SELECT max(total_revenue) FROM revenue0) ORDER BY s_suppkey": pq: relation "revenue0" does not exist
		    Error: DEAD_ROACH_PROBLEM:
		      - error with user detail: Node 4. Command with error:
		        ```
		        ./workload run querybench --db=tpch --concurrency=1 --query-file=tpch --num-runs=3 --max-ops=72 {pgurl:1-3} --histograms=perf/stats.json --histograms-max-latency=8m20s
		        ```
		      - exit status 1
		    
		    stdout::
		  - exit status 30

	cluster.go:2368,tpchbench.go:120,tpchbench.go:245,test_runner.go:753: error with attached stack trace:
		    main.(*monitor).WaitE
		    	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/cluster.go:2356
		    main.(*monitor).Wait
		    	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/cluster.go:2364
		    main.runTPCHBench
		    	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tpchbench.go:120
		    main.registerTPCHBenchSpec.func1
		    	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tpchbench.go:245
		    main.(*testRunner).runTest.func2
		    	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/test_runner.go:753
		    runtime.goexit
		    	/usr/local/go/src/runtime/asm_amd64.s:1357
		  - monitor failure:
		  - error with attached stack trace:
		    main.(*monitor).wait.func2
		    	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/cluster.go:2412
		    runtime.goexit
		    	/usr/local/go/src/runtime/asm_amd64.s:1357
		  - monitor task failed:
		  - error with attached stack trace:
		    main.init
		    	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/cluster.go:2309
		    runtime.doInit
		    	/usr/local/go/src/runtime/proc.go:5222
		    runtime.main
		    	/usr/local/go/src/runtime/proc.go:190
		    runtime.goexit
		    	/usr/local/go/src/runtime/asm_amd64.s:1357
		  - Goexit() was called

More

Artifacts: /tpchbench/tpch/nodes=3/cpu=4/sf=1
Related:

• roachtest: tpchbench/tpch/nodes=3/cpu=4/sf=1 failed #46547 roachtest: tpchbench/tpch/nodes=3/cpu=4/sf=1 failed C-test-failure O-roachtest O-robot branch-release-19.2 release-blocker

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

[yuzefovich]

Dup of #46547.

[cockroach-teamcity]

(roachtest).tpchbench/tpch/nodes=3/cpu=4/sf=1 failed on master@c0855e9fcf979cca1094d7edeeacb9882ddc9f96:

		    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-1832621-1585293773-13-n4cpu4:4 -- ./workload run querybench --db=tpch --concurrency=1 --query-file=tpch --num-runs=3 --max-ops=72 {pgurl:1-3} --histograms=perf/stats.json --histograms-max-latency=8m20s returned:
		    stderr:
		    Error: failed to prepare query "SELECT s_suppkey, s_name, s_address, s_phone, total_revenue FROM supplier, revenue0 WHERE s_suppkey = supplier_no AND total_revenue = ( SELECT max(total_revenue) FROM revenue0) ORDER BY s_suppkey": pq: relation "revenue0" does not exist
		    Error: DEAD_ROACH_PROBLEM:
		      - error with user detail: Node 4. Command with error:
		        ```
		        ./workload run querybench --db=tpch --concurrency=1 --query-file=tpch --num-runs=3 --max-ops=72 {pgurl:1-3} --histograms=perf/stats.json --histograms-max-latency=8m20s
		        ```
		      - exit status 1
		    
		    stdout::
		  - exit status 30

	cluster.go:2368,tpchbench.go:120,tpchbench.go:245,test_runner.go:753: error with attached stack trace:
		    main.(*monitor).WaitE
		    	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/cluster.go:2356
		    main.(*monitor).Wait
		    	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/cluster.go:2364
		    main.runTPCHBench
		    	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tpchbench.go:120
		    main.registerTPCHBenchSpec.func1
		    	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tpchbench.go:245
		    main.(*testRunner).runTest.func2
		    	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/test_runner.go:753
		    runtime.goexit
		    	/usr/local/go/src/runtime/asm_amd64.s:1357
		  - monitor failure:
		  - error with attached stack trace:
		    main.(*monitor).wait.func2
		    	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/cluster.go:2412
		    runtime.goexit
		    	/usr/local/go/src/runtime/asm_amd64.s:1357
		  - monitor task failed:
		  - error with attached stack trace:
		    main.init
		    	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/cluster.go:2309
		    runtime.doInit
		    	/usr/local/go/src/runtime/proc.go:5222
		    runtime.main
		    	/usr/local/go/src/runtime/proc.go:190
		    runtime.goexit
		    	/usr/local/go/src/runtime/asm_amd64.s:1357
		  - Goexit() was called

More

Artifacts: /tpchbench/tpch/nodes=3/cpu=4/sf=1
Related:

• roachtest: tpchbench/tpch/nodes=3/cpu=4/sf=1 failed #46547 roachtest: tpchbench/tpch/nodes=3/cpu=4/sf=1 failed C-test-failure O-roachtest O-robot branch-release-19.2 release-blocker

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