[Support] Linuxserver.io - Sonarr


Recommended Posts

hey guys - i randomly just got the error "database disk image is malformed database disk image is malformed". I restored from backup just now via built-in backup function but while googling the error, i'm worried that my current backup (5 days old) is going to encounter this issue down the line.

 

Some people who had same issue seemed to mention this was an issue with Unraid 6.7.0 + SQLite DBs not playing nicely. I'm on 6.9.2. Should I be worried with my Radarr/Sonarr/Lidarr/Prowlarr instances for DB corruption over time? Is there any best practices to avoid future corruption?

Link to comment
  • 1 month later...
  • 2 weeks later...
On 2/15/2022 at 4:20 PM, Timbiotic said:

I was looking at system messages today and noticed its upset about old tag, and old version. I am on 3.0.5 from about a year ago and it says there is 3.0.6.1342 available.  Is this version available for unraid? Or a newer one? It says docker has to be updated.

 

I have that version installed. I'm having some problems with BTN's API, but I'm 95% sure it's not related to the the latest release or actually Sonarr itself, probably my Internet. Other than that, it's working like it should.

 

Also, I don't recommend changing your release to go into development (nightly). There's why: https://wiki.servarr.com/sonarr/faq#how-do-i-update-sonarr

Edited by mizifih
Link to comment
  • 4 weeks later...

Hi there


I posted over at the Sonarr forums and they say that only the Image Maintainer can remove it. 

 

There has been a System Message notification that is unclearable "This image is now based on Alpine. Custom scripts using apt-get will need to be updated to use apk" for quite some time, is it possible to get this removed now?

 

I keep thinking I have an issue...

 

Thanks :)

Link to comment
  • 4 weeks later...

I am currently running version linuxserver/sonarr:3.0.6.1342-ls135. When I update to any of the newer versions my downloads are moved by sonarr but some if not most files downloaded are cut down to one minute. What the heck is going on? Anyone have any idea with out the logs? I already went back to linuxserver/sonarr:3.0.6.1342-ls135.

Link to comment
  • 4 weeks later...
On 1/4/2022 at 7:30 AM, Linguafoeda said:

hey guys - i randomly just got the error "database disk image is malformed database disk image is malformed". I restored from backup just now via built-in backup function but while googling the error, i'm worried that my current backup (5 days old) is going to encounter this issue down the line.

 

Some people who had same issue seemed to mention this was an issue with Unraid 6.7.0 + SQLite DBs not playing nicely. I'm on 6.9.2. Should I be worried with my Radarr/Sonarr/Lidarr/Prowlarr instances for DB corruption over time? Is there any best practices to avoid future corruption?

Did you get this fixed?  I had the same issue around the same time, but before I got around to fixing it UnRaid stopped recognising I had any Dockers, I didn't have them backed up and I haven't had time to set everything back up.  Then yesterday UnRaid decided I did have Dockers setup, everything started working again, except Sonarr, which is throwing the same error on opening the Console and I can't access the GUI.

 

I can still access it via my mobile app, so it is still doing something, but I can't add new programs, so it does look like there's an issue with the database.

 

Is there a way to fix it or, worse-case, reinstall it and flatten the database?

 

 

Link to comment
5 hours ago, Paul Rockliffe said:

Did you get this fixed?  I had the same issue around the same time, but before I got around to fixing it UnRaid stopped recognising I had any Dockers, I didn't have them backed up and I haven't had time to set everything back up.  Then yesterday UnRaid decided I did have Dockers setup, everything started working again, except Sonarr, which is throwing the same error on opening the Console and I can't access the GUI.

 

I can still access it via my mobile app, so it is still doing something, but I can't add new programs, so it does look like there's an issue with the database.

 

Is there a way to fix it or, worse-case, reinstall it and flatten the database?

 

 

 

Just restored from database and also edited all my docker apps to directly source the appdata folder from the cache drive instead of the unRAID share. I heard that was better way to eliminate overhead that is created for apps that are openly writing to data base constantly. Haven't had any issues since

Link to comment

I am also facing a new weird issue (after using Sonarr docker for many years).

 

Episodes no longer auto-import. When trying to do so manually, the release gets rejected "not enough free space".

 

Happy to post logs or provide info for troubleshooting. Any thought what's best?

Link to comment
  • 1 month later...
  • 3 weeks later...

I don't know why, I didn't change anything in my path either on Sonarr or Deluge, but Sonarr cannot import files anymore, at first I thought it was something with deluge, but once I look at Sonarr, it keeps saying it can't import files, can't edit the library, can't actually do anything with any file because "Access to the path '/tv/TVSHOW/Show Name' is denied. So I can't add new shows because it can't import files. I tried editing some shows, it also can't access the /tv/TVSHOW/ folder or any subfolder.

 

How do I  fix this? I don't want to mess with file permission and end up making it even worse. Sould I give permission to whatever user runs docker on my Server? Should I give permission from inside sonarr container terminal? I found out Sonarr is run by user 'abc' from inside the container.

 

UPDATE: just checked and the -v parameter has the rw flag (-v '/mnt/user/MediaCenter/':'/tv':'rw'), I am still getting the "Couldn't import episode /folder/tvshow/episode-file.mkv: Access to the path '/tv/TVSHOW/Show Name' is denied."

 

PS: 'Show Name' in the path is fictional, it can't work with any show.

Edited by mizifih
update 1
Link to comment
  • 1 month later...

