Update Nextcloud 21.0.1 RC1

update Nextcloud 21.0.1 RC1
error
he 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.

sudo -u www-data php /var/www/nextcloud/occ db:add-missing-indices

error

Check indices of the share table.
Check indices of the filecache table.
Adding additional path index to the filecache table, this can take some time…

In ExceptionConverter.php line 114:

An exception occurred while executing a query: SQLSTATE[HY000]: General err
or: 1089 Incorrect prefix key; the used key part isn’t a string, the used l
ength is longer than the key part, or the storage engine doesn’t support un
ique prefix keys

In Exception.php line 26:

SQLSTATE[HY000]: General error: 1089 Incorrect prefix key; the used key par
t isn’t a string, the used length is longer than the key part, or the stora
ge engine doesn’t support unique prefix keys

In Connection.php line 82:

SQLSTATE[HY000]: General error: 1089 Incorrect prefix key; the used key par
t isn’t a string, the used length is longer than the key part, or the stora
ge engine doesn’t support unique prefix keys

db:add-missing-indices

help

1 Like

this issue occurred after the update
OK.
and how to solve the problem

well… you upgraded to a Beta-Version… It’s not recommended for productive environments (and I daresay neither for non-specialst users).

I hope you have a recent backup taken to go back to now… and then wait for the official release of 21.0.1 in a few days.

The problem has been resolved in version 21.0.1. The official version is already distributed in the updater.

3 Likes