•  

Announcement

Announcement Module
Collapse
No announcement yet.

innobackupex fails innobackupex: Error: Failed to copy file 'func.frm'

Page Title Module
Move Remove Collapse
Conversation Detail Module
Collapse
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts

  • innobackupex fails innobackupex: Error: Failed to copy file 'func.frm'

    #1
    Hi ,

    I am getting this error. backup directory permissions is wide open and running as a root user. Getting this error. is any one have over come this situation.

    121009 15:15:24 innobackupex: All tables locked and flushed to disk

    121009 15:15:24 innobackupex: Starting to backup .frm, .MRG, .MYD, .MYI,
    innobackupex: .TRG, .TRN, .ARM, .ARZ, .CSM, .CSV and .opt files in
    innobackupex: subdirectories of '/data/dvantagedb/ec'
    innobackupex: Backing up files '/data/dvantagedb/ec/mysql/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,AR Z,CSM,CSV,opt,par}' (72 files)
    cp: failed to preserve ownership for `/backup/dev_dumps/2012-10-09_15-07-50/mysql/func.frm': Invalid argument
    innobackupex: Error: Failed to copy file 'func.frm': No such file or directory at /usr/bin/innobackupex line 374
    Tags: None
  • #2
    Hi,

    Can you share some more information like OS/Innobackex versions, ls -al output of backup dir? Are you using encryption for your backup folder?

    Regards,
    Nil

    Comment

    • #3
      ]# innobackupex -version
      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.

      [root@db09 bin]# cat /etc/redhat-release
      CentOS release 6.3 (Final)
      [root@db09 bin]# cd /backup/2012-10-11_11-33-16/
      [root@db09 2012-10-11_11-33-16]# ls -al
      total 26748
      drwxr-xr-x 28 nfsnobody nfsnobody 4096 Oct 11 2012 .
      drwxrwxrwx 16 root root 4096 Oct 11 2012 ..
      drwx------ 2 nfsnobody nfsnobody 4096 Oct 11 2012 1ZXBHS
      drwx------ 2 nfsnobody nfsnobody 4096 Oct 11 2012 3S22XW
      drwx------ 2 nfsnobody nfsnobody 4096 Oct 11 2012 6HVTE1
      drwx------ 2 nfsnobody nfsnobody 4096 Oct 11 2012 8H40TL
      -rw-r--r-- 1 nfsnobody nfsnobody 196 Oct 11 2012 backup-my.cnf
      drwx------ 2 nfsnobody nfsnobody 4096 Oct 11 2012 BD5ACH
      drwx------ 2 nfsnobody nfsnobody 4096 Oct 11 2012 BWQEQJ
      drwx------ 2 nfsnobody nfsnobody 4096 Oct 11 2012 BZUH3A
      drwx------ 2 nfsnobody nfsnobody 4096 Oct 11 2012 C3FK8S
      drwx------ 2 nfsnobody nfsnobody 4096 Oct 11 2012 C7YXKI
      drwx------ 2 nfsnobody nfsnobody 4096 Oct 11 2012 companydb
      drwx------ 2 nfsnobody nfsnobody 4096 Oct 11 2012 DMLOHN
      drwx------ 2 nfsnobody nfsnobody 4096 Oct 11 2012 FKJNTO
      drwx------ 2 nfsnobody nfsnobody 4096 Oct 11 2012 FWVD53
      -rw-r----- 1 nfsnobody nfsnobody 27262976 Oct 11 2012 ibdata1
      drwxr-xr-x 2 nfsnobody nfsnobody 4096 Oct 11 2012 mysql
      drwx------ 2 nfsnobody nfsnobody 4096 Oct 11 2012 PPFII0
      drwx------ 2 nfsnobody nfsnobody 4096 Oct 11 2012 QX2ZVX
      drwx------ 2 nfsnobody nfsnobody 4096 Oct 11 2012 SYST01
      drwx------ 2 nfsnobody nfsnobody 4096 Oct 11 2012 TNUHZZ
      drwx------ 2 nfsnobody nfsnobody 4096 Oct 11 2012 TVUQUW
      drwx------ 2 nfsnobody nfsnobody 4096 Oct 11 2012 UOHO9Q
      drwx------ 2 nfsnobody nfsnobody 4096 Oct 11 2012 utility
      drwx------ 2 nfsnobody nfsnobody 4096 Oct 11 2012 vta
      drwx------ 2 nfsnobody nfsnobody 4096 Oct 11 2012 WGLVAT
      drwx------ 2 nfsnobody nfsnobody 4096 Oct 11 2012 word_press_evgeny
      -rw-r--r-- 1 nfsnobody nfsnobody 4 Oct 11 2012 xtrabackup_binlog_info
      -rw-r----- 1 nfsnobody nfsnobody 2048 Oct 11 2012 xtrabackup_logfile
      -rw-r--r-- 1 nfsnobody nfsnobody 0 Oct 11 2012 xtrabackup_suspended
      drwx------ 2 nfsnobody nfsnobody 4096 Oct 11 2012 YMDHPR
      drwx------ 2 nfsnobody nfsnobody 4096 Oct 11 2012 YR4H4B

      Comment

      • #4
        Hi,

        Are you taking backup to nfs mount point? looks like innobackupex tries to copy the file with cp -a to preserve the ownership (mysql:mysql) but it got refused by the storage.

        I'm not sure but reportedly, some NFS configurations don't support/allow that. There is one bug already filed for this scenario.
        https://bugs.launchpad.net/percona-xtrabackup/+bug/943750

        If this is the case, can you provide some more information?
        - command line which you are running to take backup.
        - fstab and mount -i

        Comment

        • #5
          Thank you for the information. database size is 1 gb I am not getting the error. The one I have problem is 9.2 GB database

          Thanks,
          Madhu

          Comment

          Working...
          X