Andrew Dunstan <[EMAIL PROTECTED]> writes: > pgbfprod=# select sysname, stage, snapshot from build_status where log ~ > $$read only \d+ of \d+ bytes$$; > sysname | stage | snapshot > -----------+--------------+--------------------- > zebra | InstallCheck | 2007-09-11 10:25:03 > wildebeest | InstallCheck | 2007-09-11 22:00:11 > baiji | InstallCheck | 2007-09-12 22:39:24 > luna_moth | InstallCheck | 2007-09-19 13:10:01 > (4 rows)
Fascinating. So I would venture that (1) it's definitely our bug, not something we could blame on NFS or whatever, and (2) we introduced it fairly recently. That specific error message wording exists only in HEAD, but it's been there since 2007-01-03, so if there were a pre-existing problem you'd think there would be some more matches. The patterns I notice here are (1) they're all InstallCheck not Check failures; (2) though not all at the same place in the tests, it's a fairly short range; (3) it's all references to system catalogs, though not all the same one. My gut feeling is that we're seeing autovacuum truncate off an empty end block and then a backend tries to reference that block again. But there should be enough interlocks in place to prevent such references. Any ideas out there? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly