Nextcloud Upgrade from 14.x.x to 15.0.0

Errors & Solutions When Upgrading from Nextcloud 14.x.x to 15.0.0

Issue/Error 1:

A. In Settings > Overview, there is a php-fpm configuration error:

https://docs.nextcloud.com/server/14/admin_manual/installation/source_installation.html#php-fpm-tips-label

$ sudo nano /etc/php/7.2/fpm/pool.d/www.conf

Solution 1

Uncomment these lines:

env[HOSTNAME] = $HOSTNAME
env[PATH] = /usr/local/bin:/usr/bin:/bin
env[TMP] = /tmp
env[TMPDIR] = /tmp
env[TEMP] = /tmp

Issue/Error 2:

A. You get a message like 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 index "owner_index" in table "oc_share".
    Missing index "initiator_index" in table "oc_share".

Solution 2:

Run:

$ cd /var/www/html/nextcloud
$ sudo -u www-data php occ db:add-missing-indice

or (substituting ‘/var/www/html/nextcloud/’ with the path to your nextcloud directory):

$ sudo -u www-data php /var/www/html/nextcloud/occ db:add-missing-indice

Issue/Error 3:

A. You get a message like below:
https://docs.nextcloud.com/server/15/admin_manual/configuration_database/bigint_identifiers.html

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.

    activity.activity_id
    activity.object_id
    activity_mq.mail_id
    filecache.fileid
    filecache.storage
    filecache.parent
    filecache.mimetype
    filecache.mimepart
    filecache.mtime
    filecache.storage_mtime
    mimetypes.id
    storages.numeric_id

Solution 3:

Run:

$ cd /var/www/html/nextcloud
$ sudo -u www-data php occ db:convert-filecache-bigint

or (substituting ‘/var/www/html/nextcloud/’ with the path to your nextcloud directory):

$ sudo -u www-data php /var/www/html/nextcloud/occ db:convert-filecache-bigint

Issue/Error 4:

A. You get a message like below:

Last background job execution ran X hours ago. Something seems wrong. Check the background job settings

Solution 4:

Run the cron manually (make sure the path to the Nextcloud directory is correct):

$ sudo -u www-data php -f /var/www/html/nextcloud/cron.php

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.