Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: Problem with ZRM for mysql v1.1.4

  1. #1
    Join Date
    Nov 2005
    Posts
    52

    Default Problem with ZRM for mysql v1.1.4

    Forwarding with permission

    Kristjan Dodigovic wrote:
    > Hi
    >
    > I install ZRM for mysql v1.1.4 od debian linux.
    > When i try to make incremental backup with "mysql-zrm-scheduler --now
    > --backup-set test --backup-level 1"
    > i get this erorr
    > /bin/tar: /dev/nst0: Cannot read: Cannot allocate memory
    > /bin/tar: At beginning of tape, quitting now
    > /bin/tar: Error is not recoverable: exiting now
    >
    > gzip: stdin: unexpected end of file
    > /bin/tar: Child returned status 2
    > /bin/tar: Error exit delayed from previous errors
    > Do you know why ZRM is try to conect to tape drive on /dev/nst0 or
    > can you help me to avoid this beacuse i want to make backup on my local
    > harddrive?
    >
    >
    > Details from log:
    > Logging to /var/log/mysql-zrm/mysql-zrm-scheduler.log
    > INFO: ZRM for MySQL Community Edition - version 1.1.4
    > INFO: Input Parameters Used {
    > INFO: verbose=1
    > INFO: retention-policy=3M
    > INFO: tmpdir=/tmp
    > INFO: destination=/var/lib/mysql-zrm
    > INFO: backup-mode=raw
    > INFO: password=******
    > INFO: user=******
    > INFO: copy-plugin=/usr/share/mysql-zrm/plugins/socket-copy.pl
    > INFO: quiet=0
    > INFO: backup-level=1
    > INFO: databases=testdatabases
    > INFO: html-reports=backup-method-info,
    > backup-status-info,backup-retention-info, backup-performance-info,
    > backup-app-performance-info
    > INFO: remote-mysql-binpath=/var/log/mysql
    > INFO: host=test.server
    > INFO: database=testdatabases
    > INFO: html-report-directory=/var/www/mysql-zrm/reports/
    > INFO: mysql-binlog-path=/var/log/mysqll
    > INFO: }
    > INFO: ZRM Temporary configuration file = /etc/mysql-zrm/test/tmpKGTJP.conf
    > INFO: Getting mysql variables
    > INFO: mysqladmin --user="*****" --password="*****" --host="test.server"
    > variables
    > INFO: datadir is /var/lib/mysql/
    > INFO: mysql_version is 5.0.24a-Debian_2.dotdeb.0-log
    > INFO: log_bin=ON
    > INFO: InnoDB data file are /var/lib/mysql/ibdata1
    > INFO: InnoDB log dir is /var/lib/mysql/.
    > INFO: backup set being used is test
    > INFO: backup-set=test
    > INFO: backup-date=20070220164338
    > INFO: host=test.server
    > INFO: backup-date-epoch=1171986218
    > INFO: retention-policy=3M
    > INFO: mysql-zrm-version=ZRM for MySQL Community Edition - version 1.1.4
    > INFO: mysql-version=5.0.24a-Debian_2.dotdeb.0-log
    > INFO: backup-directory=/var/lib/mysql-zrm/test/20070220164338
    > INFO: Flushing the logs
    > INFO: flush-logs
    > INFO: Getting master logname using command mysql --user="*****""
    > --password="*****" --host="test.server" -e "show master status"
    > INFO: backup-level=1
    > INFO: Getting list of binary logs using command mysql --user="*****""
    > --password="*****" --host="test.server" -e "show master logs"
    > /bin/tar: /dev/nst0: Cannot read: Cannot allocate memory
    > /bin/tar: At beginning of tape, quitting now
    > /bin/tar: Error is not recoverable: exiting now
    >
    > gzip: stdin: unexpected end of file
    > /bin/tar: Child returned status 2
    > /bin/tar: Error exit delayed from previous errors
    > close of pipe failed
    > ERROR: Could not copy file /var/log/mysq/mysql-bin.000408
    > ERROR: copy-plugin exited with error 512
    > ERROR: Could not copy bin log file mysql-bin.000408
    > INFO: incremental=mysql-bin.[0-9]*
    > INFO: next-binlog=mysql-bin.000409
    > INFO: last-backup=/var/lib/mysql-zrm/test2/20070220121047
    > INFO: backup-size=0.00 MB
    > INFO: Executing post-backup-plugin
    > INFO: read-locks-time=00:00:00
    > INFO: flush-logs-time=00:00:01
    > INFO: backup-time=00:00:14
    > INFO: backup-status=Backup done but with errors
    > INFO: Backup done but with errors
    > ERROR: /usr/bin/mysql-zrm did not finish successfully
    >
    > Best regrads
    > Kristjan Dodigovic

  2. #2
    Join Date
    Oct 2006
    Posts
    199

    Default

    Could you please run with --verbose and post the logs?

    --kkg

  3. #3

    Default

    test:/etc/mysql-zrm/test# mysql-zrm --backup-set test --backup-level 1 --verbose --action backup
    INFO: ZRM for MySQL Community Edition - version 1.1.4
    INFO: Reading options from file /etc/mysql-zrm/mysql-zrm.conf
    INFO: Reading options from file /etc/mysql-zrm/test/mysql-zrm.conf
    INFO: action being performed is backup
    INFO: Input Parameters Used {
    INFO: verbose=1
    INFO: retention-policy=3M
    INFO: backup-level=1
    INFO: tmpdir=/tmp
    INFO: destination=/var/lib/mysql-zrm
    INFO: databases=databasestest
    INFO: remote-mysql-binpath=/var/log/mysql
    INFO: host=test.server
    INFO: database=databasestest
    INFO: backup-mode=raw
    INFO: password=******
    INFO: user=******
    INFO: mysql-binlog-path=/var/log/mysql
    INFO: copy-plugin=/usr/share/mysql-zrm/plugins/socket-copy.pl
    INFO: }
    INFO: ZRM Temporary configuration file = /etc/mysql-zrm/test/tmpw2KGh.conf
    INFO: Getting mysql variables
    INFO: mysqladmin --user="*****" --password="*****" --host="test.server" variables
    INFO: datadir is /var/lib/mysql/
    INFO: mysql_version is 5.0.24a-Debian_2.dotdeb.0-log
    INFO: log_bin=ON
    INFO: InnoDB data file are /var/lib/mysql/ibdata1
    INFO: InnoDB log dir is /var/lib/mysql/.
    INFO: backup set being used is test
    INFO: backup-set=test
    INFO: backup-date=20070221093912
    INFO: host=test.server
    INFO: backup-date-epoch=1172047152
    INFO: retention-policy=3M
    INFO: mysql-zrm-version=ZRM for MySQL Community Edition - version 1.1.4
    INFO: mysql-version=5.0.24a-Debian_2.dotdeb.0-log
    INFO: backup-directory=/var/lib/mysql-zrm/test/20070221093912
    INFO: Executing pre-backup-plugin
    INFO: Flushing the logs
    INFO: flush-logs
    INFO: Getting master logname using command mysql --user="*****" --password="*****" --host="test.server" -e "show master status"
    INFO: backup-level=1
    INFO: Getting list of binary logs using command mysql --user="*****" --password="*****" --host="test.server" -e "show master logs"
    /bin/tar: /dev/nst0: Cannot read: Cannot allocate memory
    /bin/tar: At beginning of tape, quitting now
    /bin/tar: Error is not recoverable: exiting now

    gzip: stdin: unexpected end of file
    /bin/tar: Child returned status 2
    /bin/tar: Error exit delayed from previous errors
    Pipe broke at /usr/share/mysql-zrm/plugins/socket-copy.pl line 85.
    ERROR: Could not copy file /var/log/mysql/mysql-bin.000412
    ERROR: copy-plugin exited with error 8192
    ERROR: Could not copy bin log file mysql-bin.000412
    INFO: incremental=mysql-bin.[0-9]*
    INFO: next-binlog=mysql-bin.000413
    INFO: last-backup=/var/lib/mysql-zrm/test2/20070221092948
    INFO: backup-size=0.00 MB
    INFO: Executing post-backup-plugin
    INFO: read-locks-time=00:00:00
    INFO: flush-logs-time=00:00:00
    INFO: backup-time=00:00:01
    INFO: backup-status=Backup done but with errors
    INFO: Backup done but with errors

  4. #4
    Join Date
    Oct 2006
    Posts
    199

    Default

    Could you also post the /tmp/client.log on the machine running test.server

    --kkg

  5. #5

    Default

    I dont have client.log on test.server, client.log is only on client server.

    Details from /tmp/client.log on client server.
    Client started
    Client clean exit

  6. #6
    Join Date
    Oct 2006
    Posts
    199

    Default

    That is strange. As per the logs you are trying to backup the host test.server and hence this host should be having a /tmp/client.log.

    BTW which is the client server machine? I don't see any reference to that machine in the logs.

    Could you see if xinet is running on test.server and if you are able to do a telnet to port 25300 on the test.server machine.

    --kkg

  7. #7

    Default

    Client is test.server. I can connect from test to test.server on port 25300.
    Details from /tmp/client.log on test.server
    Client started
    Client clean exit

  8. #8
    Join Date
    Oct 2006
    Posts
    199

    Default

    Oh boy, no easy answers :-(

    When you have some time, could you please try the following on the command line and post the output

    first edit the file /usr/share/mysql-zrm/plugins/socket-copy.pl and add the following line

    print "|$TAR --same-owner -xpszC $destDir\n";

    as the first line in the function readTarStream()

    Then do the following in the shell

    export ZRM_CONF=/etc/mysql-zrm/test/mysql-zrm.conf
    /usr/share/mysql-zrm/plugins/socket-copy.pl --source-host test.server --source-file /var/log/mysql/mysql-bin.000412 --destination-host localhost --destination-directory /tmp

    Sorry to send you so many instructions and questions but currently I am shooting in the dark and to top it all I don't have a debian system with me at this point.

    --kkg

  9. #9

    Default does ZRM suppors backup on local disc

    does ZRM supports backup on local disc? As it seems that by deafult it is trying to make backup to tape drive.

  10. #10

    Default

    test:/usr/share/mysql-zrm/plugins# export ZRM_CONF=/etc/mysql-zrm/test/mysql-zrm.conf
    test:/usr/share/mysql-zrm/plugins# /usr/share/mysql-zrm/plugins/socket-copy.pl --source-host test.server --source-file /var/log/mysql/mysql-bin.000412 --destination-host localhost --destination-directory /tmp
    |/bin/tar --same-owner -xpszC /tmp
    /bin/tar: /dev/nst0: Cannot read: Cannot allocate memory
    /bin/tar: At beginning of tape, quitting now
    /bin/tar: Error is not recoverable: exiting now

    gzip: stdin: unexpected end of file
    /bin/tar: Child returned status 2
    /bin/tar: Error exit delayed from previous errors
    Pipe broke at /usr/share/mysql-zrm/plugins/socket-copy.pl line 85.

    Whay ZRM try to connect on tape drive /dev/nst0 and tar someting on it?

Posting Permissions

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