From: | Gerhard Hintermayer <g(dot)hintermayer(at)inode(dot)at> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | ERROR: unexpected hash relation size: |
Date: | 2007-07-02 09:46:54 |
Message-ID: | f6aha5$v86$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
... 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)
The affected table has only one index based upon an integer.
The table definition is:
p_code character varying(10)
a_nr integer
ch_nr integer
and some other columns
the Index is a hash base upon a_nr. The table stores protocols for
batches with batch number ch_nr and order number a_nr and product
identifier code p_code. None of these columns are primary keys.
On the backup_server I got eg. errors while inserting
INSERT INTO d_kochmi (p_code,a_nr,ch_nr ....)
VALUES('613CL8D110',56117,1 ...)
batch number (column 3) varied from 1 to 9.
Should I do some more inverstigation ?
On one server i dropped and recreated the index
(CREATE INDEX idx_d_kochmi ON d_kochmi (a_nr) ) and the error while
running VACCUM was gone.
I'm wondering if the use of the hash index is disabled when such an
error occurs or if the index is used with probably wrong data ?
Regards
Gerhard
From | Date | Subject | |
---|---|---|---|
Next Message | Dimitri Fontaine | 2007-07-02 09:48:17 | Re: table disk space usage query? |
Previous Message | Simon Riggs | 2007-07-02 09:27:37 | Re: recovery_target_time ignored or recovery alwaysrecovers to end of WAL |