Skip to content

PG 14 pgbench automated tests fails #232

@onderkalaci

Description

@onderkalaci

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

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions