- 追加された行はこの色です。
- 削除された行はこの色です。
#author("2019-01-30T14:42:12+09:00","default:kuji","kuji")
CONTENTS
#contents
----
Lastmodified &lastmod;
----
*Nextcloud [#a1d4a042]
**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
**Nextcloud 13.0.0 > 13.0.1 [#ifbc2406]
アップグレード後、少々操作が必要。
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
/!\ 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.
で一件落着。
** nextcloud-12.0.5 < needs updating (port has 13.0.0) [#m7afa87c]
----------------------------------------------------------------------
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
あ・・・・・
+SVNの使わなくなったデータを大量消去してスペース造る。
+nextcloudをportupgrade で強制アップグレード portupgrade -fr nextcloud
+バックアップしてあった/usr/local/www/nextcloud/config/config.phpを上書き。
+アップグレードコマンドを打つ。
Starting code integrity check...
Finished code integrity check
Update successful
Maintenance mode is kept active
Reset log level
+上手く行ったようなら、 'maintenance' => false, してみる。
*history [#ud770b00]
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 &counter(total);：本日 &counter(today);：昨日 &counter(yesterday);
#counter([total|today|yesterday]);
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
