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: Assertion failure during running of xtrabackup
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
   8 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
 
Johann Vincent Paul Tagle  
View profile  
 More options Sep 19 2011, 4:36 am
From: Johann Vincent Paul Tagle <johannta...@gmail.com>
Date: Mon, 19 Sep 2011 16:36:50 +0800
Local: Mon, Sep 19 2011 4:36 am
Subject: InnoDB: Assertion failure during running of xtrabackup
Print | Individual message | Show original | Report this message | Find messages by this author

We have Percona Server 5.1.57-rel12.8-log and we do full and incremental
backups on it using xtrabackup.  The command we use for full backup is:

innobackupex-1.5.1 --slave-info
    \
  --defaults-file=/etc/my.cnf                                 \
  --user=root                                                             \
  --password=password                              \
  --socket=/var/run/mysqld/mysqld.sock
\
  --safe-slave-backup                                                     \
  --no-timestamp                                                          \
  2> /backup/xtrabackups/xtrabackup-timestamped-filename.log        \
  /backup/xtrabackups/timestamped-directory

It's been running smoothly for I think 2 months now.  But last week I
started getting errors like the one below.

>> log scanned up to (291781603905)
>> log scanned up to (291781611845)
>> log scanned up to (291781620026)
>> log scanned up to (291781629903)

InnoDB: Error: tablespace id is 710 in the data dictionary
InnoDB: but in file ./vbulletin/threadviews.ibd it is 712!
110918 18:40:39  InnoDB: Assertion failure in thread 139974588552960 in file
fil/fil0fil.c line 740
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
Aborted
innobackupex-1.5.1: Error: ibbackup child process has died at
/usr/bin/innobackupex-1.5.1 line 336.

Last week it gets fixed after I restart the database then rerun the backup
script.  But it keeps popping up again.  The table threadviews is actually
empty, so I've tried dropping and recreating, but it doesn't fix it.

Any ideas?  Thanks

Johann


 
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.
Alexey Kopytov  
View profile  
 More options Sep 19 2011, 6:08 am
From: Alexey Kopytov <alexey.kopy...@percona.com>
Date: Mon, 19 Sep 2011 14:08:55 +0400
Local: Mon, Sep 19 2011 6:08 am
Subject: Re: InnoDB: Assertion failure during running of xtrabackup
Print | Individual message | Show original | Report this message | Find messages by this author
Hi,

On 19.09.11 12:36, Johann Vincent Paul Tagle wrote:

It's https://bugs.launchpad.net/percona-xtrabackup/+bug/722638 which was
fixed last week. The fix is going to be released in XtraBackup 1.6.3.

Best regards,
Alexey.


 
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.
Johann Vincent Paul Tagle  
View profile  
 More options Sep 19 2011, 7:22 am
From: Johann Vincent Paul Tagle <johannta...@gmail.com>
Date: Mon, 19 Sep 2011 19:22:24 +0800
Local: Mon, Sep 19 2011 7:22 am
Subject: Re: InnoDB: Assertion failure during running of xtrabackup
Print | Individual message | Show original | Report this message | Find messages by this author

Awesome work as usual.  Thanks!

On Monday, September 19, 2011, Alexey Kopytov <alexey.kopy...@percona.com>
wrote:

http://dev.mysql.com/doc/refman/5.1/en/forcing-innodb-recovery.html
>> InnoDB: about forcing recovery.
>> Aborted
>> innobackupex-1.5.1: Error: ibbackup child process has died at
>> /usr/bin/innobackupex-1.5.1 line 336.

> It's https://bugs.launchpad.net/percona-xtrabackup/+bug/722638 which was
> fixed last week. The fix is going to be released in XtraBackup 1.6.3.

> Best regards,
> Alexey.

> --
> You received this message because you are subscribed to the Google Groups

"Percona Discussion" group.
> To post to this group, send email to percona-discussion@googlegroups.com.
> To unsubscribe from this group, send email to

percona-discussion+unsubscribe@googlegroups.com.
> For more options, visit this group at

