sequences problem

From: gsmd(at)gmx-topmail(dot)de
To: pgsql-bugs(at)postgresql(dot)org
Subject: sequences problem
Date: 2006-05-18 06:05:03
Message-ID: 20060518060503.27260@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

>Could you provide a complete test case?
As I've been told, there is no special code, just a usual sequence usage. There is no small part of code that can be reproduced.
--
The situation is that there are 2 applications working with the same DB and accessing sequences. Each time application is started the sequences are reloaded (without doing this the sequences go crazy, e.g. you can get 1000 with 5 being the last value).
--
> Is it possible that another session is altering the sequence to
> start with a lower value?
No, as only next value is called.

Have you perchance set the sequence's
> CACHE setting to a value other than 1 (one)?
No.

> What's the output of
> "SELECT * FROM sequence_name"?
ERROR: relation "sequence_name" does not exist

> Are you making queries from more
> than one session? Are you using connection pooling?
Yes. No.

Thank you.

On 4/7/06, Michael Fuhr <mike(at)fuhr(dot)org> wrote:
> On Thu, Apr 06, 2006 at 10:04:03AM +0000, Alex Fomin wrote:
> > While using the following function:
> > ---
> > nextval(sequence_name) returns currval(sequence_name) -1
> > ---
> > while +1 is expected. It happens only sometimes, no dependency can be found.
>
> Could you provide a complete test case? That is, all SQL statements
> that somebody could execute in an empty database to reproduce the
> problem. It doesn't have to be 100% reproducible as long as it
> does exhibit the behavior every once in a while (an indication of
> how often or under what circumstances, if known, would be helpful).
>
> Is it possible that another session is altering the sequence to
> start with a lower value? Have you perchance set the sequence's
> CACHE setting to a value other than 1 (one)? What's the output of
> "SELECT * FROM sequence_name"? Are you making queries from more
> than one session? Are you using connection pooling?
>
> --
> Michael Fuhr
>
> --

Bis zu 70% Ihrer Onlinekosten sparen: GMX SmartSurfer!
Kostenlos downloaden: http://www.gmx.net/de/go/smartsurfer

--

Bis zu 70% Ihrer Onlinekosten sparen: GMX SmartSurfer!
Kostenlos downloaden: http://www.gmx.net/de/go/smartsurfer

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message nikolaus klepp 2006-05-18 09:57:59 BUG #2443: 1 hour error at date calculation
Previous Message Qingqing Zhou 2006-05-18 01:57:50 Re: BUG #2442: Problemas accessing DB in a multithread pross