pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres Replication stopped
4+ messages / 3 participants
[nested] [flat]
* Postgres Replication stopped
@ 2019-06-10 06:24 Mahmoud Moharam <mmoharam@lucidya.com>
2019-06-10 06:31 ` Re: Postgres Replication stopped Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
0 siblings, 1 reply; 4+ messages in thread
From: Mahmoud Moharam @ 2019-06-10 06:24 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>; pgsql-admin
Hi All ,
I faced some issues on postgres replication as it was stopped with these
errors :-
LOG: unexpected EOF on client connection with an open transaction
LOG: could not send data to client: Broken pipe
FATAL: connection to client lost
on DB Master
thanks in advance
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Postgres Replication stopped
2019-06-10 06:24 Postgres Replication stopped Mahmoud Moharam <mmoharam@lucidya.com>
@ 2019-06-10 06:31 ` Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
2019-06-10 07:20 ` Re: Postgres Replication stopped Mahmoud Moharam <mmoharam@lucidya.com>
0 siblings, 1 reply; 4+ messages in thread
From: Alvaro Aguayo Garcia-Rada @ 2019-06-10 06:31 UTC (permalink / raw)
To: Mahmoud Moharam <mmoharam@lucidya.com>; +Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>; pgsql-admin
That seems like a connection issue. Is the connection ovr a LAN? Or a VPN? There might have been some interruption, from a damaged cable to an isp problem
Regards,
Alvaro Aguayo
Operations Manager
Open Comb Systems E.I.R.L.
(+51-1) 337-7813 Ext. 4002
www.ocs.pe
----- Original Message -----
From: "Mahmoud Moharam" <mmoharam@lucidya.com>
To: "pgsql-admin" <pgsql-admin@lists.postgresql.org>, "pgsql-admin" <pgsql-admin@postgresql.org>
Sent: Monday, 10 June, 2019 01:24:26
Subject: Postgres Replication stopped
Hi All ,
I faced some issues on postgres replication as it was stopped with these
errors :-
LOG: unexpected EOF on client connection with an open transaction
LOG: could not send data to client: Broken pipe
FATAL: connection to client lost
on DB Master
thanks in advance
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Postgres Replication stopped
2019-06-10 06:24 Postgres Replication stopped Mahmoud Moharam <mmoharam@lucidya.com>
2019-06-10 06:31 ` Re: Postgres Replication stopped Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
@ 2019-06-10 07:20 ` Mahmoud Moharam <mmoharam@lucidya.com>
2019-06-10 15:35 ` Re: Postgres Replication stopped Lev Kokotov <lev.kokotov@instacart.com>
0 siblings, 1 reply; 4+ messages in thread
From: Mahmoud Moharam @ 2019-06-10 07:20 UTC (permalink / raw)
To: Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>; +Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>; pgsql-admin
Thanks for your kind reply
I found this log too
LOG: checkpoints are occurring too frequently (28 seconds apart)
HINT: Consider increasing the configuration parameter "max_wal_size"
On Mon, Jun 10, 2019 at 8:31 AM Alvaro Aguayo Garcia-Rada <
aaguayo@opensysperu.com> wrote:
> That seems like a connection issue. Is the connection ovr a LAN? Or a VPN?
> There might have been some interruption, from a damaged cable to an isp
> problem
>
> Regards,
>
> Alvaro Aguayo
> Operations Manager
> Open Comb Systems E.I.R.L.
>
> (+51-1) 337-7813 Ext. 4002
> www.ocs.pe
>
> ----- Original Message -----
> From: "Mahmoud Moharam" <mmoharam@lucidya.com>
> To: "pgsql-admin" <pgsql-admin@lists.postgresql.org>, "pgsql-admin" <
> pgsql-admin@postgresql.org>
> Sent: Monday, 10 June, 2019 01:24:26
> Subject: Postgres Replication stopped
>
> Hi All ,
>
> I faced some issues on postgres replication as it was stopped with these
> errors :-
>
> LOG: unexpected EOF on client connection with an open transaction
> LOG: could not send data to client: Broken pipe
> FATAL: connection to client lost
> on DB Master
>
> thanks in advance
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Postgres Replication stopped
2019-06-10 06:24 Postgres Replication stopped Mahmoud Moharam <mmoharam@lucidya.com>
2019-06-10 06:31 ` Re: Postgres Replication stopped Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
2019-06-10 07:20 ` Re: Postgres Replication stopped Mahmoud Moharam <mmoharam@lucidya.com>
@ 2019-06-10 15:35 ` Lev Kokotov <lev.kokotov@instacart.com>
0 siblings, 0 replies; 4+ messages in thread
From: Lev Kokotov @ 2019-06-10 15:35 UTC (permalink / raw)
To: Mahmoud Moharam <mmoharam@lucidya.com>; +Cc: Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>; pgsql-admin
That second one is because your "max_wal_size" is too small. Increase it so
your checkpoints do not happen more often than your your
"checkpoint_timeout" setting.
- Lev
On Mon, Jun 10, 2019, 12:20 AM Mahmoud Moharam, <mmoharam@lucidya.com>
wrote:
> Thanks for your kind reply
> I found this log too
>
> LOG: checkpoints are occurring too frequently (28 seconds apart)
> HINT: Consider increasing the configuration parameter "max_wal_size"
>
>
> On Mon, Jun 10, 2019 at 8:31 AM Alvaro Aguayo Garcia-Rada <
> aaguayo@opensysperu.com> wrote:
>
>> That seems like a connection issue. Is the connection ovr a LAN? Or a
>> VPN? There might have been some interruption, from a damaged cable to an
>> isp problem
>>
>> Regards,
>>
>> Alvaro Aguayo
>> Operations Manager
>> Open Comb Systems E.I.R.L.
>>
>> (+51-1) 337-7813 Ext. 4002
>> www.ocs.pe
>>
>> ----- Original Message -----
>> From: "Mahmoud Moharam" <mmoharam@lucidya.com>
>> To: "pgsql-admin" <pgsql-admin@lists.postgresql.org>, "pgsql-admin" <
>> pgsql-admin@postgresql.org>
>> Sent: Monday, 10 June, 2019 01:24:26
>> Subject: Postgres Replication stopped
>>
>> Hi All ,
>>
>> I faced some issues on postgres replication as it was stopped with these
>> errors :-
>>
>> LOG: unexpected EOF on client connection with an open transaction
>> LOG: could not send data to client: Broken pipe
>> FATAL: connection to client lost
>> on DB Master
>>
>> thanks in advance
>>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2019-06-10 15:35 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-06-10 06:24 Postgres Replication stopped Mahmoud Moharam <mmoharam@lucidya.com>
2019-06-10 06:31 ` Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
2019-06-10 07:20 ` Mahmoud Moharam <mmoharam@lucidya.com>
2019-06-10 15:35 ` Lev Kokotov <lev.kokotov@instacart.com>
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