Skip site navigation (1) Skip section navigation (2)

Re: could not truncate directory "pg_subtrans": apparent wraparound

From: Mikko Partio <mpartio(at)gmail(dot)com>
To: Ray Stell <stellr(at)cns(dot)vt(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: could not truncate directory "pg_subtrans": apparent wraparound
Date: 2010-05-20 04:39:00
Message-ID: AANLkTikOXlslvSGhfI5m96EkUMznK-sLLnhVcUuqAks7@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Wed, May 19, 2010 at 3:21 PM, Ray Stell <stellr(at)cns(dot)vt(dot)edu> wrote:

> On Wed, May 19, 2010 at 08:40:04AM +0300, Mikko Partio wrote:
> >
> > May 16 01:17:35 xxx postgres[25550]: [1-1] LOG:  could not truncate
> > directory "pg_subtrans": apparent wraparound
> >
>
> http://archives.postgresql.org/pgsql-general/2007-06/msg01050.php
>


Browsing through that thread I can see that I have similar symptoms:

$ pg_controldata | grep Multi
Latest checkpoint's NextMultiXactId:  1
Latest checkpoint's NextMultiOffset:  0

$ ls -l $PGDATA/pg_multixact/members
total 8
-rw------- 1 postgres dba 8192 May  3 08:21 0000

$ ls -l $PGDATA/pg_multixact/offsets
total 8
-rw------- 1 postgres dba 8192 May  3 08:49 0000

I don't see any resolution to that thread though.

Regards

Mikko

In response to

Responses

pgsql-admin by date

Next:From: Narasimha Murthy-VRFX87Date: 2010-05-20 06:47:21
Subject: Re: Clarification Needed: When does autovacuum daemon run?
Previous:From: Mikko PartioDate: 2010-05-20 04:32:20
Subject: Re: could not truncate directory "pg_subtrans": apparent wraparound

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group