Re: BUG #18349: ERROR: invalid DSA memory alloc request size 1811939328, CONTEXT: parallel worker

On 2024-03-01 18:48, Andrei Lepikhov wrote:
> Could you provide a backtrace at the moment of the error? It can show
> us exact place of the error without guesses.

Hello. Уes, you are right about ExecParallelHashJoinSetUpBatches.
Backtrace looks like this:

========parallel worker
Breakpoint 1, 0x0000000000a2f1e0 in errfinish ()
(gdb) bt
#0  0x0000000000a2f1e0 in errfinish ()
#1  0x0000000000515d06 in dsa_allocate_extended.cold ()
#2  0x000000000071abdc in ExecParallelHashJoinSetUpBatches ()
#3  0x000000000071bd03 in ExecParallelHashIncreaseNumBatches ()
#4  0x000000000071c50d in ExecParallelHashTableInsert ()
#5  0x000000000071c6fa in MultiExecHash ()
#6  0x000000000071ecd1 in ExecParallelHashJoin.lto_priv.0 ()
#7  0x00000000006f8dc2 in standard_ExecutorRun ()
#8  0x00007f860667cf75 in pgss_ExecutorRun () from
/usr/pgsql-16/lib/pg_stat_statements.so
#9  0x00007f8606271cad in pgsk_ExecutorRun () from
/usr/pgsql-16/lib/pg_stat_kcache.so
#10 0x00000000006fdd36 in ParallelQueryMain ()
#11 0x00000000005b1ca2 in ParallelWorkerMain ()
#12 0x000000000083072c in StartBackgroundWorker ()
#13 0x000000000083a177 in maybe_start_bgworkers.lto_priv ()
#14 0x000000000083b7f4 in ServerLoop.lto_priv.0 ()
#15 0x0000000000833b6d in PostmasterMain ()
#16 0x000000000051c221 in main ()

=======backend
Breakpoint 1, 0x0000000000a2f1e0 in errfinish ()
(gdb) bt
#0  0x0000000000a2f1e0 in errfinish ()
#1  0x00000000005b12e8 in HandleParallelMessages ()
#2  0x00000000008c74f5 in ProcessInterrupts.part.0 ()
#3  0x00000000008b0715 in ConditionVariableTimedSleep.part.0 ()
#4  0x000000000089ea85 in BarrierArriveAndWait ()
#5  0x000000000071b9e7 in ExecParallelHashIncreaseNumBatches ()
#6  0x000000000071c255 in ExecParallelHashTupleAlloc ()
#7  0x000000000071c449 in ExecParallelHashTableInsert ()
#8  0x000000000071c6fa in MultiExecHash ()
#9  0x000000000071ecd1 in ExecParallelHashJoin.lto_priv.0 ()
#10 0x0000000000718124 in ExecGather ()
#11 0x00000000006f8dc2 in standard_ExecutorRun ()
#12 0x00007f860667cf75 in pgss_ExecutorRun () from
/usr/pgsql-16/lib/pg_stat_statements.so
#13 0x00007f8606271cad in pgsk_ExecutorRun () from
/usr/pgsql-16/lib/pg_stat_kcache.so
#14 0x00000000008c8ba6 in PortalRunSelect ()
#15 0x00000000008ca556 in PortalRun ()
#16 0x00000000008cb5e0 in exec_simple_query ()
#17 0x00000000008cd96f in PostgresMain ()
#18 0x000000000083d174 in ServerLoop.lto_priv.0 ()
#19 0x0000000000833b6d in PostmasterMain ()
#20 0x000000000051c221 in main ()

Would you like to get any additional info from gdb (like number of
batches) ?

--

Thanks,

Alexey Ermakov