Ubuntu V2 to V4 upgrade failure

Sonarr version (exact version): 2.0.0.5344
Mono version (if Sonarr is not running on Windows): 5.18.0.240
OS: Linux 4.15.0-213-generic x86_64
Debug logs: N/A
Description of issue: Upgrading from V2 to V4 appears to work as the install script shows that it completes successfully and I can see the sonarr service running but cannot access web gui. Some notes below.

After running the installer via curl I get the prompt that installation was successful and to navigate to the local IP on the same port of 8989 but when i try from a browser i get a connection refused error. I have tried leaving everything at default (user sonarr and group media) as well as using root for the user and the same problem occurs.

Perhaps this helps?

… :~$ sudo systemctl status sonarr
● sonarr.service - Sonarr Daemon
Loaded: loaded (/etc/systemd/system/sonarr.service; enabled; vendor preset: enab
Active: active (running) since Wed 2024-03-13 02:07:12 UTC; 3min 33s ago
Main PID: 7062 (Sonarr)
Tasks: 10 (limit: 2312)
CGroup: /system.slice/sonarr.service
└─7062 /opt/Sonarr/Sonarr -nobrowser -data=/var/lib/sonarr/

Mar 13 02:07:18 streamingautomation Sonarr[7062]: [Info] FluentMigrator.Runner.Migr
Mar 13 02:07:18 streamingautomation Sonarr[7062]: [Info] NzbDrone.Core.Datastore.Mi
Mar 13 02:07:18 streamingautomation Sonarr[7062]: [Info] FluentMigrator.Runner.Migr
Mar 13 02:07:18 streamingautomation Sonarr[7062]: [Info] FluentMigrator.Runner.Migr
Mar 13 02:07:18 streamingautomation Sonarr[7062]: [Info] FluentMigrator.Runner.Migr
Mar 13 02:07:18 streamingautomation Sonarr[7062]: [Info] FluentMigrator.Runner.Migr
Mar 13 02:07:18 streamingautomation Sonarr[7062]: [Info] NzbDrone.Core.Datastore.Mi
Mar 13 02:07:18 streamingautomation Sonarr[7062]: [Info] FluentMigrator.Runner.Migr
Mar 13 02:07:18 streamingautomation Sonarr[7062]: [Info] FluentMigrator.Runner.Migr
Mar 13 02:07:18 streamingautomation Sonarr[7062]: SQLite error (1): no such column:

You may need to revert to v2, restore your DB from backup, update to v3, allow migration to finish, then update to v4.

It’s running on a VM and I took a snapshot before the upgrade, so I simply reverted the snapshot so at least I have V2 working (which coincidentally works pretty well still).

So the question is, how can I update to v3? I couldn’t find any good instructions.

TIA!!

https://sonarr.tv/#downloads-linux-ubuntu

See the advanced users section and just change the version in the download link from 4 to 3.

Thanks. I’ve downloaded the tar.gz file but now what? Have a link to instructions? I am not very familiar with linux. I really appreciate the help!

https://www.reddit.com/r/sonarr/comments/ikg4l6/comment/g3l8vwb/

Or download https://raw.githubusercontent.com/Sonarr/Sonarr/develop/distribution/debian/install.sh, edit the version in the dlbase URL to 3, and run that script with sudo bash install.sh.

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.