Error on pgbench logs

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

Responses

Browse pgsql-hackers by date

  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?