-
Notifications
You must be signed in to change notification settings - Fork 4.1k
opt: internal error: memo group optimization passes surpassed limit of 100000 #80901
Copy link
Copy link
Closed
Closed
Copy link
Labels
C-test-failureBroken test (automatically or manually discovered).Broken test (automatically or manually discovered).O-roachtestO-robotOriginated from a bot.Originated from a bot.T-sql-queriesSQL Queries TeamSQL Queries Team
Description
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;
This test on roachdash | Improve this report!
Jira issue: CRDB-15462
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
C-test-failureBroken test (automatically or manually discovered).Broken test (automatically or manually discovered).O-roachtestO-robotOriginated from a bot.Originated from a bot.T-sql-queriesSQL Queries TeamSQL Queries Team
Type
Projects
Status
Done