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 1twmp1-0005WA-D4 for pgsql-bugs@arkaria.postgresql.org; Mon, 24 Mar 2025 18:46: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 1twmoz-008PpH-Eg for pgsql-bugs@arkaria.postgresql.org; Mon, 24 Mar 2025 18:46:49 +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 1twmeg-008Cpy-GU for pgsql-bugs@lists.postgresql.org; Mon, 24 Mar 2025 18:36:10 +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 1twmeb-000uLS-2w for pgsql-bugs@lists.postgresql.org; Mon, 24 Mar 2025 18:36:09 +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=kP3ykOMSyHeWERkDFC9PCDj+2SJQzTkXlw7TgTviDSk=; b=wdm6wqL89DitbXUIzBx4jQPvD4 RxVW/qf0WujS43jxhXN5OoGQTW0AMYOz+xwn3bXhtAMh9/Wowf5OKPxpsLHTvtrMvunSprHu61PrC 9MFucSViPTkhytdSuf230XzGeZIPxyZZeLxCf6bQMgV9g0/fgoupzbuqd1R0pRZXZaf1JTSQ9nRJX H0DLplH7vCNp7Se3agaVou84XVe1R4glwIEKK5adYe19wQkHYSfgfKJV91M5kdI2g94+MQ1wT82at oXn8iE3BtoSm5szM1DkfdWoPrOQ9d/NNBnz9lDrLPFGMZ5WQCd6VmcL756B3sBICLl7FyKZktmuZv FPzfnhOA==; 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 1twmea-00CJvy-3l for pgsql-bugs@lists.postgresql.org; Mon, 24 Mar 2025 18:36:04 +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 1twmeY-004xKD-FE for pgsql-bugs@lists.postgresql.org; Mon, 24 Mar 2025 18:36:02 +0000 Content-Type: multipart/mixed; boundary="===============8314419058964587262==" MIME-Version: 1.0 Subject: BUG #18863: Multixact wraparound and pg_resetwal error "multitransaction ID (-m) must not be 0" 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: Mon, 24 Mar 2025 18:35:07 +0000 Message-ID: <18863-72f08858855344a2@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 --===============8314419058964587262== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODg2MwpMb2dnZWQgYnk6ICAgICAgICAgIERtaXRyeSBLb3ZhbGVua28K RW1haWwgYWRkcmVzczogICAgICBkLmtvdmFsZW5rb0Bwb3N0Z3Jlc3Byby5ydQpQb3N0Z3JlU1FM IHZlcnNpb246IDE3LjQKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjAyNC4wNApEZXNjcmlw dGlvbjogICAgICAgIAoKSGVsbG8sDQoNCkEgcHJvYmxlbSBvZiBhIGRhdGFiYXNlIGNsdXN0ZXIg bWlncmF0aW9uLCB3aGVyZSBhIG11bHRpeGFjdCB3cmFwYXJvdW5kIHdhcwpvY2N1cnJlZCwgaXMg Zm91bmQuDQoNCk15IHRlc3QgY3JlYXRlcyBhIGNsdXN0ZXIgd2hlcmUgTmV4dE11bHRpWGFjdElk IGJlY29tZXMgZXF1YWwgMCBhbmQgcnVuCnBnX3VwZ3JhZGUuDQoNCnBnX3VwZ3JhZGUgZmFpbHMg YmVjYXVzZSBwZ19yZXNldHdhbCByZXR1cm5zIHRoZSBmb2xsb3dpbmcgZXJyb3I6CiJtdWx0aXRy YW5zYWN0aW9uIElEICgtbSkgbXVzdCBub3QgYmUgMCIuDQoNCi0tLQ0KVGVzdCBwcm9qZWN0IChw eXRob24pOg0KaHR0cHM6Ly9naXRodWIuY29tL2RtaXRyeS1saXBldHNrL1Bvc3RncmVzVGVzdHMv dHJlZS9tYWluL0hlYXAwMDEvUG9zdGdyZVNRTC9TZXQwMDEvRDIwMjUwMzI0XzAwMS0tbXVsdGl4 YWN0X2FuZF93cmFwYXJvdW5kL0l0ZXIwMDANCg0KU291cmNlIGNvZGUgb2YgdGVzdDoNCmh0dHBz Oi8vZ2l0aHViLmNvbS9kbWl0cnktbGlwZXRzay9Qb3N0Z3Jlc1Rlc3RzL2Jsb2IvbWFpbi9IZWFw MDAxL1Bvc3RncmVTUUwvU2V0MDAxL0QyMDI1MDMyNF8wMDEtLW11bHRpeGFjdF9hbmRfd3JhcGFy b3VuZC9JdGVyMDAwL3NyYy90ZXN0cy9wZ191cGdyYWRlL3Rlc3Rfc2V0MDAxX19NdWx0aVhhY3Rz LnB5DQoNCkFuIGFyY2hpdmUgY29udGFpbnMgdGhlIHJlc3VsdCBvZiB0ZXN0CiJ0ZXN0XzAwNF9f bXVsdGl4YWN0c1tuZXh0XzQyOTQ5NjcyOTUtb2xkXzQyOTQ5NjcyOTUtY214aWRzXzFdIiBleGVj dXRpb246DQoNCmh0dHBzOi8vZHJvcG1lZmlsZXMuY29tL1kxQ3BDICAodGhpcyBsaW5rIGlzIHZh bGlkIHdpdGhpbiB0d28gd2Vla3MpDQoNCjAwMS1iYWQNCiAtIGl0IGlzIGEgcmVzdWx0IHdpdGgg b3JpZ25hbCBwb3N0Z3JlcyAobWFzdGVyLCBQRzE4KQ0KDQowMDItb2sNCiAtIGl0IGlzIGEgcmVz dWx0IHdpdGggbW9kaWZpZWQgcG9zdGdyZXM6Cmh0dHBzOi8vZ2l0aHViLmNvbS9kbWl0cnktbGlw ZXRzay9wb3N0Z3Jlcy90cmVlL0QyMDI1MDMyNF8wMDEtLW11bHRpeGFjdF9hbmRfd3JhcGFyb3Vu ZA0KDQooSSB0cmllZCB0byBmaXggdGhpcyBwcm9ibGVtLCBvZiBjb3Vyc2UgaXQgaXMgYSByZXNl YXJjaCBvbmx5LikNCg0KWW91IGNhbiByZWNyZWF0ZSB0aGVzZSByZXN1bHRzOg0KZXhwb3J0IFRF U1RfQ0ZHX19PTERfQklOX0RJUj0icGF0aF90b19wZ19iaW5fZGlyIg0KZXhwb3J0IFRFU1RfQ0ZH X19ORVdfQklOX0RJUj0icGF0aF90b19wZ19iaW5fZGlyIg0KcHl0ZXN0IC1sIC12IC1rICJuZXh0 XzQyOTQ5NjcyOTUtb2xkXzQyOTQ5NjcyOTUtY214aWRzXzEiDQoNCi0tLQ0KU2hvcnQgc2NlbmFy aW8NCg0KMSkgU2V0IE5leHRNdWx0aVhhY3RJZCBhbmQgb2xkZXN0TXVsdGlYaWQgZXF1YWwgdG8g NDI5NDk2NzI5NQ0KMikgQ3JlYXRlIDEgbXVsdGl0cmFuc2FjdGlvbg0KMykgUnVuIHBnX3VwZ3Jh ZGUNCjQpIEdldCB0aGUgZXJyb3IgInBnX3Jlc2V0d2FsOiBtdWx0aXRyYW5zYWN0aW9uIElEICgt bSkgbXVzdCBub3QgYmUgMCINCg0KLS0tDQpGdWxsIHNjZW5hcmlvDQoNCjApIEJ1aWxkIFBvc3Rn cmVzIGZyb20gbWFzdGVyIHRyZWUgKFBHMTgpDQoNCjEpIENyZWF0ZSB0aGUgbmV3IGNsdXN0ZXIg LSBzb3VyY2VfY2x1c3Rlcg0KDQoyKSBFeGVjdXRlIHRoZSBjb21tYW5kOiANCnBnX3Jlc2V0d2Fs IC1tIDQyOTQ5NjcyOTUsNDI5NDk2NzI5NSAtRCA8cGF0aF90b19zb3VyY2VfY2x1c3Rlcj4NCg0K MykgQ3JlYXRlIGZpbGVzIGluIHBnX211bHRpeGFjdC9vZmZzZXRzIGZvbGRlcjoNCg0KYmFzaCAt YyAiZGQgaWY9L2Rldi96ZXJvCm9mPTxwYXRoX3RvX3NvdXJjZV9jbHVzdGVyPi9wZ19tdWx0aXhh Y3Qvb2Zmc2V0cy9GRkZGIGJzPTI2MjE0NCBjb3VudD0xIg0KDQo0KSBDcmVhdGUgdGhlIHRlc3Qg dGFibGU6DQoNCkNSRUFURSBUQUJMRSB0ZXN0X3RhYmxlIChpZCBpbnRlZ2VyIE5PVCBOVUxMIFBS SU1BUlkgS0VZLCB2YWwgdGV4dCk7DQpJTlNFUlQgSU5UTyB0ZXN0X3RhYmxlIFZBTFVFUyAoMSwg J2EnKTsNCg0KNSkgQ3JlYXRlIHR3byBjb25uZWN0aW9uIC0gQ04xINC4IENOMg0KDQo2KSBDcmVh dGUgYSBtdWx0aXRyYW5zYWN0aW9uOg0KDQpDTjE6IEJFR0lOOyBzZWxlY3QgKiBmcm9tIHRlc3Rf dGFibGUgd2hlcmUgaWQgPSAxIGZvciBzaGFyZTsNCkNOMjogQkVHSU47IHNlbGVjdCAqIGZyb20g dGVzdF90YWJsZSB3aGVyZSBpZCA9IDEgZm9yIHNoYXJlOw0KDQo3KSBDb21taXQgdHJhbnNhY3Rp b25zIGluIENOMSBhbmQgQ04yOg0KDQpDTjE6IENPTU1JVDsNCkNOMjogQ09NTUlUOw0KDQo4KSBD bG9zZSBjb25uZWN0aW9ucyBDTjEgYW5kIENOMg0KDQpDb250cm9sRGF0YSBvZiBzb3VyY2VfY2x1 c3RlciBzYXlzOg0KLSBMYXRlc3QgY2hlY2twb2ludCdzIE5leHRNdWx0aVhhY3RJZDogIDANCi0g TGF0ZXN0IGNoZWNrcG9pbnQncyBOZXh0TXVsdGlPZmZzZXQ6ICAzDQotIExhdGVzdCBjaGVja3Bv aW50J3Mgb2xkZXN0TXVsdGlYaWQ6ICAgNDI5NDk2NzI5NQ0KDQo5KSBDcmVhdGUgdGhlIG5ldyBj bHVzdGVyIC0gdGFyZ2V0X2NsdXN0ZXIgDQoNCjEwKSBSdW4gdGhlIGNvbW1hbmQNCg0KcGdfdXBn cmFkZSAtLW9sZC1kYXRhZGlyIDxwYXRoX3RvX3NvdXJjZV9jbHVzdGVyPiAtLW5ldy1kYXRhZGly CjxwYXRoX3RvX3RhcmdldF9jbHVzdGVyPiAuLi4uDQoNCjExKSBHZXQgdGhlIG1pZ3JhdGlvbiBl cnJvcjoNCg0KUGVyZm9ybWluZyBVcGdyYWRlDQotLS0tLS0tLS0tLS0tLS0tLS0NCi4uLg0KU2V0 dGluZyBuZXh0IG11bHRpeGFjdCBJRCBhbmQgb2Zmc2V0IGZvciBuZXcgY2x1c3RlciAgICAgICAg ICANCipmYWlsdXJlKg0KDQpDb25zdWx0IHRoZSBsYXN0IGZldyBsaW5lcyBvZgoiLi4uLi90YXJn ZXQvZGF0YS9wZ191cGdyYWRlX291dHB1dC5kLzIwMjUwMzI0VDE3MDkyMS4xNTQvbG9nL3BnX3Vw Z3JhZGVfdXRpbGl0eS5sb2ciCmZvciB0aGUgcHJvYmFibGUgY2F1c2Ugb2YgdGhlIGZhaWx1cmUu DQoNCi0tDQpwZ191cGdyYWRlX3V0aWxpdHkubG9nIGhhcyB0aGUgZm9sbG93aW5nIGluZm9ybWF0 aW9uOg0KDQpjb21tYW5kOiAiLi4uL3BnX3Jlc2V0d2FsIiAtTyAzIC1tIDAsNDI5NDk2NzI5NSAi Li4uL3RhcmdldC9kYXRhIiA+PgoiLi4uL3RhcmdldC9kYXRhL3BnX3VwZ3JhZGVfb3V0cHV0LmQv MjAyNTAzMjRUMTcwOTIxLjE1NC9sb2cvcGdfdXBncmFkZV91dGlsaXR5LmxvZyIKMj4mMQ0KcGdf cmVzZXR3YWw6IGVycm9yOiBtdWx0aXRyYW5zYWN0aW9uIElEICgtbSkgbXVzdCBub3QgYmUgMA0K DQpSZWdhcmRzLA0KRG1pdHJ5IEtvdmFsZW5rbywNClBvc3RncmVzIFByb2Zlc3Npb25hbAoK --===============8314419058964587262==--