Re: [GENERAL] Clog/Transaction problems

2005-08-05 Thread Alvaro Herrera
On Fri, Aug 05, 2005 at 04:52:29PM -0400, Logan Bowers wrote: > Hello, > > > > I have a really weird problem; queries against a very large table are > failing against a very large table with a strange error. Case in point: > > > > dqfull=# vacuum freeze mytable; > > ERROR: could not acc

[GENERAL] Clog/Transaction problems

2005-08-05 Thread Logan Bowers
Hello,   I have a really weird problem; queries against a very large table are failing against a very large table with a strange error.  Case in point:   dqfull=# vacuum freeze mytable; ERROR:  could not access status of transaction 538989714 DETAIL:  could not open file "/srv/db/pos