Re: Apparent Wraparound?

From: g(dot)hintermayer(at)inode(dot)at
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Apparent Wraparound?
Date: 2007-06-13 12:35:51
Message-ID: 1181738151.663659.258770@o11g2000prd.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Jun 8, 3:23 pm, alvhe(dot)(dot)(dot)(at)commandprompt(dot)com (Alvaro Herrera) wrote:
> Gunther Mayer wrote:
> > Hi there,
>
> > I just found the following message in my logs:
>
> > Jun 8 10:38:38 caligula postgres[56868]: [1-1] : LOG: could not
> > truncate directory "pg_subtrans": apparent wraparound
>
> > Should I be worried or can I just ignore this one? My database is still
> > small (a pg_dumpall bzippe'd is still around 500KB) so I doubt that I'm
> > affected by any transaction id wraparound problems. I also vacuum
> > analyze once a day and have pg_autovacuum turned on.
>
> What version are you running? This seems to match the description of a
> bug fixed for 8.2 and 8.1.5:
>

I noticed the same message in my logfiles (once on each of two
servers). I'm running 8.1.8, and the server's been running flawless
for about 2 months.

Gerhard

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2007-06-13 12:55:13 Re: [SQL] setof or array as input parameter to postgresql 8.2 functions
Previous Message Gabriele 2007-06-13 12:08:59 Re: PostGreSQL for a small Desktop Application