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

pkg/ccl/testccl/sqlccl/sqlccl_test: TestShowCreateRedactableValues failed #121885

Closed
cockroach-teamcity opened this issue Apr 6, 2024 · 1 comment
Closed

pkg/ccl/testccl/sqlccl/sqlccl_test: TestShowCreateRedactableValues failed #121885

cockroach-teamcity opened this issue Apr 6, 2024 · 1 comment
Labels
branch-release-23.1 Used to mark GA and release blockers, technical advisories, and bugs for 23.1 C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. T-sql-queries SQL Queries Team
Milestone
23.1

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Apr 6, 2024 •
edited by cockroach-jira-scripts
Loading

pkg/ccl/testccl/sqlccl/sqlccl_test.TestShowCreateRedactableValues failed with artifacts on release-23.1 @ dca70edc5aaf5f552694a87d1ea56e404eb6528f:

Fatal error:

panic: ReturnType called on TypedExpr with empty typeAnnotation. Was the underlying Expr type-checked before asserting a type of TypedExpr? [recovered]
	panic: ReturnType called on TypedExpr with empty typeAnnotation. Was the underlying Expr type-checked before asserting a type of TypedExpr?

Stack:

goroutine 38513 [running]:
github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).recover(0xc0038a8c78?, {0x74c09e0, 0xc003d8de30})
	github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:229 +0x6a
panic({0x58cdc00, 0xc00658a120})
	GOROOT/src/runtime/panic.go:884 +0x212
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.typeAnnotation.assertTyped(...)
	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/expr.go:153
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*Subquery).TypeCheck(0xc0052b1cf0?, {0x74df098?, 0xc0065b64e0?}, 0xc00a073000?, 0x7492968?)
	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/type_check.go:1506 +0xe5
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*CastExpr).TypeCheck(0xc0065b65a0, {0x74c09e0, 0xc003d8de30}, 0xc0052b1cd8, 0x0?)
	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/type_check.go:586 +0x268
github.com/cockroachdb/cockroach/pkg/sql/catalog/schemaexpr.deserializeExprForFormatting({0x74c09e0, 0xc003d8de30}, {0x75942f0, 0xc000502500}, {0xc000c2def0?, 0x83?}, 0xc000c2def0?, 0x48000)
	github.com/cockroachdb/cockroach/pkg/sql/catalog/schemaexpr/expr.go:339 +0xd6
github.com/cockroachdb/cockroach/pkg/sql/catalog/schemaexpr.formatExprForDisplayImpl({0x74c09e0, 0xc003d8de30}, {0x75942f0?, 0xc000502500?}, {0xc000c2def0?, 0x4?}, 0x22e?, 0xc003dc4700, 0x1761d57?, 0x0)
	github.com/cockroachdb/cockroach/pkg/sql/catalog/schemaexpr/expr.go:294 +0x6b
github.com/cockroachdb/cockroach/pkg/sql/catalog/schemaexpr.FormatExprForDisplay(...)
	github.com/cockroachdb/cockroach/pkg/sql/catalog/schemaexpr/expr.go:251
github.com/cockroachdb/cockroach/pkg/sql.formatViewQueryTypesForDisplay.func1({0x74de490?, 0xc0065b6240})
	github.com/cockroachdb/cockroach/pkg/sql/show_create_clauses.go:271 +0x165
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*simpleVisitor).VisitPre(0xc0016aca80, {0x74de490, 0xc0065b6240})
	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:2025 +0x46
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.WalkExpr({0x74940b0, 0xc0016aca80}, {0x74de490?, 0xc0065b6240})
	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:831 +0x5a
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*ComparisonExpr).Walk(0xc002db4370, {0x74940b0, 0xc0016aca80})
	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:191 +0x3d
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.WalkExpr({0x74940b0, 0xc0016aca80}, {0x74de5a8?, 0xc002db4370})
	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:834 +0x77
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*SelectClause).walkStmt(0xc005f22960, {0x74940b0, 0xc0016aca80})
	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:1722 +0x135
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.walkStmt({0x74940b0, 0xc0016aca80}, {0x74ecc20?, 0xc005f22960})
	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:2010 +0x5d
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*Select).walkStmt(0xc002db43c0, {0x74940b0, 0xc0016aca80})
	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:1626 +0x7d
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.walkStmt({0x74940b0, 0xc0016aca80}, {0x74ecbe0?, 0xc002db43c0})
	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:2010 +0x5d
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.SimpleStmtVisit({0x74ecbe0, 0xc002db43c0}, 0xc00a0728c0)
	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:2057 +0x85
