Hi,
I’ve been running ChirpStack v4.5.1 on one of our servers for over a year, and I’m now trying to upgrade it to v4.7 to match another server we have in production.
As a first step, I tried upgrading to version 4.6.0 using:
dnf install https://artifacts.chirpstack.io/downloads/chirpstack/chirpstack_4.6.0_linux_amd64.rpm
The installation goes through fine, and I’ve updated the configuration to point to the correct PostgreSQL database, etc.
However, when starting the service, it fails during the schema migration step, complaining that tables or columns already exist. This happens with multiple migration files.
I also tried dumping the existing database, upgrading to v4.6.0, letting it apply its migrations, and then restoring the data — but that also fails with similar schema-related errors.
I’ve been stuck on this for almost 3 hours and have searched extensively without finding a clear solution.
I’m aware that in v4.7 there is a migration from Redis to PostgreSQL, but I haven’t even reached that point yet — my current goal is just to get 4.6.0 running properly.
Our environments run on Rocky Linux 9.5 and have been very stable so far. We also have a new server installed directly with v4.7, and I’d like both systems to run the same version.
Any help or guidance would be greatly appreciated.
Thanks!