Re: Tables dissapearing

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Kamil Srot <kamil(dot)srot(at)nlogy(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Tables dissapearing
Date: 2007-08-27 16:47:56
Message-ID: 20070827164755.GD5353@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Aug 27, 2007 at 06:37:17PM +0200, Kamil Srot wrote:
> I don't say, it's gone by itself, I'm asking for help debuging this
> situation and hopefully find a solution. For the first time it happened,
> it had the same symptoms - this specific table was missing and
> transaction counter was wrapped-around. Now it seems to be the same but
> the transaction counters are far below the critical value...

You don't say explicitly, but when you say "vacuum all tables" you
didn't specify any tables names right? You just typed "vacuum". On each
database...

As for debugging, maybe something like:

select xmin, age(xmin) from pg_class;

Just to check the wraparound issue...

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-08-27 16:55:31 Re: Out of Memory - 8.2.4
Previous Message Tony Caduto 2007-08-27 16:47:15 Re: PostgreSQL vs Firebird feature comparison finished