From: Alexey Ermakov <alexey.ermakov@dataegret.com>
To: Andrei Lepikhov <a.lepikhov@postgrespro.ru>
To: Tomas Vondra <tomas.vondra@enterprisedb.com>
To: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18349: ERROR: invalid DSA memory alloc request size 1811939328, CONTEXT: parallel worker
Date: Mon, 11 Mar 2024 14:12:57 +0600
Message-ID: <a2f83556-5ef0-ddca-c63d-bbcbf5054335@dataegret.com> (raw)
In-Reply-To: <90092199-55cd-4fa3-a608-9a41d8e76c44@postgrespro.ru>
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: alexey.ermakov@dataegret.com, a.lepikhov@postgrespro.ru, tomas.vondra@enterprisedb.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18349: ERROR: invalid DSA memory alloc request size 1811939328, CONTEXT: parallel worker
In-Reply-To: <a2f83556-5ef0-ddca-c63d-bbcbf5054335@dataegret.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox