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)

#author("2019-01-31T08:30:29+09:00","default:kuji","kuji")
CONTENTS
#contents
----
Lastmodified　&lastmod;
----
*Nextcloud [#a1d4a042]
**14.04 > 15.0.2 [#s82b12a3]
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 &counter(total);：本日 &counter(today);：昨日 &counter(yesterday);
#counter([total|today|yesterday]);