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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #10329: Could not read block 0 in file "base/56100265/57047884": read only 0 of 8192 bytes
Дата
Msg-id 26235.1400166587@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #10329: Could not read block 0 in file "base/56100265/57047884": read only 0 of 8192 bytes  (olivier.macchioni@wingo.ch)
Ответы Re: BUG #10329: Could not read block 0 in file "base/56100265/57047884": read only 0 of 8192 bytes
Список pgsql-bugs
olivier.macchioni@wingo.ch writes:
> When doing the following query on the standby server:

> select * from ir_translation where src = 'a';

> We have the following error in the logfiles:

> ERROR:  could not read block 0 in file "base/56100265/57047884": read only 0
> of 8192 bytes

> When checking the file usage, the following is reported:

> postgres@db-stdby:~/9.1/main/base/56100265$
> /usr/lib/postgresql/9.1/bin/oid2name -d xx -f 57047884
>> From database "xx":
>   Filenode                   Table Name
> ---------------------------------------
>   57047884  ir_translation_src_hash_idx

"hash_idx"?  Is this a hash index?  Those aren't supported for replication
purposes (no WAL code :-().

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: olivier.macchioni@wingo.ch
Дата:
Сообщение: BUG #10329: Could not read block 0 in file "base/56100265/57047884": read only 0 of 8192 bytes
Следующее
От: Olivier Macchioni
Дата:
Сообщение: Re: BUG #10329: Could not read block 0 in file "base/56100265/57047884": read only 0 of 8192 bytes