Sonarr version (exact version):
Version 4.0.4.1491
Package Version release-38868c1 by [hotio](https://github.com/hotio)
.NET Yes (6.0.13)
Docker Yes
Database Sqlite 3.44.2
Mono version (if Sonarr is not running on Windows):
OS: Ubuntu 23.10
Running in docker
Debug logs:
Description of issue:
Sonarr runs fine but the console log shows an error recurring every 4 minutes, to do with a list. I will include:
-
the stack trace
-
the list parameters displayed/stored in Sonarr
-
the details of the list created in listrrpro
-
Stack trace:
2024-05-17T21:56:14.062421566Z [Info] ImportListSyncService: Starting Import List Refresh for List Listrrpro dir
2024-05-17T21:56:14.321040490Z [Error] FetchAndParseImportListService: Error during Import List Sync of Custom List (Listrrpro dir)
2024-05-17T21:56:14.321069893Z
2024-05-17T21:56:14.321074739Z [v4.0.4.1491] code = Constraint (19), message = System.Data.SQLite.SQLiteException (0x800027AF): constraint failed
2024-05-17T21:56:14.321079059Z NOT NULL constraint failed: ImportListItems.Title
2024-05-17T21:56:14.321083233Z at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
2024-05-17T21:56:14.321087388Z at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
2024-05-17T21:56:14.321091505Z at System.Data.SQLite.SQLiteDataReader.NextResult()
2024-05-17T21:56:14.321095613Z at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
2024-05-17T21:56:14.321099908Z at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
2024-05-17T21:56:14.321104050Z at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior) in /_/Dapper/SqlMapper.cs:line 1075
2024-05-17T21:56:14.321108361Z at Dapper.SqlMapper.QueryMultipleImpl(IDbConnection cnn, CommandDefinition& command) in /_/Dapper/SqlMapper.cs:line 1058
2024-05-17T21:56:14.321112891Z at NzbDrone.Core.Datastore.BasicRepository`1.Insert(IDbConnection connection, IDbTransaction transaction, TModel model) in ./Sonarr.Core/Datastore/BasicRepository.cs:line 188
2024-05-17T21:56:14.321117173Z at NzbDrone.Core.Datastore.BasicRepository`1.InsertMany(IList`1 models) in ./Sonarr.Core/Datastore/BasicRepository.cs:line 210
2024-05-17T21:56:14.321121356Z at NzbDrone.Core.ImportLists.ImportListItems.ImportListItemService.SyncSeriesForList(List`1 listSeries, Int32 listId) in ./Sonarr.Core/ImportLists/ImportListItems/ImportListItemService.cs:line 35
2024-05-17T21:56:14.321125726Z at NzbDrone.Core.ImportLists.FetchAndParseImportListService.<>c__DisplayClass6_0.<FetchSingleList>b__0() in ./Sonarr.Core/ImportLists/FetchAndParseImportListService.cs:line 137
2024-05-17T21:56:14.321149228Z
2024-05-17T21:56:14.322628444Z [Info] ImportListSyncService: Processing 98 list items
2024-05-17T21:56:14.332387206Z [Info] ImportListSyncService: Import List Sync Completed. Items found: 98, Series added: 0
- The list parameters of the failing Import list in Sonarr:
- Name: Listrrpro dir
- Enable Automatic Add: true
- Search for Missing episodes: true
- Monitor: All episodes
- Monitor New Seasons: All seasons
- Root Folder: /data/tv (5.4 TiB free)
- Quality Profile: Any
- Series type: Standard
- Season Folder: true
- Sonarr Tags: listrrpro
- List URL: https://listrr.pro/api/Import/Sonarr/66130622f71f6bafb8b93715?apikey=41793290426047cd926d998772f7faa4193b50f04d9540ddad0a708e26674af9
A ‘test’ done on this succeeds.
- Details of the list created in Listrrpro
- Name: “Best tv by dir”
- Last processed: 22 minutes ago
- Type: Show
- State: None
- IsStatic: No
- IsPrivate: Yes
- Items: 100
- Upvotes: 0
- Created: One month ago
- Modified: 22 minutes ago
This list currently has 100 items in it, including 2 occurrences of duplicate items, thus 98 actual unique items).
Details of this list: (if field omitted, defaults are used)
Basic filters:
- Include: Between 2010 and 2024
- Exclude: Between 1965 and 2009
Rating filters: - TMDb Rating: Between 8 and 10 with at least 100 votes
- IMDb Rating: Between 8 and 10
Content rating filter:
Include: Content rating country: Canada, United Kingdom of Great Britain and Northern Ireland, United States of America
Nationality filter: Include: English