close
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
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions