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: costfuzz/seed-multi-region failed #90683

Closed
cockroach-teamcity opened this issue Oct 26, 2022 · 42 comments
Closed

roachtest: costfuzz/seed-multi-region failed #90683

cockroach-teamcity opened this issue Oct 26, 2022 · 42 comments
Assignees
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. T-sql-queries SQL Queries Team X-duplicate Closed as a duplicate of another issue.
Milestone

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Oct 26, 2022

roachtest.costfuzz/seed-multi-region failed with artifacts on master @ 1b1c8da55be48c174b7b370b305f42622546209f:

test artifacts and logs in: /artifacts/costfuzz/seed-multi-region/run_1
(test_impl.go:314).Errorf: test timed out (1h0m0s)

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_fs=ext4 , ROACHTEST_localSSD=true , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-20887

@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 Oct 26, 2022
@cockroach-teamcity cockroach-teamcity added this to the 22.2 milestone Oct 26, 2022
@blathers-crl blathers-crl bot added the T-sql-queries SQL Queries Team label Oct 26, 2022
@DrewKimball
Copy link
Collaborator

Seems related to #90504. Seeing these in the node 1 kv-distribution log:

I221026 09:13:18.893224 7338 13@kv/kvserver/replicate_queue.go:1613 ⋮ [n1,replicate,s1,r10/1:‹/Table/{6-8}›] 885  no suitable rebalance target for voters
I221026 09:13:18.893262 7338 13@kv/kvserver/replicate_queue.go:1633 ⋮ [n1,replicate,s1,r10/1:‹/Table/{6-8}›] 886  no suitable rebalance target for non-voters
I221026 09:13:18.893322 7338 13@kv/kvserver/replicate_queue.go:1862 ⋮ [n1,replicate,s1,r10/1:‹/Table/{6-8}›] 887  transferring lease to s3
I221026 09:13:18.959132 7350 13@kv/kvserver/replicate_queue.go:1613 ⋮ [n1,replicate,s1,r22/1:‹/Table/2{1-2}›] 888  no suitable rebalance target for voters
I221026 09:13:18.959169 7350 13@kv/kvserver/replicate_queue.go:1633 ⋮ [n1,replicate,s1,r22/1:‹/Table/2{1-2}›] 889  no suitable rebalance target for non-voters
I221026 09:13:18.959461 7351 13@kv/kvserver/replicate_queue.go:1613 ⋮ [n1,replicate,s1,r9/1:‹/Table/{5-6}›] 890  no suitable rebalance target for voters
I221026 09:13:18.959506 7351 13@kv/kvserver/replicate_queue.go:1633 ⋮ [n1,replicate,s1,r9/1:‹/Table/{5-6}›] 891  no suitable rebalance target for non-voters
I221026 09:13:18.959774 7352 13@kv/kvserver/replicate_queue.go:1613 ⋮ [n1,replicate,s1,r34/1:‹/Table/3{3-4}›] 892  no suitable rebalance target for voters
I221026 09:13:18.959801 7352 13@kv/kvserver/replicate_queue.go:1633 ⋮ [n1,replicate,s1,r34/1:‹/Table/3{3-4}›] 893  no suitable rebalance target for non-voters
I221026 09:13:18.960050 7353 13@kv/kvserver/replicate_queue.go:1613 ⋮ [n1,replicate,s1,r14/1:‹/Table/1{3-4}›] 894  no suitable rebalance target for voters
I221026 09:13:18.960076 7353 13@kv/kvserver/replicate_queue.go:1633 ⋮ [n1,replicate,s1,r14/1:‹/Table/1{3-4}›] 895  no suitable rebalance target for non-voters
I221026 09:13:18.960313 7354 13@kv/kvserver/replicate_queue.go:1613 ⋮ [n1,replicate,s1,r11/1:‹/Table/{8-11}›] 896  no suitable rebalance target for voters
I221026 09:13:18.960339 7354 13@kv/kvserver/replicate_queue.go:1633 ⋮ [n1,replicate,s1,r11/1:‹/Table/{8-11}›] 897  no suitable rebalance target for non-voters
I221026 09:13:18.960558 7355 13@kv/kvserver/replicate_queue.go:1613 ⋮ [n1,replicate,s1,r26/1:‹/Table/2{5-6}›] 898  no suitable rebalance target for voters
I221026 09:13:18.960583 7355 13@kv/kvserver/replicate_queue.go:1633 ⋮ [n1,replicate,s1,r26/1:‹/Table/2{5-6}›] 899  no suitable rebalance target for non-voters
I221026 09:13:18.960813 7356 13@kv/kvserver/replicate_queue.go:1613 ⋮ [n1,replicate,s1,r44/1:‹/Table/4{3-4}›] 900  no suitable rebalance target for voters

And the setup for the test has these lines:

