We also had problems to reproduce it outside of the application, but are still working on an independent test script.
One special case is, that the application uses prepared statements for all queries, also for the NEXTVAL() selection.
Christoph
Am 20. August 2019 15:44:55 MESZ schrieb Jeff Janes <jeff.janes@gmail.com>:
I did many tests:
Can you include the code which implements those tests?
I can't reproduce with something like this:
perl -e 'use DBI; fork; fork; fork; my $dbh=DBI->connect("dbi:Pg:host=/tmp"); for (1..1e6) {my $seq = $dbh->selectrow_array("select nextval('\''foo_seq'\'')"); $dbh->do("insert into foo values (?)",undef,$seq);}'
Cheers,
Jeff