# Database insert exception errors in the logs **URL:** \ **Category:** Live TV & DVR\ **Created:** [October 6, 2023, 9:45am UTC](https://forums.plex.tv/t/database-insert-exception-errors-in-the-logs/856148 "2023-10-06T09:45:55Z")\ **Posts on this page:** 1\ **Showing post:** 2
**Author:** ![costinr](https://avatars.discourse-cdn.com/v4/letter/c/a587f6/32.png) [@costinr](https://forums.plex.tv/u/costinr)\ **Post date:** [October 6, 2023, 6:10pm UTC](https://forums.plex.tv/t/database-insert-exception-errors-in-the-logs/856148/2 "2023-10-06T18:10:55Z")
> [@I'm finding Plex server stopped every day](https://forums.plex.tv/t/im-finding-plex-server-stopped-every-day/855256/26): > > > [@I'm finding Plex server stopped every day](https://forums.plex.tv/t/im-finding-plex-server-stopped-every-day/855256/26): > > > > @sa2000 could you check also my logs? > > [Plex Media Server Logs\_2023-10-05\_17-10-06.zip](https://forums.plex.tv/uploads/short-url/4VyvPE7MqySPkEsSBbMXeclw9rX.zip) (3.8 MB) > > I would like to follow up on another issue I am seeing in your logs - relates to your DVRs and the Plex Media Server database - I will create a separate forum topic for this for you - once I have the information I need to investigate: > > Could you download the Plex Media Server Database zip - through the Plex Web Settings / Troubleshooting web page and send it to me - probably too big to attach, so please upload externally and send me link by private message > > Your logs show errors inserting entries into the database for a DVR > > ```auto > Oct 04, 2023 23:34:52.095 [7884] ERROR - [Grabber] SQLITE3:0x7ff73c3c7d20, 2067, abort at 34 in [update media_provider_resources set parent_id=:media_provider_resources_parent_id,type=:media_provider_resources_type,status=:media_provider_resources_status,state=:media_provider_resources_state,identifier=:media_provider_resources_identifier,protocol=:media_provider_resources_protocol,uri=:media_provider_resources_uri,uuid=:media_provider_resources_uuid,extra_data=:media_provider_resources_extra_data,last_seen_at=:media_provider_resources_last_seen_at,created_at=:media_provider_resources_created_at,updated_at=:media_provider_resources_updated_at where id=:media_provider_resources_id]: UNIQUE constraint failed: media_provider_resources.uuid > > Oct 04, 2023 23:34:52.095 [7884] ERROR - [Grabber] Exception inside transaction (inside=1) (E:\jenkins\server\4164555190\MediaProviders\Grabbers\MediaGrabber.cpp:171): sqlite3_statement_backend::loadOne: UNIQUE constraint failed: media_provider_resources.uuid > > Oct 04, 2023 23:34:52.095 [7884] DEBUG - DVR:Device: Device was alive, refreshed device://tv.plex.grabbers.hdhomerun/2022-09-BQIH-Z6V6QE:4. > > ``` > > We addressed issues like this before on VBox DVRs - looks like a similar issue or may be the fix needs further tweaks. We try to create a unique uuid (device identifier) for each DVR to add entries for in the database and this is failing with the above error > > Could you please get me the responses from these requests - saving each in a text file with a suitable name to identify the request > > ```auto > http://costinr:S1_3_b1n3@192.168.100.216:34400/discover.json > http://costinr:S1_3_b1n3@192.168.100.216:34400/lineup_status.json > > ``` > > Could you also do the same for these - are these for the same physical DVR? > > ```auto > https://costinr:S1_3_b1n3@cloud.rizescu.eu:2087/discover.json > https://costinr:S1_3_b1n3@cloud.rizescu.eu:2087/lineup_status.json > > ``` > > and these > > ```auto > http://costinr:S1_3_b1n3@192.168.100.17:34400/discover.json > http://costinr:S1_3_b1n3@192.168.100.17:34400/lineup_status.json > > ``` > > and these - are these the same DVR as the one above? > > ```auto > http://costinr:C31_ma1_b1n3@192.168.100.17:34400/discover.json > http://costinr:C31_ma1_b1n3@192.168.100.17:34400/lineup_status.json > > ``` None of the DVR’s are up anymore. I’ve tried several tuners with Live TV & DVR but I gave up because there were a lot of errors (wrong or missing recordings, wrong EPG mappings, etc.) Thank you very much, --- _[View the full topic](https://forums.plex.tv/t/database-insert-exception-errors-in-the-logs/856148)._