Re: pgbench error: (setshell) of script 0; execution of meta-command failed

Hi,

On Fri, 10 Jan 2025 at 10:10, Andy Fan <zhihuifan1213@163.com> wrote:
>
> Andy Fan <zhihuifan1213@163.com> writes:
>
> > Hi:
> >
> > I run into the {subject} issue with the below setup.
> >
> > cat foo.sql
> >
> > \setshell txn_mode echo ${TXN_MODE}
> > \setshell speed echo ${SPEED}
> > \setshell sleep_ms echo ${SLEEP_MS}
> > \setshell subtxn_mode echo ${SUBTXN_MODE}
> >
> > select 1;
> >
> > $ TXN_MODE=-1 SPEED=1 SLEEP_MS=0 SUBTXN_MODE=-1 pgbench -n -ffoo.sql postgres -T5 -c4 --exit-on-abort
> >
> > I *randomly*(7/8) get errors like:
> >
> > pgbench (18devel)
> > pgbench: error: client 2 aborted in command 0 (setshell) of script 0; execution of meta-command failed
> > pgbench: error: Run was aborted due to an error in thread 0
>
> I think I have figured out the issue, if you want reproduce it quicker,
> you can change the '-T5' to '-T1' in the pgbench command and run many times.

I ran it ~500 times on HEAD but the issue did not occur on my machine.
Is 500 times not enough?

-- 
Regards,
Nazir Bilal Yavuz
Microsoft