Just another quick update for NextCloud, from patch level 24.04 to 24.08. Most of the time, we get the standard error about updating indicies, but this time I got a new one to me: convert-filecache-bigint. Apparently, some of the database columns were missing the conversion to a big integer, and this needed to be fixed for the latest revision level. It seemed pretty straight forward, but I read the documentation anyways. [1]
Per the references, you are required to put the instance in maintenance mode prior to running the command to convert the file cache to the big integers. So, I did exactly that with:
root@alaskalinuxuser-PowerEdge-R520:/var/www/nextcloud# sudo -u www-data php occ maintenance:mode --on
Maintenance mode enabled
However, this caused a problem when I ran the command to convert my database:
root@alaskalinuxuser-PowerEdge-R520:/var/www/nextcloud# cd /var/www/nextcloud && sudo -u www-data php occ db:convert-filecache-bigint
Nextcloud is in maintenance mode, hence the database isn't accessible.
Cannot perform any command except 'maintenance:mode --off'
So the instructions say to enter maintenance mode, but the command can’t run while you are in maintenance mode. We only have two clients currently, my wife and myself, so I wasn’t too worried about a sync problem during use, however, to be safe, an easy way was to just stop my apache web server and thus the clients couldn’t reach the NC instance. An even easier method was to simply unplug the computer’s network cable, since I use a physical server at my home.
With maintenance mode turned off, I then re-ran the command and it was successful. Actually, it said it could take hours, but with only two clients, it was done in a minute!
Linux – keep it simple.