BUG #5420: pg_attribute broken

From: "cool" <coolshower2008(at)yahoo(dot)co(dot)jp>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5420: pg_attribute broken
Date: 2010-04-14 08:25:25
Message-ID: 201004140825.o3E8PPlO030071@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5420
Logged by: cool
Email address: coolshower2008(at)yahoo(dot)co(dot)jp
PostgreSQL version: 8.1.8
Operating system: debian 2.6.18-6-686
Description: pg_attribute broken
Details:

We use PostgreSQL Databse on Hospital Information System in Japan.
In case of normal condition(Not busy, Not Backup, Not Start up and Not
Shutdown),
Suddenly, PostgreSQL outputs error message and "pg_attribute" catalog file
is broken as bellow.
Could you sent it to us A.S.A.P.
<Environment>
debian debian 2.6.18-6-686 / PostgreSQL 8.1.8
<Error message>
invalid attribute number 0 for tbl_syuday
<pg_attribute>
attrelid addname atttypid attstattarget attlen
attnum
45762 tableoid 26 0 4
-7
45762 cmax 29 0 4
-6
45762 xmax 28 0 4
-5
45762 cmin 29 0 4
-4
45762 xmin 28 0 4
-3
45762 ctid 27 0 6
-1
45762 santeiflg18_4 0 0 0
0 (?)
45762 nyugaikbn 1042 -1 -1
1
45762 ptid 1700 -1 -1
2
.
.(Omission)
.
45762 santeiflg17_1 1700 -1 -1
343
45762 ftmoney17_1 1700 -1 -1
344
45762 ftmoney18_4 1700 -1 -1
380 (345..379 are deleted?)
45762 comptfn18_4 1700 -1 -1
381
.
.(Omission)
.
Q1:Does anything have same reports ?
Q2:Does anything have repair patches ?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message cool shower 2010-04-14 11:02:49 BUG #5421: pg_attribute broken
Previous Message Pavel Stehule 2010-04-14 06:36:25 Re: BUG #5419: Default parameters in PLPGSQL functions skipping every other value in pgAdmin view