Re: [HACKERS] vacuum analyze problem - Mailing list pgsql-hackers

From Thomas G. Lockhart
Subject Re: [HACKERS] vacuum analyze problem
Date
Msg-id 36183CDF.5C3F448C@alumni.caltech.edu
Whole thread Raw
In response to vacuum analyze problem  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-hackers
> cvs still has problem with vacuum analyze on my Linux machine:
> after completion of regression test which passed fine I tried
> vacuum analyze on regression db and got
> NOTICE:  AbortTransaction and not in in-progress state
> NOTICE:  AbortTransaction and not in in-progress state
*snip*
> Earlier this happened only if I run postmaster with number of buffers > 128 and never happens when I run regression
testfollowing procedure 
> described in INSTALL.

I'm not seeing this problem on my Linux machine (2.0.30 kernel) so it
probably isn't a general problem with Linux. I haven't done a completely
new refresh of my sources for at least a few days, though I don't think
this is the problem because you've been seeing something like this on
your machine for a while.

Your problem would be easier to diagnose if someone could reproduce it
on another machine, but if the test is as simple as trying a vacuum on
the regression database then it's easy to test and we aren't finding it
happening everywhere :(

Keep plugging away at it though because there's always a chance that
your particular machine is uncovering an obscure feature of the code...

                    - Tom

pgsql-hackers by date:

Previous
From: "Thomas G. Lockhart"
Date:
Subject: Re: pg_dump new -n flag
Next
From: "Marc G. Fournier"
Date:
Subject: Re: [HACKERS] Dumping of views -- done!