"Database Column Conversion to Big Integers in Nextcloud"¶

Some columns in the database are missing a conversion to big int. Due to the fact that changing column types on big tables could take some time they were not changed automatically. By running "occ db:convert-filecache-bigint" those pending changes could be applied manually. This operation needs to be made while the instance is offline. For further details read the documentation page about this ↗.

it is recommended to enable maintenance mode before running the occ db:convert-filecache-bigint command. This will ensure that no users can access the instance during the database conversion process, which can take a considerable amount of time and may cause errors or issues for users trying to access the instance while the process is ongoing.

To enable maintenance mode, you can use the following command:

sudo -u www-data php occ maintenance:mode --on

sudo systemctl stop apache2

When you're done with your updates or changes, you can turn off maintenance mode with the following command:

sudo -u www-data php occ maintenance:mode --off

sudo systemctl start apache2

The occ script should be located in the nextcloud directory (the top-level directory of your Nextcloud installation).

sudo -u www-data php occ db:convert-filecache-bigint