Skip to content

sql: found repro for "adding questionable descriptor 4294867296" #57868

Closed
#58416
Closed
sql: found repro for "adding questionable descriptor 4294867296"#57868
#58416
Assignees
thoszhang
Labels
A-schema-descriptorsRelating to SQL table/db descriptor handling.C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.
@knz

Description

@knz
knz
opened on Dec 12, 2020

Courtesy of the pgx go driver:

$ ./cockroach demo --empty --logtostderr=WARNING

> SELECT t.oid, t.typname
  FROM pg_type AS t
  JOIN pg_type AS base_type ON t.typelem = base_type.oid
 WHERE (t.typtype = 'b') AND (base_type.typtype = 'e');
W201212 22:57:42.309093 2021 sql/catalog/lease/lease.go:1651  adding questionable descriptor 4294867296 to lease manager: &{{{{0 0}} {[]} false 0} 0xc000d98cf0 4294867296 0} goroutine 2021 [running]:
runtime/debug.Stack(0x878e60, 0xc0012bea40, 0xc0fffe7960)
        /usr/local/go/src/runtime/debug/stack.go:24 +0x9f
github.com/cockroachdb/cockroach/pkg/sql/catalog/lease.(*Manager).findDescriptorState(0xc0012fc640, 0x1fffe7960, 0x0)
        /data/home/kena/src/go/src/github.com/cockroachdb/cockroach/pkg/sql/catalog/lease/lease.go:1650 +0x1a5
github.com/cockroachdb/cockroach/pkg/sql/catalog/lease.(*Manager).Acquire(0xc0012fc640, 0x18e39c0, 0xc000987f80, 0x16501a306fd47660, 0x0, 0xfffe7960, 0x0, 0x0, 0x8, 0x9, ...)
        /data/home/kena/src/go/src/github.com/cockroachdb/cockroach/pkg/sql/catalog/lease/lease.go:1535 +0x45
github.com/cockroachdb/cockroach/pkg/sql/catalog/descs.(*Collection).getDescriptorVersionByID(0xc0004d6210, 0x18e39c0, 0xc000987f80, 0xc00076ecf0, 0xfffe7960, 0xc001180100, 0xc00118a6c0, 0x1934901, 0xc0006b9510, 0x36e9425)
        /data/home/kena/src/go/src/github.com/cockroachdb/cockroach/pkg/sql/catalog/descs/collection.go:759 +0x2ea
github.com/cockroachdb/cockroach/pkg/sql/catalog/descs.(*Collection).GetTypeVersionByID(0xc0004d6210, 0x18e39c0, 0xc000987f80, 0xc00076ecf0, 0xc0fffe7960, 0x0, 0x0, 0x0, 0x0, 0x1, ...)
        /data/home/kena/src/go/src/github.com/cockroachdb/cockroach/pkg/sql/catalog/descs/collection.go:1138 +0x85
github.com/cockroachdb/cockroach/pkg/sql.glob..func140(0x18e39c0, 0xc000987f80, 0x1a2d160, 0xc00118a6c0, 0xc0004d63c0, 0xc0028ff980, 0xc00152a100, 0x0, 0x14, 0xc0024d4d80)
        /data/home/kena/src/go/src/github.com/cockroachdb/cockroach/pkg/sql/pg_catalog.go:2376 +0x23c
github.com/cockroachdb/cockroach/pkg/sql.(*virtualDefEntry).makeConstrainedRowsGenerator.func1(0x1852b20, 0xc000570d80, 0x4, 0xc0012be340)
        /data/home/kena/src/go/src/github.com/cockroachdb/cockroach/pkg/sql/virtual_schema.go:586 +0x4a2
github.com/cockroachdb/cockroach/pkg/sql.(*vTableLookupJoinNode).Next(0xc000570d80, 0x18e39c0, 0xc000987f80, 0xc00079cdc0, 0xc0004d63c0, 0x0, 0x12beb80, 0xc001e56060)
        /data/home/kena/src/go/src/github.com/cockroachdb/cockroach/pkg/sql/virtual_table.go:305 +0x51c
github.com/cockroachdb/cockroach/pkg/sql.(*planNodeToRowSource).Next(0xc000527800, 0xc0004d63c0, 0x18e6540, 0xc000570d80, 0x0)
        /data/home/kena/src/go/src/github.com/cockroachdb/cockroach/pkg/sql/plan_node_to_row_source.go:173 +0x447
