Not the answer you need?
Register and ask your own question!

The problem with xtrabackup. Error writing file 'UNOPENED' (Errcode: 32 - Broken pipe)

perrfectperrfect Current User Role Novice
Hello.
I use this command for copy mysql data to a slave server:
innobackupex --stream=tar ./ | pigz -p 4 | pv > /dev/tcp/10.10.1.40/4444

On the slave server i use:
nc -l 4444 | tar -zxv

But i get the error:
>> log scanned up to (193253267572108)                                                                                                                                 ]
[01] Streaming ./ibdata1
pv: write failed: Connection reset by peer
pigz: abort: write error on <stdout> (Broken pipe)
xtrabackup: Error writing file 'UNOPENED' (Errcode: 32 - Broken pipe)
archive_write_data() failed: (Empty error message) (errno = 0)
[01] xtrabackup: Error: xtrabackup_copy_datafile() failed.
[01] xtrabackup: Error: failed to copy datafile.
innobackupex: got a fatal error with the following stacktrace: at /bin/innobackupex line 2711.
        main::wait_for_ibbackup_file_create('/tmp/xtrabackup_suspended_2') called at /bin/innobackupex line 2731
        main::wait_for_ibbackup_suspend('/tmp/xtrabackup_suspended_2') called at /bin/innobackupex line 1984
        main::backup() called at /bin/innobackupex line 1609
innobackupex: Error: The xtrabackup child process has died at /bin/innobackupex line 2711.
Tagged:

Answers

  • YodaYoda Current User Role Supporter
    I think, your TAR-command is not corect. try these one:
    nc -l 4444 | tar xzvf -

  • perrfectperrfect Current User Role Novice
    Yoda said:
    I think, your TAR-command is not corect. try these one:
    nc -l 4444 | tar xzvf -

    Hi. Thank you for your reply.
    I tried, but result is the same(
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.