Hi there,
I’m running Percona mysql Server version: 5.5.23-55-log Percona Server (GPL), Release 25.3 and xtrabackup version 2.0.0 for Percona Server 5.1.59 unknown-linux-gnu (x86_64) (revision id: undefined).
I have 5 database servers with this setup, and 4 are completing their backups fine, and one is failing with the error:
Failed to stream xtrabackup_binary: Inappropriate ioctl for device at /usr/bin/innobackupex-1.5.1 line 301.
Throughout the log of the backup, there’s also errors with exit code 141 like this:
innobackupex-1.5.1: Ignoring nonexistent file ‘my_db_staging/password_resets.frm’.
innobackupex-1.5.1: xbstream -c returned with exit code 141.
I am running all 5 backups with the command: /usr/bin/innobackupex-1.5.1 --defaults-file=/etc/mysql/my.cnf --user=my_user --password=my_pass --throttle=40 --stream=xbstream ./ | pv -q -L40m | su backups -c ‘ssh backups@10.54.168.16 “xbstream -x -C /backups/mysql-9/0-days-ago”’
Does anyone know what might cause this error or how I should go about troubleshooting it?
Thank you,
Tim.
A truncated copy of the end of the backup log:
log scanned up to (1708839913493)
log scanned up to (1708840156643)
log scanned up to (1708840595827)
log scanned up to (1708841052489)
log scanned up to (1708841365198)
log scanned up to (1708841828552)
log scanned up to (1708842195574)
[01] …done
121105 18:37:24 innobackupex-1.5.1: Continuing after ibbackup has suspended
121105 18:37:24 innobackupex-1.5.1: Starting mysql with options: --defaults-file=‘/etc/mysql/my.cnf’ --password=xxxxxxxx --user=‘my_user’ --unbuffered –
121105 18:37:24 innobackupex-1.5.1: Connected to database with mysql child process (pid=13585)
121105 18:37:26 innobackupex-1.5.1: Starting to lock all tables…
log scanned up to (1708842531794)
log scanned up to (1708842747386)
121105 18:37:36 innobackupex-1.5.1: All tables locked and flushed to disk
121105 18:37:36 innobackupex-1.5.1: Starting to backup .frm, .MRG, .MYD, .MYI,
innobackupex-1.5.1: .TRG, .TRN, .ARM, .ARZ, .CSM, .CSV and .opt files in
innobackupex-1.5.1: subdirectories of ‘/var/lib/mysql’
innobackupex-1.5.1: Backing up files ‘/var/lib/mysql/beta_billing/.{frm,MYD,MYI,MRG,TRG,TRN,ARM, ARZ,CSM,CSV,opt,par}’ (10 files)
innobackupex-1.5.1: Backing up files '/var/lib/mysql/my_db_staging/.{frm,MYD,MYI,MRG,TRG,TRN,ARM ,ARZ,CSM,CSV,opt,par}’ (54 files)
xbstream: Can’t create/write to file ‘./my_db_staging/user_opt_outs.ibd’ (Errcode: 17)
xbstream: failed to create file.
innobackupex-1.5.1: xbstream -c returned with exit code 141.
innobackupex-1.5.1: Ignoring nonexistent file ‘my_db_staging/user_opt_outs.ibd’.
innobackupex-1.5.1: xbstream -c returned with exit code 141.
innobackupex-1.5.1: Ignoring nonexistent file ‘my_db_staging/subscriptions.frm’.
innobackupex-1.5.1: xbstream -c returned with exit code 141.
innobackupex-1.5.1: Ignoring nonexistent file ‘my_db_staging/subscription_plans.frm’.
innobackupex-1.5.1: xbstream -c returned with exit code 141.
innobackupex-1.5.1: Ignoring nonexistent file ‘my_db_staging/billing_transactions.frm’.
innobackupex-1.5.1: xbstream -c returned with exit code 141.
innobackupex-1.5.1: Ignoring nonexistent file ‘my_db_staging/password_resets.frm’.
innobackupex-1.5.1: xbstream -c returned with exit code 141.
innobackupex-1.5.1: Ignoring nonexistent file ‘my_db_staging/tolk_phrases.frm’.
innobackupex-1.5.1: Backing up files ‘/var/lib/mysql/mysql/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,ARZ,CSM ,CSV,opt,par}’ (68 files)
innobackupex-1.5.1: xbstream -c returned with exit code 141.
innobackupex-1.5.1: Ignoring nonexistent file ‘mysql/db.frm’.
innobackupex-1.5.1: xbstream -c returned with exit code 141.
innobackupex-1.5.1: Ignoring nonexistent file ‘mysql/procs_priv.MYD’.
innobackupex-1.5.1: xbstream -c returned with exit code 141.
innobackupex-1.5.1: Ignoring nonexistent file ‘mysql/plugin.MYD’.
innobackupex-1.5.1: xbstream -c returned with exit code 141.
innobackupex-1.5.1: xbstream -c returned with exit code 141.
innobackupex-1.5.1: Ignoring nonexistent file ‘mysql/tables_priv.MYI’.
innobackupex-1.5.1: xbstream -c returned with exit code 141.
innobackupex-1.5.1: Ignoring nonexistent file ‘mysql/proxies_priv.MYD’.
innobackupex-1.5.1: Backing up file ‘/var/lib/mysql/event_tracker/events.frm’
innobackupex-1.5.1: xbstream -c returned with exit code 141.
innobackupex-1.5.1: Ignoring nonexistent file ‘event_tracker/events.frm’.
innobackupex-1.5.1: Backing up file ‘/var/lib/mysql/event_tracker/db.opt’
innobackupex-1.5.1: xbstream -c returned with exit code 141.
innobackupex-1.5.1: Ignoring nonexistent file ‘event_tracker/db.opt’.
innobackupex-1.5.1: Backing up files ‘/var/lib/mysql/performance_schema/*.{frm,MYD,MYI,MRG,TRG,TR N,ARM,ARZ,CSM,CSV,opt,par}’ (18 files)
innobackupex-1.5.1: xbstream -c returned with exit code 141.
innobackupex-1.5.1: Ignoring nonexistent file ‘performance_schema/cond_instances.frm’.
innobackupex-1.5.1: xbstream -c returned with exit code 141.
innobackupex-1.5.1: Ignoring nonexistent file ‘performance_schema/events_waits_summary_global_by_event_nam e.frm’.
innobackupex-1.5.1: xbstream -c returned with exit code 141.
innobackupex-1.5.1: Ignoring nonexistent file ‘performance_schema/rwlock_instances.frm’.
121105 18:37:37 innobackupex-1.5.1: Finished backing up .frm, .MRG, .MYD, .MYI, .TRG, .TRN, .ARM, .ARZ, .CSV, .CSM and .opt files
innobackupex-1.5.1: Resuming ibbackup
xtrabackup: The latest check point (for incremental): ‘1708472789748’
xtrabackup: Stopping log copying thread.
.>> log scanned up to (1708842747978)
121105 18:37:39 innobackupex-1.5.1: All tables unlocked
121105 18:37:39 innobackupex-1.5.1: Connection to database server closed
innobackupex-1.5.1: Backup created in directory ‘/usr/local/sbin’
innobackupex-1.5.1: MySQL binlog position: filename ‘mysql-bin.005115’, position 76986073
Failed to stream xtrabackup_binary: Inappropriate ioctl for device at /usr/bin/innobackupex-1.5.1 line 301.