From: | YoungHwan Joo <rulyox(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
Subject: | Error on pgbench logs |
Date: | 2021-06-08 03:09:47 |
Message-ID: | CAF7igB1r6wRfSCEAB-iZBKxkowWY6+dFF2jObSdd9+iVK+vHJg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
Attachment | Content-Type | Size |
---|---|---|
image/png | 71.8 KB | |
image/png | 18.7 KB | |
good_b1d6a8f86813772b9198367a34c8ff8bff7fef9e_2.png | image/png | 111.0 KB |
image/png | 33.6 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2021-06-08 03:24:31 | Re: Multiple hosts in connection string failed to failover in non-hot standby mode |
Previous Message | Kyotaro Horiguchi | 2021-06-08 03:04:43 | Re: Duplicate history file? |