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

internal/sqlsmith: TestGenerateParse failed #73783

Closed
cockroach-teamcity opened this issue Dec 14, 2021 · 3 comments
Closed

internal/sqlsmith: TestGenerateParse failed #73783

cockroach-teamcity opened this issue Dec 14, 2021 · 3 comments
Labels
branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. T-sql-queries SQL Queries Team

Comments

@cockroach-teamcity
Copy link
Member

internal/sqlsmith.TestGenerateParse failed with artifacts on master @ 5cd5be83218475ef0cc3c62a856b8d9d22cf142b:

        	/go/src/github.com/cockroachdb/cockroach/pkg/sql/sem/tree/expr.go:613 +0x1da
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.NewTypedComparisonExpr({0x4369100, 0x0}, {0x62c2900, 0xc004220e40}, {0x62c2900, 0xc004220e70})
        	/go/src/github.com/cockroachdb/cockroach/pkg/sql/sem/tree/expr.go:527 +0xef
        github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.makeEquiJoinExpr(0xc0048da540, {0x0, 0x0, 0x0}, 0xe)
        	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/relational.go:238 +0x2c5
        github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.makeTableExpr(0xc0048da540, {0x0, 0x0, 0x0}, 0x10)
        	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/relational.go:144 +0xb0
        github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.(*Smither).makeSelectClause(0xc0048da540, {0xc000115340, 0x1, 0x1}, {0x0, 0x0, 0x0}, {0x0, 0x0, 0x0})
        	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/relational.go:521 +0x276
        github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.makeSelectClause(0x0, {0xc000115340, 0xc0063faf18, 0x1}, {0x0, 0xc000115340, 0x8be4220}, {0x0, 0x0, 0x0})
        	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/relational.go:501 +0x46
        github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.(*Smither).makeSelectStmt(0xc0048da540, {0xc000115340, 0x1, 0x1}, {0x0, 0x0, 0x0}, {0x0, 0x0, 0x0})
        	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/relational.go:28 +0x129
        github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.(*Smither).makeWith(0xc0048da540)
        	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/relational.go:385 +0x1a5
        github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.(*Smither).makeSelect(0x203000, {0xc0063fb188, 0x1, 0x1}, {0x0, 0x0, 0x0})
        	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/relational.go:724 +0x66
        github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.makeScalarSubquery(0xc0063fb1d0, 0x8be5960, {0x0, 0x10000c006813327, 0xc003deb4d0})
        	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/scalar.go:694 +0x65
        github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.scalarNoContext.func1(0xc002cad860, {0x30, 0x0}, 0xc000d8bb90, {0x0, 0xc0063fb238, 0xc0063fb238})
        	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/scalar.go:60 +0x2f
        github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.makeScalarSample(0xc00593c040, 0xc0048da540, {0x90167e0, 0xa8}, 0x13fbdfb, {0x0, 0x0, 0x0})
        	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/scalar.go:104 +0x152
        github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.makeScalarContext(...)
        	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/scalar.go:71
        github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.makeScalar(...)
        	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/scalar.go:67
        github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.makeValues(0xc0048da540, {0xc0058ccdc0, 0x3, 0x4ac4a20}, {0x0, 0x0, 0x0})
        	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/relational.go:1064 +0x537
        github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.makeValuesSelect(0x0, {0xc0058ccdc0, 0xc0063fb420, 0x3}, {0x0, 0xc0058ccdc0, 0x8be5960}, {0x0, 0x0, 0x0})
        	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/relational.go:1100 +0x2d
        github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.(*Smither).makeSelectStmt(0xc0048da540, {0xc0058ccdc0, 0x3, 0x4}, {0x0, 0x0, 0x0}, {0x0, 0x0, 0x0})
        	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/relational.go:34 +0xad
        github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.(*Smither).makeWith(0xc0048da540)
        	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/relational.go:385 +0x1a5
        github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.(*Smither).makeSelect(0x0, {0x0, 0x0, 0x0}, {0x0, 0x0, 0x0})
        	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/relational.go:724 +0x66
        github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.makeSelect(0xc0048da540)
        	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/relational.go:679 +0x45
        github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.(*Smither).makeStmt(0xc0048da540)
        	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/relational.go:20 +0x35
        github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.(*Smither).Generate(0x6203620)
        	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/sqlsmith.go:158 +0x31
        github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.TestGenerateParse(0xc001510820)
        	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/sqlsmith_test.go:184 +0x786
        testing.tRunner(0xc001510820, 0x5202540)
        	/usr/local/go/src/testing/testing.go:1259 +0x102
        created by testing.(*T).Run
        	/usr/local/go/src/testing/testing.go:1306 +0x35a
