roachtest: sqlsmith/setup=rand-tables/setting=no-ddl failed

[cockroach-teamcity]

roachtest.sqlsmith/setup=rand-tables/setting=no-ddl failed with artifacts on release-23.1 @ e12e85479312972b551677203849d29aeb38ad5f:

(sqlsmith.go:244).func3: error: pq: internal error: unable to vectorize execution plan: 0.000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000:::DECIMAL: could not evaluate 0.000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 as Datum type DDecimal from string "0.000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000": could not parse "0.000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000" as type decimal
stmt:
SELECT
	tab1967.tableoid AS col3650,
	tab1967."%pcol1_2" AS col3651,
	tab1967.col1_0 AS col3652,
	NULL AS "c\\xa7ol3653",
	(6765372031569587176:::INT8::INT8 / 'Infinity':::DECIMAL::DECIMAL)::DECIMAL AS col3654,
	tab1967.col1_0 AS "c\gol3655",
	tab1967."""c'ol1_1" AS col3656
FROM
	defaultdb.public."tabl""e1"@[0] AS tab1967
ORDER BY
	tab1967.crdb_internal_mvcc_timestamp DESC NULLS LAST
LIMIT
	53:::INT8;
test artifacts and logs in: /artifacts/sqlsmith/setup=rand-tables/setting=no-ddl/run_1

Parameters: ROACHTEST_arch=amd64 , ROACHTEST_cloud=aws , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

• roachtest: sqlsmith/setup=rand-tables/setting=no-ddl failed #105796 roachtest: sqlsmith/setup=rand-tables/setting=no-ddl failed [C-test-failure O-roachtest O-robot T-sql-queries branch-release-22.2]

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-29369

[mgartner]

Stack trace:

github.com/cockroachdb/cockroach/pkg/sql/execinfrapb/pkg/sql/execinfrapb/expr.go:88: processExpression()
github.com/cockroachdb/cockroach/pkg/sql/execinfrapb/pkg/sql/execinfrapb/expr.go:169: DeserializeExpr()
github.com/cockroachdb/cockroach/pkg/sql/execinfrapb/pkg/sql/execinfrapb/expr.go:209: Init()
github.com/cockroachdb/cockroach/pkg/sql/execinfra/processorsbase.go:173: Init()
github.com/cockroachdb/cockroach/pkg/sql/execinfra/processorsbase.go:795: InitWithEvalCtx()
github.com/cockroachdb/cockroach/pkg/sql/execinfra/processorsbase.go:764: Init()
github.com/cockroachdb/cockroach/pkg/sql/rowexec/noop.go:57: newNoopProcessor()
github.com/cockroachdb/cockroach/pkg/sql/rowexec/processors.go:127: NewProcessor()
github.com/cockroachdb/cockroach/pkg/sql/colexec/colbuilder/execplan.go:557: func1()
github.com/cockroachdb/cockroach/pkg/sql/colexec/colbuilder/execplan.go:111: wrapRowSources()
github.com/cockroachdb/cockroach/pkg/sql/colexec/colbuilder/execplan.go:545: createAndWrapRowSource()
github.com/cockroachdb/cockroach/pkg/sql/colexec/colbuilder/execplan.go:1915: wrapPostProcessSpec()
github.com/cockroachdb/cockroach/pkg/sql/colexec/colbuilder/execplan.go:1771: NewColOperator()
github.com/cockroachdb/cockroach/pkg/sql/colflow/vectorized_flow.go:1235: func1()
github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:92: CatchVectorizedRuntimeError()
github.com/cockroachdb/cockroach/pkg/sql/colflow/vectorized_flow.go:1170: setupFlow()
github.com/cockroachdb/cockroach/pkg/sql/colflow/vectorized_flow.go:269: Setup()
github.com/cockroachdb/cockroach/pkg/sql/distsql/server.go:429: setupFlow()
github.com/cockroachdb/cockroach/pkg/sql/distsql/server.go:661: func1()
github.com/cockroachdb/cockroach/pkg/sql/distsql/server.go:689: SetupFlow()
github.com/cockroachdb/cockroach/pkg/sql/execinfrapb/bazel-out/darwin_arm64-fastbuild/bin/pkg/sql/execinfrapb/execinfrapb_go_pr
oto_/github.com/cockroachdb/cockroach/pkg/sql/execinfrapb/api.pb.go:602: func1()
github.com/cockroachdb/cockroach/pkg/util/tracing/grpcinterceptor/grpc_interceptor.go:96: func1()
google.golang.org/grpc/external/org_golang_google_grpc/server.go:1162: 1()
github.com/cockroachdb/cockroach/pkg/rpc/pkg/rpc/context.go:276: func3()
google.golang.org/grpc/external/org_golang_google_grpc/server.go:1165: 1()
github.com/cockroachdb/cockroach/pkg/rpc/pkg/rpc/context.go:243: 1()
github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:322: RunTaskWithErr()
github.com/cockroachdb/cockroach/pkg/rpc/pkg/rpc/context.go:241: func1()
google.golang.org/grpc/external/org_golang_google_grpc/server.go:1165: 1()
google.golang.org/grpc/external/org_golang_google_grpc/server.go:1167: func1()
github.com/cockroachdb/cockroach/pkg/sql/execinfrapb/bazel-out/darwin_arm64-fastbuild/bin/pkg/sql/execinfrapb/execinfrapb_go_pr
oto_/github.com/cockroachdb/cockroach/pkg/sql/execinfrapb/api.pb.go:604: _DistSQL_SetupFlow_Handler()
google.golang.org/grpc/external/org_golang_google_grpc/server.go:1340: processUnaryRPC()

[mgartner]

This can be reproduced in a 3-node cluster.

Reproduction Steps

1. Start and initialize a local 3-node cluster.

cockroach start \
--insecure \
--store=node1 \
--listen-addr=localhost:26257 \
--http-addr=localhost:8080 \
--join=localhost:26257,localhost:26258,localhost:26259

cockroach start \
--insecure \
--store=node2 \
--listen-addr=localhost:26258 \
--http-addr=localhost:8081 \
--join=localhost:26257,localhost:26258,localhost:26259

cockroach start \
--insecure \
--store=node3 \
--listen-addr=localhost:26259 \
--http-addr=localhost:8082 \
--join=localhost:26257,localhost:26258,localhost:26259

cockroach init --insecure --host=localhost:26257

2. Open a SQL session to the cluster.

cockroach sql --insecure --host=localhost:26257

3. Run the SQL below. The SELECT may produce the internal error. If not, continue to step 4.

CREATE TABLE t (a INT);
SELECT (1 / 'Infinity'::DECIMAL) FROM t;

4. Connect to the other nodes and run the SELECT statement above. It should error in one of the sessions.

cockroach sql --insecure --host=localhost:26258

cockroach sql --insecure --host=localhost:26259

SELECT (1 / 'Infinity'::DECIMAL) FROM t;

[mgartner]

I've reproduced this on v23.1.4, v22.2.11, v22.1.13, and master@972c37959.

[yuzefovich]

It looks like a dup of #40929

[yuzefovich]

I added C-test-failure label to #40929 and closing this issue as a dup of that one.