X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D162BD1D27C for ; Tue, 27 Jan 2004 01:12:19 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 16492-01 for ; Mon, 26 Jan 2004 21:11:50 -0400 (AST) Received: from sj-iport-5.cisco.com (sj-iport-5.cisco.com [171.68.10.87]) by svr1.postgresql.org (Postfix) with ESMTP id 6E66ED1E16B for ; Mon, 26 Jan 2004 21:11:46 -0400 (AST) Received: from sj-core-4.cisco.com (171.68.223.138) by sj-iport-5.cisco.com with ESMTP; 26 Jan 2004 17:13:59 -0800 Received: from cjwhitew2k02 (dhcp-128-107-151-36.cisco.com [128.107.151.36]) by sj-core-4.cisco.com (8.12.6/8.12.6) with ESMTP id i0R1Bj5k021711 for ; Mon, 26 Jan 2004 17:11:46 -0800 (PST) Reply-To: From: "Chris White (cjwhite)" To: Subject: Error seen when vacuuming pg_largeobject table Date: Mon, 26 Jan 2004 17:11:45 -0800 Message-ID: <002001c3e472$88698fd0$24976b80@amer.cisco.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0021_01C3E42F.7A464FD0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.4024 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4927.1200 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.5 tagged_above=0.0 required=5.0 tests=HTML_20_30 X-Spam-Level: * X-Archive-Number: 200401/246 X-Sequence-Number: 12109 This is a multi-part message in MIME format. ------=_NextPart_000_0021_01C3E42F.7A464FD0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit Following a power fail restart, when I vacuum the pg_largeobject table I see the following error messages: VACUUM: DEBUG sql sql sql DEBUG: --Relation pg_largeobject-- blocks 450 VACUUM: DEBUG sql sql sql DEBUG: Pages 450: Changed 78, reaped 277, Empty 0, New 37; Tup 1390: Vac 232, Keep/VTL 0/0, UnUsed 220, MinLen 98, MaxLen 2092; Re-using: Free/Avail. Space 1464136/1463348; EndEmpty/Avail. Pages 0/445. VACUUM: CPU 0.05s/0.01u sec elapsed 0.56 sec. VACUUM: DEBUG sql sql sql DEBUG: Index pg_largeobject_loid_pn_index: Pages 14; Tuples 1044: Deleted 232. VACUUM: CPU 0.00s/0.00u sec elapsed 0.00 sec. VACUUM: INFO sql sql sql NOTICE: Index pg_largeobject_loid_pn_index: NUMBER OF INDEX' TUPLES (1044) IS NOT THE SAME AS HEAP' (1390). VACUUM: Recreate the index. VACUUM: WARNING sql sql sql ERROR: Cannot insert a duplicate key into unique index pg_largeobject_loid_pn_index When I run postgres with the -P and -O options to reindex the index, everything seem to run okay, I see no error messages. However, when I restart postmaster and try and do a vacuum again, I get the same error messages. What can I do to correct the problem? Thanks Chris White ------=_NextPart_000_0021_01C3E42F.7A464FD0 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Message
Following= a power=20 fail restart, when I vacuum the pg_largeobject table I see the following er= ror=20 messages:
 

VACUUM: DEBUG sql sql sql DEBUG: --Relation= =20 pg_largeobject-- blocks 450

VACUUM: DEBUG sql sql sql DEBUG: Pages 450: = Changed=20 78, reaped 277, Empty 0, New 37; Tup 1390: Vac 232, Keep/VTL 0/0, UnUsed 22= 0,=20 MinLen 98, MaxLen 2092; Re-using: Free/Avail. Space 1464136/1463348;=20 EndEmpty/Avail. Pages 0/445.

VACUUM: CPU 0.05s/0.01u sec elapsed 0.56=20 sec.

VACUUM: DEBUG sql sql sql DEBUG: Index=20 pg_largeobject_loid_pn_index: Pages 14; Tuples 1044: Deleted 232.

VACUUM: CPU 0.00s/0.00u sec elapsed 0.00=20 sec. VACUUM: INFO sql sql sql NOTICE: Index pg_largeobject_loid_pn_ind= ex:=20 NUMBER OF INDEX' TUPLES (1044) IS NOT THE SAME AS HEAP' (1390).

VACUUM: Recreate the index.

VACUUM: WARNING sql sql sql ERROR: Cannot in= sert a=20 duplicate key into unique index pg_largeobject_loid_pn_index

When I run = postgres=20 with the -P and -O options to reindex the index, everything seem to run oka= y, I=20 see no error messages. However, when I restart postmaster and try and do a= =20 vacuum again, I get the same error messages.

What can I = do to=20 correct the problem?

Thanks

Chris=20 White

------=_NextPart_000_0021_01C3E42F.7A464FD0--