Plex Server DB errors Constant Crashing

Fallenfederation · January 10, 2023, 10:57pm

Server Version#: 1.30.1.6562
Player Version#: 4.87.2
Unraid: 6.11.5
Docker Container: Plexinc/pms-docker:latest

My plex server started recently having some DB errors
Sqlite3: Sleeping for 200ms to retry busy DB.
We rebuild the DB but now this is what I’m getting. I’m a bit of a novice when it come to plex coding and such so please forgive my ignorance when it comes to the operation and handeling on here.

Any help would be appreciated.

Sqlite3: Sleeping for 200ms to retry busy DB.
libc++abi: terminating with uncaught exception of type soci::soci_error: sqlite3_statement_backend::prepare: near ")": syntax error for SQL: select distinct metadata_items.id from metadata_items  where metadata_items.library_section_id in (1) and ((metadata_items.added_at>2147483647 and metadata_items.metadata_type=1) and )  order by metadata_items.title_sort
****** PLEX MEDIA SERVER CRASHED, CRASH REPORT WRITTEN: /config/Library/Application Support/Plex Media Server/Crash Reports/1.30.1.6562-915986d62/PLEX MEDIA SERVER/7cf840cc-4dc4-478a-683ea689-839d446e.dmp
Stopping Plex Media Server.
Starting Plex Media Server.
Critical: libusb_init failed
libc++abi: terminating with uncaught exception of type soci::soci_error: sqlite3_statement_backend::prepare: near ")": syntax error for SQL: select distinct metadata_items.id from metadata_items  where metadata_items.library_section_id in (1) and ((metadata_items.added_at>2147483647 and metadata_items.metadata_type=1) and )  order by metadata_items.title_sort
****** PLEX MEDIA SERVER CRASHED, CRASH REPORT WRITTEN: /config/Library/Application Support/Plex Media Server/Crash Reports/1.30.1.6562-915986d62/PLEX MEDIA SERVER/2915c08a-7aeb-4bf4-858d2491-a1a13b83.dmp
Stopping Plex Media Server.
kill: usage: kill [-s sigspec | -n signum | -sigspec] pid | jobspec ... or kill -l [sigspec]
Starting Plex Media Server.
Critical: libusb_init failed
Connection to 184.105.148.89 closed by remote host.
libc++abi: terminating with uncaught exception of type soci::soci_error: sqlite3_statement_backend::prepare: near ")": syntax error for SQL: select distinct metadata_items.id from metadata_items  where metadata_items.library_section_id in (1) and ((metadata_items.added_at>2147483647 and metadata_items.metadata_type=1) and )  order by metadata_items.title_sort
****** PLEX MEDIA SERVER CRASHED, CRASH REPORT WRITTEN: /config/Library/Application Support/Plex Media Server/Crash Reports/1.30.1.6562-915986d62/PLEX MEDIA SERVER/4e4287c6-db6b-4917-b4a0f692-b7885f9c.dmp
Stopping Plex Media Server.
Starting Plex Media Server.
Critical: libusb_init failed
Connection to 184.105.148.89 closed by remote host.
libc++abi: terminating with uncaught exception of type soci::soci_error: sqlite3_statement_backend::prepare: near ")": syntax error for SQL: select distinct metadata_items.id from metadata_items  where metadata_items.library_section_id in (1) and ((metadata_items.added_at>2147483647 and metadata_items.metadata_type=1) and )  order by metadata_items.title_sort
****** PLEX MEDIA SERVER CRASHED, CRASH REPORT WRITTEN: /config/Library/Application Support/Plex Media Server/Crash Reports/1.30.1.6562-915986d62/PLEX MEDIA SERVER/79712d4d-9c14-40bb-7c5f21b6-29c5c5e5.dmp
Stopping Plex Media Server.
kill: usage: kill [-s sigspec | -n signum | -sigspec] pid | jobspec ... or kill -l [sigspec]
Starting Plex Media Server.
Critical: libusb_init failed
libc++abi: terminating with uncaught exception of type soci::soci_error: sqlite3_statement_backend::prepare: near ")": syntax error for SQL: select distinct metadata_items.id from metadata_items  where metadata_items.library_section_id in (1) and ((metadata_items.added_at>2147483647 and metadata_items.metadata_type=1) and )  order by metadata_items.title_sort
****** PLEX MEDIA SERVER CRASHED, CRASH REPORT WRITTEN: /config/Library/Application Support/Plex Media Server/Crash Reports/1.30.1.6562-915986d62/PLEX MEDIA SERVER/95f4cb8b-d598-417d-3069d883-3de6b2ce.dmp
Stopping Plex Media Server.
Starting Plex Media Server.
Critical: libusb_init failed
libc++abi: terminating with uncaught exception of type soci::soci_error: sqlite3_statement_backend::prepare: near ")": syntax error for SQL: select distinct metadata_items.id from metadata_items  where metadata_items.library_section_id in (1) and ((metadata_items.added_at>2147483647 and metadata_items.metadata_type=1) and )  order by metadata_items.title_sort
****** PLEX MEDIA SERVER CRASHED, CRASH REPORT WRITTEN: /config/Library/Application Support/Plex Media Server/Crash Reports/1.30.1.6562-915986d62/PLEX MEDIA SERVER/c2e9f8ec-bc77-40ac-9f356295-300ba953.dmp
Stopping Plex Media Server.
kill: usage: kill [-s sigspec | -n signum | -sigspec] pid | jobspec ... or kill -l [sigspec]
Starting Plex Media Server.

