Re: pgbench logging broken by time logic changes
Fabien COELHO <coelho@cri.ensmp.fr>
From: Fabien COELHO <coelho@cri.ensmp.fr>
To: Thomas Munro <thomas.munro@gmail.com>
Cc: Michael Paquier <michael@paquier.xyz>,
Andrew Dunstan <andrew@dunslane.net>,
Alvaro Herrera <alvherre@alvh.no-ip.org>,
Gregory Smith <gregsmithpgsql@gmail.com>,
PostgreSQL-development <pgsql-hackers@postgresql.org>,
david.christensen@crunchydata.com
Date: 2021-07-11T13:07:09Z
Lists: pgsql-hackers
Attachments
- pgbench-time-test-1.patch (text/x-diff) patch
Hello Thomas, > I committed the code change without the new TAP tests, because I > didn't want to leave the open item hanging any longer. Ok. Good. > As for the test, ... [...] Argh, so there are no tests that would have caught the regressions:-( > ... I know it can fail, and your v18 didn't fix that, because... > > +check_pgbench_logs($bdir, '001_pgbench_log_1', $nthreads, 1, 3, > ... this range can be exceeded. Indeed. I meant to move that one in the TODO section as well, not just the previous call, so that all time-sensitive tests are fully ignored but reported, which would be enough for me. > I suspect the number of aggregates could be made deterministic, as I > described in an earlier message. What do you think about doing > something like that first for the next release, before trying to add > assertions about the number of aggregates? I think that last time I did something to get more deterministic results in pgbench, which involved a few lines of hocus-pocus in pgbench, the patch got rejected:-) An "ignored" tests looked like a good compromise to check how things are going in the farm and to be able to check for more non regressions when developing pgbench, without introducing behavioral changes. > I'm with you on the importance of testing, but it seems better to start > by making the thing more testable. I'm used to my test patches being rejected, including modifying pgbench behavior to make it more testable. Am I mad enough to retry? Maybe, maybe not. Attached the fully "ignored" version of the time features test as a patch. -- Fabien.
Commits
-
Fix pgbench timestamp bugs.
- 5614a0f78eaa 14.0 landed
- 0e39a608ed55 15.0 landed
-
Fix pattern matching logic for logs in TAP tests of pgbench
- 0efd2a1a66dd 11.13 landed
- 79ff96aa9d9a 12.8 landed
- 7a9eaf111ac0 13.4 landed
- c13585fe9e55 14.0 landed
-
pgbench: Improve time logic.
- 547f04e7348b 14.0 cited
-
pgbench: Synchronize client threads.
- aeb57af8e640 14.0 cited
-
pgbench: refactor handling of stats tracking
- b60376649600 9.6.0 cited