Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1i06bP-0004Pf-Te
	for pgsql-bugs@arkaria.postgresql.org; Tue, 20 Aug 2019 16:03:20 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1i06bO-0007QH-Kp
	for pgsql-bugs@arkaria.postgresql.org; Tue, 20 Aug 2019 16:03:18 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <ziegenberg@web.de>)
	id 1i066o-0002mU-JX
	for pgsql-bugs@lists.postgresql.org; Tue, 20 Aug 2019 15:31:42 +0000
Received: from mx2a.mailbox.org ([2001:67c:2050:104:0:2:25:2]
 helo=mx2.mailbox.org)
	by makus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256)
	(Exim 4.92)
	(envelope-from <ziegenberg@web.de>)
	id 1i066l-0007Bo-8q
	for pgsql-bugs@lists.postgresql.org; Tue, 20 Aug 2019 15:31:41 +0000
Received: from smtp2.mailbox.org (smtp2.mailbox.org [80.241.60.241])
	(using TLSv1.2 with cipher ECDHE-RSA-CHACHA20-POLY1305 (256/256 bits))
	(No client certificate requested)
	by mx2.mailbox.org (Postfix) with ESMTPS id 82F3DA20E4;
	Tue, 20 Aug 2019 17:31:33 +0200 (CEST)
X-Virus-Scanned: amavisd-new at heinlein-support.de
Received: from smtp2.mailbox.org ([80.241.60.241])
	by spamfilter05.heinlein-hosting.de (spamfilter05.heinlein-hosting.de
 [80.241.56.123]) (amavisd-new, port 10030)
	with ESMTP id U9zNlNhQcvuJ; Tue, 20 Aug 2019 17:31:30 +0200 (CEST)
Date: Tue, 20 Aug 2019 17:31:26 +0200
In-Reply-To: 
 <CAMkU=1w7BtrvqghRdeJ1WGeeiP5UKhMYLAXxBuKR7JaSfuYsew@mail.gmail.com>
References: <15967-ae7fd939200f4547@postgresql.org>
 <CAMkU=1w7BtrvqghRdeJ1WGeeiP5UKhMYLAXxBuKR7JaSfuYsew@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="----A6CU31JV34Y2G4E0440QXGICSFXXSD"
Content-Transfer-Encoding: 7bit
Subject: Re: BUG #15967: Sequence generation using NEXTVAL() fails on 64bit
 systems
To: Jeff Janes <jeff.janes@gmail.com>,ziegenberg@web.de,pgsql-bugs
 <pgsql-bugs@lists.postgresql.org>
From: Christoph Ziegenberg <ziegenberg@web.de>
Message-ID: <E9CEB172-6CDC-49FF-AACD-AACCE88A76C6@web.de>
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Precedence: bulk

------A6CU31JV34Y2G4E0440QXGICSFXXSD
Content-Type: text/plain;
 charset=utf-8
Content-Transfer-Encoding: quoted-printable

We also had problems to reproduce it outside of the application, but are st=
ill working on an independent test script=2E

One special case is, that the application uses prepared statements for all=
 queries, also for the NEXTVAL() selection=2E

Christoph


Am 20=2E August 2019 15:44:55 MESZ schrieb Jeff Janes <jeff=2Ejanes@gmail=
=2Ecom>:
>>
>>
>> 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=3DDBI->connect("dbi:Pg:host=3D/tmp"); for (1=2E=2E1e6) {my $seq =3D
>$dbh->selectrow_array("select nextval('\''foo_seq'\'')");
>$dbh->do("insert
>into foo values (?)",undef,$seq);}'
>
>Cheers,
>
>Jeff

------A6CU31JV34Y2G4E0440QXGICSFXXSD
Content-Type: text/html;
 charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head></head><body>We also had problems to reproduce it outside of th=
e application, but are still working on an independent test script=2E<br><b=
r>One special case is, that the application uses prepared statements for al=
l queries, also for the NEXTVAL() selection=2E<br><br>Christoph<br><br><br>=
<div class=3D"gmail_quote">Am 20=2E August 2019 15:44:55 MESZ schrieb Jeff =
Janes &lt;jeff=2Ejanes@gmail=2Ecom&gt;:<blockquote class=3D"gmail_quote" st=
yle=3D"margin: 0pt 0pt 0pt 0=2E8ex; border-left: 1px solid rgb(204, 204, 20=
4); padding-left: 1ex;">
<div dir=3D"ltr"><div class=3D"gmail_quote"><blockquote class=3D"gmail_quo=
te" style=3D"margin:0px 0px 0px 0=2E8ex;border-left:1px solid rgb(204,204,2=
04);padding-left:1ex"><br>I did many tests:<br></blockquote><div>&nbsp;</di=
v><div>Can you include the code which implements those tests?&nbsp;</div><d=
iv><br></div><div>I can't reproduce with something like this:</div><div><br=
></div><div>perl -e 'use DBI; fork; fork; fork; my $dbh=3DDBI-&gt;connect("=
dbi:Pg:host=3D/tmp"); for (1=2E=2E1e6) {my $seq =3D $dbh-&gt;selectrow_arra=
y("select nextval('\''foo_seq'\'')"); $dbh-&gt;do("insert into foo values (=
?)",undef,$seq);}'<br></div><div><br></div><div>Cheers,</div><div><br></div=
><div>Jeff</div></div></div>
</blockquote></div></body></html>
------A6CU31JV34Y2G4E0440QXGICSFXXSD--