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
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) |