Skip to content

roachtest: costfuzz failed #88035

@cockroach-teamcity

Description

@cockroach-teamcity

roachtest.costfuzz failed with artifacts on release-22.2 @ a7b39a0d0155e2571412e0279848bb0f15486c4c:

	query_comparison_util.go:241,query_comparison_util.go:69,costfuzz.go:43,test_runner.go:908: . 8747 statements run: expected unperturbed and perturbed results to be equal
		(1) attached stack trace
		  -- stack trace:
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.(*queryComparisonHelper).makeError
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/query_comparison_util.go:349
		  | [...repeated from below...]
		Wraps: (2) . 8747 statements run
		Wraps: (3) attached stack trace
		  -- stack trace:
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runCostFuzzQuery
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/costfuzz.go:104
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runOneRoundQueryComparison
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/query_comparison_util.go:240
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runQueryComparison
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/query_comparison_util.go:69
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runCostFuzz
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/costfuzz.go:43
		  | main.(*testRunner).runTest.func2
		  | 	main/pkg/cmd/roachtest/test_runner.go:908
		  | runtime.goexit
		  | 	GOROOT/src/runtime/asm_amd64.s:1594
		Wraps: (4) expected unperturbed and perturbed results to be equal
		  |   []string{
		  |   	strings.Join({
		  |   		"NULL,00000000-0000-0000-0000-000000000000,0000-01-01 00:16:40 +0",
		  |   		"000 UTC,-7",
		  | - 		".",
		  |   		"897932553683414752",
		  | - 		"E+2",
		  | + 		"0",
		  |   		"0,0,NULL",
		  |   	}, ""),
		  |   	"NULL,d5d8e3ac-ef69-48d8-a78d-8ccad1e3694f,0000-01-01 00:00:00 +0"...,
		  |   	"NULL,d5d8e3ac-ef69-48d8-a78d-8ccad1e3694f,0000-01-01 00:01:40.00"...,
		  |   	... // 4 identical elements
		  |   }
		  | sql: SELECT
		  | 	tab_10698.col4_10 AS col_32039,
		  | 	tab_10697.col5_10 AS col_32040,
		  | 	tab_10697.col5_2 AS col_32041,
		  | 	tab_10697.col5_16 AS col_32042,
		  | 	0:::OID AS col_32043,
		  | 	tab_10698.col4_13 AS col_32044
		  | FROM
		  | 	defaultdb.public.table5@[0] AS tab_10697
		  | 	LEFT JOIN defaultdb.public.table4@[0] AS tab_10698
		  | 		JOIN defaultdb.public.table4@[0] AS tab_10699 ON
		  | 				(tab_10698.col4_2) = (tab_10699.col4_2) AND (tab_10698.col4_3) = (tab_10699.col4_3) ON
		  | 			(tab_10697.col5_7) = (tab_10699.col4_3) AND (tab_10697.col5_11) = (tab_10699.col4_10)
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *withstack.withStack (4) *errutil.leafError

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-19652

Metadata

Metadata

Assignees

No one assigned

    Labels

    C-test-failureBroken test (automatically or manually discovered).O-roachtestO-robotOriginated from a bot.T-sql-queriesSQL Queries Teambranch-release-22.2Used to mark GA and release blockers, technical advisories, and bugs for 22.2

    Type

    No type

    Projects

    Status

    Done

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions