Re: Hot standby, recovery infra

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Hot standby, recovery infra
Дата
Msg-id 498BEF77.2070100@enterprisedb.com
обсуждение исходный текст
Ответ на Re: Hot standby, recovery infra  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: Hot standby, recovery infra
Список pgsql-hackers
Simon Riggs wrote:
> On Thu, 2009-02-05 at 21:54 +0200, Heikki Linnakangas wrote:
>> - If you perform a fast shutdown while startup process is waiting for 
>> the restore command, startup process sometimes throws a FATAL error 
>> which leads escalates into an immediate shutdown. That leads to 
>> different messages in the logs, and skipping of the shutdown 
>> restartpoint that we now otherwise perform.
> 
> Sometimes?

I think what happens is that if the restore command receives the SIGTERM 
and dies before the startup process that's waiting for the restore 
command receives the SIGTERM, the startup process throws a FATAL error 
because the restore command died unexpectedly. I put this

>     if (shutdown_requested && InRedo)
>     {
>         /* XXX: Is EndRecPtr always the right value here? */
>         UpdateMinRecoveryPoint(EndRecPtr);
>         proc_exit(0);
>     }

right after the "system(xlogRestoreCmd)" call, to exit gracefully if we 
were requested to shut down while restore command was running, but it 
seems that that's not enough because of the race condition.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: new GUC var: autovacuum_process_all_tables
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Hot standby, recovery infra