pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Corruption issue
Date: Wed, 27 Sep 2023 09:11:40 -0500
Message-ID: <ff7390a0-33a6-610f-4836-8abcae7ccd59@gmail.com> (raw)
In-Reply-To: <CAM==JRFTBnbhaF0ytAf5KPq-qFr1VmbNUMUQPSkZnNQB53XQnw@mail.gmail.com>
References: <CAM==JRGCwoupcQsrggE7cSca0J8HtCfG3hTx+L=aHGB6dsMe-A@mail.gmail.com>
	<CAK50JryUP_gFkxPR=T=TDegZmCRFk21tzWybChX8a8pZY=viqA@mail.gmail.com>
	<1D460E80-E3B1-493D-9801-A34DD9657CA2@jakobs.com>
	<CAM==JRGBdfjyhhZpPeT9chA=C6H0vS_dCp6qi9f6GQt5uFozgg@mail.gmail.com>
	<CAM==JREm6C-qvF7bCvoH_Ru5AemXb_Y82e3kGupefVPBf1+T+w@mail.gmail.com>
	<181619eddd09e4a23568d748bc5d2504c0a496ad.camel@cybertec.at>
	<CAM==JRFTBnbhaF0ytAf5KPq-qFr1VmbNUMUQPSkZnNQB53XQnw@mail.gmail.com>

1) Pg 9.5 minor version?
2) How old is the hardware?
3) What kernel version does SUSE 12 SP5 run?
4) Is SUSE 12 SP5 also EOL?

On 9/27/23 03:13, OS DB2 wrote:
> Hi,
>
> Os version is suse12 sp5
>
> On Wed, 27 Sept 2023, 13:22 Laurenz Albe, <laurenz.albe@cybertec.at> wrote:
>
>     On Wed, 2023-09-27 at 11:16 +0530, OS DB2 wrote:
>     > > > > On Fri, Sep 22, 2023, 12:48 PM OS DB2
>     <opensourcedb2@gmail.com> wrote:
>     > > > > > In one of the our production database when we are trying to
>     fetch the
>     > > > > > records from one of the table, we are getting below error.
>     > > > > >
>     > > > > > Compressed data is corrupted
>     > > > > >
>     > > > > > Os - linux
>     > > > > > Postgresql version - 9.5
>     >
>     > What can be the cause of corruption?
>
>     You wrote 9.5, but you didn't disclose how old your hardware or
>     your operating system are.
>
>     Most often the cause is bad hardware, but it could be a bug in the
>     file system
>     or the Linux kernel or one of the numerous bugs that have been fixed in
>     PostgreSQL since 9.5 went out of commission.
>
>     Yours,
>     Laurenz Albe
>

-- 
Born in Arizona, moved to Babylonia.

view thread (10+ messages)

Message-ID: <ff7390a0-33a6-610f-4836-8abcae7ccd59@gmail.com>
Permalink:  ../ff7390a0-33a6-610f-4836-8abcae7ccd59@gmail.com/
Also on:    postgresql.org/message-id/ff7390a0-33a6-610f-4836-8abcae7ccd59@gmail.com

 · 

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: pgsql-admin@postgresql.org
  Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Corruption issue
  In-Reply-To: <ff7390a0-33a6-610f-4836-8abcae7ccd59@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 DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox