Skip site navigation (1) Skip section navigation (2)

Re: Duplicate values found when reindexing unique index

From: "Mason Hale" <masonhale(at)gmail(dot)com>
To: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Gregory Stark" <stark(at)enterprisedb(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Duplicate values found when reindexing unique index
Date: 2007-12-31 14:43:09
Message-ID: 8bca3aa10712310643i656496der7aa29a757a20f77@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
>
>
> I think you misread Mason's post of 20:23 GMT-6 where he says the
> created_at values are the *same*, not different. Mason's previous bug
> report 3724 also had duplicate rows with matching created_at values.
>

Yes, to confirm, the created_at values are the same. The *only* values that
are different are updated_at and that value is set via trigger.

Another data point that may or may not be relevant: I've been working to set
up a warm standby server and have run into some weird behavior there as
well. The symptom is the server encounters an error during the file restore,
then pre-maturely exits recovery mode. I'm using the pg_standby program for
the restore_command in my recovery.conf on the standby server.

The error message from the standby server was:

Last week I had turned my attention away from the database restore, and
didn't notice that our standby server had exited recovery mode on 12/20.
Here's the last few lines from the log file (full log attached).

2007-12-20 04:11:43 CST () LOG:  restored log file
"000000010000042200000057" from archive
2007-12-20 04:13:09 CST () LOG:  restored log file
"000000010000042200000058" from archive
2007-12-20 04:14:40 CST () LOG:  restored log file
"000000010000042200000059" from archive
2007-12-20 04:14:40 CST () LOG:  invalid info bits 0001 in log file 1058,
segment 89, offset 0
2007-12-20 04:14:40 CST () LOG:  redo done at 422/58FFEE38
2007-12-20 04:14:40 CST () LOG:  restored log
file "000000010000042200000058" from archive
2007-12-20 04:14:40 CST () LOG:  archive recovery complete
2007-12-20 04:24:57 CST () LOG:  database system is ready

thanks,
Mason

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2007-12-31 15:48:43
Subject: Re: Duplicate values found when reindexing unique index
Previous:From: Simon RiggsDate: 2007-12-31 14:31:16
Subject: Re: Duplicate values found when reindexing unique index

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group