Tom Lane wrote:
Jared Carr <ja***@89glass.com> writes:
live=# select oid,ctid,cmax,xmax,cmin,xmin,* from pg_class where
relname='order_to_do';
oid | ctid | cmax | xmax | cmin | xmin |
relname | relnamespace | reltype | relowner | relam | relfilenode |
relpages | reltuples | reltoastrelid | reltoastidxid | relhasindex |
relisshared | relkind | relnatts | relchecks | reltriggers | relukeys |
relfkeys | relrefs | relhasoids | relhaspkey | relhasrules |
relhassubclass | relacl
----------+---------+------+----------+----------+----------+-------------+--------------+----------+----------+-------+-------------+----------+-----------+---------------+---------------+-------------+-------------+---------+----------+-----------+-------------+----------+----------+---------+------------+------------+-------------+----------------+--------
11462032 | (27,2) | 0 | 2 | 2 | 46034931 |
order_to_do | 2200 | 11462033 | 101 | 0 | 11462032
| 506 | 59401 | 11462039 | 0 | t |
f | r | 5 | 0 | 1 | 0
| 0 | 0 | t | t | f |
f |
11462032 | (27,43) | 2 | 46034931 | 46034931 | 8051642 |
order_to_do | 2200 | 11462033 | 101 | 0 | 11462032
| 453 | 53407 | 11462039 | 0 | t |
f | r | 5 | 0 | 1 | 0
| 0 | 0 | t | t | f |
f |
(2 rows)
Hmm. This does not look like an index problem --- it looks like a tuple
status problem. Apparently transaction 46034931 updated this row,
marking the tuple at (27,43) invalid and inserting a new version at
(27,2). That's fine and is not a unique-index violation by itself,
but we should only be able to see one of these versions of the row.
Clearly, both of them appear good since both are visible to your current
transaction. There is no way that both of these tuples should be
considered good; one or the other ought to be invalid from the point of
view of any observing transaction. I think somebody dropped a status
update somewhere. Have you had any system crashes recently? What kind
of disk hardware is this running on --- is it IDE, and if so, do you
have write caching properly disabled
Hmm...there haven't been any crashes for a good long time, there were
some power oddities around
a month ago, but I think we would have noticed this by now. The
application that was built on it just
died yesterday, so...unfortunately I don't know for sure how long this
has been this way.
Next it is running scsi disks in a raid 5 array.
To really dig into this, we need to get a physical dump of these rows.
The best tool for this is pg_filedump, which you can get from
http://sources.redhat.com/rhdb/utilities.html. You can run it with
something like
pg_filedump -i -f -R 27 $PGDATA/base/nnn/1259
where nnn is the OID of the database with the problem (look in
pg_database to determine this). 1259 is the known OID of pg_class.
Both of the interesting tuples are on the same page 27, so this should
get the data we need.
The filedump is pasted in at the end.
Also, please show the output of "ls -l $PGDATA/pg_clog". If the
relevant segments of clog are still around, we might want to look at
what it says about the commit states of these two transactions.
ls -l $PGDATA/pg_clog gives
-rw------- 1 postgres postgres 262144 Nov 26 11:58 0000
-rw------- 1 postgres postgres 262144 Nov 28 11:15 0001
-rw------- 1 postgres postgres 262144 Nov 30 04:27 0002
-rw------- 1 postgres postgres 262144 Dec 1 07:23 0003
-rw------- 1 postgres postgres 262144 Dec 1 11:09 0004
-rw------- 1 postgres postgres 262144 Dec 1 12:50 0005
-rw------- 1 postgres postgres 262144 Dec 1 15:37 0006
-rw------- 1 postgres postgres 262144 Dec 2 05:58 0007
-rw------- 1 postgres postgres 262144 Dec 2 11:25 0008
-rw------- 1 postgres postgres 262144 Dec 2 16:54 0009
-rw------- 1 postgres postgres 262144 Dec 3 10:29 000A
-rw------- 1 postgres postgres 262144 Dec 3 16:31 000B
-rw------- 1 postgres postgres 262144 Dec 4 10:34 000C
-rw------- 1 postgres postgres 262144 Dec 5 00:00 000D
-rw------- 1 postgres postgres 262144 Dec 5 11:50 000E
-rw------- 1 postgres postgres 262144 Dec 6 14:41 000F
-rw------- 1 postgres postgres 262144 Dec 8 05:58 0010
-rw------- 1 postgres postgres 262144 Dec 8 09:30 0011
-rw------- 1 postgres postgres 262144 Dec 8 13:33 0012
-rw------- 1 postgres postgres 262144 Dec 9 06:15 0013
-rw------- 1 postgres postgres 262144 Dec 9 11:47 0014
-rw------- 1 postgres postgres 262144 Dec 10 05:45 0015
-rw------- 1 postgres postgres 262144 Dec 10 12:43 0016
-rw------- 1 postgres postgres 262144 Dec 11 08:11 0017
-rw------- 1 postgres postgres 262144 Dec 11 13:48 0018
-rw------- 1 postgres postgres 262144 Dec 12 06:20 0019
-rw------- 1 postgres postgres 262144 Dec 12 15:44 001A
-rw------- 1 postgres postgres 262144 Dec 14 19:30 001B
-rw------- 1 postgres postgres 262144 Dec 15 10:22 001C
-rw------- 1 postgres postgres 262144 Dec 15 20:41 001D
-rw------- 1 postgres postgres 262144 Dec 16 07:51 001E
-rw------- 1 postgres postgres 262144 Dec 16 13:18 001F
-rw------- 1 postgres postgres 262144 Dec 17 09:57 0020
-rw------- 1 postgres postgres 262144 Dec 18 06:00 0021
-rw------- 1 postgres postgres 262144 Dec 18 15:09 0022
-rw------- 1 postgres postgres 262144 Dec 19 12:25 0023
-rw------- 1 postgres postgres 262144 Dec 21 16:37 0024
-rw------- 1 postgres postgres 262144 Dec 22 13:30 0025
-rw------- 1 postgres postgres 262144 Dec 23 12:04 0026
-rw------- 1 postgres postgres 262144 Dec 25 17:07 0027
-rw------- 1 postgres postgres 262144 Dec 27 11:50 0028
-rw------- 1 postgres postgres 262144 Dec 29 08:27 0029
-rw------- 1 postgres postgres 262144 Dec 29 12:42 002A
-rw------- 1 postgres postgres 262144 Dec 29 17:40 002B
-rw------- 1 postgres postgres 262144 Dec 30 09:26 002C
-rw------- 1 postgres postgres 262144 Dec 30 14:18 002D
-rw------- 1 postgres postgres 262144 Dec 31 08:28 002E
-rw------- 1 postgres postgres 262144 Jan 1 00:05 002F
-rw------- 1 postgres postgres 262144 Jan 1 09:10 0030
-rw------- 1 postgres postgres 262144 Jan 2 10:04 0031
-rw------- 1 postgres postgres 262144 Jan 3 08:34 0032
-rw------- 1 postgres postgres 262144 Jan 5 08:30 0033
-rw------- 1 postgres postgres 262144 Jan 5 16:29 0034
-rw------- 1 postgres postgres 262144 Jan 6 10:50 0035
-rw------- 1 postgres postgres 262144 Jan 6 21:50 0036
-rw------- 1 postgres postgres 262144 Jan 7 13:11 0037
-rw------- 1 postgres postgres 262144 Jan 8 07:34 0038
-rw------- 1 postgres postgres 262144 Jan 8 14:47 0039
-rw------- 1 postgres postgres 262144 Jan 9 10:00 003A
-rw------- 1 postgres postgres 262144 Jan 10 16:58 003B
-rw------- 1 postgres postgres 262144 Jan 12 08:20 003C
-rw------- 1 postgres postgres 262144 Jan 12 15:13 003D
-rw------- 1 postgres postgres 262144 Jan 13 11:25 003E
-rw------- 1 postgres postgres 262144 Jan 14 08:23 003F
-rw------- 1 postgres postgres 262144 Jan 14 16:47 0040
-rw------- 1 postgres postgres 262144 Jan 15 13:06 0041
-rw------- 1 postgres postgres 262144 Jan 16 07:39 0042
-rw------- 1 postgres postgres 262144 Jan 16 14:28 0043
-rw------- 1 postgres postgres 90112 Jan 19 14:30 0044
And finally the dump.
************************************************** *****************
* PostgreSQL File/Block Formatted Dump Utility - Version 3.0-Beta
*
* File: /var/tmp/pgsql/data74/base/11462031/1259
* Options used: -i -f -R 27
*
* Dump created on: Tue Jan 20 08:17:53 2004
************************************************** *****************
Block 27 ************************************************** ******
<Header> -----
Block Offset: 0x00036000 Offsets: Lower 232 (0x00e8)
Block: Size 8192 Version 1 Upper 6416 (0x1910)
LSN: logid 7 recoff 0x2e369840 Special 8192 (0x2000)
Items: 53 Free Space: 6184
Length (including item array): 236
0000: 07000000 4098362e 18000000 e8001019 ....@.6.........
0010: 00200120 cc1a0000 cc9a2801 389a2801 . . ......(.8.(.
0020: 10190000 a4992801 e8170000 10992801 ......(.......(.
0030: 601b0000 cc1a0000 381a0000 a4190000 `.......8.......
0040: 10190000 7c180000 e8170000 54170000 ....|.......T...
0050: c0160000 2c160000 98150000 04150000 ....,...........
0060: 70140000 dc130000 48130000 b4120000 p.......H.......
0070: 20120000 8c110000 f8100000 64100000 ...........d...
0080: d00f0000 3c0f0000 a80e0000 140e0000 ....<...........
0090: 800d0000 ec0c0000 580c0000 c40b0000 ........X.......
00a0: 300b0000 9c0a0000 080a0000 74090000 0...........t...
00b0: e0080000 4c080000 b8070000 6c9f2801 ....L.......l.(.
00c0: d89e2801 fc050000 449e2801 b09d2801 ..(.....D.(...(.
00d0: 40040000 1c9d2801 889c2801 f49b2801 @.....(...(...(.
00e0: f0010000 609b2801 00000000 ....`.(.....
<Data> ------
Item 1 -- Length: 0 Offset: 6860 (0x1acc) Flags: 0x00
Item 2 -- Length: 148 Offset: 6860 (0x1acc) Flags: USED
XID: min (46034931) CMIN|XMAX: 2 CMAX|XVAC: 0
Block Id: 27 linp Index: 2 Attributes: 23 Size: 28
infomask: 0x2910 (HASOID|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
1acc: f36fbe02 02000000 00000000 00001b00 .o..............
1adc: 02001700 10291c00 90e5ae00 6f726465 .....)......orde
1aec: 725f746f 5f646f00 00000000 00000000 r_to_do.........
1afc: 00000000 00000000 00000000 00000000 ................
1b0c: 00000000 00000000 00000000 00000000 ................
1b1c: 00000000 00000000 00000000 98080000 ................
1b2c: 91e5ae00 65000000 00000000 90e5ae00 ....e...........
1b3c: fa010000 00096847 97e5ae00 00000000 ......hG........
1b4c: 01007200 05000000 01000000 00000000 ..r.............
1b5c: 01010000 ....
Item 3 -- Length: 148 Offset: 6712 (0x1a38) Flags: USED
XID: min (46034931) CMIN|XMAX: 3 CMAX|XVAC: 0
Block Id: 27 linp Index: 3 Attributes: 23 Size: 28
infomask: 0x2910 (HASOID|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
1a38: f36fbe02 03000000 00000000 00001b00 .o..............
1a48: 03001700 10291c00 9ae5ae00 6f726465 .....)......orde
1a58: 725f746f 5f646f5f 706b6579 00000000 r_to_do_pkey....
1a68: 00000000 00000000 00000000 00000000 ................
1a78: 00000000 00000000 00000000 00000000 ................
1a88: 00000000 00000000 00000000 98080000 ................
1a98: 00000000 65000000 93010000 72c7b501 ....e.......r...
1aa8: 1d010000 00096847 00000000 00000000 ......hG........
1ab8: 00006900 02000000 00000000 00000000 ..i.............
1ac8: 00000000 ....
Item 4 -- Length: 0 Offset: 6416 (0x1910) Flags: 0x00
Item 5 -- Length: 148 Offset: 6564 (0x19a4) Flags: USED
XID: min (46034931) CMIN|XMAX: 7 CMAX|XVAC: 0
Block Id: 27 linp Index: 5 Attributes: 23 Size: 28
infomask: 0x2910 (HASOID|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
19a4: f36fbe02 07000000 00000000 00001b00 .o..............
19b4: 05001700 10291c00 bb7e2101 746f5f64 .....)...~!.to_d
19c4: 6f5f6964 5f627472 65655f69 6e646578 o_id_btree_index
19d4: 00000000 00000000 00000000 00000000 ................
19e4: 00000000 00000000 00000000 00000000 ................
19f4: 00000000 00000000 00000000 98080000 ................
1a04: 00000000 64000000 93010000 73c7b501 ....d.......s...
1a14: fd000000 00096847 00000000 00000000 ......hG........
1a24: 00006900 01000000 00000000 00000000 ..i.............
1a34: 00000000 ....
Item 6 -- Length: 0 Offset: 6120 (0x17e8) Flags: 0x00
Item 7 -- Length: 148 Offset: 6416 (0x1910) Flags: USED
XID: min (46034931) CMIN|XMAX: 11 CMAX|XVAC: 0
Block Id: 27 linp Index: 7 Attributes: 23 Size: 28
infomask: 0x2910 (HASOID|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
1910: f36fbe02 0b000000 00000000 00001b00 .o..............
1920: 07001700 10291c00 99e5ae00 70675f74 .....)......pg_t
1930: 6f617374 5f313134 36323033 325f696e oast_11462032_in
1940: 64657800 00000000 00000000 00000000 dex.............
1950: 00000000 00000000 00000000 00000000 ................
1960: 00000000 00000000 00000000 63000000 ............c...
1970: 00000000 65000000 93010000 74c7b501 ....e.......t...
1980: 01000000 00000000 00000000 00000000 ................
1990: 00006900 02000000 00000000 00000000 ..i.............
19a0: 00000000 ....
Item 8 -- Length: 0 Offset: 7008 (0x1b60) Flags: 0x00
Item 9 -- Length: 0 Offset: 6860 (0x1acc) Flags: 0x00
Item 10 -- Length: 0 Offset: 6712 (0x1a38) Flags: 0x00
Item 11 -- Length: 0 Offset: 6564 (0x19a4) Flags: 0x00
Item 12 -- Length: 0 Offset: 6416 (0x1910) Flags: 0x00
Item 13 -- Length: 0 Offset: 6268 (0x187c) Flags: 0x00
Item 14 -- Length: 0 Offset: 6120 (0x17e8) Flags: 0x00
Item 15 -- Length: 0 Offset: 5972 (0x1754) Flags: 0x00
Item 16 -- Length: 0 Offset: 5824 (0x16c0) Flags: 0x00
Item 17 -- Length: 0 Offset: 5676 (0x162c) Flags: 0x00
Item 18 -- Length: 0 Offset: 5528 (0x1598) Flags: 0x00
Item 19 -- Length: 0 Offset: 5380 (0x1504) Flags: 0x00
Item 20 -- Length: 0 Offset: 5232 (0x1470) Flags: 0x00
Item 21 -- Length: 0 Offset: 5084 (0x13dc) Flags: 0x00
Item 22 -- Length: 0 Offset: 4936 (0x1348) Flags: 0x00
Item 23 -- Length: 0 Offset: 4788 (0x12b4) Flags: 0x00
Item 24 -- Length: 0 Offset: 4640 (0x1220) Flags: 0x00
Item 25 -- Length: 0 Offset: 4492 (0x118c) Flags: 0x00
Item 26 -- Length: 0 Offset: 4344 (0x10f8) Flags: 0x00
Item 27 -- Length: 0 Offset: 4196 (0x1064) Flags: 0x00
Item 28 -- Length: 0 Offset: 4048 (0x0fd0) Flags: 0x00
Item 29 -- Length: 0 Offset: 3900 (0x0f3c) Flags: 0x00
Item 30 -- Length: 0 Offset: 3752 (0x0ea8) Flags: 0x00
Item 31 -- Length: 0 Offset: 3604 (0x0e14) Flags: 0x00
Item 32 -- Length: 0 Offset: 3456 (0x0d80) Flags: 0x00
Item 33 -- Length: 0 Offset: 3308 (0x0cec) Flags: 0x00
Item 34 -- Length: 0 Offset: 3160 (0x0c58) Flags: 0x00
Item 35 -- Length: 0 Offset: 3012 (0x0bc4) Flags: 0x00
Item 36 -- Length: 0 Offset: 2864 (0x0b30) Flags: 0x00
Item 37 -- Length: 0 Offset: 2716 (0x0a9c) Flags: 0x00
Item 38 -- Length: 0 Offset: 2568 (0x0a08) Flags: 0x00
Item 39 -- Length: 0 Offset: 2420 (0x0974) Flags: 0x00
Item 40 -- Length: 0 Offset: 2272 (0x08e0) Flags: 0x00
Item 41 -- Length: 0 Offset: 2124 (0x084c) Flags: 0x00
Item 42 -- Length: 0 Offset: 1976 (0x07b8) Flags: 0x00
Item 43 -- Length: 148 Offset: 8044 (0x1f6c) Flags: USED
XID: min (8051642) CMIN|XMAX: 46034931 CMAX|XVAC: 2
Block Id: 27 linp Index: 2 Attributes: 23 Size: 28
infomask: 0x2910 (HASOID|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
1f6c: badb7a00 f36fbe02 02000000 00001b00 ..z..o..........
1f7c: 02001700 10291c00 90e5ae00 6f726465 .....)......orde
1f8c: 725f746f 5f646f00 00000000 00000000 r_to_do.........
1f9c: 00000000 00000000 00000000 00000000 ................
1fac: 00000000 00000000 00000000 00000000 ................
1fbc: 00000000 00000000 00000000 98080000 ................
1fcc: 91e5ae00 65000000 00000000 90e5ae00 ....e...........
1fdc: c5010000 009f5047 97e5ae00 00000000 ......PG........
1fec: 01007200 05000000 01000000 00000000 ..r.............
1ffc: 01010000 ....
Item 44 -- Length: 148 Offset: 7896 (0x1ed8) Flags: USED
XID: min (8051642) CMIN|XMAX: 46034931 CMAX|XVAC: 0
Block Id: 27 linp Index: 1 Attributes: 23 Size: 28
infomask: 0x2910 (HASOID|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
1ed8: badb7a00 f36fbe02 00000000 00001b00 ..z..o..........
1ee8: 01001700 10291c00 9ae5ae00 6f726465 .....)......orde
1ef8: 725f746f 5f646f5f 706b6579 00000000 r_to_do_pkey....
1f08: 00000000 00000000 00000000 00000000 ................
1f18: 00000000 00000000 00000000 00000000 ................
1f28: 00000000 00000000 00000000 98080000 ................
1f38: 00000000 65000000 93010000 54722401 ....e.......Tr$.
1f48: 03010000 009f5047 00000000 00000000 ......PG........
1f58: 00006900 02000000 00000000 00000000 ..i.............
1f68: 00000000 ....
Item 45 -- Length: 0 Offset: 1532 (0x05fc) Flags: 0x00
Item 46 -- Length: 148 Offset: 7748 (0x1e44) Flags: USED
XID: min (8051642) CMIN|XMAX: 46034931 CMAX|XVAC: 4
Block Id: 27 linp Index: 4 Attributes: 23 Size: 28
infomask: 0x2910 (HASOID|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
1e44: badb7a00 f36fbe02 04000000 00001b00 ..z..o..........
1e54: 04001700 10291c00 bb7e2101 746f5f64 .....)...~!.to_d
1e64: 6f5f6964 5f627472 65655f69 6e646578 o_id_btree_index
1e74: 00000000 00000000 00000000 00000000 ................
1e84: 00000000 00000000 00000000 00000000 ................
1e94: 00000000 00000000 00000000 98080000 ................
1ea4: 00000000 64000000 93010000 55722401 ....d.......Ur$.
1eb4: e1000000 009f5047 00000000 00000000 ......PG........
1ec4: 00006900 01000000 00000000 00000000 ..i.............
1ed4: 00000000 ....
Item 47 -- Length: 148 Offset: 7600 (0x1db0) Flags: USED
XID: min (8051642) CMIN|XMAX: 46034931 CMAX|XVAC: 8
Block Id: 27 linp Index: 6 Attributes: 23 Size: 28
infomask: 0x2910 (HASOID|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
1db0: badb7a00 f36fbe02 08000000 00001b00 ..z..o..........
1dc0: 06001700 10291c00 99e5ae00 70675f74 .....)......pg_t
1dd0: 6f617374 5f313134 36323033 325f696e oast_11462032_in
1de0: 64657800 00000000 00000000 00000000 dex.............
1df0: 00000000 00000000 00000000 00000000 ................
1e00: 00000000 00000000 00000000 63000000 ............c...
1e10: 00000000 65000000 93010000 62722401 ....e.......br$.
1e20: 01000000 00000000 00000000 00000000 ................
1e30: 00006900 02000000 00000000 00000000 ..i.............
1e40: 00000000 ....
Item 48 -- Length: 0 Offset: 1088 (0x0440) Flags: 0x00
Item 49 -- Length: 148 Offset: 7452 (0x1d1c) Flags: USED
XID: min (8051658) CMIN|XMAX: 3 CMAX|XVAC: 0
Block Id: 27 linp Index: 49 Attributes: 23 Size: 28
infomask: 0x2910 (HASOID|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
1d1c: cadb7a00 03000000 00000000 00001b00 ..z.............
1d2c: 31001700 10291c00 9ce5ae00 746f5f64 1....)......to_d
1d3c: 6f5f6974 656d7300 00000000 00000000 o_items.........
1d4c: 00000000 00000000 00000000 00000000 ................
1d5c: 00000000 00000000 00000000 00000000 ................
1d6c: 00000000 00000000 00000000 98080000 ................
1d7c: 9de5ae00 65000000 00000000 9ce5ae00 ....e...........
1d8c: 01000000 00004041 a8e5ae00 00000000 ......@A........
1d9c: 01007200 0b000300 01000000 00000000 ..r.............
1dac: 01010000 ....
Item 50 -- Length: 148 Offset: 7304 (0x1c88) Flags: USED
XID: min (8051658) CMIN|XMAX: 4 CMAX|XVAC: 0
Block Id: 27 linp Index: 50 Attributes: 23 Size: 28
infomask: 0x2910 (HASOID|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
1c88: cadb7a00 04000000 00000000 00001b00 ..z.............
1c98: 32001700 10291c00 abe5ae00 746f5f64 2....)......to_d
1ca8: 6f5f6974 656d735f 706b6579 00000000 o_items_pkey....
1cb8: 00000000 00000000 00000000 00000000 ................
1cc8: 00000000 00000000 00000000 00000000 ................
1cd8: 00000000 00000000 00000000 98080000 ................
1ce8: 00000000 65000000 93010000 63722401 ....e.......cr$.
1cf8: 02000000 00004041 00000000 00000000 ......@A........
1d08: 00006900 01000000 00000000 00000000 ..i.............
1d18: 00000000 ....
Item 51 -- Length: 148 Offset: 7156 (0x1bf4) Flags: USED
XID: min (8051658) CMIN|XMAX: 5 CMAX|XVAC: 0
Block Id: 27 linp Index: 51 Attributes: 23 Size: 28
infomask: 0x2910 (HASOID|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
1bf4: cadb7a00 05000000 00000000 00001b00 ..z.............
1c04: 33001700 10291c00 aae5ae00 70675f74 3....)......pg_t
1c14: 6f617374 5f313134 36323034 345f696e oast_11462044_in
1c24: 64657800 00000000 00000000 00000000 dex.............
1c34: 00000000 00000000 00000000 00000000 ................
1c44: 00000000 00000000 00000000 63000000 ............c...
1c54: 00000000 65000000 93010000 64722401 ....e.......dr$.
1c64: 01000000 00000000 00000000 00000000 ................
1c74: 00006900 02000000 00000000 00000000 ..i.............
1c84: 00000000 ....
Item 52 -- Length: 0 Offset: 496 (0x01f0) Flags: 0x00
Item 53 -- Length: 148 Offset: 7008 (0x1b60) Flags: USED
XID: min (8051660) CMIN|XMAX: 4 CMAX|XVAC: 0
Block Id: 27 linp Index: 53 Attributes: 23 Size: 28
infomask: 0x2910 (HASOID|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
1b60: ccdb7a00 04000000 00000000 00001b00 ..z.............
1b70: 35001700 10291c00 b8e5ae00 61646d69 5....)......admi
1b80: 6e5f7365 7373696f 6e735f70 6b657900 n_sessions_pkey.
1b90: 00000000 00000000 00000000 00000000 ................
1ba0: 00000000 00000000 00000000 00000000 ................
1bb0: 00000000 00000000 00000000 98080000 ................
1bc0: 00000000 65000000 93010000 65722401 ....e.......er$.
1bd0: 49000000 00008841 00000000 00000000 I......A........
1be0: 00006900 01000000 00000000 00000000 ..i.............
1bf0: 00000000 ....
*** End of Requested Range Encountered. Last Block Read: 27 ***
Thanks,
Jared Carr
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html