Re: btrfs issue with mariadb incremental backup

2017-08-13 Thread siranee . ja
Hi Chris, Thank you very much for your suggestion. I didn't remember which steps that I made a mistake and made the mysql had Received UUID. I have done the following and it work as it should be right now. [root@backuplogC7 mariadb]# btrfs subvolume snapshot mbroken_201708070830 rw_20170807083

Re: btrfs issue with mariadb incremental backup

2017-08-13 Thread siranee . ja
Hi "A L", Thank you very much for your suggestion. I've got it. It work properly right now. what I have done are following. mv all current mysql and snapshot mysql to mbroken and mbroken_yymmddhhmm btrfs subvolume snapshot mbroken to mysql (to make it rw subvolume without Recieve UUID) btrfs sub

Re: btrfs issue with mariadb incremental backup

2017-08-13 Thread siranee . ja
Hi "A L", As your suggestion. Does it mean I have to make all my current subvolumes to clear "Receive UUID" and send them with full snapshots? >> mysql >> mysql_201708060830 >> mysql_201708070830 >>

Re: btrfs issue with mariadb incremental backup

2017-08-13 Thread siranee . ja
Hi "A L", [root@backuplogC7 ~]# btrfs sub show /var/lib/mariadb/mysql /var/lib/mariadb/mysql Name: mysql UUID: 92f319c5-e132-3249-9b13-d39ee77a2b44 Parent UUID:- Received UUID: 3ad0334a-4063-654c-add6-b1cbcdea

Re: btrfs issue with mariadb incremental backup

2017-08-13 Thread siranee . ja
Hi Chris, 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. Yes, It's di

Re: btrfs issue with mariadb incremental backup

2017-08-12 Thread siranee . ja
Hi Chris, I started as your suggestion again. The diff occured since snapshot mysql_201708090830 manually send. What should I do next? - delete all the bad/mismatching snapshots only on the destination computer. [root@joytest ~]# date Sun Aug 13 10:27:23 ICT 2017 [root@joytest ~]# cd /var/lib/mar

Re: btrfs issue with mariadb incremental backup

2017-08-12 Thread siranee . ja
Hi Chris, I did as you suggest and the result was bad then I decided to start over with snapshot mysql_201708070830 and manually send incremental the result rsync always said "a log diff" but the dest can start mariadb until snapshot "mysql_201708100830" it couldn't start mariadb. The following

Re: btrfs issue with mariadb incremental backup

2017-08-11 Thread siranee . ja
Hi Chris, Sorry for the misunderstanding and inappropriate attached the file (I thought that too long text in the mail message so I used the attached file). The backup script has the btrfs sync command since Aug 3 I sent the following rsync command as you said (sorry for the misunderstanding wi

Re: btrfs issue with mariadb incremental backup

2017-08-11 Thread siranee . ja
Hi Chris, I explain what I have done in the attached file. Please suggest me what I should do next? I plan to reproduce the data mannually for the daily inserted data to check the detail step by step to know exactly which steps make the btrfs send /receive result diff on the Second box (Machine

Re: btrfs issue with mariadb incremental backup

2017-08-10 Thread siranee . ja
Sorry Chris, I forgot to send the diff from rsync -anc result the source container A start data as data on snapshot mysql_201708040830 [root@backuplogC7 tmp]# ls -l /var/lib/mariadb total 0 drwxrwxr-x+ 1 mysql mysql 260 Aug 4 13:10 mysql drwxrwxr-x+ 1 mysql mysql 260 Jul 12 08:29 mysql_2017080

Re: btrfs issue with mariadb incremental backup

2017-08-10 Thread siranee . ja
Hi Chris, The kernel version that I test is "4.4.0-89-generic" as I tested on ubuntu lxd If I want to change the kernel version I have to upgrade the host box. As you suggest the rsync to compare the subvolumes. I found the point. the subvolumes are different only after I start to del old subvol

Re: btrfs issue with mariadb incremental backup

2017-08-09 Thread siranee . ja
I'll test and response the result to you soon. I have another question about the combination within Host lxd ubuntu and lxd container centos Host Machine X (16.04.3 LTS with lxd 2.0.10 and btrfs-progs v4.4 kernel 4.4 ) set 1 lvm raw partitions and format to btrfs filesystem (on host) Partition A

Re: btrfs issue with mariadb incremental backup

2017-08-08 Thread siranee . ja
Hi Chris, Sorry for the incompleted command that I used in the post. This is the real command from Machine A backup step : in crontab 30 08 * * * root /root/script/backup/backupsnap.sh root password /var/lib/mariadb/mysql [root@backuplogC7 ~]# cat /root/script/backup/backupsnap.sh #Backup # u

btrfs issue with mariadb incremental backup

2017-08-08 Thread siranee . ja
Hi btrfs support team, My name is siranee jaraswachirakul. I tested btrfs incremental send and receive and I found something incorrect. I posted detail in the url http://www.linuxquestions.org/questions/showthread.php?p=5746238#post5746238 Could you please help me to find the reason? Best Reg