# pt-archiver gets stopped everytime the souce table receieves DMLs

**URL:** https://forums.percona.com/t/pt-archiver-gets-stopped-everytime-the-souce-table-receieves-dmls/7663
**Category:** Percona Toolkit
**Created:** [June 4, 2020, 3:00am UTC](https://forums.percona.com/t/pt-archiver-gets-stopped-everytime-the-souce-table-receieves-dmls/7663 "2020-06-04T03:00:56Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Milind](https://avatars.discourse-cdn.com/v4/letter/m/7bcc69/32.png) [@Milind](https://forums.percona.com/u/Milind)
#### Post date: [June 4, 2020, 3:00am UTC](https://forums.percona.com/t/pt-archiver-gets-stopped-everytime-the-souce-table-receieves-dmls/7663/1 "2020-06-04T03:00:56Z")

</div>

Hi Percona Team  
&nbsp;Actually i need to know if pt-archiver can wait if the source tables have any queries running on it and then once the DMLs are complete on source table, will it resume the process ahead from same position or will it start new?  
pt-archiver --source h=127.0.0.1,P=3306,D= **,t=tbl1,u=** \*\*_,p=\*\*\*\*\*\*\*\* --where "LAST\_UPD\_DT \> ‘2018-06-02’ " --dest h=127.0.0.1,P=3306,u= **,p=** _,D=\*\*\*\*\*,t=tbl2–limit=50000 --ignore --progress 100000 --no-delete --max-lag=300s --sleep=1 --statistics  
  
So, here if tbl1 has some bulk DMLs running on it for few hours then will it wait until those transactions are complete or will it come out?  
  
For my case it failed because i have not used retries.  
  
Also, if I use retries then at what intervals it retries? After the DMLs on source tables are complete then will it start copying from the position from where it was stopped or will it start copying from the start?  
  
Also even if putting thousand retries does not help then running pt-archiver again will start copying from the start or it will start from the last failed state.&nbsp;  
  
Regards,&nbsp;  
Milind&nbsp;  
  
&nbsp;&nbsp;

---

<div class="post-metadata">

### Author: ![carlos.salguero](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/carlos.salguero/32/20_2.png) [@carlos.salguero](https://forums.percona.com/u/carlos.salguero)
#### Post date: [June 7, 2020, 5:09pm UTC](https://forums.percona.com/t/pt-archiver-gets-stopped-everytime-the-souce-table-receieves-dmls/7663/2 "2020-06-07T17:09:48Z")

</div>

Hello,   
Could you please clarify what are you trying to achieve and what’s the error you are receiving?  
It would be awesome if you can provide a way to reproduce the issue.Regards