agora inbox for pgsql-admin@postgresql.org
help / color / mirror / Atom feedFrom: Domen Šetar <domen.setar@izum.si>
To: Kashif Zeeshan <kashi.zeeshan@gmail.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: RE: wal seams to be corrupted
Date: Fri, 19 Jul 2024 06:43:38 +0000
Message-ID: <43413b4628e24e5cab22bfa62930a5c1@izum.si> (raw)
In-Reply-To: <CAAPsdheMONzDuB+WfoeRebGzEO96pzjTwy+4-HP0-zG+oYDDJA@mail.gmail.com>
References: <e5c12651f94e469fa3667d816d865e28@izum.si>
<CAAPsdheMONzDuB+WfoeRebGzEO96pzjTwy+4-HP0-zG+oYDDJA@mail.gmail.com>
Thank you Kashif.
I’ll try to find the cause of the problem. If I fail, I’ll do it with replica.
Best regards!
[izum]
Domen Šetar
Computer Systems Support
IZUM – Institute of Information Science | Prešernova ulica 17 | 2000 Maribor | Slovenia
T: +386 2 25 20 339 | M: +386 41 676 342 | www.izum.si<http://www.izum.si/; | domen.setar@izum.si<mailto:domen.setar@izum.si>
From: Kashif Zeeshan <kashi.zeeshan@gmail.com>
Sent: Friday, July 19, 2024 8:42 AM
To: Domen Šetar <domen.setar@izum.si>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: wal seams to be corrupted
Hi
On Fri, Jul 19, 2024 at 11:37 AM Domen Šetar <domen.setar@izum.si<mailto:domen.setar@izum.si>> wrote:
Hi,
I think, that possible the best solution will be to stop postgresql on problem server (which is replication master), promote secondary, replicate data from promoted secondary back to problem server in make it replication master again. That way I'll get rid of problematic wal file.
This is the standard way and it will require a lot of time on your end and the down time as well, i think it's better to find the cause of the failure first and its possible that you can fix the issue in less time and effort but the solution you suggested is the safest way though.
Best regards!
[izum]
Domen Šetar
Computer Systems Support
IZUM – Institute of Information Science | Prešernova ulica 17 | 2000 Maribor | Slovenia
T: +386 2 25 20 339 | M: +386 41 676 342 | www.izum.si<http://www.izum.si/; | domen.setar@izum.si<mailto:domen.setar@izum.si>
From: Domen Šetar
Sent: Friday, July 19, 2024 7:58 AM
To: pgsql-admin@lists.postgresql.org<mailto:pgsql-admin@lists.postgresql.org>
Subject: wal seams to be corrupted
Hi admins,
The number of wal files on my postgresql server is rising, because it seams that one wal is corrupted. Postgrsql is running normaly. I see this in postgresql log file:
2024-07-19 07:44:12 CEST [2205]: [32288-1] user=,db=,app=,client= DETAIL: The failed archive command was: test ! -f /var/lib/pgsql/ArchiveDir/000000010000044E0000009D && cp pg_wal/000000010000044E0000009D /var/lib/pgsql/ArchiveDir/000000010000044E0000009D
Usualy helped if I deleted wal in ArchiveDir directory. But not this time. Wal is copied again from pg_wal to ArchiveDir directory and error message continues.
What can I do to solve this problem? Is pg_resetwal solution fort his problem? If it is, how to use it?
Best regards!
[izum]
Domen Šetar
Computer Systems Support
IZUM – Institute of Information Science | Prešernova ulica 17 | 2000 Maribor | Slovenia
T: +386 2 25 20 339 | M: +386 41 676 342 | www.izum.si<http://www.izum.si/; | domen.setar@izum.si<mailto:domen.setar@izum.si>
Attachments:
[image/jpeg] image001.jpg (1.3K, ../43413b4628e24e5cab22bfa62930a5c1@izum.si/3-image001.jpg)
download | view image
[image/jpeg] image002.jpg (1.3K, ../43413b4628e24e5cab22bfa62930a5c1@izum.si/4-image002.jpg)
download | view image
view thread (15+ messages) latest in thread
Message-ID: <43413b4628e24e5cab22bfa62930a5c1@izum.si>
Permalink: ../43413b4628e24e5cab22bfa62930a5c1@izum.si/
Also on: postgresql.org/message-id/43413b4628e24e5cab22bfa62930a5c1@izum.si
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: domen.setar@izum.si, kashi.zeeshan@gmail.com, pgsql-admin@lists.postgresql.org
Subject: RE: wal seams to be corrupted
In-Reply-To: <43413b4628e24e5cab22bfa62930a5c1@izum.si>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox