MIME-Version: 1.0
References: 
 <CAA5RZ0s+kZZRMSF4HW7tZ9W2jS1o4B+Fg8dr5a-T6mANX+mdQA@mail.gmail.com>
 <525d0f48-93f7-493f-a988-f39b460a79bc@gmail.com>
 <CAD21AoCj=OSxoh3RBw0VWJ7Y7c9EipRhpatcZaHuXKGLWyKgdQ@mail.gmail.com>
 <CAA5RZ0uqvjxv5HPzz36UEq-LUf8F+kae61k0imaGw0C0XGa7nw@mail.gmail.com>
 <CAD21AoBte7CSVRpnOvXibYPsqOE9aswsp7jrQW+8fhwxRZFWpg@mail.gmail.com>
 <CAA5RZ0uOSnAKX4xF0PBSZqYCxUMTnheAKkcsiQDNYTZg20ognQ@mail.gmail.com>
 <CAD21AoBVwNJo9We6tT1p96ZMNZom7OCr4tx1Z3AiDTv1oS8Vjg@mail.gmail.com>
In-Reply-To: 
 <CAD21AoBVwNJo9We6tT1p96ZMNZom7OCr4tx1Z3AiDTv1oS8Vjg@mail.gmail.com>
From: Sami Imseih <samimseih@gmail.com>
Date: Thu, 9 Apr 2026 17:54:19 -0500
Message-ID: 
 <CAA5RZ0tLxDGS7p+H4LD-GbV4e6oQ8iHws_xLE6CvsSN_e8Ay_A@mail.gmail.com>
Subject: Re: test_autovacuum/001_parallel_autovacuum is broken
To: Masahiko Sawada <sawada.mshk@gmail.com>
Cc: Alexander Lakhin <exclusion@gmail.com>,
 pgsql-hackers <pgsql-hackers@postgresql.org>,
	Daniil Davydov <3danissimo@gmail.com>
Content-Type: multipart/mixed; boundary="000000000000485b7c064f0ee663"
Archived-At: 
 <https://www.postgresql.org/message-id/CAA5RZ0tLxDGS7p%2BH4LD-GbV4e6oQ8iHws_xLE6CvsSN_e8Ay_A%40mail.gmail.com>
Precedence: bulk

--000000000000485b7c064f0ee663
Content-Type: text/plain; charset="UTF-8"

> I believe that we don't need to worry about the regexp for this test.
> Parallel vacuum would be used on all tables having more than one
> index, but we enable the autovacuum logs only on the test_autovac
> table.

ah, correct.

```
) WITH (autovacuum_parallel_workers = $autovacuum_parallel_workers,
log_autovacuum_min_duration = 0);
```

see v3 with the reverted regexp string.

Thanks!

--
Sami

--000000000000485b7c064f0ee663
Content-Type: application/octet-stream;
	name="v3-0001-Fix-unstable-log_contains-in-parallel-autovacuum-.patch"
Content-Disposition: attachment;
	filename="v3-0001-Fix-unstable-log_contains-in-parallel-autovacuum-.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mns2q1p50>
X-Attachment-Id: f_mns2q1p50

RnJvbSBiZGQzNTUyZmViODkzZGQ1MmYyNTMzMmUyYzI3NTQ0ZGEyMmVlOWY2IE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBTYW1pIEltc2VpaCA8c2FtaW1zZWloQGdtYWlsLmNvbT4KRGF0
ZTogVGh1LCA5IEFwciAyMDI2IDIwOjA2OjAwICswMDAwClN1YmplY3Q6IFtQQVRDSCB2MyAxLzFd
IEZpeCB1bnN0YWJsZSBsb2dfY29udGFpbnMgaW4gcGFyYWxsZWwgYXV0b3ZhY3V1bSB0ZXN0cwoK
UmVwbGFjZSBsb2dfY29udGFpbnMgd2l0aCB3YWl0X2Zvcl9sb2cgaW4gdGhlIHBhcmFsbGVsIGF1
dG92YWN1dW0KdGVzdCB0byBlbnN1cmUgd2Ugd2FpdCBmb3IgdGhlIGxvZyBjb250YWluaW5nIHBh
cmFsbGVsIHZhY3V1bSBpbmZvLgpSZW1vdmUgd2FpdF9mb3JfYXV0b3ZhY3V1bV9jb21wbGV0ZSBh
cyB0aGUgbG9nIHdhaXQgaXMgc3VmZmljaWVudAp0byBkZXRlcm1pbmUgdmFjdXVtIGNvbXBsZXRp
b24uIFRoZSBxdWVyeSB0byBwZ19zdGF0X3VzZXJfdGFibGVzCmZvciB2YWN1dW0gY291bnQgaW4g
cHJlcGFyZV9mb3JfbmV4dF90ZXN0IGlzIGFsc28gcmVtb3ZlZCwgc2luY2UKdGhlIHByb29mIG9m
IHRoZSB2YWN1dW0gaWQgZGV0ZXJtaW5lZCBieSB0aGUgbG9nZ2luZy4KLS0tCiAuLi4vdC8wMDFf
cGFyYWxsZWxfYXV0b3ZhY3V1bS5wbCAgICAgICAgICAgICAgfCAzMSArKystLS0tLS0tLS0tLS0t
LS0tCiAxIGZpbGUgY2hhbmdlZCwgNSBpbnNlcnRpb25zKCspLCAyNiBkZWxldGlvbnMoLSkKCmRp
ZmYgLS1naXQgYS9zcmMvdGVzdC9tb2R1bGVzL3Rlc3RfYXV0b3ZhY3V1bS90LzAwMV9wYXJhbGxl
bF9hdXRvdmFjdXVtLnBsIGIvc3JjL3Rlc3QvbW9kdWxlcy90ZXN0X2F1dG92YWN1dW0vdC8wMDFf
cGFyYWxsZWxfYXV0b3ZhY3V1bS5wbAppbmRleCBmYzRkZDIyZjVlYi4uOWZlMGNmOGEzNDQgMTAw
NjQ0Ci0tLSBhL3NyYy90ZXN0L21vZHVsZXMvdGVzdF9hdXRvdmFjdXVtL3QvMDAxX3BhcmFsbGVs
X2F1dG92YWN1dW0ucGwKKysrIGIvc3JjL3Rlc3QvbW9kdWxlcy90ZXN0X2F1dG92YWN1dW0vdC8w
MDFfcGFyYWxsZWxfYXV0b3ZhY3V1bS5wbApAQCAtMTUsOCArMTUsNyBAQCBpZiAoJEVOVntlbmFi
bGVfaW5qZWN0aW9uX3BvaW50c30gbmUgJ3llcycpCiB9CiAKICMgQmVmb3JlIGVhY2ggdGVzdCB3
ZSBzaG91bGQgZGlzYWJsZSBhdXRvdmFjdXVtIGZvciAndGVzdF9hdXRvdmFjJyB0YWJsZSBhbmQK
LSMgZ2VuZXJhdGUgc29tZSBkZWFkIHR1cGxlcyBpbiBpdC4gUmV0dXJucyB0aGUgY3VycmVudCBh
dXRvdmFjdXVtX2NvdW50IG9mCi0jIHRoZSB0YWJsZSB0ZXN0X2F1dG92YWMuCisjIGdlbmVyYXRl
IHNvbWUgZGVhZCB0dXBsZXMgaW4gaXQuCiBzdWIgcHJlcGFyZV9mb3JfbmV4dF90ZXN0CiB7CiAJ
bXkgKCRub2RlLCAkdGVzdF9udW1iZXIpID0gQF87CkBAIC0yNiwyNCArMjUsNiBAQCBzdWIgcHJl
cGFyZV9mb3JfbmV4dF90ZXN0CiAJCUFMVEVSIFRBQkxFIHRlc3RfYXV0b3ZhYyBTRVQgKGF1dG92
YWN1dW1fZW5hYmxlZCA9IGZhbHNlKTsKIAkJVVBEQVRFIHRlc3RfYXV0b3ZhYyBTRVQgY29sXzEg
PSAkdGVzdF9udW1iZXI7CiAJfSk7Ci0KLQlteSAkY291bnQgPSAkbm9kZS0+c2FmZV9wc3FsKAot
CQkncG9zdGdyZXMnLCBxcXsKLQkJU0VMRUNUIGF1dG92YWN1dW1fY291bnQgRlJPTSBwZ19zdGF0
X3VzZXJfdGFibGVzIFdIRVJFIHJlbG5hbWUgPSAndGVzdF9hdXRvdmFjJwotCX0pOwotCi0JcmV0
dXJuICRjb3VudDsKLX0KLQotIyBXYWl0IGZvciB0aGUgdGFibGUgdG8gYmUgdmFjdXVtZWQgYnkg
YW4gYXV0b3ZhY3V1bSB3b3JrZXIuCi1zdWIgd2FpdF9mb3JfYXV0b3ZhY3V1bV9jb21wbGV0ZQot
ewotCW15ICgkbm9kZSwgJG9sZF9jb3VudCkgPSBAXzsKLQotCSRub2RlLT5wb2xsX3F1ZXJ5X3Vu
dGlsKAotCQkncG9zdGdyZXMnLCBxcXsKLQkJU0VMRUNUIGF1dG92YWN1dW1fY291bnQgPiAkb2xk
X2NvdW50IEZST00gcGdfc3RhdF91c2VyX3RhYmxlcyBXSEVSRSByZWxuYW1lID0gJ3Rlc3RfYXV0
b3ZhYycKLQl9KTsKIH0KIAogbXkgJG5vZGUgPSBQb3N0Z3JlU1FMOjpUZXN0OjpDbHVzdGVyLT5u
ZXcoJ21haW4nKTsKQEAgLTExOSw3ICsxMDAsNyBAQCAkbm9kZS0+c2FmZV9wc3FsKAogIyBPdXIg
dGFibGUgaGFzIGVub3VnaCBpbmRleGVzIGFuZCBhcHByb3ByaWF0ZSByZWxvcHRpb25zLCBzbyBh
dXRvdmFjdXVtIG11c3QKICMgYmUgYWJsZSB0byBwcm9jZXNzIGl0IGluIHBhcmFsbGVsIG1vZGUu
IEp1c3QgY2hlY2sgaWYgaXQgY2FuIGRvIGl0LgogCi1teSAkYXZfY291bnQgPSBwcmVwYXJlX2Zv
cl9uZXh0X3Rlc3QoJG5vZGUsIDEpOworcHJlcGFyZV9mb3JfbmV4dF90ZXN0KCRub2RlLCAxKTsK
IG15ICRsb2dfb2Zmc2V0ID0gLXMgJG5vZGUtPmxvZ2ZpbGU7CiAKICRub2RlLT5zYWZlX3BzcWwo
CkBAIC0xMjcsMTAgKzEwOCw4IEBAICRub2RlLT5zYWZlX3BzcWwoCiAJQUxURVIgVEFCTEUgdGVz
dF9hdXRvdmFjIFNFVCAoYXV0b3ZhY3V1bV9lbmFibGVkID0gdHJ1ZSk7CiB9KTsKIAotIyBXYWl0
IHVudGlsIHRoZSBwYXJhbGxlbCBhdXRvdmFjdXVtIG9uIHRhYmxlIGlzIGNvbXBsZXRlZC4gQXQg
dGhlIHNhbWUgdGltZSwKLSMgd2UgY2hlY2sgdGhhdCB0aGUgcmVxdWlyZWQgbnVtYmVyIG9mIHBh
cmFsbGVsIHdvcmtlcnMgaGFzIGJlZW4gc3RhcnRlZC4KLXdhaXRfZm9yX2F1dG92YWN1dW1fY29t
cGxldGUoJG5vZGUsICRhdl9jb3VudCk7Ci1vayggJG5vZGUtPmxvZ19jb250YWlucygKKyMgV2Fp
dCBmb3IgcGFyYWxsZWwgYXV0b3ZhY3V1bSB0byBjb21wbGV0ZTsgY2hlY2sgd29ya2VyIGNvdW50
IG1hdGNoZXMgcmVsb3B0aW9ucy4KK29rKCAkbm9kZS0+d2FpdF9mb3JfbG9nKAogCQlxci9wYXJh
bGxlbCB3b3JrZXJzOiBpbmRleCB2YWN1dW06IDIgcGxhbm5lZCwgMiBsYXVuY2hlZCBpbiB0b3Rh
bC8sCiAJCSRsb2dfb2Zmc2V0KSk7CiAKQEAgLTEzOCw3ICsxMTcsNyBAQCBvayggJG5vZGUtPmxv
Z19jb250YWlucygKICMgQ2hlY2sgd2hldGhlciBwYXJhbGxlbCBhdXRvdmFjdXVtIGxlYWRlciBj
YW4gcHJvcGFnYXRlIGNvc3QtYmFzZWQgcGFyYW1ldGVycwogIyB0byB0aGUgcGFyYWxsZWwgd29y
a2Vycy4KIAotJGF2X2NvdW50ID0gcHJlcGFyZV9mb3JfbmV4dF90ZXN0KCRub2RlLCAyKTsKK3By
ZXBhcmVfZm9yX25leHRfdGVzdCgkbm9kZSwgMik7CiAkbG9nX29mZnNldCA9IC1zICRub2RlLT5s
b2dmaWxlOwogCiAkbm9kZS0+c2FmZV9wc3FsKAotLSAKMi41MC4xCgo=
--000000000000485b7c064f0ee663--