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 1sUgcp-004tZ2-2p for pgsql-admin@arkaria.postgresql.org; Fri, 19 Jul 2024 05:57:51 +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 1sUgcn-00A3b7-3a for pgsql-admin@arkaria.postgresql.org; Fri, 19 Jul 2024 05:57:49 +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 1sUgcm-00A3az-M1 for pgsql-admin@lists.postgresql.org; Fri, 19 Jul 2024 05:57:49 +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 1sUgck-000KaY-7O for pgsql-admin@lists.postgresql.org; Fri, 19 Jul 2024 05:57:48 +0000 Received: from EXSRV-01.izum.pri (EXSRV-01.izum.pri [10.1.100.193]) by mailout3.izum.si (Postfix) with ESMTPS id B297A6028649 for ; Fri, 19 Jul 2024 07:57:44 +0200 (CEST) DKIM-Filter: OpenDKIM Filter v2.11.0 mailout3.izum.si B297A6028649 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=izum.si; s=20210129; t=1721368664; bh=Mkbf/DAmNgTnJbB5T1cTHM7N/mjT0WQX2+g/1FdyCz4=; h=From:To:Subject:Date:From; b=hfP4SE8z1lRlq/uPw8DgXkLvEj755YksannEnjzK1yzG1zprlHS5KpOaY4yUjAlrW KzI4kaGvdLeTY6jhOk/8O0LpcKaERcTpGrF3OMy+nS/KnUaVCKWhnVD4ZWndMWgybd sCh5LBla/1lAna2KcDiCdxJysFy/yrWd58K1/eHVKeTdrZcRWPst2b5zlK4mTbzRiy oZCNAZ6uAmRvp2q8NyFNan2zRMtzkn5c+dJBbDuQWnmFMKblH6Ee7ur7ySvXk/OoP6 oyx9ExTI9L13UfHq68fhkDp9j4tIcyA4L5XIsfp3patLUtSC0pTr3LcIh6rNrtfhvI +vV/QGJzZd2uw== Received: from EXSRV-02.izum.pri (10.1.100.197) by EXSRV-01.izum.pri (10.1.100.193) 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 07:57:44 +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 07:57:44 +0200 From: =?iso-8859-2?Q?Domen_=A9etar?= To: "pgsql-admin@lists.postgresql.org" Subject: wal seams to be corrupted Thread-Topic: wal seams to be corrupted Thread-Index: AdrZoJJO3BlBqyPDSnuxDyTSy34Kaw== Date: Fri, 19 Jul 2024 05:57:44 +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="_004_fb27effbffe84e5e81bc234a388ed929izumsi_"; type="multipart/alternative" MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_004_fb27effbffe84e5e81bc234a388ed929izumsi_ Content-Type: multipart/alternative; boundary="_000_fb27effbffe84e5e81bc234a388ed929izumsi_" --_000_fb27effbffe84e5e81bc234a388ed929izumsi_ Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable 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_fb27effbffe84e5e81bc234a388ed929izumsi_ Content-Type: text/html; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable

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_fb27effbffe84e5e81bc234a388ed929izumsi_-- --_004_fb27effbffe84e5e81bc234a388ed929izumsi_ 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 05:57:44 GMT"; modification-date="Fri, 19 Jul 2024 05:57:44 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== --_004_fb27effbffe84e5e81bc234a388ed929izumsi_--