Nextcloud Upgrade error の履歴(No.6)

• 履歴一覧
• 差分 を表示
• 現在との差分 を表示
• ソース を表示
• Nextcloud Upgrade error へ行く。
  • 1 (2018-03-10 (土) 06:42:39)
  • 2 (2018-03-10 (土) 08:39:11)
  • 3 (2018-04-05 (木) 15:34:48)
  • 4 (2019-01-30 (水) 14:42:12)
  • 5 (2019-01-30 (水) 20:41:20)
  • 6 (2019-01-31 (木) 08:30:29)

CONTENTS

Lastmodified　2020-03-07 (土) 06:05:29

Nextcloud†

14.04 > 15.0.2†

https://help.nextcloud.com/t/missing-index-owner-index-in-table-oc-share-solved/45154

テーブル "oc_share"のインデックス "owner_index"が見つかりません。 
テーブル "oc_share"のインデックス "initiator_index"が見つかりません。

# sudo -u www php occ db:add-missing-indices
Check indices of the share table.
Adding additional owner index to the share table, this can take some time...
Share table updated successfully.
Adding additional initiator index to the share table, this can take some time...
Share table updated successfully.

SOLVED!!

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.

filecache.mtime
filecache.storage_mtime

# sudo -u www php occ db:convert-filecache-bigint
Following columns will be updated:

* filecache.mtime
* filecache.storage_mtime

This can take up to hours, depending on the number of files in your instance!
Continue with the conversion (y/n)? [n] y

Total access 1871：本日 1：昨日 0