| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Bankim Bhavsar <bankim(at)nimblestorage(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Index corruption |
| Date: | 2015-03-30 18:42:21 |
| Message-ID: | CAOR=d=08e2CpTiZcmxiN+kXf7Pt+5b553TntguXSvFZ0dVjU+A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Mar 24, 2015 at 12:49 PM, Bankim Bhavsar
<bankim(at)nimblestorage(dot)com> wrote:
> Hello postgres experts,
>
> We are running a test that periodically abruptly kills postgres
> process(equivalent to kill -9) and restarts it.
> After running this test for 24 hrs or so, we see duplicate primary key
> entries in postgres table.
>
Are you killing the POSTMASTER process, deleting the pid file, and
then restarting it without killing its children? That's a recipe for
corruption.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2015-03-30 19:25:56 | Re: Muti-table join and roll-up aggregate data into nested JSON? |
| Previous Message | Deven Phillips | 2015-03-30 18:00:51 | Re: JSON "pretty" and selecting nested JSON fields |