From: Richard Huxton <dev@archonet.com>
To: Purusothaman A <purusothaman.a@gmail.com>
Cc: pgsql-general@postgresql.org
Cc: pgsql-admin@postgresql.org
Subject: Re: [GENERAL] OIDs - file objects, are damaged by PostgreSQL.
Date: Thu, 24 May 2007 09:20:55 +0100
Message-ID: <46554AE7.2060600@archonet.com> (raw)
In-Reply-To: <3650d0d50705240035h795f935do6312ebe0866577fb@mail.gmail.com>
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>
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
> "</haarcascade_frontalface_default>\015\012</opencv_storage>\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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: dev@archonet.com, purusothaman.a@gmail.com, pgsql-general@postgresql.org
Subject: Re: [GENERAL] OIDs - file objects, are damaged by PostgreSQL.
In-Reply-To: <46554AE7.2060600@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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