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 <thara...@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...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
