public inbox for [email protected]  

help / color / mirror / Atom feed

From: [email protected] <[email protected]>
To: Pgsql-general <[email protected]>
Subject: Re: Corruption of few tables
Date: Tue, 25 Feb 2025 12:02:43 +0000 (UTC)
Message-ID: <[email protected]> (raw)
References: <[email protected]>

Hello,
Using PostgreSQL 11.11, compiled by Visual C++ build 1914, 64-bit  with Powerbuilder 

Recently, in one of our customers' places, we got an error while saving a record from our custom-built application using PowerBuilder.     While saving a record, we compare a value from a table with a hard-coded value in application.  Here the select command failed to fetch that particular record from the table and so the save failed.
When we tried to read data from randomly selected tables [ from PGAdmin], we 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 tables.  This time the failure was with only one table and select was success in all other tables.  
So we dropped that particular table [ around 33000 records ], after removing all foreign key links and re-created that table and inserted all records from a backup set.
The problem got solved.  Since this is not the first time, we are getting this error, I want to know

1.  Why is corruption happening?  How to find out the reason?
2.  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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: Corruption of few tables
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox