[BUGS] BUG #14481: “could not read block 7 in file "base/16393/12769": read only 0 of 8192 bytes”

Поиск
Список
Период
Сортировка
От digoal@126.com
Тема [BUGS] BUG #14481: “could not read block 7 in file "base/16393/12769": read only 0 of 8192 bytes”
Дата
Msg-id 20161230021215.10141.46915@wrigleys.postgresql.org
обсуждение исходный текст
Ответы [BUGS] Re: [BUGS] BUG #14481: “could not read block 7 in file "base/16393/12769": read only 0 of 8192 bytes”  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14481
Logged by:          Zhou Digoal
Email address:      digoal@126.com
PostgreSQL version: 9.4.8
Operating system:   CentOS 6.x x64
Description:

when our database upgrade from 9.4.2 to 9.4.8.
there some error when create table .

“could not read block 7 in file "base/16393/12769": read only 0 of 8192
bytes”

# select relname,relkind from pg_class where pg_relation_filepath(oid) ~
'16393/12769';
  relname   | relkind 
------------+---------
 pg_attrdef | r
(1 row)

after vacuum pg_attrdef 

it's no error now.

but i don't known why?  

this database is protect by these parameter :  
datachecksum=on
fsync=on
full page write=on
sync commit =on

best regards
digoal



--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

Предыдущее
От: Keith Fiske
Дата:
Сообщение: Re: [BUGS] 9.6rc1 Background worker starting multiple times
Следующее
От: Michael Paquier
Дата:
Сообщение: [BUGS] Re: [BUGS] BUG #14481: “could not read block 7 in file "base/16393/12769": read only 0 of 8192 bytes”