Search Postgresql Archives

Re: ERROR: unexpected hash relation size:

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Gerhard Hintermayer wrote:
Tom Lane wrote:
Gerhard Hintermayer <g.hintermayer@xxxxxxxx> writes:
... 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).

Update.

I thought the fixed error was related to running VACUUM FULL, so I disabled running it once a week to prevent currupting my indices. (btw I do not use autovacuum) But I still get occasional error log entries of this kind (one attempt to insert), is the fixed error in 8.1.9 also related to growing index size or is there any other bug burried somewhere. I'm planning to upgrade the upcoming weekend, so I could investigate some more.

regards
Gerhard
Ah, must have been the changes in backend/access/hash/hashovfl.c. Although i never got a PANIC, only an ERROR. I cross my fingers to keep de DB up and running without any data corruption (besides of indices) until the weekend. So a PANIC and backend crash would be possible ? Hopefully under rare circumstances ? Can somebody confirm this ?

regards
Gerhard


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux