Is this expected?

[gamename]

Hi,

I'm getting the following errors during the test run (below). Should they be happening?

{{{
Run set #2 of 3 with 16 clients scale=1
Running tests using: psql -h localhost -U postgres -p 5432 -d pgbench
Storing results using: psql -h localhost -U postgres -p 5432 -d results
Found standard pgbench tables with prefix=pgbench_
Cleaning up database pgbench
TRUNCATE TABLE
Skipping vacuum, it was recently ran by the last test
CHECKPOINT
Waiting for checkpoint statistics
INSERT 0 1
This is test 11
Script select.sql executing for 16 concurrent users...
./benchwarmer: line 229: 25716 Killed ./timed-os-stats vmstat > results/$TEST/vmstat.log (wd: ~/pgbench-tools-master)
Traceback (most recent call last):
File "../../kill_pg", line 29, in
kill_pg(int(sys.argv[1]))
File "../../kill_pg", line 12, in kill_pg
pgid = os.getpgid(pid)
OSError: [Errno 3] No such process
./benchwarmer: line 229: 25718 Killed ./timed-os-stats meminfo > results/$TEST/meminfo.log (wd: ~/pgbench-tools-master)
UPDATE 1
transaction type: Custom query
scaling factor: 1
query mode: simple
number of clients: 16
number of threads: 1
duration: 60 s
number of transactions actually processed: 298863
tps = 4979.932254 (including connections establishing)
tps = 4989.163544 (excluding connections establishing)
Cleaning up database pgbench
TRUNCATE TABLE
VACUUM
CHECKPOINT
Worst latency results:
218952
246585
252718
265586
284780

gnuplot> set xlabel 'Time'; set ylabel 'wMB/s'; plot
^
line 0: function to plot expected

gnuplot> set xlabel 'Time'; set ylabel 'rMB/s'; plot
^
line 0: function to plot expected

gnuplot> set xlabel 'Time'; set ylabel '%util'; plot
^
line 0: function to plot expected

Run set #2 of 3 with 32 clients scale=1
}}}

[gregs1104]

The kill errors and "No such process" ones are normal, I just haven't filtered those out of the script's output yet. There are some normal gnuplot warnings, but those errors look like your version isn't accepting the commands the program gives it at all. I doubt a graph came out of there. Not sure what's going on there. I'd need to know your gnuplot version and platform to get an idea what might be going on.

[sbailliez]

I'm getting similar errors, while I figured out the no such process seems to be normal, I have the gnuplot issues "function to plot expected" appearing.

version of gnuplot is gnuplot 4.2 patchlevel 6

note that I also have to install liberation-sans-fonts to avoid the gnuplot warning messages

yum install liberation-sans-fonts
export GDFONTPATH=/usr/share/fonts/liberation
export GNUPLOT_DEFAULT_GDFONT=LiberationSans-Regular

[sbailliez]

Update:
After digging into the scripts and enabling debug output on the csv2gnuplot script, I found out that:

• it was missing iostat, so needed to install sysstat package
• the disklist in config was set to sda while I have no sda but xvda and xvdb

this was what explained the empty set of data passed to gnuplot