# DBRepair development

**URL:** <https://forums.plex.tv/t/dbrepair-development/822684>\
**Category:** Apps & Creations\
**Created:** [December 14, 2022, 3:57am UTC](https://forums.plex.tv/t/dbrepair-development/822684 "2022-12-14T03:57:23Z")\
**Posts on this page:** 20\
**Page:** 29

<div class="post-metadata">

**Author:** ![SE56](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/se56/32/222425_2.png) [@SE56](https://forums.plex.tv/u/SE56)\
**Post date:** [March 28, 2025, 2:25am UTC](https://forums.plex.tv/t/dbrepair-development/822684/615 "2025-03-28T02:25:20Z")

</div>

Well you have excelled yourself, after that Terminal Command it talks to me. `STOP, AUTO, START, EXIT.` I near fell off my chair. 🤣

---

<div class="post-metadata">

**Author:** ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)\
**Post date:** [March 28, 2025, 2:36am UTC](https://forums.plex.tv/t/dbrepair-development/822684/616 "2025-03-28T02:36:35Z")

</div>

Pobody’s Nerfect

😛

---

<div class="post-metadata">

**Author:** ![SE56](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/se56/32/222425_2.png) [@SE56](https://forums.plex.tv/u/SE56)\
**Post date:** [March 28, 2025, 3:00am UTC](https://forums.plex.tv/t/dbrepair-development/822684/617 "2025-03-28T03:00:39Z")

</div>

I’m putting it down to `Apple Intelligence` more rubbish. 🤨

---

<div class="post-metadata">

**Author:** ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)\
**Post date:** [March 28, 2025, 3:13am UTC](https://forums.plex.tv/t/dbrepair-development/822684/618 "2025-03-28T03:13:12Z")

</div>

ok, so really, wth did I do wrong?

---

<div class="post-metadata">

**Author:** ![SE56](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/se56/32/222425_2.png) [@SE56](https://forums.plex.tv/u/SE56)\
**Post date:** [March 28, 2025, 3:17am UTC](https://forums.plex.tv/t/dbrepair-development/822684/619 "2025-03-28T03:17:15Z")

</div>

An update on MacOS with Apple Intelligence introduction. It’s optional so I will check out by disabling later. If the sound not up you would never know.

---

<div class="post-metadata">

**Author:** ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)\
**Post date:** [March 28, 2025, 3:29am UTC](https://forums.plex.tv/t/dbrepair-development/822684/620 "2025-03-28T03:29:59Z")

</div>

Maybe you should record what it says and share it?

---

<div class="post-metadata">

**Author:** ![Volts](https://avatars.discourse-cdn.com/v4/letter/v/a5b964/32.png) [@Volts](https://forums.plex.tv/u/Volts)\
**Post date:** [March 29, 2025, 5:56pm UTC](https://forums.plex.tv/t/dbrepair-development/822684/621 "2025-03-29T17:56:04Z")

</div>

It’s been there for almost a year. In AppleScript `say` means “speak out loud”.

```auto
sayStarted() { [$HapticOkay -eq 1] && osascript -e 'say "started"'; }
sayStopped() { [$HapticOkay -eq 1] && osascript -e 'say "Its stopped"'; }

```

---

<div class="post-metadata">

**Author:** ![SE56](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/se56/32/222425_2.png) [@SE56](https://forums.plex.tv/u/SE56)\
**Post date:** [March 29, 2025, 6:31pm UTC](https://forums.plex.tv/t/dbrepair-development/822684/622 "2025-03-29T18:31:24Z")

</div>

Never noticed as i have the Sound turned down mostly. Thanks for the insight Volts

---

<div class="post-metadata">

**Author:** ![plexmei](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/plexmei/32/255262_2.png) [@plexmei](https://forums.plex.tv/u/plexmei)\
**Post date:** [April 13, 2025, 12:13pm UTC](https://forums.plex.tv/t/dbrepair-development/822684/623 "2025-04-13T12:13:55Z")

</div>

your tool is amazing chuckpa. ty very much for your work.  
on a new plex server with a lot of files and 1gb database cache size, it took \>6 seconds to load a movie page when it is part of a movie collection. now it takes 3 seconds

---

<div class="post-metadata">

**Author:** ![ChristianKent](https://avatars.discourse-cdn.com/v4/letter/c/f17d59/32.png) [@ChristianKent](https://forums.plex.tv/u/ChristianKent)\
**Post date:** [May 8, 2025, 11:06am UTC](https://forums.plex.tv/t/dbrepair-development/822684/624 "2025-05-08T11:06:51Z")

</div>

Not sure if it was already discussed, but does the “auto” completely do all the things that “Optimize Database” in Plex does? So, after running this, it would be pointless to run “Optimize Database”?

---

<div class="post-metadata">

**Author:** ![Insomnic\_1](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/insomnic_1/32/215416_2.png) [@Insomnic\_1](https://forums.plex.tv/u/Insomnic_1)\
**Post date:** [May 8, 2025, 2:39pm UTC](https://forums.plex.tv/t/dbrepair-development/822684/625 "2025-05-08T14:39:52Z")

</div>

Yup. Auto takes care of that part too.

I keep this marked as it does a good job covering things a bit better than digging through this particular thread sometimes: [GitHub - ChuckPa/PlexDBRepair: Database repair utility for Plex Media Server databases](https://github.com/ChuckPa/PlexDBRepair)

I don’t use the tool that often and ChuckPa maintains that really well so I always go back to it when I need to update and run it again to make sure I’m doing the right stuff. 🙂

---

<div class="post-metadata">

**Author:** ![sdjme](https://avatars.discourse-cdn.com/v4/letter/s/e9bcb4/32.png) [@sdjme](https://forums.plex.tv/u/sdjme)\
**Post date:** [May 19, 2025, 2:08am UTC](https://forums.plex.tv/t/dbrepair-development/822684/626 "2025-05-19T02:08:38Z")

</div>

I recently started getting Plex crashes with an error in the container of:

`Sqlite3: Sleeping for 200ms to retry busy DB.`

Did some searching and came across this script. Awesome! Executed ‘automatic’ within the container (LSIO on unraid) and it just sits there. I’ve let it run for 5+ minutes before control-c.

```auto
Enter command # -or- command name (4 char min) : automatic

Automatic Check,Repair,Index started.

Checking the PMS databases

```

In looking at some people’s screenshots with timestamps, it looks like that first part should take a couple of seconds. Am I just impatient and I need to let this run for tens of minutes, or am I running into some strange issue?

Thanks!

Edited: After about 20 minutes of waiting it seems to have progressed (with OKs)! I guess I’m just impatient!

---

<div class="post-metadata">

**Author:** ![jfreiman](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/jfreiman/32/82584_2.png) [@jfreiman](https://forums.plex.tv/u/jfreiman)\
**Post date:** [May 19, 2025, 5:30am UTC](https://forums.plex.tv/t/dbrepair-development/822684/627 "2025-05-19T05:30:30Z")

</div>

> [@sdjme](#):
>
> Am I just impatient and I need to let this run for tens of minutes, or am I running into some strange issue?

I just rain this on my Windows complete last night and it took exactly 59 minutes to complete on a gen4 SSD.

---

<div class="post-metadata">

**Author:** ![jfreiman](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/jfreiman/32/82584_2.png) [@jfreiman](https://forums.plex.tv/u/jfreiman)\
**Post date:** [May 21, 2025, 4:55am UTC](https://forums.plex.tv/t/dbrepair-development/822684/628 "2025-05-21T04:55:11Z")

</div>

I just deleted nearly 1,000 bif.tmp files in the \Media\localhost\ folders totaling nearly 1TB in size which got me thinking.

Can you create a function similar to Purge that would remove unused/orphaned bif files?

If over the years I’ve accumulated this many tmp files, potentially, how many bif files remain for videos that have been deleted or moved?

that was a lot of space I recovered and the only reason I noticed was because my backup was so much less than the original (only files excluded were .tmp)

---

<div class="post-metadata">

**Author:** ![Tony\_T](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/tony_t/32/311528_2.png) [@Tony\_T](https://forums.plex.tv/u/Tony_T)\
**Post date:** [May 23, 2025, 11:11am UTC](https://forums.plex.tv/t/dbrepair-development/822684/629 "2025-05-23T11:11:00Z")

</div>

For the past 2 updates, entering only 88 to check for updates on **Ubuntu** prints a long list of (all?) prior versions.

Also, entering only 88 when there is no updates available will ask _Ok to remove temporary databases/workfiles for this session?_ Not sure if this is intended.

---

<div class="post-metadata">

**Author:** ![ChristianKent](https://avatars.discourse-cdn.com/v4/letter/c/f17d59/32.png) [@ChristianKent](https://forums.plex.tv/u/ChristianKent)\
**Post date:** [May 23, 2025, 11:31am UTC](https://forums.plex.tv/t/dbrepair-development/822684/630 "2025-05-23T11:31:52Z")

</div>

> [@sdjme](#):
>
> I recently started getting Plex crashes with an error in the container of:
> 
> `Sqlite3: Sleeping for 200ms to retry busy DB.`

That’s not a crash. That’s your database being overloaded currently. You can wait until it eases up, or you can terminate PMS (should be your last choice).

---

<div class="post-metadata">

**Author:** ![FordGuy61](https://avatars.discourse-cdn.com/v4/letter/f/22d042/32.png) [@FordGuy61](https://forums.plex.tv/u/FordGuy61)\
**Post date:** [May 23, 2025, 2:47pm UTC](https://forums.plex.tv/t/dbrepair-development/822684/631 "2025-05-23T14:47:37Z")

</div>

@Tony_T

Fixed in latest version, .06.

You should be able to answer Y after the entering 88 and the extra info is displayed.

---

<div class="post-metadata">

**Author:** ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)\
**Post date:** [May 23, 2025, 11:39pm UTC](https://forums.plex.tv/t/dbrepair-development/822684/632 "2025-05-23T23:39:12Z")

</div>

# ALL:

Pursuant to Plex, inc. Trademark policy, the current name is in violation of that policy.

I will be renaming the tool.

---

<div class="post-metadata">

**Author:** ![SE56](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/se56/32/222425_2.png) [@SE56](https://forums.plex.tv/u/SE56)\
**Post date:** [May 23, 2025, 11:51pm UTC](https://forums.plex.tv/t/dbrepair-development/822684/633 "2025-05-23T23:51:22Z")

</div>

> [@ChuckPa](#):
>
> Pursuant

I hope it’s not `Chucks Tool`. 🤣

Thank goodness: [GitHub - ChuckPa/DBRepair: Database repair utility for Plex Media Server databases](https://github.com/ChuckPa/DBRepair)

---

<div class="post-metadata">

**Author:** ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)\
**Post date:** [May 24, 2025, 12:05am UTC](https://forums.plex.tv/t/dbrepair-development/822684/634 "2025-05-24T00:05:45Z")

</div>

Version 1.11.00 has been hatched.

Same crusty author.  
Same crabby style.

With some actual bug fixes this time! 🤣

 ![Screenshot from 2025-05-23 20-04-02](https://global.discourse-cdn.com/plex/original/4X/4/d/e/4de482ab19e9fea4b423d7a86f0c0c739920529e.png)

I fixed the tag overflow when updating.

[Previous page](https://forums.plex.tv/t/dbrepair-development/822684.md?page=28)

[Next page](https://forums.plex.tv/t/dbrepair-development/822684.md?page=30)
