Re: could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error

Поиск
Список
Период
Сортировка
От Soni M
Тема Re: could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error
Дата
Msg-id CAAMgDX=RajSKgYqeGpTJA11=LUpknDHq75AmEBCWz2JnpGnSBA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error  (Laurenz Albe <laurenz.albe@cybertec.at>)
Ответы Re: could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error  (Soni M <diptatapa@gmail.com>)
Список pgsql-general
Дерево обсуждения
More disk space now available, but still the error happens and postgres won't start.
I think it could be corrupted shared buffers, as stated on the log messages, and perhaps the corruption goes to disk.

On Fri, Jan 15, 2021 at 4:33 PM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Fri, 2021-01-15 at 16:13 +0700, Soni M wrote:
> We filled out the wal archive disk, and then those messages appear
>
> [...]PANIC,58030,"could not fsync file ""pg_wal/xlogtemp.3510"": Input/output error"
>
> And now I cannot start postgres
>
> [...]PANIC,58030,"could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error"
>
> Any idea to solve this ?

Did you add more disk space?

You won't be able to start PostgreSQL unless you do that.

And no, don't start deleting files in the data directory.

What you can do is move the *complete* data directory to another location
with more disk space and start it there.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com



--
Regards,

Soni Maula Harriz

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

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error
Следующее
От: Niels Jespersen
Дата:
Сообщение: time-based range partitioning and truncate/delete different timezones