Nextcloud LinuxServer upgrade fail (uppush error)

[coanda45]

Hi,
I have Nextcloud 30.0.3 from linuxserver installed on my Synology NAS (DSM 7.2.1 version 6 (the latest).
It is installed with docker.

The following upgrade from previous to new version has worked several time (until 30.0.3), but I’m now stuck during the upgrade.

Usually, from portainer, I stop the nextcloud container, and leave the nextcloud-db container working. I then open the nextcloud container in portainer, click on duplicate/edit, check if nextcloud:latest is written (which is the case) and then click on “Deploy this container”. Until now, the upgrade has always work. I follow the upgrade with the log and then start again the nextcloud container.

Now, the upgrade is stuck to this windows:

I check the config.php and the maintenance mode is false.

By looking on this forum, I find to try occ:maintenance repair and occ upgrade through terminal using ssh.

The result is the following:
(first command: maintenance:repair before occ upgrade

The problem seems to be linked with the uppush upgrade.

Now, nextcloud is in maintenance mode true. But the problem loop again if I turn it to false.

Any help would be grate!

Thanks,
Best regards,

Fabien

[jtr]

Looks like a maybe a bug introduced in that app in the latest release. May want to report it to the maintainer(s):

uppush

[coanda45]

OK Thanks. Maybe it is the problem because I installed nextpush recently.
Is it possible to remove this apps and dependencies in terminal in order to manage to do the update and use nextcloud again?

[coanda45]

I found the solution

occ app:disable uppush
then

occ maintenance:repair
occ upgrade

[j-ed]

The provided workaround might reactivate the server access, because the app is disabled, but it doesn’t fix the db issue, because the app can still not be enabled afterwards. The same error message is shown if the following command is executed:

> occ app:disable uppush
> occ maintenance:repair
> occ upgrade

> occ app:enable uppush
Database error when running migration 020100 for app uppush
An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1833 Cannot change column 'device_id': used in a foreign key constraint 'device_id' of table 'nextcloud.oc_uppush_applications'

An issue ticket already exists which addresses this issue:

DB error while upgrading uppush 2.1.0

[coanda45]

Yes, sorry. My message was unclear.
I confirm, uppush is still not working. And it is still a problem to install some app (Notes for instance…)

I put as resolved, because I was able to use nextcloud again.
Sorry for misunderstanding.

[coanda45]

Today, the 2.1.2 package has been push by the developer.
It solves the problem for me.