Martijn van Oosterhout wrote:
On Mon, Jul 02, 2007 at 11:46:54AM +0200, Gerhard Hintermayer wrote:
... x should be y
I do get these messages one 2 of my servers running mostly on identical
data. The servers are unix-based and are running 8.1.8 under linux (Gentoo).
On one server the message appears only after vacuum-ing, on the other I
had some errors after inserting into the table too (about 12 inserts, no
more messages except while vacuuming since then)
Has the server crashed recently? Hash indexes are known not to be crash
safe. Using REINDEX on the index should fix it.
Have a nice day,
No, the server(s) did not crash.
Will do the update Tom Lane sugested ASAP (unfortunately server is
running 7*24 :-( )
Strange, that the error is encountered after more that 2 month running
flawless.
Thanks
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
