# Would it be possible to get some help with -\[Req#a34/Database optimization/com.plexapp.plugins.libra **URL:** \ **Category:** Remote Access\ **Tags:** server-synology, media-optimizer\ **Created:** [May 31, 2023, 4:37am UTC](https://forums.plex.tv/t/would-it-be-possible-to-get-some-help-with-req-a34-database-optimization-com-plexapp-plugins-libra/842954 "2023-05-31T04:37:10Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![mdreed72](https://avatars.discourse-cdn.com/v4/letter/m/9f8e36/32.png) [@mdreed72](https://forums.plex.tv/u/mdreed72)\ **Post date:** [May 31, 2023, 4:37am UTC](https://forums.plex.tv/t/would-it-be-possible-to-get-some-help-with-req-a34-database-optimization-com-plexapp-plugins-libra/842954/1 "2023-05-31T04:37:10Z")
Server Version#:1.32.3.7089-7000 Player Version#:Beta Would anyone be able to help me with this error I get while optimizing? [Req#a34/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x7f995e7100, 17, statement aborts at 58: [select \* from metadata\_items limit 1] database schema has changed Everything runs fine. It’s just slow and I would like to optimize it. If I have to start over, can I keep my thumbnails, playlists and collections? [Plex Media Server Logs\_2023-05-30\_23-26-03.zip](https://forums.plex.tv/uploads/short-url/k6YP1Y1rjOpWnqCz58E5ZmTcy33.zip) (5.0 MB) Thanks! ---
**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 31, 2023, 5:04am UTC](https://forums.plex.tv/t/would-it-be-possible-to-get-some-help-with-req-a34-database-optimization-com-plexapp-plugins-libra/842954/2 "2023-05-31T05:04:28Z")
Can you handle a little command line work with Putty/SSH into the synology command line ? > **[GitHub - ChuckPa/PlexDBRepair: Database repair utility for Plex Media Server...](https://github.com/ChuckPa/PlexDBRepair)** > > Database repair utility for Plex Media Server databases - GitHub - ChuckPa/PlexDBRepair: Database repair utility for Plex Media Server databases ---
**Author:** ![mdreed72](https://avatars.discourse-cdn.com/v4/letter/m/9f8e36/32.png) [@mdreed72](https://forums.plex.tv/u/mdreed72)\ **Post date:** [May 31, 2023, 5:16am UTC](https://forums.plex.tv/t/would-it-be-possible-to-get-some-help-with-req-a34-database-optimization-com-plexapp-plugins-libra/842954/3 "2023-05-31T05:16:31Z")
I have not done it before. Are the directions good? If they are, I can try and pull it off! I’ll try anything! ---
**Author:** ![mdreed72](https://avatars.discourse-cdn.com/v4/letter/m/9f8e36/32.png) [@mdreed72](https://forums.plex.tv/u/mdreed72)\ **Post date:** [May 31, 2023, 5:18am UTC](https://forums.plex.tv/t/would-it-be-possible-to-get-some-help-with-req-a34-database-optimization-com-plexapp-plugins-libra/842954/4 "2023-05-31T05:18:41Z")
Would I install the github server and download the software through that? ---
**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 31, 2023, 5:59am UTC](https://forums.plex.tv/t/would-it-be-possible-to-get-some-help-with-req-a34-database-optimization-com-plexapp-plugins-libra/842954/5 "2023-05-31T05:59:38Z")
don’t overcomplicate it. download the file using your browser. copy it to the NAS I show where to put it and then what to do in the README.md (hint: Put it at the very top of the Plex or PlexMediaServer shared folder) ---
**Author:** ![mdreed72](https://avatars.discourse-cdn.com/v4/letter/m/9f8e36/32.png) [@mdreed72](https://forums.plex.tv/u/mdreed72)\ **Post date:** [May 31, 2023, 4:09pm UTC](https://forums.plex.tv/t/would-it-be-possible-to-get-some-help-with-req-a34-database-optimization-com-plexapp-plugins-libra/842954/6 "2023-05-31T16:09:19Z")
Im going to try it now! ---
**Author:** ![mdreed72](https://avatars.discourse-cdn.com/v4/letter/m/9f8e36/32.png) [@mdreed72](https://forums.plex.tv/u/mdreed72)\ **Post date:** [May 31, 2023, 5:45pm UTC](https://forums.plex.tv/t/would-it-be-possible-to-get-some-help-with-req-a34-database-optimization-com-plexapp-plugins-libra/842954/7 "2023-05-31T17:45:18Z")
Hi I did everything and it was successful! or “ok”! I like to be pushed out of my comfort zone. I had not done that before and now I have a “little” better understanding of what goes on behind the curtains! Thank you. super cool tool! I go to run PMS and it starts to run and then quits to “manually stopped”. I have tried to hit run like 6 times and it wont work. I removed the repair tool files after the first fail. Do i need to redo iit? Thanks again Mike ---
**Author:** ![mdreed72](https://avatars.discourse-cdn.com/v4/letter/m/9f8e36/32.png) [@mdreed72](https://forums.plex.tv/u/mdreed72)\ **Post date:** [May 31, 2023, 7:52pm UTC](https://forums.plex.tv/t/would-it-be-possible-to-get-some-help-with-req-a34-database-optimization-com-plexapp-plugins-libra/842954/8 "2023-05-31T19:52:44Z")
@ChuckPa - It’s refusing connection. I went back in through the tool and did it all again. this time I hit 7 to have it run and then “exit”. I have checked every setting and I tried to connect locally (manually). I’m afraid to stop it for that it won’t start. ![image](https://global.discourse-cdn.com/plex/original/4X/4/8/7/487c05fb00740f4ef2fb5a59efd9ce92e975cab8.png) ---
**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 31, 2023, 10:05pm UTC](https://forums.plex.tv/t/would-it-be-possible-to-get-some-help-with-req-a34-database-optimization-com-plexapp-plugins-libra/842954/9 "2023-05-31T22:05:33Z")
That’s telling you (in web browser fashion) the server didn’t start Open the PlexMediaServer shared folder Go to AppData/Plex Media Server Right-click “Logs” → “Compress to Logs.zip” download the zip and attach here ---
**Author:** ![mdreed72](https://avatars.discourse-cdn.com/v4/letter/m/9f8e36/32.png) [@mdreed72](https://forums.plex.tv/u/mdreed72)\ **Post date:** [June 1, 2023, 12:23am UTC](https://forums.plex.tv/t/would-it-be-possible-to-get-some-help-with-req-a34-database-optimization-com-plexapp-plugins-libra/842954/10 "2023-06-01T00:23:03Z")
[Logs.zip](https://forums.plex.tv/uploads/short-url/pnthUeSlDZy4cQXNNR4g2xFoVkb.zip) (1.5 MB) ---
**Author:** ![mdreed72](https://avatars.discourse-cdn.com/v4/letter/m/9f8e36/32.png) [@mdreed72](https://forums.plex.tv/u/mdreed72)\ **Post date:** [June 1, 2023, 12:23am UTC](https://forums.plex.tv/t/would-it-be-possible-to-get-some-help-with-req-a34-database-optimization-com-plexapp-plugins-libra/842954/11 "2023-06-01T00:23:58Z")
Here you go! [Logs.zip](https://forums.plex.tv/uploads/short-url/pnthUeSlDZy4cQXNNR4g2xFoVkb.zip) (1.5 MB) ---
**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:** [June 1, 2023, 1:16am UTC](https://forums.plex.tv/t/would-it-be-possible-to-get-some-help-with-req-a34-database-optimization-com-plexapp-plugins-libra/842954/12 "2023-06-01T01:16:11Z")
@mdreed72 You ran the tool as a username other than `root` , didn’t you? ```auto May 31, 2023 15:02:54.229 [547855167712] DEBUG - HttpServer: Set up a thread pool with 2 threads. May 31, 2023 15:02:54.246 [547942989856] ERROR - SQLITE3:0x7f93f2c100, 14, cannot open file at line 41714 of [a29f994989] ``` On DSM 7, PlexMediaServer is very fragile. Use this procedure to reset the permissions (complete with screenshots and the commands to paste into task scheduler) > [@Synology FAQ - Questions, Answers, and How-To's](https://forums.plex.tv/t/synology-faq-questions-answers-and-a-few-how-tos/490215/40): > > FAQ 32: Repairing the PlexMediaServer shared folder While DSM 7 manages the permission of the PlexMediaServer shared folder itself, it does not manage the permission of files placed inside. This means any modification of permissions can cause PMS to fail. Frequent causes: Placing media in the shared folder – Which should NEVER be done. This is for PMS internal (metadata) use only. Special allowed case of adding plug-ins but must be installed correctly. One of the biggest confusion po… It will take time to complete. When you receive the email of successful completion – THEN start PMS. ---
**Author:** ![mdreed72](https://avatars.discourse-cdn.com/v4/letter/m/9f8e36/32.png) [@mdreed72](https://forums.plex.tv/u/mdreed72)\ **Post date:** [June 1, 2023, 3:27am UTC](https://forums.plex.tv/t/would-it-be-possible-to-get-some-help-with-req-a34-database-optimization-com-plexapp-plugins-libra/842954/13 "2023-06-01T03:27:27Z")
I ran it as my admin account. [admin@192.168.1.2](mailto:admin@192.168.1.2). I don’t put anything in the PMS folder! I switched up the the user settings to open up SSH. I activated the admin and then gave permissions to the shared folder. It gave me a ton of warnings about security so I changed the password of admin. I might have changed my user settings then. (I don’t think I did though). I switched them up about 6 weeks ago when all this started. I wont again! Ill follow ---
**Author:** ![mdreed72](https://avatars.discourse-cdn.com/v4/letter/m/9f8e36/32.png) [@mdreed72](https://forums.plex.tv/u/mdreed72)\ **Post date:** [June 1, 2023, 3:37am UTC](https://forums.plex.tv/t/would-it-be-possible-to-get-some-help-with-req-a34-database-optimization-com-plexapp-plugins-libra/842954/14 "2023-06-01T03:37:31Z")
And thank you very much! ---
**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:** [June 1, 2023, 4:18am UTC](https://forums.plex.tv/t/would-it-be-possible-to-get-some-help-with-req-a34-database-optimization-com-plexapp-plugins-libra/842954/15 "2023-06-01T04:18:47Z")
@mdreed72 Did that fix it? FYI. ‘admin’ is NOT ‘root’ . ‘admin’ is a normal username which Synology marks with special privileges in their apps. In real Linux, it’s another non-privileged user just like ‘plex’. You need ‘root’ when do you do this sort of thing. ---
**Author:** ![mdreed72](https://avatars.discourse-cdn.com/v4/letter/m/9f8e36/32.png) [@mdreed72](https://forums.plex.tv/u/mdreed72)\ **Post date:** [June 1, 2023, 6:21am UTC](https://forums.plex.tv/t/would-it-be-possible-to-get-some-help-with-req-a34-database-optimization-com-plexapp-plugins-libra/842954/16 "2023-06-01T06:21:39Z")
No email yet. I’ll check in the morning. ---
**Author:** ![mdreed72](https://avatars.discourse-cdn.com/v4/letter/m/9f8e36/32.png) [@mdreed72](https://forums.plex.tv/u/mdreed72)\ **Post date:** [June 1, 2023, 4:56pm UTC](https://forums.plex.tv/t/would-it-be-possible-to-get-some-help-with-req-a34-database-optimization-com-plexapp-plugins-libra/842954/17 "2023-06-01T16:56:02Z")
Hi! That got me back into the system!!! I tried to optimize and got the same error. I have attached the logs. All of the DBRepair is still in the folder. Do I pull it out? Should i try the repair again? Thank you! [Plex Media Server Logs\_2023-06-01\_11-40-47.zip](https://forums.plex.tv/uploads/short-url/4nbfBsSA0Z4EJaLdc6XkdtejTs2.zip) (1.5 MB) ---
**Author:** ![SilverSurfer-JM](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/silversurfer-jm/32/9812_2.png) [@SilverSurfer-JM](https://forums.plex.tv/u/SilverSurfer-JM)\ **Post date:** [June 1, 2023, 5:18pm UTC](https://forums.plex.tv/t/would-it-be-possible-to-get-some-help-with-req-a34-database-optimization-com-plexapp-plugins-libra/842954/18 "2023-06-01T17:18:27Z")
having this exact same issue and gave up. Tried as my personal administrator account, also tried as the synology default one (this is admin which I’ve disabled under every day use). Either way, the db permissions get baulked and plex will not start. ---
**Author:** ![mdreed72](https://avatars.discourse-cdn.com/v4/letter/m/9f8e36/32.png) [@mdreed72](https://forums.plex.tv/u/mdreed72)\ **Post date:** [June 1, 2023, 5:22pm UTC](https://forums.plex.tv/t/would-it-be-possible-to-get-some-help-with-req-a34-database-optimization-com-plexapp-plugins-libra/842954/19 "2023-06-01T17:22:53Z")
thx! Glad to know it’s not a me thing. lol. I hope something we try fixes the issue! ---
**Author:** ![SilverSurfer-JM](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/silversurfer-jm/32/9812_2.png) [@SilverSurfer-JM](https://forums.plex.tv/u/SilverSurfer-JM)\ **Post date:** [June 1, 2023, 5:24pm UTC](https://forums.plex.tv/t/would-it-be-possible-to-get-some-help-with-req-a34-database-optimization-com-plexapp-plugins-libra/842954/20 "2023-06-01T17:24:51Z")
I think maybe the problem lies in the fact we cannot use SSH as root with these devices. You can use an admin account and raise priviliges, but this seems to leave the db with incorrect permissions after the repair. [Next page](https://forums.plex.tv/t/would-it-be-possible-to-get-some-help-with-req-a34-database-optimization-com-plexapp-plugins-libra/842954.md?page=2)