Re: [ADMIN] Problems rebuilding slave using pg_basebackup

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: [ADMIN] Problems rebuilding slave using pg_basebackup
Дата
Msg-id 1510144112.2752.24.camel@cybertec.at
обсуждение исходный текст
Ответ на [ADMIN] Problems rebuilding slave using pg_basebackup  (Douglas Reed <douglas@fsbtech.com>)
Список pgsql-admin
Douglas Reed wrote:
> We are having a number of problems when we attempt to rebuild our  slave from its master
> 
> We have made about three attempts without success (using a proven set of notes)
> 
> It's been rebuilt several times over the last few months although the time between 
> pg_basebackup being keyed and it actually copying data can be up to six minutes. 
> And after completion the time taken from database startup to psql availability 
> can also be several minutes while it processes any remaining logs.
> 
> Both machines are virtuals and are based with a leading cloud provider
> 
> OS Linux Centos6 (6.8 Final)
> 
> pg version 9.5.4

[...]

> Message from pg_basebackup
> 
>     [postgres@xxxxxxxxxx]$ pg_basebackup -h -IP_HIDDEN- -D /var/lib/pgsql/9.5/data -P -U postgres
--xlog-method=stream
>     pg_basebackup: could not receive data from WAL stream: server closed the connection unexpectedly
>         This probably means the server terminated abnormally
>         before or while processing the request.
>     269061959/269164935 kB (99%), 1/1 tablespace
>     pg_basebackup: child process exited with error 1
> 
> 
> Relevant error messages from master's log
> 
>     Nov  7 11:52:32 o8-data1 postgres[28558]: [6-1] user=[unknown],db=[unknown],app=[unknown]client=-IP_HIDDEN- LOG:
connectionreceived: host=-IP_HIDDEN- port=41498
 
>     Nov  7 11:52:32 o8-data1 postgres[28558]: [7-1] user=postgres,db=[unknown],app=[unknown]client=-IP_HIDDEN- LOG:
replicationconnection authorized: user=postgres
 
>     Nov  7 13:51:44 o8-data1 postgres[28558]: [8-1] user=postgres,db=[unknown],app=pg_basebackupclient=-IP_HIDDEN-
LOG: could not send data to client: Broken pipe
 
>     Nov  7 13:51:44 o8-data1 postgres[28558]: [9-1] user=postgres,db=[unknown],app=pg_basebackupclient=-IP_HIDDEN-
ERROR: base backup could not send data, aborting backup
 
>     Nov  7 13:51:44 o8-data1 postgres[28558]: [10-1] user=postgres,db=[unknown],app=pg_basebackupclient=-IP_HIDDEN-
FATAL: connection to client lost
 
>     Nov  7 13:51:44 o8-data1 postgres[28558]: [11-1] user=postgres,db=[unknown],app=pg_basebackupclient=-IP_HIDDEN-
LOG: disconnection: session time: 1:59:11.943 user=postgres database= host=-IP_HIDDEN- port=41498
 
> 
>     Nov  7 13:54:48 o8-data1 postgres[35445]: [6-1] user=[unknown],db=[unknown],app=[unknown]client=-IP_HIDDEN- LOG:
connectionreceived: host=-IP_HIDDEN- port=44040
 
>     Nov  7 13:54:48 o8-data1 postgres[35445]: [7-1] user=postgres,db=[unknown],app=[unknown]client=-IP_HIDDEN- LOG:
replicationconnection authorized: user=postgres
 
>     Nov  7 15:09:20 o8-data1 postgres[35445]: [8-1] user=postgres,db=[unknown],app=pg_basebackupclient=-IP_HIDDEN-
LOG: could not send data to client: Broken pipe
 
>     Nov  7 15:09:20 o8-data1 postgres[35445]: [9-1] user=postgres,db=[unknown],app=pg_basebackupclient=-IP_HIDDEN-
ERROR: base backup could not send data, aborting backup
 
>     Nov  7 15:09:20 o8-data1 postgres[35445]: [10-1] user=postgres,db=[unknown],app=pg_basebackupclient=-IP_HIDDEN-
FATAL: connection to client lost
 
>     Nov  7 15:09:20 o8-data1 postgres[35445]: [11-1] user=postgres,db=[unknown],app=pg_basebackupclient=-IP_HIDDEN-
LOG: disconnection: session time: 1:14:31.925 user=postgres database= host=-IP_HIDDEN- port=44040
 

Both client and server complain that the peer has gone away.

That means that the network connection got interrupted.

Either you do not have a reliable TCP connection, or some in-between firewall
terminates the connection.

Yours,
Laurenz Albe


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

В списке pgsql-admin по дате отправления:

Предыдущее
От: Payal Singh
Дата:
Сообщение: Re: [ADMIN] Problems rebuilding slave using pg_basebackup
Следующее
От: Douglas Reed
Дата:
Сообщение: Re: [ADMIN] Problems rebuilding slave using pg_basebackup