Sounds like a bug. We should either fix pgbench so that -M and -C can
be used together (I don't see any technical reason why we can't do
this) or modify pgbench to not allow using -M and -C (less desirable).
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
From: Robins Tharakan <tharakan@gmail.com>
Subject: [BUGS] pgbench -C -M prepared gives an error
Date: Tue, 15 Mar 2016 19:18:47 +0000
Message-ID: <CAEP4nAwqG-XufE95gpCs2dpxmV7579c3AWjgEpW=xAE7+44_cw@mail.gmail.com>
> 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@pi2:/opt/postgres/master/bin $ ./createdb pgbench
> robins@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@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@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