GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Reourring xtrabackup_suspended_2 ERROR

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

  • Reourring xtrabackup_suspended_2 ERROR

    Hello,

    Getting below error reoccuringly. Backups are failing.
    Please suggest

    --------------------------------------------------------------------------------------------------------------------------------------
    140804 15:31:50 innobackupex: Starting ibbackup with command: xtrabackup --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/Backup/Full/2014-08-04_15-31-50 --tmpdir=/tmp --extra-lsndir='/tmp'
    innobackupex: Waiting for ibbackup (pid=27974) to suspend
    innobackupex: Suspend file '/Backup/Full/2014-08-04_15-31-50/xtrabackup_suspended_2'

    xtrabackup version 2.2.3 based on MySQL server 5.6.17 Linux (x86_64) (revision id: )
    xtrabackup: uses posix_fadvise().
    xtrabackup: cd to /var/lib/mysql/
    xtrabackup: open files limit requested 65535, set to 65535
    xtrabackup: using the following InnoDB configuration:
    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 = 536870912
    >> log scanned up to (272362439809)
    >> log scanned up to (272362439809)
    ----------------------------------------------------------------------------------------------------------------------------------


    my.cnf
    --------------------------------------------------------------------------------------------------------------------------------
    [root@mysql117slave tmp]# cat /etc/my.cnf
    [mysql]

    # CLIENT #
    port = 3306
    socket = /var/lib/mysql/mysql.sock

    [mysqld]
    server-id=2
    binlog-ignore-db=mysql

    # GENERAL #
    user = mysql
    socket = /var/lib/mysql/mysql.sock
    pid-file = /var/lib/mysql/mysql.pid

    # MyISAM #
    key-buffer-size = 32M

    # SAFETY #
    max-allowed-packet = 16M
    max-connect-errors = 1000000
    skip-name-resolve

    # DATA STORAGE #
    datadir = /var/lib/mysql/

    # CACHES AND LIMITS #
    tmp-table-size = 32M
    max-heap-table-size = 32M
    max-connections = 500
    thread-cache-size = 50
    open-files-limit = 65535
    table-definition-cache = 4096
    table-open-cache = 10240

    # INNODB #
    innodb-log-file-size = 512M
    innodb-buffer-pool-size = 6G

    # LOGGING #
    log-error = /var/log/mysql/mysql-error.log
    log-queries-not-using-indexes = 1
    slow-query-log = 1
    slow-query-log-file = /var/log/mysql/mysql-slow.log
    ------------------------------------------------------------------------------------------------------------------------

  • #2
    Please reply

    140804 15:31:50 innobackupex: Starting ibbackup with command: xtrabackup --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/Backup/Full/2014-08-04_15-31-50 --tmpdir=/tmp --extra-lsndir='/tmp'
    innobackupex: Waiting for ibbackup (pid=27974) to suspend
    innobackupex: Suspend file '/Backup/Full/2014-08-04_15-31-50/xtrabackup_suspended_2'

    xtrabackup version 2.2.3 based on MySQL server 5.6.17 Linux (x86_64) (revision id: )
    xtrabackup: uses posix_fadvise().
    xtrabackup: cd to /var/lib/mysql/

    keeps repeating

    Comment


    • #3
      Could you please show us the full output? I can't see the error.

      Martin.

      Comment

      Working...
      X