i deleted, renamed logs.db and its not working for me

On 9/28/2022 at 4:50 PM, haakony said:

just a heads up if someone is still having problems, deleting logs.db fixed it for me. 

Diddent notice it was the logs.db database that was malformed.

 

if you want to fix it, theres a faq on it.
https://wiki.servarr.com/en/radarr/faq

https://wiki.servarr.com/useful-tools#recovering-a-corrupt-db-ui

Thanks for this. I was trying to recover backups, etc. and wasn't have much luck. Checked here to see if I was missing anything and after restoring my original files and nuking the logs.db, it started working without issue!

9 hours ago, Carmelo said:

i deleted, renamed logs.db and its not working for me

You should check the logs and see which error you have.  I assume you get this error " Database disk image is malformed"... however, after that you probably get either one of these errors " Error creating log database" or "Error creating main database". 

 

If you have the main database error then deleting and renaming the log file will not solve the problem.  When you go here: https://wiki.servarr.com/en/radarr/faq follow the instructions under "Errors of Error creating main database indicate issues with radarr.db" and that will probably fix the issue.  The first startup will probably take awhile.

 

3 days and counting, still importing yay! 💀smh

The past few days I've been getting on the web UI:

 

Failed to load Radarr

Version 4.2.4.6635

 

Tried a few of the suggestions here and even tried downgrading and restoring Radarr from backup but doing so showed no movies added. Tried repairing my database, didn't work. The error in logs is "System.Data.DataException: Error parsing column 16 (DigitalRelease=16/05/2000 00:00:00 - DateTime)" which makes me feel like there's some movie in my database that is breaking it or something.

 

Full logs:

 

2022-10-06 19:49:42,215 DEBG 'radarr' stdout output:
[Fatal] RadarrErrorPipeline: Request Failed. GET /api/v3/collection 
2022-10-06 19:49:42,215 DEBG 'radarr' stdout output:


[v4.2.4.6635] System.Data.DataException: Error parsing column 16 (DigitalRelease=16/05/2000 00:00:00 - DateTime)
 ---> System.FormatException: String '' was not recognized as a valid DateTime.
   at System.DateTimeParse.ParseExactMultiple(ReadOnlySpan`1 s, String[] formats, DateTimeFormatInfo dtfi, DateTimeStyles style)
   at System.Data.SQLite.SQLiteConvert.ToDateTime(String dateText, SQLiteDateFormats format, DateTimeKind kind, String formatString)
   at System.Data.SQLite.SQLite3.GetDateTime(SQLiteStatement stmt, Int32 index)
   at System.Data.SQLite.SQLite3.GetValue(SQLiteStatement stmt, SQLiteConnectionFlags flags, Int32 index, SQLiteType typ)
   at System.Data.SQLite.SQLiteDataReader.GetValue(Int32 i)
   at Deserialize7df62f75-f090-4bae-8863-2ca15258a174(IDataReader )
   --- End of inner exception stack trace ---
   at Dapper.SqlMapper.ThrowDataException(Exception ex, Int32 index, IDataReader reader, Object value) in /_/Dapper/SqlMapper.cs:line 3706
   at Deserialize7df62f75-f090-4bae-8863-2ca15258a174(IDataReader )
   at Dapper.SqlMapper.<>c__DisplayClass160_0`8.<GenerateMapper>b__0(IDataReader r)
   at Dapper.SqlMapper.MultiMapImpl[TFirst,TSecond,TThird,TFourth,TFifth,TSixth,TSeventh,TReturn](IDbConnection cnn, CommandDefinition command, Delegate map, String splitOn, IDataReader reader, Identity identity, Boolean finalize)+MoveNext()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)

