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.16k stars 3.82k forks source link

pgwire: v23.2.10: error in argument for $1: unsupported OID 2283 with format code FormatBinary #132273

Open cockroach-sentry opened 1 month ago

cockroach-sentry commented 1 month ago

This issue was auto filed by Sentry. It represents a crash or reported error on a live cluster with telemetry enabled.

Sentry Link: https://cockroach-labs.sentry.io/issues/5976537485/?referrer=webhooks_plugin

Panic Message:

encoding.go:865: error in argument for $1: unsupported OID 2283 with format code FormatBinary
(1) ×
Wraps: (2) ×
Wraps: (3) candidate pg code: 08P01
Wraps: (4) attached stack trace
  -- stack trace:
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execBind.func2
  |     github.com/cockroachdb/cockroach/pkg/sql/conn_executor_prepare.go:501
  | [...repeated from below...]
Wraps: (5) error in argument for $1
Wraps: (6) assertion failure
Wraps: (7) attached stack trace
  -- stack trace:
  | github.com/cockroachdb/cockroach/pkg/sql/pgwire/pgwirebase.DecodeDatum
  |     github.com/cockroachdb/cockroach/pkg/sql/pgwire/pgwirebase/encoding.go:865
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execBind.func2
  |     github.com/cockroachdb/cockroach/pkg/sql/conn_executor_prepare.go:493
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execBind
  |     github.com/cockroachdb/cockroach/pkg/sql/conn_executor_prepare.go:510
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd
  |     github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:2401
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).run
  |     github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:2185
  | github.com/cockroachdb/cockroach/pkg/sql.(*Server).ServeConn
  |     github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:969
  | github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).processCommands
  |     github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:247
  | github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*Server).serveImpl.func3
  |     github.com/cockroachdb/cockroach/pkg/sql/pgwire/server.go:1002
  | runtime.goexit
  |     src/runtime/asm_amd64.s:1650