github.com/cockroachdb/cockroach/pkg/sql/execinfra.Run(0x18e39c0, 0xc000987f80, 0x1909e80, 0xc000527800, 0x18ba4c0, 0xc002ae2000)
        /data/home/kena/src/go/src/github.com/cockroachdb/cockroach/pkg/sql/execinfra/base.go:171 +0x35
github.com/cockroachdb/cockroach/pkg/sql/execinfra.(*ProcessorBase).Run(0xc000527800, 0x18e39c0, 0xc000987f80)
        /data/home/kena/src/go/src/github.com/cockroachdb/cockroach/pkg/sql/execinfra/processorsbase.go:765 +0x92
github.com/cockroachdb/cockroach/pkg/sql/flowinfra.(*FlowBase).Run(0xc000570fc0, 0x18e39c0, 0xc000987f80, 0x12bdf98, 0x0, 0x0)
        /data/home/kena/src/go/src/github.com/cockroachdb/cockroach/pkg/sql/flowinfra/flow.go:392 +0x24b
github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).Run(0xc001957600, 0xc001e3d0a0, 0xc00076ecf0, 0xc00111fc80, 0xc002ae3180, 0xc0004d65c8, 0x0, 0x0)
        /data/home/kena/src/go/src/github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:384 +0x469
github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).PlanAndRun(0xc001957600, 0x18e3a80, 0xc002a53bf0, 0xc0004d65c8, 0xc001e3d0a0, 0xc00076ecf0, 0x18e5e80, 0xc0018ad9a0, 0x0, 0xc002ae3180, ...)
        /data/home/kena/src/go/src/github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:977 +0x1d2
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execWithDistSQLEngine(0xc0004d6000, 0x18e3a80, 0xc002a53bf0, 0xc0004d63c0, 0x3, 0x831094810, 0xc000f6c680, 0xc0006ba300, 0xc001c92958, 0x0, ...)
        /data/home/kena/src/go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:997 +0x3aa
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).dispatchToExecutionEngine(0xc0004d6000, 0x18e3a80, 0xc002a53bf0, 0xc0004d63c0, 0x831094810, 0xc000f6c680, 0x0, 0x0)
        /data/home/kena/src/go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:876 +0x706
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmtInOpenState(0xc0004d6000, 0x18e3a80, 0xc002a53bf0, 0x19021c0, 0xc000fe0050, 0xc000462160, 0x96, 0x0, 0x2, 0x0, ...)
        /data/home/kena/src/go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:631 +0xf46
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt(0xc0004d6000, 0x18e3a80, 0xc002a53bc0, 0x19021c0, 0xc000fe0050, 0xc000462160, 0x96, 0x0, 0x2, 0x0, ...)
        /data/home/kena/src/go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:119 +0xb14
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd.func1(0x19021c0, 0xc000fe0050, 0xc000462160, 0x96, 0x0, 0x2, 0x125d9588, 0xed76741e6, 0x0, 0x125da214, ...)
        /data/home/kena/src/go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1445 +0x225
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd(0xc0004d6000, 0x18e3a80, 0xc002a53bc0, 0x0, 0x0)
        /data/home/kena/src/go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1447 +0x13f7
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).run(0xc0004d6000, 0x18e39c0, 0xc002a48440, 0xc000fd43c0, 0x5400, 0x15000, 0xc000fd4460, 0xc002ae14f0, 0x0, 0x0)
        /data/home/kena/src/go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1372 +0x1cd
github.com/cockroachdb/cockroach/pkg/sql.(*Server).ServeConn(0xc000a91700, 0x18e39c0, 0xc002a48440, 0xc0004d6000, 0x5400, 0x15000, 0xc000fd4460, 0xc002ae14f0, 0x0, 0x0)
        /data/home/kena/src/go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:481 +0xce
github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).processCommandsAsync.func1(0xc001c281ed, 0xc001696fa0, 0x18e39c0, 0xc002a48440, 0xc002ae14f0, 0xc000a91700, 0xc000f6c000, 0x1943ae0, 0xc0028f7480, 0xc000ffe600, ...)
        /data/home/kena/src/go/src/github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:628 +0x3ea
created by github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).processCommandsAsync
        /data/home/kena/src/go/src/github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:556 +0x185

cc @ajwerner @rafiss for triage

Metadata

Metadata

Assignees

Labels

A-schema-descriptorsRelating to SQL table/db descriptor handling.C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions