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

Re: Crash with pg_clog file not found

From: "Matthieu Roger" <matthieu(dot)roger(at)gene6(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Crash with pg_clog file not found
Date: 2008-11-03 15:49:34
Message-ID: 30111ec50811030749h5f2da74bq3d3c071ea26d764a@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
2008/11/3 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> "Matthieu Roger" <matthieu(dot)roger(at)gene6(dot)com> writes:
>> 2008-10-31 20:14:27 CET 10.0.0.119 exile PANIC:  could not access
>> status of transaction 0
>
> Can you present a self-contained test case that causes that?

Hello Tom,

we were not able to reproduce at will :-( it seems to happen after
running for 1 week, sometimes less, always for the same base, I know
not helpful at all ...

> A stack trace from the PANIC would be mighty useful too, but I dunno
> whether there's any point in asking for that from a Windows system.

Anyway to do that under windows ?

8.3.3 was also producing the same error, prior version (8.3.1) did not
seem to exhibit it, though we've opened a new universe in the web game
which increased the number of accounts and players in september so
maybe this triggers the problem.

I know this is not much helping, if there is any debug build I could run ...

Matthieu

In response to

Responses

pgsql-admin by date

Next:From: Scott MarloweDate: 2008-11-03 16:04:57
Subject: Re: Crash with pg_clog file not found
Previous:From: Carol WalterDate: 2008-11-03 15:24:04
Subject: Re: Lock them out?

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