Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qlVYP-0036kj-Pd for pgsql-admin@arkaria.postgresql.org; Wed, 27 Sep 2023 14:30:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qlVXP-000N22-M6 for pgsql-admin@arkaria.postgresql.org; Wed, 27 Sep 2023 14:29:16 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qlVVy-000FG1-Ot for pgsql-admin@lists.postgresql.org; Wed, 27 Sep 2023 14:27:47 +0000 Received: from mail-yw1-x112a.google.com ([2607:f8b0:4864:20::112a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qlVGR-007u98-C0 for pgsql-admin@lists.postgresql.org; Wed, 27 Sep 2023 14:11:45 +0000 Received: by mail-yw1-x112a.google.com with SMTP id 00721157ae682-59c0a7d54bdso136157347b3.1 for ; Wed, 27 Sep 2023 07:11:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1695823901; x=1696428701; darn=lists.postgresql.org; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=gWQ72I/KTHBZitXKC+cI6tZg2xSMrm/ORoNlZSrZdiI=; b=lODaDhNQOSiOuC7576YEYZVlmfi3T1uzycJ3aly/8nmWL8/bIXwpdnhVr3ZQts+6T1 9iPRUmzdWyO+8WTX9R7hC2ubDvg5nvSgbCLzhoIE96LjNGY0eyI1bnsXVhKuHbtAM8+E EzevLmeRjOu8rNcrZMxHpKmoSZwniE1aWFdKcPEs3Z29aUonZpuOsvQWtPwgtDJxjdLB /AF++V/3h5hs+ltDujGR2lKOVAz+Bnmyh/5AS6zqukLkwdfFe0kgcAnKr2HKWfqgtNGX y9FqlCfPDfJH2Mi6I+3wibMx/A2zXRvYZY3eP7HqBPKcsGvpCBnOZYDahoNsk8M1mvpC tATg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1695823901; x=1696428701; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=gWQ72I/KTHBZitXKC+cI6tZg2xSMrm/ORoNlZSrZdiI=; b=QKwO01IZANL6FdSZKbHgMZrsfrLo01PtLsxtfYhjSxgcgjQSyFwoybCGLzgB4HKdt9 C2M268KJfGCGr+Pgv6gCQ+nfI6xFnymQnmflSlYnm0o21h58CpbsXy1mXwNsMYFU2J/8 KxE5bf6eKlvMHheWJePsf1/lVHv1lbJqWTPhrxVEG9aQvVAXYNQj7lUObPRNegpcCgD4 HLN7wMcVZ1OM2CGNI/VmaGukJZDhHijpI0oeOO9xipXCwj3N27EoRs8iBmawFpVEShsx SyqR44WhlgrObmPZ8hCVccDcQZ0vq9FSG+i5jI2y9LDAbH+WxGpzFk54sLiiNdWQc0ki NVUg== X-Gm-Message-State: AOJu0YwZZbNAYtaK2cLUycrGUreugug0TLbg8nceQMcMCCP2qDKZrRof +W8pEvHbPWJndQzTpIBXmz1xLcTnZjo= X-Google-Smtp-Source: AGHT+IGglslHGw+iFbwEMCEEhKQ7BcKn3OFuRQgTN4GXk9SbCpMOtVtyzzhMP7Eag0d0dhUjMfEO6g== X-Received: by 2002:a81:c20f:0:b0:59f:7f8e:dc4a with SMTP id z15-20020a81c20f000000b0059f7f8edc4amr2555917ywc.22.1695823901396; Wed, 27 Sep 2023 07:11:41 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:5dc0:a698:4c4:a73d? ([2600:1700:bd2c:b810:5dc0:a698:4c4:a73d]) by smtp.googlemail.com with ESMTPSA id e189-20020a8169c6000000b0059af9f2ee68sm3685017ywc.66.2023.09.27.07.11.40 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 27 Sep 2023 07:11:41 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------u0rD5XS0xrXoq61tKjDB4vp7" Message-ID: Date: Wed, 27 Sep 2023 09:11:40 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.11.0 Subject: Re: Corruption issue Content-Language: en-US To: pgsql-admin@lists.postgresql.org References: <1D460E80-E3B1-493D-9801-A34DD9657CA2@jakobs.com> <181619eddd09e4a23568d748bc5d2504c0a496ad.camel@cybertec.at> From: Ron In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------u0rD5XS0xrXoq61tKjDB4vp7 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit 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, wrote: > > On Wed, 2023-09-27 at 11:16 +0530, OS DB2 wrote: > > > > > On Fri, Sep 22, 2023, 12:48 PM OS DB2 > 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. --------------u0rD5XS0xrXoq61tKjDB4vp7 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit 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.
--------------u0rD5XS0xrXoq61tKjDB4vp7--