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.06k stars 3.8k forks source link

roachtest: sqlsmith/setup=empty/setting=no-mutations failed #73105

Closed cockroach-teamcity closed 2 years ago

cockroach-teamcity commented 2 years ago

roachtest.sqlsmith/setup=empty/setting=no-mutations failed with artifacts on release-21.2 @ 44c5c2c509fb16b44ef7edcb3e24cfba9b7d0621:

                            NULL,
                            CASE
                            WHEN NULL
                            THEN e'[{"7;2rl;GBP": 0.31314520389721423}, {"Gs5%z?%": [{"bar": []}], "baz": {")Li \\\\vZ1": [{}, {}], "Tn5": false, "b": []}}, [], {}]':::JSONB
                            ELSE '{"test": "json"}':::JSONB
                            END
                        ),
                        (
                            '01010000408ABA478091F7E1C19651CFE7E185E4C16DC89EC5ED7FF6C1':::GEOMETRY,
                            e'{"CxHbB$mw*q,$": {}, "WIb<I+a}c|0": {"AFRbb": [null], "a": 0.9988269453688856}, "a": {}, "b": {"foobar": true}, "foobar": {}, "r[H[H8oZY4U": {"\'Pwx\' A,MA": {"hI8\\\\V+l.2": "baz"}}}':::JSONB
                        ),
                        (
                            st_minimumboundingcircle(st_point(atanh(1.4896149456297487:::FLOAT8::FLOAT8)::FLOAT8::FLOAT8, (-1.3902581275162773):::FLOAT8::FLOAT8)::GEOMETRY::GEOMETRY)::GEOMETRY,
                            e'[{"\\\\,f1ZdaH&": true, "]b\\\\``&i|Z\\"cz": [[{}, true]], "c": 0.3395598943278726}, {"foobar": "=tF5H2l4|B@"}, [2.1529387038419188], {}]':::JSONB
                        )
                )
                    AS tab_181430 (col_312806, col_312807) ON true
        ORDER BY
            tab_181429.col_312805 ASC
        LIMIT
            66:::INT8;

    cluster.go:1249,context.go:89,cluster.go:1237,test_runner.go:866: dead node detection: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/bin/roachprod monitor teamcity-3788190-1637738085-08-n4cpu4 --oneshot --ignore-empty-nodes: exit status 1 3: 11389
        2: 11399
        4: 10964
        1: dead (exit status 134)
        Error: UNCLASSIFIED_PROBLEM: 1: dead (exit status 134)
        (1) UNCLASSIFIED_PROBLEM
        Wraps: (2) attached stack trace
          -- stack trace:
          | github.com/cockroachdb/cockroach/pkg/roachprod.Monitor
          |     /home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/roachprod/roachprod.go:596
          | main.glob..func14
          |     /home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachprod/main.go:569
          | main.wrap.func1
          |     /home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachprod/main.go:123
          | github.com/spf13/cobra.(*Command).execute
          |     /home/agent/work/.go/src/github.com/cockroachdb/cockroach/vendor/github.com/spf13/cobra/command.go:856
          | github.com/spf13/cobra.(*Command).ExecuteC
          |     /home/agent/work/.go/src/github.com/cockroachdb/cockroach/vendor/github.com/spf13/cobra/command.go:960
          | github.com/spf13/cobra.(*Command).Execute
          |     /home/agent/work/.go/src/github.com/cockroachdb/cockroach/vendor/github.com/spf13/cobra/command.go:897
          | main.main
          |     /home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachprod/main.go:1170
          | runtime.main
          |     /usr/local/go/src/runtime/proc.go:255
          | runtime.goexit
          |     /usr/local/go/src/runtime/asm_amd64.s:1581
        Wraps: (3) 1: dead (exit status 134)
        Error types: (1) errors.Unclassified (2) *withstack.withStack (3) *errutil.leafError
Reproduce

