Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

PG 14 pgbench automated tests fails #232

Open
onderkalaci opened this issue Sep 3, 2021 · 0 comments
Open

PG 14 pgbench automated tests fails #232

onderkalaci opened this issue Sep 3, 2021 · 0 comments

Comments

@onderkalaci
Copy link
Member

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'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant