Can't add missing indexes to database with occ command

ℹ️ Support
, , ,
1

Hello All,

I have the typical error in security and setup warnings as below:

  • The database is missing some indexes. Due to the fact that adding indexes on big tables could take some time they were not added automatically. By running “occ db:add-missing-indices” those missing indexes could be added manually while the instance keeps running. Once the indexes are added queries to those tables are usually much faster. Missing optional index “mail_messages_strucanalyz_idx” in table “mail_messages”. Missing optional index “mail_class_creat_idx” in table “mail_classifiers”. Missing optional index “mail_acc_prov_idx” in table “mail_accounts”. Missing optional index “mail_alias_accid_idx” in table “mail_aliases”.

I had started by moving to my nextcloud web server dir, /var/www/nextcloud and then doing sudo -u www-root php occ db:add-missing-indices but I get:

An unhandled exception has been thrown:
OCP\HintException: [0]: Memcache OC\Memcache\APCu not available for local cache (Is the matching PHP module installed and enabled?)

I then checked to make sure I had the ‘memcache.local’ => ‘\OC\Memcache\APCu’, in my config.php for nextcloud which I do, then I made sure I had apcu installed and enable with:

sudo apt-get update
sudo apt-get install php-apcu

adding extension=apcu.so to php.ini (Running 8.2)

And then rebooting the server and trying the command again but I get the same error. I’m not sure If I’ve got something wrong. The only other error I have in the security and setup warnings is this:

The database is used for transactional file locking. To enhance performance, please configure memcache, if available. For more details see the documentation :arrow_upper_right:

Any help would be appreciated.

Thanks!

Happy Nextcloud User

2

you can try changing the module-parameters.
Mine (Debian11; php 8.2) look like this
in /etc/php/8.2/mods-available/apcu.ini

extension=apcu.so
apc.enable=1
apc.enable_cli=1
apc.shm_size=64M

the enable.cli is the important one.
GOOD LUCK!

3

I have this problem with nextcloud 87 - see my errors: * One or more mimetype migrations are available. Occasionally new mimetypes are added to better handle certain file types. Migrating the mimetypes take a long time on larger instances so this is not done automatically during upgrades. Use the command occ maintenance:repair --include-expensive to perform the migrations.

  • The database is missing some indexes. Due to the fact that adding indexes on big tables could take some time they were not added automatically. By running “occ db:add-missing-indices” those missing indexes could be added manually while the instance keeps running. Once the indexes are added queries to those tables are usually much faster. Missing optional index “dav_shares_resourceid_type” in table “dav_shares”. Missing optional index “dav_shares_resourceid_access” in table “dav_shares”. Missing optional index “oc_npushhash_di” in table “notifications_pushhash”. Missing optional index “schedulobj_lastmodified_idx” in table “schedulingobjects”. Missing optional index “systag_by_objectid” in table “systemtag_object_mapping”.

Please tell me how to fix. - Newbie

4

https://docs.nextcloud.com/server/latest/admin_manual/maintenance/upgrade.html#manual-steps-during-upgrade

P.S. Beware the mimetypes one - if you’re on 29.0.5 - is actually a bug that is fixed in the upcoming maintenance release. You can safely ignore it for the time being. You can search the forum for details.