pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (10+ messages)

Message-ID: <46554AE7.2060600@archonet.com>
Permalink:  ../46554AE7.2060600@archonet.com/
Also on:    postgresql.org/message-id/46554AE7.2060600@archonet.com

 · 

reply

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