sequence skips 30 values, how?

From: Geoffrey <esoteric(at)3times25(dot)net>
To: PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: sequence skips 30 values, how?
Date: 2007-01-31 12:43:05
Message-ID: 45C08ED9.9000200@3times25.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We are trying to track down an issue with our PostgreSQL application.
We are running PostgreSQL 7.4.13 on Red Hat Enterprise ES 3.

We have a situation where the postgres backend process drops core and
dies. We've tracked this to an unusual situation where a sequence value
that is being created during the process that is causing the core file
generation. The thing that is bizarre is that the sequence value skips
30+ entries.

How is this even possible? Any suggestions would be greatly appreciated.

--
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2007-01-31 13:33:22 Re: sequence skips 30 values, how?
Previous Message Ron Johnson 2007-01-31 12:40:27 Re: Any Plans for cross database queries on the same server?