github.com/cockroachdb/cockroach/pkg/sql.formatViewQueryTypesForDisplay({0x74c09e0?, 0xc003d8de30}, 0xc0052b1cd8, 0xc003dc4700, {0x75942f0?, 0xc000502500})
	github.com/cockroachdb/cockroach/pkg/sql/show_create_clauses.go:290 +0x1d6
github.com/cockroachdb/cockroach/pkg/sql.formatViewQueryForDisplay({0x74c09e0, 0xc003d8de30}, 0xc0038a9730?, 0x203002?, {0x75942f0, 0xc000502500}, {0x60, 0x4, 0x0, 0x1, ...})
	github.com/cockroachdb/cockroach/pkg/sql/show_create_clauses.go:175 +0x192
github.com/cockroachdb/cockroach/pkg/sql.ShowCreateView({0x74c09e0, 0xc003d8de30}, 0xc0038a9838?, 0x46115d?, 0x5e14fe0?, {0x75942f0, 0xc000502500}, 0x0)
	github.com/cockroachdb/cockroach/pkg/sql/show_create_clauses.go:144 +0x29f
github.com/cockroachdb/cockroach/pkg/sql.glob..func66({0x74c09e0, 0xc003d8de30}, 0xc0052b1940, {{0xc006044300?, 0x65?}}, {0x75628e0, 0xc005639a20}, {0x7560278, 0xc0087aff40}, {0x75942f0, ...}, ...)
	github.com/cockroachdb/cockroach/pkg/sql/crdb_internal.go:3466 +0x48d
github.com/cockroachdb/cockroach/pkg/sql.makeAllRelationsVirtualTableWithDescriptorIDIndex.func1.1({0x75628e0?, 0xc005639a20?}, {0x7560278?, 0xc0087aff40?}, {0x75942f0?, 0xc000502500?}, 0xc005639a20?)
	github.com/cockroachdb/cockroach/pkg/sql/pg_catalog.go:1170 +0xcf
github.com/cockroachdb/cockroach/pkg/sql.forEachTableDescWithTableLookupInternalFromDescriptors({0x74c09e0, 0xc003d8de30}, 0xc0052b1940, {0x75628e0, 0xc004bfd6b0}, 0x1, 0x0?, {{0xc0007aa7c0}, {0xc0007aa900}, 0x1463d}, ...)
	github.com/cockroachdb/cockroach/pkg/sql/information_schema.go:2667 +0x5a3
github.com/cockroachdb/cockroach/pkg/sql.forEachTableDescWithTableLookupInternal({0x74c09e0, 0xc003d8de30}, 0xc0052b1940, {0x75628e0?, 0xc004bfd6b0}, 0x7ff11904b780?, 0x40?, 0x7ff1458ae5b8?)
	github.com/cockroachdb/cockroach/pkg/sql/information_schema.go:2540 +0x145
github.com/cockroachdb/cockroach/pkg/sql.forEachTableDescWithTableLookup(...)
	github.com/cockroachdb/cockroach/pkg/sql/information_schema.go:2511
github.com/cockroachdb/cockroach/pkg/sql.makeAllRelationsVirtualTableWithDescriptorIDIndex.func1({0x74c09e0, 0xc003d8de30}, 0xc0052b1940, {0x75628e0, 0xc004bfd6b0}, 0xc00282d3c0)
	github.com/cockroachdb/cockroach/pkg/sql/pg_catalog.go:1168 +0x125
github.com/cockroachdb/cockroach/pkg/sql.(*virtualDefEntry).getPlanInfo.func1.1({0x74c09e0, 0xc003d8de30}, {0x7485020?, 0xc003639e20})
	github.com/cockroachdb/cockroach/pkg/sql/virtual_schema.go:682 +0x196
github.com/cockroachdb/cockroach/pkg/sql.setupGenerator.func3({0x74c09e0, 0xc003d8de30})
	github.com/cockroachdb/cockroach/pkg/sql/virtual_table.go:127 +0x114
github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunAsyncTaskEx.func2()
	github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:470 +0x146
created by github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunAsyncTaskEx
	github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:461 +0x43b
Log preceding fatal error 

