Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group