Re: WIP/PoC for parallel backup

Поиск
Список
Период
Сортировка
От Rajkumar Raghuwanshi
Тема Re: WIP/PoC for parallel backup
Дата
Msg-id CAKcux6=7csjHE=dP3cgxdPxuqDMmSy1YDwrzMJu_ZFSBxSZ37w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: WIP/PoC for parallel backup  (Asif Rehman <asifr.rehman@gmail.com>)
Список pgsql-hackers


On Mon, Mar 16, 2020 at 11:52 AM Asif Rehman <asifr.rehman@gmail.com> wrote:


On Mon, Mar 16, 2020 at 11:08 AM Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com> wrote:
Thanks for the patches.

I have verified reported issues with new patches, issues are fixed now. 

I got another observation where If a new slot name given without -C option, it leads to server crash error.

[edb@localhost bin]$ ./pg_basebackup -p 5432 -j 4 -D /tmp/bkp --slot test_bkp_slot
pg_basebackup: error: could not send replication command "START_REPLICATION": ERROR:  replication slot "test_bkp_slot" does not exist
pg_basebackup: error: could not list backup files: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
pg_basebackup: removing data directory "/tmp/bkp"

It seems to be an expected behavior. The START_BACKUP command has been executed, and
pg_basebackup tries to start a WAL streaming process with a non-existent slot, which results in
an error. So the backup is aborted while terminating all other processes.
I think error message can be improved. current error message looks like database server is crashed.

on PG same is existing with exit 1.
[edb@localhost bin]$ ./pg_basebackup -p 5432 -D /tmp/bkp --slot test_bkp_slot
pg_basebackup: error: could not send replication command "START_REPLICATION": ERROR:  replication slot "test_bkp_slot" does not exist
pg_basebackup: error: child process exited with exit code 1
pg_basebackup: removing data directory "/tmp/bkp"
 


--
Asif Rehman
Highgo Software (Canada/China/Pakistan)
URL : www.highgo.ca

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

Предыдущее
От: Prabhat Sahu
Дата:
Сообщение: Re: [Proposal] Global temporary tables
Следующее
От: Kuntal Ghosh
Дата:
Сообщение: Re: [HACKERS] Moving relation extension locks out of heavyweight lock manager