| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Geoffrey <esoteric(at)3times25(dot)net> |
| Cc: | PostgreSQL List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: sequence skips 30 values, how? |
| Date: | 2007-01-31 13:36:53 |
| Message-ID: | 20070131133653.GC22158@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Geoffrey wrote:
> 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.
Sequences are WAL-logged in chunks. So if you ask for a number and then
the process crashes, on recovery the sequence will resume generating
numbers at the start of the next chunk. I very much doubt that this
causes the crash itself; you should keep looking.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alban Hertroys | 2007-01-31 13:38:00 | Re: sequence skips 30 values, how? |
| Previous Message | A. Kretschmer | 2007-01-31 13:33:22 | Re: sequence skips 30 values, how? |