Hey, I'm new to Unraid so I will be as detailed as I can. I have recently moved from ESXI and Windows VM's

first off I'm not sure if if my issue is with Sonarr or NZBGet, but thought I would start here.

 

I have NZBGet and Sonarr set up and everything is functioning but Sonarr fails on importing the file. I believe this is to do the folder mappings of the containers but unsure on how to troubleshoot and fix.

 

I have looked at several docs and tutorials, but my set up is slightly different to the tutorials.  All off my media is on my QNAP NAS and I am using the Unassigned Devices plugin and the media shares are added to Unraid as SMB's for instance my TV shows are \\192.168.1.30\TV

 

I am new to docker and my Windows brain can't work out how to sort the mappings  (if that's the issue)

 

Containers:

NZBGet

/tv - /mnt/remotes/192.168.1.30_TV/
/config - /mnt/user/appdata/nzbget

Sonarr

/tv - /mnt/remotes/192.168.1.30_TV/
/downloads - /downloads/completed/tv/
/data - /mnt/user/data/
/config - /mnt/user/appdata/sonarr

 

I hope I have explained this enough, if not please let me know. 

Thanks

 

Link to comment

Where is NZBGet downloading to?  It appears without any screenshots that it's downloading to /config/downloads.

 

You should add another path mapping of /downloads -> /mnt/user/downloads

 

Also, your Sonarr /downloads mapping doesn't make a whole lot of sense as it's actually looking in RAM for the downloads as /downloads/completed/tv isn't a valid path mapping to any drive / device in the system

 

See 

 

Link to comment

Having an issue with replacing episodes with new copies. If it's the first time an episode is grabbed, Sonarr imports it from QBit without issue, this error is only occurring when it tries to replace an existing episode. The mappings work fine as far as I am aware, since new episodes import without issue. It doesn't happen with every episode either, some are replaced without issue, while others get the Destination Already Exists error.

 

Specific error is NzbDrone.Common.Disk.DestinationAlreadyExistsException

Full trace log for affected file: https://pastebin.com/PqptSrFc

 

Permissions within Unraid for affected files are

previous file: 666 nobody users

new file: 666 nobody users

 

Permissions from Docker container for affected files are

previous 

previous file: 666 abc users

new file: 666 abc users

 

I also ssh'd into the docker itself, and manually ran cp to copy the new file over the old file, and it worked without issue, so I don't think it's a permission issue either.

 

I did try googling for an answer, but couldn't find anything that fit the problem I'm experiencing, so starting here to see if it's an unraid docker issue before moving to Sonarr direct help.

Link to comment
  • 3 weeks later...

Hi guys,

New to unraid, been running a synology nas for a few years.
I set up a docker container with transmission-vpn for downloading, and i set up Linuxserver.io Sonarr container.
Adding downloads to transmission via sonarr is working. But Sonarr can't move the files. I get the following log:
 

Couldn't import episode /data/completed/Chicago.PD.S10E01.1080p.WEB.h264-GOSSIP[rarbg]/Chicago.PD.S10E01.1080p.WEB.h264-GOSSIP.mkv: Access to the path '/data/completed/Chicago.PD.S10E01.1080p.WEB.h264-GOSSIP[rarbg]/Chicago.PD.S10E01.1080p.WEB.h264-GOSSIP.mkv' is denied.


Now here is the strange thing. When i check the Tv show > season folder i can see the file being moved there. The file get's added, and the file size increases until it reaches the correct file size. And then it just dissapears with the error above.

Link to comment

Hey guys,

 

I seem to be having issues adding a new series:

 

Couldn't import episode /data/completed/Series/Season/Episode: Access to the path '/tv/Series' is denied.

 

I added the series but it doesn't appear to have created the folder. Other automatic downloads are working fine and being imported.

Link to comment

Hello everyone.

 

Having a weird situation that appears to have come out of nowhere (but I suspect it may be after a recent update).

The database has become readonly. This is part of what I see in the log:

2022-09-21 21:24:45.3|Info|Bootstrap|Starting Sonarr - /app/sonarr/bin/Sonarr.exe - Version 3.0.9.1549
2022-09-21 21:24:46.1|Info|AppFolderInfo|Data directory is being overridden to [/config]
2022-09-21 21:24:46.2|Info|Router|Application mode: Interactive
2022-09-21 21:24:46.6|Info|MigrationLogger|*** Checking database for required migrations data source=/config/sonarr.db;cache size=-10000;datetimekind=Utc;journal mode=Wal;pooling=True;version=3 ***
2022-09-21 21:24:46.9|Info|MigrationLogger|*** Checking database for required migrations data source=/config/logs.db;cache size=-10000;datetimekind=Utc;journal mode=Wal;pooling=True;version=3 ***
2022-09-21 21:24:47.3|Info|OwinHostController|Listening on the following URLs:
2022-09-21 21:24:47.3|Info|OwinHostController|  http://*:8989/
2022-09-21 21:24:48.0|Info|SonarrBootstrapper|Starting Web Server
2022-09-21 21:24:49.9|Error|EventAggregator|QualityDefinitionService failed while processing [ApplicationStartedEvent]

