Re: Logical Replication 08P01 invalid memory alloc request size 1095736448

public inbox for [email protected]  
help / color / mirror / Atom feed

From: Soni M <[email protected]>
To: [email protected]
Subject: Re: Logical Replication 08P01 invalid memory alloc request size 1095736448
Date: Sun, 6 Jul 2025 19:41:06 +0700
Message-ID: <CAAMgDXkDwz-c+hNWe-RtB2eUNCT8kWxEY3LWDfd14je8oczWOA@mail.gmail.com> (raw)
In-Reply-To: <CAAMgDXkrDTZwo3v=vcGd0=axjEg9BV09LL=f2+n=DShFBmAV9Q@mail.gmail.com>
References: <CAAMgDXkrDTZwo3v=vcGd0=axjEg9BV09LL=f2+n=DShFBmAV9Q@mail.gmail.com>

Some updates :
Checking at lsn_diff from 33D44/EF3219B0 to 33D45/373C2D98,
 pg_wal_lsn_diff
-----------------
      1208620008
which is quite different to memory alloc request 1095736448.

Digging deeper into debug messages :

DEBUG,00000,"find_in_dynamic_libpath: trying
""/usr/pgsql-15/lib/libpqwalreceiver""",,,,,,,,,"","logical replication
worker",,0
DEBUG,00000,"find_in_dynamic_libpath: trying
""/usr/pgsql-15/lib/libpqwalreceiver.so""",,,,,,,,,"","logical replication
worker",,0
DEBUG,00000,"InitPostgres",,,,,,,,,"","logical replication worker",,0
DEBUG,00000,"my backend ID is 3",,,,,,,,,"","logical replication worker",,0
DEBUG,00000,"StartTransaction(1) name: unnamed; blockState: DEFAULT; state:
INPROGRESS, xid/subid/cid: 0/1/0",,,,,,,,,"","logical replication worker",,0
DEBUG,00000,"CommitTransaction(1) name: unnamed; blockState: STARTED;
state: INPROGRESS, xid/subid/cid: 0/1/0",,,,,,,,,"","logical replication
worker",,0
DEBUG,00000,"StartTransaction(1) name: unnamed; blockState: DEFAULT; state:
INPROGRESS, xid/subid/cid: 0/1/0",,,,,,,,,"","logical replication worker",,0
LOG,00000,"logical replication apply worker for subscription
""consprod_subscription"" has started",,,,,,,,,"","logical replication
worker",,0
DEBUG,00000,"CommitTransaction(1) name: unnamed; blockState: STARTED;
state: INPROGRESS, xid/subid/cid: 0/1/0",,,,,,,,,"","logical replication
worker",,0
DEBUG,00000,"connecting to publisher using connection string
""host=10.2.5.43 port=5432 user=replicator
dbname=consprod""",,,,,,,,,"","logical replication worker",,0
DEBUG,00000,"StartTransaction(1) name: unnamed; blockState: DEFAULT; state:
INPROGRESS, xid/subid/cid: 0/1/0",,,,,,,,,"","logical replication worker",,0
DEBUG,00000,"CommitTransaction(1) name: unnamed; blockState: STARTED;
state: INPROGRESS, xid/subid/cid: 0/1/0",,,,,,,,,"","logical replication
worker",,0
DEBUG,00000,"logical replication apply worker for subscription
""consprod_subscription"" two_phase is DISABLED",,,,,,,,,"","logical
replication worker",,0
DEBUG,00000,"sending feedback (force 0) to recv 33D45/373C2D98, write
33D45/373C2D98, flush 33D45/373C2D98",,,,,,,,,"","logical replication
worker",,0
DEBUG,00000,"StartTransaction(1) name: unnamed; blockState: DEFAULT; state:
INPROGRESS, xid/subid/cid: 0/1/0",,,,,,,,,"","logical replication worker",,0
DEBUG,00000,"CommitTransaction(1) name: unnamed; blockState: STARTED;
state: INPROGRESS, xid/subid/cid: 0/1/0",,,,,,,,,"","logical replication
worker",,0
DEBUG,00000,"sending feedback (force 0) to recv 33D45/373C2D98, write
33D45/373C2D98, flush 33D45/373C2D98",,,,,,,,,"","logical replication
worker",,0
ERROR,08P01,"could not receive data from WAL stream: ERROR:  invalid memory
alloc request size 1095736448",,,,,,,,,"","logical replication worker",,0
DEBUG,00000,"shmem_exit(1): 5 before_shmem_exit callbacks to
make",,,,,,,,,"","logical replication worker",,0
DEBUG,00000,"shmem_exit(1): 7 on_shmem_exit callbacks to
make",,,,,,,,,"","logical replication worker",,0
DEBUG,00000,"proc_exit(1): 1 callbacks to make",,,,,,,,,"","logical
replication worker",,0
DEBUG,00000,"exit(1)",,,,,,,,,"","logical replication worker",,0
DEBUG,00000,"shmem_exit(-1): 0 before_shmem_exit callbacks to
make",,,,,,,,,"","logical replication worker",,0
DEBUG,00000,"shmem_exit(-1): 0 on_shmem_exit callbacks to
make",,,,,,,,,"","logical replication worker",,0
DEBUG,00000,"proc_exit(-1): 0 callbacks to make",,,,,,,,,"","logical
replication worker",,0
LOG,00000,"background worker ""logical replication worker"" (PID 62160)
exited with exit code 1",,,,,,,,,"","postmaster",,0

Please help

On Sun, Jul 6, 2025 at 4:40 PM Soni M <[email protected]> wrote:

> Hello All,
> we have this set up :
> Postgres 15.13 on RHEL 9.6
>
> Logical Master also have 2 streaming replica
> Logical Replica also have 1 streaming replica
>
> We just do patch updates from 15.12 to 15.13, restart Logical Master and
> then Logical Replica, and suddenly Logical replication stops working.
> Streaming replication of both are fine.
>
> The message on Logical Replica :
> ERROR,08P01,"could not receive data from WAL stream: ERROR:  invalid
> memory alloc request size 1095736448",,,,,,,,,"","logical replication
> worker",,0
>
> The message on Logical Master :
> "START_REPLICATION", LOG,00000,"starting logical decoding for slot
> ""_subscription""","Streaming transactions committing after 33D45/373C2D98,
> reading WAL from 33D44/EF3219B0.",,,,,"START_REPLICATION SLOT
> ""_subscription"" LOGICAL 33D45/373C2D98 (proto_version '3',
> publication_names '""_publication""')",,,"_subscription","walsender",,0
>
> "START_REPLICATION", ,LOG,00000,"logical decoding found consistent point
> at 33D44/EF3219B0","Logical decoding will begin using saved
> snapshot.",,,,,"START_REPLICATION SLOT ""_subscription"" LOGICAL
> 33D45/373C2D98 (proto_version '3', publication_names
> '""_publication""')",,,"_subscription","walsender",,0
>
> Checking at error code 08P01 is protocol_violation.
>
> Is there any idea on what causing this and how to resolve ?
>
> --
> Regards,
>
> Soni Maula Harriz
>


-- 
Regards,

Soni Maula Harriz

view thread (3+ messages)  latest in thread

reply

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: [email protected]
  Cc: [email protected]
  Subject: Re: Logical Replication 08P01 invalid memory alloc request size 1095736448
  In-Reply-To: <CAAMgDXkDwz-c+hNWe-RtB2eUNCT8kWxEY3LWDfd14je8oczWOA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox