pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: Krishnakanth_bn@infosys.com
Subject: BUG #16352: Data corruption in few tables
Date: Wed, 08 Apr 2020 15:58:57 +0000
Message-ID: <16352-8a22275b605f48b8@postgresql.org> (raw)

The following bug has been logged on the website:

Bug reference:      16352
Logged by:          KrishnaKanth BN
Email address:      Krishnakanth_bn@infosys.com
PostgreSQL version: 9.6.13
Operating system:   Docker image postgres:9.6.13
Description:        

Our Application is using Postgres Version (Image- postgres:9.6.13) and we
are running it as Docker Container with Volume mounted to a NFS storage. We
came across a peculiar issue.   

We had enabled unique key constraint on a particular table, it was violated
and had duplicate data. When this table was queried in the application, it
was resulting in chunk errors. This had major outage in the application.

ERROR:  missing chunk number 0 for toast value 241012 in pg_toast_2619
STATEMENT:  SELECT distinct role_name FROM tapplication_roles INNER JOIN
troles ON tapplication_roles.role_id = troles.role_id where user_id in
('user1','value1')

We followed several posts and somehow managed to remove the duplicate rows
and reindexed and vacuumed the table. We also had to manually remove
duplicate entries in pg_statistic table and reindex and vaccum it.

There are couple of other tables in which few rows are corrupted. It is
because of a corrupt value in one of the columns.

We did not see any error in the container logs to isolate this issue when it
first occurred.

Can you please throw some light what might have caused the corruption and
how can we prevent it?



view thread (3+ messages)  latest in thread

Message-ID: <16352-8a22275b605f48b8@postgresql.org>
Permalink:  ../16352-8a22275b605f48b8@postgresql.org/
Also on:    postgresql.org/message-id/16352-8a22275b605f48b8@postgresql.org

 · 

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-bugs@postgresql.org
  Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, Krishnakanth_bn@infosys.com
  Subject: Re: BUG #16352: Data corruption in few tables
  In-Reply-To: <16352-8a22275b605f48b8@postgresql.org>

* 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