[v3.0.9.1549] code = ReadOnly (8), message = System.Data.SQLite.SQLiteException (0x800017FF): attempt to write a readonly database
attempt to write a readonly database

  at System.Data.SQLite.SQLite3.Reset (System.Data.SQLite.SQLiteStatement stmt) [0x00088] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) [0x0006e] in <cf516e4846354910b3d60749c894b1bf>: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,System.Data.CommandBehavior)
  at System.Data.SQLite.SQLiteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x0000c] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery (System.Data.CommandBehavior behavior) [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery () [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
  at Marr.Data.QGen.UpdateQueryBuilder`1[T].Execute () [0x0003b] in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\QGen\UpdateQueryBuilder.cs:157 
  at Marr.Data.DataMapper.Update[T] (T entity, System.Linq.Expressions.Expression`1[TDelegate] filter) [0x00000] in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:674 
  at NzbDrone.Core.Datastore.BasicRepository`1[TModel].UpdateMany (System.Collections.Generic.IList`1[T] models) [0x00055] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Datastore\BasicRepository.cs:175 
  at NzbDrone.Core.Qualities.QualityDefinitionService.InsertMissingDefinitions () [0x000c9] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Qualities\QualityDefinitionService.cs:92 
  at NzbDrone.Core.Qualities.QualityDefinitionService.Handle (NzbDrone.Core.Lifecycle.ApplicationStartedEvent message) [0x00010] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Qualities\QualityDefinitionService.cs:109 
  at NzbDrone.Core.Messaging.Events.EventAggregator.PublishEvent[TEvent] (TEvent event) [0x0011a] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Events\EventAggregator.cs:92 

2022-09-21 21:24:50.2|Error|EventAggregator|CommandQueueManager failed while processing [ApplicationStartedEvent]