http://groups.google.com/group/percona-discussion?hl=en.


 
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.
Johann Vincent Paul Tagle  
View profile  
 More options Sep 19 2011, 8:53 am
From: Johann Vincent Paul Tagle <johannta...@gmail.com>
Date: Mon, 19 Sep 2011 20:53:53 +0800
Local: Mon, Sep 19 2011 8:53 am
Subject: Re: InnoDB: Assertion failure during running of xtrabackup
Print | Individual message | Show original | Report this message | Find messages by this author

I'm sorry.  This is me being silly - how do I get the patch?  I'm new to
Launchpad and can't seem to find my way around.

Thanks

Johann

On Mon, Sep 19, 2011 at 7:22 PM, Johann Vincent Paul Tagle <


 
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.
Johann Vincent Paul Tagle  
View profile  
 More options Sep 19 2011, 9:42 am
From: Johann Vincent Paul Tagle <johannta...@gmail.com>
Date: Mon, 19 Sep 2011 21:42:06 +0800
Local: Mon, Sep 19 2011 9:42 am
Subject: Re: InnoDB: Assertion failure during running of xtrabackup
Print | Individual message | Show original | Report this message | Find messages by this author

Okay think I got it.  Installed Bazaar VCS then did:

bzr branch lp:percona-xtrabackup/1.6 percona-xtrabackup-1.6

On Mon, Sep 19, 2011 at 8:53 PM, Johann Vincent Paul Tagle <


 
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.
Johann Vincent Paul Tagle  
View profile  
 More options Sep 19 2011, 8:18 pm
From: Johann Vincent Paul Tagle <johannta...@gmail.com>
Date: Tue, 20 Sep 2011 08:18:38 +0800
Local: Mon, Sep 19 2011 8:18 pm
Subject: Re: InnoDB: Assertion failure during running of xtrabackup
Print | Individual message | Show original | Report this message | Find messages by this author

Okay, so I followed the build instructions that came with the code, uploaded
the created innobackupex, soft-linked innobackupex-1.5.1 to it, then tried
to do my backup - still same error.

Attached the file I created - just added the following lines to it to cover
a previous issue:
mysql_send "set interactive_timeout=28800;
mysql_send "set wait_timeout=28800;

Any ideas?  Thanks.

Johann

On Mon, Sep 19, 2011 at 9:42 PM, Johann Vincent Paul Tagle <

  innobackupex
121K Download

 
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.
Alexey Kopytov  
View profile  
 More options Sep 20 2011, 12:08 am
From: Alexey Kopytov <alexey.kopy...@percona.com>
Date: Tue, 20 Sep 2011 08:08:18 +0400
Local: Tues, Sep 20 2011 12:08 am
Subject: Re: InnoDB: Assertion failure during running of xtrabackup
Print | Individual message | Show original | Report this message | Find messages by this author
Johann,

On 20.09.11 4:18, Johann Vincent Paul Tagle wrote:

> Okay, so I followed the build instructions that came with the code, uploaded
> the created innobackupex, soft-linked innobackupex-1.5.1 to it, then tried
> to do my backup - still same error.

You also have to make sure that xtrabackup binaries are installed and
used by the innobackupex script (i.e. they are in PATH). There is
information on where the binaries can be found at the bottom of BUILD.txt.

Best regards,
Alexey.


 
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.
Johann Vincent Paul Tagle  
View profile  
 More options Sep 20 2011, 9:58 am
From: Johann Vincent Paul Tagle <johannta...@gmail.com>
Date: Tue, 20 Sep 2011 21:58:39 +0800
Local: Tues, Sep 20 2011 9:58 am
Subject: Re: InnoDB: Assertion failure during running of xtrabackup
Print | Individual message | Show original | Report this message | Find messages by this author

Ah, it's another case of PEBKAC-NFI* for me... my bad.  Thanks!

Johann

*Problem Exists Between Keyboard And Chair - Not Following Instructions :-)

On Tue, Sep 20, 2011 at 12:08 PM, Alexey Kopytov <alexey.kopy...@percona.com


 
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