BUG #10095: primary key corruption
От
lukecoldiron@hotmail.com
Тема
BUG #10095: primary key corruption
Дата
Msg-id
20140421200838.2714.47552@wrigleys.postgresql.org
Список
Дерево обсуждения
BUG #10095: primary key corruption lukecoldiron@hotmail.com
Re: BUG #10095: primary key corruption Matheus de Oliveira <matioli.matheus@gmail.com>
Re: BUG #10095: primary key corruption Luke Coldiron <lukecoldiron@hotmail.com>
The following bug has been logged on the website: Bug reference: 10095 Logged by: Luke Coldiron Email address: lukecoldiron@hotmail.com PostgreSQL version: 9.3.3 Operating system: Ubuntu Linux 12.04 "Precise Pangolin" 32bit Description: I am seeing a problem where different primary keys in my database are being corrupted. ERROR: could not read block 0 in file "base/16407/41243": read only 0 of 8192 bytes When I look on the filesystem the "base/16407/41243" file is zero bytes. When I lookup the object name that is currupt via select relname from pg_class where relfilenode = 41243; it is always a primary key and not always on the same table. The system was previously upgraded from pg 8.3.7 and these issues did not occur. I haven't tried upgrading to 9.3.4 since it didn't look like any of the bug fixes where targeted at the issue I am seeing. Unfortunately, I have not yet be able to create a reproducible test case or find a log where the issue first appeared. Any ideas would be much appreciated.
В списке pgsql-bugs по дате отправления
От: Christoph Berg
Дата: