Re: Duplicate values found when reindexing unique index

On Dec 31, 2007 9:48 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> "Mason Hale" <masonhale(at)gmail(dot)com> writes:
> >> 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.
>
> Which still demonstrates that they aren't exact images. I'd still like
> to see the pg_filedump output though ...

I sent in previous email. You saw it, yes?

> > 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
>
> Do you by any chance still have 000000010000042200000058 and
> 000000010000042200000059 archived? If so it would be useful to
> look at the first dozen lines of "od -x" dump of each of them.
>

Yes, I do. Here's the output:

[postgres(at)dev-db-2 wal_archive]$ od -x 000000010000042200000058 | head -n15
0000000 d05e 0002 0001 0000 0423 0000 0000 c100
0000020 f7df 472e e701 4728 0000 0100 2000 0000
0000040 a1db 81e6 0423 0000 0068 c000 0000 0000
0000060 0048 0000 002c 0000 0000 0000 0423 0000
0000100 0020 c100 0000 0000 0000 0000 0001 0000
0000120 0000 0000 780b 2ede 9f68 00f5 7834 0000
0000140 2f4d 0001 1f35 4774 0000 0000 0000 0000
0000160 0000 0000 0000 0000 0000 0000 0000 0000
*
0020000 d05e 0000 0001 0000 0422 0000 2000 5800
0020020 53c2 48bc 0422 0000 1fbc 5800 ce6f 2edd
0020040 003a 0000 001e 0000 0b00 0000 067f 0000
0020060 41be 0000 1ff8 0015 0000 0186 0007 0000
0020100 4337 000a 000c 008f 0122 0000 db84 d429
0020120 0422 0000 2010 5800 ce6f 2edd 003a 0000
[postgres(at)dev-db-2 wal_archive]$ od -x 000000010000042200000059 | head -n15
0000000 d05e 0001 0001 0000 006b 0000 6000 69dc
0000020 12ae 0000 6380 0024 0010 375a 21cd 1174
0000040 4001 0001 637c 0058 0010 375a 21cd 1174
0000060 4001 0001 6355 0010 0010 375a 21cd 1174
0000100 4001 0001 631d 005a 0010 375a 21cd 1174
0000120 4001 0001 62e8 001e 0010 375a 21cd 1174
0000140 4001 0001 629a 0019 0010 375a 21cd 1174
0000160 4001 0001 604a 0013 0010 375a 21cd 1174
0000200 4001 0001 6045 0025 0010 375a 21cd 1174
0000220 4001 0001 6044 0029 0010 375a 21cd 1174
0000240 4001 0001 603a 0005 0010 375a 21cd 1174
0000260 4001 0001 6020 0035 0010 375a 21cd 1174
0000300 4001 0001 600e 0050 0010 375a 21cd 1174
0000320 4001 0001 600d 0018 0010 375a 21cd 1174
0000340 4001 0001 600b 0033 0010 375a 21cd 1174
[postgres(at)dev-db-2 wal_archive]$

Mason