![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
CONTENTS
Lastmodified 2020-03-07 (土) 06:05:29
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
アップグレード後、少々操作が必要。
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
/!\ NEXTCLOUD 13.0.1 UPDATE /!\
The nextcloud 13.0.1 package changes the location of the bundled apps.
After updating to 13.0.1 you MUST adapt your configuration. You MUST
add an additional entry to the "apps-paths" array in config/config.php
1 =>
array (
'path' => '/usr/local/www/nextcloud/apps-pkg',
'url' => '/apps-pkg',
'writable' => false,
),
For the default installation, the fix can be applied with:
cd /usr/local/www/nextcloud
su -m www -c "php ./occ config:import < /usr/local/share/nextcloud/fix-apps_paths.json
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
とのことなので、上記をしないとエラーでサーバへログイン出来ない。
config/config.php の
'maintenance' => false, この部分に、上記追加 );
で、記述の通り、
cd /usr/local/www/nextcloud su -m www -c "php ./occ config:import < /usr/local/share/nextcloud/fix-apps_paths.json
するも、「”」がミスマッチといわれるので、末尾に「”」追加したところ、
su -m www -c "php ./occ config:import < /usr/local/share/nextcloud/fix-apps_paths.json" Config successfully imported from: /usr/local/www/nextcloud:18_04_05:15:16 # su -m www -c "php ./occ upgrade" Nextcloud is already latest version /usr/local/www/nextcloud:18_04_05:15:16 # apachectl restart Performing sanity check on apache24 configuration: Syntax OK Stopping apache24. Waiting for PIDS: 968. Performing sanity check on apache24 configuration: Syntax OK Starting apache24.
で一件落着。
----------------------------------------------------------------------
Libraries have been installed in:
/usr/ports/net/pecl-smbclient/work-php56/smbclient-0.9.0/modules
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
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)
root@sun1:~:18_03_10:7:00 # pkg delete php56-pecl-smbclient
Updating database digests format: 100%
No packages matched for pattern 'php56-pecl-smbclient'
Checking integrity... done (0 conflicting)
1 packages requested for removal: 0 locked, 1 missing
root@sun1:~:18_03_10:7:00 #
root@sun1:~:18_03_10:7:01 #
root@sun1:~:18_03_10:7:01 #
root@sun1:~:18_03_10:7:01 # pkg delete pecl-smbclient-0.9.0_3
Checking integrity... done (0 conflicting)
Deinstallation has been requested for the following 2 packages (of 0 packages in the universe):
Installed packages to be REMOVED:
pecl-smbclient-0.9.0_3
nextcloud-12.0.5
Number of packages to be removed: 2
The operation will free 150 MiB.
Proceed with deinstalling packages? [y/N]: y
[1/2] Deinstalling nextcloud-12.0.5...
[1/2] Deleting files for nextcloud-12.0.5: 100%
[2/2] Deinstalling pecl-smbclient-0.9.0_3...
[2/2] Deleting files for pecl-smbclient-0.9.0_3: 100%
root@sun1:~:18_03_10:7:02 #
root@sun1:~:18_03_10:7:02 #
root@sun1:~:18_03_10:7:02 #
root@sun1:~:18_03_10:7:02 #
root@sun1:~:18_03_10:7:02 #
root@sun1:~:18_03_10:7:02 #
root@sun1:~:18_03_10:7:02 #
root@sun1:~:18_03_10:7:02 #
root@sun1:~:18_03_10:7:02 # portinstall nextcloud
[Reading data from pkg(8) ... - 422 packages found - done]
root@sun1:~:18_03_10:7:04 # cd /usr/local/www/nextcloud root@sun1:/usr/local/www/nextcloud:18_03_10:7:04 # su -m www -c "php ./occ upgrade"
Nextcloud or one of the apps require upgrade - only a limited number of commands are available You may use your browser or the occ upgrade command to do the upgrade Set log level to debug /: write failed, filesystem is full /: write failed, filesystem is full Turned on maintenance mode /: write failed, filesystem is full Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'SELECT DISTINCT(TABLE_NAME) AS `table` FROM INFORMATION_SCHEMA . COLUMNS WHERE TABLE_SCHEMA = ? AND (COLLATION_NAME <> 'utf8_bin' OR CHARACTER_SET_NAME <> 'utf8') AND TABLE_NAME LIKE "oc_%"' with params ["nc"]: SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine Update failed Maintenance mode is kept active Reset log level
あ・・・・・
Starting code integrity check... Finished code integrity check Update successful Maintenance mode is kept active Reset log level
986 7:24 cd /usr/home/svn/repos 987 7:24 ll 988 7:24 rm -r F_Ortho4XP 989 7:24 df -h 990 7:24 rm -r X_Users/ 991 7:24 df -h 992 7:25 cd /usr/local/www/nextcloud 993 7:25 su -m www -c "php ./occ upgrade" 994 7:26 su -m www -c "php ./occ upgrade" 995 7:29 portupgrade -fr nextcloud 996 7:31 cd /usr/local/www/nextcloud/config 997 7:32 ll 998 7:32 cp config.php config.php_dist 999 7:32 cp config.php_Back config.php 1000 7:32 reboot 1001 8:08 top 1002 8:26 cd /usr/local/www/nextcloud 1003 8:26 su -m www -c "php ./occ upgrade" 1004 8:28 su -m www -c "php ./occ upgrade" 1005 8:34 history
Total access 1980：本日 1：昨日 1