*   | 	github.com/cockroachdb/cockroach/pkg/sql/catalog/schemaexpr/expr.go:251
*   | github.com/cockroachdb/cockroach/pkg/sql.formatViewQueryTypesForDisplay.func1
*   | 	github.com/cockroachdb/cockroach/pkg/sql/show_create_clauses.go:271
*   | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*simpleVisitor).VisitPre
*   | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:2025
*   | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.WalkExpr
*   | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:831
*   | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*ComparisonExpr).Walk
*   | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:191
*   | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.WalkExpr
*   | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:834
*   | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*SelectClause).walkStmt
*   | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:1722
*   | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.walkStmt
*   | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:2010
*   | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*Select).walkStmt
*   | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:1626
*   | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.walkStmt
*   | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:2010
*   | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.SimpleStmtVisit
*   | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:2057
*   | github.com/cockroachdb/cockroach/pkg/sql.formatViewQueryTypesForDisplay
*   | 	github.com/cockroachdb/cockroach/pkg/sql/show_create_clauses.go:290
*   | github.com/cockroachdb/cockroach/pkg/sql.formatViewQueryForDisplay
*   | 	github.com/cockroachdb/cockroach/pkg/sql/show_create_clauses.go:175
*   | github.com/cockroachdb/cockroach/pkg/sql.ShowCreateView
*   | 	github.com/cockroachdb/cockroach/pkg/sql/show_create_clauses.go:144
*   | github.com/cockroachdb/cockroach/pkg/sql.glob..func66
*   | 	github.com/cockroachdb/cockroach/pkg/sql/crdb_internal.go:3466
*   | github.com/cockroachdb/cockroach/pkg/sql.makeAllRelationsVirtualTableWithDescriptorIDIndex.func1.1
*   | 	github.com/cockroachdb/cockroach/pkg/sql/pg_catalog.go:1170
*   | github.com/cockroachdb/cockroach/pkg/sql.forEachTableDescWithTableLookupInternalFromDescriptors
*   | 	github.com/cockroachdb/cockroach/pkg/sql/information_schema.go:2667
*   | github.com/cockroachdb/cockroach/pkg/sql.forEachTableDescWithTableLookupInternal
*   | 	github.com/cockroachdb/cockroach/pkg/sql/information_schema.go:2540
*   | github.com/cockroachdb/cockroach/pkg/sql.forEachTableDescWithTableLookup
*   | 	github.com/cockroachdb/cockroach/pkg/sql/information_schema.go:2511
*   | github.com/cockroachdb/cockroach/pkg/sql.makeAllRelationsVirtualTableWithDescriptorIDIndex.func1
*   | 	github.com/cockroachdb/cockroach/pkg/sql/pg_catalog.go:1168
*   | github.com/cockroachdb/cockroach/pkg/sql.(*virtualDefEntry).getPlanInfo.func1.1
*   | 	github.com/cockroachdb/cockroach/pkg/sql/virtual_schema.go:682
*   | github.com/cockroachdb/cockroach/pkg/sql.setupGenerator.func3
*   | 	github.com/cockroachdb/cockroach/pkg/sql/virtual_table.go:127
*   | github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunAsyncTaskEx.func2
*   | 	github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:470
*   | runtime.goexit
*   | 	GOROOT/src/runtime/asm_amd64.s:1594
* Wraps: (4) ReturnType called on TypedExpr with empty typeAnnotation. Was the underlying Expr type-checked before asserting a type of TypedExpr?
* Error types: (1) *withstack.withStack (2) *assert.withAssertionFailure (3) *withstack.withStack (4) *errutil.leafError
*

Parameters:

  • TAGS=bazel,gss
Help

See also: How To Investigate a Go Test Failure (internal)

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-37597
@cockroach-teamcity cockroach-teamcity added branch-release-23.1 Used to mark GA and release blockers, technical advisories, and bugs for 23.1 C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. T-sql-queries SQL Queries Team labels Apr 6, 2024
@cockroach-teamcity cockroach-teamcity added this to the 23.1 milestone Apr 6, 2024
@github-project-automation github-project-automation bot moved this to Triage in SQL Queries Apr 6, 2024
@michae2
Copy link
Collaborator

michae2 commented Apr 8, 2024

dup of #112750

@michae2 michae2 closed this as completed Apr 8, 2024
@github-project-automation github-project-automation bot moved this from Triage to Done in SQL Queries Apr 8, 2024
@michae2 michae2 added the X-duplicate Closed as a duplicate of another issue. label Apr 8, 2024
@exalate-issue-sync exalate-issue-sync bot removed the X-duplicate Closed as a duplicate of another issue. label Apr 8, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
branch-release-23.1 Used to mark GA and release blockers, technical advisories, and bugs for 23.1 C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. T-sql-queries SQL Queries Team
Projects
SQL Queries
Archived in project
Milestone
23.1
Development

No branches or pull requests
2 participants
@cockroach-teamcity @michae2