search

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.
https://www.cockroachlabs.com
Other
30.03k stars 3.8k forks source link

roachtest: sqlsmith index out of range #76102

Closed cockroach-teamcity closed 2 years ago

cockroach-teamcity commented 2 years ago

roachtest.sqlsmith/setup=rand-tables/setting=no-mutations failed with artifacts on master @ 8548987813ff9e1b8a9878023d3abfc6911c16db:

                                                        ORDER BY
                                                            tab_9072.crdb_internal_mvcc_timestamp
                                                        LIMIT
                                                            1:::INT8
                                                    )
                                                )
                                                    AS col_15071
                                            FROM
                                                defaultdb.public.table1@table1_expr_key AS tab_9070
                                            WHERE
                                                '\xe29883':::BYTES::BYTES
                                                NOT IN (
                                                        SELECT
                                                            '\xbb29ed960621':::BYTES::BYTES AS col_15069
                                                        FROM
                                                            defaultdb.public.table1@table1_expr_key AS tab_9071
                                                        WHERE
                                                            false
                                                        LIMIT
                                                            84:::INT8
                                                    )
                                            LIMIT
                                                1:::INT8
                                        ),
                                        ARRAY[]:::RECORD[]
                                    )
                                ),
                                (ARRAY[(),(),(),()]),
                                (ARRAY[(),(),()]),
                                (ARRAY[(),(),(),(),(),(),()])
                        )
                            AS tab_9074 (col_15072)
                )
        SELECT
            tab_9075.tableoid AS col_15073,
            '{"bar": {"0ih``": {"b": 1.1607717734160394}}, "foo": [[{":DE b5I": {}, "qc}7EGv3": {"bar": [{}], "baz": null}, "u[[": []}, {}], {"foo": 0.07430659923456653, "foobar": {}}]}':::JSONB
                AS col_15074,
            1727859127:::OID AS col_15075,
            '[null, null]':::JSONB AS col_15076,
            ARRAY[]:::RECORD[] AS col_15077,
            261803.805151728437:::DECIMAL AS col_15078,
            1.886734687860280106E+35:::DECIMAL AS col_15079
        FROM
            with_3656 AS cte_ref_1089,
            defaultdb.public.table1@table1_expr_key AS tab_9075,
            defaultdb.public.table1@[0] AS tab_9076
        WHERE
            true
        LIMIT
            65:::INT8;
Help

See: [roachtest README](https://github.com/cockroachdb/cockroach/blob/master/pkg/cmd/roachtest/README.md) See: [How To Investigate \(internal\)](https://cockroachlabs.atlassian.net/l/c/SSSBr8c7)

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

cockroach-teamcity commented 2 years ago

roachtest.sqlsmith/setup=rand-tables/setting=no-mutations failed with artifacts on master @ 8548987813ff9e1b8a9878023d3abfc6911c16db:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/sqlsmith/setup=rand-tables/setting=no-mutations/run_1
    sqlsmith.go:258,sqlsmith.go:297,test_runner.go:779: error: pq: internal error: runtime error: index out of range [0] with length 0
        stmt:
        SELECT
            tab_12855.col1_7 AS col_29705
        FROM
            defaultdb.public.table1@table1_col1_2_key AS tab_12855
        GROUP BY
            tab_12855.col1_7
        LIMIT
            62:::INT8;
Help

See: [roachtest README](https://github.com/cockroachdb/cockroach/blob/master/pkg/cmd/roachtest/README.md) See: [How To Investigate \(internal\)](https://cockroachlabs.atlassian.net/l/c/SSSBr8c7)

This test on roachdash | Improve this report!

rharding6373 commented 2 years ago

First failure has error: pq: internal error: no volatility for cast tuple[]::tuple[], which is a dupe of #76139

Second failure has error index out of range [0] with length 0 which looks similar to #76222 (slice bound out of range).

yuzefovich commented 2 years ago

Second failure is

E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617  encountered internal error:
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +‹runtime error: index out of range [0] with length 0›
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +(1) assertion failure
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +Wraps: (2) attached stack trace
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  -- stack trace:
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  | github.com/cockroachdb/cockroach/pkg/util/errorutil.ShouldCatch
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  |   github.com/cockroachdb/cockroach/pkg/util/errorutil/catch.go:29
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  | github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).Optimize.func1
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  |   github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:206
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  | runtime.gopanic
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  |   GOROOT/src/runtime/panic.go:1038
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  | runtime.goPanicIndex
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  |   GOROOT/src/runtime/panic.go:90
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  | github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*CustomFuncs).GenerateLimitedTopKScans.func1
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  |   github.com/cockroachdb/cockroach/pkg/sql/opt/xform/limit_funcs.go:267
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  | github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*scanIndexIter).ForEachStartingAfter
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  |   github.com/cockroachdb/cockroach/pkg/sql/opt/xform/scan_index_iter.go:298
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  | github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*scanIndexIter).ForEach
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  |   github.com/cockroachdb/cockroach/pkg/sql/opt/xform/scan_index_iter.go:209
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  | github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*CustomFuncs).GenerateLimitedTopKScans
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  |   github.com/cockroachdb/cockroach/pkg/sql/opt/xform/limit_funcs.go:242
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  | github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*explorer).exploreTopK
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  |   github.com/cockroachdb/cockroach/bazel-out/k8-opt/bin/pkg/sql/opt/xform/explorer.og.go:3437
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  | github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*explorer).exploreGroupMember
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  |   github.com/cockroachdb/cockroach/bazel-out/k8-opt/bin/pkg/sql/opt/xform/explorer.og.go:62
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  | github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*explorer).exploreGroup
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  |   github.com/cockroachdb/cockroach/pkg/sql/opt/xform/explorer.go:182
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  | github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  |   github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:469
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  | github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeEnforcer
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  |   github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:627
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  | github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).enforceProps
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  |   github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:586
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  | github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  |   github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:496
E220206 06:30:39.973409 2167 sql/sqltelemetry/report.go:57 ⋮ [n1,client=‹34.73.204.138:37154›,user=root] 617 +  | github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup
...