FordGuy61 · January 10, 2023, 11:12pm

Please supply a set of server logs that capture the crash. Someone versed in running Plex on Docker will be able to assist.

Configure your server for debug, not verbose, level logging.
Settings → Server_Name → General + Show Advanced

Screenshot (1203)715×154 23.1 KB
Restart Plex Media Server
After the next crash, restart Plex Media Server.
Wait 3 to 5 minutes for Plex to fully boot and the logs to capture everything.
Retrieve the log files, Settings → Troubleshooting.
Upload the entire zip file to the thread.
Drag it into the message window. It will attach at the cursor location.

Fallenfederation · January 11, 2023, 3:28am

Plex Media Server Logs_2023-01-10_20-27-06.zip (4.3 MB)

logs. Thank you!

Fallenfederation · January 11, 2023, 3:34am

Had another crash right after restart.

ChuckPa · January 11, 2023, 3:49am

Would you like to try the DBRepair shell tool and see if it can ferret out bad records ?

Fallenfederation · January 11, 2023, 3:53am

I did run a repair on the db this is after the rebuild.

Fallenfederation · January 11, 2023, 4:10am

Plex Media Server Logs_2023-01-10_21-09-07.zip (3.2 MB)

Another set of logs after this latest crash.

This is a pretty new database and installation is there something I can be doing to help prevent these issues?

ChuckPa · January 11, 2023, 5:03am

This DB is corrupt.

Jan 10, 2023 20:33:02.604 [0x14c8e42beb38] ERROR - SQLITE3:0x80000001, 1, near ")": syntax error in "select distinct metadata_items.id from metadata_items  where metadata_items.library_section_id in (1) and ((metadata_items.added_at>2147483647 and metadata_items.metadata_type=1) and

It’s failing on ‘distinct’. transactions aren’t completing.

Is the DB on the host or network / remote ?

ChuckPa · January 11, 2023, 5:34am

Did you repair with my tool or Plex’s documented method?

Fallenfederation · January 11, 2023, 7:07am

It’s on the host.

As for repair I followed the steps in Spaceinvaderone’s YouTube video.

ChuckPa · January 11, 2023, 7:59am

@Fallenfederation

Wow, that’s a really hard way to fix things. It assumes your backup database isn’t damaged. That’s risky.

Can I interest you in an easier way which will drop the corrupted records?

The important first part (which shows the README.md) is here.

The release is here.

How it works in docker.

Place the script’s tar.gz / zip file wherever you have /config mapped.
Start the container
Enter the container (docker exec -it container_name bash)
Shutdown Plex only (the container stays live) See README for instructions
Extract the tool
Now you can run the most common sequence (1 4 3 )
– check and report status , should be OK
– Repair (by export & import). This is where damaged records get dropped
– Reindex (put the indexes, lost by repairing, back in before PMS starts)

Please see the readme and sample session at the bottom.

In actual use, When PMS crashes because of a database problem and this tool runs, PMS never crashed again. I hope it solves your problem too

Don’t hesitate to ask any questions you might have,

Fallenfederation · January 13, 2023, 8:30pm

Ok, I did use your tool and the DB had no detectable errors. I ran a repair and reindex on the DB with no affect. One thing I’m starting to notice is that the error happens a bunch when media is added to plex. Is there something that can cause it when adding media?

Fallenfederation · January 13, 2023, 9:03pm

Plex Media Server Logs_2023-01-13_14-02-23.zip (2.2 MB)

Here are the logs after using the tool.

Fallenfederation · January 14, 2023, 11:03pm

It seems the crash is happening when media is added. Anyone have any ideas why the DB would have problems when adding media only. The media is still added and processed by plex. After restart that takes about 8 to 10 seconds everything returns to normal operation.

ChuckPa · January 14, 2023, 11:46pm

THere are known issues with PMS crashing adding media.

The only known stable (IMHO) is 1.29.2

Recommend downgrading and waiting until it’s fixed.
Seems to be music / music analysis related (based on comments I’ve seen)

Fallenfederation · January 15, 2023, 2:14am

Ok I will try the downgrade. It’s easy with docker. Mine seems to be movies but I have not tried music yet. Thanks for the reply.

system · April 15, 2023, 2:15am

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

Topic		Replies	Views
Plex crashing on 1.23.2.4584 Plex Media Server server-windows	7	249	August 24, 2021
My plex server is constantly crashing and won't stay up Plex Media Server server-linux , server-docker	19	240	January 8, 2023
(Solved) PMS Stopped Working, Crash Logs in Docker Desktops & Laptops server-docker	4	372	August 22, 2019
Plex Media Server crashes multiple times a day, every day due to "Sqlite3: Sleeping for 200ms to retry busy DB" flooding Plex Media Server server-docker , roku	20	367	June 12, 2022
Version 1.18.1 SQlite errors and crashing Desktops & Laptops server-windows	7	203	February 2, 2020

Plex Server DB errors Constant Crashing

Related topics