pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kris Kiger <kris@musicrebellion.com>
To: Michael Fuhr <mike@fuhr.org>
Cc: Scott Marlowe <smarlowe@g2switchworks.com>
Cc: Pgsql-Admin (E-mail) <pgsql-admin@postgresql.org>
Subject: Re: Very worried about this
Date: Thu, 24 Mar 2005 17:01:21 -0500
Message-ID: <424338B1.9050501@musicrebellion.com> (raw)
In-Reply-To: <20050324215234.GA33036@winnie.fuhr.org>
References: <42432F48.8060103@musicrebellion.com>
	<1111700264.12450.10.camel@state.g2switchworks.com>
	<424334DE.4020908@musicrebellion.com>
	<20050324215234.GA33036@winnie.fuhr.org>

Heh, I see.  The sequence currval was set lower than what was already in 
the table.  It just so happened we had holes in our data for the values 
it was selecting.  Thanks for pointing that out!

Kris

Michael Fuhr wrote:

>On Thu, Mar 24, 2005 at 04:45:02PM -0500, Kris Kiger wrote:
>
>  
>
>>I'm positive no one else has been in the database.  There are two of us 
>>who work on it and we have been side by side all afternoon.  The problem 
>>appears to be purely internal to the database.  I'm running more tests 
>>as we speak and we are still recieving the same sporadic errors.  It 
>>works for a long amount of time and then the error occurs, but then 
>>things work fine again for a while.  The inconsistency is quite troubling.
>>    
>>
>
>What are the results of the following queries?
>
>SELECT max(d_id) FROM hd;
>SELECT * FROM hd_d_id_seq;
>
>  
>




view thread (7+ messages)

Message-ID: <424338B1.9050501@musicrebellion.com>
Permalink:  ../424338B1.9050501@musicrebellion.com/
Also on:    postgresql.org/message-id/424338B1.9050501@musicrebellion.com

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: kris@musicrebellion.com, mike@fuhr.org, smarlowe@g2switchworks.com
  Subject: Re: Very worried about this
  In-Reply-To: <424338B1.9050501@musicrebellion.com>
  References: <42432F48.8060103@musicrebellion.com> <1111700264.12450.10.camel@state.g2switchworks.com> <424334DE.4020908@musicrebellion.com> <20050324215234.GA33036@winnie.fuhr.org> <424338B1.9050501@musicrebellion.com>

* 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