Issue with pg_basebackup v.11

From: Ninad Shah <nshah(dot)postgres(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Issue with pg_basebackup v.11
Date: 2021-10-22 15:40:31
Message-ID: CAOFEiBc21S_CBaw4qHB5S-j3ty00CV21T8SMt8SvYFKEJnFDVA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello experts,

I am facing an issue with a customer's production server while trying to
take backup using pg_basebackup.

Below is the log from pg_basebackup execution.

* 115338208/1304172127 kB (8%), 0/1 tablespace
(...atastaging/base/115868/154220.1)
115355616/1304172127 kB (8%), 0/1 tablespace
(...atastaging/base/115868/154220.1)
115372640/1304172127 kB (8%), 0/1 tablespace
(...atastaging/base/115868/154220.1)
115389568/1304172127 kB (8%), 0/1 tablespace
(...atastaging/base/115868/154220.1)
115405792/1304172127 kB (8%), 0/1 tablespace
(...atastaging/base/115868/154220.1)
115423776/1304172127 kB (8%), 0/1 tablespace
(...atastaging/base/115868/154220.1)
115440640/1304172127 kB (8%), 0/1 tablespace
(...atastaging/base/115868/154220.2)
115454656/1304172127 kB (8%), 0/1 tablespace
(...atastaging/base/115868/154220.2)
pgbasebackup: could not read COPY data: could not receive data from server:
Connection timed out
pgbasebackup: removing contents of data directory
"/u01/PostgreSQL/11/datastaging"*

It copied nearly 110 GB of data and exited. Initially, we suspected it as a
network/OS issue. However, we tried to copy a 150 GB large file over the
network, which finished successfully.

What I observed is that it takes a couple of hours between below 2 lines.

115454656/1304172127 kB (8%), 0/1 tablespace
(...atastaging/base/115868/154220.2)
pgbasebackup: could not read COPY data: could not receive data from server:
Connection timed out

In other words, it run for an hour, and later, it takes 2 hours before it
times out.

Can someone please help me out here?

Regards,
Ninad Shah

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2021-10-22 15:49:28 Re: Looking for a doc section that presents the overload selection rules
Previous Message Laurenz Albe 2021-10-22 15:20:55 Re: [Major version upgrade] pg_upgrade fails despite passing check mode