Skip site navigation (1) Skip section navigation (2)

BUG #14580: pgbench bug

From: spesternikov(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14580: pgbench bug
Date: 2017-03-07 12:33:47
Message-ID: 20170307123347.25054.73207@wrigleys.postgresql.org (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14580
Logged by:          Stepan Pesternikov
Email address:      spesternikov(at)gmail(dot)com
PostgreSQL version: 9.6.2
Operating system:   Linux
Description:        

Bug in pgbench with option --builtin


Environment:
RDBMS

postgres=# select version();
                                                 version                    
                             
----------------------------------------------------------------------------------------------------------
 PostgreSQL 9.6.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5
20150623 (Red Hat 4.8.5-11), 64-bit

Operating system

[root(at)kiselev ~]# cat /etc/redhat-release 
CentOS Linux release 7.3.1611 (Core)

After start pgbench

-bash-4.2$ /usr/pgsql-9.6/bin/pgbench --host=localhost --username=postgres
--transactions=1000 --client=100 --jobs=10 -b tpcb-like(at)0
--builtin=select-only(at)0 --no-vacuum
--file=/var/lib/pgsql/9.6/pgbench_test.sql postgres

occur error:

/usr/pgsql-9.6/bin/pgbench: unrecognized option '--builtin=select-only(at)0'

If use option '-b select-only(at)0', error doesn't occur.

Solution:
Preparing:
$ git clone git://git.postgresql.org/git/postgresql.git
$ git checkout remotes/origin/REL9_6_STABLE

In file 'src/bin/pgbench/pgbench.c' replace string

{"tpc-b", no_argument, NULL, 'b'}

the string

{"builtin", required_argument, NULL, 'b'}

Then './configure', 'make', 'make check', 'make install'
Option '--builtin=select-only(at)0' works correctly.


Responses

pgsql-bugs by date

Next:From: stepyaDate: 2017-03-07 14:12:01
Subject: BUG #14581: invalid cache ID: 41 CONTEXT: parallel worker
Previous:From: Masahiko SawadaDate: 2017-03-07 10:55:58
Subject: Re: Two phase commit in ECPG

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group