From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC in pg_wal "No space left on device"
Date: Sat, 17 Nov 2018 12:51:42 +0200
Message-ID: <50f45df3-e4f6-0038-3f6a-902c570898ba@matrix.gatewaynet.com> (raw)
In-Reply-To: <3631323B-8B6B-410E-9B08-D5877D99304A@crazybean.net>
References: <ae8812c3-d138-73b7-537a-a273e15ef6e1@matrix.gatewaynet.com>
<838a3914-a078-88eb-ee5e-4059b7d14620@matrix.gatewaynet.com>
<0BBC4BB3-4A59-4040-B065-82D09268A4F7@crazybean.net>
<48415b2a-ea0f-cf5e-1145-17e8797a6e79@matrix.gatewaynet.com>
<739822AC-E20F-493B-8B4F-8AF78A8276D0@crazybean.net>
<c0651fcb-95e9-3fe8-ce34-122c5090c826@matrix.gatewaynet.com>
<946FBD41-7BAF-4414-8FB9-C0F16A0680F6@crazybean.net>
<e501a748-5a39-9c15-6e79-5aae8c47fb28@matrix.gatewaynet.com>
<52EE6BE4-73B4-4BDB-9CDF-1F1C099BA0AD@crazybean.net>
<e7581f2a-5c1b-a3be-7b22-88dea4c5aeeb@matrix.gatewaynet.com>
<3631323B-8B6B-410E-9B08-D5877D99304A@crazybean.net>
On 16/11/18 5:36 μ.μ., Rui DeSousa wrote:
>
>> On Nov 16, 2018, at 3:18 AM, Achilleas Mantzios <achill@matrix.gatewaynet.com> wrote:
>>
>>> net.inet.tcp.always_keepalive=1
>> This setting is from FreeBSD. I have tested changing the settings on my PostgreSQL 11.1 on my FreeBSD 11.2-RELEASE-p3, and this would have no effect at all to the postgresql settings, they remained all three of them at zero.
> That setting is not going to change Postgresql settings it’s not possible; however, it overrides the connection and forces TCP keep alive even if the application attempts to disable it. If you would to watch the connection you see the keep alive packets.
Note : this is just a small parenthesis to the search for the cause of
the problem.
So I changed all three settings in POSTGRESQL 11.1 (by ALTER SYSTEM +
pg_ctl restart) which runs on a FreeBSD 11 and none of those seemed to
have changed, via SHOW or :
postgres# select name,setting from pg_settings where name ~* 'keepalive';
name | setting
-------------------------+---------
tcp_keepalives_count | 0
tcp_keepalives_idle | 0
tcp_keepalives_interval | 0
(3 rows)
repeated the test on a Linux machine with PostgreSQL 10.5, guess what,
same outcome, it seems that both FreeBSD and Linux trust the OS for
those settings.
Docs don't imply this behavior, docs say that if those values are set to
0 then the OS values are used.
>
>> This is completely irrelevant with my problem but anyway.
> You have network related issue and this would detect and resolve the issue without fixing the network issue. You have to fix at least one or both of them.
I mean FreeBSD is irrelevant with the problem. Problem was on Linux.
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-admin@postgresql.org
Cc: achill@matrix.gatewaynet.com, pgsql-admin@lists.postgresql.org
Subject: Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC in pg_wal "No space left on device"
In-Reply-To: <50f45df3-e4f6-0038-3f6a-902c570898ba@matrix.gatewaynet.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