I'm testing the latest xtrabackup(lp:percona-xtrabackup) with this server and I have the following issue when I try to do backup:
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /tmp/1/src/data
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 = 2097152
130313 0:06:46 InnoDB: Assertion failure in thread 140183767389952 in file fil0fil.c line 5519
InnoDB: Failing assertion: byte_offset % OS_FILE_LOG_BLOCK_SIZE == 0
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.5/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
I use the following test script to repeat it:
#!/bin/bash
$MYSQL --no-defaults -uroot test -e 'create table t1 (a int unsigned auto_increment primary key, b int(10) unsigned not null default 0) engine=innodb;'
$MYSQL --no-defaults -uroot test -e 'insert into t1 (b) values (1),(1),(1),(1),(1),(1),(1),(1),(1),(1);'
for i in `seq 1 15`; do
$MYSQL --no-defaults -uroot test -e 'insert into t1 (b) select b from t1;'
done
$MYSQL --no-defaults -uroot test -e 'insert into t1 (b) select b from t1;' 2>&1>/dev/null &
PID2=$!
echo '----------------------------backup---------------------------------'
$XTRABACKUP --backup --datadir=$DATA_DIR --target-dir=$BACKUP_DIR $EXTRA_OPTIONS
wait $PID2
If SERVER_OPTIONS is empty(i.e. log archiving is disabled) xtrabackup works without abort. I've tested the latest PS 5.6 and the revision just before "archived logs" changes and both works fine.
I'm testing the latest xtrabackup(lp:percona-xtrabackup) with this server and I have the following issue when I try to do backup:
xtrabackup: uses posix_fadvise(). data_home_ dir = ./ data_file_ path = ibdata1: 10M:autoextend log_group_ home_dir = ./ log_files_ in_group = 2 log_file_ size = 2097152 LOG_BLOCK_ SIZE == 0 bugs.mysql. com. dev.mysql. com/doc/ refman/ 5.5/en/ forcing- innodb- recovery. html
xtrabackup: cd to /tmp/1/src/data
xtrabackup: Target instance is assumed as followings.
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
130313 0:06:46 InnoDB: Assertion failure in thread 140183767389952 in file fil0fil.c line 5519
InnoDB: Failing assertion: byte_offset % OS_FILE_
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://
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://
InnoDB: about forcing recovery.
I use the following test script to repeat it:
#!/bin/bash
BASE_DIR= /tmp/1/ percona- current /tmp/1/ src/data LOGS_DIR= /tmp/1/ src/archived_ logs DIR=/tmp/ 1/src/backup $XTRABACKUP_ DIR/xtrabackup_ 55 "--innodb- file-per- table --innodb_ log_file_ size=2M" OPTIONS= "--innodb_ log_archive= ON --innodb_ log_arch_ dir=$ARCHIVED_ LOGS_DIR" PATH=$BASE_ DIR/lib/ mysql:$ LD_LIBRARY_ PATH DB=$BASE_ DIR/scripts/ mysql_install_ db $BASE_DIR/ bin/mysqld BASE_DIR/ bin/mysql
DATA_DIR=
ARCHIVED_
BACKUP_
DST_DIR=/tmp/1/dst
XTRABACKUP_DIR=.
XTRABACKUP=
USER=some_user
EXTRA_OPTIONS=
SERVER_
LD_LIBRARY_
INSTALL_
MYSQLD=
MYSQL=$
mkdir -p $DATA_DIR $ARCHIVED_LOGS_DIR $BACKUP_DIR $DST_DIR LOGS_DIR/ * $BACKUP_DIR/* $DST_DIR/*
rm -rf $DATA_DIR/* $ARCHIVED_
$INSTALL_DB --no-defaults --basedir=$BASE_DIR --datadir=$DATA_DIR --user=$USER $EXTRA_OPTIONS ------- ------- ------after start-- ------- ------- ------- ------'
PID1=$!
sleep 2
echo '------
$MYSQL --no-defaults -uroot test -e 'create table t1 (a int unsigned auto_increment primary key, b int(10) unsigned not null default 0) engine=innodb;' ,(1),(1) ,(1),(1) ,(1),(1) ,(1),(1) ;'
$MYSQL --no-defaults -uroot test -e 'insert into t1 (b) values (1),(1)
for i in `seq 1 15`; do
$MYSQL --no-defaults -uroot test -e 'insert into t1 (b) select b from t1;'
done
$MYSQL --no-defaults -uroot test -e 'insert into t1 (b) select b from t1;' 2>&1>/dev/null & ------- ------- ------- -backup- ------- ------- ------- ------- ----' dir=$BACKUP_ DIR $EXTRA_OPTIONS
PID2=$!
echo '------
$XTRABACKUP --backup --datadir=$DATA_DIR --target-
wait $PID2
If SERVER_OPTIONS is empty(i.e. log archiving is disabled) xtrabackup works without abort. I've tested the latest PS 5.6 and the revision just before "archived logs" changes and both works fine.