Crashing Server 1.29.1.6276

Plex Media Server
1

Server Version#: 1.29.1.6276
64 Bit on Windows 2019 Server

Since yesterday I have permanent crashes of my server and I don’t know why - I also hopped it woul restart by itself but he doesn’t

As i saw in the log the following:
Oct 11, 2022 14:50:08.046 [3808] ERROR - SQLITE3:0x7ff76db8c4e0, 1, near “s”: syntax error in "select tags.id as ‘tags_id’, tags.parent_id as ‘tags_parent_id’, tags.metadata_item_id as ‘tags_metadata_item_id’, tags.tag as ‘tags_tag’, tags.key as ‘tags_key’, tags.tag_type as 't
I thought a vacuum, reindex, integrity check would be good but without any result

Any other error isn’t visible :confused:

Does anyone else have suddenly such strange issues?

Before I never had crashes, at least none I would have seen…
And no movies or so were added since days…

Any ideas would be welcome…

Thanks

2

It just crashed again and I saw he was checking some photos and I thought again that I added some on sunday I think it was - totally forgot this…
Could so be related on this as the last log entries are:

Oct 11, 2022 17:22:14.393 [4904] ERROR - SQLITE3:0x7ff76db8c4e0, 1, near “s”: syntax error in "select tags.id as ‘tags_id’, tags.parent_id as ‘tags_parent_id’, tags.metadata_item_id as ‘tags_metadata_item_id’, tags.tag as ‘tags_tag’, tags.key as ‘tags_key’, tags.tag_type as 't

Oct 11, 2022 17:22:14.393 [3332] DEBUG - AutoTagging: processing M:\Photos\2022\2022-10-08 - Nuit des mus…es - Luxembourg\08-10-2022 18h32m47s.JPG (id: 281515). Current Version 1

I remove the tag photos option for now and if that doesn’t help I gonna kill that library until a solution is available…

3

Sounds like you have a corrupt database https://support.plex.tv/articles/repair-a-corrupted-database/

4

Nope
Like I wrote I already did all the checks…

Since I deactivate photo taging no more crashes…
I found another posts of a user with the same issue now that I know that it comes from the photos I knew what so search for…

5

You only ran some of the repair options, see the section labeled Low-Level Database Recovery

6

As it doesn’t crash on any scan now since I deactivated photo tagging it’s clear where it comes from

And the database was rebuilt like in the last step on the db recovery support page as the basics didn’t find any error or helped stop the crashings

7

@FordGuy61 There’s now been a half dozen of these reports where Autotagging crashes 64bit PMS with an SQLITE error when running on Windows. I’ve been working on another thread too. Anyone come to mind that we can bribe to look at this? :slight_smile:

I figure they’re seeing the crash reports but ya know.

1 Like
8

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