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 1tx553-002c7l-4Z for pgsql-bugs@arkaria.postgresql.org; Tue, 25 Mar 2025 14:16:37 +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 1tx551-0053jT-9q for pgsql-bugs@arkaria.postgresql.org; Tue, 25 Mar 2025 14:16:35 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tx1DY-001pTw-6z for pgsql-bugs@lists.postgresql.org; Tue, 25 Mar 2025 10:09:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tx1DW-0011LC-1e for pgsql-bugs@lists.postgresql.org; Tue, 25 Mar 2025 10:09:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=Cs1JXwzeNtqFjPdPmIx7tHcAlSW7cRlr60ktSwiY5g8=; b=TzhUjQlTdbBLiSwyhhvDikfRGb S1ULELq7qn67p9u1zCczWerj3oMgrY/NcjsC8Td8nlxGZl6vAqIYn5crW/VH0ZjxegkzYYnxWTS7e MQAk1mqtHNJs/seBvRB5jL9o1IaW7kDt0uYQhcKwKmEmOz78tzuvJRx3Nb+SVGVMbDUK+zg3qqFCK ep/QVJSpm1uFshfvC6zpjrrJ97Ut+9RrYW1+5lBe32wQwxnUPkax+mFNLwZ/K94oNAb0PfKC1/rqq KjmkygnnWmRn7JHX9djhGWNPbwHmE4EI9EpY4AEBZcNVJtoTc2yqyb1ApJDULMlUBt0AH6xOcFGRX qtLrPEEA==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tx1DU-00Ccpa-Ez for pgsql-bugs@lists.postgresql.org; Tue, 25 Mar 2025 10:09:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tx1DS-005Zr5-F8 for pgsql-bugs@lists.postgresql.org; Tue, 25 Mar 2025 10:09:02 +0000 Content-Type: multipart/mixed; boundary="===============3476251052765566808==" MIME-Version: 1.0 Subject: BUG #18865: pg_resetwal error: multitransaction offset (-O) must not be -1 To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: d.kovalenko@postgrespro.ru Reply-To: d.kovalenko@postgrespro.ru, pgsql-bugs@lists.postgresql.org Date: Tue, 25 Mar 2025 10:08:23 +0000 Message-ID: <18865-d4c66cf35c2a67af@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3476251052765566808== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODg2NQpMb2dnZWQgYnk6ICAgICAgICAgIERtaXRyeSBLb3ZhbGVua28K RW1haWwgYWRkcmVzczogICAgICBkLmtvdmFsZW5rb0Bwb3N0Z3Jlc3Byby5ydQpQb3N0Z3JlU1FM IHZlcnNpb246IDE3LjQKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjAyNC4wNApEZXNjcmlw dGlvbjogICAgICAgIAoKSGVsbG8sDQoNCkEgcHJvYmxlbSBvZiBkYXRhYmFzZSBjbHVzdGVyIG1p Z3JhdGlvbiwgd2hlcmUgbmV4dC1tdWx0aXhhY3Qtb2Zmc2V0IGJlY2FtZQo0Mjk0OTY3Mjk1ICgt MSksIGlzIGZvdW5kLg0KDQpJIGNyZWF0ZWQgYSB0ZXN0IHdoZXJlIGRhdGFiYXNlIGhhcyBOZXh0 TXVsdGlPZmZzZXQgZXF1YWwgNDI5NDk2NzI5NSAoLTEpLg0KDQpwZ191cGdyYWRlIGNhbid0IHBy b2Nlc3MgdGhlIHN1Y2ggZGF0YWJhc2UgYmVjYXVzZSBwZ19yZXNldHdhbCByZXR1cm5zIHRoZQpl cnJvciAibXVsdGl0cmFuc2FjdGlvbiBvZmZzZXQgKC1PKSBtdXN0IG5vdCBiZSAtMSIuICAgDQoN Ci0tLQ0KVGVzdCBwcm9qZWN0IChweXRob24pOg0KaHR0cHM6Ly9naXRodWIuY29tL2RtaXRyeS1s aXBldHNrL1Bvc3RncmVzVGVzdHMvdHJlZS9tYWluL0hlYXAwMDEvUG9zdGdyZVNRTC9TZXQwMDEv RDIwMjUwMzI1XzAwMS0tbmV4dF9tdWx0aXhhY3Rfb2Zmc2V0c19pc19taW51c19vbmUvSXRlcjAw MA0KDQpTb3VyY2UgY29kZSBvZiB0ZXN0Og0KaHR0cHM6Ly9naXRodWIuY29tL2RtaXRyeS1saXBl dHNrL1Bvc3RncmVzVGVzdHMvYmxvYi9tYWluL0hlYXAwMDEvUG9zdGdyZVNRTC9TZXQwMDEvRDIw MjUwMzI1XzAwMS0tbmV4dF9tdWx0aXhhY3Rfb2Zmc2V0c19pc19taW51c19vbmUvSXRlcjAwMC9z cmMvdGVzdHMvcGdfdXBncmFkZS90ZXN0X3NldDAwMV9fTXVsdGlYYWN0cy5weQ0KDQpBbiBhcmNo aXZlIGhhcyB0aGUgcmVzdWx0IG9mIHRlc3QKdGVzdF8wMDZfX211bHRpeGFjdF9vZmZzZXRzW25l eHRfNDI5NDk2NzI5My1jaXRlbXNfMi1jbXhpZHNfMV0gZXhlY3V0aW9uOg0KDQpodHRwczovL2Ry b3BtZWZpbGVzLmNvbS9Kem1aOCAobGluayBpcyB2YWxpZCB3aXRoaW4gdHdvIHdlZWtzKQ0KDQow MDEtYmFkDQogLSBpdCBpcyBhIHJlc3VsdCB3aXRoIG9yaWduYWwgcG9zdGdyZXMgKG1hc3Rlciwg UEcxOCkNCg0KMDAyLW9rDQogLSBpdCBpcyBhIHJlc3VsdCB3aXRoIG1vZGlmaWVkIHBvc3RncmVz OgpodHRwczovL2dpdGh1Yi5jb20vZG1pdHJ5LWxpcGV0c2svcG9zdGdyZXMvdHJlZS9EMjAyNTAz MjVfMDAxLS1uZXh0X211bHRpeGFjdF9vZmZzZXRzX2lzX21pbnVzX29uZQ0KDQpZb3UgY2FuIHJl Y3JlYXRlIHRoZXNlIHJlc3VsdHM6DQpleHBvcnQgVEVTVF9DRkdfX09MRF9CSU5fRElSPSJwYXRo X3RvX3BnX2Jpbl9kaXIiDQpleHBvcnQgVEVTVF9DRkdfX05FV19CSU5fRElSPSJwYXRoX3RvX3Bn X2Jpbl9kaXIiDQpweXRlc3QgLWwgLXYgLWsgIm5leHRfNDI5NDk2NzI5My1jaXRlbXNfMi1jbXhp ZHNfMSINCg0KLS0tDQpTaG9ydCBzY2VuYXJpbw0KDQotIEluIGVtcHR5IChuZXcpIGNsdXN0ZXIg c2V0IE5leHRNdWx0aU9mZnNldCBlcXVhbCA0Mjk0OTY3MjkzIHdpdGgKcGdfcmVzZXR3YWwNCi0g Q3JlYXRlIGEgbXVsdGl0cmFuc2FjdGlvbiB0aGF0IGlzIGJhc2VkIG9uIHR3byBub3JtYWwgdHJh bnNhY3Rpb25zDQozKSBSdW4gcGdfdXBncmFkZQ0KNCkgR2V0IHRoZSBwZ19yZXNldHdhbCBlcnJv ciAibXVsdGl0cmFuc2FjdGlvbiBvZmZzZXQgKC1PKSBtdXN0IG5vdCBiZSAtMSINCg0KLS0tDQpG dWxsIHNjZW5hcmlvDQoNCjApIEJ1aWxkIFBvc3RncmVzIGZyb20gbWFzdGVyIHRyZWUgKFBHMTgp DQoNCjEpIENyZWF0ZSB0aGUgbmV3IGNsdXN0ZXIgLSBzb3VyY2VfY2x1c3Rlcg0KDQoyKSBFeGVj dXRlIHRoZSBjb21tYW5kOiANCnBnX3Jlc2V0d2FsIC1PIDQyOTQ5NjcyOTMgLUQgPHBhdGhfdG9f c291cmNlX2NsdXN0ZXI+DQoNCjMpIENyZWF0ZSBmaWxlcyBpbiAgaW4gcGdfbXVsdGl4YWN0L21l bWJlcnMgZm9sZGVyOg0KYmFzaCAtYyAiZGQgaWY9L2Rldi96ZXJvCm9mPTxwYXRoX3RvX3NvdXJj ZV9jbHVzdGVyPi9wZ19tdWx0aXhhY3QvbWVtYmVycy8xNDA3OCBicz0yNjIxNDQgY291bnQ9MSIN Cg0KNCkgQ3JlYXRlIHRoZSB0ZXN0IHRhYmxlOg0KDQpDUkVBVEUgVEFCTEUgdGVzdF90YWJsZSAo aWQgaW50ZWdlciBOT1QgTlVMTCBQUklNQVJZIEtFWSwgdmFsIHRleHQpOw0KSU5TRVJUIElOVE8g dGVzdF90YWJsZSBWQUxVRVMgKDEsICdhJyk7DQoNCjUpIENyZWF0ZSB0d28gY29ubmVjdGlvbiAt IENOMSDQuCBDTjINCg0KNikgQ3JlYXRlIGEgbXVsdGl0cmFuc2FjdGlvbjoNCg0KQ04xOiBCRUdJ Tjsgc2VsZWN0ICogZnJvbSB0ZXN0X3RhYmxlIHdoZXJlIGlkID0gMSBmb3Igc2hhcmU7DQpDTjI6 IEJFR0lOOyBzZWxlY3QgKiBmcm9tIHRlc3RfdGFibGUgd2hlcmUgaWQgPSAxIGZvciBzaGFyZTsN Cg0KNykgQ29tbWl0IHRyYW5zYWN0aW9ucyBpbiBDTjEgYW5kIENOMjoNCg0KQ04xOiBDT01NSVQ7 DQpDTjI6IENPTU1JVDsNCg0KOCkgQ2xvc2UgY29ubmVjdGlvbnMgQ04xIGFuZCBDTjINCg0KQ29u dHJvbERhdGEgb2Ygc291cmNlX2NsdXN0ZXIgc2F5czoNCi0gTGF0ZXN0IGNoZWNrcG9pbnQncyBO ZXh0TXVsdGlYYWN0SWQ6ICAyDQotIExhdGVzdCBjaGVja3BvaW50J3MgTmV4dE11bHRpT2Zmc2V0 OiAgNDI5NDk2NzI5NQ0KLSBMYXRlc3QgY2hlY2twb2ludCdzIG9sZGVzdE11bHRpWGlkOiAgIDEN Cg0KOSkgQ3JlYXRlIHRoZSBuZXcgY2x1c3RlciAtIHRhcmdldF9jbHVzdGVyIA0KDQoxMCkgUnVu IHRoZSBjb21tYW5kDQoNCnBnX3VwZ3JhZGUgLS1vbGQtZGF0YWRpciA8cGF0aF90b19zb3VyY2Vf Y2x1c3Rlcj4gLS1uZXctZGF0YWRpcgo8cGF0aF90b190YXJnZXRfY2x1c3Rlcj4gLi4uLg0KDQox MSkgR2V0IHRoZSBtaWdyYXRpb24gZXJyb3I6DQouLi4NClBlcmZvcm1pbmcgVXBncmFkZQ0KLS0t LS0tLS0tLS0tLS0tLS0tDQouLi4NCkNvcHlpbmcgb2xkIHBnX211bHRpeGFjdC9tZW1iZXJzIHRv IG5ldyBzZXJ2ZXIgICAgICAgICAgICAgICAgb2sNClNldHRpbmcgbmV4dCBtdWx0aXhhY3QgSUQg YW5kIG9mZnNldCBmb3IgbmV3IGNsdXN0ZXIgICAgICAgICAgDQoqZmFpbHVyZSoNCi4uLg0KQ29u c3VsdCB0aGUgbGFzdCBmZXcgbGluZXMgb2YKIi4uLi90YXJnZXQvZGF0YS9wZ191cGdyYWRlX291 dHB1dC5kLzIwMjUwMzI1VDEwMTYyOC44MjIvbG9nL3BnX3VwZ3JhZGVfdXRpbGl0eS5sb2ciCmZv ciB0aGUgcHJvYmFibGUgY2F1c2Ugb2YgdGhlIGZhaWx1cmUuDQpGYWlsdXJlLCBleGl0aW5nDQoN Ci0tDQpwZ191cGdyYWRlX3V0aWxpdHkubG9nIGhhcyB0aGUgZm9sbG93aW5nIGluZm9ybWF0aW9u Og0KDQpjb21tYW5kOiAiLi4uL3BnX3Jlc2V0d2FsIiAtTyA0Mjk0OTY3Mjk1IC1tIDIsMSAiLi4u L3RhcmdldC9kYXRhIiA+PgoiLi4uL3RhcmdldC9kYXRhL3BnX3VwZ3JhZGVfb3V0cHV0LmQvMjAy NTAzMjVUMTAxNjI4LjgyMi9sb2cvcGdfdXBncmFkZV91dGlsaXR5LmxvZyIKMj4mMQ0KcGdfcmVz ZXR3YWw6IGVycm9yOiBtdWx0aXRyYW5zYWN0aW9uIG9mZnNldCAoLU8pIG11c3Qgbm90IGJlIC0x DQoNClJlZ2FyZHMsDQpEbWl0cnkgS292YWxlbmtvDQpQb3N0Z3JlcyBQcm9mZXNzaW9uYWwKCg== --===============3476251052765566808==--