Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
Percona Discussion
Home
+ new post
About this group
Join this group
innodb recovery tool - page parser and deleted rows
Options
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
   7 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Tuyra  
View profile  
 More options Oct 31 2012, 7:14 am
From: Tuyra <harun....@gmail.com>
Date: Wed, 31 Oct 2012 04:14:16 -0700 (PDT)
Local: Wed, Oct 31 2012 7:14 am
Subject: innodb recovery tool - page parser and deleted rows
Print | Individual message | Show original | Report this message | Find messages by this author

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.


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Tuyra  
View profile  
 More options Oct 31 2012, 9:17 am
From: Tuyra <harun....@gmail.com>
Date: Wed, 31 Oct 2012 06:17:59 -0700 (PDT)
Local: Wed, Oct 31 2012 9:17 am
Subject: Re: innodb recovery tool - page parser and deleted rows
Print | Individual message | Show original | Report this message | Find messages by this author

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ı:


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Aleksandr Kuzminsky  
View profile  
 More options Oct 31 2012, 12:48 pm
From: Aleksandr Kuzminsky <aleksandr.kuzmin...@percona.com>
Date: Wed, 31 Oct 2012 18:48:20 +0200
Local: Wed, Oct 31 2012 12:48 pm
Subject: Re: [percona-group] Re: innodb recovery tool - page parser and deleted rows
Print | Individual message | Show original | Report this message | Find messages by this author
-----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-----


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Tuyra  
View profile  
 More options Oct 31 2012, 2:41 pm
From: Tuyra <harun....@gmail.com>
Date: Wed, 31 Oct 2012 11:41:20 -0700 (PDT)
Local: Wed, Oct 31 2012 2:41 pm
Subject: Re: [percona-group] Re: innodb recovery tool - page parser and deleted rows
Print | Individual message | Show original | Report this message | Find messages by this author

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ı:


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Aleksandr Kuzminsky  
View profile  
 More options Oct 31 2012, 3:45 pm
From: Aleksandr Kuzminsky <aleksandr.kuzmin...@percona.com>
Date: Wed, 31 Oct 2012 21:45:36 +0200
Local: Wed, Oct 31 2012 3:45 pm
Subject: Re: [percona-group] Re: innodb recovery tool - page parser and deleted rows
Print | Individual message | Show original | Report this message | Find messages by this author
-----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-----


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Tuyra  
View profile  
 More options Oct 31 2012, 4:15 pm
From: Tuyra <harun....@gmail.com>
Date: Wed, 31 Oct 2012 13:15:54 -0700 (PDT)
Local: Wed, Oct 31 2012 4:15 pm
Subject: Re: [percona-group] Re: innodb recovery tool - page parser and deleted rows
Print | Individual message | Show original | Report this message | Find messages by this author

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ı:


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Tuyra  
View profile  
 More options Oct 31 2012, 4:40 pm
From: Tuyra <harun....@gmail.com>
Date: Wed, 31 Oct 2012 13:40:42 -0700 (PDT)
Local: Wed, Oct 31 2012 4:40 pm
Subject: Re: [percona-group] Re: innodb recovery tool - page parser and deleted rows
Print | Individual message | Show original | Report this message | Find messages by this author

imported succesfly, everything is well.

31 Ekim 2012 Çarşamba 22:15:54 UTC+2 tarihinde Tuyra yazdı:


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2013 Google