From: Christoph Ziegenberg <ziegenberg@web.de>
To: Jeff Janes <jeff.janes@gmail.com>
To: ziegenberg@web.de,pgsql-bugs <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #15967: Sequence generation using NEXTVAL() fails on 64bit systems
Date: Tue, 20 Aug 2019 17:31:26 +0200
Message-ID: <E9CEB172-6CDC-49FF-AACD-AACCE88A76C6@web.de> (raw)
In-Reply-To: <CAMkU=1w7BtrvqghRdeJ1WGeeiP5UKhMYLAXxBuKR7JaSfuYsew@mail.gmail.com>
References: <15967-ae7fd939200f4547@postgresql.org>
<CAMkU=1w7BtrvqghRdeJ1WGeeiP5UKhMYLAXxBuKR7JaSfuYsew@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: ziegenberg@web.de, jeff.janes@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #15967: Sequence generation using NEXTVAL() fails on 64bit systems
In-Reply-To: <E9CEB172-6CDC-49FF-AACD-AACCE88A76C6@web.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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