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
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 |