pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedinvalid page header in block 29 of relation "pg_type"
5+ messages / 2 participants
[nested] [flat]
* invalid page header in block 29 of relation "pg_type"
@ 2008-06-02 12:55 Filip Krška <filip.krska@comstar.cz>
2008-06-06 21:19 ` Re: invalid page header in block 29 of relation "pg_type" Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 1 reply; 5+ messages in thread
From: Filip Krška @ 2008-06-02 12:55 UTC (permalink / raw)
To: pgsql-admin
Hello,
we have (maybe due to temporary Disk Array HW failure, which occurred on
the same day the pg_dump started to complain - array is now successfully
rebuilt) problem with consistency of pg_catalog.pg_type table.
pg_dumpall command gives following message:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: invalid page header in block
29
of relation "pg_type"
pg_dump: The command was: SELECT tableoid, oid, typname, typnamespace,
(SELECT rolname FROM pg_catalog.pg_roles WHERE oid = typowner) as rolname,
typinput::oid as typinput, typoutput::oid as typoutput, typelem, typrelid,
CASE WHEN typrelid = 0 THEN ' '::"char" ELSE (SELECT relkind FROM pg_class
WHERE oid = typrelid) END as typrelkind, typtype, typisdefined FROM
pg_type
pg_dumpall: pg_dump failed on database "isdb", exiting
and exits, so we are not able to make fresh backup and recover the
database.
The same error (ERROR: invalid page header in block 29 of relation
"pg_type") give commands VACUUM, REINDEX on the table pg_catalog.pg_type.
I'm afraid of performing any tests, restarting the service, because
it is running production database and due to the inability of backing it
up we have only week old dump.
The service acts as there was no problem (INSERT, SELECT, DROP, CREATE,
ALTER TABLE works normally), only the dump and vacuum complains.
There was one damaged file (fortunetely belonging to an empty regular
table) in the $PGDATA/base/ directory, which caused I/O error, while
reading. After drop and create of the table, the partition with $PGDATA
seems error-free.
We run PostgreSQL 8.1.5 on CentOS release 3.8, 2.4.21-47.EL kernel,
x86_64 architecture.
Thanks for any advice
Best regards,
Filip Krska
--
ComSTAR spol. s r. o.
Třebohostická 14
100 31 Praha 10
HotLine (pev.): 261 305 432
HotLine (mob.): 777 343 857
From pgsql-admin-owner@postgresql.org Mon Jun 2 10:41:27 2008
Received: from localhost (unknown [200.46.204.183])
by developer.postgresql.org (Postfix) with ESMTP id 2C60B2E0124
for <pgsql-admin-postgresql.org@developer.postgresql.org>; Mon, 2 Jun 2008 10:41:27 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
with ESMTP id 53359-03-6
for <pgsql-admin-postgresql.org@developer.postgresql.org>;
Mon, 2 Jun 2008 10:41:13 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
by developer.postgresql.org (Postfix) with ESMTP id 300182E0085
for <pgsql-admin@postgresql.org>; Mon, 2 Jun 2008 10:40:01 -0300 (ADT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m52DdbTo017315;
Mon, 2 Jun 2008 09:39:37 -0400 (EDT)
To: Alexander Stanier <alexander.stanier@egsgroup.com>
cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: Vacuuming and template0
In-reply-to: <4843E458.1090200@egsgroup.com>
References: <4843E458.1090200@egsgroup.com>
Comments: In-reply-to Alexander Stanier <alexander.stanier@egsgroup.com>
message dated "Mon, 02 Jun 2008 13:15:20 +0100"
Date: Mon, 02 Jun 2008 09:39:37 -0400
Message-ID: <17314.1212413977@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200806/6
X-Sequence-Number: 29344
Alexander Stanier <alexander.stanier@egsgroup.com> writes:
> Should we attempt to vacuum template0? I read a note somewhere saying
> that you can't vacuum template0 and don't need to. Is this correct?
No; yes. template0 was frozen when it was made.
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: invalid page header in block 29 of relation "pg_type"
2008-06-02 12:55 invalid page header in block 29 of relation "pg_type" Filip Krška <filip.krska@comstar.cz>
@ 2008-06-06 21:19 ` Alvaro Herrera <alvherre@commandprompt.com>
2008-06-09 08:09 ` Re: invalid page header in block 29 of relation "pg_type" Filip Krška <filip.krska@comstar.cz>
0 siblings, 1 reply; 5+ messages in thread
From: Alvaro Herrera @ 2008-06-06 21:19 UTC (permalink / raw)
To: Filip Krška <filip.krska@comstar.cz>; +Cc: pgsql-admin
Filip Krška wrote:
> Hello,
>
> we have (maybe due to temporary Disk Array HW failure, which occurred on
> the same day the pg_dump started to complain - array is now successfully
> rebuilt) problem with consistency of pg_catalog.pg_type table.
Did you solve this problem?
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: invalid page header in block 29 of relation "pg_type"
2008-06-02 12:55 invalid page header in block 29 of relation "pg_type" Filip Krška <filip.krska@comstar.cz>
2008-06-06 21:19 ` Re: invalid page header in block 29 of relation "pg_type" Alvaro Herrera <alvherre@commandprompt.com>
@ 2008-06-09 08:09 ` Filip Krška <filip.krska@comstar.cz>
2008-06-09 18:21 ` Re: invalid page header in block 29 of relation "pg_type" Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 1 reply; 5+ messages in thread
From: Filip Krška @ 2008-06-09 08:09 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@commandprompt.com>; +Cc: pgsql-admin
I hope, I've solved it.
I found 512 damaged bytes on the 29th 8k page of the pg_type's datafile
($PGDATA/base/16390/1247), it was overwritten by text from some log(?!).
When I had dropped the whole 8k page (dd of=/tmp/head count=29 bs=8192,
dd of=/tmp/tail skip=30 bs=8192, then cat /tmp/head /tmp/tail), the
pg_dumpall utility was able to dump the DB instance then.
I compared schemas (pg_dumpall -s), fortunately only several empty, not
used tables were affected.
Then I imported the dump, and now the DB instance seems to work properly,
also the pg_dumps, vacuum anylysis.
Best regards,
Filip Krska
--
ComSTAR spol. s r. o.
Třebohostická 14
100 31 Praha 10
HotLine (pev.): 274 016 000
HotLine (mob.): 777 343 857
On Fri, 6 Jun 2008, Alvaro Herrera wrote:
> Filip Krška wrote:
>> Hello,
>>
>> we have (maybe due to temporary Disk Array HW failure, which occurred on
>> the same day the pg_dump started to complain - array is now successfully
>> rebuilt) problem with consistency of pg_catalog.pg_type table.
>
> Did you solve this problem?
>
> --
> Alvaro Herrera http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
From pgsql-admin-owner@postgresql.org Mon Jun 9 08:19:56 2008
Received: from localhost (unknown [200.46.204.183])
by developer.postgresql.org (Postfix) with ESMTP id 68C032E0035
for <pgsql-admin-postgresql.org@developer.postgresql.org>; Mon, 9 Jun 2008 08:19:54 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
with ESMTP id 62170-01
for <pgsql-admin-postgresql.org@developer.postgresql.org>;
Mon, 9 Jun 2008 08:19:46 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from swip.net (mailfe13.tele2.it [212.247.155.141])
by developer.postgresql.org (Postfix) with ESMTP id 26EEA2E0032
for <pgsql-admin@postgresql.org>; Mon, 9 Jun 2008 08:19:49 -0300 (ADT)
X-Cloudmark-Score: 0.000000 []
X-Cloudmark-Analysis: v=1.0 c=1 a=Y4xYv2_f_KlqPSz4q0MA:9 a=o9DRAFmFE2JGraQ64hMA:7 a=_AXKxNSVHTDbA4C6wee0gfDQ5nYA:4 a=50e4U0PicR4A:10
Received: from [88.149.236.151] (account cxu-8rf-htj@tele2.it HELO [192.168.1.103])
by mailfe13.swip.net (CommuniGate Pro SMTP 5.1.13)
with ESMTPA id 579254902 for pgsql-admin@postgresql.org; Mon, 09 Jun 2008 13:19:46 +0200
Message-ID: <484D11CC.3050806@geologyx.it>
Date: Mon, 09 Jun 2008 13:19:40 +0200
From: Simone Gadenz <s.gadenz@geologyx.it>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Connecting from xp to linux server
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level:
X-Archive-Number: 200806/52
X-Sequence-Number: 29390
Hi all,
this is the problem I am facing.
I have PG 8.3 running on a KUBUNTU installation running on a virtual
machine. From inside the virtual machine I can use PGADMIN to manage PG
but when I try to connect from the xp machine I have this error: "Error
connecting to the server:FATAL: missing or erroneous pg_hba.conf file" .
I set the permission in the pg_hba.conf on the server.
The machine talk each oher, I can ping and use telnet on the 5432 port.
The log on the server does not report any problem.
Ideas?
--
Dr. Simone Gadenz
via P. Togliatti 69, 50051
Castelfiorentino (FI)
+39 339 6053660
*INFORMATIVA PRIVACY (ex D.lgs. 196/03)*
Le inormazioni contenute in questo documento e nei relativi allegato
possono essere riservate e sono destinate esclusivamente alla persona
od alla Societŕ indicata come destinatario.
La diffusione e la distribuzione del presente documento a soggetti
diversi da quelli indicati, od in genere qualsivoglia utilizzo illecito
dei dati ivi contenuti, e proibita sia ai sensi dell'art. 616 del
Codice Penale che dal D.Lgs 196/03 in materia di protezione dei dati
personali (Privacy).
Se avete ricevuto per errore questo documento siete pregati di
distruggerlo e di comunicarcelo prontamente tramite e-mail o fax.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: invalid page header in block 29 of relation "pg_type"
2008-06-02 12:55 invalid page header in block 29 of relation "pg_type" Filip Krška <filip.krska@comstar.cz>
2008-06-06 21:19 ` Re: invalid page header in block 29 of relation "pg_type" Alvaro Herrera <alvherre@commandprompt.com>
2008-06-09 08:09 ` Re: invalid page header in block 29 of relation "pg_type" Filip Krška <filip.krska@comstar.cz>
@ 2008-06-09 18:21 ` Alvaro Herrera <alvherre@commandprompt.com>
2008-06-10 08:49 ` Re: invalid page header in block 29 of relation "pg_type" Filip Krška <filip.krska@comstar.cz>
0 siblings, 1 reply; 5+ messages in thread
From: Alvaro Herrera @ 2008-06-09 18:21 UTC (permalink / raw)
To: Filip Krška <filip.krska@comstar.cz>; +Cc: pgsql-admin
Filip Krška wrote:
> I hope, I've solved it.
>
> I found 512 damaged bytes on the 29th 8k page of the pg_type's datafile
> ($PGDATA/base/16390/1247), it was overwritten by text from some log(?!).
Ugh. For the record, what operating system and filesystem are you
using? Oh, the underlying storage may be useful too.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: invalid page header in block 29 of relation "pg_type"
2008-06-02 12:55 invalid page header in block 29 of relation "pg_type" Filip Krška <filip.krska@comstar.cz>
2008-06-06 21:19 ` Re: invalid page header in block 29 of relation "pg_type" Alvaro Herrera <alvherre@commandprompt.com>
2008-06-09 08:09 ` Re: invalid page header in block 29 of relation "pg_type" Filip Krška <filip.krska@comstar.cz>
2008-06-09 18:21 ` Re: invalid page header in block 29 of relation "pg_type" Alvaro Herrera <alvherre@commandprompt.com>
@ 2008-06-10 08:49 ` Filip Krška <filip.krska@comstar.cz>
0 siblings, 0 replies; 5+ messages in thread
From: Filip Krška @ 2008-06-10 08:49 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@commandprompt.com>; +Cc: pgsql-admin
It was CentOS release 3.8 and ext2 (I switched it to ext3 after the
disaster).
HW is HP Array P400, with HP DG146ABAB4 Disks.
Status of one of the disk switched from OK to predictive failure, I guess
the array didn't recognize the failure and didn't park it in time.
Filip
======================================
On Mon, 9 Jun 2008, Alvaro Herrera
wrote:
> Filip Krška wrote:
>> I hope, I've solved it.
>>
>> I found 512 damaged bytes on the 29th 8k page of the pg_type's datafile
>> ($PGDATA/base/16390/1247), it was overwritten by text from some log(?!).
>
> Ugh. For the record, what operating system and filesystem are you
> using? Oh, the underlying storage may be useful too.
>
>
> --
> Alvaro Herrera http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
From pgsql-admin-owner@postgresql.org Tue Jun 10 08:20:49 2008
Received: from localhost (unknown [200.46.204.183])
by developer.postgresql.org (Postfix) with ESMTP id 023202E0060
for <pgsql-admin-postgresql.org@developer.postgresql.org>; Tue, 10 Jun 2008 08:20:49 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
with ESMTP id 14275-05
for <pgsql-admin-postgresql.org@developer.postgresql.org>;
Tue, 10 Jun 2008 08:20:41 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from swip.net (mailfe06.tele2.it [212.247.154.173])
by developer.postgresql.org (Postfix) with ESMTP id A94A82E0056
for <pgsql-admin@postgresql.org>; Tue, 10 Jun 2008 08:20:45 -0300 (ADT)
X-Cloudmark-Score: 0.000000 []
X-Cloudmark-Analysis: v=1.0 c=1 a=nd9pq3UZPq4A:10 a=zBtazHSgq_sA:10 a=Y4xYv2_f_KlqPSz4q0MA:9 a=W0Q0wkfP6-tQkYaMdnIA:7 a=lCc08YjtoD-ljeRBZldCOUfjOtsA:4 a=XF7b4UCPwd8A:10
Received: from [88.149.254.239] (account cxu-8rf-htj@tele2.it HELO [192.168.1.103])
by mailfe06.swip.net (CommuniGate Pro SMTP 5.2.4b)
with ESMTPA id 968916674; Tue, 10 Jun 2008 13:20:43 +0200
Message-ID: <484E6387.4040008@geologyx.it>
Date: Tue, 10 Jun 2008 13:20:39 +0200
From: Simone Gadenz <s.gadenz@geologyx.it>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
To: Shane Ambler <pgsql@Sheeky.Biz>
CC: pgsql-admin@postgresql.org
Subject: Re: Connecting from xp to linux server
References: <484D11CC.3050806@geologyx.it> <484D4097.4070807@Sheeky.Biz> <484D9D62.8050705@geologyx.it> <484DCE85.5080800@Sheeky.Biz>
In-Reply-To: <484DCE85.5080800@Sheeky.Biz>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level:
X-Archive-Number: 200806/68
X-Sequence-Number: 29406
Thanks everybody! In fact it was a syntax problem. Now it works fine.
Cheers
Simone
Shane Ambler ha scritto:
> Simone Gadenz wrote:
>> Shane,
>>
>> I attached the pg_hba.conf I have on the server. I can use pgadmin3
>> when I connect from the server itself, so I think the pg_hba on the
>> server is correct.
>>
>> From the client machine I cannot connect through pgadmin3. Is there
>> another way to test connection client server? Has pg a textual client
>> to send sql statements?
>>
>> Thanks a lot
>>
>> Simone
>>
>>
>
> # connections for all the pcs on the subnet
> #
> # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
> host all all 192.168.148.0 255.255.255.0
> host all all 192.168.159.0 255.255.255.0
>
>
> try adding the method to the end of these lines.
>
>
> # METHOD can be "trust", "reject", "md5", "crypt", "password", "gss",
> "sspi",
> # "krb5", "ident", "pam" or "ldap". Note that "password" sends passwords
> # in clear text; "md5" is preferred since it sends encrypted passwords.
>
>
--
Dr. Simone Gadenz
via P. Togliatti 69, 50051
Castelfiorentino (FI)
+39 339 6053660
*INFORMATIVA PRIVACY (ex D.lgs. 196/03)*
Le inormazioni contenute in questo documento e nei relativi allegato
possono essere riservate e sono destinate esclusivamente alla persona
od alla Società indicata come destinatario.
La diffusione e la distribuzione del presente documento a soggetti
diversi da quelli indicati, od in genere qualsivoglia utilizzo illecito
dei dati ivi contenuti, e proibita sia ai sensi dell'art. 616 del
Codice Penale che dal D.Lgs 196/03 in materia di protezione dei dati
personali (Privacy).
Se avete ricevuto per errore questo documento siete pregati di
distruggerlo e di comunicarcelo prontamente tramite e-mail o fax.
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2008-06-10 08:49 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-06-02 12:55 invalid page header in block 29 of relation "pg_type" Filip Krška <filip.krska@comstar.cz>
2008-06-06 21:19 ` Alvaro Herrera <alvherre@commandprompt.com>
2008-06-09 08:09 ` Filip Krška <filip.krska@comstar.cz>
2008-06-09 18:21 ` Alvaro Herrera <alvherre@commandprompt.com>
2008-06-10 08:49 ` Filip Krška <filip.krska@comstar.cz>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox