Error on pgbench logs
YoungHwan Joo <rulyox@gmail.com>
From: YoungHwan Joo <rulyox@gmail.com>
To: pgsql-hackers@lists.postgresql.org
Date: 2021-06-08T03:09:47Z
Lists: pgsql-hackers
Attachments
- bad_547f04e7348b6ed992bd4a197d39661fe7c25097_1.png (image/png)
- good_b1d6a8f86813772b9198367a34c8ff8bff7fef9e_1.png (image/png)
- good_b1d6a8f86813772b9198367a34c8ff8bff7fef9e_2.png (image/png)
- good_b1d6a8f86813772b9198367a34c8ff8bff7fef9e_3.png (image/png)
Hello! While I was using pgbench from the master branch, I discovered an error on pgbench logs. When I run pgbench, the log file contains a lot of redundant 0s. I ran git bisect and found out that this error occured since the commit 547f04e7348b6ed992bd4a197d39661fe7c25097 (Mar 10, 2021). I ran the tests below on the problematic commit and the commit before it. (I used Debian 10.9 and Ubuntu 20.04) ===== ./pg_ctl -D /tmp/data init ./pg_ctl -D /tmp/data start ./pgbench -i -s 1 postgres ./pgbench -r -c 1 -j 1 -T 1 --aggregate-interval 1 -l --log-prefix pgbench-log postgres ./pgbench -r -c 2 -j 4 -T 60 --aggregate-interval 1 -l --log-prefix pgbench-log postgres ./pgbench -r -c 2 -j 4 -T 60 --aggregate-interval 10 -l --log-prefix pgbench-log postgres ===== The result screenshots are in the attachments. (I didn't attach the problematic 60 second log file which was bigger than 1GB.) Please take a look at this issue. Thank you! Regards, YoungHwan
Commits
-
Fix pgbench timestamp bugs.
- 5614a0f78eaa 14.0 landed
- 0e39a608ed55 15.0 landed
-
pgbench: Improve time logic.
- 547f04e7348b 14.0 cited
-
Make [U]INT64CONST safe for use in #if conditions.
- 9d6b160d7db7 11.0 cited
-
Teach libpq to detect integer overflow in the row count of a PGresult.
- 2e70d6b5e99b 11.0 cited