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 <diptat...@gmail.com> 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

Reply via email to