Re: BUG #10329: Could not read block 0 in file "base/56100265/57047884": read only 0 of 8192 bytes

From: Olivier Macchioni <olivier(dot)macchioni(at)wingo(dot)ch>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #10329: Could not read block 0 in file "base/56100265/57047884": read only 0 of 8192 bytes
Date: 2014-05-15 15:20:35
Message-ID: 4EE3A338-8C14-4E1B-9F2B-479354765138@wingo.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> [...]
> "hash_idx"? Is this a hash index? Those aren't supported for replication
> purposes (no WAL code :-().
>
> regards, tom lane

Bingo:

xx=# \d ir_translation_src_hash_idx
Index "public.ir_translation_src_hash_idx"
Column | Type | Definition
--------+---------+------------
src | integer | src
hash, for table "public.ir_translation"

(for the record, this is created by the stock version of OpenERP v6)

And it's the only hash index out of 1741 other indexes on my system...

I guess my best bet is to replace it by another kind of indexes... and maybe one day PostgreSQL will be clever enough to issue a warning / error in such a case for the people like me who don't read *all the doc* :P

Thanks a lot and sorry for the noise :)

Olivier

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message erica.stine 2014-05-15 15:46:20 BUG #10330: pg_ctl does not correctly honor "DETACHED_PROCESS"
Previous Message Tom Lane 2014-05-15 15:09:47 Re: BUG #10329: Could not read block 0 in file "base/56100265/57047884": read only 0 of 8192 bytes