Skip to content

sql: panic: windowNode can't be run in local mode #36830

Closed
#37171
Closed
sql: panic: windowNode can't be run in local mode#36830
#37171
Assignees
yuzefovich
Labels
C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.O-sqlsmith
@madelynnblue

Description

@madelynnblue
madelynnblue
opened on Apr 15, 2019
CREATE TABLE t (
    _bool BOOL,
    _bytes BYTES,
    _date DATE,
    _decimal DECIMAL,
    _float4 FLOAT4,
    _float8 FLOAT8,
    _inet INET,
    _int4 INT4,
    _int8 INT8,
    _interval INTERVAL,
    _jsonb JSONB,
    _string STRING,
    _time TIME,
    _timestamp TIMESTAMP,
    _timestamptz TIMESTAMPTZ,
    _uuid UUID
);

INSERT INTO t DEFAULT VALUES;

INSERT
INTO
    defaultdb.public.t AS tab_280
SELECT
    not_ilike_escape(e'OF\x1e_?"a':::STRING::STRING, 'R 3':::STRING::STRING, e'(-\x06':::STRING::STRING)::BOOL AS col_829,
    experimental_uuid_v4()::BYTES AS col_830,
    current_date()::DATE AS col_831,
    crdb_internal.round_decimal_values((-8.193686308684118093E+24):::DECIMAL::DECIMAL, tab_284._int8::INT8)::DECIMAL AS col_832,
    ceiling(0.1393546902245561:::FLOAT8::FLOAT8)::FLOAT8 AS col_833,
    radians(NULL::FLOAT8)::FLOAT8 AS col_834,
    netmask('245.8.134.113/26':::INET::INET)::INET AS col_835,
    lag(tab_284._int8::INT8) OVER (PARTITION BY tab_284._int8)::INT8 AS col_836,
    dense_rank() OVER ()::INT8 AS col_837,
    date_trunc('GmwQ!i':::STRING::STRING, '07:05:39.063661':::TIME::TIME)::INTERVAL AS col_838,
    jsonb_agg(tab_284._int8)::JSONB AS col_839,
    quote_ident(e'\x0fW\x0fa\x16?_n\x0b':::STRING::STRING)::STRING AS col_840,
    '07:14:46.928522':::TIME AS col_841,
    clock_timestamp():::TIMESTAMP::TIMESTAMP AS col_842,
    clock_timestamp():::TIMESTAMPTZ::TIMESTAMPTZ AS col_843,
    gen_random_uuid()::UUID AS col_844
FROM
    defaultdb.public.t AS tab_281,
    defaultdb.public.t AS tab_282,
    defaultdb.public.t AS tab_283,
    defaultdb.public.t AS tab_284,
    defaultdb.public.t AS tab_285
    FULL JOIN defaultdb.public.t AS tab_286
    ON
        inet_contains_or_contained_by(
            '9e37:1fe4:a022:189e:61e2:671f:bae0:c23e/118':::INET::INET,
            'ca28:d25:d604:8eda:d7e4:2000:c5ef:7e97/18':::INET::INET
        )::BOOL,
    defaultdb.public.t AS tab_287,
    defaultdb.public.t AS tab_288,
    defaultdb.public.t AS tab_289
GROUP BY
    tab_284._int8;

github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).closeWrapper(0xc00182e000, 0x39b31a0, 0xc0018e1680, 0x2d33da0, 0x396ba80)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:723 +0x36d
github.com/cockroachdb/cockroach/pkg/sql.(*Server).ServeConn.func1(0xc00182e000, 0x39b31a0, 0xc0018e1680)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:435 +0x61
panic(0x2d33da0, 0x396ba80)
        /usr/local/go/src/runtime/panic.go:513 +0x1b9
github.com/cockroachdb/cockroach/pkg/sql.(*windowNode).Next(0xc0001f5e60, 0x39b3260, 0xc000ba8c30, 0xc001147400, 0xc00182e350, 0xc001b94530, 0x6c59bd, 0x2e70900)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/window.go:175 +0x39
github.com/cockroachdb/cockroach/pkg/sql.(*insertNode).BatchedNext(0xc001648f00, 0x39b3260, 0xc000ba8c30, 0xc001147400, 0xc00182e350, 0xc000ba8c00, 0x39b4f20, 0xc00038cbc0)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/insert.go:471 +0xcc
github.com/cockroachdb/cockroach/pkg/sql.(*rowCountNode).startExec(0xc00038cbc0, 0x39b3260, 0xc000ba8c30, 0xc001147400, 0xc00182e350, 0x6cec45, 0xc000f966b8)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/plan_batch.go:173 +0xd0
github.com/cockroachdb/cockroach/pkg/sql.startExec.func2(0x322d374, 0x5, 0x39b4f20, 0xc00038cbc0, 0xc001b94640, 0x0)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/plan.go:495 +0x55
github.com/cockroachdb/cockroach/pkg/sql.(*planVisitor).visitInternal.func1(0xc000b6b980, 0x322d374, 0x5, 0x39b4f20, 0xc00038cbc0)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/walk.go:145 +0x5d
panic(0x2d33da0, 0x396ba70)
        /usr/local/go/src/runtime/panic.go:513 +0x1b9