ALTER DATABASE defaultdb SET PRIMARY REGION "europe-west2";
ALTER TABLE seed_mr_table SET LOCALITY REGIONAL BY ROW;

@cockroach-teamcity
Copy link
Member Author

roachtest.costfuzz/seed-multi-region failed with artifacts on master @ d39558f51ded0411e90ef1d8aa05106930b36667:

test artifacts and logs in: /artifacts/costfuzz/seed-multi-region/run_1
(test_impl.go:314).Errorf: test timed out (1h0m0s)

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_fs=ext4 , ROACHTEST_localSSD=true , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@DrewKimball
Copy link
Collaborator

Most recent failure looks like the same issue.

@cockroach-teamcity
Copy link
Member Author

roachtest.costfuzz/seed-multi-region failed with artifacts on master @ 0c1c3e7777b28a30ebe41428fb173f0156e8968c:

test artifacts and logs in: /artifacts/costfuzz/seed-multi-region/run_1
(test_impl.go:314).Errorf: test timed out (1h0m0s)

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_fs=ext4 , ROACHTEST_localSSD=true , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@DrewKimball
Copy link
Collaborator

ditto

@cockroach-teamcity
Copy link
Member Author

roachtest.costfuzz/seed-multi-region failed with artifacts on master @ 0c1c3e7777b28a30ebe41428fb173f0156e8968c:

test artifacts and logs in: /artifacts/costfuzz/seed-multi-region/run_1
(test_impl.go:314).Errorf: test timed out (1h0m0s)

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_fs=ext4 , ROACHTEST_localSSD=true , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@DrewKimball
Copy link
Collaborator

Ditto. This one has us-west1 instead of europe-west2 as the primary region.

@cockroach-teamcity
Copy link
Member Author

roachtest.costfuzz/seed-multi-region failed with artifacts on master @ 2d926e68000df659f282d4e4477329867b9a3323:

test artifacts and logs in: /artifacts/costfuzz/seed-multi-region/run_1
(test_impl.go:314).Errorf: test timed out (1h0m0s)

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_fs=ext4 , ROACHTEST_localSSD=true , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@rytaft
Copy link
Collaborator

rytaft commented Oct 31, 2022

Same issue. Removing release-blocker label.

@rytaft rytaft removed the release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. label Oct 31, 2022
@cucaroach
Copy link
Contributor

I looked at the last OOM. The memory profile shows 3GB of GC heap, that's nominal, this is interesting:

[ 2767.747961] Memory cgroup stats for /system.slice/cockroach.service:
[ 2767.747970] anon 14911578112
               anon_thp 12138315776
...
               active_anon 14911586304

So we're using 14.9 GB of memory and 12.1 GB is anonymous huge pages. I don't know about the go allocator but in the past jemalloc didn't jive well with THP. I wonder if we should try disabling it:

❯ gdb cockroach
GNU gdb (Ubuntu 9.2-0ubuntu1~20.04.1) 9.2
Copyright (C) 2020 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.
Type "show copying" and "show warranty" for details.
This GDB was configured as "x86_64-linux-gnu".
Type "show configuration" for configuration details.
For bug reporting instructions, please see:
<http://www.gnu.org/software/gdb/bugs/>.
Find the GDB manual and other documentation resources online at:
    <http://www.gnu.org/software/gdb/documentation/>.

