ashkasto Posted October 6, 2023 Share Posted October 6, 2023 can anyone help me with radarr and sonarr docker. When new folders are being made by docker container they do not have correct permissions. I get errors when sonarr and radarr try to migrate files to plex server. When i reset permission in tools section of unraid I am then ok, but the following day same thing happens again. Thank you Quote Link to comment
allanp81 Posted October 9, 2023 Share Posted October 9, 2023 On 10/6/2023 at 8:19 PM, ashkasto said: can anyone help me with radarr and sonarr docker. When new folders are being made by docker container they do not have correct permissions. I get errors when sonarr and radarr try to migrate files to plex server. When i reset permission in tools section of unraid I am then ok, but the following day same thing happens again. Thank you Under settings and then Media Management (make sure you enable show advanced) there's a section if you scroll down so that you can set permissions. Quote Link to comment
RadRom Posted October 22, 2023 Share Posted October 22, 2023 (edited) On 8/31/2023 at 10:24 PM, JonathanM said: Docker run commands for each of the containers, be sure to redact any credentials. Hi 🙂 Thankyou. I have still been trying to fix now writer's strike is over. Plex, SABnzbdvpn & Sonarr commands and other: Where am I going wrong that Sonarr can't pick up the downloaded file and drag to Plex? Cheers 🙂 EDITED BIT: Uploaded incorrect pic, had creds. Edited October 22, 2023 by RadRom Quote Link to comment
JonathanM Posted October 22, 2023 Share Posted October 22, 2023 3 hours ago, RadRom said: Where am I going wrong that Sonarr can't pick up the downloaded file and drag to Plex? sonarr and sab must have a common path mapping. Right now you have /downloads->/mnt/user/downloads/complete and /data->/mnt/user/downloads. Change one or the other to match, both host and container parts of both mappings must be identical. You have neither part identical right now. 1 Quote Link to comment
RichB Posted November 19, 2023 Share Posted November 19, 2023 Sonarr and MP4 Automator - How to get post Sonarr processing to optimize for direct play under this docker? I'm new to unraid and still have Python and MP4 Automator installed running postsonarr.py on my other machine. Is there a way to replicate while still keeping unraid stock and not getting setup wiped in future docker updates? I've seen mentions of a handbrake docker using a drop folder, but not familiar how to workflow from Sonarr to completed downloads folder, then moves to final tv folder tree with the show name. I'm a little confused on all this. My setup is on a mini pc homelab with an AMD igpu, so I'd love my ...arr files to be direct play optimized from the get go. Thanks all and sorry if I missed above or elsewhere. Quote Link to comment
snowboardjoe Posted January 3 Share Posted January 3 (edited) Sonarr container is offline. Getting some ugly database errors on startup. Pasting the main bits here and attaching the full log. While Processing: "INSERT INTO "Commands_temp" ("Id", "Name", "Body", "Priority", "Status", "QueuedAt", "StartedAt", "EndedAt", "Duration", "Exception", "Trigger", "Result") SELECT "Id", "Name", "Body", "Priority", "Status", "QueuedAt", "StartedAt", "EndedAt", "Duration", "Exception", "Trigger", "Result" FROM "Commands"" ---> code = Constraint (19), message = System.Data.SQLite.SQLiteException (0x800027AF): constraint failed NOT NULL constraint failed: Commands_temp.Body [Info] NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor: Rolling back transaction [Fatal] ConsoleApp: EPIC FAIL! [v4.0.0.748] NzbDrone.Common.Exceptions.SonarrStartupException: Sonarr failed to start: Error creating main database ---> System.Exception: constraint failed NOT NULL constraint failed: Commands_temp.Body While Processing: "INSERT INTO "Commands_temp" ("Id", "Name", "Body", "Priority", "Status", "QueuedAt", "StartedAt", "EndedAt", "Duration", "Exception", "Trigger", "Result") SELECT "Id", "Name", "Body", "Priority", "Status", "QueuedAt", "StartedAt", "EndedAt", "Duration", "Exception", "Trigger", "Result" FROM "Commands"" ---> code = Constraint (19), message = System.Data.SQLite.SQLiteException (0x800027AF): constraint failed NOT NULL constraint failed: Commands_temp.Body Press enter to exit... Non-recoverable failure, waiting for user intervention... Any ideas what may be happening here? Seems it started a few days ago when I did an update this past weekend and did not realize it was down. More data I found in the logs when the database problem started: 2023-12-28 06:19:11.1|Info|ExistingOtherExtraImporter|Found 0 existing other extra files 2023-12-28 06:19:11.1|Info|ExistingExtraFileService|Found 0 possible extra files, imported 0 files. 2023-12-28 06:20:50.7|Error|CommandExecutor|Error occurred while executing task MessagingCleanup [v3.0.10.1567] code = Corrupt (11), message = System.Data.SQLite.SQLiteException (0x800007EF): database disk image is ma lformed database disk image is malformed at System.Data.SQLite.SQLite3.Reset (System.Data.SQLite.SQLiteStatement stmt) [0x00088] in <cf516e4846354910b3d60749c8 94b1bf>:0 at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) [0x0006e] in <cf516e4846354910b3d60749c89 4b1bf>:0 at System.Data.SQLite.SQLiteDataReader.NextResult () [0x00174] in <cf516e4846354910b3d60749c894b1bf>:0 at System.Data.SQLite.SQLiteDataReader..ctor (System.Data.SQLite.SQLiteCommand cmd, System.Data.CommandBehavior behave ) [0x0008e] in <cf516e4846354910b3d60749c894b1bf>:0 at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteDataReader..ctor(System.Data.SQLite.SQLiteCommand,Sys tem.Data.CommandBehavior) at System.Data.SQLite.SQLiteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x0000c] in <cf516e484635491 0b3d60749c894b1bf>:0 at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery (System.Data.CommandBehavior behavior) [0x00006] in <cf516e4846354 910b3d60749c894b1bf>:0 sonarr_database_error.txt Edited January 3 by snowboardjoe Quote Link to comment
snowboardjoe Posted January 3 Share Posted January 3 Found the resources on how to restore and did that from backup on 27 Dec. Had to roll back to earlier version to match that backup. WebUI is restored and performing updates, but still seems like there is corruption in the database. 23:11 HousekeepingService Error running housekeeping task: CleanupCommandQueue: database disk image is malformed database disk image is malformed 23:11 CommandExecutor Error occurred while executing task MessagingCleanup: database disk image is malformed database disk image is malformed 23:10 EventAggregator CommandQueueManager failed while processing [ApplicationStartedEvent]: database disk image is malformed database disk image is malformed Quote Link to comment
jpw007 Posted January 3 Share Posted January 3 Mine looks to have been corrupted also. I'm not savvy enough to know how to pull logs from docker, but can't seem to get it working. Quote Link to comment
jpw007 Posted January 3 Share Posted January 3 Ok, managed to fix mine. I have the Appdata backup plugin. I deleted the docker, restored it to a backup from 25/12/23, and redownloaded the docker with forcing it to version "3.0.10.1567-ls218". I noticed that version was issued ~2 weeks ago, and the latest version from ~2 days ago is some 4.XXX version. Looks like the corruption must have happened with the new main version #. Looks like i'll be sticking with forcing the current version to be safe! Quote Link to comment
snowboardjoe Posted January 3 Share Posted January 3 Yeah, going to dig back to older backups too and see if I can get past the corruption. Check your event log and make sure there are no new errors involving the database. I wish I had know there was a problem much earlier. Quote Link to comment
snowboardjoe Posted January 3 Share Posted January 3 1 hour ago, snowboardjoe said: Yeah, going to dig back to older backups too and see if I can get past the corruption. Check your event log and make sure there are no new errors involving the database. I wish I had know there was a problem much earlier. Still not working very well. Jumped to a backup from almost a month ago and still showing database errors. Sonarr is running, but constant database error events. Quote Link to comment
snowboardjoe Posted January 3 Share Posted January 3 Ended up using a backup from 2-3 months ago. Restored that and seem to be stable now. Just had to re-add some shows to monitor that I added since then. Watching logs for a week and will then try to upgrade to v4. Quote Link to comment
chiefo Posted January 22 Share Posted January 22 +Also ran into upgrade issues with the update to v4. Per the v4 sonarr release notes I was able to uncorrupt database and it is now working fine. " Issues when upgrading If you had a lot of preferred words in Sonarr v3 then you will see many migrated custom formats in v4. These will need to be edited or deleted and readded. The {Preferred Words} naming token is also replaced with the {Custom Formats} token. Check your naming strings. Due to multiple database migrations we’ve seen that some corrupt databases that were doing OK in v3 have broken in v4. You can try to follow our corrupt database repair guide Useful Tools | Servarr Wiki 102 or reach out to one of our Support channels."6 Quote Link to comment
Meller Posted January 22 Share Posted January 22 (edited) Ok, yes I know this is the Sonarr Support thread, but I'm using both Sonarr and Radarr from Linuxserver.io and I'm having issues. It's one of the most common issues we have around here. And I've done everything I can think of but I'm very obviously missing a setting or several settings some where. Issue: When qBittorrent finishes downloading a file, it's suppose to move it from /mnt/user/Media/Torrents to /mnt/user/Media/Torrents/Completed. Once it does that, Radarr (or Sonarr) is suppose to pick it up and move it to /mnt/user/Media/Plex/4K Movies (or 4K TV Shows). That isn't happening. Radarr will show the file as green/available, with it's path as "/downloads/(movie folder name)". So Plex never see's it. It's also suppose to rename the file. It does rename it and create a proper folder for it (Title (year)), but it leaves it in /mnt/user/Media/Torrents. Using just Radarr as my example for now, I've mapped /movies to /mnt/user/Media/Plex/4K Movies and /downloads to /mnt/user/Media/Torrents/. With in Radarr, I've added the root path "/movies" and in qBT I have the following settings Downloads Tab: -Default Torrent Management Mode: Automatic -When Torrent Category changed: Relocate Torrent -When Default Save Path Changed: Relocate affected torrents. -When Category Save Path Changed: Relocate affected torrents - Use Subcategories: Checked -Default Save Path: /downloads/Completed -Keep incomplete torrents in: /downloads/incomplete BitTorrent Tab: -Seeing Limits --When Ratio reaches: 1 Then Pause Torrent There's clearly something I'm missing because I have Sonarr set up the exact same way, except with 4K TV Shows folder instead of 4K Movies. Any advice on where to look? Edited January 22 by Meller Left out where Radarr says the path is Quote Link to comment
Elmojo Posted January 30 Share Posted January 30 (edited) So I feel like I'm having a similar issue to some others, but I'm just not smart enough to figure it out... lol Everything has been working perfectly up until maybe a couple weeks ago, although I'm just realizing that I have a problem today. Nothing in my config has changed, other than various dockers updating along the way, as they do. like most others, I have Radarr, Sonarr, Jackett and Plex all working together, along with SabNZB and qBit handling the downloading. As I said, everything has been great, until recently. Today, I ran a manual search for a certain show. The results came back as usual, and I selected one for download. It was an NZB. A few minutes later, I saw that it was complete, but not showing up in Sonarr. I looked in the unraid file manager, and the file is there, but it's not being moved or acknowledged in any way by Sonarr, as best as I can tell. The odd thing is that there are no errors in Sonarr. This is a key difference from previous times I've had trouble. Before, it's always been that Sonarr saw the file, but had some permissions or mapping issue. This time, it's like it doesn't knw the file exists, even though it was the one that initiated the download request. As I said, now that I look, I see that I have lots of files backing up in the downloads folder, waiting to be imported, but Sonarr doesn't seem to know they are there. I'm not even sure where to begin looking. I'm not good at parsing logs, or even finding them always. I'm happy to provide info, if anyone can tell me what you need to see.... I saw a mention above about there being an update from v3 to v4, and custom preference tags causing some issue? How can I tell what version I'm on? I do use preference tags, in an attempt to get Sonarr to pull smaller x264/x265 files, rather than huge 1080p rips. Could that be part of the issue? EDIT/SOLUTION: So I found the solution, at least for my specific issue. Maybe this is your problem as well. It seems that in the update to Sonarr v4, it's now aggressively enforcing the "Category" thing, whatever that is. I've never needed, cared or wanted to know anything about "Categories", but without assigning one, Sonarr just refused to import my files. I found this out by digging through my settings, looking for what I thought was maybe a bad mapping, based on the comments above. Everything looked okay, though, and had been working just fine for many months. On the Settings > Download Clients > SABnzbd screen, I tried to run a [test] and got a warning. It said "Adding a category specific to Sonarr avoids conflicts with unrelated non-Sonarr downloads. Using a category is optional, but strongly recommended. A category is recommended". In this case "recommended" means, 100% will not work until you assign one. I knew nothing about what it wanted for input, so I tried "Sonarr", which it rejected, since it didn't exist in SAB already. Okay... to I went over to SAB, checked the [Categories] tab, and noticed that they were more like {TV}, {Movies}, etc... Fine, I went back to Sonarr, put in "tv", and clicked [test]. I got a green check, so I manually ran the tasks, and lo and behold, all my files are importing! This really could be documented a bit better. Or better yet, just left alone! TL;DR - put "tv" into the [category] field of SABnzbd's settings (within Sonarr), and see if that fixes your import issues. Edited February 5 by Elmojo added solution/update Quote Link to comment
AlphaXL Posted February 17 Share Posted February 17 Hi, Update to the latest stable failed and now cannot even install it from the scratch. Any ideas? Quote Link to comment
Squid Posted February 17 Share Posted February 17 If it’s still there in docker edit it (if not previous apps and actions reinstall) and you have a path sitting in there that doesn’t have an entry next to it. Remove that path Quote Link to comment
AlphaXL Posted February 17 Share Posted February 17 2 hours ago, Squid said: If it’s still there in docker edit it (if not previous apps and actions reinstall) and you have a path sitting in there that doesn’t have an entry next to it. Remove that path Thank you! Removing the empty "tv" and "downloads" paths worked. But not sure why the sonarr docker update went belly up the first place... Could be related that I previously had updated Unraid from 6.12.6 to 6.12.8? Quote Link to comment
JonathanM Posted February 18 Share Posted February 18 On 2/17/2024 at 9:28 AM, AlphaXL said: Removing the empty "tv" and "downloads" paths worked. I'm curious, what is your use case that works with no media or incoming files? I'm having a hard time understanding what you use sonarr for if it doesn't have access to those folders. Quote Link to comment
ThinkSta Posted March 14 Share Posted March 14 (edited) Since updating to Unraid 6.12.8 I've not been able to access the Sonarr webgui. Not sure if it's related but I don't think anything else has changed and I've checked all the settings. I can still access all the other dockers (e.g. Radarr, plex, etc) but this is what I see when I try to access Sonarr: Here's my setup: Any idea what could have gone wrong and how I can fix it? I have tried removing and re-adding the docker, which works fine, but still can't access the webgui. I have also tried temporarily turning off the windows firewall, but this didn't make any difference either. Advice appreciated! Edited March 14 by ThinkSta Quote Link to comment
Hogwind Posted March 16 Share Posted March 16 On 3/14/2024 at 4:23 PM, ThinkSta said: Since updating to Unraid 6.12.8 I've not been able to access the Sonarr webgui. Not sure if it's related but I don't think anything else has changed and I've checked all the settings. I can still access all the other dockers (e.g. Radarr, plex, etc) but this is what I see when I try to access Sonarr: This site can't be reached Any idea what could have gone wrong and how I can fix it? I have tried removing and re-adding the docker, which works fine, but still can't access the webgui. I have also tried temporarily turning off the windows firewall, but this didn't make any difference either. Best way to trouble shot is to look in the log file. A quick way is to open the log after you started the docker through the docker menu. For all the logs look in \appdata\sonarr\logs Quote Link to comment
shredswithpiks Posted March 18 Share Posted March 18 (edited) On 3/16/2024 at 1:01 AM, Hogwind said: Best way to trouble shot is to look in the log file. A quick way is to open the log after you started the docker through the docker menu. Same issue on my end. Logs have the following errors over and over and over: Quote 2024-03-18 17:20:57.0|Info|MigrationController|*** Migrating data source=/config/sonarr.db;cache size=-20000;datetimekind=Utc;journal mode=Wal;pooling=True;version=3;busytimeout=100 *** 2024-03-18 17:20:57.1|Info|FluentMigrator.Runner.MigrationRunner|DatabaseEngineVersionCheck migrating 2024-03-18 17:20:57.1|Info|FluentMigrator.Runner.MigrationRunner|PerformDBOperation 2024-03-18 17:20:57.1|Info|NzbDrone.Core.Datastore.Migration.Framework.NzbDroneSQLiteProcessor|Performing DB Operation 2024-03-18 17:20:57.1|Error|FluentMigrator.Runner.MigrationRunner|file is not a database file is not a database [v4.0.2.1183] code = NotADb (26), message = System.Data.SQLite.SQLiteException (0x800007FF): file is not a database file is not a database Either a database problem or a mapping problem. I *think* they may have added in a /config path that didn't used to be defined or expected, so Sonarr can't find the config files. Maybe? edit: seems to be a database problem edit 2: decently easy fix in my case. sonarr creates periodic backups and drops them in /config/Backups (or from Unraid host - /path/to/appdata/sonarr/Backups... in most cases that's probably /mnt/user/appdata/sonarr/Backups by default). Moved /mnt/user/appdata/sonarr/sonarr.db to /mnt/user/appdata/sonarr/sonarr.db_old, unzipped the second-to-most-recent backup and moved it's sonarr.db to /mnt/user/appdata/sonarr/sonarr.db. Started right up after that. Edited March 19 by shredswithpiks Quote Link to comment
truetype Posted Saturday at 12:38 PM Share Posted Saturday at 12:38 PM (edited) On 3/19/2024 at 12:29 AM, shredswithpiks said: Same issue on my end. Logs have the following errors over and over and over: Either a database problem or a mapping problem. I *think* they may have added in a /config path that didn't used to be defined or expected, so Sonarr can't find the config files. Maybe? edit: seems to be a database problem edit 2: decently easy fix in my case. sonarr creates periodic backups and drops them in /config/Backups (or from Unraid host - /path/to/appdata/sonarr/Backups... in most cases that's probably /mnt/user/appdata/sonarr/Backups by default). Moved /mnt/user/appdata/sonarr/sonarr.db to /mnt/user/appdata/sonarr/sonarr.db_old, unzipped the second-to-most-recent backup and moved it's sonarr.db to /mnt/user/appdata/sonarr/sonarr.db. Started right up after that. I had issued as well, found the logs as you mentioned it was database error. Found an earlier backup from 2 weeks (before the errors in the logs started) and restored from that in the UI, worked like a flaw. Edited Saturday at 12:39 PM by truetype Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.