pgbench -C -M prepared gives an error

From: Robins Tharakan <tharakan(at)gmail(dot)com>
To: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: pgbench -C -M prepared gives an error
Date: 2016-03-15 19:18:47
Message-ID: CAEP4nAwqG-XufE95gpCs2dpxmV7579c3AWjgEpW=xAE7+44_cw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Hi,

When trying pgbench with -C -M prepared gives an error (see log below).

It probably doesn't make sense (to have both options together), but
shouldn't it still PREPARE per connection, or exit gracefully / document
this?

robins(at)pi2:/opt/postgres/master/bin $ ./createdb pgbench
robins(at)pi2:/opt/postgres/master/bin $ ./pgbench -i pgbench
NOTICE: table "pgbench_history" does not exist, skipping
NOTICE: table "pgbench_tellers" does not exist, skipping
NOTICE: table "pgbench_accounts" does not exist, skipping
NOTICE: table "pgbench_branches" does not exist, skipping
creating tables...
100000 of 100000 tuples (100%) done (elapsed 0.93 s, remaining 0.00 s)
vacuum...
set primary keys...
done.
robins(at)pi2:/opt/postgres/master/bin $ ./pgbench -M prepared -C pgbench
starting vacuum...end.
client 0 aborted in state 7: ERROR: prepared statement "P0_7" does not
exist
transaction type: <builtin: TPC-B (sort of)>
scaling factor: 1
query mode: prepared
number of clients: 1
number of threads: 1
number of transactions per client: 10
number of transactions actually processed: 1/10
latency average: 0.000 ms
tps = 22.399928 (including connections establishing)
tps = 52.598359 (excluding connections establishing)
robins(at)pi2:/opt/postgres/master/bin $ ./psql -U postgres -c "select
version();"
version
----------------------------------------------------------------------------------------------------------
PostgreSQL 9.6devel on armv7l-unknown-linux-gnueabihf, compiled by gcc
(Raspbian 4.9.2-10) 4.9.2, 32-bit
(1 row)

-
robins

--

-
robins

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2016-03-15 20:40:26 Re: BUG #13750: Autovacuum slows down with large numbers of tables. More workers makes it slower.
Previous Message Léonard Benedetti 2016-03-15 17:44:57 Re: BUG #13440: unaccent does not remove all diacritics

Browse pgsql-hackers by date

  From Date Subject
Next Message David Steele 2016-03-15 19:28:36 Re: [PATCH] Supporting +-Infinity values by to_timestamp(float8)
Previous Message Pavel Stehule 2016-03-15 19:09:16 Re: proposal: function parse_ident