[v3.0.9.1549] code = ReadOnly (8), message = System.Data.SQLite.SQLiteException (0x800017FF): attempt to write a readonly database
attempt to write a readonly database
  at System.Data.SQLite.SQLite3.Reset (System.Data.SQLite.SQLiteStatement stmt) [0x00088] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) [0x0006e] in <cf516e4846354910b3d60749c894b1bf>: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,System.Data.CommandBehavior)
  at System.Data.SQLite.SQLiteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x0000c] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery (System.Data.CommandBehavior behavior) [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery () [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
  at Marr.Data.DataMapper.ExecuteNonQuery (System.String sql) [0x0002a] in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:204 
  at NzbDrone.Core.Messaging.Commands.CommandRepository.OrphanStarted () [0x00064] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Commands\CommandRepository.cs:46 
  at NzbDrone.Core.Messaging.Commands.CommandQueueManager.Handle (NzbDrone.Core.Lifecycle.ApplicationStartedEvent message) [0x00010] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Commands\CommandQueueManager.cs:260 
  at NzbDrone.Core.Messaging.Events.EventAggregator.PublishEvent[TEvent] (TEvent event) [0x0011a] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Events\EventAggregator.cs:92 

2022-09-21 21:24:50.2|Error|EventAggregator|TaskManager failed while processing [ApplicationStartedEvent]

[v3.0.9.1549] code = ReadOnly (8), message = System.Data.SQLite.SQLiteException (0x800017FF): attempt to write a readonly database
attempt to write a readonly database
  at System.Data.SQLite.SQLite3.Reset (System.Data.SQLite.SQLiteStatement stmt) [0x00088] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) [0x0006e] in <cf516e4846354910b3d60749c894b1bf>: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,System.Data.CommandBehavior)
  at System.Data.SQLite.SQLiteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x0000c] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery (System.Data.CommandBehavior behavior) [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery () [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
  at Marr.Data.QGen.UpdateQueryBuilder`1[T].Execute () [0x0003b] in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\QGen\UpdateQueryBuilder.cs:157 
  at Marr.Data.DataMapper.Update[T] (T entity, System.Linq.Expressions.Expression`1[TDelegate] filter) [0x00000] in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:674 
  at NzbDrone.Core.Datastore.BasicRepository`1[TModel].Update (TModel model) [0x0002a] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Datastore\BasicRepository.cs:133 
  at NzbDrone.Core.Datastore.BasicRepository`1[TModel].Upsert (TModel model) [0x00017] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Datastore\BasicRepository.cs:194 
  at NzbDrone.Core.Jobs.TaskManager.Handle (NzbDrone.Core.Lifecycle.ApplicationStartedEvent message) [0x00340] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Jobs\TaskManager.cs:164 
  at NzbDrone.Core.Messaging.Events.EventAggregator.PublishEvent[TEvent] (TEvent event) [0x0011a] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Events\EventAggregator.cs:92 

2022-09-21 21:24:50.5|Error|TaskExtensions|Task Error

[v3.0.9.1549] System.UnauthorizedAccessException: Access to the path "/config/config.xml" is denied.
  at System.IO.FileStream..ctor (System.String path, System.IO.FileMode mode, System.IO.FileAccess access, System.IO.FileShare share, System.Int32 bufferSize, System.Boolean anonymous, System.IO.FileOptions options) [0x0019e] in <de882a77e7c14f8ba5d298093dde82b2>:0 
  at System.IO.FileStream..ctor (System.String path, System.IO.FileMode mode, System.IO.FileAccess access, System.IO.FileShare share, System.Int32 bufferSize, System.IO.FileOptions options) [0x00000] in <de882a77e7c14f8ba5d298093dde82b2>:0 
  at (wrapper remoting-invoke-with-check) System.IO.FileStream..ctor(string,System.IO.FileMode,System.IO.FileAccess,System.IO.FileShare,int,System.IO.FileOptions)
  at System.IO.StreamWriter..ctor (System.String path, System.Boolean append, System.Text.Encoding encoding, System.Int32 bufferSize) [0x00055] in <de882a77e7c14f8ba5d298093dde82b2>:0 
  at System.IO.StreamWriter..ctor (System.String path) [0x00008] in <de882a77e7c14f8ba5d298093dde82b2>:0 
  at (wrapper remoting-invoke-with-check) System.IO.StreamWriter..ctor(string)
  at System.IO.File.WriteAllText (System.String path, System.String contents) [0x00026] in <de882a77e7c14f8ba5d298093dde82b2>:0 
  at NzbDrone.Common.Disk.DiskProviderBase.WriteAllText (System.String filename, System.String contents) [0x00052] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Common\Disk\DiskProviderBase.cs:304 
  at NzbDrone.Core.Configuration.ConfigFileProvider.SaveConfigFile (System.Xml.Linq.XDocument xDoc) [0x00010] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Configuration\ConfigFileProvider.cs:376 
  at NzbDrone.Core.Configuration.ConfigFileProvider.DeleteOldValues () [0x000a7] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Configuration\ConfigFileProvider.cs:333 
  at NzbDrone.Core.Configuration.ConfigFileProvider.HandleAsync (NzbDrone.Core.Lifecycle.ApplicationStartedEvent message) [0x00006] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Configuration\ConfigFileProvider.cs:388 
  at NzbDrone.Core.Messaging.Events.EventAggregator+<>c__DisplayClass6_2`1[TEvent].<PublishEvent>b__2 () [0x00035] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Events\EventAggregator.cs:119 
  at System.Threading.Tasks.Task.InnerInvoke () [0x0000f] in <de882a77e7c14f8ba5d298093dde82b2>:0 
  at System.Threading.Tasks.Task.Execute () [0x00000] in <de882a77e7c14f8ba5d298093dde82b2>:0 

2022-09-21 21:25:20.3|Error|TaskExtensions|Task Error

[v3.0.9.1549] code = ReadOnly (8), message = System.Data.SQLite.SQLiteException (0x800017FF): attempt to write a readonly database
attempt to write a readonly database
  at System.Data.SQLite.SQLite3.Reset (System.Data.SQLite.SQLiteStatement stmt) [0x00088] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) [0x0006e] in <cf516e4846354910b3d60749c894b1bf>: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,System.Data.CommandBehavior)
  at System.Data.SQLite.SQLiteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x0000c] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteScalar (System.Data.CommandBehavior behavior) [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteScalar () [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
  at Marr.Data.QGen.InsertQueryBuilder`1[T].Execute () [0x00046] in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\QGen\InsertQueryBuilder.cs:140 
  at Marr.Data.DataMapper.Insert[T] (T entity) [0x0005f] in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:728 
  at NzbDrone.Core.Datastore.BasicRepository`1[TModel].Insert (TModel model) [0x00030] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Datastore\BasicRepository.cs:119 
  at NzbDrone.Core.Messaging.Commands.CommandQueueManager.Push[TCommand] (TCommand command, NzbDrone.Core.Messaging.Commands.CommandPriority priority, NzbDrone.Core.Messaging.Commands.CommandTrigger trigger) [0x0015a] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Commands\CommandQueueManager.cs:126 
  at System.Dynamic.UpdateDelegates.UpdateAndExecute4[T0,T1,T2,T3,TRet] (System.Runtime.CompilerServices.CallSite site, T0 arg0, T1 arg1, T2 arg2, T3 arg3) [0x00136] in <f6c405b973804b5c804e7e759353765f>:0 
  at (wrapper delegate-invoke) System.Func`6[System.Runtime.CompilerServices.CallSite,NzbDrone.Core.Messaging.Commands.CommandQueueManager,System.Object,NzbDrone.Core.Messaging.Commands.CommandPriority,NzbDrone.Core.Messaging.Commands.CommandTrigger,System.Object].invoke_TResult_T1_T2_T3_T4_T5(System.Runtime.CompilerServices.CallSite,NzbDrone.Core.Messaging.Commands.CommandQueueManager,object,NzbDrone.Core.Messaging.Commands.CommandPriority,NzbDrone.Core.Messaging.Commands.CommandTrigger)
  at NzbDrone.Core.Messaging.Commands.CommandQueueManager.Push (System.String commandName, System.Nullable`1[T] lastExecutionTime, NzbDrone.Core.Messaging.Commands.CommandPriority priority, NzbDrone.Core.Messaging.Commands.CommandTrigger trigger) [0x000b7] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Commands\CommandQueueManager.cs:139 
  at NzbDrone.Core.Jobs.Scheduler.ExecuteCommands () [0x00043] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Jobs\Scheduler.cs:42 
  at System.Threading.Tasks.Task.InnerInvoke () [0x0000f] in <de882a77e7c14f8ba5d298093dde82b2>:0 
  at System.Threading.Tasks.Task.Execute () [0x00000] in <de882a77e7c14f8ba5d298093dde82b2>:0 

2022-09-21 21:25:50.3|Error|TaskExtensions|Task Error

[v3.0.9.1549] code = ReadOnly (8), message = System.Data.SQLite.SQLiteException (0x800017FF): attempt to write a readonly database
attempt to write a readonly database
  at System.Data.SQLite.SQLite3.Reset (System.Data.SQLite.SQLiteStatement stmt) [0x00088] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) [0x0006e] in <cf516e4846354910b3d60749c894b1bf>: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,System.Data.CommandBehavior)
  at System.Data.SQLite.SQLiteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x0000c] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteScalar (System.Data.CommandBehavior behavior) [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteScalar () [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
  at Marr.Data.QGen.InsertQueryBuilder`1[T].Execute () [0x00046] in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\QGen\InsertQueryBuilder.cs:140 
  at Marr.Data.DataMapper.Insert[T] (T entity) [0x0005f] in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:728 
  at NzbDrone.Core.Datastore.BasicRepository`1[TModel].Insert (TModel model) [0x00030] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Datastore\BasicRepository.cs:119 
  at NzbDrone.Core.Messaging.Commands.CommandQueueManager.Push[TCommand] (TCommand command, NzbDrone.Core.Messaging.Commands.CommandPriority priority, NzbDrone.Core.Messaging.Commands.CommandTrigger trigger) [0x0015a] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Commands\CommandQueueManager.cs:126 
  at NzbDrone.Core.Messaging.Commands.CommandQueueManager.Push (System.String commandName, System.Nullable`1[T] lastExecutionTime, NzbDrone.Core.Messaging.Commands.CommandPriority priority, NzbDrone.Core.Messaging.Commands.CommandTrigger trigger) [0x000b7] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Commands\CommandQueueManager.cs:139 
  at NzbDrone.Core.Jobs.Scheduler.ExecuteCommands () [0x00043] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Jobs\Scheduler.cs:42 
  at System.Threading.Tasks.Task.InnerInvoke () [0x0000f] in <de882a77e7c14f8ba5d298093dde82b2>:0 
  at System.Threading.Tasks.Task.Execute () [0x00000] in <de882a77e7c14f8ba5d298093dde82b2>:0 

2022-09-21 21:26:20.3|Error|TaskExtensions|Task Error

 

Within Sonarr when I attempt to do a search.  I get the following message:

 

Search failed because its attempt to write a readonly database attempt to write a readonly database. Try refreshing the series info and verify the necessary information is present before searching again

 

I have no idea where the database is or how to fix.  Any ideas,  guys?

  • Upvote 1
Link to comment
On 9/27/2022 at 12:53 AM, eds said:

Hello everyone.

 

Having a weird situation that appears to have come out of nowhere (but I suspect it may be after a recent update).

The database has become readonly. This is part of what I see in the log:

2022-09-21 21:24:45.3|Info|Bootstrap|Starting Sonarr - /app/sonarr/bin/Sonarr.exe - Version 3.0.9.1549
2022-09-21 21:24:46.1|Info|AppFolderInfo|Data directory is being overridden to [/config]
2022-09-21 21:24:46.2|Info|Router|Application mode: Interactive
2022-09-21 21:24:46.6|Info|MigrationLogger|*** Checking database for required migrations data source=/config/sonarr.db;cache size=-10000;datetimekind=Utc;journal mode=Wal;pooling=True;version=3 ***
2022-09-21 21:24:46.9|Info|MigrationLogger|*** Checking database for required migrations data source=/config/logs.db;cache size=-10000;datetimekind=Utc;journal mode=Wal;pooling=True;version=3 ***
2022-09-21 21:24:47.3|Info|OwinHostController|Listening on the following URLs:
2022-09-21 21:24:47.3|Info|OwinHostController|  http://*:8989/
2022-09-21 21:24:48.0|Info|SonarrBootstrapper|Starting Web Server
2022-09-21 21:24:49.9|Error|EventAggregator|QualityDefinitionService failed while processing [ApplicationStartedEvent]

[v3.0.9.1549] code = ReadOnly (8), message = System.Data.SQLite.SQLiteException (0x800017FF): attempt to write a readonly database
attempt to write a readonly database

  at System.Data.SQLite.SQLite3.Reset (System.Data.SQLite.SQLiteStatement stmt) [0x00088] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) [0x0006e] in <cf516e4846354910b3d60749c894b1bf>: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,System.Data.CommandBehavior)
  at System.Data.SQLite.SQLiteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x0000c] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery (System.Data.CommandBehavior behavior) [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery () [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
  at Marr.Data.QGen.UpdateQueryBuilder`1[T].Execute () [0x0003b] in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\QGen\UpdateQueryBuilder.cs:157 
  at Marr.Data.DataMapper.Update[T] (T entity, System.Linq.Expressions.Expression`1[TDelegate] filter) [0x00000] in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:674 
  at NzbDrone.Core.Datastore.BasicRepository`1[TModel].UpdateMany (System.Collections.Generic.IList`1[T] models) [0x00055] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Datastore\BasicRepository.cs:175 
  at NzbDrone.Core.Qualities.QualityDefinitionService.InsertMissingDefinitions () [0x000c9] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Qualities\QualityDefinitionService.cs:92 
  at NzbDrone.Core.Qualities.QualityDefinitionService.Handle (NzbDrone.Core.Lifecycle.ApplicationStartedEvent message) [0x00010] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Qualities\QualityDefinitionService.cs:109 
  at NzbDrone.Core.Messaging.Events.EventAggregator.PublishEvent[TEvent] (TEvent event) [0x0011a] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Events\EventAggregator.cs:92 

2022-09-21 21:24:50.2|Error|EventAggregator|CommandQueueManager failed while processing [ApplicationStartedEvent]

[v3.0.9.1549] code = ReadOnly (8), message = System.Data.SQLite.SQLiteException (0x800017FF): attempt to write a readonly database
attempt to write a readonly database
  at System.Data.SQLite.SQLite3.Reset (System.Data.SQLite.SQLiteStatement stmt) [0x00088] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) [0x0006e] in <cf516e4846354910b3d60749c894b1bf>: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,System.Data.CommandBehavior)
  at System.Data.SQLite.SQLiteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x0000c] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery (System.Data.CommandBehavior behavior) [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery () [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
  at Marr.Data.DataMapper.ExecuteNonQuery (System.String sql) [0x0002a] in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:204 
  at NzbDrone.Core.Messaging.Commands.CommandRepository.OrphanStarted () [0x00064] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Commands\CommandRepository.cs:46 
  at NzbDrone.Core.Messaging.Commands.CommandQueueManager.Handle (NzbDrone.Core.Lifecycle.ApplicationStartedEvent message) [0x00010] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Commands\CommandQueueManager.cs:260 
  at NzbDrone.Core.Messaging.Events.EventAggregator.PublishEvent[TEvent] (TEvent event) [0x0011a] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Events\EventAggregator.cs:92 

2022-09-21 21:24:50.2|Error|EventAggregator|TaskManager failed while processing [ApplicationStartedEvent]

[v3.0.9.1549] code = ReadOnly (8), message = System.Data.SQLite.SQLiteException (0x800017FF): attempt to write a readonly database
attempt to write a readonly database
  at System.Data.SQLite.SQLite3.Reset (System.Data.SQLite.SQLiteStatement stmt) [0x00088] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) [0x0006e] in <cf516e4846354910b3d60749c894b1bf>: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,System.Data.CommandBehavior)
  at System.Data.SQLite.SQLiteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x0000c] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery (System.Data.CommandBehavior behavior) [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery () [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
  at Marr.Data.QGen.UpdateQueryBuilder`1[T].Execute () [0x0003b] in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\QGen\UpdateQueryBuilder.cs:157 
  at Marr.Data.DataMapper.Update[T] (T entity, System.Linq.Expressions.Expression`1[TDelegate] filter) [0x00000] in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:674 
  at NzbDrone.Core.Datastore.BasicRepository`1[TModel].Update (TModel model) [0x0002a] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Datastore\BasicRepository.cs:133 
  at NzbDrone.Core.Datastore.BasicRepository`1[TModel].Upsert (TModel model) [0x00017] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Datastore\BasicRepository.cs:194 
  at NzbDrone.Core.Jobs.TaskManager.Handle (NzbDrone.Core.Lifecycle.ApplicationStartedEvent message) [0x00340] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Jobs\TaskManager.cs:164 
  at NzbDrone.Core.Messaging.Events.EventAggregator.PublishEvent[TEvent] (TEvent event) [0x0011a] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Events\EventAggregator.cs:92 

2022-09-21 21:24:50.5|Error|TaskExtensions|Task Error

[v3.0.9.1549] System.UnauthorizedAccessException: Access to the path "/config/config.xml" is denied.
  at System.IO.FileStream..ctor (System.String path, System.IO.FileMode mode, System.IO.FileAccess access, System.IO.FileShare share, System.Int32 bufferSize, System.Boolean anonymous, System.IO.FileOptions options) [0x0019e] in <de882a77e7c14f8ba5d298093dde82b2>:0 
  at System.IO.FileStream..ctor (System.String path, System.IO.FileMode mode, System.IO.FileAccess access, System.IO.FileShare share, System.Int32 bufferSize, System.IO.FileOptions options) [0x00000] in <de882a77e7c14f8ba5d298093dde82b2>:0 
  at (wrapper remoting-invoke-with-check) System.IO.FileStream..ctor(string,System.IO.FileMode,System.IO.FileAccess,System.IO.FileShare,int,System.IO.FileOptions)
  at System.IO.StreamWriter..ctor (System.String path, System.Boolean append, System.Text.Encoding encoding, System.Int32 bufferSize) [0x00055] in <de882a77e7c14f8ba5d298093dde82b2>:0 
  at System.IO.StreamWriter..ctor (System.String path) [0x00008] in <de882a77e7c14f8ba5d298093dde82b2>:0 
  at (wrapper remoting-invoke-with-check) System.IO.StreamWriter..ctor(string)
  at System.IO.File.WriteAllText (System.String path, System.String contents) [0x00026] in <de882a77e7c14f8ba5d298093dde82b2>:0 
  at NzbDrone.Common.Disk.DiskProviderBase.WriteAllText (System.String filename, System.String contents) [0x00052] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Common\Disk\DiskProviderBase.cs:304 
  at NzbDrone.Core.Configuration.ConfigFileProvider.SaveConfigFile (System.Xml.Linq.XDocument xDoc) [0x00010] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Configuration\ConfigFileProvider.cs:376 
  at NzbDrone.Core.Configuration.ConfigFileProvider.DeleteOldValues () [0x000a7] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Configuration\ConfigFileProvider.cs:333 
  at NzbDrone.Core.Configuration.ConfigFileProvider.HandleAsync (NzbDrone.Core.Lifecycle.ApplicationStartedEvent message) [0x00006] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Configuration\ConfigFileProvider.cs:388 
  at NzbDrone.Core.Messaging.Events.EventAggregator+<>c__DisplayClass6_2`1[TEvent].<PublishEvent>b__2 () [0x00035] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Events\EventAggregator.cs:119 
  at System.Threading.Tasks.Task.InnerInvoke () [0x0000f] in <de882a77e7c14f8ba5d298093dde82b2>:0 
  at System.Threading.Tasks.Task.Execute () [0x00000] in <de882a77e7c14f8ba5d298093dde82b2>:0 

2022-09-21 21:25:20.3|Error|TaskExtensions|Task Error

[v3.0.9.1549] code = ReadOnly (8), message = System.Data.SQLite.SQLiteException (0x800017FF): attempt to write a readonly database
attempt to write a readonly database
  at System.Data.SQLite.SQLite3.Reset (System.Data.SQLite.SQLiteStatement stmt) [0x00088] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) [0x0006e] in <cf516e4846354910b3d60749c894b1bf>: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,System.Data.CommandBehavior)
  at System.Data.SQLite.SQLiteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x0000c] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteScalar (System.Data.CommandBehavior behavior) [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteScalar () [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
  at Marr.Data.QGen.InsertQueryBuilder`1[T].Execute () [0x00046] in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\QGen\InsertQueryBuilder.cs:140 
  at Marr.Data.DataMapper.Insert[T] (T entity) [0x0005f] in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:728 
  at NzbDrone.Core.Datastore.BasicRepository`1[TModel].Insert (TModel model) [0x00030] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Datastore\BasicRepository.cs:119 
  at NzbDrone.Core.Messaging.Commands.CommandQueueManager.Push[TCommand] (TCommand command, NzbDrone.Core.Messaging.Commands.CommandPriority priority, NzbDrone.Core.Messaging.Commands.CommandTrigger trigger) [0x0015a] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Commands\CommandQueueManager.cs:126 
  at System.Dynamic.UpdateDelegates.UpdateAndExecute4[T0,T1,T2,T3,TRet] (System.Runtime.CompilerServices.CallSite site, T0 arg0, T1 arg1, T2 arg2, T3 arg3) [0x00136] in <f6c405b973804b5c804e7e759353765f>:0 
  at (wrapper delegate-invoke) System.Func`6[System.Runtime.CompilerServices.CallSite,NzbDrone.Core.Messaging.Commands.CommandQueueManager,System.Object,NzbDrone.Core.Messaging.Commands.CommandPriority,NzbDrone.Core.Messaging.Commands.CommandTrigger,System.Object].invoke_TResult_T1_T2_T3_T4_T5(System.Runtime.CompilerServices.CallSite,NzbDrone.Core.Messaging.Commands.CommandQueueManager,object,NzbDrone.Core.Messaging.Commands.CommandPriority,NzbDrone.Core.Messaging.Commands.CommandTrigger)
  at NzbDrone.Core.Messaging.Commands.CommandQueueManager.Push (System.String commandName, System.Nullable`1[T] lastExecutionTime, NzbDrone.Core.Messaging.Commands.CommandPriority priority, NzbDrone.Core.Messaging.Commands.CommandTrigger trigger) [0x000b7] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Commands\CommandQueueManager.cs:139 
  at NzbDrone.Core.Jobs.Scheduler.ExecuteCommands () [0x00043] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Jobs\Scheduler.cs:42 
  at System.Threading.Tasks.Task.InnerInvoke () [0x0000f] in <de882a77e7c14f8ba5d298093dde82b2>:0 
  at System.Threading.Tasks.Task.Execute () [0x00000] in <de882a77e7c14f8ba5d298093dde82b2>:0 

2022-09-21 21:25:50.3|Error|TaskExtensions|Task Error

[v3.0.9.1549] code = ReadOnly (8), message = System.Data.SQLite.SQLiteException (0x800017FF): attempt to write a readonly database
attempt to write a readonly database
  at System.Data.SQLite.SQLite3.Reset (System.Data.SQLite.SQLiteStatement stmt) [0x00088] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) [0x0006e] in <cf516e4846354910b3d60749c894b1bf>: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,System.Data.CommandBehavior)
  at System.Data.SQLite.SQLiteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x0000c] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteScalar (System.Data.CommandBehavior behavior) [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteScalar () [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
  at Marr.Data.QGen.InsertQueryBuilder`1[T].Execute () [0x00046] in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\QGen\InsertQueryBuilder.cs:140 
  at Marr.Data.DataMapper.Insert[T] (T entity) [0x0005f] in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:728 
  at NzbDrone.Core.Datastore.BasicRepository`1[TModel].Insert (TModel model) [0x00030] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Datastore\BasicRepository.cs:119 
  at NzbDrone.Core.Messaging.Commands.CommandQueueManager.Push[TCommand] (TCommand command, NzbDrone.Core.Messaging.Commands.CommandPriority priority, NzbDrone.Core.Messaging.Commands.CommandTrigger trigger) [0x0015a] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Commands\CommandQueueManager.cs:126 
  at NzbDrone.Core.Messaging.Commands.CommandQueueManager.Push (System.String commandName, System.Nullable`1[T] lastExecutionTime, NzbDrone.Core.Messaging.Commands.CommandPriority priority, NzbDrone.Core.Messaging.Commands.CommandTrigger trigger) [0x000b7] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Commands\CommandQueueManager.cs:139 
  at NzbDrone.Core.Jobs.Scheduler.ExecuteCommands () [0x00043] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Jobs\Scheduler.cs:42 
  at System.Threading.Tasks.Task.InnerInvoke () [0x0000f] in <de882a77e7c14f8ba5d298093dde82b2>:0 
  at System.Threading.Tasks.Task.Execute () [0x00000] in <de882a77e7c14f8ba5d298093dde82b2>:0 

2022-09-21 21:26:20.3|Error|TaskExtensions|Task Error

 

Within Sonarr when I attempt to do a search.  I get the following message:

 

Search failed because its attempt to write a readonly database attempt to write a readonly database. Try refreshing the series info and verify the necessary information is present before searching again

 

I have no idea where the database is or how to fix.  Any ideas,  guys?

 

I had a similar problem after an update to Unraid 6.11.0. The problem was caused by wrong permissions in the /config directory of the container. By reseting the permissions, which is done by removing the file perms.txt in /config and then restarting the container all issues went away.

 

 Hope this helps :)

