pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCorruption issue
10+ messages / 7 participants
[nested] [flat]
* Corruption issue
@ 2023-09-22 12:33 OS DB2 <opensourcedb2@gmail.com>
2023-09-22 16:55 ` Re: Corruption issue Dan Smith <j.daniel.smith1@gmail.com>
0 siblings, 1 reply; 10+ messages in thread
From: OS DB2 @ 2023-09-22 12:33 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Corruption issue
2023-09-22 12:33 Corruption issue OS DB2 <opensourcedb2@gmail.com>
@ 2023-09-22 16:55 ` Dan Smith <j.daniel.smith1@gmail.com>
2023-09-23 09:34 ` Re: Corruption issue Holger Jakobs <holger@jakobs.com>
0 siblings, 1 reply; 10+ messages in thread
From: Dan Smith @ 2023-09-22 16:55 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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 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
>
Recommend running chkdsk and upgrade the cluster (9.5 is EOL).
Best regards,
Dan Smith
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Corruption issue
2023-09-22 12:33 Corruption issue OS DB2 <opensourcedb2@gmail.com>
2023-09-22 16:55 ` Re: Corruption issue Dan Smith <j.daniel.smith1@gmail.com>
@ 2023-09-23 09:34 ` Holger Jakobs <holger@jakobs.com>
2023-09-24 04:26 ` Re: Corruption issue OS DB2 <opensourcedb2@gmail.com>
0 siblings, 1 reply; 10+ messages in thread
From: Holger Jakobs @ 2023-09-23 09:34 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org, Dan Smith <j.daniel.smith1@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
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 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
>>
>
>
>Recommend running chkdsk and upgrade the cluster (9.5 is EOL).
>
>
>Best regards,
>
>Dan Smith
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Corruption issue
2023-09-22 12:33 Corruption issue OS DB2 <opensourcedb2@gmail.com>
2023-09-22 16:55 ` Re: Corruption issue Dan Smith <j.daniel.smith1@gmail.com>
2023-09-23 09:34 ` Re: Corruption issue Holger Jakobs <holger@jakobs.com>
@ 2023-09-24 04:26 ` OS DB2 <opensourcedb2@gmail.com>
2023-09-24 14:23 ` Re: Corruption issue Zhaoxun Yan <yan.zhaoxun@gmail.com>
2023-09-27 05:46 ` Re: Corruption issue OS DB2 <opensourcedb2@gmail.com>
0 siblings, 2 replies; 10+ messages in thread
From: OS DB2 @ 2023-09-24 04:26 UTC (permalink / raw)
To: Holger Jakobs <holger@jakobs.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>; +Cc: Dan Smith <j.daniel.smith1@gmail.com>
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 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
>>>
>>
>>
>> Recommend running chkdsk and upgrade the cluster (9.5 is EOL).
>>
>>
>> Best regards,
>>
>> Dan Smith
>>
>>
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Corruption issue
2023-09-22 12:33 Corruption issue OS DB2 <opensourcedb2@gmail.com>
2023-09-22 16:55 ` Re: Corruption issue Dan Smith <j.daniel.smith1@gmail.com>
2023-09-23 09:34 ` Re: Corruption issue Holger Jakobs <holger@jakobs.com>
2023-09-24 04:26 ` Re: Corruption issue OS DB2 <opensourcedb2@gmail.com>
@ 2023-09-24 14:23 ` Zhaoxun Yan <yan.zhaoxun@gmail.com>
2023-09-24 14:41 ` Re: Corruption issue Scott Ribe <scott_ribe@elevated-dev.com>
1 sibling, 1 reply; 10+ messages in thread
From: Zhaoxun Yan @ 2023-09-24 14:23 UTC (permalink / raw)
To: OS DB2 <opensourcedb2@gmail.com>; +Cc: Holger Jakobs <holger@jakobs.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>; Dan Smith <j.daniel.smith1@gmail.com>
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 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
>>>>
>>>
>>>
>>> Recommend running chkdsk and upgrade the cluster (9.5 is EOL).
>>>
>>>
>>> Best regards,
>>>
>>> Dan Smith
>>>
>>>
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Corruption issue
2023-09-22 12:33 Corruption issue OS DB2 <opensourcedb2@gmail.com>
2023-09-22 16:55 ` Re: Corruption issue Dan Smith <j.daniel.smith1@gmail.com>
2023-09-23 09:34 ` Re: Corruption issue Holger Jakobs <holger@jakobs.com>
2023-09-24 04:26 ` Re: Corruption issue OS DB2 <opensourcedb2@gmail.com>
2023-09-24 14:23 ` Re: Corruption issue Zhaoxun Yan <yan.zhaoxun@gmail.com>
@ 2023-09-24 14:41 ` Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 0 replies; 10+ messages in thread
From: Scott Ribe @ 2023-09-24 14:41 UTC (permalink / raw)
To: Zhaoxun Yan <yan.zhaoxun@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
> 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
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Corruption issue
2023-09-22 12:33 Corruption issue OS DB2 <opensourcedb2@gmail.com>
2023-09-22 16:55 ` Re: Corruption issue Dan Smith <j.daniel.smith1@gmail.com>
2023-09-23 09:34 ` Re: Corruption issue Holger Jakobs <holger@jakobs.com>
2023-09-24 04:26 ` Re: Corruption issue OS DB2 <opensourcedb2@gmail.com>
@ 2023-09-27 05:46 ` OS DB2 <opensourcedb2@gmail.com>
2023-09-27 07:52 ` Re: Corruption issue Laurenz Albe <laurenz.albe@cybertec.at>
1 sibling, 1 reply; 10+ messages in thread
From: OS DB2 @ 2023-09-27 05:46 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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 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
>>>>
>>>
>>>
>>> Recommend running chkdsk and upgrade the cluster (9.5 is EOL).
>>>
>>>
>>> Best regards,
>>>
>>> Dan Smith
>>>
>>>
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Corruption issue
2023-09-22 12:33 Corruption issue OS DB2 <opensourcedb2@gmail.com>
2023-09-22 16:55 ` Re: Corruption issue Dan Smith <j.daniel.smith1@gmail.com>
2023-09-23 09:34 ` Re: Corruption issue Holger Jakobs <holger@jakobs.com>
2023-09-24 04:26 ` Re: Corruption issue OS DB2 <opensourcedb2@gmail.com>
2023-09-27 05:46 ` Re: Corruption issue OS DB2 <opensourcedb2@gmail.com>
@ 2023-09-27 07:52 ` Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-27 08:13 ` Re: Corruption issue OS DB2 <opensourcedb2@gmail.com>
0 siblings, 1 reply; 10+ messages in thread
From: Laurenz Albe @ 2023-09-27 07:52 UTC (permalink / raw)
To: OS DB2 <opensourcedb2@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Corruption issue
2023-09-22 12:33 Corruption issue OS DB2 <opensourcedb2@gmail.com>
2023-09-22 16:55 ` Re: Corruption issue Dan Smith <j.daniel.smith1@gmail.com>
2023-09-23 09:34 ` Re: Corruption issue Holger Jakobs <holger@jakobs.com>
2023-09-24 04:26 ` Re: Corruption issue OS DB2 <opensourcedb2@gmail.com>
2023-09-27 05:46 ` Re: Corruption issue OS DB2 <opensourcedb2@gmail.com>
2023-09-27 07:52 ` Re: Corruption issue Laurenz Albe <laurenz.albe@cybertec.at>
@ 2023-09-27 08:13 ` OS DB2 <opensourcedb2@gmail.com>
2023-09-27 14:11 ` Re: Corruption issue Ron <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 10+ messages in thread
From: OS DB2 @ 2023-09-27 08:13 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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
>
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Corruption issue
2023-09-22 12:33 Corruption issue OS DB2 <opensourcedb2@gmail.com>
2023-09-22 16:55 ` Re: Corruption issue Dan Smith <j.daniel.smith1@gmail.com>
2023-09-23 09:34 ` Re: Corruption issue Holger Jakobs <holger@jakobs.com>
2023-09-24 04:26 ` Re: Corruption issue OS DB2 <opensourcedb2@gmail.com>
2023-09-27 05:46 ` Re: Corruption issue OS DB2 <opensourcedb2@gmail.com>
2023-09-27 07:52 ` Re: Corruption issue Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-27 08:13 ` Re: Corruption issue OS DB2 <opensourcedb2@gmail.com>
@ 2023-09-27 14:11 ` Ron <ronljohnsonjr@gmail.com>
0 siblings, 0 replies; 10+ messages in thread
From: Ron @ 2023-09-27 14:11 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 10+ messages in thread
end of thread, other threads:[~2023-09-27 14:11 UTC | newest]
Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-09-22 12:33 Corruption issue OS DB2 <opensourcedb2@gmail.com>
2023-09-22 16:55 ` Dan Smith <j.daniel.smith1@gmail.com>
2023-09-23 09:34 ` Holger Jakobs <holger@jakobs.com>
2023-09-24 04:26 ` OS DB2 <opensourcedb2@gmail.com>
2023-09-24 14:23 ` Zhaoxun Yan <yan.zhaoxun@gmail.com>
2023-09-24 14:41 ` Scott Ribe <scott_ribe@elevated-dev.com>
2023-09-27 05:46 ` OS DB2 <opensourcedb2@gmail.com>
2023-09-27 07:52 ` Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-27 08:13 ` OS DB2 <opensourcedb2@gmail.com>
2023-09-27 14:11 ` Ron <ronljohnsonjr@gmail.com>
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