Work in Progress Upgrade List¶

• flask (*)
• flask-babel (*)
• pandas
• flask-cors
• rdflib (*)
• email-validator
• shapley (*)
• pylint

(*) will definitively break OpenAtlas 8.x.x instances

Debian 12 → 13 (Bookworm → Trixie) Upgrade Notes¶

Previous upgrade issue: #2038

Steps Performed¶

Update current system¶

sudo apt update && sudo apt full-upgrade -y

Adjust APT sources¶

sudo apt edit-sources

Change all occurrences of bookworm to trixie.

Refresh and perform safe upgrade¶

sudo apt update && sudo apt upgrade --without-new-pkgs

When prompted by rkhunter, choose N (keep installed settings).

Continue upgrade¶

sudo apt update && sudo apt upgrade --with-new-pkgs

When prompted to upgrade PostgreSQL, choose No – the database will be upgraded manually later.

Clean up unused packages¶

sudo apt --purge autoremove -y
sudo apt autoclean

Reboot system after completion¶

sudo reboot

PostgreSQL cluster upgrade¶

sudo apt install postgresql-postgis
sudo systemctl stop postgresql
sudo pg_dropcluster 17 main
sudo pg_upgradecluster 15 main
sudo pg_dropcluster 15 main
sudo systemctl start postgresql

Get postgres user and reindex each database:

psql <database>
REINDEX DATABASE;

Or re-index all databases at once:

reindexdb --all

In case of collation warnings you could also call this statement:

ALTER DATABASE <database> REFRESH COLLATION VERSION;

Package Version Map (Debian 12 → Debian 13)¶

Reference¶

Upgrade guide: https://fullmetalbrackets.com/blog/upgrade-debian-12-bookworm-debian-13-trixie/

You need to REINDEX each database with:

REINDEX DATABASE <database>;

And I just removed the @babel.localeselector from init.py line 39, and added locale_selector to Babel (Babel(app, locale_selector=get_locale))

There are still issues, but to get it running and basically working, just this was needed.

A added a branch: feature/trixie

Thanks a lot for this. You can leave the Mypy stuff to me. Except for very API specific stuff which I may not dare to touch.
Anyway, it would be ok to leave some Mypy issues for the 9.1.0 release, although a nice to have, there are more important things.

cp -p /usr/lib/iipimage-server/iipsrv.fcgi /var/www/iipsrv/

• I merged feature/new_classes to feature/trixie which will now be the main develop branch for the next version
• There were multiple merge conflicts but I hope I solved all of them correctly
• I added an SQL command to re-index all databases and a collation SQL fix to your install note
• I managed to solve all Mypy issues and will look into the Pylint issues next