Re: Beta 6 Regression results on Redat 7.0.
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Lamar Owen <lamar.owen@wgcr.org>
Cc: pgsql-hackers@postgresql.org
Date: 2001-03-20T23:22:42Z
Lists: pgsql-hackers
Lamar Owen <lamar.owen@wgcr.org> writes: > I'm hoping it was a problem on my machine -- educate me on > what caused the error Well, that's exactly what I'd like to know. The direct cause of the error is that DROP TABLE is finding that some other backend has a reference-count hold on a page of the temp table it's trying to drop. Since no other backend should be trying to touch this temp table, there's something pretty fishy here. Given that this is a parallel test, you may be looking at a low-probability timing-dependent failure. I'd say set up the machine and run repeat tests for an hour or three ... that's what I plan to do here. BTW, what postmaster parameters are you using --- -B and so forth? regards, tom lane