Date: Tue, 25 Feb 2025 12:02:43 +0000 (UTC)
From: "sivapostgres@yahoo.com" <sivapostgres@yahoo.com>
Reply-To: "sivapostgres@yahoo.com" <sivapostgres@yahoo.com>
To: Pgsql-general <pgsql-general@postgresql.org>
Message-ID: <611536258.144285.1740484963829@mail.yahoo.com>
Subject: Re: Corruption of few tables
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_144284_690794744.1740484963828"
References: <611536258.144285.1740484963829.ref@mail.yahoo.com>
Content-Length: 4040
Archived-At: <https://www.postgresql.org/message-id/611536258.144285.1740484963829%40mail.yahoo.com>
Precedence: bulk

------=_Part_144284_690794744.1740484963828
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hello,
Using PostgreSQL 11.11, compiled by Visual C++ build 1914, 64-bit=C2=A0 wit=
h Powerbuilder=C2=A0

Recently, in one of our customers' places, we got an error while saving a r=
ecord from our custom-built application using PowerBuilder.=C2=A0 =C2=A0 =
=C2=A0While saving a record, we compare a value from a table with a hard-co=
ded value in application.=C2=A0 Here the select command failed to fetch tha=
t particular record from the table and so the save failed.
When we tried to read data from randomly selected tables [ from PGAdmin], w=
e found that records could not be read from a set of consecutive tables. We=
 re-started server [ Windows Server 2012 ] and tried again to read those ta=
bles.=C2=A0 This time the failure was with only one table and select was su=
ccess in all other tables.=C2=A0=C2=A0
So we dropped that particular table [ around 33000 records ], after removin=
g all foreign key links and re-created that table and inserted all records =
from a backup set.
The problem got solved.=C2=A0 Since this is not the first time, we are gett=
ing this error, I want to know

1.=C2=A0 Why is corruption happening?=C2=A0 How to find out the reason?
2.=C2=A0 What should I do to prevent this from happening again?
Any steps or suggestions to avoid such corruptions is really appreciated.
Happiness Always
BKR Sivaprakash

------=_Part_144284_690794744.1740484963828
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html><head></head><body><div class=3D"yahoo-style-wrap" style=3D"font-fami=
ly:times new roman, new york, times, serif;font-size:16px;"><div dir=3D"ltr=
" data-setdir=3D"false">Hello,</div><div dir=3D"ltr" data-setdir=3D"false">=
<br></div><div dir=3D"ltr" data-setdir=3D"false"><span><span>Using PostgreS=
QL 11.11, compiled by Visual C++ build 1914, 64-bit&nbsp; with Powerbuilder=
&nbsp;</span><br></span></div><div dir=3D"ltr" data-setdir=3D"false"><span>=
<span><br></span></span></div><div dir=3D"ltr" data-setdir=3D"false">Recent=
ly, in one of our customers' places, we got an error while saving a record =
from our custom-built application using PowerBuilder.&nbsp; &nbsp; &nbsp;Wh=
ile saving a record, we compare a value from a table with a hard-coded valu=
e in application.&nbsp; Here the select command failed to fetch that partic=
ular record from the table and so the save failed.</div><div dir=3D"ltr" da=
ta-setdir=3D"false"><br></div><div dir=3D"ltr" data-setdir=3D"false">When w=
e tried to read data from randomly selected tables [ from PGAdmin], we foun=
d that records could not be read from a set of consecutive tables. We re-st=
arted server [ Windows Server 2012 ] and tried again to read those tables.&=
nbsp; This time the failure was with only one table and select was success =
in all other tables.&nbsp;&nbsp;</div><div dir=3D"ltr" data-setdir=3D"false=
"><br></div><div dir=3D"ltr" data-setdir=3D"false">So we dropped that parti=
cular table [ around 33000 records ], after removing all foreign key links =
and re-created that table and inserted all records from a backup set.</div>=
<div dir=3D"ltr" data-setdir=3D"false"><br></div><div dir=3D"ltr" data-setd=
ir=3D"false">The problem got solved.&nbsp; Since this is not the first time=
, we are getting this error, I want to know<br><br></div><div dir=3D"ltr" d=
ata-setdir=3D"false">1.&nbsp; Why is corruption happening?&nbsp; How to fin=
d out the reason?<br>2.&nbsp; What should I do to prevent this from happeni=
ng again?</div><div dir=3D"ltr" data-setdir=3D"false"><br></div><div dir=3D=
"ltr" data-setdir=3D"false">Any steps or suggestions to avoid such corrupti=
ons is really appreciated.</div><div dir=3D"ltr" data-setdir=3D"false"><br>=
</div><div dir=3D"ltr" data-setdir=3D"false">Happiness Always<br>BKR Sivapr=
akash</div><div dir=3D"ltr" data-setdir=3D"false"><br></div></div></body></=
html>
------=_Part_144284_690794744.1740484963828--