Xtrabackup crash

senya88 · December 30, 2020, 4:22pm

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)[root@server:~/backup]# ./xtrabackup.sh incr
Loading configuration from /root/.xtrabackup.config.

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)[root@server:~/backup]#

I would be grateful for any help.

Thanks

jrivera · December 30, 2020, 4:32pm

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 ?

senya88 · December 30, 2020, 4:32pm

Hi,

Thank you for response.

(pts/1)[root@server:~/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)[root@server:~/backup]#

senya88 · December 30, 2020, 4:32pm

I tried manual start:
root@server:~/backup # /usr/local/bin/innobackupex --slave-info --user=root --password=PASSWORD --defaults-file=/etc/my.cnf /usr/backup/mysql/full

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.
root@server:~/backup #

Unfortunatly, result is core dumped