On 6/3/20 2:32 AM, Sameer Malve wrote:
> Hi Team,
>
> I am seeing in postgresql release notes that below bugs are fix in 9.6.x
> version but unable to find the details for about that bug .
Easiest way I found is to go here:
https://git.postgresql.org/gitweb/?p=postgresql.git
Then go to the tags section and select the tag for the release. So for
the the first item below:
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=518d5492911d445b126e9d5c669a83b5cae43e50
Then click on Log and search for wal_sender_timeout. That leads you to:
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=518d5492911d445b126e9d5c669a83b5cae43e50
"Ignore server-side delays when enforcing wal_sender_timeout.
Healthy clients of servers having poor I/O performance, such as
buildfarm members hamster and tern, saw unexpected timeouts. That
disagreed with documentation. This fix adds one gettimeofday() call
whenever ProcessRepliesIfAny() finds no client reply messages.
Back-patch to 9.4; the bug's symptom is rare and mild, and the code all
moved between 9.3 and 9.4.
Discussion: https://postgr.es/m/20180826034600.GA1105084@rfd.leadboat.com"
>
> _Fixed in 9.6.11_
> _
> _
> Fix unexpected timeouts when using wal_sender_timeout on a slow server
> (Noah Misch) .
>
> _Fixed in 9.6.12_
> _
> _
> 1. A new server parameter data_sync_retry has been added to control
> this; if you are certain that your kernel does not discard dirty data
> buffers in such scenarios, you can set data_sync_retry to on to restore
> the old behavior._
> _
> 2. Fix logic for stopping a subset of WAL senders when synchronous
> replication is enabled
> 3. Make the archiver prioritize WAL history files over WAL data files
> while choosing which file to archive next
>
> _Fixed in 9.6.16_
> _
> _
> Ensure that temporary WAL and history files are removed at the end of
> archive recovery.
>
> Avoid unwanted delay during shutdown of a logical replication walsender. _
> _
>
> _Fixed in 9.6.17_
>
> Fix failure in logical replication publisher after a database crash and
> restart
>
> _Fixed in 9.6.18:_
> _
> _
> This can eliminate many attempts to fetch non-existent WAL files from
> archive storage, which is helpful if archive access is slow._
> _
>
> Regards,
> Sameer Malve
--
Adrian Klaver
adrian.klaver@aklaver.com