Carmelo Posted September 29, 2022 Share Posted September 29, 2022 i deleted, renamed logs.db and its not working for me Quote Link to comment
smikwily Posted September 29, 2022 Share Posted September 29, 2022 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! 1 Quote Link to comment
Mogo Posted September 29, 2022 Share Posted September 29, 2022 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. Quote Link to comment
Tolete Posted September 30, 2022 Share Posted September 30, 2022 3 days and counting, still importing yay! 💀smh Quote Link to comment
s449 Posted October 7, 2022 Share Posted October 7, 2022 (edited) 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, 2022 by s449 Quote Link to comment
wgstarks Posted October 7, 2022 Share Posted October 7, 2022 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. Quote Link to comment
Supershocker Posted October 13, 2022 Share Posted October 13, 2022 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. Quote Link to comment
Timpalimpa Posted October 19, 2022 Share Posted October 19, 2022 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... Quote Link to comment
T_Matz Posted October 22, 2022 Share Posted October 22, 2022 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 Quote Link to comment
T_Matz Posted October 24, 2022 Share Posted October 24, 2022 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 Quote Link to comment
binhex Posted October 24, 2022 Author Share Posted October 24, 2022 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. Quote Link to comment
T_Matz Posted October 25, 2022 Share Posted October 25, 2022 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! 1 Quote Link to comment
IzzleDude Posted October 27, 2022 Share Posted October 27, 2022 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 Quote Link to comment
wgstarks Posted October 27, 2022 Share Posted October 27, 2022 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 Quote Link to comment
CarlP Posted October 27, 2022 Share Posted October 27, 2022 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 Quote Link to comment
DanielPT Posted November 3, 2022 Share Posted November 3, 2022 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! Quote Link to comment
wgstarks Posted November 3, 2022 Share Posted November 3, 2022 32 minutes ago, DanielPT said: Can somebody figure this out? Post your docker run command. 1 Quote Link to comment
DanielPT Posted November 4, 2022 Share Posted November 4, 2022 22 hours ago, wgstarks said: Post your docker run command. here you go. And thanks! Radarr and qbitorrent log.txt Quote Link to comment
wgstarks Posted November 4, 2022 Share Posted November 4, 2022 (edited) 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, 2022 by wgstarks Typo 1 Quote Link to comment
DanielPT Posted November 5, 2022 Share Posted November 5, 2022 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? Quote Link to comment
DanielPT Posted November 5, 2022 Share Posted November 5, 2022 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! Quote Link to comment
wgstarks Posted November 5, 2022 Share Posted November 5, 2022 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. 1 Quote Link to comment
DanielPT Posted November 5, 2022 Share Posted November 5, 2022 Ahh i changed it in Radarr and now it works! Thanks man! Quote Link to comment
wgstarks Posted November 5, 2022 Share Posted November 5, 2022 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. Quote Link to comment
DanielPT Posted November 5, 2022 Share Posted November 5, 2022 Im all new to radarr. Why do i get this? Thnaks! 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.