Re: [GENERAL] could not fdatasync log file: Input/output error

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: [GENERAL] could not fdatasync log file: Input/output error
Дата
Msg-id CAB7nPqSUt0rq62RQz2ZH-t4nkOQYNocqpbP50r6x+jyninXh6Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] could not fdatasync log file: Input/output error  (said assemlal <said.assemlal@gmail.com>)
Ответы Re: [GENERAL] could not fdatasync log file: Input/output error  (said assemlal <said.assemlal@gmail.com>)
Список pgsql-general
On Mon, Oct 16, 2017 at 11:47 PM, said assemlal <said.assemlal@gmail.com> wrote:
> Just before we restart the server today, I found only one line as:
>
> PANIC:  could not fdatasync log file 000000010000017600000083: Input/output
> error
> the database system is in recovery mode

Ouch. I would not trust this host at this point, this looks like a
file system or a disk issue. Before doing anything you should stop the
database, and make a cold copy of the data folder on which you could
work on if you don't have a live backup. This wiki page is wise on the
matter:
http://wiki.postgresql.org/wiki/Corruption
-- 
Michael


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

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

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: [GENERAL] PGConf.ASIA and VISA
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: [GENERAL] wal_retrieve_retry_interval