Nextcloud update fails, backup restore fails due to Memories

[apt9637]

What app is this about, and its version: Nextcloud, 31.0.11~ynh1
What YunoHost version are you running: 12.1.38
What type of hardware are you using: Old laptop or computer

Describe your issue

I tried updating Nextcloud, and the installation failed. The system tried to restore Nextcloud from a backup, but the process is stuck with the INSERT INTO memories_planet_geometry VALUES message, due to Nextcloud Memories I presume.

The web interface has been stuck for around 20 hours, and I cannot find a way to abort the process to get the logs and intervene.

I found some relevant posts in the forum (Nextcloud update failed, restore backup failed - #3 by Olomorn) that could help me solve the issue but I do not know how to proceed.

Trying to run CLI commands, I get the following message: Warning: Another YunoHost command is running right now, we are waiting for it to finish before running this one

Thanks for the help!

Share relevant logs or error messages

N/A

[apt9637]

[apt9637]

I also noticed that @olomorn solved a similar issue here Nextcloud update failed, restore backup failed - #4 by Olomorn but the topic has been closed. Perhaps you could share how you removed the data from the backup, repackaged it, and restored it? Thanks!

[otm33]

See here:

Nextcloud update (and restore) failed after first updating yunohost

I think I’ve found a much less invasive solution: prevent displaying the database restore output in the logs; that way there’s no problem with decoding binary data. => Only necessary to edit the restore script. cd /home/yunohost.backup/archives tar xvf nc_bak2.tar apps/nextcloud/settings/scripts/restore nano apps/nextcloud/settings/scripts/restore Edit this line from ynh_mysql_db_shell < ./db.sql to ynh_mysql_db_shell < ./db.sql > /tmp/nextcloud_restore.log 2>&1 Then tar --update -f n…

[apt9637]

And to stop the restore procedure that got stuck, I just rebooted the server (via CLI sudo reboot)