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

From: Soni M <diptatapa(at)gmail(dot)com>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error
Date: 2021-01-15 14:34:41
Message-ID: CAAMgDXn=uX9hd8BXL7U9jBuYUzZ60Vya24rpNxt+YKsanUBkFg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Fix it already, so it was the SAN and vmware issue.

Thanks Everyone.

On Fri, Jan 15, 2021 at 4:40 PM Soni M <diptatapa(at)gmail(dot)com> wrote:

> 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(dot)albe(at)cybertec(dot)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
>

--
Regards,

Soni Maula Harriz

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kristi Kangas 2021-01-15 14:35:27 PostgreSQL License Question
Previous Message Atul Kumar 2021-01-15 14:14:16 Re: upgrade postgres 9.5 to 9.6