Play_queue_items.id auto increment overflow prevented playback

Plex Media Server
1

Server Version#:1.4.2
Player Version#: All

Playback recently began to fail on all clients and across multiple versions of Plex Server Linux. The Sa,sung client returned “Can’t Reach Server”. “Failed to fetch play queue response.” After a lot of debug I found the root cause and fix which I used Claude Code to implement. I’ll summarize below:

  1. Root cause: play_queue_items.id auto-increment sequence had reached 2147483647 (INT32_MAX). Every new play queue item insert would overflow Plex’s internal 32-bit integer, throwing std::exception and returning an empty play queue.
  2. Fix: Stopped Plex, cleared play_queue_items and play_queues (temporary session data), reset the sqlite_sequence for both tables to 0, restarted Plex.

Hope this helps anyone facing the same problem.