Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id ABB429FBD4F; Thu, 24 May 2007 05:21:00 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 01295-03; Thu, 24 May 2007 05:20:54 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75]) by postgresql.org (Postfix) with ESMTP id D13D39FBD1F; Thu, 24 May 2007 05:20:56 -0300 (ADT) Received: from server3.office.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id 8156573E33; Thu, 24 May 2007 09:20:55 +0100 (BST) Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id 56357274116; Thu, 24 May 2007 09:20:55 +0100 (BST) Message-ID: <46554AE7.2060600@archonet.com> Date: Thu, 24 May 2007 09:20:55 +0100 From: Richard Huxton User-Agent: Thunderbird 2.0.0.0 (X11/20070326) MIME-Version: 1.0 To: Purusothaman A Cc: pgsql-general@postgresql.org, pgsql-admin@postgresql.org Subject: Re: [GENERAL] OIDs - file objects, are damaged by PostgreSQL. References: <3650d0d50705152242y689c0ef8u56223ec15661c821@mail.gmail.com> <464AD62B.9000003@archonet.com> <3650d0d50705230134n15b993aat8bbc631836eef65e@mail.gmail.com> <46540766.2030108@archonet.com> <3650d0d50705230756g5fdf8bdava3de463eb6f82ad9@mail.gmail.com> <4654621C.8010700@archonet.com> <3650d0d50705232254w265b94b0yaaf5163b92567403@mail.gmail.com> <465533B3.5060704@archonet.com> <3650d0d50705240035h795f935do6312ebe0866577fb@mail.gmail.com> In-Reply-To: <3650d0d50705240035h795f935do6312ebe0866577fb@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/260 X-Sequence-Number: 25580 Purusothaman A wrote: > Richard Huxton, > > In my system also its 2048 bytes chunk. > > The below output shows clearly that the last chunk differs in its length. > > You might have noticed in my previous mail that the string > "\015\012\015\012" is > missing some characters in SFRS2, SFRS1 and FASP_AVT database outputs. > Have a look at it, In this mail I have bolded the corrucpted part. Yep, spotted that. Hence asking for the length, and it looks like... > loid | pageno | length > --------+--------+-------- > 101177 | 630 | 181 > 41642 | 630 | 193 > 101800 | 630 | 193 > 24038 | 630 | 205 The data has just been truncated rather than corrupted. > Is it bug in Posstgresql or is they any way to solve this problem. Well, something is setting the length too short on these entries. Can you tell me whether the following statements are all correct? 1. Each database is on a separate machine (that would rule out a hardware problem) 2. All systems are running on Windows 2000/XP/2003. 3. All systems are version 8.2.4 (if not, please give details) 4. You upload the data with lo_import (once) and download it with lo_export (many times) and don't alter it in-between. 5. Where the data has been truncated, you know for a fact you downloaded it OK before (or do you just suspect it was OK?) If you're not changing the data, and you know it was OK at some point then there are only two things I can think of: 1. A hardware problem (which we might rule out above) 2. A bug in PostgreSQL's vacuum code Nothing else should be writing to those blocks. If it looks like a bug in vacuum, we can try to reproduce it, and also examine the actual contents of the on-disk files (to see if the data is there on the disk or not). I'll also copy this message over to the hackers list and see what the developers have to say. -- Richard Huxton Archonet Ltd