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-18 09:08:11
Message-ID: 1182157691.494610.260120@c77g2000hse.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Jun 13, 2:35 pm, g(dot)hinterma(dot)(dot)(dot)(at)inode(dot)at wrote:
> 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

Can someone tell me if I should be concerned about this log entry ? My
database is quite large (~ 2G in PGDATA)

regards
Gerhard

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sabin Coanda 2007-06-18 09:35:10 statistics on CRUD operations
Previous Message Dave Page 2007-06-18 08:00:37 Re: Problem editing tables (geom columns)