Hi Alexey,

I believe this is the part you're interested in: the full log is 4000 lines
long, but the only instance of the string "failed" appears about 80 lines
in. Here are thee first 85 lines of the log:

<begin_partial_log_dump>

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona Inc 2009-2012.  All Rights Reserved.

This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

121003 18:48:31  innobackupex: Starting mysql with options:  
--password=xxxxxxxx --user='jbegg' --unbuffered --
121003 18:48:31  innobackupex: Connected to database with mysql child
process (pid=24095)
121003 18:48:37  innobackupex: Connection to database server closed
IMPORTANT: Please check that the backup run completes successfully.
           At the end of a successful backup run innobackupex
           prints "completed OK!".

innobackupex: Using mysql  Ver 14.14 Distrib 5.1.63, for debian-linux-gnu
(x86_64) using readline 6.1
innobackupex: Using mysql server version Copyright (c) 2000, 2011, Oracle
and/or its affiliates. All rights reserved.

innobackupex: Created backup directory /backup/LH-02_2012-10-03
121003 18:48:37  innobackupex: Starting mysql with options:  
--password=xxxxxxxx --user='jbegg' --unbuffered --
121003 18:48:37  innobackupex: Connected to database with mysql child
process (pid=24120)
121003 18:48:39  innobackupex: Connection to database server closed

121003 18:48:39  innobackupex: Starting ibbackup with command:
xtrabackup_51  --defaults-group="mysqld" --backup --suspend-at-end
--target-dir=/backup/LH-02_2012-10-03
innobackupex: Waiting for ibbackup (pid=24126) to suspend
innobackupex: Suspend file '/backup/LH-02_2012-10-03/xtrabackup_suspended'

xtrabackup_51 version 2.0.3 for MySQL server 5.1.59 unknown-linux-gnu
(x86_64) (revision id: undefined)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql
xtrabackup: Target instance is assumed as followings.
xtrabackup:   innodb_data_home_dir = ./
xtrabackup:   innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup:   innodb_log_group_home_dir = ./
xtrabackup:   innodb_log_files_in_group = 2
xtrabackup:   innodb_log_file_size = 5242880

[01] Copying ./ibdata1 to /backup/LH-02_2012-10-03/ibdata1
[01]        ...done
[01] Copying ./supportdev/element_de.ibd to
/backup/LH-02_2012-10-03/./supportdev/element_de.ibd
[01]        ...done
[01] Copying ./supportdev/element_en.ibd to
/backup/LH-02_2012-10-03/./supportdev/element_en.ibd
[01]        ...done
[01] Copying ./supportdev/sites__history.ibd to
/backup/LH-02_2012-10-03/./supportdev/sites__history.ibd
[01]        ...done
[01] Copying ./supportdev/page_related_page.ibd to
/backup/LH-02_2012-10-03/./supportdev/page_related_page.ibd
[01]        ...done
[01] Copying ./supportdev/pages_de.ibd to
/backup/LH-02_2012-10-03/./supportdev/pages_de.ibd
[01]        ...done
[01] Copying ./supportdev/element__history.ibd to
/backup/LH-02_2012-10-03/./supportdev/element__history.ibd
[01]        ...done
[01] Copying ./supportdev/pages_en.ibd to
/backup/LH-02_2012-10-03/./supportdev/pages_en.ibd
[01]        ...done
[01] Copying ./supportdev/site_page.ibd to
/backup/LH-02_2012-10-03/./supportdev/site_page.ibd
[01]        ...done
[01] Copying ./supportdev/element.ibd to
/backup/LH-02_2012-10-03/./supportdev/element.ibd
[01]        ...done
[01] Copying ./supportdev/sites.ibd to
/backup/LH-02_2012-10-03/./supportdev/sites.ibd
[01]        ...done
[01] Copying ./supportdev/site_page__history.ibd to
/backup/LH-02_2012-10-03/./supportdev/site_page__history.ibd
[01]        ...done
[01] Copying ./supportdev/slots.ibd to
/backup/LH-02_2012-10-03/./supportdev/slots.ibd
[01]        ...done
[01] Copying ./supportdev/templates.ibd to
/backup/LH-02_2012-10-03/./supportdev/templates.ibd
[01]        ...done
[01] Copying ./supportdev/slot_element.ibd to
/backup/LH-02_2012-10-03/./supportdev/slot_element.ibd
[01]        ...done
[01] Copying ./supportdev/users__history.ibd to
/backup/LH-02_2012-10-03/./supportdev/users__history.ibd
[01]        ...done
[01] Copying ./supportdev/pages.ibd to
/backup/LH-02_2012-10-03/./supportdev/pages.ibd
[01]        ...done
[01] Copying ./supportdev/html_entities.ibd to
/backup/LH-02_2012-10-03/./supportdev/html_entities.ibd
[01]        ...done
[01] Copying ./supportdev/template_slot.ibd to
/backup/LH-02_2012-10-03/./supportdev/template_slot.ibd
[01]        ...done
[01] Copying ./supportdev/element_es.ibd to
/backup/LH-02_2012-10-03/./supportdev/element_es.ibd
xtrabackup: error: log block numbers mismatch:
xtrabackup: error: expected log block no. 97070621, but got no. 97091093
from the log file.
xtrabackup: error: it looks like InnoDB log has wrapped around before
xtrabackup could process all records due to either log copying being too
slow, or  log files being too small.
xtrabackup: Error: xtrabackup_copy_logfile() failed.
[01]        ...done
<end_partial_log_dump>

What can I do to correct what is wrong with supportdev.element_es.ibd?

Thank you.

Hi Dragan,

On 06.10.12, 1:05, Dragan Prostran wrote:

...
 > xtrabackup: error: log block numbers mismatch:

Yes, that's the problem. Either log files are too small (it looks like
the default innodb_log_file_size is being used by the server) or writes
to the backup target device are too slow so the log copying activity in
XtraBackup is unable to catch up with the log writing activity in the
server. See discussion in
https://bugs.launchpad.net/percona-xtrabackup/+bug/1050355 for example.

Best regards,
Alexey.