See: [roachtest README](https://github.com/cockroachdb/cockroach/blob/master/pkg/cmd/roachtest/README.md)

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

yuzefovich commented 2 years ago
fatal error: unexpected signal during runtime execution
[signal SIGSEGV: segmentation violation code=0x1 addr=0x2b20ef57 pc=0x7fcfa48308e4]

runtime stack:
runtime.throw({0x490d1a5, 0x7fcfa4f6ade0})
    /usr/local/go/src/runtime/panic.go:1198 +0x71 fp=0x7fcfa6bfec18 sp=0x7fcfa6bfebe8 pc=0x488891
runtime.sigpanic()
    /usr/local/go/src/runtime/signal_unix.go:719 +0x396 fp=0x7fcfa6bfec68 sp=0x7fcfa6bfec18 pc=0x49eeb6

goroutine 2582 [syscall]:
runtime.cgocall(0x3c57d30, 0xc0026754a8)
    /usr/local/go/src/runtime/cgocall.go:156 +0x5c fp=0xc002675470 sp=0xc002675438 pc=0x45647c
github.com/cockroachdb/cockroach/pkg/geo/geos._Cfunc_CR_GEOS_MinimumBoundingCircle(0x7fcfa8c58000, {0xc008516a40, 0x15}, 0xc00aaa6988, 0xc009adf660, 0xc009adf670)
    _cgo_gotypes.go:571 +0x4e fp=0xc0026754a8 sp=0xc002675470 pc=0x166a80e
github.com/cockroachdb/cockroach/pkg/geo/geos.MinimumBoundingCircle.func1(0x7fcfa8c58000, {0xc008516a40, 0x2, 0x0}, 0x30, 0xc000100400, 0xc00700d760)
    /home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/geo/geos/geos.go:444 +0xdd fp=0xc002675520 sp=0xc0026754a8 pc=0x166f35d
github.com/cockroachdb/cockroach/pkg/geo/geos.MinimumBoundingCircle({0xc008516a40, 0x15, 0x40})
    /home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/geo/geos/geos.go:444 +0xb9 fp=0xc0026755a8 sp=0xc002675520 pc=0x166f139
github.com/cockroachdb/cockroach/pkg/geo/geomfn.MinimumBoundingCircle({{0x2, {0xc008516a40, 0x15, 0x40}, 0x0, 0x1, 0xc00c326f00}})
    /home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/geo/geomfn/topology_operations.go:45 +0xbb fp=0xc0026756e0 sp=0xc0026755a8 pc=0x16aa7fb
github.com/cockroachdb/cockroach/pkg/sql/sem/builtins.glob..func574(0x8166790, 0xc00dd89260)
    /home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/sem/builtins/geo_builtins.go:6460 +0x89 fp=0xc002675818 sp=0xc0026756e0 pc=0x1cbbf69
github.com/cockroachdb/cockroach/pkg/sql/sem/builtins.geometryOverload1.func1(0xc00e78f300, {0xc009adf650, 0x1, 0x80})
    /home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/sem/builtins/geo_builtins.go:6847 +0x5c fp=0xc002675850 sp=0xc002675818 pc=0x1c6399c
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*FuncExpr).Eval(0xc00e78f300, 0xc001611b20)
    /home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/sem/tree/eval.go:4212 +0x6f fp=0xc002675960 sp=0xc002675850 pc=0x15128af
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*CustomFuncs).FoldFunction(0xc0016120e8, {0xc009adf590, 0x1, 0x8180280}, 0xc002675b50)
    /home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/fold_constants_funcs.go:578 +0x1a8 fp=0xc0026759e8 sp=0xc002675960 pc=0x21c8928
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructFunction(0xc0016120d8, {0xc009adf590, 0x1, 0x1}, 0xc002675b50)
    /home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:19693 +0x17a fp=0xc002675a40 sp=0xc0026759e8 pc=0x21970fa
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildFunction(0xc00d1db960, 0xc00e78f080, 0xc00d298000, 0x0, 0x100c002c5e4cc, 0x1)
    /home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/scalar.go:511 +0x205 fp=0xc002675c00 sp=0xc002675a40 pc=0x2eb4d25
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildScalar(0xc00d1db960, {0x8180280, 0xc00e78f080}, 0xc00d298000, 0xc00aaa6805, 0x7, 0xc00aaa6805)
    /home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/scalar.go:299 +0x103d fp=0xc002675ff0 sp=0xc002675c00 pc=0x2eb277d
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildValuesClause(0xc00d1db960, 0xc0079b34e8, {0x0, 0x0, 0xab3d080}, 0xc00d298000)
    /home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/values.go:86 +0x9f4 fp=0xc0026761e8 sp=0xc002675ff0 pc=0x2ed3834
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildSelectStmtWithoutParens(0xf, {0x81808f8, 0xc0079b34e8}, {0x0, 0x0, 0x0}, 0x0, {0x0, 0x0, 0x0}, ...)
    /home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:921 +0x1b9 fp=0xc0026762d0 sp=0xc0026761e8 pc=0x2ec56b9
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildSelect.func1(0xc00d1db960)

dup of #70660