Insert into generate series repeat crash

[SaitTalhaNisanci]

 CREATE TABLE no_index_cleanup (i INT PRIMARY KEY, t TEXT);
select create_distributed_table('no_index_cleanup','i');
INSERT INTO no_index_cleanup(i, t) VALUES (generate_series(1,30),
    repeat('1234567890',269));

Program received signal SIGABRT, Aborted.
__GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
51 ../sysdeps/unix/sysv/linux/raise.c: No such file or directory.
(gdb) where
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
#1 0x00007f5b53b92801 in __GI_abort () at abort.c:79
#2 0x000055eb98453c96 in ExceptionalCondition (
conditionName=conditionName@entry=0x7f5b51201848 "!(currentPlan->fastPathRouterPlan || !EnableFastPathRouterPlanner)", errorType=errorType@entry=0x7f5b511f23e3 "FailedAssertion",
fileName=fileName@entry=0x7f5b512016a5 "executor/citus_custom_scan.c",
lineNumber=lineNumber@entry=347) at assert.c:54
#3 0x00007f5b5117aeef in CitusBeginModifyScan (node=node@entry=0x55eb98bf83c0,
estate=estate@entry=0x55eb98bf8138, eflags=eflags@entry=0) at executor/citus_custom_scan.c:347
#4 0x00007f5b5117aff5 in CitusBeginScan (node=0x55eb98bf83c0, estate=0x55eb98bf8138, eflags=0)
at executor/citus_custom_scan.c:196
#5 0x000055eb981abdd8 in ExecInitCustomScan (cscan=cscan@entry=0x55eb98beb178,
estate=estate@entry=0x55eb98bf8138, eflags=eflags@entry=0) at nodeCustom.c:103
#6 0x000055eb98199e95 in ExecInitNode (node=node@entry=0x55eb98beb178,
estate=estate@entry=0x55eb98bf8138, eflags=eflags@entry=0) at execProcnode.c:282
#7 0x000055eb98193eba in InitPlan (queryDesc=queryDesc@entry=0x55eb98b84f88,
eflags=eflags@entry=0) at execMain.c:1020
#8 0x000055eb9819406c in standard_ExecutorStart (queryDesc=queryDesc@entry=0x55eb98b84f88,
eflags=eflags@entry=0) at execMain.c:266
#9 0x00007f5b511800bf in CitusExecutorStart (queryDesc=0x55eb98b84f88, eflags=0)
at executor/multi_executor.c:123
#10 0x00007f5b4b04f729 in pgss_ExecutorStart (queryDesc=0x55eb98b84f88, eflags=)
at pg_stat_statements.c:853
#11 0x000055eb98194164 in ExecutorStart (queryDesc=queryDesc@entry=0x55eb98b84f88,
eflags=eflags@entry=0) at execMain.c:146
#12 0x000055eb9832079d in ProcessQuery (plan=plan@entry=0x55eb98beb4a0,
sourceText=, params=0x0, queryEnv=0x0, dest=dest@entry=0x55eb98beb710,
completionTag=completionTag@entry=0x7ffd7ed8e540 "") at pquery.c:156
#13 0x000055eb98320999 in PortalRunMulti (portal=portal@entry=0x55eb98b42788,
isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false,
dest=dest@entry=0x55eb98beb710, altdest=altdest@entry=0x55eb98beb710,
completionTag=completionTag@entry=0x7ffd7ed8e540 "") at pquery.c:1283
#14 0x000055eb98321920 in PortalRun (portal=portal@entry=0x55eb98b42788,
count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true,
run_once=run_once@entry=true, dest=dest@entry=0x55eb98beb710,
altdest=altdest@entry=0x55eb98beb710, completionTag=0x7ffd7ed8e540 "") at pquery.c:796
#15 0x000055eb9831d9c6 in exec_simple_query (
query_string=query_string@entry=0x55eb98a6bcc8 "INSERT INTO no_index_cleanup(i, t) VALUES (generate_series(1,30),\n repeat('1234567890',269));") at postgres.c:1215
#16 0x000055eb9831fa78 in PostgresMain (argc=, argv=argv@entry=0x55eb98b087f8,
dbname=, username=) at postgres.c:4247
#17 0x000055eb9828ed15 in BackendRun (port=port@entry=0x55eb98b06430) at postmaster.c:4448
#18 0x000055eb982921b0 in BackendStartup (port=port@entry=0x55eb98b06430) at postmaster.c:4139
#19 0x000055eb982924cf in ServerLoop () at postmaster.c:1704

[metdos]

Tentatively adding Citus 10 milestone

[onderkalaci]

@SaitTalhaNisanci does it crash when asserts disabled? Because in this example we are hitting an assertion failure.

[onurctirtir]

same as #4091

[SaitTalhaNisanci]

Yeah they look same

[SaitTalhaNisanci]

same as #4091