| 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: | Whole Thread | Raw Message | 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? |