Re: [HACKERS] WIP Patch: Pgbench Serialization and deadlock errors

On 25-03-2018 15:23, Fabien COELHO wrote:
>> Hm, I took a look on both thread about patch and it seems to me now
>> it's overcomplicated. With recently committed enhancements of pgbench
>> (\if, \when) it becomes close to impossible to retry transation in
>> case of failure. So, initial approach just to rollback such
>> transaction looks more attractive.
>
> Yep.

Many thanks to both of you! I'm working on a patch in this direction..

> I think that the best approach for now is simply to reset (command
> zero, random generator) and start over the whole script, without
> attempting to be more intelligent. The limitations should be clearly
> documented (one transaction per script), though. That would be a
> significant enhancement already.

I'm not sure that we can always do this, because we can get new errors
until we finish the failed transaction block, and we need destroy the
conditional stack..

--
Marina Polyakova
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company