table corrupted
Hi
Can someone help me how to repair the problem below, I'm using Postgres
8.2.5:
- after appeared the erros below in selects, vacuum and dump in one table:
2009-10-16 16:07:06 BRT 192.168.0.87 ERROR: could not access status of
transaction 29024764
2009-10-16 16:07:06 BRT 192.168.0.87 DETAIL: Could not open file
"pg_clog/001B": No such file or directory.
2009-10-16 16:07:06 BRT 192.168.0.87 STATEMENT: select ...
2009-10-16 16:11:47 BRT 192.168.0.29 ERROR: invalid page header in block
462821 of relation "..."
2009-10-16 16:11:47 BRT 192.168.0.29 STATEMENT: select ....
I created the file pg_clog/001B with 256kB of /dev/zero
That resolve the problem with vacuum but began other error in selects and
dump to the same table ended all connections and stay up after showing the
error:
2009-10-19 13:50:03 BRT LOG: server process (PID 1544) was terminated by
signal 11
2009-10-19 13:50:03 BRT LOG: terminating any other active server processes
2009-10-19 13:50:03 BRT 192.168.0.253 WARNING: terminating connection
because of crash of another server process
2009-10-19 13:50:03 BRT 192.168.0.253 DETAIL: The postmaster has commanded
this server process to roll back the current transaction and exit, because
another server process exited abnormally and possibly corrupted shared
memory.
2009-10-19 13:50:03 BRT 192.168.0.253 HINT: In a moment you should be able
to reconnect to the database and repeat your command.
Was habilited the zero_damage_pages option then executed selects, vacuums,
and dumps but not changed...
Was identified 2 register that if refered cause error.
The BD was restored in backup server with 8.2.7 and executed vacuums ok but
select and reindex crashed...
Instaled 8.3.8 version and used pg_dump but error
And then the select below show the problem where the codentrega from where
clause differ from select answer:
LOGIST=# select codentrega from entregas where codentrega='9879622';
codentrega
------------
z879622
(1 registro)
Any idea?
Hi everybody,
Can someone help me how to repair the problem below, I'm using Postgres
8.2.5:
- after appeared the erros below in selects, vacuum and dump in one table:
2009-10-16 16:07:06 BRT 192.168.0.87 ERROR: could not access status of
transaction 29024764
2009-10-16 16:07:06 BRT 192.168.0.87 DETAIL: Could not open file
"pg_clog/001B": No such file or directory.
2009-10-16 16:07:06 BRT 192.168.0.87 STATEMENT: select ...
2009-10-16 16:11:47 BRT 192.168.0.29 ERROR: invalid page header in block
462821 of relation "..."
2009-10-16 16:11:47 BRT 192.168.0.29 STATEMENT: select ....
I created the file pg_clog/001B with 256kB of /dev/zero
That resolve the problem with vacuum but began other error in selects and
dump to the same table ended all connections and stay up after showing the
error:
2009-10-19 13:50:03 BRT LOG: server process (PID 1544) was terminated by
signal 11
2009-10-19 13:50:03 BRT LOG: terminating any other active server processes
2009-10-19 13:50:03 BRT 192.168.0.253 WARNING: terminating connection
because of crash of another server process
2009-10-19 13:50:03 BRT 192.168.0.253 DETAIL: The postmaster has commanded
this server process to roll back the current transaction and exit, because
another server process exited abnormally and possibly corrupted shared
memory.
2009-10-19 13:50:03 BRT 192.168.0.253 HINT: In a moment you should be able
to reconnect to the database and repeat your command.
Was habilited the zero_damage_pages option then executed selects, vacuums,
and dumps but not changed...
Was identified 2 register that if refered cause error.
The BD was restored in backup server with 8.2.7 and executed vacuums ok but
select and reindex crashed...
Instaled 8.3.8 version and used pg_dump but error
And then the select below show the problem where the codentrega from where
clause differ from select answer:
LOGIST=# select codentrega from entregas where codentrega='9879622';
codentrega
------------
z879622
(1 registro)
Any idea?
On Thu, 2009-10-22 at 14:28 -0200, João Eugenio Marynowski wrote:
Hi
Repair? Not likely. Get past? Maybe.
set zero_damaged_pages to on;
vacuum verbose;
I would do a hardware check too.
Joshua D. Drake
Can someone help me how to repair the problem below, I'm using
Postgres 8.2.5:
- after appeared the erros below in selects, vacuum and dump in one
table:
2009-10-16 16:07:06 BRT 192.168.0.87 ERROR: could not access status
of transaction 29024764
2009-10-16 16:07:06 BRT 192.168.0.87 DETAIL: Could not open file
"pg_clog/001B": No such file or directory.
2009-10-16 16:07:06 BRT 192.168.0.87 STATEMENT: select ...
2009-10-16 16:11:47 BRT 192.168.0.29 ERROR: invalid page header in
block 462821 of relation "..."
2009-10-16 16:11:47 BRT 192.168.0.29 STATEMENT: select ....
I created the file pg_clog/001B with 256kB of /dev/zero
That resolve the problem with vacuum but began other error in selects
and dump to the same table ended all connections and stay up after
showing the error:
2009-10-19 13:50:03 BRT LOG: server process (PID 1544) was
terminated by signal 11
2009-10-19 13:50:03 BRT LOG: terminating any other active server
processes
2009-10-19 13:50:03 BRT 192.168.0.253 WARNING: terminating connection
because of crash of another server process
2009-10-19 13:50:03 BRT 192.168.0.253 DETAIL: The postmaster has
commanded this server process to roll back the current transaction and
exit, because another server process exited abnormally and possibly
corrupted shared memory.
2009-10-19 13:50:03 BRT 192.168.0.253 HINT: In a moment you should be
able to reconnect to the database and repeat your command.
Was habilited the zero_damage_pages option then executed selects,
vacuums, and dumps but not changed...
Was identified 2 register that if refered cause error.
The BD was restored in backup server with 8.2.7 and executed vacuums
ok but select and reindex crashed...Instaled 8.3.8 version and used pg_dump but error
And then the select below show the problem where the codentrega from
where clause differ from select answer:LOGIST=# select codentrega from entregas where codentrega='9879622';
codentrega
------------
z879622
(1 registro)Any idea?
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
If the world pushes look it in the eye and GRR. Then push back harder. - Salamander
The hardware is ok because we have migrated to other machine and the errors
is the same
zero_damaged_pages is on and the vaccum verbose don't show any error...
2009/10/22 Joshua D. Drake <jd@commandprompt.com>
Show quoted text
On Thu, 2009-10-22 at 14:28 -0200, João Eugenio Marynowski wrote:
Hi
Repair? Not likely. Get past? Maybe.
set zero_damaged_pages to on;
vacuum verbose;I would do a hardware check too.
Joshua D. Drake
Can someone help me how to repair the problem below, I'm using
Postgres 8.2.5:
- after appeared the erros below in selects, vacuum and dump in one
table:
2009-10-16 16:07:06 BRT 192.168.0.87 ERROR: could not access status
of transaction 29024764
2009-10-16 16:07:06 BRT 192.168.0.87 DETAIL: Could not open file
"pg_clog/001B": No such file or directory.
2009-10-16 16:07:06 BRT 192.168.0.87 STATEMENT: select ...
2009-10-16 16:11:47 BRT 192.168.0.29 ERROR: invalid page header in
block 462821 of relation "..."
2009-10-16 16:11:47 BRT 192.168.0.29 STATEMENT: select ....
I created the file pg_clog/001B with 256kB of /dev/zero
That resolve the problem with vacuum but began other error in selects
and dump to the same table ended all connections and stay up after
showing the error:
2009-10-19 13:50:03 BRT LOG: server process (PID 1544) was
terminated by signal 11
2009-10-19 13:50:03 BRT LOG: terminating any other active server
processes
2009-10-19 13:50:03 BRT 192.168.0.253 WARNING: terminating connection
because of crash of another server process
2009-10-19 13:50:03 BRT 192.168.0.253 DETAIL: The postmaster has
commanded this server process to roll back the current transaction and
exit, because another server process exited abnormally and possibly
corrupted shared memory.
2009-10-19 13:50:03 BRT 192.168.0.253 HINT: In a moment you should be
able to reconnect to the database and repeat your command.
Was habilited the zero_damage_pages option then executed selects,
vacuums, and dumps but not changed...
Was identified 2 register that if refered cause error.
The BD was restored in backup server with 8.2.7 and executed vacuums
ok but select and reindex crashed...Instaled 8.3.8 version and used pg_dump but error
And then the select below show the problem where the codentrega from
where clause differ from select answer:LOGIST=# select codentrega from entregas where codentrega='9879622';
codentrega
------------
z879622
(1 registro)Any idea?
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
If the world pushes look it in the eye and GRR. Then push back harder. -
Salamander
On Thu, Oct 22, 2009 at 10:34 PM, João Eugenio Marynowski
<joaoem@gmail.com> wrote:
The hardware is ok because we have migrated to other machine and the errors
is the same
zero_damaged_pages is on and the vaccum verbose don't show any error...
You need to dump (or otherwise extract) your data and load it into a
new cluster. The one you have sounds like it's in bad shape.
...Robert
I don't be able to select the data from table with pg_dump or select, both
occur error...
how i can identified the register of a table independent the contends of the
register, only control of the postgres?
I eliminate the index pk but now I don't be able to create begin because
show the error:
ERROR: index row requires 21776744 bytes, maximum size is 8191
How increase the index row?
--
João Eugenio Marynowski
(41) 9624-3933
2009/10/23 Robert Haas <robertmhaas@gmail.com>
Show quoted text
On Thu, Oct 22, 2009 at 10:34 PM, João Eugenio Marynowski
<joaoem@gmail.com> wrote:The hardware is ok because we have migrated to other machine and the
errors
is the same
zero_damaged_pages is on and the vaccum verbose don't show any error...You need to dump (or otherwise extract) your data and load it into a
new cluster. The one you have sounds like it's in bad shape....Robert
On Thu, Oct 22, 2009 at 11:00 PM, João Eugenio Marynowski
<joaoem@gmail.com> wrote:
I don't be able to select the data from table with pg_dump or select, both
occur error...
how i can identified the register of a table independent the contends of the
register, only control of the postgres?
I eliminate the index pk but now I don't be able to create begin because
show the error:
ERROR: index row requires 21776744 bytes, maximum size is 8191
How increase the index row?
Well, that's not really the problem. Your data is corrupted -
increasing the index row size is not going to fix it.
I'm not really knowledgeable enough about the guts of the database to
know whether there are lower-level tools that could be used to rescue
your data. I wonder if you'd have any luck selecting data a few rows
at a time (LIMIT 100, say, without ORDER BY). That might at least
enable you to get some of the data out of there, if there are some
pages that are undamaged. But I'm grasping at straws here.
...Robert
João Eugenio Marynowski <joaoem@gmail.com> writes:
2009-10-16 16:11:47 BRT 192.168.0.29 ERROR: invalid page header in
block 462821 of relation "..."
It could be that the following will prove helpful:
http://archives.postgresql.org/pgsql-general/2007-07/msg00506.php
http://pgsql.tapoueh.org/site/html/news/20080410.badblock.html
Regards,
--
dim
2009/10/23 Robert Haas <robertmhaas@gmail.com>
Well, that's not really the problem. Your data is corrupted -
increasing the index row size is not going to fix it.I'm not really knowledgeable enough about the guts of the database to
know whether there are lower-level tools that could be used to rescue
your data. I wonder if you'd have any luck selecting data a few rows
at a time (LIMIT 100, say, without ORDER BY). That might at least
enable you to get some of the data out of there, if there are some
pages that are undamaged. But I'm grasping at straws here....Robert
I ask about the index row size because I can't re-index the database and
I've a server for tests and in this I removed the pk and can't recreate the
index because it showing error about size row limit indices.
And, only occurs erros when you run a query involving the records damaged.
I'm trying to identify them (less of 1% of the total registers).
2009/10/23 Dimitri Fontaine <dfontaine@hi-media.com>
João Eugenio Marynowski <joaoem@gmail.com> writes:
2009-10-16 16:11:47 BRT 192.168.0.29 ERROR: invalid page header in
block 462821 of relation "..."It could be that the following will prove helpful:
http://archives.postgresql.org/pgsql-general/2007-07/msg00506.php
http://pgsql.tapoueh.org/site/html/news/20080410.badblock.htmlRegards,
--
dim
I thought this would solve my problems but not yet ...
the block that I found is not presenting error...
find_bad_block
----------------
(514708,16)
(1 registro)
blockId / blocks_per_chunk = 514708 / 131072 = 3,9269104
base/21058/21271.3
chunk_block_id = block_id % blocks_per_chunk = 514708 % 131072 = 121492
is attached the result of pg_filedump -if -R 121492
/var/lib/postgresql/8.2/main/base/21058/21271.3
Even then I filled the block with zero
But when I run again the find_bad_block it show one block before, ctid
514707, and then, 514706 and I stop...
Any suggestion and explication?
--
João Eugenio
Attachments:
pg_filedump-ctid-514708application/octet-stream; name=pg_filedump-ctid-514708Download
*******************************************************************
* PostgreSQL File/Block Formatted Dump Utility - Version 8.2.0
*
* File: /var/lib/postgresql/8.2/main/base/21058/21271.3
* Options used: -if -R 121492
*
* Dump created on: Fri Oct 23 21:10:27 2009
*******************************************************************
Block 121492 ********************************************************
<Header> -----
Block Offset: 0x3b528000 Offsets: Lower 92 (0x005c)
Block: Size 8192 Version 3 Upper 1544 (0x0608)
LSN: logid 756 recoff 0x903b247c Special 8192 (0x2000)
Items: 18 Free Space: 1452
Length (including item array): 92
0000: f4020000 7c243b90 01000000 5c000806 ....|$;.....\...
0010: 00200320 649e3803 cc9c3003 409b1803 . . d.8...0.@...
0020: b0992003 1c982803 7c964003 dc944003 .. ...(.|.@...@.
0030: 34935003 90914803 0c900803 548e7003 4.P...H.....T.p.
0040: bc8c2c03 208b3403 3c89c803 a0873403 ..,. .4.<.....4.
0050: 08862c03 a0020000 e8000000 ..,.........
<Data> ------
Item 1 -- Length: 412 Offset: 7780 (0x1e64) Flags: USED
XMIN: 679931577 CMIN: 0 XMAX: 679931577 CMAX|XVAC: 680494136
Block Id: 514708 linp Index: 1 Attributes: 71 Size: 36
infomask: 0x2983 (HASNULL|HASVARWIDTH|XMAX_SHARED_LOCK|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
t_bits: [0]: 0xff [1]: 0xff [2]: 0xff [3]: 0xfc
[4]: 0xff [5]: 0xbf [6]: 0x2f [7]: 0x70
[8]: 0x55
1e64: b9ee8628 00000000 b9ee8628 38848f28 ...(.......(8..(
1e74: 070094da 01004700 832924ff fffffcff ......G..)$.....
1e84: bf2f7055 0c000000 31303935 36393636 ./pU....10956966
1e94: 7f006201 11000000 53533030 34373733 ..b.....SS004773
1ea4: 33323342 54000000 04000000 00000000 323BT...........
1eb4: 04000000 1e000000 4d415243 4f532052 ........MARCOS R
1ec4: 4f424552 544f2044 45204f4c 49564549 OBERTO DE OLIVEI
1ed4: 52410000 04000000 19000000 52204c41 RA..........R LA
1ee4: 43455244 41204d41 52515545 53203230 CERDA MARQUES 20
1ef4: 31000000 04000000 04000000 04000000 1...............
1f04: 0d000000 53414f20 5041554c 4f000000 ....SAO PAULO...
1f14: 0c000000 30323434 31323030 06000000 ....02441200....
1f24: 53500000 04000000 04000000 01000000 SP..............
1f34: f80d0000 fb0d0000 fc0d0000 fe0d0000 ................
1f44: fe0d0000 06000000 30300000 ba040000 ........00......
1f54: 05000000 20000000 00000000 01000000 .... ...........
1f64: 09000000 30303333 34000000 0b000000 ....00334.......
1f74: 30303835 32333300 04000000 04000000 0085233.........
1f84: 04000000 04000000 42020000 fc0d0000 ........B.......
1f94: 0080e24f 51190100 00000000 fd0d0000 ...OQ...........
1fa4: 07000000 32303100 00000000 00000000 ....201.........
1fb4: 05000000 58000000 00000000 02000000 ....X...........
1fc4: 08000000 30343430 07000000 09000000 ....0440........
1fd4: 30303030 33000000 06000000 30310000 00003.......01..
1fe4: 00000000 00000000 08000000 00000300 ................
1ff4: 08000000 30343430 04000000 ....0440....
Item 2 -- Length: 408 Offset: 7372 (0x1ccc) Flags: USED
XMIN: 679931737 CMIN: 0 XMAX: 679931737 CMAX|XVAC: 680494136
Block Id: 514708 linp Index: 2 Attributes: 71 Size: 36
infomask: 0x2983 (HASNULL|HASVARWIDTH|XMAX_SHARED_LOCK|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
t_bits: [0]: 0xff [1]: 0xff [2]: 0xff [3]: 0xfc
[4]: 0xff [5]: 0xbf [6]: 0x2f [7]: 0x70
[8]: 0x55
1ccc: 59ef8628 00000000 59ef8628 38848f28 Y..(....Y..(8..(
1cdc: 070094da 02004700 832924ff fffffcff ......G..)$.....
1cec: bf2f7055 0c000000 31303935 37373237 ./pU....10957727
1cfc: 7f006201 11000000 53533030 34373830 ..b.....SS004780
1d0c: 39333942 54000000 04000000 00000000 939BT...........
1d1c: 04000000 1f000000 4d494348 454c4520 ........MICHELE
1d2c: 444f5320 53414e54 4f532044 41205349 DOS SANTOS DA SI
1d3c: 4c564100 04000000 1b000000 52205441 LVA.........R TA
1d4c: 56414e4e 45532031 32352041 50542031 VANNES 125 APT 1
1d5c: 33204400 04000000 04000000 04000000 3 D.............
1d6c: 0d000000 53414f20 5041554c 4f000000 ....SAO PAULO...
1d7c: 0c000000 30323434 33303930 06000000 ....02443090....
1d8c: 53500000 04000000 04000000 01000000 SP..............
1d9c: f80d0000 fb0d0000 fc0d0000 fe0d0000 ................
1dac: fe0d0000 06000000 30300000 b3070000 ........00......
1dbc: 05000000 20000000 00000000 01000000 .... ...........
1dcc: 09000000 30303333 34000000 0b000000 ....00334.......
1ddc: 30323036 30363900 04000000 04000000 0206069.........
1dec: 04000000 04000000 d8070000 fc0d0000 ................
1dfc: 0080e24f 51190100 00000000 fd0d0000 ...OQ...........
1e0c: 05000000 31000000 00000000 05000000 ....1...........
1e1c: 58000000 00000000 02000000 08000000 X...............
1e2c: 30343430 07000000 09000000 30303030 0440........0000
1e3c: 33000000 06000000 30310000 00000000 3.......01......
1e4c: 00000000 08000000 00000300 08000000 ................
1e5c: 30343430 04000000 0440....
Item 3 -- Length: 396 Offset: 6976 (0x1b40) Flags: USED
XMIN: 679931706 CMIN: 0 XMAX: 679931706 CMAX|XVAC: 680494136
Block Id: 514708 linp Index: 3 Attributes: 71 Size: 36
infomask: 0x2983 (HASNULL|HASVARWIDTH|XMAX_SHARED_LOCK|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
t_bits: [0]: 0xff [1]: 0xff [2]: 0xff [3]: 0xfc
[4]: 0xff [5]: 0xbf [6]: 0x2f [7]: 0x70
[8]: 0x55
1b40: 3aef8628 00000000 3aef8628 38848f28 :..(....:..(8..(
1b50: 070094da 03004700 832924ff fffffcff ......G..)$.....
1b60: bf2f7055 0c000000 31303935 36323530 ./pU....10956250
1b70: 7f006201 11000000 53533030 34373636 ..b.....SS004766
1b80: 31363342 54000000 04000000 00000000 163BT...........
1b90: 04000000 1d000000 414e4745 4c412041 ........ANGELA A
1ba0: 50415245 43494441 20464552 52454952 PARECIDA FERREIR
1bb0: 41000000 04000000 0e000000 52205641 A...........R VA
1bc0: 55442031 35380000 04000000 04000000 UD 158..........
1bd0: 04000000 0d000000 53414f20 5041554c ........SAO PAUL
1be0: 4f000000 0c000000 30323434 33303630 O.......02443060
1bf0: 06000000 53500000 04000000 04000000 ....SP..........
1c00: 01000000 f80d0000 fb0d0000 fc0d0000 ................
1c10: fe0d0000 fe0d0000 06000000 30300000 ............00..
1c20: ee010000 05000000 20000000 00000000 ........ .......
1c30: 01000000 09000000 30303333 34000000 ........00334...
1c40: 0b000000 30343339 36313600 04000000 ....0439616.....
1c50: 04000000 04000000 04000000 9a000000 ................
1c60: fc0d0000 0080e24f 51190100 00000000 .......OQ.......
1c70: fd0d0000 05000000 31000000 00000000 ........1.......
1c80: 05000000 58000000 00000000 02000000 ....X...........
1c90: 08000000 30343430 07000000 09000000 ....0440........
1ca0: 30303030 33000000 06000000 30310000 00003.......01..
1cb0: 00000000 00000000 08000000 00000300 ................
1cc0: 08000000 30343430 04000000 ....0440....
Item 4 -- Length: 400 Offset: 6576 (0x19b0) Flags: USED
XMIN: 679931831 CMIN: 0 XMAX: 679931831 CMAX|XVAC: 680494136
Block Id: 514708 linp Index: 4 Attributes: 71 Size: 36
infomask: 0x2983 (HASNULL|HASVARWIDTH|XMAX_SHARED_LOCK|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
t_bits: [0]: 0xff [1]: 0xff [2]: 0xff [3]: 0xfc
[4]: 0xff [5]: 0xbf [6]: 0x2f [7]: 0x70
[8]: 0x55
19b0: b7ef8628 00000000 b7ef8628 38848f28 ...(.......(8..(
19c0: 070094da 04004700 832924ff fffffcff ......G..)$.....
19d0: bf2f7055 0c000000 31303935 37303137 ./pU....10957017
19e0: 7f006201 11000000 53533030 34373733 ..b.....SS004773
19f0: 38333642 54000000 04000000 00000000 836BT...........
1a00: 04000000 18000000 4a554c49 45544120 ........JULIETA
1a10: 4d414941 204d454e 544f4e49 04000000 MAIA MENTONI....
1a20: 1b000000 4d555353 41204b55 52414945 ....MUSSA KURAIE
1a30: 4e203232 20415054 20303300 04000000 N 22 APT 03.....
1a40: 04000000 04000000 0d000000 53414f20 ............SAO
1a50: 5041554c 4f000000 0c000000 30323432 PAULO.......0242
1a60: 32313330 06000000 53500000 04000000 2130....SP......
1a70: 04000000 01000000 f80d0000 fb0d0000 ................
1a80: fc0d0000 fe0d0000 fe0d0000 06000000 ................
1a90: 30300000 ed040000 05000000 20000000 00.......... ...
1aa0: 00000000 01000000 09000000 30303333 ............0033
1ab0: 34000000 0b000000 30313833 37303800 4.......0183708.
1ac0: 04000000 04000000 04000000 04000000 ................
1ad0: 8b020000 fc0d0000 0080e24f 51190100 ...........OQ...
1ae0: 00000000 fd0d0000 05000000 31000000 ............1...
1af0: 00000000 05000000 58000000 00000000 ........X.......
1b00: 02000000 08000000 30343430 07000000 ........0440....
1b10: 09000000 30303030 33000000 06000000 ....00003.......
1b20: 30310000 00000000 00000000 08000000 01..............
1b30: 00000300 08000000 30343430 04000000 ........0440....
Item 5 -- Length: 404 Offset: 6172 (0x181c) Flags: USED
XMIN: 679932028 CMIN: 0 XMAX: 679932028 CMAX|XVAC: 680494136
Block Id: 514708 linp Index: 5 Attributes: 71 Size: 36
infomask: 0x2983 (HASNULL|HASVARWIDTH|XMAX_SHARED_LOCK|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
t_bits: [0]: 0xff [1]: 0xff [2]: 0xff [3]: 0xfc
[4]: 0xff [5]: 0xbf [6]: 0x2f [7]: 0x70
[8]: 0x55
181c: 7cf08628 00000000 7cf08628 38848f28 |..(....|..(8..(
182c: 070094da 05004700 832924ff fffffcff ......G..)$.....
183c: bf2f7055 0c000000 31303935 37323433 ./pU....10957243
184c: 7f006201 11000000 53533030 34373736 ..b.....SS004776
185c: 30393042 54000000 04000000 00000000 090BT...........
186c: 04000000 17000000 43415353 494f2044 ........CASSIO D
187c: 45205341 4e542041 4e4e4100 04000000 E SANT ANNA.....
188c: 1c000000 41562053 54412049 4e455320 ....AV STA INES
189c: 38383120 41502031 32332042 04000000 881 AP 123 B....
18ac: 04000000 04000000 0d000000 53414f20 ............SAO
18bc: 5041554c 4f000000 0c000000 30323431 PAULO.......0241
18cc: 35303031 06000000 53500000 04000000 5001....SP......
18dc: 04000000 01000000 f80d0000 fb0d0000 ................
18ec: fc0d0000 fe0d0000 fe0d0000 06000000 ................
18fc: 30300000 cf050000 05000000 20000000 00.......... ...
190c: 00000000 01000000 09000000 30303333 ............0033
191c: 34000000 0b000000 30303030 38333700 4.......0000837.
192c: 04000000 04000000 04000000 04000000 ................
193c: dd020000 fc0d0000 0080e24f 51190100 ...........OQ...
194c: 00000000 fd0d0000 0a000000 39353435 ............9545
195c: 30310000 00000000 05000000 58000000 01..........X...
196c: 00000000 02000000 08000000 30343430 ............0440
197c: 07000000 09000000 30303030 33000000 ........00003...
198c: 06000000 30310000 00000000 00000000 ....01..........
199c: 08000000 00000300 08000000 30343430 ............0440
19ac: 04000000 ....
Item 6 -- Length: 416 Offset: 5756 (0x167c) Flags: USED
XMIN: 679932113 CMIN: 0 XMAX: 679932113 CMAX|XVAC: 680494136
Block Id: 514708 linp Index: 6 Attributes: 71 Size: 36
infomask: 0x2983 (HASNULL|HASVARWIDTH|XMAX_SHARED_LOCK|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
t_bits: [0]: 0xff [1]: 0xff [2]: 0xff [3]: 0xfc
[4]: 0xff [5]: 0xbf [6]: 0x2f [7]: 0x70
[8]: 0x55
167c: d1f08628 00000000 d1f08628 38848f28 ...(.......(8..(
168c: 070094da 06004700 832924ff fffffcff ......G..)$.....
169c: bf2f7055 0c000000 31303935 37383030 ./pU....10957800
16ac: 7f006201 11000000 53533030 34373831 ..b.....SS004781
16bc: 36363042 54000000 04000000 00000000 660BT...........
16cc: 04000000 23000000 53414e44 5241204d ....#...SANDRA M
16dc: 4152494e 41204341 44494d41 20444520 ARINA CADIMA DE
16ec: 414c4d45 49444100 04000000 1a000000 ALMEIDA.........
16fc: 41562053 54412049 4e455320 35303920 AV STA INES 509
170c: 41502031 31320000 04000000 04000000 AP 112..........
171c: 04000000 0d000000 53414f20 5041554c ........SAO PAUL
172c: 4f000000 0c000000 30323431 35303030 O.......02415000
173c: 06000000 53500000 04000000 04000000 ....SP..........
174c: 01000000 f80d0000 fb0d0000 fc0d0000 ................
175c: fe0d0000 fe0d0000 06000000 30300000 ............00..
176c: fc070000 05000000 20000000 00000000 ........ .......
177c: 01000000 09000000 30303333 34000000 ........00334...
178c: 0b000000 30303432 32353900 04000000 ....0042259.....
179c: 04000000 04000000 04000000 02080000 ................
17ac: fc0d0000 0080e24f 51190100 00000000 .......OQ.......
17bc: fd0d0000 08000000 31383831 00000000 ........1881....
17cc: 00000000 05000000 58000000 00000000 ........X.......
17dc: 02000000 08000000 30343430 07000000 ........0440....
17ec: 09000000 30303030 33000000 06000000 ....00003.......
17fc: 30310000 00000000 00000000 08000000 01..............
180c: 00000300 08000000 30343430 04000000 ........0440....
Item 7 -- Length: 416 Offset: 5340 (0x14dc) Flags: USED
XMIN: 679932224 CMIN: 0 XMAX: 679932224 CMAX|XVAC: 680494136
Block Id: 514708 linp Index: 7 Attributes: 71 Size: 36
infomask: 0x2983 (HASNULL|HASVARWIDTH|XMAX_SHARED_LOCK|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
t_bits: [0]: 0xff [1]: 0xff [2]: 0xff [3]: 0xfc
[4]: 0xff [5]: 0xbf [6]: 0x2f [7]: 0x70
[8]: 0x55
14dc: 40f18628 00000000 40f18628 38848f28 @..(....@..(8..(
14ec: 070094da 07004700 832924ff fffffcff ......G..)$.....
14fc: bf2f7055 0c000000 31303935 37313932 ./pU....10957192
150c: 7f006201 11000000 53533030 34373735 ..b.....SS004775
151c: 35383042 54000000 04000000 00000000 580BT...........
152c: 04000000 1a000000 4d415243 454c4f20 ........MARCELO
153c: 4d415449 41532050 45524549 52410000 MATIAS PEREIRA..
154c: 04000000 22000000 52204452 204c5549 ...."...R DR LUI
155c: 53204c55 53544f53 41205349 4c564120 S LUSTOSA SILVA
156c: 31373620 37310000 04000000 04000000 176 71..........
157c: 04000000 0d000000 53414f20 5041554c ........SAO PAUL
158c: 4f000000 0c000000 30323430 36303430 O.......02406040
159c: 06000000 53500000 04000000 04000000 ....SP..........
15ac: 01000000 f80d0000 fb0d0000 fc0d0000 ................
15bc: fe0d0000 fe0d0000 06000000 30300000 ............00..
15cc: 9c050000 05000000 20000000 00000000 ........ .......
15dc: 01000000 09000000 30303333 34000000 ........00334...
15ec: 0b000000 30303139 32393400 04000000 ....0019294.....
15fc: 04000000 04000000 04000000 d1020000 ................
160c: fc0d0000 0080e24f 51190100 00000000 .......OQ.......
161c: fd0d0000 0a000000 37393234 30310000 ........792401..
162c: 00000000 05000000 58000000 00000000 ........X.......
163c: 02000000 08000000 30343430 07000000 ........0440....
164c: 09000000 30303030 33000000 06000000 ....00003.......
165c: 30310000 00000000 00000000 08000000 01..............
166c: 00000300 08000000 30343430 04000000 ........0440....
Item 8 -- Length: 424 Offset: 4916 (0x1334) Flags: USED
XMIN: 679932278 CMIN: 0 XMAX: 679932278 CMAX|XVAC: 680494136
Block Id: 514708 linp Index: 8 Attributes: 71 Size: 36
infomask: 0x2983 (HASNULL|HASVARWIDTH|XMAX_SHARED_LOCK|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
t_bits: [0]: 0xff [1]: 0xff [2]: 0xff [3]: 0xfc
[4]: 0xff [5]: 0xbf [6]: 0x2f [7]: 0x70
[8]: 0x55
1334: 76f18628 00000000 76f18628 38848f28 v..(....v..(8..(
1344: 070094da 08004700 832924ff fffffcff ......G..)$.....
1354: bf2f7055 0c000000 31303935 36303732 ./pU....10956072
1364: 7f006201 11000000 53533030 34373634 ..b.....SS004764
1374: 33383342 54000000 04000000 00000000 383BT...........
1384: 04000000 23000000 4c55495a 20504155 ....#...LUIZ PAU
1394: 4c4f2052 45535449 46464520 44452043 LO RESTIFFE DE C
13a4: 41525641 4c484f00 04000000 23000000 ARVALHO.....#...
13b4: 52204452 20475549 4c484552 4d452043 R DR GUILHERME C
13c4: 52495354 4f46454c 20333835 20363100 RISTOFEL 385 61.
13d4: 04000000 04000000 04000000 0d000000 ................
13e4: 53414f20 5041554c 4f000000 0c000000 SAO PAULO.......
13f4: 30323430 36303130 06000000 53500000 02406010....SP..
1404: 04000000 04000000 01000000 f80d0000 ................
1414: fb0d0000 fc0d0000 fe0d0000 fe0d0000 ................
1424: 06000000 30300000 3c010000 05000000 ....00..<.......
1434: 20000000 00000000 01000000 09000000 ...............
1444: 30303333 34000000 0b000000 30323432 00334.......0242
1454: 35353300 04000000 04000000 04000000 553.............
1464: 04000000 70000000 fc0d0000 0080e24f ....p..........O
1474: 51190100 00000000 fd0d0000 07000000 Q...............
1484: 32303100 00000000 00000000 05000000 201.............
1494: 58000000 00000000 02000000 08000000 X...............
14a4: 30343430 07000000 09000000 30303030 0440........0000
14b4: 33000000 06000000 30310000 00000000 3.......01......
14c4: 00000000 08000000 00000300 08000000 ................
14d4: 30343430 04000000 0440....
Item 9 -- Length: 420 Offset: 4496 (0x1190) Flags: USED
XMIN: 679932305 CMIN: 0 XMAX: 679932305 CMAX|XVAC: 680494136
Block Id: 514708 linp Index: 9 Attributes: 71 Size: 36
infomask: 0x2983 (HASNULL|HASVARWIDTH|XMAX_SHARED_LOCK|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
t_bits: [0]: 0xff [1]: 0xff [2]: 0xff [3]: 0xfc
[4]: 0xff [5]: 0xbf [6]: 0x2f [7]: 0x70
[8]: 0x55
1190: 91f18628 00000000 91f18628 38848f28 ...(.......(8..(
11a0: 070094da 09004700 832924ff fffffcff ......G..)$.....
11b0: bf2f7055 0c000000 31303935 36323536 ./pU....10956256
11c0: 7f006201 11000000 53533030 34373636 ..b.....SS004766
11d0: 32323542 54000000 04000000 00000000 225BT...........
11e0: 04000000 1d000000 4d415249 41204845 ........MARIA HE
11f0: 4c454e41 2053204d 204f4c49 56454952 LENA S M OLIVEIR
1200: 41000000 04000000 22000000 52204652 A......."...R FR
1210: 414e4349 53434120 4a554c49 41203634 ANCISCA JULIA 64
1220: 34204150 544f2031 32310000 04000000 4 APTO 121......
1230: 04000000 04000000 0d000000 53414f20 ............SAO
1240: 5041554c 4f000000 0c000000 30323430 PAULO.......0240
1250: 33303131 06000000 53500000 04000000 3011....SP......
1260: 04000000 01000000 f80d0000 fb0d0000 ................
1270: fc0d0000 fe0d0000 fe0d0000 06000000 ................
1280: 30300000 f4010000 05000000 20000000 00.......... ...
1290: 00000000 01000000 09000000 30303333 ............0033
12a0: 34000000 0b000000 30343235 39373600 4.......0425976.
12b0: 04000000 04000000 04000000 04000000 ................
12c0: 9a000000 fc0d0000 0080e24f 51190100 ...........OQ...
12d0: 00000000 fd0d0000 0a000000 39353534 ............9554
12e0: 36310000 00000000 05000000 58000000 61..........X...
12f0: 00000000 02000000 08000000 30343430 ............0440
1300: 07000000 09000000 30303030 33000000 ........00003...
1310: 06000000 39320000 00000000 00000000 ....92..........
1320: 08000000 00000300 08000000 30343430 ............0440
1330: 04000000 ....
Item 10 -- Length: 388 Offset: 4108 (0x100c) Flags: USED
XMIN: 680433651 CMIN: 238 XMAX: 680433651 CMAX|XVAC: 680494136
Block Id: 514708 linp Index: 10 Attributes: 71 Size: 36
infomask: 0x2983 (HASNULL|HASVARWIDTH|XMAX_SHARED_LOCK|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
t_bits: [0]: 0xff [1]: 0xff [2]: 0xff [3]: 0xfc
[4]: 0xff [5]: 0xbf [6]: 0x2e [7]: 0x40
[8]: 0x75
100c: f3978e28 ee000000 f3978e28 38848f28 ...(.......(8..(
101c: 070094da 0a004700 832924ff fffffcff ......G..)$.....
102c: bf2e4075 0c000000 31303933 34353036 ..@u....10934506
103c: 9b010001 10000000 48533130 39333435 ........HS109345
104c: 30364543 04000000 00000000 04000000 06EC............
105c: 1d000000 4d415243 494f204a 4f534520 ....MARCIO JOSE
106c: 4445204d 454c4f20 53494c56 41000000 DE MELO SILVA...
107c: 04000000 16000000 52205045 44524f20 ........R PEDRO
108c: 50454c49 5a4f4e20 38340000 04000000 PELIZON 84......
109c: 04000000 0b000000 414c4941 4e434100 ........ALIANCA.
10ac: 12000000 52494245 4952414f 20504952 ....RIBEIRAO PIR
10bc: 45530000 0c000000 30393430 33343830 ES......09403480
10cc: 06000000 53500000 04000000 04000000 ....SP..........
10dc: 00000000 f70d0000 f70d0000 f70d0000 ................
10ec: fe0d0000 fe0d0000 06000000 30300000 ............00..
10fc: 00000000 05000000 43000000 00000000 ........C.......
110c: 01000000 0c000000 32303039 31303135 ........20091015
111c: 04000000 04000000 04000000 04000000 ................
112c: 04000000 00000000 f80d0000 000085d8 ................
113c: 00190100 00000000 f90d0000 04000000 ................
114c: 00000000 00000000 05000000 58000100 ............X...
115c: 00000000 08000000 30343037 32000000 ........04072...
116c: 00000000 00000000 08000000 00000300 ................
117c: 08000000 30343037 08000000 30343037 ....0407....0407
118c: 04000000 ....
Item 11 -- Length: 440 Offset: 3668 (0x0e54) Flags: USED
XMIN: 2 CMIN: 0 XMAX: 0 CMAX|XVAC: 680494136
Block Id: 514708 linp Index: 11 Attributes: 71 Size: 36
infomask: 0x2983 (HASNULL|HASVARWIDTH|XMAX_SHARED_LOCK|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
t_bits: [0]: 0xff [1]: 0xff [2]: 0xff [3]: 0xfc
[4]: 0xff [5]: 0xbf [6]: 0x2f [7]: 0xc0
[8]: 0x7d
0e54: 02000000 00000000 00000000 38848f28 ............8..(
0e64: 070094da 0b004700 832924ff fffffcff ......G..)$.....
0e74: bf2fc07d 0c000000 31303831 34333438 ./.}....10814348
0e84: 9b017707 15000000 53413230 30393030 ..w.....SA200900
0e94: 30343735 36373642 41000000 04000000 0475676BA.......
0ea4: 00000000 04000000 15000000 45444e41 ............EDNA
0eb4: 2053494c 5641204d 41434544 4f000000 SILVA MACEDO...
0ec4: 04000000 25000000 52554120 414c4558 ....%...RUA ALEX
0ed4: 414e4452 4520424f 4e494349 4f203030 ANDRE BONICIO 00
0ee4: 30363138 20415032 33000000 04000000 0618 AP23.......
0ef4: 04000000 0e000000 414c5645 53204449 ........ALVES DI
0f04: 41530000 0f000000 53414f20 42204341 AS......SAO B CA
0f14: 4d504f00 0c000000 30393835 30343530 MPO.....09850450
0f24: 06000000 53500000 04000000 0c000000 ....SP..........
0f34: 30303030 30303030 01000000 e30d0000 00000000........
0f44: e60d0000 e70d0000 e80d0000 e90d0000 ................
0f54: 06000000 30300000 01000000 05000000 ....00..........
0f64: 20000000 00000000 01000000 0c000000 ...............
0f74: 32303039 32353039 0f000000 30323231 20092509....0221
0f84: 31333033 38353900 04000000 04000000 1303859.........
0f94: 04000000 04000000 55560000 e70d0000 ........UV......
0fa4: 00a037dd aa170100 00000000 e80d0000 ..7.............
0fb4: 04000000 00000200 00000000 05000000 ................
0fc4: 58000000 00000000 02000000 06000000 X...............
0fd4: 30307e00 00000000 008a777c e1170100 00~.......w|....
0fe4: 00000000 08000000 00000300 00e04390 ..............C.
0ff4: 23180100 08000000 30333431 08000000 #.......0341....
1004: 30333431 04000000 0341....
Item 12 -- Length: 406 Offset: 3260 (0x0cbc) Flags: USED
XMIN: 679548129 CMIN: 9 XMAX: 679548129 CMAX|XVAC: 680494136
Block Id: 514708 linp Index: 12 Attributes: 71 Size: 36
infomask: 0x2983 (HASNULL|HASVARWIDTH|XMAX_SHARED_LOCK|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
t_bits: [0]: 0xff [1]: 0xff [2]: 0xff [3]: 0xfc
[4]: 0x3f [5]: 0xbd [6]: 0x2f [7]: 0x40
[8]: 0x55
0cbc: e1148128 09000000 e1148128 38848f28 ...(.......(8..(
0ccc: 070094da 0c004700 832924ff fffffc3f ......G..)$....?
0cdc: bd2f4055 0c000000 31303937 34383038 ./@U....10974808
0cec: 83007001 18000000 47433033 30323936 ..p.....GC030296
0cfc: 39363030 30313831 31383334 04000000 960001811834....
0d0c: 00000000 04000000 1f000000 4a414e49 ............JANI
0d1c: 434c4155 44494f20 42495350 4f20444f CLAUDIO BISPO DO
0d2c: 5320414e 4a4f5300 04000000 16000000 S ANJOS.........
0d3c: 52554120 20205649 54414c20 42524153 RUA VITAL BRAS
0d4c: 494c0000 06000000 36330000 04000000 IL......63......
0d5c: 0f000000 53414e54 41204c55 5a494100 ....SANTA LUZIA.
0d6c: 0d000000 42415252 45495241 53000000 ....BARREIRAS...
0d7c: 0c000000 34373830 34353230 06000000 ....47804520....
0d8c: 42410000 04000000 12000000 30303030 BA..........0000
0d9c: 30303030 30303030 30300100 fc0d0000 0000000000......
0dac: fc0d0000 fd0d0000 fe0d0000 fe0d0000 ................
0dbc: 06000000 30300000 66000000 05000000 ....00..f.......
0dcc: 20000000 00000000 04000000 0c000000 ...............
0ddc: 32303039 31303230 04000000 04000000 20091020........
0dec: 04000000 04000000 04000000 00740000 .............t..
0dfc: 00000000 04000000 00000000 00000000 ................
0e0c: 05000000 58000000 00000000 02000000 ....X...........
0e1c: 08000000 30313533 5d000000 00000000 ....0153].......
0e2c: 00000000 08000000 00000300 08000000 ................
0e3c: 30313533 12000000 30303030 30303030 0153....00000000
0e4c: 30303030 3030 000000
Item 13 -- Length: 410 Offset: 2848 (0x0b20) Flags: USED
XMIN: 680018511 CMIN: 0 XMAX: 680018512 CMAX|XVAC: 680494136
Block Id: 514708 linp Index: 13 Attributes: 71 Size: 36
infomask: 0x2983 (HASNULL|HASVARWIDTH|XMAX_SHARED_LOCK|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
t_bits: [0]: 0xff [1]: 0xff [2]: 0xff [3]: 0xfc
[4]: 0x3f [5]: 0xbd [6]: 0x2f [7]: 0xc0
[8]: 0x5d
0b20: 4f428828 00000000 50428828 38848f28 OB.(....PB.(8..(
0b30: 070094da 0d004700 832924ff fffffc3f ......G..)$....?
0b40: bd2fc05d 0c000000 31303937 34383531 ./.]....10974851
0b50: 83007001 18000000 47433033 30303930 ..p.....GC030090
0b60: 34343030 30313830 39373133 04000000 440001809713....
0b70: 00000000 04000000 1c000000 57414e49 ............WANI
0b80: 4c534f4e 2053494c 56412044 41532044 LSON SILVA DAS D
0b90: 4f524553 04000000 1b000000 4156454e ORES........AVEN
0ba0: 49444120 20205345 4e41444f 52204c45 IDA SENADOR LE
0bb0: 4d4f5300 05000000 30000000 04000000 MOS.....0.......
0bc0: 0c000000 554d4152 495a414c 09000000 ....UMARIZAL....
0bd0: 42454c45 4d000000 0c000000 36363035 BELEM.......6605
0be0: 30303030 06000000 50410000 04000000 0000....PA......
0bf0: 12000000 30303030 30303030 30303030 ....000000000000
0c00: 30300100 fc0d0000 fc0d0000 fd0d0000 00..............
0c10: fe0d0000 fe0d0000 06000000 30300000 ............00..
0c20: 67000000 05000000 53000000 00000000 g.......S.......
0c30: 00000000 0c000000 32303039 31303230 ........20091020
0c40: 04000000 04000000 04000000 04000000 ................
0c50: 04000000 54230000 00000000 04000000 ....T#..........
0c60: 00000000 00000000 05000000 58000000 ............X...
0c70: 00000000 02000600 06000000 30300200 ............00..
0c80: 00000000 005ed8dd 85190100 01000000 .....^..........
0c90: 08000000 00000300 0040918b 79190100 .........@..y...
0ca0: 08000000 30313533 12000000 30303030 ....0153....0000
0cb0: 30303030 30303030 3030 0000000000
Item 14 -- Length: 484 Offset: 2364 (0x093c) Flags: USED
XMIN: 679843486 CMIN: 127 XMAX: 0 CMAX|XVAC: 680494136
Block Id: 514708 linp Index: 14 Attributes: 71 Size: 36
infomask: 0x2903 (HASNULL|HASVARWIDTH|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
t_bits: [0]: 0xff [1]: 0xff [2]: 0xff [3]: 0xfc
[4]: 0xff [5]: 0xbf [6]: 0x2f [7]: 0xfe
[8]: 0x55
093c: 9e968528 7f000000 00000000 38848f28 ...(........8..(
094c: 070094da 0e004700 032924ff fffffcff ......G..)$.....
095c: bf2ffe55 0c000000 31303932 34313030 ./.U....10924100
096c: 9b011f07 0f000000 31383033 38373131 ........18038711
097c: 36425200 04000000 00000000 04000000 6BR.............
098c: 0f000000 494f4c49 54412052 4f534100 ....IOLITA ROSA.
099c: 04000000 22000000 52204645 4c495045 ...."...R FELIPE
09ac: 20534348 4d494454 20333736 2c204345 SCHMIDT 376, CE
09bc: 4e54524f 202d0000 04000000 12000000 NTRO -..........
09cc: 30313334 3a204345 4e54524f 20460000 0134: CENTRO F..
09dc: 10000000 4c4f5249 414e4f50 4f4c4953 ....LORIANOPOLIS
09ec: 11000000 464c4f52 49414e4f 504f4c49 ....FLORIANOPOLI
09fc: 53000000 0c000000 38383133 31303031 S.......88131001
0a0c: 06000000 53430000 04000000 0f000000 ....SC..........
0a1c: 30343833 33343235 34303800 01000000 04833425408.....
0a2c: f60d0000 f60d0000 f60d0000 f80d0000 ................
0a3c: fc0d0000 06000000 30300000 6f030000 ........00..o...
0a4c: 05000000 43000000 00000000 01000000 ....C...........
0a5c: 09000000 30333532 32000000 04000000 ....03522.......
0a6c: 04000000 04000000 04000000 04000000 ................
0a7c: 00000000 f60d0000 0040d69c d8180100 .........@......
0a8c: 00000000 f70d0000 04000000 00000000 ................
0a9c: 00000000 05000000 58000000 00000000 ........X.......
0aac: 02000000 08000000 30303038 34000000 ........00084...
0abc: 14000000 30303030 30303030 30303030 ....000000000000
0acc: 38313236 04000000 05000000 4d000000 8126........M...
0adc: 07000000 32303600 17000000 474f4c44 ....206.....GOLD
0aec: 43415244 204d4153 54455243 41524400 CARD MASTERCARD.
0afc: 00000000 00ffced2 80190100 01000000 ................
0b0c: 08000000 00000300 08000000 30303038 ............0008
0b1c: 04000000 ....
Item 15 -- Length: 410 Offset: 1952 (0x07a0) Flags: USED
XMIN: 679548129 CMIN: 74 XMAX: 679548129 CMAX|XVAC: 680494136
Block Id: 514708 linp Index: 15 Attributes: 71 Size: 36
infomask: 0x2983 (HASNULL|HASVARWIDTH|XMAX_SHARED_LOCK|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
t_bits: [0]: 0xff [1]: 0xff [2]: 0xff [3]: 0xfc
[4]: 0x3f [5]: 0xbd [6]: 0x2f [7]: 0x40
[8]: 0x55
07a0: e1148128 4a000000 e1148128 38848f28 ...(J......(8..(
07b0: 070094da 0f004700 832924ff fffffc3f ......G..)$....?
07c0: bd2f4055 0c000000 31303937 34393936 ./@U....10974996
07d0: 83007001 18000000 47433033 30313730 ..p.....GC030170
07e0: 36353030 30313830 37303534 04000000 650001807054....
07f0: 00000000 04000000 19000000 4c554341 ............LUCA
0800: 53204d41 54455553 20444120 53494c56 S MATEUS DA SILV
0810: 41000000 04000000 17000000 52554120 A...........RUA
0820: 20204f4c 4956494f 2046454e 41544800 OLIVIO FENATH.
0830: 07000000 31343900 04000000 19000000 ....149.........
0840: 44495354 5249544f 20494e44 55535452 DISTRITO INDUSTR
0850: 49414c20 49000000 0a000000 4652414e IAL I.......FRAN
0860: 43410000 0c000000 31343430 36303733 CA......14406073
0870: 06000000 53500000 04000000 12000000 ....SP..........
0880: 30303030 30303030 30303030 30300100 00000000000000..
0890: fc0d0000 fc0d0000 fd0d0000 fe0d0000 ................
08a0: fe0d0000 06000000 30300000 59000000 ........00..Y...
08b0: 05000000 20000000 00000000 04000000 .... ...........
08c0: 0c000000 32303039 31303230 04000000 ....20091020....
08d0: 04000000 04000000 04000000 04000000 ................
08e0: a9420000 00000000 04000000 00000000 .B..............
08f0: 00000000 05000000 58000000 00000000 ........X.......
0900: 02000000 08000000 30313533 5d000000 ........0153]...
0910: 00000000 00000000 08000000 00000300 ................
0920: 08000000 30313533 12000000 30303030 ....0153....0000
0930: 30303030 30303030 3030 0000000000
Item 16 -- Length: 406 Offset: 1544 (0x0608) Flags: USED
XMIN: 679548129 CMIN: 99 XMAX: 679548129 CMAX|XVAC: 680494136
Block Id: 514708 linp Index: 16 Attributes: 71 Size: 36
infomask: 0x2983 (HASNULL|HASVARWIDTH|XMAX_SHARED_LOCK|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
t_bits: [0]: 0xff [1]: 0xff [2]: 0xff [3]: 0xfc
[4]: 0x3f [5]: 0xbd [6]: 0x2f [7]: 0x40
[8]: 0x55
0608: e1148128 63000000 e1148128 38848f28 ...(c......(8..(
0618: 070094da 10004700 832924ff fffffc3f ......G..)$....?
0628: bd2f4055 0c000000 31303937 35303031 ./@U....10975001
0638: 83007001 18000000 47433033 30313730 ..p.....GC030170
0648: 36353030 30313830 37303539 04000000 650001807059....
0658: 00000000 04000000 18000000 5041554c ............PAUL
0668: 4f204345 53415220 44412053 494c5641 O CESAR DA SILVA
0678: 04000000 17000000 52554120 20204f4c ........RUA OL
0688: 4956494f 2046454e 41544800 07000000 IVIO FENATH.....
0698: 31343900 04000000 19000000 44495354 149.........DIST
06a8: 5249544f 20494e44 55535452 49414c20 RITO INDUSTRIAL
06b8: 49000000 0a000000 4652414e 43410000 I.......FRANCA..
06c8: 0c000000 31343430 36303733 06000000 ....14406073....
06d8: 53500000 04000000 12000000 30303030 SP..........0000
06e8: 30303030 30303030 30300100 fc0d0000 0000000000......
06f8: fc0d0000 fd0d0000 fe0d0000 fe0d0000 ................
0708: 06000000 30300000 54000000 05000000 ....00..T.......
0718: 20000000 00000000 04000000 0c000000 ...............
0728: 32303039 31303230 04000000 04000000 20091020........
0738: 04000000 04000000 04000000 a9420000 .............B..
0748: 00000000 04000000 00000000 00000000 ................
0758: 05000000 58000000 00000000 02000000 ....X...........
0768: 08000000 30313533 5d000000 00000000 ....0153].......
0778: 00000000 08000000 00000300 08000000 ................
0788: 30313533 12000000 30303030 30303030 0153....00000000
0798: 30303030 3030 000000
Item 17 -- Length: 0 Offset: 672 (0x02a0) Flags: 0x00
Item 18 -- Length: 0 Offset: 232 (0x00e8) Flags: 0x00
*** End of Requested Range Encountered. Last Block Read: 121492 ***
2009/10/23 João Eugenio Marynowski <joaoem@gmail.com>
I thought this would solve my problems but not yet ...
the block that I found is not presenting error...
find_bad_block
----------------
(514708,16)
(1 registro)
blockId / blocks_per_chunk = 514708 / 131072 = 3,9269104
base/21058/21271.3
chunk_block_id = block_id % blocks_per_chunk = 514708 % 131072 = 121492
is attached the result of pg_filedump -if -R 121492
/var/lib/postgresql/8.2/main/base/21058/21271.3
Even then I filled the block with zero
But when I run again the find_bad_block it show one block before, ctid
514707, and then, 514706 and I stop...
Any suggestion and explication?--
João Eugenio
I fond manually a record with error (462813,13) and zeroed it and the BD
work ok only with 18 register lost that will be recovery from old backup.
The function find_bad_block (
http://archives.postgresql.org/pgsql-general/2007-07/msg00506.php )
don't work for me, anybody know why?
Thanks for now!
--
João Eugenio Marynowski
On Thu, Oct 22, 2009 at 7:16 PM, Joshua D. Drake <jd@commandprompt.com>wrote:
On Thu, 2009-10-22 at 14:28 -0200, João Eugenio Marynowski wrote:
Hi
Repair? Not likely. Get past? Maybe.
I don't know how valuable your data is, but I've performed data recovery on
tens of PG databases suffering from both hardware and software corruption on
versions 7.0 through 8.3. My rate is $300-600 USD/hour depending on the
database/table size and the extent of the corruption.
If you're just trying to save what's not corrupted, there's quite a few
examples online.
--
Jonah H. Harris
On Mon, 2009-10-26 at 09:14 -0400, Jonah H. Harris wrote:
On Thu, Oct 22, 2009 at 7:16 PM, Joshua D. Drake
<jd@commandprompt.com> wrote:
On Thu, 2009-10-22 at 14:28 -0200, João Eugenio Marynowski
wrote:Hi
Repair? Not likely. Get past? Maybe.
I don't know how valuable your data is, but I've performed data
recovery on tens of PG databases suffering from both hardware and
software corruption on versions 7.0 through 8.3. My rate is $300-600
USD/hour depending on the database/table size and the extent of the
corruption.If you're just trying to save what's not corrupted, there's quite a
few examples online.
Jonah,
This reply is wholly inappropriate for a Pg list. We are here to help
people. If you have a consultancy, please feel free to list that but any
discussion of rates is just plain rude. Please use better discretion in
the future.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
If the world pushes look it in the eye and GRR. Then push back harder. - Salamander
On Mon, Oct 26, 2009 at 12:55 PM, Joshua D. Drake <jd@commandprompt.com>wrote:
This reply is wholly inappropriate for a Pg list. We are here to help
people. If you have a consultancy, please feel free to list that but any
discussion of rates is just plain rude. Please use better discretion in
the future.
Perhaps. Though, I only posted because you made it sound somewhat
impossible and because I only know of a few ppl in the PG community that
offer it and/or have done is successfully. Maybe letting people know there
are options, other than being screwed, is wrong... my bad :-)
--
Jonah H. Harris, Senior DBA
myYearbook.com
"Jonah H. Harris" <jonah.harris@gmail.com> wrote:
Joshua D. Drake <jd@commandprompt.com>wrote:
This reply is wholly inappropriate for a Pg list. We are here to
help people. If you have a consultancy, please feel free to list
that but any discussion of rates is just plain rude. Please use
better discretion in the future.Perhaps. Though, I only posted because you made it sound somewhat
impossible and because I only know of a few ppl in the PG community
that offer it and/or have done is successfully. Maybe letting
people know there are options, other than being screwed, is wrong...
my bad :-)
That really sounded disingenuous.
It would probably be appropriate to point out that there are numerous
sources of professional support for PostgreSQL.
http://www.postgresql.org/support/professional_support
As someone who ran a consulting business for 25 years and has been on
both sides of the calls for assistance on recovery from database
problems (and currently not in that business, so I have no ax to grind
here), that post was inappropriate for the list. I don't think anyone
would fault you (or anyone else) for making a polite offer of
assistance off-list, as long as you quietly bow out if they're not
interested; but anybody who is a professional in this business should
know better than to post that to the list. There are several reasons,
and they should be obvious.
-Kevin