Subject: Re: BUG #18349: ERROR: invalid DSA memory alloc request size
 1811939328, CONTEXT: parallel worker
To: Andrei Lepikhov <a.lepikhov@postgrespro.ru>,
 Tomas Vondra <tomas.vondra@enterprisedb.com>, pgsql-bugs@lists.postgresql.org
References: <18349-83d33dd3d0c855c3@postgresql.org>
 <512ef568-336e-4087-ba23-f22b006d329d@postgrespro.ru>
 <df93756b-e011-1b09-7bbb-18e6e1ec3ae2@dataegret.com>
 <df297e10-d50f-497d-b278-86a6bce1c44e@enterprisedb.com>
 <7a1f5e5b-632f-4cc5-8078-b18a848e8924@postgrespro.ru>
 <2ff6260b-8722-b301-cf7e-4e66a159778c@dataegret.com>
 <90092199-55cd-4fa3-a608-9a41d8e76c44@postgrespro.ru>
From: Alexey Ermakov <alexey.ermakov@dataegret.com>
Message-ID: <a2f83556-5ef0-ddca-c63d-bbcbf5054335@dataegret.com>
Date: Mon, 11 Mar 2024 14:12:57 +0600
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.0; rv:68.0)
 Gecko/20100101 Thunderbird/68.12.1
MIME-Version: 1.0
In-Reply-To: <90092199-55cd-4fa3-a608-9a41d8e76c44@postgrespro.ru>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-US
Archived-At: 
 <https://www.postgresql.org/message-id/a2f83556-5ef0-ddca-c63d-bbcbf5054335%40dataegret.com>
Precedence: bulk

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