Ich möchte eine etwas vernachlässigte owncloud installation die noch sqlite als Datenbank nutzt auf einem Debian stable von von 8.1 über 8.2 und 9.0 auf die aktuelle stable version update. Das erste Update von 8.1.9.2 auf 8.2.7 läuft wunderbar. Beim zweiten, von 8.2.7 auf 9.0.4 bekomme ich den folgenden Fehler (output etwas gekürzt):
Code: Alles auswählen
$ sudo -u www-data php /var/www/owncloud/occ upgrade
ownCloud 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
Checking whether the database schema can be updated (this can take a long time depending on the database size)
Checked database schema update
Checking updates of apps
Checking whether the database schema for <activity> can be updated (this can take a long time depending on the database size)
Checking whether the database schema for <files_external> can be updated (this can take a long time depending on the database size)
Checking whether the database schema for <files_sharing> can be updated (this can take a long time depending on the database size)
Checking whether the database schema for <files_trashbin> can be updated (this can take a long time depending on the database size)
Checked database schema update for apps
Updating database schema
Updated database
Disabled incompatible app: calendar
Disabled 3rd-party app: calendar
Disabled incompatible app: contacts
Disabled 3rd-party app: contacts
Disabled 3rd-party app: files_videoviewer
Updating <files_pdfviewer> ...
[...]
Updating <files_versions> ...
Updated <files_versions> to 1.2.0
Update 3rd-party app: calendar
Update 3rd-party app: contacts
Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occurred while executing 'PRAGMA journal_mode = WAL':
SQLSTATE[HY000]: General error: 10 disk I/O error
Update failed
Maintenance mode is kept active
Reset log level
PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 10 disk I/O error' in /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:77
Stack trace:
#0 /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(77): PDO->prepare('UPDATE "oc_file...', Array)
#1 /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(984): Doctrine\DBAL\Driver\PDOConnection->prepare('UPDATE "oc_file...')
#2 /var/www/owncloud/lib/private/db/connection.php(205): Doctrine\DBAL\Connection->executeUpdate('UPDATE "oc_file...', Array, Array)
#3 /var/www/owncloud/lib/private/lock/dblockingprovider.php(263): OC\DB\Connection->executeUpdate('UPDATE `*PREFIX...', Array)
#4 [internal function]: OC\Lock\DBLockingProvider->releaseAll()
#5 {main}
Next exception 'Doctrine\DBAL\Driver\PDOException' with message 'SQLSTATE[HY000]: General error: 10 disk I/O error' in /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:7 in /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractSQLiteDriver.php on line 85
Also habe ich nach Rückspielen meines Backups aus Version 8.1.9.2 (das Backup ist OK, denn hier funktioniert alles) heraus von sqlite auf auf mysql umgestellt:
Code: Alles auswählen
$ sudo -u www-data php /var/www/owncloud/occ db:convert-type mysql owncloud localhost owncloud --password="XXX"
ownCloud is in maintenance mode - no app have been loaded
Creating schema in new database
The following tables will not be converted:
oc_bookmarks
oc_bookmarks_tags
oc_documents_invite
oc_documents_member
oc_documents_op
oc_documents_revisions
oc_documents_session
oc_gallery_sharing
oc_lucene_status
Please note that tables belonging to available but currently not installed apps
can be included by specifying the --all-apps option.
Continue with the conversion (y/n)? [n] y
oc_activity
35/35 [============================] 100%
oc_activity_mq
0/0 [============================] 0%
oc_appconfig
110/110 [============================] 100%
oc_clndr_calendars
13/13 [============================] 100%
oc_clndr_objects
3256/3256 [============================] 100%
oc_clndr_repeat
1362/1362 [============================] 100%
oc_clndr_share_calendar
0/0 [============================] 0%
oc_clndr_share_event
0/0 [============================] 0%
oc_contacts_addressbooks
9/9 [============================] 100%
oc_contacts_cards
2638/2638 [============================] 100%
oc_contacts_cards_properties
11464/11464 [============================] 100%
oc_file_map
0/0 [============================] 0%
oc_filecache
757/757 [============================] 100%
oc_files_trash
3/3 [============================] 100%
oc_group_admin
0/0 [============================] 0%
oc_group_user
18/18 [============================] 100%
oc_groups
6/6 [============================] 100%
oc_jobs
9/9 [============================] 100%
oc_mimetypes
28/28 [============================] 100%
oc_preferences
104/104 [============================] 100%
oc_privatedata
0/0 [============================] 0%
oc_properties
0/0 [============================] 0%
oc_share
5/5 [============================] 100%
oc_share_external
0/0 [============================] 0%
oc_storages
13/13 [============================] 100%
oc_users
9/9 [============================] 100%
oc_vcategory
135/135 [============================] 100%
oc_vcategory_to_object
37/37 [============================] 100%
Code: Alles auswählen
$ sudo -u www-data php /var/www/owncloud/occ upgrade
ownCloud 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 - current level: 'Warning'
Checking whether the database schema can be updated (this can take a long time depending on the database size)
Checked database schema update
Checking updates of apps
Checked database schema update for apps
Updating database schema
Updated database
Disabled incompatible app: calendar
Disabled 3rd-party app: calendar
Disabled incompatible app: contacts
Disabled 3rd-party app: contacts
Disabled 3rd-party app: files_locking
Disabled 3rd-party app: tasks
Updating <files_texteditor> ...
Updated <files_texteditor> to 2.0
Update 3rd-party app: calendar
Update 3rd-party app: contacts
Update successful
Maintenance mode is kept active
Reset log level to 'Warning'
$ sudo -u www-data php /var/www/owncloud/occ maintenance:mode --off
Code: Alles auswählen
$ sudo -u www-data php /var/www/owncloud/occ user:report
+------------------+---+
| User Report | |
+------------------+---+
| Database | 9 |
| | |
| total users | 9 |
| | |
| user directories | 3 |
+------------------+---+
$ sudo -u www-data php /var/www/owncloud/occ status
- installed: true
- version: 8.2.7.1
- versionstring: 8.2.7
- edition:
Was kann ich tun?