-
Notifications
You must be signed in to change notification settings - Fork 3
Open
Description
It seems like pgbench output format has changed, and our scripts fails to parse the output
[localhost] out: progress: 600.0 s, 2388.9 tps, lat 329.801 ms stddev 724.856
[localhost] out: transaction type: <builtin: TPC-B (sort of)>
[localhost] out: scaling factor: 100
[localhost] out: query mode: simple
[localhost] out: number of clients: 796
[localhost] out: number of threads: 32
[localhost] out: duration: 600 s
[localhost] out: number of transactions actually processed: 1663702
[localhost] out: latency average = 287.030 ms
[localhost] out: latency stddev = 524.726 ms
[localhost] out: initial connection time = 326.291 ms
[localhost] out: tps = 2770.785214 (without initial connection time)
[localhost] out: statement latencies in milliseconds:
[localhost] out: 0.006 \set aid random(1, 100000 * :scale)
[localhost] out: 0.003 \set bid random(1, 1 * :scale)
[localhost] out: 0.003 \set tid random(1, 10 * :scale)
[localhost] out: 0.003 \set delta random(-5000, 5000)
[localhost] out: 0.447 BEGIN;
[localhost] out: 8.885 UPDATE pgbench_accounts SET abalance = abalance + :delta WHERE aid = :aid;
[localhost] out: 4.306 SELECT abalance FROM pgbench_accounts WHERE aid = :aid;
[localhost] out: 141.791 UPDATE pgbench_tellers SET tbalance = tbalance + :delta WHERE tid = :tid;
[localhost] out: 101.743 UPDATE pgbench_branches SET bbalance = bbalance + :delta WHERE bid = :bid;
[localhost] out: 5.510 INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (:tid, :bid, :aid, :delta, CURRENT_TIMESTAMP);
[localhost] out: 24.380 END;
[localhost] out:
Traceback (most recent call last):
File "/home/pguser/.local/lib/python2.7/site-packages/fabric/main.py", line 757, in main
*args, **kwargs
File "/home/pguser/.local/lib/python2.7/site-packages/fabric/tasks.py", line 386, in execute
multiprocessing
File "/home/pguser/.local/lib/python2.7/site-packages/fabric/tasks.py", line 276, in _execute
return task.run(*args, **kwargs)
File "/home/pguser/.local/lib/python2.7/site-packages/fabric/tasks.py", line 173, in run
return self.wrapped(*args, **kwargs)
File "/home/pguser/.local/lib/python2.7/site-packages/fabric/decorators.py", line 142, in decorated
decorated.return_value = func(*args, **kwargs)
File "/home/pguser/.local/lib/python2.7/site-packages/fabric/decorators.py", line 56, in inner_decorator
return func(*args, **kwargs)
File "/home/pguser/fabfile/run.py", line 100, in pgbench_tests
re.search('tps = (.+?) \(including connections establishing\)', out_val).group(1)
AttributeError: 'NoneType' object has no attribute 'group'
Metadata
Metadata
Assignees
Labels
No labels