# (SQLite?) When server scans library clients unusable

**URL:** <https://forums.plex.tv/t/sqlite-when-server-scans-library-clients-unusable/809595>\
**Category:** Plex Media Server\
**Tags:** server-windows, android-tv, player-windows\
**Created:** [September 5, 2022, 11:33pm UTC](https://forums.plex.tv/t/sqlite-when-server-scans-library-clients-unusable/809595 "2022-09-05T23:33:02Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Cutha](https://avatars.discourse-cdn.com/v4/letter/c/cc9497/32.png) [@Cutha](https://forums.plex.tv/u/Cutha)\
**Post date:** [September 5, 2022, 11:33pm UTC](https://forums.plex.tv/t/sqlite-when-server-scans-library-clients-unusable/809595/1 "2022-09-05T23:33:02Z")

</div>

Server Version#: 1.28.2.6151  
Player Version#: Any

Server:  
Ryzen 7 5800X  
32GB RAM Available (after RAM disk for scratch is allocated)  
Dedicated EVO 970 Plus 2TB for metadata  
40Gb Ethernet connection to storage server  
1Gb Up/Down internet connection for clients

When my server does a library scan initiated manually or by schedule the clients become unusable, whatever is playing craps out and browsing the library is wickedly slow and going into a show or movie doesn’t show anything and sometimes displays an error.

I have had 8 clients connected to the server without any issues however a library scan renders it unusable for even one client. I have tested from the server and while it is scanning browsing the library is unusable.

During scanning the CPU averages a few % with short peaks of 20%, RAM usage is \< 10GB, disk average active time \< 1%.

I don’t know what to do to resolve this, any ideas? Thanks.

Error that shows up sometimes when browsing library while a scan is happening.

 ![Browse error when scanning](https://global.discourse-cdn.com/plex/original/4X/6/9/8/69891047801998d9fff09be1b849a9b8a31864ac.jpeg)

---

<div class="post-metadata">

**Author:** ![Cutha](https://avatars.discourse-cdn.com/v4/letter/c/cc9497/32.png) [@Cutha](https://forums.plex.tv/u/Cutha)\
**Post date:** [September 6, 2022, 10:46pm UTC](https://forums.plex.tv/t/sqlite-when-server-scans-library-clients-unusable/809595/2 "2022-09-06T22:46:24Z")

</div>

User \_plx\_svr seems to have had the same [issue {plex-scanner-drops-plex-media-server-cpu-usage-to-0-and-kicks-clients-off}](https://forums.plex.tv/t/plex-scanner-drops-plex-media-server-cpu-usage-to-0-and-kicks-clients-off/686410).

Looking at the logs it seems that after the scanner is complete is when the client playback and browsing issues occur. I’m guessing it’s an issue with the SQLite db.

15:56:24 … completed 100.0% - Scanning Movies

~15:56:35 is when I skipped back 10 seconds and the client errored out and after that I tried browsing shows on the server and it gave me the “Something went wrong” error message.

After about another minute everything went back to working normally.

For these logs I stopped the plex server, restarted it, waited a minute or so for the web interface to become responsive and then I manually started a scan of Movies.

I hope this is not expected behavior, is anybody else having this issue?  
[Plex Media Server Logs\_2022-09-06\_15-58-21.zip](https://forums.plex.tv/uploads/short-url/s1SadDWKYF41IKwo5pXFkWcFNQn.zip) (511.9 KB)

I also did a “PRAGMA integrity\_check;” and the result was “ok”.

---

<div class="post-metadata">

**Author:** ![OttoKerner](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/ottokerner/32/10079_2.png) [@OttoKerner](https://forums.plex.tv/u/OttoKerner)\
**Post date:** [September 7, 2022, 7:53am UTC](https://forums.plex.tv/t/sqlite-when-server-scans-library-clients-unusable/809595/3 "2022-09-07T07:53:26Z")

</div>

After extensive changes in the DB, the server will perform a “vaccum” of the DB file. This operation should only take a short time. And yes, during this operation, the server may not respond to client requests.

---

<div class="post-metadata">

**Author:** ![Cutha](https://avatars.discourse-cdn.com/v4/letter/c/cc9497/32.png) [@Cutha](https://forums.plex.tv/u/Cutha)\
**Post date:** [September 7, 2022, 3:03pm UTC](https://forums.plex.tv/t/sqlite-when-server-scans-library-clients-unusable/809595/4 "2022-09-07T15:03:40Z")

</div>

Good to know. I have the same behaviour I described even when there are no charges to the DB,. If I run the scan for a second time a couple minutes after its complete it will become unusable again, same as before.

---

<div class="post-metadata">

**Author:** ![OttoKerner](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/ottokerner/32/10079_2.png) [@OttoKerner](https://forums.plex.tv/u/OttoKerner)\
**Post date:** [September 7, 2022, 3:09pm UTC](https://forums.plex.tv/t/sqlite-when-server-scans-library-clients-unusable/809595/5 "2022-09-07T15:09:44Z")

</div>

I’m told that server version 1.29.1 could bring a fix which might be related to this.

---

<div class="post-metadata">

**Author:** ![Cutha](https://avatars.discourse-cdn.com/v4/letter/c/cc9497/32.png) [@Cutha](https://forums.plex.tv/u/Cutha)\
**Post date:** [September 7, 2022, 6:11pm UTC](https://forums.plex.tv/t/sqlite-when-server-scans-library-clients-unusable/809595/6 "2022-09-07T18:11:04Z")

</div>

Thanks for the information and for your time. Do you happen to know if that update is being published soon? As you mention fix, is there an acknowledged bug report for this issue?

---

<div class="post-metadata">

**Author:** ![OttoKerner](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/ottokerner/32/10079_2.png) [@OttoKerner](https://forums.plex.tv/u/OttoKerner)\
**Post date:** [September 8, 2022, 10:27am UTC](https://forums.plex.tv/t/sqlite-when-server-scans-library-clients-unusable/809595/7 "2022-09-08T10:27:14Z")

</div>

I am not able to tell release dates.  
The bug tracker is not publicly accessible.

---

<div class="post-metadata">

**Author:** ![Cutha](https://avatars.discourse-cdn.com/v4/letter/c/cc9497/32.png) [@Cutha](https://forums.plex.tv/u/Cutha)\
**Post date:** [September 29, 2022, 12:42am UTC](https://forums.plex.tv/t/sqlite-when-server-scans-library-clients-unusable/809595/8 "2022-09-29T00:42:19Z")

</div>

I just updated to version 1.29.0.6244 as it noted under bug fixes:

- (Butler) The server could become unresponsive during database optimization (#13820)

The issues is significantly worse now.

---

<div class="post-metadata">

**Author:** ![Cutha](https://avatars.discourse-cdn.com/v4/letter/c/cc9497/32.png) [@Cutha](https://forums.plex.tv/u/Cutha)\
**Post date:** [September 29, 2022, 1:27am UTC](https://forums.plex.tv/t/sqlite-when-server-scans-library-clients-unusable/809595/9 "2022-09-29T01:27:16Z")

</div>

Updated to the 64 bit version, Version 1.29.1.6260, issue is still there.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/plex/original/3X/2/a/2acb9765406f63293d357b4ec509ec39aa28f2ad.png) [@system](https://forums.plex.tv/u/system)\
**Post date:** [December 28, 2022, 1:28am UTC](https://forums.plex.tv/t/sqlite-when-server-scans-library-clients-unusable/809595/10 "2022-12-28T01:28:17Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.