github.com/cockroachdb/cockroach/pkg/sql.(*windowNode).startExec(0xc0001f5e60, 0x39b3260, 0xc000ba8c30, 0xc001147400, 0xc00182e350, 0xc0011d4b40, 0xc001b94790)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/window.go:171 +0x39
github.com/cockroachdb/cockroach/pkg/sql.startExec.func2(0x32300fd, 0x6, 0x39b55a0, 0xc0001f5e60, 0xc000f96840, 0xc001b947a0)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/plan.go:495 +0x55
github.com/cockroachdb/cockroach/pkg/sql.(*planVisitor).visitInternal.func1(0xc000b6b980, 0x32300fd, 0x6, 0x39b55a0, 0xc0001f5e60)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/walk.go:145 +0x5d
github.com/cockroachdb/cockroach/pkg/sql.(*planVisitor).visitInternal(0xc000b6b980, 0x39b55a0, 0xc0001f5e60, 0x32300fd, 0x6)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/walk.go:616 +0x1c4
github.com/cockroachdb/cockroach/pkg/sql.(*planVisitor).visit(0xc000b6b980, 0x39b55a0, 0xc0001f5e60, 0x322f533, 0x6)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/walk.go:112 +0x8d
github.com/cockroachdb/cockroach/pkg/sql.(*planVisitor).visitInternal(0xc000b6b980, 0x39b4b60, 0xc001648f00, 0x322f533, 0x6)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/walk.go:455 +0x4929
github.com/cockroachdb/cockroach/pkg/sql.(*planVisitor).visitConcrete(0xc000b6b980, 0x39b4b60, 0xc001648f00)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/walk.go:125 +0x81
github.com/cockroachdb/cockroach/pkg/sql.(*planVisitor).visitInternal(0xc000b6b980, 0x39b4f20, 0xc00038cbc0, 0x322d374, 0x5)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/walk.go:536 +0x4e1f
github.com/cockroachdb/cockroach/pkg/sql.(*planVisitor).visit(0xc000b6b980, 0x39b4f20, 0xc00038cbc0, 0x203000, 0x6c9869)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/walk.go:112 +0x8d
github.com/cockroachdb/cockroach/pkg/sql.walkPlan(0x39b3260, 0xc000ba8c30, 0x39b4f20, 0xc00038cbc0, 0x0, 0x33a0048, 0x0, 0x0, 0x0, 0xc000ba9740, ...)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/walk.go:76 +0x1a4
github.com/cockroachdb/cockroach/pkg/sql.startExec(0x39b3260, 0xc000ba8c30, 0xc001147400, 0xc00182e350, 0x39b4f20, 0xc00038cbc0, 0xc001beb1d8, 0xc001beb1d0)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/plan.go:498 +0x116
github.com/cockroachdb/cockroach/pkg/sql.(*planNodeToRowSource).Start(0xc000868000, 0x39b3260, 0xc000ba8c30, 0x5afa900, 0x2d33020)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/plan_node_to_row_source.go:124 +0xd9
github.com/cockroachdb/cockroach/pkg/sql/distsqlrun.(*ProcessorBase).Run(0xc000868000, 0x39b3260, 0xc000ba8c30)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/distsqlrun/processors.go:813 +0x52
github.com/cockroachdb/cockroach/pkg/sql/distsqlrun.(*Flow).Run(0xc00012c960, 0x39b3260, 0xc000ba8c30, 0x339f738, 0x0, 0x0)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/distsqlrun/flow.go:626 +0x1e9
github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).Run(0xc000100a00, 0xc0017f6780, 0xc0011da240, 0xc001b96860, 0xc0011422c0, 0xc00182e410, 0x0)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:252 +0x8a0
github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).PlanAndRun(0xc000100a00, 0x39b3260, 0xc0016553e0, 0xc00182e410, 0xc0017f6780, 0xc0011da240, 0x39b4f20, 0xc00038cbc0, 0xc0011422c0)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:840 +0x227
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execWithDistSQLEngine(0xc00182e000, 0x39b3260, 0xc0016553e0, 0xc00182e350, 0x2, 0x7feb45047ef0, 0xc0015f8210, 0x0, 0x0, 0x0)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1121 +0x283
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).dispatchToExecutionEngine(0xc00182e000, 0x39b3260, 0xc0016553e0, 0xc00182e350, 0x7feb45047ef0, 0xc0015f8210, 0x0, 0x0)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:957 +0x658
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmtInOpenState(0xc00182e000, 0x39b3260, 0xc0016553e0, 0x39b8820, 0xc0010318b0, 0xc000a35691, 0x616, 0x0, 0x0, 0x0, ...)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:459 +0xe03
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt(0xc00182e000, 0x39b3260, 0xc0016553e0, 0x39b8820, 0xc0010318b0, 0xc000a35691, 0x616, 0x0, 0x0, 0x0, ...)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:101 +0x610
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd(0xc00182e000, 0x39b3260, 0xc0016553b0, 0x0, 0x0)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1221 +0x1acf
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).run(0xc00182e000, 0x39b31a0, 0xc0018e1680, 0xc00056d9b8, 0x5400, 0x15000, 0xc00056da50, 0xc000312500, 0x0, 0x0)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1157 +0x1b4
github.com/cockroachdb/cockroach/pkg/sql.(*Server).ServeConn(0xc0009ecb00, 0x39b31a0, 0xc0018e1680, 0xc00182e000, 0x5400, 0x15000, 0xc00056da50, 0xc000312500, 0x0, 0x0)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:437 +0xce
github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).processCommandsAsync.func1(0xc00033b519, 0xc0003b0ba0, 0x39b31a0, 0xc0018e1680, 0xc000312500, 0xc0009ecb00, 0xc000225b00, 0x39b6e60, 0xc0003b0b80, 0xc000b6baa0, ...)
        /home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:581 +0x21f
created by github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).processCommandsAsync

Metadata

Metadata

Assignees

Labels

C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.O-sqlsmith

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions