Re: Apparent Wraparound? - Mailing list pgsql-general

From g.hintermayer@inode.at
Subject Re: Apparent Wraparound?
Date
Msg-id 1182157691.494610.260120@c77g2000hse.googlegroups.com
Whole thread Raw
In response to Re: Apparent Wraparound?  (g.hintermayer@inode.at)
Responses Re: Apparent Wraparound?
List pgsql-general
On Jun 13, 2:35 pm, g.hinterma...@inode.at wrote:
> On Jun 8, 3:23 pm, alvhe...@commandprompt.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


pgsql-general by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: is it possible to recover more than one recordset or cursor from a function?
Next
From: "Sabin Coanda"
Date:
Subject: statistics on CRUD operations