pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #14580: pgbench bug
2+ messages / 2 participants
[nested] [flat]

* BUG #14580: pgbench bug
@ 2017-03-07 12:33 spesternikov@gmail.com
  2017-03-07 16:01 ` Re: BUG #14580: pgbench bug Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: spesternikov@gmail.com @ 2017-03-07 12:33 UTC (permalink / raw)
  To: pgsql-bugs

The following bug has been logged on the website:

Bug reference:      14580
Logged by:          Stepan Pesternikov
Email address:      spesternikov@gmail.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@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@0
--builtin=select-only@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@0'

If use option '-b select-only@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@0' works correctly.


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: BUG #14580: pgbench bug
  2017-03-07 12:33 BUG #14580: pgbench bug spesternikov@gmail.com
@ 2017-03-07 16:01 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2017-03-07 16:01 UTC (permalink / raw)
  To: spesternikov@gmail.com; +Cc: pgsql-bugs

spesternikov@gmail.com writes:
> Bug in pgbench with option --builtin

Hm, yeah, somebody seems to have fat-fingered the table entry for that.
For even more fun, what they left behind is broken in another way:

$ pgbench --tpc-b
Segmentation fault (core dumped)

Will fix, thanks for report.

			regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2017-03-07 16:01 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-03-07 12:33 BUG #14580: pgbench bug spesternikov@gmail.com
2017-03-07 16:01 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox