💾 Archived View for alaskalinuxuser.ddns.net › 2023-01-16.gmi captured on 2024-09-29 at 00:21:17. Gemini links have been rewritten to link to archived content
-=-=-=-=-=-=-
">
92w, https://alaskalinuxuser3.ddns.net/wp-content/uploads/2023/01/24.08Issues-
300x191.png 300w, https://alaskalinuxuser3.ddns.net/wp-content/uploads/2023/01/
24.08Issues-768x488.png 768w" sizes="(max-width: 892px) 100vw, 892px" /
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\nMaintenance mode enabled\n
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\nNextcloud is in
maintenance mode, hence the database isn't accessible.\nCannot perform any
command except 'maintenance:mode --off'\n
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.