for people with ubuntu 20.04 that need to upgrade

[AartJansen]

recreating addon containers

[joseph]

Oh, this is the Cloudron recreate containers? You can just reboot the server and it will try to get unstuck (hopefully). After reboot, can you check the logs at /home/yellowtent/platformdata/logs/box.log ?

[AartJansen]

2025-08-18T02:41:20.005Z box:cron BoxError: connect ECONNREFUSED 127.0.0.1:3306
    at Query.queryCallback [as _callback] (/home/yellowtent/box/src/database.js:93:38)
    at Sequence.end (/home/yellowtent/box/node_modules/mysql/lib/protocol/sequences/Sequence.js:83:24)
    at /home/yellowtent/box/node_modules/mysql/lib/Pool.js:205:13
    at Handshake.onConnect (/home/yellowtent/box/node_modules/mysql/lib/Pool.js:58:9)
    at Handshake.<anonymous> (/home/yellowtent/box/node_modules/mysql/lib/Connection.js:526:10)
    at Handshake._callback (/home/yellowtent/box/node_modules/mysql/lib/Connection.js:488:16)
    at Sequence.end (/home/yellowtent/box/node_modules/mysql/lib/protocol/sequences/Sequence.js:83:24)
    at Protocol.handleNetworkError (/home/yellowtent/box/node_modules/mysql/lib/protocol/Protocol.js:369:14)
    at Connection._handleNetworkError (/home/yellowtent/box/node_modules/mysql/lib/Connection.js:418:18)
    at Socket.emit (node:events:519:28)

Just get that over and over, and the console saying its offline after reboot.
Oh and the lat entries

2025-08-18T02:51:52.226Z box:platform uninitializing platform
2025-08-18T02:51:52.228Z box:platform onDeactivated: stopping post activation services
2025-08-18T02:51:52.229Z box:tasks stopAllTasks: stopping all tasks
2025-08-18T02:51:52.229Z box:shell tasks /usr/bin/sudo -S /home/yellowtent/box/src/scripts/stoptask.sh all
2025-08-18T02:51:52.249Z box:shell logs: /usr/bin/sudo -S /home/yellowtent/box/src/scripts/logtail.sh --lines=100 --follow /home/yellowtent/platformdata/logs/fb7aa282-5eb1-49ac-b77e-a864d1ef0202/apptask.log /home/yellowtent/platformdata/logs/fb7aa282-5eb1-49ac-b77e-a864d1ef0202/app.log terminated
2025-08-18T02:51:52.366Z box:shell All tasks stopped

2025-08-18T02:51:52.369Z box:directoryserver stopping server

[joseph]

@AartJansen mysql server is not running. Can you check systemctl status mysql ? In old ubuntu upgrades, mysql 8 has to be removed (https://docs.cloudron.io/guides/upgrade-ubuntu-20/#post-upgrade) . Can you check if mysql package is installed as well?

[AartJansen]

I got it going again, with the cloudron-support --troubleshoot command
Thanks

[AartJansen]

aart@cloudron:/home/yellowtent/platformdata/logs$ systemctl status mysql
● mysql.service - MySQL Community Server
     Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
     Active: active (running) since Mon 2025-08-18 09:51:50 UTC; 45min ago
    Process: 876 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
   Main PID: 1010 (mysqld)
     Status: "Server is operational"
      Tasks: 43 (limit: 38208)
     Memory: 303.1M
        CPU: 14.762s
     CGroup: /system.slice/mysql.service
             └─1010 /usr/sbin/mysqld

Notice: journal has been rotated since unit was started, output may be incomplete.

How do I know what version it is?

[AartJansen]

All my apps say configuring (queued)

[joseph]

@AartJansen said in for people with ubuntu 20.04 that need to upgrade:

Process: 876 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)

I think the mysql exited. Can you try systemctl restart mysql ? If that command worked, then do systemctl restart box and check that log file again.

I guess mysql --version gives the version .

[joseph]

@AartJansen said in for people with ubuntu 20.04 that need to upgrade:

All my apps say configuring (queued)

This is correct, it will recreate all the app containers in a little bit. Check the log file, you will see it is rebuilding the addons.

[AartJansen]

Oh, I just rebooted it again, and it seems to be all services / apps are running.
Thanks