Re: [GENERAL] ERROR: unexpected hash relation size:
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, -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate. signature.asc Description: Digital signature
Re: [GENERAL] ERROR: unexpected hash relation size:
Gerhard Hintermayer <[EMAIL PROTECTED]> 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. http://developer.postgresql.org/pgdocs/postgres/release-8-1-9.html regards, tom lane ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] ERROR: unexpected hash relation size:
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
Re: [GENERAL] ERROR: unexpected hash relation size:
Tom Lane wrote: Gerhard Hintermayer <[EMAIL PROTECTED]> 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. http://developer.postgresql.org/pgdocs/postgres/release-8-1-9.html regards, tom lane ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match Thanks, will do that ASAP. But strange, that this problem is encoutered after 2 month running 8.1.8 flawless (without any changes to indices and database scheme) Regards Gerhard ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
Re: [GENERAL] ERROR: unexpected hash relation size:
Tom Lane wrote: Gerhard Hintermayer <[EMAIL PROTECTED]> 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 ---(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
Re: [GENERAL] ERROR: unexpected hash relation size:
Gerhard Hintermayer wrote: Tom Lane wrote: Gerhard Hintermayer <[EMAIL PROTECTED]> 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 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings