Re: BUG #8381: data base inconsistancy

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: David Fetter <david(at)fetter(dot)org>
Cc: rohit(dot)guptakec(at)gmail(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8381: data base inconsistancy
Date: 2013-08-14 23:28:34
Message-ID: CAB7nPqR6oFuCXcWqpeuNfLkMj0uqsrNN0=ibNQSoZ0-eAacOCw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, Aug 14, 2013 at 11:00 PM, David Fetter <david(at)fetter(dot)org> wrote:
> On Sun, Aug 11, 2013 at 08:06:55AM +0000, rohit(dot)guptakec(at)gmail(dot)com wrote:
>> The following bug has been logged on the website:
>>
>> Bug reference: 8381
>> Logged by: Rohit Gupta
>> Email address: rohit(dot)guptakec(at)gmail(dot)com
>> PostgreSQL version: Unsupported/Unknown
>> Operating system: linux
>> Description:
>>
>> Background:- There were a large no. of INSERT/UPDATE/DELETE operation being
>> performed on DB. The DB is reindex/vacuum every hour.
>> During reindex/vacuum time one of the DB table value was successfully
>> updated. But later the read query after ~30 seconds read previous values. Is
>> this possible that the update query commit is delayed ? Are there are some
>> known issues of commit during reindex/vacuum.
>> Currently we are using DB version 8.1
>> Later when we check the DB status (after some days)it was having the correct
>> updated values.
>> We are using default isolation level (Read Committed)
>
> PostgreSQL 8.1 has been unsupported since 2010. Once you've upgraded
> to a supported version, if the problem persists, we may be able to
> help.
You didn't specify the minor version of 8.1 you are using as well.
You might as well try to update to the latest version of 8.1, which is
8.1.23, released before it became EOL. However in your case you should
definitely upgrade to a newer version...
--
Michael

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Cal Martin 2013-08-15 20:16:29
Previous Message barnhart.jon 2013-08-14 22:25:02 BUG #8384: Missing dll