Nextcloud stuck on Change row format for oc_filecache

Support intro

Sorry to hear you’re facing problems :slightly_frowning_face:

help.nextcloud.com is for home/non-enterprise users. If you’re running a business, paid support can be accessed via portal.nextcloud.com where we can ensure your business keeps running smoothly.

In order to help you as quickly as possible, before clicking Create Topic please provide as much of the below as you can. Feel free to use a pastebin service for logs, otherwise either indent short log examples with four spaces:

example

Or for longer, use three backticks above and below the code snippet:

longer
example
here

Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can :heart:

Nextcloud version 16.0.3):
Operating system and version (Debian 9):
Apache or nginx version (eg, Apache 2.4.25):
PHP version (eg, 7.2):

The issue you are facing:
Stuck on :

/var/www/nextcloud$ sudo -u www-data php occ maintenance:repair
[sudo] password for user:
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

  • Repair MySQL collation
    • Change row format for oc_filecache …

8 hours now…

Is this the first time you’ve seen this error? (Y):

Did you take a look at the mysql processlist?

MariaDB [(none)]> show processlist;

Is the convert process showing up?
How big is that table?

1 Like

Might this command help?

sudo -u www-data php occ maintenance:repair --include-expensive

I have the same problem