Re: URGENT issue: pg-xlog growing on master!

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: URGENT issue: pg-xlog growing on master!
Дата
Msg-id CAMkU=1zf9jbmY7D_oof59qbecx=DJr_gGg2MOW_9QQQ7GvQO2g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: URGENT issue: pg-xlog growing on master!  (Niels Kristian Schjødt <nielskristian@autouncle.com>)
Ответы Re: URGENT issue: pg-xlog growing on master!
Список pgsql-performance
On Mon, Jun 10, 2013 at 8:35 AM, Niels Kristian Schjødt <nielskristian@autouncle.com> wrote:

WARNING:  pg_stop_backup still waiting for all required WAL segments to be archived (1920 seconds elapsed)
HINT:  Check that your archive_command is executing properly.  pg_stop_backup can be canceled safely, but the database backup will not be usable without all the WAL segments.

When looking at ps aux on the master, I see the following:

postgres 30930  0.0  0.0  98412  1632 ?        Ss   15:59   0:02 postgres: archiver process   failed on 0000000200000E1B000000A9

The file mentioned is the one that it was about to archive, when the standby server failed. Somehow it must still be trying to "catch up" from that file which of cause isn't there any more, since I had to remove those in order to get more space on the HDD.

So the archive_command is failing because it is trying to archive a file that no longer exists.

One way around this is to remove the .ready files from the pg_xlog/archive_status directory, which correspond to the WAL files you manually removed.  

Another way would be to temporarily replace the archive_command with one that will report success even when the archiving fails, until the archiver gets paste this stretch.  In fact you could just replace the command with 'true', so it reports success without even doing anything.

Cheers,

Jeff

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

Предыдущее
От: bricklen
Дата:
Сообщение: Re: URGENT issue: pg-xlog growing on master!
Следующее
От: Matheus de Oliveira
Дата:
Сообщение: Re: URGENT issue: pg-xlog growing on master!