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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-12-31 15:48:43 | Re: Duplicate values found when reindexing unique index |
Previous Message | Simon Riggs | 2007-12-31 14:31:16 | Re: Duplicate values found when reindexing unique index |