Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id E21269FB625; Wed, 23 May 2007 06:23:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 66852-04; Wed, 23 May 2007 06:23:50 -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 5C70E9FAA6E; Wed, 23 May 2007 06:23:54 -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 5899E75133; Wed, 23 May 2007 10:20:39 +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 2665627411B; Wed, 23 May 2007 10:20:39 +0100 (BST) Message-ID: <46540766.2030108@archonet.com> Date: Wed, 23 May 2007 10:20:38 +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> In-Reply-To: <3650d0d50705230134n15b993aat8bbc631836eef65e@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/236 X-Sequence-Number: 25556 Purusothaman A wrote: > Thanks Richard Huxton for your reply. > > I use client side api for uploading and downloading files. > > Its not happening immediately. But when database grows with data, file > object got corrupted. Yes, but *HOW* - is it a different file, length is different, what? > My table structure is as follows. > Table "public.conf" > Column | Type | Modifiers > --------+------------------------+----------- > key | character varying(50) | not null > value | character varying(100) | > Indexes: > "conf_pkey" PRIMARY KEY, btree ("key") > > Content of this table is, > key | value > ---------------------+-------- > HX | 101800 > MASK | 101801 > Rockey4ND | 101802 > Threshold | 60 > Authentication Mode | 2 > (5 rows) > > In the above, value of HX, MASK, Rockey4ND is 101800, 101801, 101802 (which > was returned by lo_import()); I find it unlikely that "2" and "60" were returned by lo_import() as OIDs available for large-objects. You've either got: 1. Some other part of your application(s) overwriting "value" 2. Old data still in "value" 3. On-disk corruption due to crashes/hardware malfunction. 4. You're not showing real values > Actually for some peculiar reason I kept "Value" field as var char instead > of oid. (this could be reason?...) Hmm - well it's clearly not right, but I don't see how it can cause errors like this. > This problem occurs only few weeks after uploading files. You still haven't said precisely what the problem is. -- Richard Huxton Archonet Ltd