Nextcloud upgrade to 13.0.4 Failed

[Maxime-BRIN]

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 
</details>

**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)
<details>
<summary>{"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) </summary>

[MorrisJobke]

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