2022-10-06 19:49:42,216 DEBG 'radarr' stdout output:
   at Dapper.SqlMapper.MultiMap[TFirst,TSecond,TThird,TFourth,TFifth,TSixth,TSeventh,TReturn](IDbConnection cnn, String sql, Delegate map, Object param, IDbTransaction transaction, Boolean buffered, String splitOn, Nullable`1 commandTimeout, Nullable`1 commandType)
   at Dapper.SqlMapper.Query[TFirst,TSecond,TReturn](IDbConnection cnn, String sql, Func`3 map, Object param, IDbTransaction transaction, Boolean buffered, String splitOn, Nullable`1 commandTimeout, Nullable`1 commandType)
   at NzbDrone.Core.Datastore.SqlMapperExtensions.Query[TFirst,TSecond,TReturn](IDatabase db, String sql, Func`3 map, Object param, IDbTransaction transaction, Boolean buffered, String splitOn, Nullable`1 commandTimeout, Nullable`1 commandType)
   at NzbDrone.Core.Datastore.SqlMapperExtensions.QueryJoined[T,T2](IDatabase db, SqlBuilder builder, Func`3 mapper)
   at NzbDrone.Core.Movies.MovieMetadataRepository.GetMoviesWithCollections()
   at NzbDrone.Core.Movies.MovieMetadataService.GetMoviesWithCollections()
   at Radarr.Api.V3.Collections.CollectionController.MapToResource(List`1 collections)+MoveNext()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at Radarr.Api.V3.Collections.CollectionController.GetCollections(Nullable`1 tmdbId)
   at lambda_method12(Closure , Object , Object[] )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync()
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)

2022-10-06 19:49:42,216 DEBG 'radarr' stdout output:
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync()
--- End of stack trace from previous location ---
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync()
--- End of stack trace from previous location ---
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeFilterPipelineAsync>g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)
   at Microsoft.AspNetCore.Routing.EndpointMiddleware.<Invoke>g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger)
   at Radarr.Http.Middleware.BufferingMiddleware.InvokeAsync(HttpContext context)
   at Radarr.Http.Middleware.IfModifiedMiddleware.InvokeAsync(HttpContext context)
   at Radarr.Http.Middleware.CacheHeaderMiddleware.InvokeAsync(HttpContext context)
   at Radarr.Http.Middleware.UrlBaseMiddleware.InvokeAsync(HttpContext context)
   at Radarr.Http.Middleware.VersionMiddleware.InvokeAsync(HttpContext context)
   at Microsoft.AspNetCore.ResponseCompression.ResponseCompressionMiddleware.InvokeCore(HttpContext context)
   at Microsoft.AspNetCore.Authorization.Policy.AuthorizationMiddlewareResultHandler.HandleAsync(RequestDelegate next, HttpContext context, AuthorizationPolicy policy, PolicyAuthorizationResult authorizeResult)
   at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.<Invoke>g__Awaited|6_0(ExceptionHandlerMiddleware middleware, HttpContext context, Task task)
SQL: 
==== Begin Query Trace ====

QUERY TEXT:
SELECT "MovieMetadata".*, "MovieTranslations".*
 FROM "MovieMetadata"   
LEFT JOIN "MovieTranslations" ON ("MovieMetadata"."Id" = "MovieTranslations"."MovieMetadataId")
2022-10-06 19:49:42,216 DEBG 'radarr' stdout output:

 WHERE ("MovieMetadata"."CollectionTmdbId" > @Clause2_P1)
   

PARAMETERS:
Clause2_P1 = [0]

==== End Query Trace ====

 

EDIT: Ended up downgrading to 4.1.0.6175-1-01, restoring from a backup from 9/23, and deleting logs.db. It's working again. I assume as long as I don't update.

Edited October 7, 20223 yr by s449

You may want to post regarding this in a Radarr forum. I may be wrong but really don’t think this is really an issue with the docker container. I think it’s an issue with the app itself. Someone in that forum may be able to point you towards a resolution.

Im not sure what happened but Radarr has stopped being able to update its 'activity' page. even after manually selecting downloads it is unable to display the files. downloads are successfully being sent to torrent client. I am unable to import the movies from webui.

I also have problem now. Just stopped working.
Cant add any new movies. Radarr does not search or add covers or anything.

I cant manually click on tasks in system settings.
Something is broken...

Radarr is unreachable for me. When i try to connect to the webui i get a refused connection. Sonarr connects just fine with no issues. Doe anyone know what i can do to fix this issue?

Binhex-radarr log.txt

I am still unable to get Radarr to open. I am getting an ERR_connection_refused error. Every other docker opens correctly. RADARR was able to open 2 weeks ago with no issues. I am not sure what I should do. Ive attached the logs and a screen shot of my set up. Any help is greatly appreciated. 

Binhex-radarr log.txt

3 hours ago, T_Matz said:

I am still unable to get Radarr to open. I am getting an ERR_connection_refused error. Every other docker opens correctly. RADARR was able to open 2 weeks ago with no issues. I am not sure what I should do. Ive attached the logs and a screen shot of my set up. Any help is greatly appreciated. 

Binhex-radarr log.txt 10.42 kB · 0 downloads

i would suspect your radarr database is corrupt, if you can try a restore of your config, if you dont have a backup then rename the database (/config/radarr/radarr.db), then restart the container, this will of course result in data loss in radarr so you may/will need to re-import everything.

That worked! Thank you, i did have a back up so the data base was still there and its attempting to repair now. Thank you so much!

I mapped the folder that has all the movies exactly like i did with the TV shows for Sonarr  but then i try and add it in the radar app  its blank and no movies show up i keep reading its possible a permission issue but not sure how to fix this  any advice is appriciated 

13 minutes ago, IzzleDude said:

I mapped the folder that has all the movies exactly like i did with the TV shows for Sonarr  but then i try and add it in the radar app  its blank and no movies show up i keep reading its possible a permission issue but not sure how to fix this  any advice is appriciated 

What do the logs show when you attempt to import the files?

system>log files

Unraid Version: 6.9.2

Updated Radarr 4.1.0.6175 to latest 4.2.4.6635

Completed without error 

Up and running No issues so far

Hmm i really dont understand why i get this error

 

You are using docker; download client Qbittorrent places downloads in /data/media/torrents/movies but this directory does not appear to exist inside the container. Review your remote path mappings and container volume settings.

 

Looking at this
https://trash-guides.info/Hardlinks/How-to-setup-for/Unraid/

 

And this:

 

 

Qbitorrent:

 

Default save path: /data/torrents

 

radarr:

 

Can somebody figure this out?

Thanks!

32 minutes ago, DanielPT said:

Can somebody figure this out?

Post your docker run command.

22 hours ago, wgstarks said:

Post your docker run command.

here you go. And thanks!

Radarr and qbitorrent log.txt

2 hours ago, DanielPT said:

here you go. And thanks!

Radarr and qbitorrent log.txt 4.37 kB · 2 downloads

The data paths for qbit and Radarr must be configured exactly the same (container and host paths both) for qbit and any *arrs you use. Otherwise you’ll get errors that downloads could not be found.

 

I would suggest simplifying your docker configuration and use just /data for the container path and leave the host path as it is. The path for downloads inside the app would be /data/<whatever you want to name the download folder>. This would be configured in the qbit app settings. Be sure to scroll down and click “save” once you add the download location.

 

Edited November 4, 20223 yr by wgstarks
Typo

9 hours ago, wgstarks said:

The data paths for qbit and Radarr must be configured exactly the same (container and host paths both) for qbit and any *arrs you use. Otherwise you’ll get errors that downloads could not be found.

 

I would suggest simplifying your docker configuration and use just /data for the container path and leave the host path as it is. The path for downloads inside the app would be /data/<whatever you want to name the download folder>. This would be configured in the qbit app settings. Be sure to scroll down and click “save” once you add the download location.

 

 

Thanks for the reply

 

I just followed Ibracoprs guide

 

But i still get the error?

 

QBit:

 

 

radarr:

 

Isent that correct?

I followed 

https://trash-guides.info/Downloaders/qBittorrent/How-to-add-categories/

https://trash-guides.info/Hardlinks/How-to-setup-for/Unraid/#torrent-clients

 

And NOW the error is gone!

2 hours ago, DanielPT said:

Isent that correct?

No. They don’t match. This configuration will result in Radarr not being able to find the completed downloads and results in the error you posted. Change your qbit and Radarr configurations to /data:/mnt/user/data/torrents.

Ahh i changed it in Radarr and now it works!

 

Thanks man!

2 minutes ago, DanielPT said:

Ahh i changed it in Radarr and now it works!

 

Thanks man!

If you use Sonarr or any other *arrs you’ll need to use the exact same paths there as well.

Im all new to radarr.

Why do i get this?

Thnaks!