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
