search

nextcloud / server

☁️ Nextcloud server, a safe home for all your data
https://nextcloud.com
GNU Affero General Public License v3.0
27.56k stars 4.08k forks source link

Nextcloud upgrade to 13.0.4 Failed #9911

Closed Maxime-BRIN closed 6 years ago

Maxime-BRIN commented 6 years ago
### Steps to reproduce sudo nextcloud.occ upgrade ### Actual behaviour The nextcloud service did not work ... So I reboot the server. At reboot I had the following error. https://i.imgur.com/Qfdgmr7.png nextcloud.occ upgrade 2018/06/19 10:46:37.943783 system_key.go:118: cannot determine nfs usage in generateSystemKey: cannot parse /etc/fstab: expected between 3 and 6 fields, found 2 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 Updating database schema Updated database Updating ... Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'SELECT `calendarid`, `uri` FROM `oc_calendarobjects` WHERE `calendardata` LIKE ?' with params ["%;VALUE=:%"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'calendardata' in 'where clause' Update failed Maintenance mode is kept active Reset log level ### Server configuration **Operating system**: Ubuntu 16.04 LTS **Web server:** Service for snap application nextcloud.apache **Database:** This installation of MySQL is already upgraded to 5.7.22 **PHP version:** Service for snap application nextcloud.php-fpm **Nextcloud version:** (see Nextcloud admin page) i can't (maintenance mode) **Updated from an older Nextcloud/ownCloud or fresh install:** Version 12 **Where did you install Nextcloud from:** https://github.com/nextcloud/nextcloud-snap **Signing status:** Result : https://i.imgur.com/Lb1i3iO.png ``` Login as admin user into your Nextcloud and access http://example.com/index.php/settings/integrity/failed Result : https://i.imgur.com/X7ARAXm.png **List of activated apps:** sudo nextcloud.occ app:list 2018/06/19 10:23:30.567107 system_key.go:118: cannot determine nfs usage in generateSystemKey: cannot parse /etc/fstab: expected between 3 and 6 fields, found 2 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 Enabled: - activity: 2.6.1 - admin_audit: 1.3.0 - admin_notifications: 1.0.1 - bruteforcesettings: 1.0.3 - caniupdate: 0.1.2 - comments: 1.3.0 - dashboard: 4.0.6 - dav: 1.4.6 - encryption: 2.0.0 - federatedfilesharing: 1.3.1 - federation: 1.3.0 - files: 1.8.0 - files_automatedtagging: 1.3.0 - files_downloadactivity: 1.2.0 - files_pdfviewer: 1.2.1 - files_rightclick: 0.8.4 - files_sharing: 1.5.0 - files_texteditor: 2.5.1 - files_trackdownloads: 1.2.2 - files_trashbin: 1.3.0 - files_versions: 1.6.0 - files_videoplayer: 1.2.0 - firstrunwizard: 2.2.1 - flowupload: 0.0.7 - gallery: 18.0.0 - keeporsweep: 0.1.4 - logreader: 2.0.0 - lookup_server_connector: 1.1.0 - metadata: 0.6.0 - music: 0.6.1 - nextcloud_announcements: 1.2.0 - notifications: 2.1.2 - oauth2: 1.1.1 - onlyoffice: 1.3.0 - ownbackup: 17.5.0 - password_policy: 1.3.0 - previewgenerator: 1.0.9 - provisioning_api: 1.3.0 - quicknotes: 0.1.3 - quota_warning: 1.2.0 - serverinfo: 1.3.0 - sharebymail: 1.3.0 - socialsharing_email: 1.0.3 - survey_client: 1.1.0 - systemtags: 1.3.0 - theming: 1.4.1 - twofactor_backupcodes: 1.2.3 - twofactor_totp: 1.4.1 - workflowengine: 1.3.0 Disabled: - apporder - files_accesscontrol - files_clipboard - files_external - user_external - user_ldap **Nextcloud configuration:** sudo nextcloud.occ config:list 2018/06/19 10:24:24.583316 system_key.go:118: cannot determine nfs usage in gene rateSystemKey: cannot parse /etc/fstab: expected between 3 and 6 fields, found 2 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 { "system": { "apps_paths": [ { "path": "\/snap\/nextcloud\/current\/htdocs\/apps", "url": "\/apps", "writable": false }, { "path": "\/var\/snap\/nextcloud\/current\/nextcloud\/extra-apps" , "url": "\/extra-apps", "writable": true } ], "supportedDatabases": [ "mysql" ], "memcache.locking": "\\OC\\Memcache\\Redis", "memcache.local": "\\OC\\Memcache\\Redis", "redis": { "host": "***REMOVED SENSITIVE VALUE***", "port": 0 }, "instanceid": "***REMOVED SENSITIVE VALUE***", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "secret": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "***REMOVED SENSITIVE VALUE***", "***REMOVED SENSITIVE VALUE***" ], "datadirectory": "***REMOVED SENSITIVE VALUE***", "overwrite.cli.url": "***REMOVED SENSITIVE VALUE***", "dbtype": "mysql", "version": "13.0.2.1", "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbport": "", "dbtableprefix": "oc_", "mysql.utf8mb4": true, "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "installed": true, "mail_from_address": "***REMOVED SENSITIVE VALUE***", "mail_smtpmode": "smtp", "mail_smtpauthtype": "LOGIN", "mail_domain": "***REMOVED SENSITIVE VALUE***", "mail_smtpport": "587", "mail_smtpsecure": "tls", "mail_smtpauth": 1, "mail_smtphost": "***REMOVED SENSITIVE VALUE***", "mail_smtpname": "***REMOVED SENSITIVE VALUE***", "mail_smtppassword": "***REMOVED SENSITIVE VALUE***", "maintenance": false, "loglevel": 2, "theme": "" }, "apps": { "activity": { "enabled": "yes", "installed_version": "2.6.1", "notify_email_calendar": "0", "notify_email_calendar_event": "0", "notify_email_calendar_todo": "0", "notify_email_comments": "0", "notify_email_favorite": "0", "notify_email_file_changed": "0", "notify_email_file_created": "0", "notify_email_file_deleted": "0", "notify_email_file_restored": "0", "notify_email_public_links": "1", "notify_email_remote_share": "1", "notify_email_shared": "0", "notify_email_systemtags": "0", "notify_setting_batchtime": "3600", "notify_setting_self": "1", "notify_setting_selfemail": "0", "notify_stream_calendar": "1", "notify_stream_calendar_event": "1", "notify_stream_calendar_todo": "1", "notify_stream_comments": "1", "notify_stream_favorite": "1", "notify_stream_file_changed": "1", "notify_stream_file_created": "1", "notify_stream_file_deleted": "1", "notify_stream_file_favorite": "0", "notify_stream_file_restored": "1", "notify_stream_public_links": "1", "notify_stream_remote_share": "1", "notify_stream_shared": "1", "notify_stream_systemtags": "1", "types": "filesystem" }, "admin_audit": { "enabled": "yes", "installed_version": "1.3.0", "types": "logging" }, "admin_notifications": { "enabled": "yes", "installed_version": "1.0.1", "types": "logging" }, "audioplayer": { "enabled": "no", "installed_version": "2.3.0", "types": "filesystem" }, "backgroundjob": { "lastjob": "13" }, "bookmarks": { "enabled": "no", "installed_version": "0.11.0", "types": "" }, "bruteforcesettings": { "enabled": "yes", "installed_version": "1.0.3", "types": "" }, "calendar": { "enabled": "no", "installed_version": "1.6.1", "types": "" }, "caniupdate": { "enabled": "yes", "installed_version": "0.1.2", "types": "" }, "comments": { "enabled": "yes", "installed_version": "1.3.0", "types": "logging" }, "core": { "backgroundjobs_mode": "cron", "default_encryption_module": "OC_DEFAULT_MODULE", "encryption_enabled": "yes", "installed.bundles": "[\"CoreBundle\"]", "installedat": "1525715355.3192", "lastcron": "1529360790", "lastupdatedat": "0", "moveavatarsdone": "yes", "oc.integritycheck.checker": "[]", "previewsCleanedUp": "1", "public_files": "files_sharing\/public.php", "public_webdav": "dav\/appinfo\/v1\/publicwebdav.php", "scss.variables": "c26cd2babe749d0fafac0c53dddfa53b", "shareapi_default_expire_date": "yes", "shareapi_enforce_expire_date": "no", "vendor": "nextcloud" }, "dashboard": { "enabled": "yes", "installed_version": "4.0.6", "types": "" }, "dav": { "buildCalendarSearchIndex": "yes", "enabled": "yes", "installed_version": "1.4.6", "types": "filesystem" }, "encryption": { "enabled": "yes", "installed_version": "2.0.0", "masterKeyId": "master_c34b2001", "publicShareKeyId": "pubShare_c34b2001", "recoveryAdminEnabled": "1", "recoveryKeyId": "recoveryKey_c34b2001", "types": "filesystem", "useMasterKey": "0" }, "federatedfilesharing": { "enabled": "yes", "installed_version": "1.3.1", "types": "" }, "federation": { "enabled": "yes", "installed_version": "1.3.0", "types": "authentication" }, "files": { "cronjob_scan_files": "500", "enabled": "yes", "installed_version": "1.8.0", "types": "filesystem" }, "files_accesscontrol": { "enabled": "no", "installed_version": "1.3.0", "types": "filesystem" }, "files_automatedtagging": { "enabled": "yes", "installed_version": "1.3.0", "types": "filesystem" }, "files_clipboard": { "enabled": "no", "installed_version": "0.7.1", "types": "" }, "files_downloadactivity": { "enabled": "yes", "installed_version": "1.2.0", "types": "filesystem" }, "files_pdfviewer": { "enabled": "yes", "installed_version": "1.2.1", "types": "" }, "files_rightclick": { "enabled": "yes", "installed_version": "0.8.4", "types": "" }, "files_sharing": { "enabled": "yes", "installed_version": "1.5.0", "types": "filesystem" }, "files_texteditor": { "enabled": "yes", "installed_version": "2.5.1", "types": "" }, "files_trackdownloads": { "enabled": "yes", "installed_version": "1.2.2", "types": "filesystem" }, "files_trashbin": { "enabled": "yes", "installed_version": "1.3.0", "types": "filesystem" }, "files_versions": { "enabled": "yes", "installed_version": "1.6.0", "types": "filesystem" }, "files_videoplayer": { "enabled": "yes", "installed_version": "1.2.0", "types": "" }, "firstrunwizard": { "enabled": "yes", "installed_version": "2.2.1", "types": "logging" }, "flowupload": { "enabled": "yes", "installed_version": "0.0.7", "types": "" }, "gallery": { "enabled": "yes", "installed_version": "18.0.0", "types": "" }, "keeporsweep": { "enabled": "yes", "installed_version": "0.1.4", "types": "" }, "logreader": { "enabled": "yes", "installed_version": "2.0.0", "ocsid": "170871", "types": "" }, "lookup_server_connector": { "enabled": "yes", "installed_version": "1.1.0", "types": "authentication" }, "mail": { "enabled": "no", "installed_version": "0.8.1", "types": "" }, "metadata": { "enabled": "yes", "installed_version": "0.6.0", "types": "" }, "music": { "enabled": "yes", "installed_version": "0.6.1", "types": "filesystem" }, "nextcloud_announcements": { "enabled": "yes", "installed_version": "1.2.0", "pub_date": "Sat, 10 Dec 2016 00:00:00 +0100", "types": "logging" }, "notes": { "enabled": "no", "installed_version": "2.3.2", "types": "" }, "notifications": { "enabled": "yes", "installed_version": "2.1.2", "types": "logging" }, "oauth2": { "enabled": "yes", "installed_version": "1.1.1", "types": "authentication" }, "onlyoffice": { "enabled": "yes", "installed_version": "1.3.0", "skey": "1528357022686", "types": "filesystem" }, "ownbackup": { "enabled": "yes", "installed_version": "17.5.0", "types": "" }, "password_policy": { "enabled": "yes", "installed_version": "1.3.0", "types": "" }, "previewgenerator": { "enabled": "yes", "installed_version": "1.0.9", "types": "filesystem" }, "provisioning_api": { "enabled": "yes", "installed_version": "1.3.0", "types": "prevent_group_restriction" }, "quicknotes": { "enabled": "yes", "installed_version": "0.1.3", "types": "" }, "quota_warning": { "enabled": "yes", "installed_version": "1.2.0", "types": "filesystem" }, "radio": { "enabled": "no", "installed_version": "0.6.1", "types": "" }, "serverinfo": { "enabled": "yes", "installed_version": "1.3.0", "types": "" }, "sharebymail": { "enabled": "yes", "installed_version": "1.3.0", "types": "filesystem" }, "socialsharing_email": { "enabled": "yes", "installed_version": "1.0.3", "types": "" }, "survey_client": { "apps": "no", "database": "no", "enabled": "yes", "encryption": "no", "files_sharing": "no", "installed_version": "1.1.0", "php": "no", "server": "no", "stats": "no", "types": "" }, "systemtags": { "enabled": "yes", "installed_version": "1.3.0", "types": "logging" }, "theming": { "cachebuster": "6", "color": "#00486F", "enabled": "yes", "installed_version": "1.4.1", "slogan": "", "types": "logging", "url": "" }, "twofactor_backupcodes": { "enabled": "yes", "installed_version": "1.2.3", "types": "" }, "twofactor_totp": { "enabled": "yes", "installed_version": "1.4.1", "types": "" }, "unsplash": { "enabled": "no", "installed_version": "1.1.1", "types": "" }, "workflowengine": { "enabled": "yes", "installed_version": "1.3.0", "types": "filesystem" } } } **Are you using external storage, if yes which one:** local/smb/sftp/... No **Are you using encryption:** yes/no Yes **Are you using an external user-backend, if yes which one:** LDAP/ActiveDirectory/Webdav/... No ### Client configuration **Browser:** Firefox And Chrome #### Nextcloud log (data/nextcloud.log)
{"reqId":"hq2mJKeLsk11T7mvfi1m","level":2,"time":"2018-05-09T17:32:52+00:00","remoteAddr":"192.168.0.47","user":"maxime","app":"core","method":"GET","url":"\/remote.php\/dav\/files\/maxime\/Raccourci%20Bureau\/Maxime\/Etudes%20(clef%20USB)\/Revue%20de%20Projet\/RdP%203%20-%20Groupe%20-%20Fran%C3%A7ais\/Logiciels\/Processing\/processing-2.2.1\/modes\/java\/libraries\/video\/library\/windows32\/plugins\/libgstnsf.dll","message":"normalizing failed for \"files\/Raccourci Bureau\/Maxime\/MP5\u00bc\u00aa\u00aa\u00a8\u00ba\u00a7\u00bb\u00b61\u00bc\u00ae\u00a2\u00bc.rar\"","userAgent":"Mozilla\/5.0 (Windows) mirall\/2.3.3 (build 1)
MorrisJobke commented 6 years ago

2018/06/19 10:23:30.567107 system_key.go:118: cannot determine nfs usage in generateSystemKey: cannot parse /etc/fstab: expected between 3 and 6 fields, found 2

This looks fishy ... could indicate further problems.

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'calendardata' in 'where clause'

This column is there since Nextcloud 10 at least. Something broke apart here.

Best would be to reach out in the forums at https://help.nextcloud.com or in the repo for the snap package to debug this with the snap maintainer: https://github.com/nextcloud/nextcloud-snap