App Uninstall Fails, Throws BoxError

[droidforensics]

Hi there Cloudron community!

When I try uninstalling Outline or the VPN app, the uninstall fails:

BoxError: Cannot delete or update a parent row: a foreign key constraint fails (`box`.`mailPasswords`, CONSTRAINT `mailPasswords_ibfk_1` FOREIGN KEY (`clientId`) REFERENCES `oidcClients` (`id`))

I uninstalled SOgo and Vault without this problem occurring, so it seems limited to some apps.

As requested, I ran cloudron-support --troubleshoot:

Vendor: QEMU Product: Standard PC (i440FX + PIIX, 1996)
Linux: 6.8.0-101-generic
Ubuntu: noble 24.04
Execution environment: kvm
Processor: AMD EPYC Processor (with IBPB)
BIOS pc-i440fx-9.0  CPU @ 2.0GHz x 4
RAM: 8131800KB
Disk: /dev/sda1       122G
[OK]    node version is correct
[OK]    IPv6 is enabled and public IPv6 address is working
[OK]    docker is running
[OK]    docker version is correct
[OK]    MySQL is running
[OK]    netplan is good
[OK]    DNS is resolving via systemd-resolved
[OK]    unbound is running
[OK]    nginx is running
[OK]    dashboard cert is valid
[OK]    dashboard is reachable via loopback
[FAIL]  Database migrations are pending. Last migration in DB: /20260217120000-mailPasswords-create-table.js. Last migration file: /package.json.
        Please run 'cloudron-support --apply-db-migrations' to apply the migrations.
[OK]    Service 'mysql' is running and healthy
[OK]    Service 'postgresql' is running and healthy
[OK]    Service 'mongodb' is running and healthy
[OK]    Service 'mail' is running and healthy
[OK]    Service 'graphite' is running and healthy
[OK]    Service 'sftp' is running and healthy
[OK]    box v9.1.0 is running
[OK]    Dashboard is reachable via domain name
[OK]    Domain [REMOVED] is valid and has not expired

Seeing the database migrations warning, I used the --apply-db-migrations argument but got repeated errors about collectd:

Applying pending database migrations
2026-02-26T04:21:56 ==> start: Cloudron Start
media:x:500:
2026-02-26T04:21:56 ==> start: Configuring docker
Synchronizing state of apparmor.service with SysV service script with /usr/lib/systemd/systemd-sysv-install.
Executing: /usr/lib/systemd/systemd-sysv-install enable apparmor
2026-02-26T04:21:58 ==> start: Ensuring directories
2026-02-26T04:21:58 ==> start: Configuring journald
2026-02-26T04:21:59 ==> start: Setting up unbound
2026-02-26T04:21:59 ==> start: Adding systemd services
Synchronizing state of unbound.service with SysV service script with /usr/lib/systemd/systemd-sysv-install.
Executing: /usr/lib/systemd/systemd-sysv-install enable unbound
Synchronizing state of cron.service with SysV service script with /usr/lib/systemd/systemd-sysv-install.
Executing: /usr/lib/systemd/systemd-sysv-install enable cron
Synchronizing state of rpcbind.service with SysV service script with /usr/lib/systemd/systemd-sysv-install.
Executing: /usr/lib/systemd/systemd-sysv-install disable rpcbind
2026-02-26T04:22:09 ==> start: Configuring sudoers
2026-02-26T04:22:09 ==> start: Unconfiguring collectd
Failed to disable unit: Unit file collectd.service does not exist.
Failed to stop collectd.service: Unit collectd.service not loaded.
2026-02-26T04:22:09 ==> start: Configuring logrotate
2026-02-26T04:22:09 ==> start: Adding motd message for admins
2026-02-26T04:22:09 ==> start: Configuring nginx
2026-02-26T04:22:10 ==> start: Starting mysql
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
2026-02-26T04:22:10 ==> start: Migrating data
[INFO] No migrations to run
[INFO] Done
2026-02-26T04:22:11 ==> start: Changing ownership
2026-02-26T04:22:11 ==> start: Starting cloudron-syslog
2026-02-26T04:22:11 ==> start: Starting Cloudron
2026-02-26T04:22:13 ==> start: Almost done
[OK]    Database migrations applied successfully

Checking the box.log, I didn't see anything relevant except for the recurring notice that the apps are unresponsive (makes sense): 2026-02-26T04:22:40.152Z box:apphealthmonitor app health: 5 running / 0 stopped / 2 unresponsive

From searching the forums, I found:

• This post with a similar SQL error to mine, but the problem was fixed a while ago
• This post says collectd was removed, so that makes sense why it doesn't startup, it's not installed.

I think I have one problem (the uninstall process fails) and one bug report (the DB migration attempts to start a service that [I think?] isn't used anymore, and thus fails).

For reference, Cloudron is installed on a fresh Ubuntu 24.04 VPS, there wasn't an existing Cloudron (or any or any other applications).

Thanks a ton for your time and help! Really appreciate the hard work that goes into Cloudron; it's helped me for years! Take care.

[girish]

@droidforensics thanks for reporting. This is a bug in 9.1 which was just released yesterday for new installations. We already fixed this issue yesterday and will be creating a 9.1.1 soon.