Re: innodb recovery tool - page parser and deleted rows

402 views
Skip to first unread message

Tuyra

unread,
Oct 31, 2012, 9:17:59 AM10/31/12
to percona-d...@googlegroups.com
I find needed page files by in-file search. i can see the rows which i have been deleted. 

but constraints_parser can't parse all of them, only some of them. what causes it, any idea?



31 Ekim 2012 Çarşamba 13:14:16 UTC+2 tarihinde Tuyra yazdı:

Hello,

i installed recovery tool and everything is fine. when i run the page_parser it parses all the data, everything is well.

i check the index id's with innodb_table_monitor, which table i had run "delete from table" query. the index id is 0-145 and there is no parsed files.

i can see my data in ibdata1 file when i open it with hex editor. but parser didn't parse this rows.

Where am I going wrong?

Thanks.

Aleksandr Kuzminsky

unread,
Oct 31, 2012, 12:48:20 PM10/31/12
to percona-d...@googlegroups.com
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,


> I find needed page files by in-file search. i can see the rows
> which i have been deleted.
>
> but constraints_parser can't parse all of them, only some of them.
> what causes it, any idea?
>


Please use the latest revision from BZR tree, there was a bug in 0.5



- --
Skype: aleksandr.kuzminsky
Mobile: +380 97 331 12 35


Percona training coming soon to
San Jose, Minneapolis, Milan, Miami, Munich, Las Vegas, Barcelona
http://www.percona.com/training/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.17 (MingW32)
Comment: Using GnuPG with Mozilla - http://www.enigmail.net/

iEYEARECAAYFAlCRVlQACgkQQ6p+ZxjCGwX2TwCgmF0pp+VOablgXgZIdIjN2GG+
mJIAn2nGcwSEyqZzcAz3qqGdhukN6bRI
=dCHo
-----END PGP SIGNATURE-----

Tuyra

unread,
Oct 31, 2012, 2:41:20 PM10/31/12
to percona-d...@googlegroups.com
Hello, thanks for reply. 

I installed the latest bzr tree with fress installion. It parsed ibdata file to pages excellenly. But constraints_parser didn't parsed any rows. I copied the parsed pages and parsed rows on the 0.5 version, it parsed but not all rows again. 

Any ideas, thanks? 

31 Ekim 2012 Çarşamba 18:48:24 UTC+2 tarihinde Aleksandr Kuzminsky yazdı:

Aleksandr Kuzminsky

unread,
Oct 31, 2012, 3:45:36 PM10/31/12
to percona-d...@googlegroups.com
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Tuyra,


>
> I installed the latest bzr tree with fress installion. It parsed
> ibdata file to pages excellenly. But constraints_parser didn't
> parsed any rows. I copied the parsed pages and parsed rows on the
> 0.5 version, it parsed but not all rows again.
>
> Any ideas, thanks?


Do you specify -D option?
Show exact command you run and debug output.
For sake of simplicity try to fetch records from a single page only.

Aleks


- --
Skype: aleksandr.kuzminsky
Mobile: +380 97 331 12 35


Percona training coming soon to
San Jose, Minneapolis, Milan, Miami, Munich, Las Vegas, Barcelona
http://www.percona.com/training/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.17 (MingW32)
Comment: Using GnuPG with Mozilla - http://www.enigmail.net/

iEYEARECAAYFAlCRf+AACgkQQ6p+ZxjCGwWylgCgiueRNUYWZuuTU68J0E4h/JD8
8M0AnjaWwNxcfy8dkd78jHaSHg6d5rxD
=wx9O
-----END PGP SIGNATURE-----

Tuyra

unread,
Oct 31, 2012, 4:15:54 PM10/31/12
to percona-d...@googlegroups.com
on the version 5.0, with -D  option or without it, it was parsing same data. but with 6.0 it worked perfect and parsed all data. 

i was trying to write regex patterns with java to parse page files. 

i'm trying to import database now.

thank you percona and all staff. 


31 Ekim 2012 Çarşamba 21:45:40 UTC+2 tarihinde Aleksandr Kuzminsky yazdı:

Tuyra

unread,
Oct 31, 2012, 4:40:42 PM10/31/12
to percona-d...@googlegroups.com
imported succesfly, everything is well. 

31 Ekim 2012 Çarşamba 22:15:54 UTC+2 tarihinde Tuyra yazdı:
Reply all
Reply to author
Forward
0 new messages