search

morpheus65535 / bazarr

Bazarr is a companion application to Sonarr and Radarr. It manages and downloads subtitles based on your requirements. You define your preferences by TV show or movie and Bazarr takes care of everything for you.
https://www.bazarr.media
GNU General Public License v3.0
2.86k stars 223 forks source link

Job "Update Movie list from Radarr/Sonarr" raised an exception #817

Closed vegovs closed 4 years ago

vegovs commented 4 years ago

Describe the bug Job "Update Movie list from Radarr" raised an exception

To Reproduce Steps to reproduce the behavior: N\A

Expected behavior Update movie list from Radarr/Sonarr

Screenshots If applicable, add screenshots to help explain your problem. image

Software (please complete the following information):

Additional context Traceback (most recent call last):  File "/opt/bazarr/bazarr/../libs/apscheduler/executors/base.py", line 125, in run_job   retval = job.func(*job.args, **job.kwargs)  File "/opt/bazarr/bazarr/get_movies.py", line 243, in update_movies   if result > 0: TypeError: >\ not supported between instances of \str\ and \int\

morpheus65535 commented 4 years ago

Please provide a complete debug log while reproducing the issue.

vegovs commented 4 years ago

13/02/2020 19:21:10|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:21:10|DEBUG |sqlite3worker |execute: INSERT OR IGNORE INTO table_movies(radarrId,title,path,tmdbId,languages,subtitles,hearing_impaired,overview,poster,fanart,audio_language,sceneName,monitored,sortTitle,year,alternativeTitles,format,resolution,video_codec,audio_codec,imdbId,forced,movie_file_id) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), (268, 'The Lion King', '/mnt/media/Movies/The Lion King (2019)/The Lion King (2019).mp4', 420818, "['en']", '[]', 'False', "Simba idolizes his father, King Mufasa, and takes to heart his own royal destiny. But not everyone in the kingdom celebrates the new cub's arrival. Scar, Mufasa's brother—and former heir to the throne—has plans of his own. The battle for Pride Rock is ravaged with betrayal, tragedy and drama, ultimately resulting in Simba's exile. With help from a curious pair of newfound friends, Simba will have to figure out how to grow up and take back what is rightfully his.", '/MediaCover/268/poster-500.jpg', '/MediaCover/268/fanart.jpg', 'English', 'The Lion King (2019) [BluRay] [1080p] [YTS.LT]', 'True', 'lion king', 2019, '[]', 'Bluray', '1080p', 'h264', 'AAC', 'tt6105098', 'False', 178)| 13/02/2020 19:21:10|DEBUG |sqlite3worker |Sleeping: 0.001 17bf37c4-015f-4bb9-a08b-f7696efac14b| 13/02/2020 19:21:10|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:21:10|DEBUG |sqlite3worker |run: INSERT OR IGNORE INTO table_movies(radarrId,title,path,tmdbId,languages,subtitles,hearing_impaired,overview,poster,fanart,audio_language,sceneName,monitored,sortTitle,year,alternativeTitles,format,resolution,video_codec,audio_codec,imdbId,forced,movie_file_id) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), (268, 'The Lion King', '/mnt/media/Movies/The Lion King (2019)/The Lion King (2019).mp4', 420818, "['en']", '[]', 'False', "Simba idolizes his father, King Mufasa, and takes to heart his own royal destiny. But not everyone in the kingdom celebrates the new cub's arrival. Scar, Mufasa's brother—and former heir to the throne—has plans of his own. The battle for Pride Rock is ravaged with betrayal, tragedy and drama, ultimately resulting in Simba's exile. With help from a curious pair of newfound friends, Simba will have to figure out how to grow up and take back what is rightfully his.", '/MediaCover/268/poster-500.jpg', '/MediaCover/268/fanart.jpg', 'English', 'The Lion King (2019) [BluRay] [1080p] [YTS.LT]', 'True', 'lion king', 2019, '[]', 'Bluray', '1080p', 'h264', 'AAC', 'tt6105098', 'False', 178)| 13/02/2020 19:21:10|ERROR |sqlite3worker |Query returned error: INSERT OR IGNORE INTO table_movies(radarrId,title,path,tmdbId,languages,subtitles,hearing_impaired,overview,poster,fanart,audio_language,sceneName,monitored,sortTitle,year,alternativeTitles,format,resolution,video_codec,audio_codec,imdbId,forced,movie_file_id) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?): (268, 'The Lion King', '/mnt/media/Movies/The Lion King (2019)/The Lion King (2019).mp4', 420818, "['en']", '[]', 'False', "Simba idolizes his father, King Mufasa, and takes to heart his own royal destiny. But not everyone in the kingdom celebrates the new cub's arrival. Scar, Mufasa's brother—and former heir to the throne—has plans of his own. The battle for Pride Rock is ravaged with betrayal, tragedy and drama, ultimately resulting in Simba's exile. With help from a curious pair of newfound friends, Simba will have to figure out how to grow up and take back what is rightfully his.", '/MediaCover/268/poster-500.jpg', '/MediaCover/268/fanart.jpg', 'English', 'The Lion King (2019) [BluRay] [1080p] [YTS.LT]', 'True', 'lion king', 2019, '[]', 'Bluray', '1080p', 'h264', 'AAC', 'tt6105098', 'False', 178): attempt to write a readonly database| 13/02/2020 19:21:10|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:21:10|ERROR |apscheduler.executors.default |Job "Update Movie list from Radarr (trigger: interval[0:05:00], next run at: 2020-02-13 19:26:10 CET)" raised an exception|Traceback (most recent call last): File "/opt/bazarr/bazarr/../libs/apscheduler/executors/base.py", line 125, in run_job retval = job.func(job.args, job.kwargs) File "/opt/bazarr/bazarr/get_movies.py", line 243, in update_movies if result > 0:TypeError: '>' not supported between instances of 'str' and 'int'| 13/02/2020 19:21:16|DEBUG |apscheduler.scheduler |Looking for jobs to run| 13/02/2020 19:21:16|DEBUG |apscheduler.scheduler |Next wakeup is due at 2020-02-13 19:22:16.700919+01:00 (in 59.999174 seconds)| 13/02/2020 19:21:16|INFO |apscheduler.executors.default |Running job "Update Series list from Sonarr (trigger: interval[0:01:00], next run at: 2020-02-13 19:22:16 CET)" (scheduled at 2020-02-13 19:21:16.700919+01:00)| 13/02/2020 19:21:16|DEBUG |urllib3.connectionpool |Starting new HTTP connection (1): 127...:8989| 13/02/2020 19:21:16|DEBUG |subliminal_patch.http |DNS: Falling back to default DNS or IP on 127...| 13/02/2020 19:21:16|DEBUG |urllib3.connectionpool |http://127...:8989 "GET /api/system/status?apikey=****48 HTTP/1.1" 200 None| 13/02/2020 19:21:16|DEBUG |urllib3.connectionpool |Starting new HTTP connection (1): 127...:8989| 13/02/2020 19:21:16|DEBUG |subliminal_patch.http |DNS: Falling back to default DNS or IP on 127...| 13/02/2020 19:21:16|DEBUG |urllib3.connectionpool |http://127.***.***.***:8989 "GET /api/system/status?apikey=****48 HTTP/1.1" 200 None| 13/02/2020 19:21:16|DEBUG |urllib3.connectionpool |Starting new HTTP connection (1): 127...:8989| 13/02/2020 19:21:16|DEBUG |subliminal_patch.http |DNS: Falling back to default DNS or IP on 127...| 13/02/2020 19:21:16|DEBUG |urllib3.connectionpool |http://127.***.***.***:8989 "GET /api/profile?apikey=****48 HTTP/1.1" 200 None| 13/02/2020 19:21:16|DEBUG |urllib3.connectionpool |Starting new HTTP connection (1): 127...:8989| 13/02/2020 19:21:16|DEBUG |subliminal_patch.http |DNS: Falling back to default DNS or IP on 127...| 13/02/2020 19:21:16|DEBUG |urllib3.connectionpool |http://127.***.***.***:8989 "GET /api/series?apikey=****48 HTTP/1.1" 200 None| 13/02/2020 19:21:16|DEBUG |sqlite3worker |execute: SELECT sonarrSeriesId FROM table_shows, None| 13/02/2020 19:21:16|DEBUG |sqlite3worker |Sleeping: 0.001 bb5b951e-288d-4bb7-bb34-b556f7fdde52| 13/02/2020 19:21:16|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:21:16|DEBUG |sqlite3worker |run: SELECT sonarrSeriesId FROM table_shows, []| 13/02/2020 19:21:16|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:21:16|DEBUG |sqlite3worker |execute: SELECT title, path, tvdbId, sonarrSeriesId, overview, poster, fanart, audio_language, sortTitle, year, alternateTitles FROM table_shows, None| 13/02/2020 19:21:16|DEBUG |sqlite3worker |Sleeping: 0.001 93adb957-da2e-46c3-9e1e-2a70f5777186| 13/02/2020 19:21:16|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:21:16|DEBUG |sqlite3worker |run: SELECT title, path, tvdbId, sonarrSeriesId, overview, poster, fanart, audio_language, sortTitle, year, alternateTitles FROM table_shows, []| 13/02/2020 19:21:16|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:21:16|DEBUG |sqlite3worker |execute: UPDATE table_shows SET title=?,path=?,tvdbId=?,sonarrSeriesId=?,overview=?,poster=?,fanart=?,audio_language=?,sortTitle=?,year=?,alternateTitles=? WHERE sonarrSeriesId = ?, ('The Mandalorian', '/mnt/media/TV-Series/The Mandalorian', 361753, 1, '“The Mandalorian” is set after the fall of the Empire and before the emergence of the First Order. We follow the travails of a lone gunfighter in the outer reaches of the galaxy, far from the authority of the New Republic.', '/MediaCover/1/poster-250.jpg', '/MediaCover/1/fanart.jpg', 'English', 'mandalorian', 2019, '[]', 1)| 13/02/2020 19:21:16|DEBUG |sqlite3worker |Sleeping: 0.001 2b7f319d-2f39-4007-acd4-691e2d077526| 13/02/2020 19:21:16|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:21:16|DEBUG |sqlite3worker |run: UPDATE table_shows SET title=?,path=?,tvdbId=?,sonarrSeriesId=?,overview=?,poster=?,fanart=?,audio_language=?,sortTitle=?,year=?,alternateTitles=? WHERE sonarrSeriesId = ?, ('The Mandalorian', '/mnt/media/TV-Series/The Mandalorian', 361753, 1, '“The Mandalorian” is set after the fall of the Empire and before the emergence of the First Order. We follow the travails of a lone gunfighter in the outer reaches of the galaxy, far from the authority of the New Republic.', '/MediaCover/1/poster-250.jpg', '/MediaCover/1/fanart.jpg', 'English', 'mandalorian', 2019, '[]', 1)| 13/02/2020 19:21:16|ERROR |sqlite3worker |Query returned error: UPDATE table_shows SET title=?,path=?,tvdbId=?,sonarrSeriesId=?,overview=?,poster=?,fanart=?,audio_language=?,sortTitle=?,year=?,alternateTitles=? WHERE sonarrSeriesId = ?: ('The Mandalorian', '/mnt/media/TV-Series/The Mandalorian', 361753, 1, '“The Mandalorian” is set after the fall of the Empire and before the emergence of the First Order. We follow the travails of a lone gunfighter in the outer reaches of the galaxy, far from the authority of the New Republic.', '/MediaCover/1/poster-250.jpg', '/MediaCover/1/fanart.jpg', 'English', 'mandalorian', 2019, '[]', 1): attempt to write a readonly database| 13/02/2020 19:21:16|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:21:16|DEBUG |sqlite3worker |execute: UPDATE table_shows SET title=?,path=?,tvdbId=?,sonarrSeriesId=?,overview=?,poster=?,fanart=?,audio_language=?,sortTitle=?,year=?,alternateTitles=? WHERE sonarrSeriesId = ?, ('Star Trek: Picard', '/mnt/media/TV-Series/Star Trek- Picard', 364093, 2, 'Jean-Luc Picard, former captain of the starship U.S.S. Enterprise, is pulled out of forced retirement and the next chapter of his life, to help a young woman who is pursued by assassins.', '/MediaCover/2/poster-250.jpg', '/MediaCover/2/fanart.jpg', 'English', 'star trek picard', 2020, '[]', 2)| 13/02/2020 19:21:16|DEBUG |sqlite3worker |Sleeping: 0.001 b49f0906-1bed-4f32-a390-e6ca50e27154| 13/02/2020 19:21:16|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:21:16|DEBUG |sqlite3worker |run: UPDATE table_shows SET title=?,path=?,tvdbId=?,sonarrSeriesId=?,overview=?,poster=?,fanart=?,audio_language=?,sortTitle=?,year=?,alternateTitles=? WHERE sonarrSeriesId = ?, ('Star Trek: Picard', '/mnt/media/TV-Series/Star Trek- Picard', 364093, 2, 'Jean-Luc Picard, former captain of the starship U.S.S. Enterprise, is pulled out of forced retirement and the next chapter of his life, to help a young woman who is pursued by assassins.', '/MediaCover/2/poster-250.jpg', '/MediaCover/2/fanart.jpg', 'English', 'star trek picard', 2020, '[]', 2)| 13/02/2020 19:21:16|ERROR |sqlite3worker |Query returned error: UPDATE table_shows SET title=?,path=?,tvdbId=?,sonarrSeriesId=?,overview=?,poster=?,fanart=?,audio_language=?,sortTitle=?,year=?,alternateTitles=? WHERE sonarrSeriesId = ?: ('Star Trek: Picard', '/mnt/media/TV-Series/Star Trek- Picard', 364093, 2, 'Jean-Luc Picard, former captain of the starship U.S.S. Enterprise, is pulled out of forced retirement and the next chapter of his life, to help a young woman who is pursued by assassins.', '/MediaCover/2/poster-250.jpg', '/MediaCover/2/fanart.jpg', 'English', 'star trek picard', 2020, '[]', 2): attempt to write a readonly database| 13/02/2020 19:21:16|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:21:16|DEBUG |sqlite3worker |execute: UPDATE table_shows SET title=?,path=?,tvdbId=?,sonarrSeriesId=?,overview=?,poster=?,fanart=?,audio_language=?,sortTitle=?,year=?,alternateTitles=? WHERE sonarrSeriesId = ?, ('The Outsider (2020)', '/mnt/media/TV-Series/The Outsider (2020)', 365480, 3, 'Based on Stephen King’s bestselling novel of the same name, The Outsider begins by following a seemingly straightforward investigation into the gruesome murder of a young boy. But when an insidious supernatural force edges its way into the case, it leads a seasoned cop and an unorthodox investigator to question everything they believe in.', '/MediaCover/3/poster-250.jpg', '/MediaCover/3/fanart.jpg', 'English', 'outsider 2020', 2020, "['El visitante', 'The Outsider']", 3)| 13/02/2020 19:21:16|DEBUG |sqlite3worker |Sleeping: 0.001 56221838-19ad-4d09-b87e-8e4a8ebe6792| 13/02/2020 19:21:16|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:21:16|DEBUG |sqlite3worker |run: UPDATE table_shows SET title=?,path=?,tvdbId=?,sonarrSeriesId=?,overview=?,poster=?,fanart=?,audio_language=?,sortTitle=?,year=?,alternateTitles=? WHERE sonarrSeriesId = ?, ('The Outsider (2020)', '/mnt/media/TV-Series/The Outsider (2020)', 365480, 3, 'Based on Stephen King’s bestselling novel of the same name, The Outsider begins by following a seemingly straightforward investigation into the gruesome murder of a young boy. But when an insidious supernatural force edges its way into the case, it leads a seasoned cop and an unorthodox investigator to question everything they believe in.', '/MediaCover/3/poster-250.jpg', '/MediaCover/3/fanart.jpg', 'English', 'outsider 2020', 2020, "['El visitante', 'The Outsider']", 3)| 13/02/2020 19:21:16|ERROR |sqlite3worker |Query returned error: UPDATE table_shows SET title=?,path=?,tvdbId=?,sonarrSeriesId=?,overview=?,poster=?,fanart=?,audio_language=?,sortTitle=?,year=?,alternateTitles=? WHERE sonarrSeriesId = ?: ('The Outsider (2020)', '/mnt/media/TV-Series/The Outsider (2020)', 365480, 3, 'Based on Stephen King’s bestselling novel of the same name, The Outsider begins by following a seemingly straightforward investigation into the gruesome murder of a young boy. But when an insidious supernatural force edges its way into the case, it leads a seasoned cop and an unorthodox investigator to question everything they believe in.', '/MediaCover/3/poster-250.jpg', '/MediaCover/3/fanart.jpg', 'English', 'outsider 2020', 2020, "['El visitante', 'The Outsider']", 3): attempt to write a readonly database| 13/02/2020 19:21:16|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:21:16|DEBUG |root |BAZARR All series synced from Sonarr into database.| 13/02/2020 19:21:16|INFO |apscheduler.executors.default |Job "Update Series list from Sonarr (trigger: interval[0:01:00], next run at: 2020-02-13 19:22:16 CET)" executed successfully| 13/02/2020 19:21:57|DEBUG |urllib3.connectionpool |Starting new HTTP connection (1): 127...:8989| 13/02/2020 19:21:57|DEBUG |subliminal_patch.http |DNS: Falling back to default DNS or IP on 127...| 13/02/2020 19:21:57|DEBUG |urllib3.connectionpool |http://127.***.***.***:8989 "GET /api/system/status?apikey=****48 HTTP/1.1" 200 None| 13/02/2020 19:21:57|DEBUG |urllib3.connectionpool |Starting new HTTP connection (1): 127...:7878| 13/02/2020 19:21:57|DEBUG |subliminal_patch.http |DNS: Falling back to default DNS or IP on 127...| 13/02/2020 19:21:57|DEBUG |urllib3.connectionpool |http://127.***.***.***:7878 "GET /api/system/status?apikey=****59 HTTP/1.1" 200 None| 13/02/2020 19:21:57|DEBUG |sqlite3worker |execute: SELECT COUNT() as count FROM table_episodes WHERE missing_subtitles != '[]', None| 13/02/2020 19:21:57|DEBUG |sqlite3worker |Sleeping: 0.001 2f696bce-a1ef-4228-a187-732945ef6a1b| 13/02/2020 19:21:57|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:21:57|DEBUG |sqlite3worker |run: SELECT COUNT() as count FROM table_episodes WHERE missing_subtitles != '[]', []| 13/02/2020 19:21:57|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:21:57|DEBUG |sqlite3worker |execute: SELECT COUNT() as count FROM table_movies WHERE missing_subtitles != '[]', None| 13/02/2020 19:21:57|DEBUG |sqlite3worker |Sleeping: 0.001 7210a975-293a-45d3-bffc-566333d5f2eb| 13/02/2020 19:21:57|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:21:57|DEBUG |sqlite3worker |run: SELECT COUNT() as count FROM table_movies WHERE missing_subtitles != '[]', []| 13/02/2020 19:21:57|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:21:57|DEBUG |sqlite3worker |execute: SELECT configured, updated FROM system, None| 13/02/2020 19:21:57|DEBUG |sqlite3worker |Sleeping: 0.001 e290745d-4dcd-4727-9b3d-8fae87dd6cee| 13/02/2020 19:21:57|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:21:57|DEBUG |sqlite3worker |run: SELECT configured, updated FROM system, []| 13/02/2020 19:21:57|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:22:16|DEBUG |apscheduler.scheduler |Looking for jobs to run| 13/02/2020 19:22:16|DEBUG |apscheduler.scheduler |Next wakeup is due at 2020-02-13 19:23:16.700919+01:00 (in 59.998914 seconds)| 13/02/2020 19:22:16|INFO |apscheduler.executors.default |Running job "Update Series list from Sonarr (trigger: interval[0:01:00], next run at: 2020-02-13 19:23:16 CET)" (scheduled at 2020-02-13 19:22:16.700919+01:00)| 13/02/2020 19:22:16|DEBUG |urllib3.connectionpool |Starting new HTTP connection (1): 127...:8989| 13/02/2020 19:22:16|DEBUG |subliminal_patch.http |DNS: Falling back to default DNS or IP on 127...| 13/02/2020 19:22:16|DEBUG |urllib3.connectionpool |http://127.***.***.***:8989 "GET /api/system/status?apikey=****48 HTTP/1.1" 200 None| 13/02/2020 19:22:16|DEBUG |urllib3.connectionpool |Starting new HTTP connection (1): 127...:8989| 13/02/2020 19:22:16|DEBUG |subliminal_patch.http |DNS: Falling back to default DNS or IP on 127...| 13/02/2020 19:22:16|DEBUG |urllib3.connectionpool |http://127.***.***.***:8989 "GET /api/system/status?apikey=****48 HTTP/1.1" 200 None| 13/02/2020 19:22:16|DEBUG |urllib3.connectionpool |Starting new HTTP connection (1): 127...:8989| 13/02/2020 19:22:16|DEBUG |subliminal_patch.http |DNS: Falling back to default DNS or IP on 127...| 13/02/2020 19:22:16|DEBUG |urllib3.connectionpool |http://127.***.***.***:8989 "GET /api/profile?apikey=****48 HTTP/1.1" 200 None| 13/02/2020 19:22:16|DEBUG |urllib3.connectionpool |Starting new HTTP connection (1): 127...:8989| 13/02/2020 19:22:16|DEBUG |subliminal_patch.http |DNS: Falling back to default DNS or IP on 127...| 13/02/2020 19:22:16|DEBUG |urllib3.connectionpool |http://127.***.***.***:8989 "GET /api/series?apikey=****48 HTTP/1.1" 200 None| 13/02/2020 19:22:16|DEBUG |sqlite3worker |execute: SELECT sonarrSeriesId FROM table_shows, None| 13/02/2020 19:22:16|DEBUG |sqlite3worker |Sleeping: 0.001 32460c1f-7694-4c1e-bb72-151623cdaf6f| 13/02/2020 19:22:16|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:22:16|DEBUG |sqlite3worker |run: SELECT sonarrSeriesId FROM table_shows, []| 13/02/2020 19:22:16|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:22:16|DEBUG |sqlite3worker |execute: SELECT title, path, tvdbId, sonarrSeriesId, overview, poster, fanart, audio_language, sortTitle, year, alternateTitles FROM table_shows, None| 13/02/2020 19:22:16|DEBUG |sqlite3worker |Sleeping: 0.001 bce18c2d-94aa-4134-beb5-b5f6c69d4c2c| 13/02/2020 19:22:16|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:22:16|DEBUG |sqlite3worker |run: SELECT title, path, tvdbId, sonarrSeriesId, overview, poster, fanart, audio_language, sortTitle, year, alternateTitles FROM table_shows, []| 13/02/2020 19:22:16|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:22:16|DEBUG |sqlite3worker |execute: UPDATE table_shows SET title=?,path=?,tvdbId=?,sonarrSeriesId=?,overview=?,poster=?,fanart=?,audio_language=?,sortTitle=?,year=?,alternateTitles=? WHERE sonarrSeriesId = ?, ('The Mandalorian', '/mnt/media/TV-Series/The Mandalorian', 361753, 1, '“The Mandalorian” is set after the fall of the Empire and before the emergence of the First Order. We follow the travails of a lone gunfighter in the outer reaches of the galaxy, far from the authority of the New Republic.', '/MediaCover/1/poster-250.jpg', '/MediaCover/1/fanart.jpg', 'English', 'mandalorian', 2019, '[]', 1)| 13/02/2020 19:22:16|DEBUG |sqlite3worker |Sleeping: 0.001 7307eb36-0c76-4f8f-8d50-1db23c718d85| 13/02/2020 19:22:16|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:22:16|DEBUG |sqlite3worker |run: UPDATE table_shows SET title=?,path=?,tvdbId=?,sonarrSeriesId=?,overview=?,poster=?,fanart=?,audio_language=?,sortTitle=?,year=?,alternateTitles=? WHERE sonarrSeriesId = ?, ('The Mandalorian', '/mnt/media/TV-Series/The Mandalorian', 361753, 1, '“The Mandalorian” is set after the fall of the Empire and before the emergence of the First Order. We follow the travails of a lone gunfighter in the outer reaches of the galaxy, far from the authority of the New Republic.', '/MediaCover/1/poster-250.jpg', '/MediaCover/1/fanart.jpg', 'English', 'mandalorian', 2019, '[]', 1)| 13/02/2020 19:22:16|ERROR |sqlite3worker |Query returned error: UPDATE table_shows SET title=?,path=?,tvdbId=?,sonarrSeriesId=?,overview=?,poster=?,fanart=?,audio_language=?,sortTitle=?,year=?,alternateTitles=? WHERE sonarrSeriesId = ?: ('The Mandalorian', '/mnt/media/TV-Series/The Mandalorian', 361753, 1, '“The Mandalorian” is set after the fall of the Empire and before the emergence of the First Order. We follow the travails of a lone gunfighter in the outer reaches of the galaxy, far from the authority of the New Republic.', '/MediaCover/1/poster-250.jpg', '/MediaCover/1/fanart.jpg', 'English', 'mandalorian', 2019, '[]', 1): attempt to write a readonly database| 13/02/2020 19:22:16|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:22:16|DEBUG |sqlite3worker |execute: UPDATE table_shows SET title=?,path=?,tvdbId=?,sonarrSeriesId=?,overview=?,poster=?,fanart=?,audio_language=?,sortTitle=?,year=?,alternateTitles=? WHERE sonarrSeriesId = ?, ('Star Trek: Picard', '/mnt/media/TV-Series/Star Trek- Picard', 364093, 2, 'Jean-Luc Picard, former captain of the starship U.S.S. Enterprise, is pulled out of forced retirement and the next chapter of his life, to help a young woman who is pursued by assassins.', '/MediaCover/2/poster-250.jpg', '/MediaCover/2/fanart.jpg', 'English', 'star trek picard', 2020, '[]', 2)| 13/02/2020 19:22:16|DEBUG |sqlite3worker |Sleeping: 0.001 0729b587-0d10-4004-a58a-1f53d5679c23| 13/02/2020 19:22:16|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:22:16|DEBUG |sqlite3worker |run: UPDATE table_shows SET title=?,path=?,tvdbId=?,sonarrSeriesId=?,overview=?,poster=?,fanart=?,audio_language=?,sortTitle=?,year=?,alternateTitles=? WHERE sonarrSeriesId = ?, ('Star Trek: Picard', '/mnt/media/TV-Series/Star Trek- Picard', 364093, 2, 'Jean-Luc Picard, former captain of the starship U.S.S. Enterprise, is pulled out of forced retirement and the next chapter of his life, to help a young woman who is pursued by assassins.', '/MediaCover/2/poster-250.jpg', '/MediaCover/2/fanart.jpg', 'English', 'star trek picard', 2020, '[]', 2)| 13/02/2020 19:22:16|ERROR |sqlite3worker |Query returned error: UPDATE table_shows SET title=?,path=?,tvdbId=?,sonarrSeriesId=?,overview=?,poster=?,fanart=?,audio_language=?,sortTitle=?,year=?,alternateTitles=? WHERE sonarrSeriesId = ?: ('Star Trek: Picard', '/mnt/media/TV-Series/Star Trek- Picard', 364093, 2, 'Jean-Luc Picard, former captain of the starship U.S.S. Enterprise, is pulled out of forced retirement and the next chapter of his life, to help a young woman who is pursued by assassins.', '/MediaCover/2/poster-250.jpg', '/MediaCover/2/fanart.jpg', 'English', 'star trek picard', 2020, '[]', 2): attempt to write a readonly database| 13/02/2020 19:22:16|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:22:16|DEBUG |sqlite3worker |execute: UPDATE table_shows SET title=?,path=?,tvdbId=?,sonarrSeriesId=?,overview=?,poster=?,fanart=?,audio_language=?,sortTitle=?,year=?,alternateTitles=? WHERE sonarrSeriesId = ?, ('The Outsider (2020)', '/mnt/media/TV-Series/The Outsider (2020)', 365480, 3, 'Based on Stephen King’s bestselling novel of the same name, The Outsider begins by following a seemingly straightforward investigation into the gruesome murder of a young boy. But when an insidious supernatural force edges its way into the case, it leads a seasoned cop and an unorthodox investigator to question everything they believe in.', '/MediaCover/3/poster-250.jpg', '/MediaCover/3/fanart.jpg', 'English', 'outsider 2020', 2020, "['El visitante', 'The Outsider']", 3)| 13/02/2020 19:22:16|DEBUG |sqlite3worker |Sleeping: 0.001 f2c48724-a329-4d64-a410-acade980fe6f| 13/02/2020 19:22:16|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:22:16|DEBUG |sqlite3worker |run: UPDATE table_shows SET title=?,path=?,tvdbId=?,sonarrSeriesId=?,overview=?,poster=?,fanart=?,audio_language=?,sortTitle=?,year=?,alternateTitles=? WHERE sonarrSeriesId = ?, ('The Outsider (2020)', '/mnt/media/TV-Series/The Outsider (2020)', 365480, 3, 'Based on Stephen King’s bestselling novel of the same name, The Outsider begins by following a seemingly straightforward investigation into the gruesome murder of a young boy. But when an insidious supernatural force edges its way into the case, it leads a seasoned cop and an unorthodox investigator to question everything they believe in.', '/MediaCover/3/poster-250.jpg', '/MediaCover/3/fanart.jpg', 'English', 'outsider 2020', 2020, "['El visitante', 'The Outsider']", 3)| 13/02/2020 19:22:16|ERROR |sqlite3worker |Query returned error: UPDATE table_shows SET title=?,path=?,tvdbId=?,sonarrSeriesId=?,overview=?,poster=?,fanart=?,audio_language=?,sortTitle=?,year=?,alternateTitles=? WHERE sonarrSeriesId = ?: ('The Outsider (2020)', '/mnt/media/TV-Series/The Outsider (2020)', 365480, 3, 'Based on Stephen King’s bestselling novel of the same name, The Outsider begins by following a seemingly straightforward investigation into the gruesome murder of a young boy. But when an insidious supernatural force edges its way into the case, it leads a seasoned cop and an unorthodox investigator to question everything they believe in.', '/MediaCover/3/poster-250.jpg', '/MediaCover/3/fanart.jpg', 'English', 'outsider 2020', 2020, "['El visitante', 'The Outsider']", 3): attempt to write a readonly database| 13/02/2020 19:22:16|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:22:16|DEBUG |root |BAZARR All series synced from Sonarr into database.| 13/02/2020 19:22:16|INFO |apscheduler.executors.default |Job "Update Series list from Sonarr (trigger: interval[0:01:00], next run at: 2020-02-13 19:23:16 CET)" executed successfully| 13/02/2020 19:22:48|DEBUG |apscheduler.scheduler |Looking for jobs to run| 13/02/2020 19:22:48|DEBUG |apscheduler.scheduler |Next wakeup is due at 2020-02-13 19:23:16.700919+01:00 (in 28.085589 seconds)| 13/02/2020 19:22:48|INFO |apscheduler.executors.default |Running job "Update Movie list from Radarr (trigger: interval[0:05:00], next run at: 2020-02-13 19:27:48 CET)" (scheduled at 2020-02-13 19:22:48.614420+01:00)| 13/02/2020 19:22:48|DEBUG |root |BAZARR Starting movie sync from Radarr.| 13/02/2020 19:22:48|DEBUG |urllib3.connectionpool |Starting new HTTP connection (1): 127...:7878| 13/02/2020 19:22:48|DEBUG |subliminal_patch.http |DNS: Falling back to default DNS or IP on 127...| 13/02/2020 19:22:48|DEBUG |urllib3.connectionpool |Starting new HTTP connection (1): 127...:8989| 13/02/2020 19:22:48|DEBUG |subliminal_patch.http |DNS: Falling back to default DNS or IP on 127...| 13/02/2020 19:22:48|DEBUG |urllib3.connectionpool |http://127.***.***.***:8989 "GET /api/system/status?apikey=****48 HTTP/1.1" 200 None| 13/02/2020 19:22:48|DEBUG |urllib3.connectionpool |http://127.***.***.***:7878 "GET /api/system/status?apikey=****59 HTTP/1.1" 200 None| 13/02/2020 19:22:48|DEBUG |urllib3.connectionpool |Starting new HTTP connection (1): 127...:7878| 13/02/2020 19:22:48|DEBUG |subliminal_patch.http |DNS: Falling back to default DNS or IP on 127...| 13/02/2020 19:22:48|DEBUG |urllib3.connectionpool |Starting new HTTP connection (1): 127...:7878| 13/02/2020 19:22:48|DEBUG |subliminal_patch.http |DNS: Falling back to default DNS or IP on 127...| 13/02/2020 19:22:48|DEBUG |urllib3.connectionpool |http://127.***.***.***:7878 "GET /api/system/status?apikey=****59 HTTP/1.1" 200 None| 13/02/2020 19:22:48|DEBUG |sqlite3worker |execute: SELECT COUNT() as count FROM table_episodes WHERE missing_subtitles != '[]', None| 13/02/2020 19:22:48|DEBUG |sqlite3worker |Sleeping: 0.001 8561620b-d4af-4bed-9622-b2d3f8d55820| 13/02/2020 19:22:48|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:22:48|DEBUG |sqlite3worker |run: SELECT COUNT() as count FROM table_episodes WHERE missing_subtitles != '[]', []| 13/02/2020 19:22:48|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:22:48|DEBUG |sqlite3worker |execute: SELECT COUNT() as count FROM table_movies WHERE missing_subtitles != '[]', None| 13/02/2020 19:22:48|DEBUG |sqlite3worker |Sleeping: 0.001 8088e758-68a2-4ab2-a617-7815f6858ec9| 13/02/2020 19:22:48|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:22:48|DEBUG |sqlite3worker |run: SELECT COUNT() as count FROM table_movies WHERE missing_subtitles != '[]', []| 13/02/2020 19:22:48|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:22:48|DEBUG |sqlite3worker |execute: SELECT configured, updated FROM system, None| 13/02/2020 19:22:48|DEBUG |sqlite3worker |Sleeping: 0.001 c30e32db-0ecb-4818-8693-b848f39c78dc| 13/02/2020 19:22:48|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:22:48|DEBUG |sqlite3worker |run: SELECT configured, updated FROM system, []| 13/02/2020 19:22:48|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:22:48|DEBUG |urllib3.connectionpool |http://127.***.***.***:7878 "GET /api/profile?apikey=****59 HTTP/1.1" 200 None| 13/02/2020 19:22:48|DEBUG |urllib3.connectionpool |Starting new HTTP connection (1): 127...:7878| 13/02/2020 19:22:48|DEBUG |subliminal_patch.http |DNS: Falling back to default DNS or IP on 127...| 13/02/2020 19:22:48|DEBUG |urllib3.connectionpool |http://127.***.***.***:7878 "GET /api/movie?apikey=****59 HTTP/1.1" 200 None| 13/02/2020 19:22:48|DEBUG |sqlite3worker |execute: SELECT tmdbId, path, radarrId FROM table_movies, None| 13/02/2020 19:22:48|DEBUG |sqlite3worker |Sleeping: 0.001 db4a56ce-df00-40ba-abd5-4b184d0b4b79| 13/02/2020 19:22:48|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:22:48|DEBUG |sqlite3worker |run: SELECT tmdbId, path, radarrId FROM table_movies, []| 13/02/2020 19:22:48|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:22:48|DEBUG |sqlite3worker |execute: DELETE FROM table_movies WHERE tmdbId=?, ('411088',)| 13/02/2020 19:22:48|DEBUG |sqlite3worker |Sleeping: 0.001 ca1e79c3-1f22-43f5-88bd-c7b244f994f5| 13/02/2020 19:22:48|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:22:48|DEBUG |sqlite3worker |run: DELETE FROM table_movies WHERE tmdbId=?, ('411088',)| 13/02/2020 19:22:48|ERROR |sqlite3worker |Query returned error: DELETE FROM table_movies WHERE tmdbId=?: ('411088',): attempt to write a readonly database| 13/02/2020 19:22:48|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:22:48|DEBUG |sqlite3worker |execute: DELETE FROM table_movies WHERE tmdbId=?, ('513045',)| 13/02/2020 19:22:48|DEBUG |sqlite3worker |Sleeping: 0.001 d3ed2527-3879-414b-9900-195f549f506b| 13/02/2020 19:22:48|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:22:48|DEBUG |sqlite3worker |run: DELETE FROM table_movies WHERE tmdbId=?, ('513045',)| 13/02/2020 19:22:48|ERROR |sqlite3worker |Query returned error: DELETE FROM table_movies WHERE tmdbId=?: ('513045',): attempt to write a readonly database| 13/02/2020 19:22:48|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:22:48|DEBUG |sqlite3worker |execute: SELECT radarrId, title, path, tmdbId, overview, poster, fanart, audio_language, sceneName, monitored, sortTitle, year, alternativeTitles, format, resolution, video_codec, audio_codec, imdbId,movie_file_id FROM table_movies, None| 13/02/2020 19:22:48|DEBUG |sqlite3worker |Sleeping: 0.001 884b3437-857e-463d-a6e2-e2272ac60968| 13/02/2020 19:22:48|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:22:48|DEBUG |sqlite3worker |run: SELECT radarrId, title, path, tmdbId, overview, poster, fanart, audio_language, sceneName, monitored, sortTitle, year, alternativeTitles, format, resolution, video_codec, audio_codec, imdbId,movie_file_id FROM table_movies, []| 13/02/2020 19:22:48|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:22:48|DEBUG |sqlite3worker |execute: UPDATE table_movies SET radarrId=?,title=?,path=?,tmdbId=?,poster=?,fanart=?,audio_language=?,sceneName=?,monitored=?,year=?,sortTitle=?,alternativeTitles=?,format=?,resolution=?,video_codec=?,audio_codec=?,overview=?,imdbId=?,movie_file_id=? WHERE radarrId = ?, (263, 'Avengers: Endgame', '/mnt/media/Movies/Avengers Endgame (2019)/Avengers Endgame (2019).mp4', '299534', '/MediaCover/263/poster-500.jpg', '/MediaCover/263/fanart.jpg', 'English', None, 'True', '2019', 'avengers endgame', '[\'Avengers: Endgame 3D\', \'Avengers: Infinity War, Part 2\', "Marvel Studios\' Avengers: Endgame"]', 'Unknown', 'unknown', 'h264', 'AAC', "After the devastating events of Avengers: Infinity War, the universe is in ruins due to the efforts of the Mad Titan, Thanos. With the help of remaining allies, the Avengers must assemble once more in order to undo Thanos' actions and restore order to the universe once and for all, no matter what consequences may be in store.", 'tt4154796', 56, 263)| 13/02/2020 19:22:48|DEBUG |sqlite3worker |Sleeping: 0.001 cd833a01-6f7b-4568-89d6-215ade45b6da| 13/02/2020 19:22:48|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:22:48|DEBUG |sqlite3worker |run: UPDATE table_movies SET radarrId=?,title=?,path=?,tmdbId=?,poster=?,fanart=?,audio_language=?,sceneName=?,monitored=?,year=?,sortTitle=?,alternativeTitles=?,format=?,resolution=?,video_codec=?,audio_codec=?,overview=?,imdbId=?,movie_file_id=? WHERE radarrId = ?, (263, 'Avengers: Endgame', '/mnt/media/Movies/Avengers Endgame (2019)/Avengers Endgame (2019).mp4', '299534', '/MediaCover/263/poster-500.jpg', '/MediaCover/263/fanart.jpg', 'English', None, 'True', '2019', 'avengers endgame', '[\'Avengers: Endgame 3D\', \'Avengers: Infinity War, Part 2\', "Marvel Studios\' Avengers: Endgame"]', 'Unknown', 'unknown', 'h264', 'AAC', "After the devastating events of Avengers: Infinity War, the universe is in ruins due to the efforts of the Mad Titan, Thanos. With the help of remaining allies, the Avengers must assemble once more in order to undo Thanos' actions and restore order to the universe once and for all, no matter what consequences may be in store.", 'tt4154796', 56, 263)| 13/02/2020 19:22:48|ERROR |sqlite3worker |Query returned error: UPDATE table_movies SET radarrId=?,title=?,path=?,tmdbId=?,poster=?,fanart=?,audio_language=?,sceneName=?,monitored=?,year=?,sortTitle=?,alternativeTitles=?,format=?,resolution=?,video_codec=?,audio_codec=?,overview=?,imdbId=?,movie_file_id=? WHERE radarrId = ?: (263, 'Avengers: Endgame', '/mnt/media/Movies/Avengers Endgame (2019)/Avengers Endgame (2019).mp4', '299534', '/MediaCover/263/poster-500.jpg', '/MediaCover/263/fanart.jpg', 'English', None, 'True', '2019', 'avengers endgame', '[\'Avengers: Endgame 3D\', \'Avengers: Infinity War, Part 2\', "Marvel Studios\' Avengers: Endgame"]', 'Unknown', 'unknown', 'h264', 'AAC', "After the devastating events of Avengers: Infinity War, the universe is in ruins due to the efforts of the Mad Titan, Thanos. With the help of remaining allies, the Avengers must assemble once more in order to undo Thanos' actions and restore order to the universe once and for all, no matter what consequences may be in store.", 'tt4154796', 56, 263): attempt to write a readonly database| 13/02/2020 19:22:48|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:22:48|DEBUG |sqlite3worker |execute: UPDATE table_movies SET radarrId=?,title=?,path=?,tmdbId=?,poster=?,fanart=?,audio_language=?,sceneName=?,monitored=?,year=?,sortTitle=?,alternativeTitles=?,format=?,resolution=?,video_codec=?,audio_codec=?,overview=?,imdbId=?,movie_file_id=? WHERE radarrId = ?, (517, 'The Sixth Sense', '/mnt/media/Movies/The Sixth Sense (1999)/The Sixth Sense (1999).mp4', '745', '/MediaCover/517/poster-500.jpg', '/MediaCover/517/fanart.jpg', 'English', 'The Sixth Sense (1999) [1080p]', 'True', '1999', 'sixth sense', '[]', 'Bluray', '1080p', 'h264', 'AAC', 'A psychological thriller about an eight year old boy named Cole Sear who believes he can see into the world of the dead. A child psychologist named Malcolm Crowe comes to Cole to help him deal with his problem, learning that he really can see the ghosts of dead people.', 'tt0167404', 44, 517)| 13/02/2020 19:22:48|DEBUG |sqlite3worker |Sleeping: 0.001 d25ce563-5d49-417f-adce-c1d99a09b9f5| 13/02/2020 19:22:48|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:22:48|DEBUG |sqlite3worker |run: UPDATE table_movies SET radarrId=?,title=?,path=?,tmdbId=?,poster=?,fanart=?,audio_language=?,sceneName=?,monitored=?,year=?,sortTitle=?,alternativeTitles=?,format=?,resolution=?,video_codec=?,audio_codec=?,overview=?,imdbId=?,movie_file_id=? WHERE radarrId = ?, (517, 'The Sixth Sense', '/mnt/media/Movies/The Sixth Sense (1999)/The Sixth Sense (1999).mp4', '745', '/MediaCover/517/poster-500.jpg', '/MediaCover/517/fanart.jpg', 'English', 'The Sixth Sense (1999) [1080p]', 'True', '1999', 'sixth sense', '[]', 'Bluray', '1080p', 'h264', 'AAC', 'A psychological thriller about an eight year old boy named Cole Sear who believes he can see into the world of the dead. A child psychologist named Malcolm Crowe comes to Cole to help him deal with his problem, learning that he really can see the ghosts of dead people.', 'tt0167404', 44, 517)| 13/02/2020 19:22:48|ERROR |sqlite3worker |Query returned error: UPDATE table_movies SET radarrId=?,title=?,path=?,tmdbId=?,poster=?,fanart=?,audio_language=?,sceneName=?,monitored=?,year=?,sortTitle=?,alternativeTitles=?,format=?,resolution=?,video_codec=?,audio_codec=?,overview=?,imdbId=?,movie_file_id=? WHERE radarrId = ?: (517, 'The Sixth Sense', '/mnt/media/Movies/The Sixth Sense (1999)/The Sixth Sense (1999).mp4', '745', '/MediaCover/517/poster-500.jpg', '/MediaCover/517/fanart.jpg', 'English', 'The Sixth Sense (1999) [1080p]', 'True', '1999', 'sixth sense', '[]', 'Bluray', '1080p', 'h264', 'AAC', 'A psychological thriller about an eight year old boy named Cole Sear who believes he can see into the world of the dead. A child psychologist named Malcolm Crowe comes to Cole to help him deal with his problem, learning that he really can see the ghosts of dead people.', 'tt0167404', 44, 517): attempt to write a readonly database| 13/02/2020 19:22:48|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:22:48|DEBUG |sqlite3worker |execute: UPDATE table_movies SET radarrId=?,title=?,path=?,tmdbId=?,poster=?,fanart=?,audio_language=?,sceneName=?,monitored=?,year=?,sortTitle=?,alternativeTitles=?,format=?,resolution=?,video_codec=?,audio_codec=?,overview=?,imdbId=?,movie_file_id=? WHERE radarrId = ?, (593, 'The Terminator', '/mnt/media/Movies/The Terminator (1984)/The Terminator (1984).mp4', '218', '/MediaCover/593/poster-500.jpg', '/MediaCover/593/fanart.jpg', 'English', 'The Terminator (1984) [1080p]', 'True', '1984', 'terminator', "['Terminator (Remastered)', 'Terminator 1']", 'Bluray', '1080p', 'h264', 'AAC', 'In the post-apocalyptic future, reigning tyrannical supercomputers teleport a cyborg assassin known as the "Terminator" back to 1984 to kill Sarah Connor, whose unborn son is destined to lead insurgents against 21st century mechanical hegemony. Meanwhile, the human-resistance movement dispatches a lone warrior to safeguard Sarah. Can he stop the virtually indestructible killing machine?', 'tt0088247', 86, 593)| 13/02/2020 19:22:48|DEBUG |sqlite3worker |Sleeping: 0.001 d864f8d4-e53c-4bba-9f96-171d9cba12c0| 13/02/2020 19:22:48|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:22:48|DEBUG |sqlite3worker |run: UPDATE table_movies SET radarrId=?,title=?,path=?,tmdbId=?,poster=?,fanart=?,audio_language=?,sceneName=?,monitored=?,year=?,sortTitle=?,alternativeTitles=?,format=?,resolution=?,video_codec=?,audio_codec=?,overview=?,imdbId=?,movie_file_id=? WHERE radarrId = ?, (593, 'The Terminator', '/mnt/media/Movies/The Terminator (1984)/The Terminator (1984).mp4', '218', '/MediaCover/593/poster-500.jpg', '/MediaCover/593/fanart.jpg', 'English', 'The Terminator (1984) [1080p]', 'True', '1984', 'terminator', "['Terminator (Remastered)', 'Terminator 1']", 'Bluray', '1080p', 'h264', 'AAC', 'In the post-apocalyptic future, reigning tyrannical supercomputers teleport a cyborg assassin known as the "Terminator" back to 1984 to kill Sarah Connor, whose unborn son is destined to lead insurgents against 21st century mechanical hegemony. Meanwhile, the human-resistance movement dispatches a lone warrior to safeguard Sarah. Can he stop the virtually indestructible killing machine?', 'tt0088247', 86, 593)| 13/02/2020 19:22:48|ERROR |sqlite3worker |Query returned error: UPDATE table_movies SET radarrId=?,title=?,path=?,tmdbId=?,poster=?,fanart=?,audio_language=?,sceneName=?,monitored=?,year=?,sortTitle=?,alternativeTitles=?,format=?,resolution=?,video_codec=?,audio_codec=?,overview=?,imdbId=?,movie_file_id=? WHERE radarrId = ?: (593, 'The Terminator', '/mnt/media/Movies/The Terminator (1984)/The Terminator (1984).mp4', '218', '/MediaCover/593/poster-500.jpg', '/MediaCover/593/fanart.jpg', 'English', 'The Terminator (1984) [1080p]', 'True', '1984', 'terminator', "['Terminator (Remastered)', 'Terminator 1']", 'Bluray', '1080p', 'h264', 'AAC', 'In the post-apocalyptic future, reigning tyrannical supercomputers teleport a cyborg assassin known as the "Terminator" back to 1984 to kill Sarah Connor, whose unborn son is destined to lead insurgents against 21st century mechanical hegemony. Meanwhile, the human-resistance movement dispatches a lone warrior to safeguard Sarah. Can he stop the virtually indestructible killing machine?', 'tt0088247', 86, 593): attempt to write a readonly database| 13/02/2020 19:22:48|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:22:48|DEBUG |sqlite3worker |execute: UPDATE table_movies SET radarrId=?,title=?,path=?,tmdbId=?,poster=?,fanart=?,audio_language=?,sceneName=?,monitored=?,year=?,sortTitle=?,alternativeTitles=?,format=?,resolution=?,video_codec=?,audio_codec=?,overview=?,imdbId=?,movie_file_id=? WHERE radarrId = ?, (612, 'Big Hero 6', '/mnt/media/Movies/Big Hero 6 (2014)/Big Hero 6.mkv', '177572', '/MediaCover/612/poster-500.jpg', '/MediaCover/612/fanart.jpg', 'English', None, 'True', '2014', 'big hero 6', '[]', 'Unknown', 'unknown', 'h264', 'AC3', 'The special bond that develops between plus-sized inflatable robot Baymax, and prodigy Hiro Hamada, who team up with a group of friends to form a band of high-tech heroes.', 'tt2245084', 93, 612)| 13/02/2020 19:22:48|DEBUG |sqlite3worker |Sleeping: 0.001 299045f0-a4d8-47e2-a376-788ebe6306d0| 13/02/2020 19:22:48|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:22:48|DEBUG |sqlite3worker |run: UPDATE table_movies SET radarrId=?,title=?,path=?,tmdbId=?,poster=?,fanart=?,audio_language=?,sceneName=?,monitored=?,year=?,sortTitle=?,alternativeTitles=?,format=?,resolution=?,video_codec=?,audio_codec=?,overview=?,imdbId=?,movie_file_id=? WHERE radarrId = ?, (612, 'Big Hero 6', '/mnt/media/Movies/Big Hero 6 (2014)/Big Hero 6.mkv', '177572', '/MediaCover/612/poster-500.jpg', '/MediaCover/612/fanart.jpg', 'English', None, 'True', '2014', 'big hero 6', '[]', 'Unknown', 'unknown', 'h264', 'AC3', 'The special bond that develops between plus-sized inflatable robot Baymax, and prodigy Hiro Hamada, who team up with a group of friends to form a band of high-tech heroes.', 'tt2245084', 93, 612)| 13/02/2020 19:22:48|ERROR |sqlite3worker |Query returned error: UPDATE table_movies SET radarrId=?,title=?,path=?,tmdbId=?,poster=?,fanart=?,audio_language=?,sceneName=?,monitored=?,year=?,sortTitle=?,alternativeTitles=?,format=?,resolution=?,video_codec=?,audio_codec=?,overview=?,imdbId=?,movie_file_id=? WHERE radarrId = ?: (612, 'Big Hero 6', '/mnt/media/Movies/Big Hero 6 (2014)/Big Hero 6.mkv', '177572', '/MediaCover/612/poster-500.jpg', '/MediaCover/612/fanart.jpg', 'English', None, 'True', '2014', 'big hero 6', '[]', 'Unknown', 'unknown', 'h264', 'AC3', 'The special bond that develops between plus-sized inflatable robot Baymax, and prodigy Hiro Hamada, who team up with a group of friends to form a band of high-tech heroes.', 'tt2245084', 93, 612): attempt to write a readonly database| 13/02/2020 19:22:48|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:22:48|DEBUG |sqlite3worker |execute: INSERT OR IGNORE INTO table_movies(radarrId,title,path,tmdbId,languages,subtitles,hearing_impaired,overview,poster,fanart,audio_language,sceneName,monitored,sortTitle,year,alternativeTitles,format,resolution,video_codec,audio_codec,imdbId,forced,movie_file_id) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), (268, 'The Lion King', '/mnt/media/Movies/The Lion King (2019)/The Lion King (2019).mp4', 420818, "['en']", '[]', 'False', "Simba idolizes his father, King Mufasa, and takes to heart his own royal destiny. But not everyone in the kingdom celebrates the new cub's arrival. Scar, Mufasa's brother—and former heir to the throne—has plans of his own. The battle for Pride Rock is ravaged with betrayal, tragedy and drama, ultimately resulting in Simba's exile. With help from a curious pair of newfound friends, Simba will have to figure out how to grow up and take back what is rightfully his.", '/MediaCover/268/poster-500.jpg', '/MediaCover/268/fanart.jpg', 'English', 'The Lion King (2019) [BluRay] [1080p] [YTS.LT]', 'True', 'lion king', 2019, '[]', 'Bluray', '1080p', 'h264', 'AAC', 'tt6105098', 'False', 178)| 13/02/2020 19:22:48|DEBUG |sqlite3worker |Sleeping: 0.001 15a280ff-3896-4c71-ad6a-cd59f055fe49| 13/02/2020 19:22:48|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:22:48|DEBUG |sqlite3worker |run: INSERT OR IGNORE INTO table_movies(radarrId,title,path,tmdbId,languages,subtitles,hearing_impaired,overview,poster,fanart,audio_language,sceneName,monitored,sortTitle,year,alternativeTitles,format,resolution,video_codec,audio_codec,imdbId,forced,movie_file_id) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), (268, 'The Lion King', '/mnt/media/Movies/The Lion King (2019)/The Lion King (2019).mp4', 420818, "['en']", '[]', 'False', "Simba idolizes his father, King Mufasa, and takes to heart his own royal destiny. But not everyone in the kingdom celebrates the new cub's arrival. Scar, Mufasa's brother—and former heir to the throne—has plans of his own. The battle for Pride Rock is ravaged with betrayal, tragedy and drama, ultimately resulting in Simba's exile. With help from a curious pair of newfound friends, Simba will have to figure out how to grow up and take back what is rightfully his.", '/MediaCover/268/poster-500.jpg', '/MediaCover/268/fanart.jpg', 'English', 'The Lion King (2019) [BluRay] [1080p] [YTS.LT]', 'True', 'lion king', 2019, '[]', 'Bluray', '1080p', 'h264', 'AAC', 'tt6105098', 'False', 178)| 13/02/2020 19:22:48|ERROR |sqlite3worker |Query returned error: INSERT OR IGNORE INTO table_movies(radarrId,title,path,tmdbId,languages,subtitles,hearing_impaired,overview,poster,fanart,audio_language,sceneName,monitored,sortTitle,year,alternativeTitles,format,resolution,video_codec,audio_codec,imdbId,forced,movie_file_id) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?): (268, 'The Lion King', '/mnt/media/Movies/The Lion King (2019)/The Lion King (2019).mp4', 420818, "['en']", '[]', 'False', "Simba idolizes his father, King Mufasa, and takes to heart his own royal destiny. But not everyone in the kingdom celebrates the new cub's arrival. Scar, Mufasa's brother—and former heir to the throne—has plans of his own. The battle for Pride Rock is ravaged with betrayal, tragedy and drama, ultimately resulting in Simba's exile. With help from a curious pair of newfound friends, Simba will have to figure out how to grow up and take back what is rightfully his.", '/MediaCover/268/poster-500.jpg', '/MediaCover/268/fanart.jpg', 'English', 'The Lion King (2019) [BluRay] [1080p] [YTS.LT]', 'True', 'lion king', 2019, '[]', 'Bluray', '1080p', 'h264', 'AAC', 'tt6105098', 'False', 178): attempt to write a readonly database| 13/02/2020 19:22:48|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:22:48|ERROR |apscheduler.executors.default |Job "Update Movie list from Radarr (trigger: interval[0:05:00], next run at: 2020-02-13 19:27:48 CET)" raised an exception|Traceback (most recent call last): File "/opt/bazarr/bazarr/../libs/apscheduler/executors/base.py", line 125, in run_job retval = job.func(job.args, job.kwargs) File "/opt/bazarr/bazarr/get_movies.py", line 243, in update_movies if result > 0:TypeError: '>' not supported between instances of 'str' and 'int'| 13/02/2020 19:23:16|DEBUG |apscheduler.scheduler |Looking for jobs to run| 13/02/2020 19:23:16|DEBUG |apscheduler.scheduler |Next wakeup is due at 2020-02-13 19:24:16.700919+01:00 (in 59.999138 seconds)| 13/02/2020 19:23:16|INFO |apscheduler.executors.default |Running job "Update Series list from Sonarr (trigger: interval[0:01:00], next run at: 2020-02-13 19:24:16 CET)" (scheduled at 2020-02-13 19:23:16.700919+01:00)| 13/02/2020 19:23:16|DEBUG |urllib3.connectionpool |Starting new HTTP connection (1): 127...:8989| 13/02/2020 19:23:16|DEBUG |subliminal_patch.http |DNS: Falling back to default DNS or IP on 127...| 13/02/2020 19:23:16|DEBUG |urllib3.connectionpool |http://127...:8989 "GET /api/system/status?apikey=****48 HTTP/1.1" 200 None| 13/02/2020 19:23:16|DEBUG |urllib3.connectionpool |Starting new HTTP connection (1): 127...:8989| 13/02/2020 19:23:16|DEBUG |subliminal_patch.http |DNS: Falling back to default DNS or IP on 127...| 13/02/2020 19:23:16|DEBUG |urllib3.connectionpool |http://127.***.***.***:8989 "GET /api/system/status?apikey=****48 HTTP/1.1" 200 None| 13/02/2020 19:23:16|DEBUG |urllib3.connectionpool |Starting new HTTP connection (1): 127...:8989| 13/02/2020 19:23:16|DEBUG |subliminal_patch.http |DNS: Falling back to default DNS or IP on 127...| 13/02/2020 19:23:16|DEBUG |urllib3.connectionpool |http://127.***.***.***:8989 "GET /api/profile?apikey=****48 HTTP/1.1" 200 None| 13/02/2020 19:23:16|DEBUG |urllib3.connectionpool |Starting new HTTP connection (1): 127...:8989| 13/02/2020 19:23:16|DEBUG |subliminal_patch.http |DNS: Falling back to default DNS or IP on 127...| 13/02/2020 19:23:16|DEBUG |urllib3.connectionpool |http://127.***.***.***:8989 "GET /api/series?apikey=****48 HTTP/1.1" 200 None| 13/02/2020 19:23:16|DEBUG |sqlite3worker |execute: SELECT sonarrSeriesId FROM table_shows, None| 13/02/2020 19:23:16|DEBUG |sqlite3worker |Sleeping: 0.001 7f1c246e-d33d-4b77-ad7a-d7dab3178da8| 13/02/2020 19:23:16|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:23:16|DEBUG |sqlite3worker |run: SELECT sonarrSeriesId FROM table_shows, []| 13/02/2020 19:23:16|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:23:16|DEBUG |sqlite3worker |execute: SELECT title, path, tvdbId, sonarrSeriesId, overview, poster, fanart, audio_language, sortTitle, year, alternateTitles FROM table_shows, None| 13/02/2020 19:23:16|DEBUG |sqlite3worker |Sleeping: 0.001 fdb1e915-8c76-498b-ac0e-8363baab2896| 13/02/2020 19:23:16|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:23:16|DEBUG |sqlite3worker |run: SELECT title, path, tvdbId, sonarrSeriesId, overview, poster, fanart, audio_language, sortTitle, year, alternateTitles FROM table_shows, []| 13/02/2020 19:23:16|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:23:16|DEBUG |sqlite3worker |execute: UPDATE table_shows SET title=?,path=?,tvdbId=?,sonarrSeriesId=?,overview=?,poster=?,fanart=?,audio_language=?,sortTitle=?,year=?,alternateTitles=? WHERE sonarrSeriesId = ?, ('The Mandalorian', '/mnt/media/TV-Series/The Mandalorian', 361753, 1, '“The Mandalorian” is set after the fall of the Empire and before the emergence of the First Order. We follow the travails of a lone gunfighter in the outer reaches of the galaxy, far from the authority of the New Republic.', '/MediaCover/1/poster-250.jpg', '/MediaCover/1/fanart.jpg', 'English', 'mandalorian', 2019, '[]', 1)| 13/02/2020 19:23:16|DEBUG |sqlite3worker |Sleeping: 0.001 95a7628e-aea2-4479-9359-f90a21495822| 13/02/2020 19:23:16|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:23:16|DEBUG |sqlite3worker |run: UPDATE table_shows SET title=?,path=?,tvdbId=?,sonarrSeriesId=?,overview=?,poster=?,fanart=?,audio_language=?,sortTitle=?,year=?,alternateTitles=? WHERE sonarrSeriesId = ?, ('The Mandalorian', '/mnt/media/TV-Series/The Mandalorian', 361753, 1, '“The Mandalorian” is set after the fall of the Empire and before the emergence of the First Order. We follow the travails of a lone gunfighter in the outer reaches of the galaxy, far from the authority of the New Republic.', '/MediaCover/1/poster-250.jpg', '/MediaCover/1/fanart.jpg', 'English', 'mandalorian', 2019, '[]', 1)| 13/02/2020 19:23:16|ERROR |sqlite3worker |Query returned error: UPDATE table_shows SET title=?,path=?,tvdbId=?,sonarrSeriesId=?,overview=?,poster=?,fanart=?,audio_language=?,sortTitle=?,year=?,alternateTitles=? WHERE sonarrSeriesId = ?: ('The Mandalorian', '/mnt/media/TV-Series/The Mandalorian', 361753, 1, '“The Mandalorian” is set after the fall of the Empire and before the emergence of the First Order. We follow the travails of a lone gunfighter in the outer reaches of the galaxy, far from the authority of the New Republic.', '/MediaCover/1/poster-250.jpg', '/MediaCover/1/fanart.jpg', 'English', 'mandalorian', 2019, '[]', 1): attempt to write a readonly database| 13/02/2020 19:23:16|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:23:16|DEBUG |sqlite3worker |execute: UPDATE table_shows SET title=?,path=?,tvdbId=?,sonarrSeriesId=?,overview=?,poster=?,fanart=?,audio_language=?,sortTitle=?,year=?,alternateTitles=? WHERE sonarrSeriesId = ?, ('Star Trek: Picard', '/mnt/media/TV-Series/Star Trek- Picard', 364093, 2, 'Jean-Luc Picard, former captain of the starship U.S.S. Enterprise, is pulled out of forced retirement and the next chapter of his life, to help a young woman who is pursued by assassins.', '/MediaCover/2/poster-250.jpg', '/MediaCover/2/fanart.jpg', 'English', 'star trek picard', 2020, '[]', 2)| 13/02/2020 19:23:16|DEBUG |sqlite3worker |Sleeping: 0.001 795e1286-5157-45ae-8e9c-d574be34fa0c| 13/02/2020 19:23:16|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:23:16|DEBUG |sqlite3worker |run: UPDATE table_shows SET title=?,path=?,tvdbId=?,sonarrSeriesId=?,overview=?,poster=?,fanart=?,audio_language=?,sortTitle=?,year=?,alternateTitles=? WHERE sonarrSeriesId = ?, ('Star Trek: Picard', '/mnt/media/TV-Series/Star Trek- Picard', 364093, 2, 'Jean-Luc Picard, former captain of the starship U.S.S. Enterprise, is pulled out of forced retirement and the next chapter of his life, to help a young woman who is pursued by assassins.', '/MediaCover/2/poster-250.jpg', '/MediaCover/2/fanart.jpg', 'English', 'star trek picard', 2020, '[]', 2)| 13/02/2020 19:23:16|ERROR |sqlite3worker |Query returned error: UPDATE table_shows SET title=?,path=?,tvdbId=?,sonarrSeriesId=?,overview=?,poster=?,fanart=?,audio_language=?,sortTitle=?,year=?,alternateTitles=? WHERE sonarrSeriesId = ?: ('Star Trek: Picard', '/mnt/media/TV-Series/Star Trek- Picard', 364093, 2, 'Jean-Luc Picard, former captain of the starship U.S.S. Enterprise, is pulled out of forced retirement and the next chapter of his life, to help a young woman who is pursued by assassins.', '/MediaCover/2/poster-250.jpg', '/MediaCover/2/fanart.jpg', 'English', 'star trek picard', 2020, '[]', 2): attempt to write a readonly database| 13/02/2020 19:23:16|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:23:16|DEBUG |sqlite3worker |execute: UPDATE table_shows SET title=?,path=?,tvdbId=?,sonarrSeriesId=?,overview=?,poster=?,fanart=?,audio_language=?,sortTitle=?,year=?,alternateTitles=? WHERE sonarrSeriesId = ?, ('The Outsider (2020)', '/mnt/media/TV-Series/The Outsider (2020)', 365480, 3, 'Based on Stephen King’s bestselling novel of the same name, The Outsider begins by following a seemingly straightforward investigation into the gruesome murder of a young boy. But when an insidious supernatural force edges its way into the case, it leads a seasoned cop and an unorthodox investigator to question everything they believe in.', '/MediaCover/3/poster-250.jpg', '/MediaCover/3/fanart.jpg', 'English', 'outsider 2020', 2020, "['El visitante', 'The Outsider']", 3)| 13/02/2020 19:23:16|DEBUG |sqlite3worker |Sleeping: 0.001 c6286074-cf97-4d9a-b3f5-6181c76f0e50| 13/02/2020 19:23:16|DEBUG |sqlite3worker |sql_queue: 0| 13/02/2020 19:23:16|DEBUG |sqlite3worker |run: UPDATE table_shows SET title=?,path=?,tvdbId=?,sonarrSeriesId=?,overview=?,poster=?,fanart=?,audio_language=?,sortTitle=?,year=?,alternateTitles=? WHERE sonarrSeriesId = ?, ('The Outsider (2020)', '/mnt/media/TV-Series/The Outsider (2020)', 365480, 3, 'Based on Stephen King’s bestselling novel of the same name, The Outsider begins by following a seemingly straightforward investigation into the gruesome murder of a young boy. But when an insidious supernatural force edges its way into the case, it leads a seasoned cop and an unorthodox investigator to question everything they believe in.', '/MediaCover/3/poster-250.jpg', '/MediaCover/3/fanart.jpg', 'English', 'outsider 2020', 2020, "['El visitante', 'The Outsider']", 3)| 13/02/2020 19:23:16|ERROR |sqlite3worker |Query returned error: UPDATE table_shows SET title=?,path=?,tvdbId=?,sonarrSeriesId=?,overview=?,poster=?,fanart=?,audio_language=?,sortTitle=?,year=?,alternateTitles=? WHERE sonarrSeriesId = ?: ('The Outsider (2020)', '/mnt/media/TV-Series/The Outsider (2020)', 365480, 3, 'Based on Stephen King’s bestselling novel of the same name, The Outsider begins by following a seemingly straightforward investigation into the gruesome murder of a young boy. But when an insidious supernatural force edges its way into the case, it leads a seasoned cop and an unorthodox investigator to question everything they believe in.', '/MediaCover/3/poster-250.jpg', '/MediaCover/3/fanart.jpg', 'English', 'outsider 2020', 2020, "['El visitante', 'The Outsider']", 3): attempt to write a readonly database| 13/02/2020 19:23:16|DEBUG |sqlite3worker |run: commit| 13/02/2020 19:23:16|DEBUG |root |BAZARR All series synced from Sonarr into database.| 13/02/2020 19:23:16|INFO |apscheduler.executors.default |Job "Update Series list from Sonarr (trigger: interval[0:01:00], next run at: 2020-02-13 19:24:16 CET)" executed successfully|

halali commented 4 years ago

attempt to write a readonly database| You havent write permissions to your database or data folder

vegovs commented 4 years ago

Could anyone give me a quick how-to on how to make a user for bazar with the correct rights? Bazarr is located under /opt/bazarr/.

morpheus65535 commented 4 years ago

You can have a look at the wiki to see how to run Bazarr as a service but we do not describe how to create user under Linux. I suggest you ask to Google but it should be with useradd, chown and chmod.