Link to comment
  • 4 weeks later...

So I had some free time and decided to use 2 sonarr instances to handle my media.

All went well except one minor issue.

When SoanrrA sends "something" to deluge, that "something" shows up in SonarrB under Activity > Queue. With status "In progress".

Seems that deluge sends some info back to both SonarrA and SonarrB.

 

Anyone had this issue ?

Link to comment
  • 3 weeks later...
On 10/24/2022 at 7:40 PM, suyac said:

So I had some free time and decided to use 2 sonarr instances to handle my media.

All went well except one minor issue.

When SoanrrA sends "something" to deluge, that "something" shows up in SonarrB under Activity > Queue. With status "In progress".

Seems that deluge sends some info back to both SonarrA and SonarrB.

 

Anyone had this issue ?

 

This started happening to me also, I never had this problem before. Did you manage to fix it?

Link to comment
On 9/30/2022 at 3:36 PM, Br3Gott said:

 

I had a similar problem after an update to Unraid 6.11.0. The problem was caused by wrong permissions in the /config directory of the container. By reseting the permissions, which is done by removing the file perms.txt in /config and then restarting the container all issues went away.

 

 Hope this helps :)

 

EDIT / UPDATE (11/21/22):

So, using Krusader, I changed the 'Group' and 'Others' permissions of the sonarr.db files from 'Can Only View' to 'Can View & Modify.' This is probably the exact wrong way to do it, but it worked and Sonarr seems to be up and running again. If I've done something horribly wrong that should be corrected immediately, someone please let me know. Otherwise since it's working I'm considering this closed. FYI and thanks!


 

