Error when upgrade 24.0.3 to 24.0.12

ℹ️ Support 📦 Appliances (Docker, Snappy, VM, NCP, AIO)
1

Hi everyone,

We tried to upgrade nextcloud 24.0.3 to 24.0.12 on an Ubuntu 20.04 (nextcloud-vm) but getting error:

Trying to automatically update all Nextcloud apps...
Your apps are already up to date!
Checking for new Nextcloud version...
Latest release is: 24.0.12. Current version is: 24.0.3.
New version available, upgrade continues!
Checking connection...
Backing up files and upgrading to Nextcloud 24.0.12 in 10 seconds... Press CTRL+C to abort.
Doing pgdump of nextcloud_db...
pg_dump: error: Dumping the contents of table "oc_filecache" failed: PQgetResult() failed.
pg_dump: error: Error message from server: ERROR:  invalid memory alloc request size 18446744073709551613
pg_dump: error: The command was: COPY public.oc_filecache (fileid, storage, path, path_hash, parent, name, mimetype, mimepart, size, mtime, storage_mtime, encrypted, unencrypted_size, etag, permissions, checksum) TO stdout;

Do we need to reset database or how can we handle this situation?

2

That is important (beacause of special update scripts)! You should post that in the right category / sub category.

That is a (known) Postgre error, caused by corrupted rows.

I am out, since I am no specialist of your vm-setup and the specialists will likely not look here, because you posted in the wrong category.