Re: Re: Vaccuum Failure w/7.1beta4 on Linux/Sparc -- FALSE ALARM
Ryan Kirkpatrick <pgsql@rkirkpat.net>
From: Ryan Kirkpatrick <pgsql@rkirkpat.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@postgresql.org
Date: 2001-03-28T03:32:02Z
Lists: pgsql-hackers
On Mon, 26 Mar 2001, Tom Lane wrote: > Ryan Kirkpatrick <pgsql@rkirkpat.net> writes: > > On Mon, 12 Mar 2001, Ryan Kirkpatrick wrote: > >> While testing some existing database applications on 7.1beta4 on > >> my Sparc 20 running Debian GNU/Linux 2.2, I got the following error on > >> attempting to do a vacuum of a table: > >> > >> NOTICE: FlushRelationBuffers(jobs, 1399): block 953 is referenced (private 0, global 1) > >> ERROR! Can't vacuum table Jobs! ERROR: VACUUM (repair_frag): FlushRelationBuffers returned -2 > > This is probably explained by the problem we found a few days ago with > BufferSync acquiring locks it shouldn't. Yea, it was. I just tried RC1 on the Sparc with my application, with the data directory NFS mounted, and it ran without errors now. Thanks. :) --------------------------------------------------------------------------- | "For to me to live is Christ, and to die is gain." | | --- Philippians 1:21 (KJV) | --------------------------------------------------------------------------- | Ryan Kirkpatrick | Boulder, Colorado | http://www.rkirkpat.net/ | ---------------------------------------------------------------------------