ORIGINAL:

(TL;DR Same readonly database issue, but don't see a perms.txt and don't know how to fix)

 

Hi - I hope someone will please take pity on me. I set up my UnRaid server a couple of years ago and really haven't thought about it since as it'a all just been working. So I've generally taken a hands-off, if it ain't broke don't fix it approach. 

 

I'd held off on updating from 6.9.2 for fear of breaking things until a couple of days ago when I finally updated to 6.11.3. Sure enough, things broke. 

 

Reading around, I found that the issues seemed to be the Docker / PUID / PGID issues that many had been reporting. In particular, binhex-sabnzbd didn't want to load. 

 

Changing from 99 / 100 to 1000 / 100 on binhex-sabnzbd (and only that Docker) seemed to do the trick and then all seemed to be going well - I did a test request through Overseerr of a movie which downloaded through Radarr / binhex-sabnzbd and then on to Plex so I thought all was well. Until I realized that Sonarr wasn't downloading anything. 

 

(IMPORTANT NOTE: JUST BECAUSE I'M THROWING THESE NUMBERS AROUND DOESN'T MEAN THAT I HAVE ANYTHING MORE THAN THE VAGUEST CLUE WHAT THEY MEAN BESIDES SOME GOOGLING!)

 

I'm getting the same "[v3.0.9.1549] code = ReadOnly (8), message = System.Data.SQLite.SQLiteException (0x800017FF): attempt to write a readonly database attempt to write a readonly database" error, but changing from 99 / 100 to 1000 / 100 didn't help. 

 

