Why does the updater not add missing indexes?

ℹ️ Support
,
1

I have no support/technical question and have seen the support category. (Be aware that direct support questions will be deleted.)

on

Which general topic do you have

Users are annoyed because often they have to manually run occ to add missing indexes after an update. It seems so trivial to just do this (and other necessary maintenance tasks) as part of the updater - but likely Dunning Kruger has his fingers in this game.

Is there a good reason to not include this in the updater and handle angry or annoyed users instead?

2

First of all, it’s not users who are supposed to run any occ commands, but admins. So I’m wondering why you have so many “angry users” about this. Do they all manage their own Nextcloud instances and complain to you about it? Or are you perhaps the admin for all of these instances, and what we really have here is one angry admin? :wink:

Seriously though, I don’t know the exact answer to your question, but I’d recommend simply using the CLI updater and then running the occ command afterwards. Alternatively, you could put together a small bash script that handles everything in one go.

Something like this, for example:

#!/bin/bash

NCINSTALLPATH="/path/to/nextcloud"
PHPVERSION="8.3"

ncoptimize () {
systemctl stop apache2
sudo -u www-data php "$NCINSTALLPATH"/occ db:add-missing-primary-keys
sudo -u www-data php "$NCINSTALLPATH"/occ db:add-missing-indices
sudo -u www-data php "$NCINSTALLPATH"/occ db:add-missing-columns
sudo -u www-data php "$NCINSTALLPATH"/occ db:convert-filecache-bigint
sudo -u www-data php "$NCINSTALLPATH"/occ maintenance:repair --include-expensive
sudo -u www-data sed -i "s/output_buffering=.*/output_buffering=0/" "$NCINSTALLPATH"/.user.ini
chown -R www-data:www-data "$NCINSTALLPATH"
systemctl restart php"$PHPVERSION"-fpm
systemctl start apache2
}

VERSION_BEFORE=$(sudo -u www-data php "$NCINSTALLPATH"/occ -V | awk '{print $2}')
sudo -u www-data php "$NCINSTALLPATH"/updater/updater.phar --no-interaction
VERSION_AFTER=$(sudo -u www-data php "$NCINSTALLPATH"/occ -V | awk '{print $2}')
if [[ "$VERSION_BEFORE" != "$VERSION_AFTER" ]]; then
echo "Nextcloud updated ($VERSION_BEFORE → $VERSION_AFTER). Running optimizations..."
ncoptimnize
fi
2 Likes
3

Yes, there is: Adding indexes can be very time-consuming on large installations with a huge database. For this reason, potentially time-consuming tasks have been deliberately omitted from the updater.

h.t.h.

ernolf

2 Likes
4

The occ command can run very long and lock large tables on big databases, which is why the updater doesn’t run it automatically.

5

Thank you and all the others. That’s very good to understand.

6

You seem to underestimate how often Nextcloud is self hosted by users who are their own admin in order to degoogle, for example. I’m one of them, though I, personally, don’t have any problem with an extra call to occ. I read that complaint quite often by other users and now I have something to quote as an answer. Thanks, and thanks for the example script!

7

I’m one of those users myself, but then again, I’ve always been a computer nerd. And yes, running server applications is a different beast than installing a mobile app, building a gaming PC, or customizing your Linux desktop.

However, with the latter two, it’s really just a matter of priorities: if you can do those things, you can also learn how to use occ commands or write a simple Bash script. But you can’t necessarily do all of those things, because time is always limited. :wink:

If you’re talking about the former, plain users who need you to set up their new phone because they’d be lost otherwise, I don’t see how they could realistically get Nextcloud up and running. And yes, Nextcloud is one of the more complex applications you can self-host, requiring a few extra steps here and there compared to other common self-hosted apps like Plex, for example. :wink:

1 Like
8

This topic was automatically closed after 2 days. New replies are no longer allowed.