Re: BUG #13324: Database returing incorrect results on querying slect clause

Attached is the output.

There were jobs loading data into the db and due to disk space they got abended. The disk space was increased afyer that and since than we started facing this issue.

This clearly shows the DB got corrupted due to that, but now how do we fix this table? And how do we identify that all the other tables are fine.

From: Venkata Balaji N [mailto:nag1010(at)gmail(dot)com]
Sent: Thursday, May 21, 2015 8:02 PM
To: Sharma, Krishna Kumar
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] BUG #13324: Database returing incorrect results on querying slect clause

On Thu, May 21, 2015 at 12:23 PM, <ksharma6(at)metlife(dot)com<mailto:ksharma6(at)metlife(dot)com>> wrote:
The following bug has been logged on the website:

Bug reference: 13324
Logged by: Krishna Sharma
Email address: ksharma6(at)metlife(dot)com<mailto:ksharma6(at)metlife(dot)com>
PostgreSQL version: Unsupported/Unknown
Operating system: Windows 2003
Description:

Hi PostgreSQL team, we are suing PostGreSQL 8.2.

When I run a query in database like
select * from dn_case where id= 1234.

it returns 2 rows with different ids.

How is this happening?

it seems the database is corrupt. Please suggest a soluton for this issue.

It seems to be. Cannot be confirmed without much details. Can you please share the output ? is this reproducible ?
Also, can you let us know some details on what exactly was happening in the database.
Regards,
Venkata B N
Fujitsu Australia

The information contained in this message may be CONFIDENTIAL and is for the intended addressee only. Any unauthorized use, dissemination of the information, or copying of this message is prohibited. If you are not the intended addressee, please notify the sender immediately and delete this message.