#author("2020-03-07T06:05:29+09:00","default:kuji","kuji")
[[Nextcloud database is missing some indexes.]]

CONTENTS
#contents
----
Lastmodified　&lastmod;
----
*Nextcloud [#a1d4a042]

 nextcloud-12.0.5            <  needs updating (port has 13.0.0)
**17.* > 18.0.1 [#v9652c3e]
***/usr/bin/su -m www -c "php /usr/local/www/nextcloud/occ db:add-missing-indices" [#i2db0298]

 root@sun1:/usr/local/www/nextcloud:20_03_06:10:46 # /usr/bin/su -m www -c "php /usr/local/www/nextcloud/occ db:add-missing-indices"

 ----------------------------------------------------------------------
 Libraries have been installed in:
    /usr/ports/net/pecl-smbclient/work-php56/smbclient-0.9.0/modules
 Check indices of the share table.
 Check indices of the filecache table.
 Check indices of the twofactor_providers table.
 Check indices of the login_flow_v2 table.
 Check indices of the whats_new table.
 Check indices of the cards table.
 Check indices of the cards_properties table.
 Check indices of the calendarobjects_props table.
 Adding calendarobject_calid_index index to the calendarobjects_props table, this can take some time...
 calendarobjects_props table updated successfully.
 Check indices of the schedulingobjects table.
 Adding schedulobj_principuri_index index to the schedulingobjects table, this can take some time...
 schedulingobjects table updated successfully.



**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:
 
 If you ever happen to want to link against installed libraries
 in a given directory, LIBDIR, you must either use libtool, and
 specify the full pathname of the library, or use the `-LLIBDIR'
 flag during linking and do at least one of the following:
    - add LIBDIR to the `LD_LIBRARY_PATH' environment variable
      during execution
    - add LIBDIR to the `LD_RUN_PATH' environment variable
      during linking
    - use the `-Wl,--rpath -Wl,LIBDIR' linker flag
 * filecache.mtime
 * filecache.storage_mtime
 
 See any operating system documentation about shared libraries for
 more information, such as the ld(1) and ld.so(8) manual pages.
 ----------------------------------------------------------------------
 --- all --- 
 
 Build complete.
 Don't forget to run 'make test'.
 ===>  Staging for php56-pecl-smbclient-0.9.0_3
 ===>   php56-pecl-smbclient-0.9.0_3 depends on file: /usr/local/include/php/main/php.h - found
 ===>   Generating temporary packing list
 ====> Compressing man pages (compress-man)
 ===>  Installing for php56-pecl-smbclient-0.9.0_3
 ===>  Checking if php56-pecl-smbclient already installed
 ===>   Registering installation for php56-pecl-smbclient-0.9.0_3 as automatic
 Installing php56-pecl-smbclient-0.9.0_3...
 pkg-static: php56-pecl-smbclient-0.9.0_3 conflicts with pecl-smbclient-0.9.0_3 (installs files into the same place).  Problematic file: /usr/local/lib/php/20131226-zts/smbclient.so
 *** Error code 70  
 
 Stop.
 make[2]: stopped in /usr/ports/net/pecl-smbclient
 *** Error code 1
 
 Stop.
 make[1]: stopped in /usr/ports/www/nextcloud
 *** Error code 1
 
 Stop.
 make: stopped in /usr/ports/www/nextcloud
 ** Command failed [exit code 1]: /usr/bin/script -qa /tmp/portupgrade20180310-37616-1y1mkys env UPGRADE_TOOL=portupgrade UPGRADE_PORT=nextcloud-12.0.5 UPGRADE_PORT_VER=12.0.5 make
 ** Fix the problem and try again.
 ** Listing the failed packages (-:ignored / *:skipped / !:failed)
         ! www/nextcloud (nextcloud-12.0.5)      (unknown build error)
 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]);
トップ   新規 一覧 検索 最終更新   ヘルプ   最終更新のRSS