Stuck at updating DB schema when upgrading from 27.1.11 to 28.0.12

we’re using Nextcloud 27.1.11 Docker image and trying to upgrade from 27.1.11 to 28.0.12.

But it’s stuck at updating the DB schema.

 ./occ upgrade -vvv
Nextcloud or one of the apps require upgrade - only a limited number of commands are available
You may use your browser or the occ upgrade command to do the upgrade
2024-11-22T05:33:12+00:00 Setting log level to debug
2024-11-22T05:33:12+00:00 Repair step: Repair MySQL collation
2024-11-22T05:33:12+00:00 Repair info: All tables already have the correct collation -> nothing to do
2024-11-22T05:33:12+00:00 Repair step: Copy data from accounts table when migrating from ownCloud
2024-11-22T05:33:12+00:00 Repair step: Drop account terms table when migrating from ownCloud
2024-11-22T05:33:12+00:00 Updating database schema

Here is data/nextcloud.log, basically it’t not helpful.

{"reqId":"kO9OI8j8KKKVZur04xIw","level":0,"time":"2024-11-22T05:33:12+00:00","remoteAddr":"","user":"--","app":"core","method":"","url":"--","message":"starting upgrade from 27.1.11.3 to 28.0.12.2","userAge
nt":"--","version":"27.1.11.3","data":{"app":"core"}}
{"reqId":"kO9OI8j8KKKVZur04xIw","level":1,"time":"2024-11-22T05:33:12+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"OC\\Repair\\Events\\RepairStepEvent: Repair step: R
epair MySQL collation","userAgent":"--","version":"27.1.11.3","data":{"app":"updater"}}
{"reqId":"kO9OI8j8KKKVZur04xIw","level":1,"time":"2024-11-22T05:33:12+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"OC\\Repair\\Events\\RepairInfoEvent: Repair info: A
ll tables already have the correct collation -> nothing to do","userAgent":"--","version":"27.1.11.3","data":{"app":"updater"}}
{"reqId":"kO9OI8j8KKKVZur04xIw","level":1,"time":"2024-11-22T05:33:12+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"OC\\Repair\\Events\\RepairStepEvent: Repair step: C
opy data from accounts table when migrating from ownCloud","userAgent":"--","version":"27.1.11.3","data":{"app":"updater"}}
{"reqId":"kO9OI8j8KKKVZur04xIw","level":1,"time":"2024-11-22T05:33:12+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"OC\\Repair\\Events\\RepairStepEvent: Repair step: D
rop account terms table when migrating from ownCloud","userAgent":"--","version":"27.1.11.3","data":{"app":"updater"}}
{"reqId":"kO9OI8j8KKKVZur04xIw","level":1,"time":"2024-11-22T05:33:12+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::dbUpgradeBefore: Updating database s
chema","userAgent":"--","version":"27.1.11.3","data":{"app":"updater"}}

How to resolve this issue? Thanks.

2024-11-22T05:33:12+00:00 Setting log level to debug
2024-11-22T05:33:12+00:00 Repair step: Repair MySQL collation
2024-11-22T05:33:12+00:00 Repair info: All tables already have the correct collation -> nothing to do
2024-11-22T05:33:12+00:00 Repair step: Copy data from accounts table when migrating from ownCloud
2024-11-22T05:33:12+00:00 Repair step: Drop account terms table when migrating from ownCloud
2024-11-22T05:33:12+00:00 Updating database schema



2024-11-22T05:48:04+00:00 Updated database
2024-11-22T05:48:04+00:00 Disabled incompatible app: files_rightclick
2024-11-22T05:48:04+00:00 Disabled incompatible app: fulltextsearch_elasticsearch
2024-11-22T05:48:04+00:00 Disabled incompatible app: ldap_write_support
2024-11-22T05:48:04+00:00 Disabled incompatible app: richdocuments
2024-11-22T05:48:04+00:00 Updating <federation> ...
2024-11-22T05:48:04+00:00 Updated <federation> to 1.18.0

After 15 minutes , it proceed . What a long period.

This topic was automatically closed 8 days after the last reply. New replies are no longer allowed.