# Log file not generating

**URL:** <https://forums.percona.com/t/log-file-not-generating/34136>\
**Category:** MySQL & MariaDB\
**Created:** [October 4, 2024, 4:48pm UTC](https://forums.percona.com/t/log-file-not-generating/34136 "2024-10-04T16:48:49Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![SumitKumar](https://avatars.discourse-cdn.com/v4/letter/s/b77776/32.png) [@SumitKumar](https://forums.percona.com/u/SumitKumar)\
**Post date:** [October 4, 2024, 4:48pm UTC](https://forums.percona.com/t/log-file-not-generating/34136/1 "2024-10-04T16:48:49Z")

</div>

Hi ,

We run the Percona Script but it is running from last 4 hours and no records is Archiving from table and no error is showing also  
Script is continuously running without archive any record . please help with the solution

---

<div class="post-metadata">

**Author:** ![SumitKumar](https://avatars.discourse-cdn.com/v4/letter/s/b77776/32.png) [@SumitKumar](https://forums.percona.com/u/SumitKumar)\
**Post date:** [October 4, 2024, 5:18pm UTC](https://forums.percona.com/t/log-file-not-generating/34136/2 "2024-10-04T17:18:45Z")

</div>

Percon script

pt-archiver --source h=localhost,u=_ **,p='** _',D=BidCplusN,t=bid\_details --where “bd\_bid\_id in (select b\_id from bids join bid\_attributes on b\_id = ba\_bid\_id where ba\_created\_on \<= ‘2024-03-20 00:00:00’ and b\_status=0)” --no-check-charset --limit=5000 --commit-each --file /db\_archive/DraftArchive\_before\_20032024/%Y-%m-%d-%D.%t 2\>\> /db\_archive/DraftArchive\_before\_20032024/arch.err

---

<div class="post-metadata">

**Author:** ![Yunus](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/yunus/32/6430_2.png) [@Yunus](https://forums.percona.com/u/Yunus)\
**Post date:** [October 5, 2024, 1:29am UTC](https://forums.percona.com/t/log-file-not-generating/34136/3 "2024-10-05T01:29:23Z")

</div>

Do you see anything in file?  
Or anything in processlist that the user is running?  
You can also use dry run to check what query it would use to archive.

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [October 7, 2024, 2:00pm UTC](https://forums.percona.com/t/log-file-not-generating/34136/4 "2024-10-07T14:00:12Z")

</div>

> [@SumitKumar](#):
>
> pt-archiver

Hey @SumitKumar,  
Try running like this `PTDEBUG=1 pt-archiver ...` to see what it is doing. That might give you a clue.