Not the answer you need?
Register and ask your own question!

Xtrabackup crash

senya88senya88 EntrantCurrent User Role Beginner
Hi All,

I have FreeBSD server 10.1-RELEASE-p14, MySQL server 5.5, xtrabackup-2.2.10 are installed from default packages repository. I'm using custom backup script:
https://github.com/vitobotta/admin-s.../xtrabackup.sh

Older version of Xtrabackup worked very good, but now I have core dumping:

(pts/2)[[email protected]:~/backup]# ./xtrabackup.sh incr
Loading configuration from /root/.xtrabackup.config.

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.

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

150729 13:38:10 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_file=/etc/my.cnf;mysql_read_default_group=xtrabackup' as 'root' (using password: YES).
150729 13:38:10 innobackupex: Connected to MySQL server
150729 13:38:10 innobackupex: Executing a version check against the server...
150729 13:38:11 innobackupex: Done.
150729 13:38:11 innobackupex: Starting the backup operation

IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex
prints "completed OK!".

innobackupex: Using server version 5.5.43

innobackupex: Created backup directory /usr/backup/mysql/full/2015-07-29_13-38-31

150729 13:38:32 innobackupex: Starting ibbackup with command: xtrabackup --defaults-file="/etc/my.cnf" --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/usr/backup/mysql/full/2015-07-29_13-38-31 --datadir="/var/db/mysql/" --innodb_log_file_size="5242880" --innodb_data_file_path="ibdata1:10M:autoextend" --tmpdir=/tmp/ --extra-lsndir='/tmp/'
innobackupex: Waiting for ibbackup (pid=80791) to suspend
innobackupex: Suspend file '/usr/backup/mysql/full/2015-07-29_13-38-31/xtrabackup_suspended_2'

innobackupex: got a fatal error with the following stacktrace: at /usr/local/bin/innobackupex line 2703.
main::wait_for_ibbackup_file_create("/usr/backup/mysql/full/2015-07-29_13-38-31/xtrabackup_suspend"...) called at /usr/local/bin/innobackupex line 2723
main::wait_for_ibbackup_suspend("/usr/backup/mysql/full/2015-07-29_13-38-31/xtrabackup_suspend"...) called at /usr/local/bin/innobackupex line 1976
main::backup() called at /usr/local/bin/innobackupex line 1601
innobackupex: Error: The xtrabackup child process has died at /usr/local/bin/innobackupex line 2703.
ls: -t: No such file or directory
grep: /usr/backup/mysql//incr/**/backup.chain: No such file or directory
(pts/2)[[email protected]:~/backup]#


I would be grateful for any help.

Thanks

Comments

  • jriverajrivera Percona Support Engineer Percona Staff Role
    innobackupex: Error: The xtrabackup child process has died at /usr/local/bin/innobackupex line 2703.
    ls: -t: No such file or directory
    grep: /usr/backup/mysql//incr/**/backup.chain: No such file or directory
    

    Are you sure the directories are present? can you provide output of ls -laR /usr/backup/mysql ?
  • senya88senya88 Entrant Current User Role Beginner
    Hi,

    Thank you for response.

    (pts/1)[[email protected]:~/backup]# ls -laR /usr/backup/mysql
    total 16
    drwxr-xr-x 4 root wheel 512 7 nov 2014 .
    drwxr-xr-x 4 root wheel 512 27 feb 13:13 ..
    drwxr-xr-x 4 root wheel 512 30 jul 02:00 full
    drwxr-xr-x 2 root wheel 1536 27 jun 13:56 incr

    /usr/backup/mysql/full:
    total 16
    drwxr-xr-x 4 root wheel 512 30 jul 02:00 .
    drwxr-xr-x 4 root wheel 512 7 nov 2014 ..
    drwxr-xr-x 2 root wheel 512 29 jul 14:08 2015-07-29_14-07-42
    drwxr-xr-x 2 root wheel 512 30 jul 02:00 2015-07-30_02-00-11

    /usr/backup/mysql/full/2015-07-29_14-07-42:
    total 16
    drwxr-xr-x 2 root wheel 512 29 jul 14:08 .
    drwxr-xr-x 4 root wheel 512 30 jul 02:00 ..
    -rw-r--r-- 1 root wheel 188 29 jul 14:07 backup-my.cnf
    -rw-r--r-- 1 root wheel 44 29 jul 14:08 backup.chain

    /usr/backup/mysql/full/2015-07-30_02-00-11:
    total 16
    drwxr-xr-x 2 root wheel 512 30 jul 02:00 .
    drwxr-xr-x 4 root wheel 512 30 jul 02:00 ..
    -rw-r--r-- 1 root wheel 188 30 jul 02:00 backup-my.cnf
    -rw-r--r-- 1 root wheel 44 30 jul 02:00 backup.chain

    /usr/backup/mysql/incr:
    total 8
    drwxr-xr-x 2 root wheel 1536 27 jun 13:56 .
    drwxr-xr-x 4 root wheel 512 7 nov 2014 ..
    (pts/1)[[email protected]:~/backup]#
  • senya88senya88 Entrant Current User Role Beginner
    I tried manual start:
    [email protected]:~/backup # /usr/local/bin/innobackupex --slave-info --user=root --password=PASSWORD --defaults-file=/etc/my.cnf /usr/backup/mysql/full

    InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
    and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.

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

    150815 11:50:41 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_file=/etc/my.cnf;mysql_read_default_group=xtrabackup' as 'root' (using password: YES).
    150815 11:50:41 innobackupex: Connected to MySQL server
    150815 11:50:41 innobackupex: Executing a version check against the server...
    150815 11:50:41 innobackupex: Done.
    150815 11:50:41 innobackupex: Starting the backup operation

    IMPORTANT: Please check that the backup run completes successfully.
    At the end of a successful backup run innobackupex
    prints "completed OK!".

    innobackupex: Using server version 5.6.25

    innobackupex: Created backup directory /usr/backup/mysql/full/2015-08-15_11-50-42

    150815 11:50:42 innobackupex: Starting ibbackup with command: xtrabackup --defaults-file="/etc/my.cnf" --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/usr/backup/mysql/full/2015-08-15_11-50-42 --datadir="/var/db/mysql/" --innodb_log_file_size="50331648" --innodb_data_file_path="ibdata1:12M:autoextend" --tmpdir=/tmp/ --extra-lsndir='/tmp/'
    innobackupex: Waiting for ibbackup (pid=1441) to suspend
    innobackupex: Suspend file '/usr/backup/mysql/full/2015-08-15_11-50-42/xtrabackup_suspended_2'

    innobackupex: got a fatal error with the following stacktrace: at /usr/local/bin/innobackupex line 2703.
    main::wait_for_ibbackup_file_create("/usr/backup/mysql/full/2015-08-15_11-50-42/xtrabackup_suspend"...) called at /usr/local/bin/innobackupex line 2723
    main::wait_for_ibbackup_suspend("/usr/backup/mysql/full/2015-08-15_11-50-42/xtrabackup_suspend"...) called at /usr/local/bin/innobackupex line 1976
    main::backup() called at /usr/local/bin/innobackupex line 1601
    innobackupex: Error: The xtrabackup child process has died at /usr/local/bin/innobackupex line 2703.
    [email protected]:~/backup #

    Unfortunatly, result is core dumped
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.