Finding this thread I started looking for a perms.txt file and while I can find that file in other dockers (binhex-preclear, binhex-sabnzbd, nzbgetvpn), I don't see one in Sonarr. 

 

Please help - I'm not Linux-savvy enough to truly grok all the discussions around users / permissions and if I can't get this fixed my only recourse will be to restore back to 6.9.2 and hope that helps. 

 

THANK YOU IN ADVANCE!!!!!

 

Edited by Highfalutintodd
Link to comment

Hello I am new to unraid and docker in general...

 

And Im sorry I have read a few pages up, and I still dont understand... I know sonarr/radarr are looking in two different places than the torrent client, but I dont get where they are looking. I keep getting the same error as everyone else that the "Import failed, path does not exist or is not accessible by Radarr: /data/completed/movie_title"

 

I attempted to change things according to what another user posted above and its still wrong. I need someone to walk me through exactly what to change. Because the file locations are not mapping correctly in Sonarr,  I still get the same error. 

 

Plus maybe it would help us newbies if we had pictures. Because I would assume its correct, but obviously its not, because of the errors I am getting.

 

Thanks!

Tomorrow.png

Today.png

Link to comment
15 hours ago, Mrtj18 said:

. I know sonarr/radarr are looking in two different places than the torrent client,

Both halves of the mappings must match.

At the moment, you have /data on one, and /downloads on the other. Change all the /mnt/cache/Downloads mappings to the same thing, whether it's /data or /downloads doesn't really matter, just has to be the same for all the download clients.

  • Like 1
Link to comment

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.