--- FAIL: TestGenerateParse (0.26s)
Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)Parameters in this failure:

  • GOFLAGS=-parallel=4

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!
@cockroach-teamcity cockroach-teamcity added branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. labels Dec 14, 2021
@blathers-crl blathers-crl bot added the T-sql-queries SQL Queries Team label Dec 14, 2021
@cockroach-teamcity
Copy link
Member Author

internal/sqlsmith.TestGenerateParse failed with artifacts on master @ 5cd5be83218475ef0cc3c62a856b8d9d22cf142b:

			(128716462:::OID, 755278948:::OID),
			(2368004113:::OID, 1796259358:::OID),
			(2044934044:::OID, 2131921440:::OID)
	)
		AS tab_159 (col_239, col_240)
ORDER BY
	tab_159.col_240
LIMIT
	81:::INT8;

STMT: 35
ROLLBACK TRANSACTION;

    panic.go:1038: lookup for ComparisonExpr ((((tab_162.col_247)[??? tab_162.col_247]))[void] = (((tab_167.col_256)[??? tab_167.col_256]))[void])[bool]'s CmpOp failed
        goroutine 690996 [running]:
        runtime/debug.Stack()
        	/usr/local/go/src/runtime/debug/stack.go:24 +0x65
        github.com/cockroachdb/cockroach/pkg/util/leaktest.AfterTest.func1()
        	/go/src/github.com/cockroachdb/cockroach/pkg/util/leaktest/leaktest.go:110 +0x11f
        panic({0x4706c60, 0xc00b585280})
        	/usr/local/go/src/runtime/panic.go:1038 +0x215
        github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).Stop(0xc0060965a0, {0x6294780, 0xc000074108})
        	/go/src/github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:551 +0x389
        panic({0x4706c60, 0xc00b585280})
        	/usr/local/go/src/runtime/panic.go:1038 +0x215
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*ComparisonExpr).memoizeFn(0xc009ef6140)
        	/go/src/github.com/cockroachdb/cockroach/pkg/sql/sem/tree/expr.go:613 +0x1da
        github.com/cockroachdb/cockroach/pkg/sql/sem/tree.NewTypedComparisonExpr({0x43714e0, 0x0}, {0x62cd5e0, 0xc004c6e450}, {0x62cd5e0, 0xc004c6e510})
        	/go/src/github.com/cockroachdb/cockroach/pkg/sql/sem/tree/expr.go:527 +0xef
        github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.makeEquiJoinExpr(0xc00a7a1c00, {0x0, 0x0, 0x0}, 0xe)
        	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/relational.go:238 +0x2c5
        github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.makeTableExpr(0xc00a7a1c00, {0x0, 0x0, 0x0}, 0xd0)
        	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/relational.go:144 +0xb0
        github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.(*Smither).makeSelectClause(0xc00a7a1c00, {0x0, 0x0, 0x0}, {0x0, 0x0, 0x0}, {0x0, 0x0, 0x0})
        	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/relational.go:521 +0x276
        github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.(*Smither).makeSelect(0xc0094edd90, {0x0, 0x0, 0x0}, {0x0, 0x0, 0x0})
        	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/relational.go:726 +0xb9
        github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.makeSelect(0xc00a7a1c00)
        	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/relational.go:679 +0x45
        github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.(*Smither).makeStmt(0xc00a7a1c00)
        	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/relational.go:20 +0x35
        github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.(*Smither).Generate(0x6207ea0)
        	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/sqlsmith.go:158 +0x31
        github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.TestGenerateParse(0xc00a643860)
        	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/sqlsmith_test.go:184 +0x786
        testing.tRunner(0xc00a643860, 0x520a158)
        	/usr/local/go/src/testing/testing.go:1259 +0x102
        created by testing.(*T).Run
        	/usr/local/go/src/testing/testing.go:1306 +0x35a
--- FAIL: TestGenerateParse (0.77s)
Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)Parameters in this failure:

  • TAGS=deadlock

  • GOFLAGS=-parallel=4

This test on roachdash | Improve this report!

@rharding6373
Copy link
Collaborator

rharding6373 commented Dec 14, 2021 •
edited
Loading

Error lookup for ComparisonExpr ((((tab_162.col_247)[??? tab_162.col_247]))[void] = (((tab_167.col_256)[??? tab_167.col_256]))[void])[bool]'s CmpOp failed looks like a dupe of #73777

@rharding6373
Copy link
Collaborator

Duplicate of #73777

@rharding6373 rharding6373 marked this as a duplicate of #73777 Dec 14, 2021
@mgartner mgartner moved this to Done in SQL Queries Jul 24, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. T-sql-queries SQL Queries Team
Projects
SQL Queries
Archived in project
Milestone
No milestone
Development

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