# Xtrabackup prepare show Waiting for change buffer merge to complete

**URL:** <https://forums.percona.com/t/xtrabackup-prepare-show-waiting-for-change-buffer-merge-to-complete/32523>\
**Category:** Percona XtraBackup\
**Tags:** mysql, percona, new-release\
**Created:** [August 23, 2024, 2:15am UTC](https://forums.percona.com/t/xtrabackup-prepare-show-waiting-for-change-buffer-merge-to-complete/32523 "2024-08-23T02:15:39Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![javaPope](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/javapope/32/16986_2.png) [@javaPope](https://forums.percona.com/u/javaPope)\
**Post date:** [August 23, 2024, 2:15am UTC](https://forums.percona.com/t/xtrabackup-prepare-show-waiting-for-change-buffer-merge-to-complete/32523/1 "2024-08-23T02:15:39Z")

</div>

My backup was made on the MySQL slave database. When I was preparing the backup file, it prompted “start shutdown”, and then it has been showing “Waiting for change buffer merge to complete number of bytes of change buffer”, but this number keeps increasing and decreasing. I suspect whether it is still synchronizing with the master database during the prepare process.  
Here are note info:  
2024-07-30T17:43:28.535402+08:00 0 [Note] [MY-013072] [InnoDB] Starting shutdown…  
2024-07-30T17:44:28.536153+08:00 0 [Note] [MY-012874] [InnoDB] Waiting for change buffer merge to complete number of bytes of change buffer just merged: 26059  
2024-07-30T17:45:02.912677+08:00 0 [Note] [MY-013073] [InnoDB] Waiting for master to exit.  
2024-07-30T17:45:28.536472+08:00 0 [Note] [MY-012874] [InnoDB] Waiting for change buffer merge to complete number of bytes of change buffer just merged: 25672  
2024-07-30T17:46:28.536851+08:00 0 [Note] [MY-012874] [InnoDB] Waiting for change buffer merge to complete number of bytes of change buffer just merged: 25046  
2024-07-30T17:46:37.242152+08:00 0 [Note] [MY-013073] [InnoDB] Waiting for master to exit.  
2024-07-30T17:47:28.537042+08:00 0 [Note] [MY-012874] [InnoDB] Waiting for change buffer merge to complete number of bytes of change buffer just merged: 24800  
2024-07-30T17:48:11.466264+08:00 0 [Note] [MY-013073] [InnoDB] Waiting for master to exit.  
2024-07-30T17:48:28.537710+08:00 0 [Note] [MY-012874] [InnoDB] Waiting for change buffer merge to complete number of bytes of change buffer just merged: 26506  
2024-07-30T17:49:28.537857+08:00 0 [Note] [MY-012874] [InnoDB] Waiting for change buffer merge to complete number of bytes of change buffer just merged: 26222  
2024-07-30T17:49:45.659260+08:00 0 [Note] [MY-013073] [InnoDB] Waiting for master to exit.  
2024-07-30T17:50:28.538629+08:00 0 [Note] [MY-012874] [InnoDB] Waiting for change buffer merge to complete number of bytes of change buffer just merged: 26147  
2024-07-30T17:51:19.890650+08:00 0 [Note] [MY-013073] [InnoDB] Waiting for master to exit.  
2024-07-30T17:51:28.539107+08:00 0 [Note] [MY-012874] [InnoDB] Waiting for change buffer merge to complete number of bytes of change buffer just merged: 24990  
2024-07-30T17:52:28.539204+08:00 0 [Note] [MY-012874] [InnoDB] Waiting for change buffer merge to complete number of bytes of change buffer just merged: 26118  
2024-07-30T17:52:54.088733+08:00 0 [Note] [MY-013073] [InnoDB] Waiting for master to exit.  
2024-07-30T17:53:28.539744+08:00 0 [Note] [MY-012874] [InnoDB] Waiting for change buffer merge to complete number of bytes of change buffer just merged: 26763  
2024-07-30T17:54:28.304980+08:00 0 [Note] [MY-013073] [InnoDB] Waiting for master to exit.  
2024-07-30T17:54:28.540255+08:00 0 [Note] [MY-012874] [InnoDB] Waiting for change buffer merge to complete number of bytes of change buffer just merged: 25321  
2024-07-30T17:55:28.540414+08:00 0 [Note] [MY-012874] [InnoDB] Waiting for change buffer merge to complete number of bytes of change buffer just merged: 26119  
2024-07-30T17:56:02.526305+08:00 0 [Note] [MY-013073] [InnoDB] Waiting for master to exit.  
2024-07-30T17:56:28.541092+08:00 0 [Note] [MY-012874] [InnoDB] Waiting for change buffer merge to complete number of bytes of change buffer just merged: 26168  
2024-07-30T17:57:28.541436+08:00 0 [Note] [MY-012874] [InnoDB] Waiting for change buffer merge to complete number of bytes of change buffer just merged: 24441  
2024-07-30T17:57:36.744417+08:00 0 [Note] [MY-013073] [InnoDB] Waiting for master to exit.  
2024-07-30T17:58:28.541860+08:00 0 [Note] [MY-012874] [InnoDB] Waiting for change buffer merge to complete number of bytes of change buffer just merged: 25650