Re: BUG #13324: Database returing incorrect results on querying slect clause
| От | Sharma, Krishna Kumar |
|---|---|
| Тема | Re: BUG #13324: Database returing incorrect results on querying slect clause |
| Дата | |
| Msg-id | b24f07b351c84144adb69c26037ab8ab@CY1PR94MB0106.063d.mgd.msft.net обсуждение исходный текст |
| Ответ на | Re: BUG #13324: Database returing incorrect results on querying slect clause (Venkata Balaji N <nag1010@gmail.com>) |
| Список | pgsql-bugs |
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@gmail.com]
Sent: Thursday, May 21, 2015 8:02 PM
To: Sharma, Krishna Kumar
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #13324: Database returing incorrect results on querying slect clause
On Thu, May 21, 2015 at 12:23 PM, <ksharma6@metlife.com> wrote:
The following bug has been logged on the website:
Bug reference: 13324
Logged by: Krishna Sharma
Email address: ksharma6@metlife.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
Вложения
В списке pgsql-bugs по дате отправления: