Results 1 to 4 of 4

Thread: mysqldumb failure

  1. #1

    Default mysqldumb failure

    I upgraded my mysql servers to mariadb 5.5 from mysql community 5.1 and now I get this error:

    Creating logical backup 00:00:00 ERRORS:
    - Output of command: 'command is : bash -c '\"/usr/bin\"/mysqldump --opt --extended-insert --create-options --default-character-set=utf8 --single-transaction --flush-logs --user=\"USER\" --password=\"*****\" --host=\"198.XXX.XXX.XXX\" --port=\"3306\" --all-databases > \"/var/lib/mysql-zrm/webmysql4.peigov/20130719111514/backup.sql\" 2>>/tmp/zrm/jabIrHPUXa;echo $[PIPESTATUS[@]
    - Output of command: 'pipe exit status' is [
    - 2
    ]
    - mysqldump did not succeed.

    any help would be great thanks :)

  2. #2

    Default

    You can see the mysqldump backup error in ZRM log file
    ie /var/log/mysql-zrm/mysql-zrm.log

    Please check the zrm log file.

  3. #3

    Default

    Thu Jul 25 09:54:36 2013: webmysql4:backup:INFO: backup-set=webmysql4
    Thu Jul 25 09:54:36 2013: webmysql4:backup:INFO: backup-date=20130725095436
    Thu Jul 25 09:54:36 2013: webmysql4:backup:INFO: mysql-server-os=Linux/Unix
    Thu Jul 25 09:54:36 2013: webmysql4:backup:INFO: backup-type=regular
    Thu Jul 25 09:54:36 2013: webmysql4:backup:INFO: host=198.167.XXX.XXX
    Thu Jul 25 09:54:36 2013: webmysql4:backup:INFO: backup-date-epoch=1374756876
    Thu Jul 25 09:54:36 2013: webmysql4:backup:INFO: mysql-zrm-version=ZRM for MySQL Enterprise Edition - version 3.6
    Thu Jul 25 09:54:36 2013: webmysql4:backup:INFO: mysql-version=5.5.31-MariaDB-log
    Thu Jul 25 09:54:36 2013: webmysql4:backup:INFO: backup-directory=/var/lib/mysql-zrm/webmysql4/20130725095436
    Thu Jul 25 09:54:36 2013: webmysql4:backup:INFO: comment=ITS database
    Thu Jul 25 09:54:36 2013: webmysql4:backup:INFO: backup-level=0
    Thu Jul 25 09:54:36 2013: webmysql4:backup:INFO: backup-mode=logical
    Thu Jul 25 09:54:36 2013: webmysql4:backup:INFO: PHASE END: Initialization
    Thu Jul 25 09:54:36 2013: webmysql4:backup:INFO: PHASE START: Running pre backup plugin
    Thu Jul 25 09:54:36 2013: webmysql4:backup:INFO: Return value from pre-backup-plugin is 0
    Thu Jul 25 09:54:36 2013: webmysql4:backup:INFO: PHASE END: Running pre backup plugin
    Thu Jul 25 09:54:36 2013: webmysql4:backup:INFO: PHASE START: Creating logical backup
    Thu Jul 25 09:54:36 2013: webmysql4:backup:INFO: Command exit status is : 0
    Thu Jul 25 09:54:36 2013: webmysql4:backup:ERROR: Output of command: 'command is : bash -c '"/usr/bin"/mysqldump --opt --extended-insert --create-options --default-character-set=utf8 --single-transaction --flush-logs --user="backup_user" --password="*****" --host="198.167.XXX.XXX" --port="3306" --all-databases > "/var/lib/mysql-zrm/webmysql4/20130725095436/backup.sql" 2>>/tmp/zrm/j3a7M5PrWa;echo ${PIPESTATUS[@]} > /tmp/zrm/G0_ijFf_0p 2>>/tmp/zrm/j3a7M5PrWa'' is {
    mysqldump: Got error: 1105: Unknown error when doing refresh
    }
    Thu Jul 25 09:54:36 2013: webmysql4:backup:ERROR: Output of command: 'pipe exit status' is {
    2
    }
    Thu Jul 25 09:54:36 2013: webmysql4:backup:ERROR: mysqldump did not succeed.
    Thu Jul 25 09:54:36 2013: webmysql4:backup:INFO: PHASE START: Cleanup
    Thu Jul 25 09:54:36 2013: webmysql4:backup:INFO: backup-status=Backup failed
    Thu Jul 25 09:54:36 2013: webmysql4:backup:INFO: Backup failed
    Thu Jul 25 09:54:36 2013: webmysql4:backup:INFO: PHASE END: Cleanup
    Thu Jul 25 09:54:36 2013: webmysql4:INFO: END OF BACKUP

  4. #4

    Default

    [
    Thu Jul 25 09:54:36 2013: webmysql4:backup:ERROR: Output of command: 'command is : bash -c '"/usr/bin"/mysqldump --opt --extended-insert --create-options --default-character-set=utf8 --single-transaction --flush-logs --user="backup_user" --password="*****" --host="198.167.XXX.XXX" --port="3306" --all-databases > "/var/lib/mysql-zrm/webmysql4/20130725095436/backup.sql" 2>>/tmp/zrm/j3a7M5PrWa;echo ${PIPESTATUS[@]} > /tmp/zrm/G0_ijFf_0p 2>>/tmp/zrm/j3a7M5PrWa'' is {
    mysqldump: Got error: 1105: Unknown error when doing refresh
    }
    Thu Jul 25 09:54:36 2013: webmysql4:backup:ERROR: Output of command: 'pipe exit status' is {
    2
    }

    Can you try the flush on mysql server, looks like MySQL binlog rotate is not working.

    mysql> flush logs;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •