From: | Aleš Zelený <zeleny(dot)ales(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Logical replication - ERROR: could not send data to WAL stream: cannot allocate memory for input buffer |
Date: | 2020-06-05 20:57:46 |
Message-ID: | CAODqTUYjnuctV-bCh=WO6a7s4qyjoQd=6DbsnO7Av62UC4ovJQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
we are using logical replication for more than 2 years and today I've found
new not yet know error message from wal receiver. The replication was in
catchup mode (on publisher side some new tables were created and added to
publication, on subscriber side they were missing).
RDBMS version:PostgreSQL 11.4 (Ubuntu 11.4-1.pgdg18.04+1) on
x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.4.0-1ubuntu1~18.04.1) 7.4.0,
64-bit
OS: Ubuntu 18.04.2 LTS
RDBMS was installed from pgdg packages.
The error message:
2020-06-05 20:00:08 UTC 19753 5edaa378.4d29 2 0 540/1132087
[XX000]:ERROR: could not send data to WAL stream: cannot allocate memory
for input buffer
2020-06-05 20:00:08 UTC 867 5df8a0b4.363 28613 0 [00000]:LOG:
background worker "logical replication worker" (PID 19753) exited with
exit code 1
Repeated several times, finally it proceeded and switch into streaming
state. The OS has 64GB RAM, OS + database instance are using usually 20GB
rest is used as OS buffers. I've checked monitoring (sampled every 10
seconds) and no memory usage peak was visible, so unless it was a very
short memory usage peak, I'd not expect the system running out of memory.
Is there something I can do to diagnose and avoid this issue?
Thanks Ales
From | Date | Subject | |
---|---|---|---|
Next Message | Vasu Madhineni | 2020-06-06 03:56:55 | Re: Multitenent architecture |
Previous Message | Peter Eisentraut | 2020-06-05 20:54:12 | Re: Logical Replication and table bloat |