From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mail-ua0-f174.google.com ([209.85.217.174]:34360 "EHLO mail-ua0-f174.google.com" rhost-flags-OK-OK-OK-OK) by vger.kernel.org with ESMTP id S1750768AbdHMEeV (ORCPT ); Sun, 13 Aug 2017 00:34:21 -0400 Received: by mail-ua0-f174.google.com with SMTP id q25so27253951uah.1 for ; Sat, 12 Aug 2017 21:34:21 -0700 (PDT) MIME-Version: 1.0 In-Reply-To: <1318.49.228.122.75.1502595606.squirrel@mail> References: <21234.192.168.42.222.1502253143.squirrel@mail> <22169.183.88.87.49.1502260598.squirrel@mail> <27218.183.88.87.49.1502426431.squirrel@mail> <13031.192.168.42.222.1502431206.squirrel@mail> <1243.49.228.123.163.1502505534.squirrel@mail> <1420.49.228.123.163.1502514511.squirrel@mail> <6341.49.228.122.75.1502590802.squirrel@mail> <1318.49.228.122.75.1502595606.squirrel@mail> From: Chris Murphy Date: Sat, 12 Aug 2017 22:34:19 -0600 Message-ID: Subject: Re: btrfs issue with mariadb incremental backup To: siranee.ja@tpc.co.th Cc: Chris Murphy , Btrfs BTRFS , voravat@tpcorp.co.th Content-Type: text/plain; charset="UTF-8" Sender: linux-btrfs-owner@vger.kernel.org List-ID: On Sat, Aug 12, 2017 at 9:40 PM, wrote: > [root@backuplogC7 ~]# rsync -avnc /var/lib/mariadb/mysql_201708090830/ > root@192.168.45.166://var/lib/mariadb/mysql_201708090830/ > sending incremental file list > ./ > ib_logfile1 > ibdata1 > > sent 3779 bytes received 25 bytes 507.20 bytes/sec > total size is 718361496 speedup is 188843.72 (DRY RUN) OK so I don't think this can be a sync related problem. That snapshot has been committed to disk days ago. There's definitely something wrong with the incremental send/receive, but it's unclear whether this is a kernel bug (send side) or btrfs-progs (receive side), or if there's any chance of file system corruption/confusion happening with either of the two subvolumes on the origin or the subvolume (parent) on the destination. So that means you're really in the weeds on what to do next. Try deleting mysql_201708090830/ snapshot on the destination. And resend but this time do a full send of that snapshot, don't use -p. I wonder if a full send, rather than incremental makes a difference. Follow it up with the rsync command to compare origin and destination. -- Chris Murphy