Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sUhF7-005037-Hk for pgsql-admin@arkaria.postgresql.org; Fri, 19 Jul 2024 06:37:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sUhF5-00AvLZ-KE for pgsql-admin@arkaria.postgresql.org; Fri, 19 Jul 2024 06:37:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sUhF5-00AvLR-5r for pgsql-admin@lists.postgresql.org; Fri, 19 Jul 2024 06:37:23 +0000 Received: from mailout3.izum.si ([193.2.126.3]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sUhF2-000Ku6-S4 for pgsql-admin@lists.postgresql.org; Fri, 19 Jul 2024 06:37:23 +0000 Received: from EXSRV-02.izum.pri (EXSRV-02.izum.pri [10.1.100.197]) by mailout3.izum.si (Postfix) with ESMTPS id 002A26028449 for ; Fri, 19 Jul 2024 08:37:19 +0200 (CEST) DKIM-Filter: OpenDKIM Filter v2.11.0 mailout3.izum.si 002A26028449 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=izum.si; s=20210129; t=1721371040; bh=F0v0zcIu+61VKaA7mbQ9xxWuVDp5szFjtRnAEZiO4PA=; h=From:To:Subject:Date:From; b=U//jkoUULd5XgshoeTBfMR5gklooNBbJBjvMdeVXhrWqA1xtU+tD7B/6nd12n9aD8 r4HKeJnKGNlcPOzafDKdLBVjHr6jJuoY/R+6j2F/z93v9H6f8ZM6TE40y6uUK1wbJr 2Hd+wHKmgX8yDpKGclcdJmXCys56v9S0dCqIHxY5iym7uZQkH5Rwuwi0ZBtqFNn7fC HZBZRINfgB7zbmJ64wGxkK67aQLl5BKorcRFCmClxk+jobQFSHk3+Y6HviCZdVee7t GLV2Adkk+uYs9JD2iHFsV6QWAo1QCtIjaOLYmKCODbNShJtUsEGybKHrEqNMB93Hc3 /p5jfnxlIfIuQ== Received: from EXSRV-02.izum.pri (10.1.100.197) by EXSRV-02.izum.pri (10.1.100.197) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256) id 15.1.2507.34; Fri, 19 Jul 2024 08:37:19 +0200 Received: from EXSRV-02.izum.pri ([fe80::dc3d:be4a:5e4c:4186]) by EXSRV-02.izum.pri ([fe80::dc3d:be4a:5e4c:4186%8]) with mapi id 15.01.2507.034; Fri, 19 Jul 2024 08:37:19 +0200 From: =?iso-8859-2?Q?Domen_=A9etar?= To: "pgsql-admin@lists.postgresql.org" Subject: RE: wal seams to be corrupted Thread-Topic: wal seams to be corrupted Thread-Index: AdrZoJJO3BlBqyPDSnuxDyTSy34KawABQ0RQ Date: Fri, 19 Jul 2024 06:37:19 +0000 Message-ID: Accept-Language: sl-SI, en-US Content-Language: en-US X-MS-Has-Attach: yes X-MS-TNEF-Correlator: x-originating-ip: [10.1.100.6] Content-Type: multipart/related; boundary="_005_e5c12651f94e469fa3667d816d865e28izumsi_"; type="multipart/alternative" MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_005_e5c12651f94e469fa3667d816d865e28izumsi_ Content-Type: multipart/alternative; boundary="_000_e5c12651f94e469fa3667d816d865e28izumsi_" --_000_e5c12651f94e469fa3667d816d865e28izumsi_ Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable Hi, I think, that possible the best solution will be to stop postgresql on prob= lem server (which is replication master), promote secondary, replicate data= from promoted secondary back to problem server in make it replication mast= er again. That way I'll get rid of problematic wal file. Best regards! [izum] Domen =A9etar Computer Systems Support IZUM - Institute of Information Science | Pre=B9ernova ulica 17 | 2000 Mari= bor | Slovenia T: +386 2 25 20 339 | M: +386 41 676 342 | www.izum.si= | domen.setar@izum.si From: Domen =A9etar Sent: Friday, July 19, 2024 7:58 AM To: 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 po= stgresql log file: 2024-07-19 07:44:12 CEST [2205]: [32288-1] user=3D,db=3D,app=3D,client=3D D= ETAIL: The failed archive command was: test ! -f /var/lib/pgsql/ArchiveDir= /000000010000044E0000009D && cp pg_wal/000000010000044E0000009D /var/lib/pg= sql/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 probl= em? If it is, how to use it? Best regards! [izum] Domen =A9etar Computer Systems Support IZUM - Institute of Information Science | Pre=B9ernova ulica 17 | 2000 Mari= bor | Slovenia T: +386 2 25 20 339 | M: +386 41 676 342 | www.izum.si= | domen.setar@izum.si --_000_e5c12651f94e469fa3667d816d865e28izumsi_ Content-Type: text/html; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable

Hi,

 

I think, that possi= ble the best solution will be to stop postgresql on problem server (which i= s replication master), promote secondary, replicate data from promoted seco= ndary back to problem server in make it replication master again. That way I'll get rid of problematic wal file= .

 

Best regards!

3D"izum"

Domen =A9etar
Computer Systems Support
IZUM ̵= 1; Institute of Information Science | Pre=B9er= nova ulica 17 | 2000 Maribor | Slovenia
T: = 3;386 2 25 20 339 | M: += 386 41 676 342 | www.izum.si | domen.setar@izum.si

 

 

From: Domen =A9etar
Sent: Friday, July 19, 2024 7:58 AM
To: pgsql-admin@lists.postgresql.org
Subject: wal seams to be corrupted

 

Hi admins,

 

The number of wal f= iles on my postgresql server is rising, because it seams that one wal is co= rrupted. Postgrsql is running normaly.  I see this in postgresql log f= ile:

 

2024-07-19 07:44:12= CEST [2205]: [32288-1] user=3D,db=3D,app=3D,client=3D DETAIL:  The fa= iled archive command was: test ! -f /var/lib/pgsql/ArchiveDir/0000000100000= 44E0000009D && 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 so= lve this problem? Is pg_resetwal solution fort his problem? If it is, how t= o use it?

 

Best regards!

3D"izum"

Domen =A9etar
Computer Systems Support
IZUM ̵= 1; Institute of Information Science | Pre=B9er= nova ulica 17 | 2000 Maribor | Slovenia
T: = 3;386 2 25 20 339 | M: += 386 41 676 342 | www.izum.si | domen.setar@izum.si

 

 

--_000_e5c12651f94e469fa3667d816d865e28izumsi_-- --_005_e5c12651f94e469fa3667d816d865e28izumsi_ Content-Type: image/jpeg; name="image001.jpg" Content-Description: image001.jpg Content-Disposition: inline; filename="image001.jpg"; size=1318; creation-date="Fri, 19 Jul 2024 06:37:19 GMT"; modification-date="Fri, 19 Jul 2024 06:37:19 GMT" Content-ID: Content-Transfer-Encoding: base64 /9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCABHAEcDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii gArN1OR0vdIVXZVe8ZXAONw8mU4P4gH8K0qwvE2q6ZoqaZfarctbwJeYVwpYbjFIOcc4xn8cVUU2 7ImTsrhqU0qaN4idZXVokk8tg2Cn7hTx6c81uD7o+lcFf+PfBsmmarF/bYb7Wj5VInLDMYTAyME8 frXer90fSnKLjuhRkm9GLRRRUFhRRRQAUUUUAFZev2Oj32lsuuR2z2UbCQm4ICoR0OT06n8zWpXJ +PNP07VLPSbTVGuBbPqAOLeMuxYQykAgAnHHPB/qLp/EiZ/Czj4brw1f6odK0bwvDr1swMc1zBYR QtDkdfMwqnrx936mvWx0rjfsNg2lyaZa6tqNlDLG0KD7KIUXcMDnylA6+oNdkOgqqruyKSsLRRRW RqFFFFABRRRQAVz3i7XZfD9pYXUOmy6g0l2IjDCu6QAxyElR6jb+Wa6Guc8Y3mtWVnp76FFDPeNd 4MMuMSIIpGKg9j8vXIq6avJJkVHaLOavfGer67ZT6VY+DtWjmvI2g827iMccYYbdzHHQZzivRYlZ YkVm3MFAJ9TXn8vjKDxFoGoJaXVzo2v2MDym0lO1wyrkjBGHHHpkegzXoQ+6PpV1VbS1iaevW4tF FFYmoUUUUAFFFFABXM+NLvTLG00y51S/ubCOO+UxXMAB2P5cn3gVbKkbh07iumrG1+ysNQfS7XUL NLqJ7w7UkAKhhDKckEHdxnj1IParhZS1Jnfl0OB8X6v8O/Etg8lxqii+ijJiuIImEuQOn3QDn0P6 V6sv3R9K4/UfDfhhdJ1iQ+HNPH2WJwfLgRWOIw3DbflPOM9sZrsB0FVUlFpKN/mRTi022LRRRWRq FFFFABRRRQAVmar/AMf+i/8AX63/AKImooprcUtilqv/ACA/E/8A1zk/9J1rfHQUUU3sJbi0UUVJ QUUUUAf/2Q== --_005_e5c12651f94e469fa3667d816d865e28izumsi_ Content-Type: image/jpeg; name="image002.jpg" Content-Description: image002.jpg Content-Disposition: inline; filename="image002.jpg"; size=1318; creation-date="Fri, 19 Jul 2024 06:37:19 GMT"; modification-date="Fri, 19 Jul 2024 06:37:19 GMT" Content-ID: Content-Transfer-Encoding: base64 /9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCABHAEcDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii gArN1OR0vdIVXZVe8ZXAONw8mU4P4gH8K0qwvE2q6ZoqaZfarctbwJeYVwpYbjFIOcc4xn8cVUU2 7ImTsrhqU0qaN4idZXVokk8tg2Cn7hTx6c81uD7o+lcFf+PfBsmmarF/bYb7Wj5VInLDMYTAyME8 frXer90fSnKLjuhRkm9GLRRRUFhRRRQAUUUUAFZev2Oj32lsuuR2z2UbCQm4ICoR0OT06n8zWpXJ +PNP07VLPSbTVGuBbPqAOLeMuxYQykAgAnHHPB/qLp/EiZ/Czj4brw1f6odK0bwvDr1swMc1zBYR QtDkdfMwqnrx936mvWx0rjfsNg2lyaZa6tqNlDLG0KD7KIUXcMDnylA6+oNdkOgqqruyKSsLRRRW RqFFFFABRRRQAVz3i7XZfD9pYXUOmy6g0l2IjDCu6QAxyElR6jb+Wa6Guc8Y3mtWVnp76FFDPeNd 4MMuMSIIpGKg9j8vXIq6avJJkVHaLOavfGer67ZT6VY+DtWjmvI2g827iMccYYbdzHHQZzivRYlZ YkVm3MFAJ9TXn8vjKDxFoGoJaXVzo2v2MDym0lO1wyrkjBGHHHpkegzXoQ+6PpV1VbS1iaevW4tF FFYmoUUUUAFFFFABXM+NLvTLG00y51S/ubCOO+UxXMAB2P5cn3gVbKkbh07iumrG1+ysNQfS7XUL NLqJ7w7UkAKhhDKckEHdxnj1IParhZS1Jnfl0OB8X6v8O/Etg8lxqii+ijJiuIImEuQOn3QDn0P6 V6sv3R9K4/UfDfhhdJ1iQ+HNPH2WJwfLgRWOIw3DbflPOM9sZrsB0FVUlFpKN/mRTi022LRRRWRq FFFFABRRRQAVmar/AMf+i/8AX63/AKImooprcUtilqv/ACA/E/8A1zk/9J1rfHQUUU3sJbi0UUVJ QUUUUAf/2Q== --_005_e5c12651f94e469fa3667d816d865e28izumsi_--