Wraps: (8) unsupported OID 2283 with format code FormatBinary
Error types: (1) *hintdetail.withDetail (2) *hintdetail.withDetail (3) *pgerror.withCandidateCode (4) *withstack.withStack (5) *errutil.withPrefix (6) *assert.withAssertionFailure (7) *withstack.withStack (8) *errutil.leafError
-- report composition:
*errutil.leafError: unsupported OID 2283 with format code FormatBinary
encoding.go:865: *withstack.withStack (top exception)
*assert.withAssertionFailure
*errutil.withPrefix: error in argument for $1
conn_executor_prepare.go:501: *withstack.withStack (1)
*pgerror.withCandidateCode: 08P01
*hintdetail.withDetail
*hintdetail.withDetail
(check the extra data payloads)
Stacktrace (expand for inline code snippets): [src/runtime/asm_amd64.s#L1649-L1651](src/runtime/asm_amd64.s#L1649-L1651) [https://github.com/cockroachdb/cockroach/blob/7b9d20d87208db1ac6c24b68b73c742eb9b1168d/pkg/sql/pgwire/server.go#L1001-L1003](https://github.com/cockroachdb/cockroach/blob/7b9d20d87208db1ac6c24b68b73c742eb9b1168d/pkg/sql/pgwire/server.go#L1001-L1003) [https://github.com/cockroachdb/cockroach/blob/7b9d20d87208db1ac6c24b68b73c742eb9b1168d/pkg/sql/pgwire/conn.go#L246-L248](https://github.com/cockroachdb/cockroach/blob/7b9d20d87208db1ac6c24b68b73c742eb9b1168d/pkg/sql/pgwire/conn.go#L246-L248) [https://github.com/cockroachdb/cockroach/blob/7b9d20d87208db1ac6c24b68b73c742eb9b1168d/pkg/sql/conn_executor.go#L968-L970](https://github.com/cockroachdb/cockroach/blob/7b9d20d87208db1ac6c24b68b73c742eb9b1168d/pkg/sql/conn_executor.go#L968-L970) [https://github.com/cockroachdb/cockroach/blob/7b9d20d87208db1ac6c24b68b73c742eb9b1168d/pkg/sql/conn_executor.go#L2184-L2186](https://github.com/cockroachdb/cockroach/blob/7b9d20d87208db1ac6c24b68b73c742eb9b1168d/pkg/sql/conn_executor.go#L2184-L2186) [https://github.com/cockroachdb/cockroach/blob/7b9d20d87208db1ac6c24b68b73c742eb9b1168d/pkg/sql/conn_executor.go#L2400-L2402](https://github.com/cockroachdb/cockroach/blob/7b9d20d87208db1ac6c24b68b73c742eb9b1168d/pkg/sql/conn_executor.go#L2400-L2402) [https://github.com/cockroachdb/cockroach/blob/7b9d20d87208db1ac6c24b68b73c742eb9b1168d/pkg/sql/conn_executor_prepare.go#L509-L511](https://github.com/cockroachdb/cockroach/blob/7b9d20d87208db1ac6c24b68b73c742eb9b1168d/pkg/sql/conn_executor_prepare.go#L509-L511) [https://github.com/cockroachdb/cockroach/blob/7b9d20d87208db1ac6c24b68b73c742eb9b1168d/pkg/sql/conn_executor_prepare.go#L500-L502](https://github.com/cockroachdb/cockroach/blob/7b9d20d87208db1ac6c24b68b73c742eb9b1168d/pkg/sql/conn_executor_prepare.go#L500-L502) [src/runtime/asm_amd64.s#L1649-L1651](src/runtime/asm_amd64.s#L1649-L1651) [https://github.com/cockroachdb/cockroach/blob/7b9d20d87208db1ac6c24b68b73c742eb9b1168d/pkg/sql/pgwire/server.go#L1001-L1003](https://github.com/cockroachdb/cockroach/blob/7b9d20d87208db1ac6c24b68b73c742eb9b1168d/pkg/sql/pgwire/server.go#L1001-L1003) [https://github.com/cockroachdb/cockroach/blob/7b9d20d87208db1ac6c24b68b73c742eb9b1168d/pkg/sql/pgwire/conn.go#L246-L248](https://github.com/cockroachdb/cockroach/blob/7b9d20d87208db1ac6c24b68b73c742eb9b1168d/pkg/sql/pgwire/conn.go#L246-L248) [https://github.com/cockroachdb/cockroach/blob/7b9d20d87208db1ac6c24b68b73c742eb9b1168d/pkg/sql/conn_executor.go#L968-L970](https://github.com/cockroachdb/cockroach/blob/7b9d20d87208db1ac6c24b68b73c742eb9b1168d/pkg/sql/conn_executor.go#L968-L970) [https://github.com/cockroachdb/cockroach/blob/7b9d20d87208db1ac6c24b68b73c742eb9b1168d/pkg/sql/conn_executor.go#L2184-L2186](https://github.com/cockroachdb/cockroach/blob/7b9d20d87208db1ac6c24b68b73c742eb9b1168d/pkg/sql/conn_executor.go#L2184-L2186) [https://github.com/cockroachdb/cockroach/blob/7b9d20d87208db1ac6c24b68b73c742eb9b1168d/pkg/sql/conn_executor.go#L2400-L2402](https://github.com/cockroachdb/cockroach/blob/7b9d20d87208db1ac6c24b68b73c742eb9b1168d/pkg/sql/conn_executor.go#L2400-L2402) [https://github.com/cockroachdb/cockroach/blob/7b9d20d87208db1ac6c24b68b73c742eb9b1168d/pkg/sql/conn_executor_prepare.go#L509-L511](https://github.com/cockroachdb/cockroach/blob/7b9d20d87208db1ac6c24b68b73c742eb9b1168d/pkg/sql/conn_executor_prepare.go#L509-L511) [https://github.com/cockroachdb/cockroach/blob/7b9d20d87208db1ac6c24b68b73c742eb9b1168d/pkg/sql/conn_executor_prepare.go#L492-L494](https://github.com/cockroachdb/cockroach/blob/7b9d20d87208db1ac6c24b68b73c742eb9b1168d/pkg/sql/conn_executor_prepare.go#L492-L494) [https://github.com/cockroachdb/cockroach/blob/7b9d20d87208db1ac6c24b68b73c742eb9b1168d/pkg/sql/pgwire/pgwirebase/encoding.go#L864-L866](https://github.com/cockroachdb/cockroach/blob/7b9d20d87208db1ac6c24b68b73c742eb9b1168d/pkg/sql/pgwire/pgwirebase/encoding.go#L864-L866) 
src/runtime/asm_amd64.s in runtime.goexit at line 1650
pkg/sql/pgwire/server.go in pkg/sql/pgwire.(*Server).serveImpl.func3 at line 1002
pkg/sql/pgwire/conn.go in pkg/sql/pgwire.(*conn).processCommands at line 247
pkg/sql/conn_executor.go in pkg/sql.(*Server).ServeConn at line 969
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).run at line 2185
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).execCmd at line 2401
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).execBind at line 510
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).execBind.func2 at line 501
src/runtime/asm_amd64.s in runtime.goexit at line 1650
pkg/sql/pgwire/server.go in pkg/sql/pgwire.(*Server).serveImpl.func3 at line 1002
pkg/sql/pgwire/conn.go in pkg/sql/pgwire.(*conn).processCommands at line 247
pkg/sql/conn_executor.go in pkg/sql.(*Server).ServeConn at line 969
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).run at line 2185
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).execCmd at line 2401
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).execBind at line 510
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).execBind.func2 at line 493
pkg/sql/pgwire/pgwirebase/encoding.go in pkg/sql/pgwire/pgwirebase.DecodeDatum at line 865

Tags

Tag Value
Command server
Environment v23.2.10
Go Version go1.21.12 X:nocoverageredesign
Platform linux amd64
Distribution CCL
Cockroach Release v23.2.10
Cockroach SHA 7b9d20d87208db1ac6c24b68b73c742eb9b1168d
# of CPUs 12
# of Goroutines 557

Jira issue: CRDB-42911

fqazi commented 1 day ago

The OID in question maps back to T_anyelement in this scenario