public inbox for [email protected]  

help / color / mirror / Atom feed

From: o1bigtenor <[email protected]>
Cc: Pgsql-general <[email protected]>
Subject: Re: Corruption of few tables
Date: Tue, 25 Feb 2025 06:39:11 -0600
Message-ID: <CAPpdf5-3fj-JCmQesVJoqdRO_Anab+usxMpnsuFGeXrZu_9uSw@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>

On Tue, Feb 25, 2025 at 6:03 AM [email protected]
<[email protected]> wrote:
>
> 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.
>
Not really a direct answer - - - but - - - have you considered
updating Postgresql.
Version 11 was EOL (end of life) over a year ago. Version 17 according
to the charts I've found
is the current version.

HTH

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: <CAPpdf5-3fj-JCmQesVJoqdRO_Anab+usxMpnsuFGeXrZu_9uSw@mail.gmail.com>

* 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