for the purpose of creating a new replica of a MySQL 5.7 server I use this command
xtrabackup --backup --stream=xbstream --parallel=4 /tmp | pigz -c --fast | nc -w 2 replica 2112
this is based on this document.
Normally it works fine (I have synced several replicas with the same method) but now it fails each time with such error after one hours
... 210428 10:56:59 Starting to backup non-InnoDB tables and files 210428 10:56:59  Streaming ./db_187/twitter_scenarios.frm to <STDOUT> 210428 10:56:59  ...done xtrabackup: Error writing file 'UNOPENED' (Errcode: 32 - Broken pipe)  Error: copy_file() failed. Failed to copy file ./db_187/twitter_scenarios.frm
./db_187/twitter_scenarios.frm has no issue or permission problem.
Also it worth pointing I don’t understand why there is the line
Starting to backup non-InnoDB tables and files before reaching this file because this table is innodb.
ls /var/lib/mysql/prod2_187/twitter_scenarios.* -al -rw-r----- 1 mysql mysql 8762 Apr 28 14:36 /var/lib/mysql/db_187/twitter_scenarios.frm -rw-r----- 1 mysql mysql 114688 Apr 28 12:53 /var/lib/mysql/db_187/twitter_scenarios.ibd
Do you have some advice to troubleshoot or even fix this issue ?