Skip to content

opt: internal error: memo group optimization passes surpassed limit of 100000 #80901

@cockroach-teamcity

Description

@cockroach-teamcity

roachtest.sqlsmith/setup=rand-tables/setting=no-ddl failed with artifacts on release-22.1.0 @ 120fbbb2cb4bdd071c1835f29d5364953752a5bd:

The test failed on branch=release-22.1.0, cloud=gce:
test artifacts and logs in: /artifacts/sqlsmith/setup=rand-tables/setting=no-ddl/run_1
	sqlsmith.go:265,sqlsmith.go:304,test_runner.go:875: error: pq: internal error: memo group optimization passes surpassed limit of 100000; there may be a cycle in the memo
		stmt:
		SELECT
			tab_42922.col2_6 AS col_94144,
			tab_42922.col2_13 AS col_94145,
			NULL AS col_94146,
			tab_42921.col1_11 AS col_94147,
			postgis_wagyu_version()::STRING AS col_94148,
			'218.76.152.122/9':::INET AS col_94149,
			tab_42921.col1_3 AS col_94150,
			tab_42921.col1_2 AS col_94151,
			tab_42921.col1_6 AS col_94152,
			e'\\G':::STRING AS col_94153,
			tab_42921.tableoid AS col_94154,
			tab_42921.tableoid AS col_94155,
			(
				SELECT
					B'10' AS col_94156
				FROM
					defaultdb.public.table1@table1_col1_7_col1_3_col1_17_col1_12_col1_2_col1_9_col1_15_idx AS tab_42923
					JOIN defaultdb.public.table1@[0] AS tab_42924
						JOIN defaultdb.public.table1@table1_col1_12_col1_0_col1_17_expr_col1_8_col1_11_col1_4_col1_7_col1_1_expr1_col1_16_col1_10_col1_14_col1_13_col1_3_idx
								AS tab_42927
							LEFT JOIN defaultdb.public.table3@[0] AS tab_42928 ON tab_42921.col1_7
							JOIN defaultdb.public.table3@table3_col3_9_col3_3_idx AS tab_42929 ON
									(tab_42927.col1_9) = (tab_42929.col3_2) ON
								(tab_42924.col1_17) = (tab_42927.col1_15)
								AND (tab_42924.col1_12) = (tab_42929.col3_9)
								AND (tab_42924.col1_14) = (tab_42928.col3_9)
								AND (tab_42924.col1_14) = (tab_42929.col3_9)
								AND (tab_42924.col1_11) = (tab_42927.col1_17)
								AND (tab_42924.col1_11) = (tab_42927.col1_16)
								AND (tab_42924.col1_15) = (tab_42929.col3_9)
								AND (tab_42924.col1_5) = (tab_42929.crdb_internal_mvcc_timestamp) ON
							(tab_42923.col1_12) = (tab_42927.col1_16),
					defaultdb.public.table1@table1_col1_6_idx AS tab_42930
				WHERE
					tab_42924.col1_7
				LIMIT
					1:::INT8
			)
				AS col_94157
		FROM
			defaultdb.public.table1@table1_col1_1_col1_0_key AS tab_42921, defaultdb.public.table2@[0] AS tab_42922
		LIMIT
			42:::INT8;
Help

See: roachtest README

See: How To Investigate (internal)

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-15462

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

Status

Done

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions