Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

sql: scary warning log when reading crdb_internal.create_statements #83351

Closed
ajwerner opened this issue Jun 24, 2022 · 3 comments · Fixed by #83421
Closed

sql: scary warning log when reading crdb_internal.create_statements #83351

ajwerner opened this issue Jun 24, 2022 · 3 comments · Fixed by #83421
Labels
C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.

Comments

@ajwerner
Copy link
Contributor

ajwerner commented Jun 24, 2022 •
edited by cockroach-jira-scripts
Loading

Describe the problem
I think this is fallout from the 32-bit OID change (#82568).

W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144  error deserializing user defined types for view ‹ranges› (4294967248): ‹crdb_internal.range_stats›(): column ‹"start_key"› does not exist
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +(1) candidate pg code: 22023
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +Wraps: (2) attached stack trace
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  -- stack trace:
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*FuncExpr).TypeCheck
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/type_check.go:1040
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.typeCheckOverloadedExprs
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/overload.go:635
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/type_check.go:310
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*ParenExpr).TypeCheck
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/type_check.go:1334
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*CastExpr).TypeCheck
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/type_check.go:572
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.TypeCheck
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/type_check.go:266
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql.formatViewQueryTypesForDisplay.func1
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/show_create_clauses.go:218
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*simpleVisitor).VisitPre
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:1710
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.WalkExpr
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:824
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).Walk
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:68
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.WalkExpr
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:827
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*SelectClause).walkStmt
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:1397
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.walkStmt
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:1695
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*Select).walkStmt
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:1321
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.walkStmt
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:1695
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.SimpleStmtVisit
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:1742
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql.formatViewQueryTypesForDisplay
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/show_create_clauses.go:248
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql.formatViewQueryForDisplay
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/show_create_clauses.go:162
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql.ShowCreateView
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/show_create_clauses.go:131
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql.glob..func37
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/crdb_internal.go:2594
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql.makeAllRelationsVirtualTableWithDescriptorIDIndex.func1.1
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/pg_catalog.go:1085
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql.forEachTableDescWithTableLookupInternalFromDescriptors.func1
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/information_schema.go:2426
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql.forEachTableDescWithTableLookupInternalFromDescriptors
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/information_schema.go:2436
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql.forEachTableDescWithTableLookupInternal
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/information_schema.go:2364
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql.forEachTableDescWithTableLookup
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/information_schema.go:2314
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql.makeAllRelationsVirtualTableWithDescriptorIDIndex.func1
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/pg_catalog.go:1083
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql.(*virtualDefEntry).getPlanInfo.func1.1
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/virtual_schema.go:573
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql.setupGenerator.func3
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/virtual_table.go:127
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunAsyncTaskEx.func2
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:494
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +Wraps: (3) ‹crdb_internal.range_stats›()
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +Wraps: (4) candidate pg code: 42703
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +Wraps: (5) attached stack trace
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  -- stack trace:
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*ColumnItem).TypeCheck
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/type_check.go:1354
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*UnresolvedName).TypeCheck
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/type_check.go:1373
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.typeCheckOverloadedExprs
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/overload.go:635
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*FuncExpr).TypeCheck
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/type_check.go:1038
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.typeCheckOverloadedExprs
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/overload.go:635
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/type_check.go:310
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*ParenExpr).TypeCheck
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/type_check.go:1334
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*CastExpr).TypeCheck
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/type_check.go:572
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.TypeCheck
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/type_check.go:266
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql.formatViewQueryTypesForDisplay.func1
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/show_create_clauses.go:218
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*simpleVisitor).VisitPre
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:1710
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.WalkExpr
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:824
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).Walk
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:68
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.WalkExpr
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:827
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*SelectClause).walkStmt
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:1397
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.walkStmt
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:1695
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*Select).walkStmt
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:1321
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.walkStmt
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:1695
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.SimpleStmtVisit
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:1742
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql.formatViewQueryTypesForDisplay
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/show_create_clauses.go:248
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql.formatViewQueryForDisplay
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/show_create_clauses.go:162
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql.ShowCreateView
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/show_create_clauses.go:131
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql.glob..func37
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/crdb_internal.go:2594
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql.makeAllRelationsVirtualTableWithDescriptorIDIndex.func1.1
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/pg_catalog.go:1085
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql.forEachTableDescWithTableLookupInternalFromDescriptors.func1
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/information_schema.go:2426
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql.forEachTableDescWithTableLookupInternalFromDescriptors
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/information_schema.go:2436
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql.forEachTableDescWithTableLookupInternal
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/information_schema.go:2364
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql.forEachTableDescWithTableLookup
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/information_schema.go:2314
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql.makeAllRelationsVirtualTableWithDescriptorIDIndex.func1
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/pg_catalog.go:1083
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql.(*virtualDefEntry).getPlanInfo.func1.1
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/virtual_schema.go:573
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/sql.setupGenerator.func3
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/sql/virtual_table.go:127
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunAsyncTaskEx.func2
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +  | 	github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:494
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +Wraps: (6) column ‹"start_key"› does not exist
W220624 19:56:35.015463 19589 sql/show_create_clauses.go:164 ⋮ [n1,client=127.0.0.1:57011,user=root] 144 +Error types: (1) *pgerror.withCandidateCode (2) *withstack.withStack (3) *errutil.withPrefix (4) *pgerror.withCandidateCode (5) *withstack.withStack (6) *errutil.leafError

To Reproduce

select * from crdb_internal.create_statements; and look in the logs.

Expected behavior
No warnings.

Jira issue: CRDB-17020
@ajwerner ajwerner added the C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. label Jun 24, 2022
@ajwerner
Copy link
Contributor Author

@rafiss maybe you have ideas about what's going on?

@rafiss
Copy link
Collaborator

rafiss commented Jun 27, 2022

This looks more like fallout from the fix to stop ignoring the error from SimpleStmtVisitor #82763

@rafiss rafiss mentioned this issue Jun 27, 2022
Merged
@ajwerner
Copy link
Contributor Author

Thanks for having a look!

@craig craig bot closed this as completed in 264cd04 Jul 6, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

sql: fix error log spam from SHOW CREATE rafiss/cockroach
2 participants
@rafiss @ajwerner