Обсуждение: Corruption issue
Hi,
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
We have restored data somehow using secondary node but still please let me know how we can find out the root cause and avoid such scenarios in future.
Regards,
Nikhil
On Fri, Sep 22, 2023, 12:48 PM OS DB2 <opensourcedb2@gmail.com> wrote:
Hi,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 corruptedOs - linuxPostgresql version - 9.5We have restored data somehow using secondary node but still please let me know how we can find out the root cause and avoid such scenarios in future.Regards,Nikhil
Recommend running chkdsk and upgrade the cluster (9.5 is EOL).
Best regards,
Dan Smith
chkdsk is a Windows program, but the original poster wrote her is using Linux.
So, badblocks could be the appropriate program.
So, badblocks could be the appropriate program.
Am 22. September 2023 18:55:14 MESZ schrieb Dan Smith <j.daniel.smith1@gmail.com>:
On Fri, Sep 22, 2023, 12:48 PM OS DB2 <opensourcedb2@gmail.com> wrote:Hi,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 corruptedOs - linuxPostgresql version - 9.5We have restored data somehow using secondary node but still please let me know how we can find out the root cause and avoid such scenarios in future.Regards,NikhilRecommend running chkdsk and upgrade the cluster (9.5 is EOL).Best regards,Dan Smith
How can I stop it from recurring?
On Sat, 23 Sept 2023, 15:04 Holger Jakobs, <holger@jakobs.com> wrote:
chkdsk is a Windows program, but the original poster wrote her is using Linux.
So, badblocks could be the appropriate program.Am 22. September 2023 18:55:14 MESZ schrieb Dan Smith <j.daniel.smith1@gmail.com>:On Fri, Sep 22, 2023, 12:48 PM OS DB2 <opensourcedb2@gmail.com> wrote:Hi,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 corruptedOs - linuxPostgresql version - 9.5We have restored data somehow using secondary node but still please let me know how we can find out the root cause and avoid such scenarios in future.Regards,NikhilRecommend running chkdsk and upgrade the cluster (9.5 is EOL).Best regards,Dan Smith
Excuse me - how did you post this issue? I have not found the place to post a thread on lists.postgresql.org.
On Sun, Sep 24, 2023 at 3:27 PM OS DB2 <opensourcedb2@gmail.com> wrote:
How can I stop it from recurring?On Sat, 23 Sept 2023, 15:04 Holger Jakobs, <holger@jakobs.com> wrote:chkdsk is a Windows program, but the original poster wrote her is using Linux.
So, badblocks could be the appropriate program.Am 22. September 2023 18:55:14 MESZ schrieb Dan Smith <j.daniel.smith1@gmail.com>:On Fri, Sep 22, 2023, 12:48 PM OS DB2 <opensourcedb2@gmail.com> wrote:Hi,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 corruptedOs - linuxPostgresql version - 9.5We have restored data somehow using secondary node but still please let me know how we can find out the root cause and avoid such scenarios in future.Regards,NikhilRecommend running chkdsk and upgrade the cluster (9.5 is EOL).Best regards,Dan Smith
> On Sep 24, 2023, at 8:23 AM, Zhaoxun Yan <yan.zhaoxun@gmail.com> wrote: > > Excuse me - how did you post this issue? I have not found the place to post a thread on lists.postgresql.org. > email to the list--like you just did
What can be the cause of corruption?
On Sun, 24 Sept 2023, 09:56 OS DB2, <opensourcedb2@gmail.com> wrote:
How can I stop it from recurring?On Sat, 23 Sept 2023, 15:04 Holger Jakobs, <holger@jakobs.com> wrote:chkdsk is a Windows program, but the original poster wrote her is using Linux.
So, badblocks could be the appropriate program.Am 22. September 2023 18:55:14 MESZ schrieb Dan Smith <j.daniel.smith1@gmail.com>:On Fri, Sep 22, 2023, 12:48 PM OS DB2 <opensourcedb2@gmail.com> wrote:Hi,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 corruptedOs - linuxPostgresql version - 9.5We have restored data somehow using secondary node but still please let me know how we can find out the root cause and avoid such scenarios in future.Regards,NikhilRecommend running chkdsk and upgrade the cluster (9.5 is EOL).Best regards,Dan Smith
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
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
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?
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 sp5On 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.
Born in Arizona, moved to Babylonia.