Upgrade the 'fittrackee' app | This operation failed!

Support
,
1

What type of hardware are you using: VPS bought online
What YunoHost version are you running: 12.1.27 (stable)
How are you able to access your server: The webadmin
Are you in a special context or did you perform specific tweaking on your YunoHost instance ?: No

Describe your issue

Upgrading of the ‘fittrackee’ app fails:

[SQL: ALTER TABLE workout_segments ADD COLUMN geom geometry(LINESTRING,4326)]
Failed to upgrade fittrackee: An error occurred inside the app upgrade script

Share relevant logs or error messages

ERROR: extension "postgis" is not available

2025-10-06 18:24:26,267: DEBUG - sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedObject) type "geometry" does not exist
2025-10-06 18:24:26,267: DEBUG - LINE 1: ALTER TABLE workout_segments ADD COLUMN geom geometry(LINEST...
2025-10-06 18:24:26,267: DEBUG -                                                      ^
2025-10-06 18:24:26,268: DEBUG - 
2025-10-06 18:24:26,269: DEBUG - [SQL: ALTER TABLE workout_segments ADD COLUMN geom geometry(LINESTRING,4326)]
2025-10-06 18:24:26,269: DEBUG - (Background on this error at: https://sqlalche.me/e/20/f405)
2025-10-06 18:24:26,469: DEBUG - + ynh_exit_properly
2025-10-06 18:24:26,470: DEBUG - + [[ upgrade =~ ^install$|^upgrade$|^restore$ ]]
2025-10-06 18:24:27,074: ERROR - Failed to upgrade fittrackee: An error occurred inside the app upgrade script

src: https://paste.yunohost.org/raw/equguzufut

2

Testing a theory here: Use..... different PostGIS? by orhtej2 · Pull Request #131 · YunoHost-Apps/fittrackee_ynh · GitHub

cc @Tho

3

@yes if you could try upgrading on your system that would be great:

sudo yunohost app upgrade fittrackee -u https://github.com/YunoHost-Apps/fittrackee_ynh/tree/postgis
1 Like
4

Thanks @orhtej2!
Lets see if it helps! If it helps, I still don’t understand why it worked for me and on the ci

5

Thanks a lot, @orhtej2! That did the trick.

# sudo yunohost app upgrade fittrackee -u https://github.com/YunoHost-Apps/fittrackee_ynh/tree/postgis
Info: Now upgrading fittrackee…
Info: Creating a safety backup prior to the upgrade
Info: Collecting files to be backed up for fittrackee…
Info: Declaring files to be backed up...
Info: /home/yunohost.app/fittrackee will not be saved, because 'BACKUP_CORE_ONLY' is set.
Info: /var/log/fittrackee/ will not be saved, because 'BACKUP_CORE_ONLY' is set.
Info: Backing up the PostgreSQL database...
Info: Backup script completed for fittrackee. (YunoHost will then actually copy those files to the archive).
Info: Creating a backup archive from the collected files…
Info: The archive will contain about 194MB of data.
Success! Backup created: fittrackee-pre-upgrade2
Info: Backup fittrackee-pre-upgrade1 was deleted because it is replaced by a newer backup fittrackee-pre-upgrade2
Info: Updating system_user...
Info: Updating install_dir...
Info: Updating data_dir...
Info: Updating permissions...
Info: Updating ports...
Info: Updating apt...
Info: Updating database...
Info: [++..................] > Stopping fittrackee's systemd service...
Info: [##++................] > Ensuring downward compatibility...
Info: [####++..............] > Updating fittrackee's configuration files...
Info: [######++............] > Updating the PostgreSQL database...
Info: [########+++.........] > Installing Python dependencies...
Info: [###########++.......] > Upgrading database...
Info: [#############++.....] > Upgrading system configurations related to fittrackee...
Info: The service fail2ban has correctly executed the action reload-or-restart.
Info: [###############++...] > Starting fittrackee's systemd services...
Info: [####################] > Upgrade of fittrackee completed
Success! fittrackee upgraded
1 Like
6

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