For help, type "help".
Type "apropos word" to search for commands related to "word"...
Reading symbols from cockroach...
p config_warning: Missing auto-load script at offset 0 in section .debug_gdb_scripts
of file /home/treilly/go/src/github.com/cockroachdb/cockroach/cockroach.
Use `info auto-load python-scripts [REGEXP]' to list them.
(gdb) p config_thp
$1 = true

There's an option to dynamically disable it at runtime and we could disable it at the OS level too. I'll try running it with THP off, how frequently is this test failing? Its a nightly right?

@cockroach-teamcity
Copy link
Member Author

roachtest.costfuzz/seed-multi-region failed with artifacts on master @ bec24eb9cfe2cc48c45772f1e88d387fe37944c9:

test artifacts and logs in: /artifacts/costfuzz/seed-multi-region/run_1
(test_impl.go:314).Errorf: test timed out (1h0m0s)

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_fs=ext4 , ROACHTEST_localSSD=true , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@DrewKimball
Copy link
Collaborator

Most recent failure is the same as the others.

@cockroach-teamcity
Copy link
Member Author

roachtest.costfuzz/seed-multi-region failed with artifacts on master @ 9c9d55d707ad9a768027e9b7a3775c7c7cde8de7:

test artifacts and logs in: /artifacts/costfuzz/seed-multi-region/run_1
(test_impl.go:314).Errorf: test timed out (1h0m0s)

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_fs=ext4 , ROACHTEST_localSSD=true , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@cucaroach
Copy link
Contributor

This last one had a query here at the end:


I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹goroutine 7100 [runnable]:›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/golang/snappy.encodeBlock({0xc1b4ab1dc2, 0x9f7298, 0x9f7298}, {0xc1b39e2000, 0x10000, 0x10cc000})›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	external/com_github_golang_snappy/encode_amd64.s:265 +0x380›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/golang/snappy.Encode({0xc1b4aae000?, 0x88?, 0x88?}, {0xc1b3992000?, 0x2e4?, 0xc0027b2ca8?})›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/golang/snappy/external/com_github_golang_snappy/encode.go:39 +0x245›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql/colcontainer.(*diskQueueWriter).compressAndFlush(0xc001982900)›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/colcontainer/diskqueue.go:103 +0x79›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql/colcontainer.(*diskQueue).writeFooterAndFlush(0xc002fcfcc0, {0x67e57e8, 0xc007b064b0})›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/colcontainer/diskqueue.go:532 +0xd2›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql/colcontainer.(*diskQueue).Enqueue(0xc002fcfcc0, {0x67e57e8, 0xc007b064b0}, {0x6837ee0, 0xc001982780})›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/colcontainer/diskqueue.go:615 +0x359›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql/colcontainer.(*PartitionedDiskQueue).Enqueue(0xc00160f8c0, {0x67e57e8, 0xc007b064b0}, 0x2e6, {0x6837ee0, 0xc001982780})›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/colcontainer/partitionedqueue.go:261 +0x409›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk.(*externalSorter).enqueue(0xc003498400, {0x6837ee0, 0xc001982780})›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk/external_sort.go:529 +0x106›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk.(*externalSorter).Next(0xc003498400)›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk/external_sort.go:423 +0x6d5›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk.(*diskSpillerBase).Next(0xc002f02750)›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk/disk_spiller.go:211 +0x142›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecbase.(*fnOp).Next(0xc002855ec0)›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecbase/fn_op.go:32 +0x29›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecbase.(*distinctBytesOp).Next(0xc0083ec960)›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/bazel-out/k8-opt/bin/pkg/sql/colexec/colexecbase/distinct.eg.go:473 +0x3e›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec.(*orderedAggregator).Next(0xc003f5b000)›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/ordered_aggregator.go:207 +0x139›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk.(*hashBasedPartitioner).Next(0xc006bda380)›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk/hash_based_partitioner.go:613 +0x4a6›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk.(*diskSpillerBase).Next(0x2100a25?)›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk/disk_spiller.go:193 +0x16f›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecbase.(*simpleProjectOp).Next(0xc0083ec9c0)›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecbase/simple_project.go:124 +0x3f›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql/colflow.(*batchInfoCollector).next(0xc0072f4780)›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/colflow/stats.go:116 +0x29›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError(0xc002855f80?)›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:92 +0x62›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql/colflow.(*batchInfoCollector).Next(0xc0072f4780)›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/colflow/stats.go:124 +0x52›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql/colflow.(*BatchFlowCoordinator).nextAdapter(0xc007b6cf20)›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/colflow/flow_coordinator.go:252 +0x2a›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError(0xc005083880?)›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:92 +0x62›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql/colflow.(*BatchFlowCoordinator).next(...)›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/colflow/flow_coordinator.go:256›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql/colflow.(*BatchFlowCoordinator).Run(0xc007b6cf20, {0x67e5740?, 0xc002855700?})›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/colflow/flow_coordinator.go:299 +0x308›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql/colflow.(*vectorizedFlow).Run(0xc001a0fa90, {0x67e5740, 0xc002855700})›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/colflow/vectorized_flow.go:320 +0x1d8›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).Run(0xc00293d040, {0x67e57e8, 0xc007262a50}, 0xc001db5a40, 0xc007e76c60, 0xc0009cbd00, 0xc005083880, 0xc002ef3b40, 0x0)›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:688 +0xa78›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).PlanAndRun(0xc007262b70?, {0x67e57e8, 0xc007262a50}, 0x0?, 0xc001db5a40, 0x0?, {{0x67e7ca8?, 0xc005c32dc0?}, 0x0?}, 0xc005083880)›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:1555 +0x1f9›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).PlanAndRunAll(0xc001db5a40?, {0x67e57e8, 0xc007262a50}, 0xc002ef37e8?, 0x1?, 0xc002ef37e8, 0xc005083880, 0x3?)›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:1307 +0x206›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execWithDistSQLEngine(0xc002ef3300, {0x67e57e8, 0xc007262a50}, 0xc002ef37e8, 0xc007262a50?, {0x7f27bc4eaaf0?, 0xc008843b08}, 0x0?, 0xc007e76da8)›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1576 +0x4c8›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).dispatchToExecutionEngine(0xc002ef3300, {0x67e57e8, 0xc005e45ce0}, 0xc002ef37e8, {0x7f27bc4eaaf0, 0xc008843b08})›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1216 +0xb99›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmtInOpenState(0xc002ef3300, {0x67e57e8?, 0xc005e45b60?}, {{0x680e540, 0xc0018cd590}, {0x0, 0x0, 0x0}, {0xc004c583d4, 0x135}, ...}, ...)›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:725 +0x2534›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt.func1({0x67e57e8?, 0xc005e45b60?})›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:129 +0xbc›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execWithProfiling(0x67e57e8?, {0x67e57e8?, 0xc005e45b60?}, {0x680e540?, 0xc0018cd590?}, 0x0?, 0x958e9c0?)›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:2421 +0x330›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt(0xc002ef3300, {0x67e57e8, 0xc005e45b60}, {{0x680e540, 0xc0018cd590}, {0x0, 0x0, 0x0}, {0xc004c583d4, 0x135}, ...}, ...)›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:128 +0x4da›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd.func1(0xc008a59ac0, 0xc002ef3300, 0xc008a597d8, 0xc008a59890, 0xc008a598d0, 0xc0027b58b0, 0xc0027b58a0, 0xc0027b58c0)›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1927 +0x305›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd(0xc002ef3300)›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1932 +0x1127›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).run(0xc002ef3300, {0x67e5740, 0xc0071dbe00}, 0x4110f72000000000?, 0xc00c7d3dd8?, 0xc00d268dd0?)›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1852 +0x20b›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql.(*Server).ServeConn(0xc0029c2500?, {0x67e5740?, 0xc0071dbe00?}, {0xc002b18000?}, 0x3?, 0xc0083bd7d0?)›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:830 +0xe6›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).processCommandsAsync.func1()›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:728 +0x40d›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹created by github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).processCommandsAsync›
I221103 10:19:05.690831 9 util/log/clog.go:409 ⋮ [-] 727 +‹	github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:639 +0x22e›

Maybe costfuzz just caused a query to run that took 30 minutes to run, oh I see we have a 1m statement timeout set, so this must be a case where we are missing a cancel checker.

@cucaroach
Copy link
Contributor

cucaroach commented Nov 3, 2022

The 11/2 failure (2nd to last) had a similar query running.


I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹goroutine 7782 [runnable]:›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/apd/v3.(*BigInt).SetString(0xc01d769868, {0xc02efa25a0, 0x1d}, 0xa?)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/apd/v3/external/com_github_cockroachdb_apd_v3/bigint.go:888 +0x297›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/apd/v3.(*Decimal).setString(0xc01d769860, 0x955a0a0, {0xc02efa2580, 0x1e})›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/apd/v3/external/com_github_cockroachdb_apd_v3/decimal.go:159 +0x655›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/apd/v3.(*Context).SetString(0x955a0a0, 0xc008f9124a?, {0xc02efa2580?, 0x80?})›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/apd/v3/external/com_github_cockroachdb_apd_v3/decimal.go:191 +0x35›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/apd/v3.(*Decimal).SetString(...)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/apd/v3/external/com_github_cockroachdb_apd_v3/decimal.go:176›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/apd/v3.(*Decimal).UnmarshalText(0xc000ff8560?, {0xc008f9124a?, 0xc006458450?, 0x0?})›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/apd/v3/external/com_github_cockroachdb_apd_v3/decimal.go:791 +0x3c›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/col/colserde.(*ArrowBatchConverter).ArrowToBatch(0xc011506c00?, {0xc001769e60, 0xc008f801e8?, 0x200?}, 0x52d8a?, {0x68360e0, 0xc018c82ae0})›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/col/colserde/arrowbatchconverter.go:351 +0x1516›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/col/colserde.(*FileDeserializer).GetBatch(0xc001769d40, 0x67e39e8?, {0x68360e0, 0xc018c82ae0})›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/col/colserde/file.go:250 +0x12e›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colcontainer.(*diskQueue).Dequeue(0xc00a2ce140, {0x67e39e8, 0xc00f3817d0}, {0x68360e0, 0xc018c82ae0?})›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colcontainer/diskqueue.go:777 +0x249›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecutils.(*SpillingQueue).Dequeue(0xc003b45e00, {0x67e39e8?, 0xc00f3817d0?})›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecutils/spilling_queue.go:362 +0x1be›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecjoin.(*crossJoinerBase).buildFromRightInput.func1()›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/bazel-out/k8-opt/bin/pkg/sql/colexec/colexecjoin/crossjoiner.eg.go:1692 +0x345›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colmem.(*Allocator).PerformOperation(0xc000a71e00?, {0xc000a71e10, 0x12, 0x2a18e45?}, 0xc00e6ddaf0?)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colmem/allocator.go:441 +0x49›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecjoin.(*crossJoinerBase).buildFromRightInput(0xc00202e160, {0x67e39e8, 0xc00f3817d0}, 0x0)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/bazel-out/k8-opt/bin/pkg/sql/colexec/colexecjoin/crossjoiner.eg.go:1360 +0x12b›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecjoin.(*mergeJoinInnerOp).buildFromBufferedGroup(0xc000598a30)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/bazel-out/k8-opt/bin/pkg/sql/colexec/colexecjoin/mergejoiner_inner.eg.go:10904 +0x16f›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecjoin.(*mergeJoinInnerOp).Next(0xc000598a30)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/bazel-out/k8-opt/bin/pkg/sql/colexec/colexecjoin/mergejoiner_inner.eg.go:10972 +0x5bd›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk.(*hashBasedPartitioner).Next(0xc00f21b500)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk/hash_based_partitioner.go:613 +0x4a6›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk.(*diskSpillerBase).Next(0xc00e6ddf78?)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk/disk_spiller.go:193 +0x16f›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colflow.(*batchInfoCollector).next(0xc0019cdb30)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colflow/stats.go:116 +0x29›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError(0xc00996b740?)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:92 +0x62›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colflow.(*batchInfoCollector).Next(0xc0019cdb30)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colflow/stats.go:124 +0x52›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk.(*bufferExportingOperator).Next(0xc00f21b6c0?)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk/disk_spiller.go:329 +0x97›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk.(*hashBasedPartitioner).Next(0xc00f21b6c0)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk/hash_based_partitioner.go:415 +0xec2›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk.(*diskSpillerBase).Next(0xc00f37c000)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk/disk_spiller.go:211 +0x142›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colflow.(*batchInfoCollector).next(0xc0019cdd10)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colflow/stats.go:116 +0x29›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError(0xc00996ba00?)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:92 +0x62›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colflow.(*batchInfoCollector).Next(0xc0019cdd10)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colflow/stats.go:124 +0x52›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexechash.(*HashTable).FullBuild(0xc00f38b200, {0x7fedb3ff3860, 0xc0019cdd10})›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexechash/hashtable.go:491 +0x88›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecjoin.(*hashJoiner).build(0xc005343380)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecjoin/hashjoiner.go:329 +0x3a›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecjoin.(*hashJoiner).Next(0xc005343380)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecjoin/hashjoiner.go:291 +0xca›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk.(*diskSpillerBase).Next.func1()›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk/disk_spiller.go:198 +0x2f›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError(0x40?)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:92 +0x62›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk.(*diskSpillerBase).Next(0xc00f37c2d0)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk/disk_spiller.go:196 +0x68›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colflow.(*batchInfoCollector).next(0xc0019cdef0)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colflow/stats.go:116 +0x29›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError(0xc00996bcc0?)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:92 +0x62›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colflow.(*batchInfoCollector).Next(0xc0019cdef0)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colflow/stats.go:124 +0x52›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexechash.(*HashTable).FullBuild(0xc00f38b680, {0x7fedb3ff3860, 0xc0019cdef0})›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexechash/hashtable.go:491 +0x88›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecjoin.(*hashJoiner).build(0xc005343ba0)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecjoin/hashjoiner.go:329 +0x3a›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecjoin.(*hashJoiner).Next(0xc005343ba0)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecjoin/hashjoiner.go:291 +0xca›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk.(*diskSpillerBase).Next.func1()›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk/disk_spiller.go:198 +0x2f›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError(0x203002?)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:92 +0x62›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk.(*diskSpillerBase).Next(0xc00f37c5a0)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk/disk_spiller.go:196 +0x68›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colflow.(*batchInfoCollector).next(0xc003a543c0)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colflow/stats.go:116 +0x29›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError(0xc00996bf80?)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:92 +0x62›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colflow.(*batchInfoCollector).Next(0xc003a543c0)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colflow/stats.go:124 +0x52›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexechash.(*HashTable).FullBuild(0xc00f38bb00, {0x7fedb3ff3860, 0xc003a543c0})›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexechash/hashtable.go:491 +0x88›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecjoin.(*hashJoiner).build(0xc001d14ea0)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecjoin/hashjoiner.go:329 +0x3a›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecjoin.(*hashJoiner).Next(0xc001d14ea0)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecjoin/hashjoiner.go:291 +0xca›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk.(*diskSpillerBase).Next.func1()›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk/disk_spiller.go:198 +0x2f›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError(0x7fedde526108?)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:92 +0x62›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk.(*diskSpillerBase).Next(0xc00f37c870)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk/disk_spiller.go:196 +0x68›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecsel.(*selGTDecimalDecimalOp).Next(0xc00f380b70)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/bazel-out/k8-opt/bin/pkg/sql/colexec/colexecsel/selection_ops.eg.go:39831 +0x4b›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecsel.(*selNEBytesBytesOp).Next(0xc00f380ba0)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/bazel-out/k8-opt/bin/pkg/sql/colexec/colexecsel/selection_ops.eg.go:9969 +0x4b›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecsel.(*selLEInt16Int16Op).Next(0xc00f380bd0)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/bazel-out/k8-opt/bin/pkg/sql/colexec/colexecsel/selection_ops.eg.go:30597 +0x48›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecbase.(*simpleProjectOp).Next(0xc00cba9aa0)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecbase/simple_project.go:124 +0x3f›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colflow.(*batchInfoCollector).next(0xc003a545a0)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colflow/stats.go:116 +0x29›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError(0xc00996c240?)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:92 +0x62›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colflow.(*batchInfoCollector).Next(0xc003a545a0)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colflow/stats.go:124 +0x52›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec.getNext_false(0xc00f35ea00)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/bazel-out/k8-opt/bin/pkg/sql/colexec/hash_aggregator.eg.go:546 +0xef›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec.(*hashAggregator).Next(0xc000098c00?)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/bazel-out/k8-opt/bin/pkg/sql/colexec/hash_aggregator.eg.go:90 +0x36›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk.(*diskSpillerBase).Next.func1()›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk/disk_spiller.go:198 +0x2f›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError(0x67e39e8?)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:92 +0x62›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk.(*diskSpillerBase).Next(0xc00f37cbd0)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecdisk/disk_spiller.go:196 +0x68›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colflow.(*batchInfoCollector).next(0xc003a54870)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colflow/stats.go:116 +0x29›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError(0xc00996c640?)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:92 +0x62›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colflow.(*batchInfoCollector).Next(0xc003a54870)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colflow/stats.go:124 +0x52›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecutils.(*selBoolOp).Next(0xc00996c6c0)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecutils/bool_vec_to_sel.go:142 +0x2d›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecutils.(*BoolVecToSelOp).Next(0xc0014acc80)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecutils/bool_vec_to_sel.go:62 +0x32›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecbase.(*simpleProjectOp).Next(0xc00cc38060)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecbase/simple_project.go:124 +0x3f›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colflow.(*batchInfoCollector).next(0xc003a54a50)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colflow/stats.go:116 +0x29›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError(0xc00996c700?)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:92 +0x62›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colflow.(*batchInfoCollector).Next(0xc003a54a50)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colflow/stats.go:124 +0x52›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colflow.(*BatchFlowCoordinator).nextAdapter(0xc00910bad0)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colflow/flow_coordinator.go:252 +0x2a›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError(0xc003ace800?)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:92 +0x62›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colflow.(*BatchFlowCoordinator).next(...)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colflow/flow_coordinator.go:256›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colflow.(*BatchFlowCoordinator).Run(0xc00910bad0, {0x67e3940?, 0xc00996a740?})›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colflow/flow_coordinator.go:299 +0x308›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/colflow.(*vectorizedFlow).Run(0xc008f72320, {0x67e3940, 0xc00996a740})›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/colflow/vectorized_flow.go:320 +0x1d8›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).Run(0xc000bdfe00, {0x67e39e8, 0xc00f35c330}, 0xc009e53dc0, 0xc0017100b0, 0xc00f360d00, 0xc008358700, 0xc004c65440, 0x0)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:688 +0xa78›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).PlanAndRun(0xc00f35c3c0?, {0x67e39e8, 0xc00f35c330}, 0x0?, 0xc009e53dc0, 0x0?, {{0x67e5ea8?, 0xc00246ce60?}, 0x0?}, 0xc008358700)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:1555 +0x1f9›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).PlanAndRunAll(0xc009e53dc0?, {0x67e39e8, 0xc00f35c330}, 0xc004c650e8?, 0x1?, 0xc004c650e8, 0xc008358700, 0x3?)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:1307 +0x206›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execWithDistSQLEngine(0xc004c64c00, {0x67e39e8, 0xc00f35c330}, 0xc004c650e8, 0xc00f35c330?, {0x7fedb33b8ff0?, 0xc004aeef08}, 0x0?, 0xc0017101f8)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1576 +0x4c8›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).dispatchToExecutionEngine(0xc004c64c00, {0x67e39e8, 0xc00e6cbce0}, 0xc004c650e8, {0x7fedb33b8ff0, 0xc004aeef08})›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1216 +0xb99›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmtInOpenState(0xc004c64c00, {0x67e39e8?, 0xc00e6cbbc0?}, {{0x680c740, 0xc009d479f0}, {0x0, 0x0, 0x0}, {0xc001b805e6, 0x5dd}, ...}, ...)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:725 +0x2534›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt.func1({0x67e39e8?, 0xc00e6cbbc0?})›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:129 +0xbc›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execWithProfiling(0x67e39e8?, {0x67e39e8?, 0xc00e6cbbc0?}, {0x680c740?, 0xc009d479f0?}, 0x0?, 0x958c960?)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:2421 +0x330›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt(0xc004c64c00, {0x67e39e8, 0xc00e6cbbc0}, {{0x680c740, 0xc009d479f0}, {0x0, 0x0, 0x0}, {0xc001b805e6, 0x5dd}, ...}, ...)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:128 +0x4da›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd.func1(0xc00e6e1ac0, 0xc004c64c00, 0xc00e6e17d8, 0xc00e6e1890, 0xc00e6e18d0, 0xc00e6e18b0, 0xc00e6e18a0, 0xc00e6e18c0)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1927 +0x305›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd(0xc004c64c00)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1932 +0x1127›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).run(0xc004c64c00, {0x67e3940, 0xc0092bdf80}, 0x4110876800000000?, 0xc00147ddd8?, 0xc000a32780?)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1852 +0x20b›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql.(*Server).ServeConn(0xc00295e820?, {0x67e3940?, 0xc0092bdf80?}, {0xc0011f3100?}, 0x3?, 0xc0061eac00?)›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:830 +0xe6›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).processCommandsAsync.func1()›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:728 +0x40d›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹created by github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).processCommandsAsync›
I221102 10:58:15.847543 54 util/log/clog.go:409 ⋮ [-] 383 +‹	github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:639 +0x22e›

@cucaroach
Copy link
Contributor

cucaroach commented Nov 3, 2022

diskQueue Dequeue and Enqueue both have cancel checkers so they must have been dealing with humonguous batches or there was some kind of disk stall? Given that they appear to be doing work and not reading/writing to disk I think they must be huge batches? @yuzefovich any thoughts? The fact that the failure on 11/1 was an OOM lends credence to the huge batches theory.

@yuzefovich
Copy link
Member

Hm, if there was a prolonged disk stall, we would crash the node (I think right now it happens if we detect 20 second disk stall). Indeed, these goroutines show that we are doing work for serializing / deserializing possibly-large batches to write / read them from the disk, but it's hard to say for sure whether this temp storage activity the cause here. I wonder whether we should augment the signature of Enqueue and Dequeue methods with some "metrics" - i.e. add arguments like Enqueue(..., estimatedBatchSizeBytes int64, batchIdx int64) these would then show up in these stack traces.

craig bot pushed a commit that referenced this issue Nov 10, 2022
91561: opt: prevent null-rejection rule cycle r=DrewKimball a=DrewKimball

This patch adds checks to the null-rejection logic to ensure that null-rejection is not attempted when the necessary filter push-down rules are disabled. This prevents rule cycles that occur when decorrelation or filter elimination rules fire after the `col IS NOT NULL` filter isn't pushed all the way down to the outer join.

Fixes #89986

Release note: None

91588: kvserver: make logAppend and sideloading stand-alone r=pavelkalinnikov a=tbg

`*Replica` is a big bag of behavior and we should try to encapsulate the
replication layer from it as much as possible.

Methods anchored on `*Replica` are particularly problematic, since it's
anyone's guess which of the many members they access. Instead, the
pattern we should follow is that as many methods as possible are
stand-alone and interact with the `*Replica` only ways obvious from
the parameters.

It was really easy to do this for `(*Replica).append` and for
`(*Replica).maybeSideloadEntries`, and this commit does it.

Epic: CRDB-220
Release note: None


91631: kvserver: fix allocator determinism r=nvanbenschoten a=kvoli

Previously, the allocator when running in deterministic mode, would not be deterministic under all scenarios due to iteration over an unordered map. This patch fixes this by first sorting entries, before iterating.

resolves: #89394

Release note: None

91632: roachtest: gather cores if requested r=cucaroach a=cucaroach

- roachtest: allow tests to opt in to core gathering and compress cores
- roachtest: gather cores on multiregion tests that are timing out

Relates to #90683 CRDB-20887

Co-authored-by: Drew Kimball <[email protected]>
Co-authored-by: Tobias Grieger <[email protected]>
Co-authored-by: Austen McClernon <[email protected]>
Co-authored-by: Tommy Reilly <[email protected]>
@cockroach-teamcity
Copy link
Member Author

roachtest.costfuzz/seed-multi-region failed with artifacts on master @ d136c1fa50fa507c2232d7b215d98b88a83649c5:

test artifacts and logs in: /artifacts/costfuzz/seed-multi-region/run_1
(test_impl.go:314).Errorf: test timed out (1h0m0s)

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_fs=ext4 , ROACHTEST_localSSD=true , 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.costfuzz/seed-multi-region failed with artifacts on master @ fb4014a31b9b8d8235dc48de52196e64b185f490:

test artifacts and logs in: /artifacts/costfuzz/seed-multi-region/run_1
(test_impl.go:291).Fatal: parallel execution failure: ~ ./cockroach.sh
: context deadline exceeded

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_fs=ext4 , ROACHTEST_localSSD=true , 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.costfuzz/seed-multi-region failed with artifacts on master @ af18b5d2f8ec09d6f3c3092be9ef5fe3f460724d:

test artifacts and logs in: /artifacts/costfuzz/seed-multi-region/run_1
(test_impl.go:314).Errorf: test timed out (1h0m0s)

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_fs=ext4 , ROACHTEST_localSSD=true , 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.costfuzz/seed-multi-region failed with artifacts on master @ d98d195dfa7a3480ce3e07657aa870692fe71cea:

test artifacts and logs in: /artifacts/costfuzz/seed-multi-region/run_1
(test_impl.go:291).Fatal: parallel execution failure: failed to upload start script: : context deadline exceeded

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_fs=ext4 , ROACHTEST_localSSD=true , 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.costfuzz/seed-multi-region failed with artifacts on master @ ea7c52e5a930be203318db6e338edd5dde7537bd:

test artifacts and logs in: /artifacts/costfuzz/seed-multi-region/run_1
(test_impl.go:314).Errorf: test timed out (1h0m0s)

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_fs=ext4 , ROACHTEST_localSSD=true , 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.costfuzz/seed-multi-region failed with artifacts on master @ 1a6e9f885baa124d5ff2996adb966ea15a1a9b2b:

test artifacts and logs in: /artifacts/costfuzz/seed-multi-region/run_1
(test_impl.go:314).Errorf: test timed out (1h0m0s)

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_fs=ext4 , ROACHTEST_localSSD=true , 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.costfuzz/seed-multi-region failed with artifacts on master @ 7823e2f75474417a44f0d34f76c5f8914cb91d52:

test artifacts and logs in: /artifacts/costfuzz/seed-multi-region/run_1
(test_impl.go:314).Errorf: test timed out (1h0m0s)

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_fs=ext4 , ROACHTEST_localSSD=true , 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.costfuzz/seed-multi-region failed with artifacts on master @ 9c21578450e395c83a1dc0df7090296fef06e006:

test artifacts and logs in: /artifacts/costfuzz/seed-multi-region/run_1
(test_impl.go:314).Errorf: test timed out (1h0m0s)

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_fs=ext4 , ROACHTEST_localSSD=true , 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.costfuzz/seed-multi-region failed with artifacts on master @ d6f98e90684894fd36f53596e6aac355676d232e:

test artifacts and logs in: /artifacts/costfuzz/seed-multi-region/run_1
(test_impl.go:291).Fatal: parallel execution failure: failed to upload start script: : context deadline exceeded

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_fs=ext4 , ROACHTEST_localSSD=true , 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.costfuzz/seed-multi-region failed with artifacts on master @ dcdf599e9eaee8010137167f419509ccb7627406:

test artifacts and logs in: /artifacts/costfuzz/seed-multi-region/run_1
(test_impl.go:291).Fatal: parallel execution failure: ~ ./cockroach.sh
: context deadline exceeded

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_fs=ext4 , ROACHTEST_localSSD=true , 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.costfuzz/seed-multi-region failed with artifacts on master @ 4232883add85a151c423c45904ac4096d04656c5:

test artifacts and logs in: /artifacts/costfuzz/seed-multi-region/run_1
(test_impl.go:291).Fatal: parallel execution failure: ~ ./cockroach.sh
: context deadline exceeded

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_fs=ext4 , ROACHTEST_localSSD=true , 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.costfuzz/seed-multi-region failed with artifacts on master @ 9c5375f6a7375724cdbcbaa0029ed97a230d7abe:

test artifacts and logs in: /artifacts/costfuzz/seed-multi-region/run_1
(test_impl.go:291).Fatal: parallel execution failure: failed to upload start script: : context deadline exceeded

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_fs=ext4 , ROACHTEST_localSSD=true , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity

This comment was marked as duplicate.

@cockroach-teamcity

This comment was marked as duplicate.

@cockroach-teamcity

This comment was marked as duplicate.

@cockroach-teamcity

This comment was marked as duplicate.

@mgartner
Copy link
Collaborator

mgartner commented Jan 3, 2023

I hid all the failures above that are duplicates of #94520.

@cucaroach
Copy link
Contributor

@msirek are these context deadline exceeded issues related the fixes you made recently?

@msirek msirek added the X-duplicate Closed as a duplicate of another issue. label Jan 3, 2023
@msirek
Copy link
Contributor

msirek commented Jan 3, 2023

are these context deadline exceeded issues related the fixes you made recently?

Yes. Closing as a dup of #92753

@msirek msirek closed this as completed Jan 3, 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). O-roachtest O-robot Originated from a bot. T-sql-queries SQL Queries Team X-duplicate Closed as a duplicate of another issue.
Projects
Archived in project
Development

No branches or pull requests

7 participants