Update to 11.0.3 failed (web updater)

[kash74]

Update from 11.0.2.to 11.0.3 fails. My nextcloud is now unusable because it shows the 'Update now' screen permanently - no way to log in.

Can I just abort the upgrade and stick with 11.0.2? I need a working instance back here!

Steps to reproduce

1. Follow the notification that nextclud 11.0.3 is available (currently installed i 11.0.2)
2. Follow the dialog
3. Finish update

Expected behaviour

Updates suceeds

Actual behaviour

Update fails:

Preparing update
Set log level to debug
Turned on maintenance mode
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 ["nextcloud_db"]: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/var/tmp/#sql_81b_0.MAI' (Errcode: 2)

Server configuration

Operating system:
Centos 7.3

Web server:
apache2

Database:
mariadb

PHP version:
php7

Nextcloud version: (see Nextcloud admin page)
11.0.2

Updated from an older Nextcloud/ownCloud or fresh install:
fresh install

Where did you install Nextcloud from:

Signing status:

Signing status

Shows the update failed screen

List of activated apps:

App list

- activity: 2.4.1 - calendar: 1.5.2 - comments: 1.1.0 - dav: 1.1.1 - direct_menu: 0.10.1 - federatedfilesharing: 1.1.1 - files: 1.6.1 - files_downloadactivity: 1.0.1 - files_pdfviewer: 1.0.1 - files_sharing: 1.1.1 - files_texteditor: 2.2 - files_trashbin: 1.1.0 - files_versions: 1.4.0 - files_videoplayer: 1.0.0 - firstrunwizard: 2.0 - gallery: 16.0.0 - logreader: 2.0.0 - lookup_server_connector: 1.0.0 - nextcloud_announcements: 1.0 - notifications: 1.0.1 - password_policy: 1.1.0 - provisioning_api: 1.1.0 - serverinfo: 1.1.1 - sharebymail: 1.0.1 - survey_client: 0.1.5 - systemtags: 1.1.3 - theming: 1.1.1 - twofactor_backupcodes: 1.0.0 - updatenotification: 1.1.1 - workflowengine: 1.1.1

Nextcloud configuration:

Config report

{ "system": { "instanceid": "ocbxjmz2p5d2", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "secret": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "oc.nixbatz.net" ], "datadirectory": "\/var\/www\/xxxxxxxxxxxxxxxxxxx\/html\/nextcloud\/data", "overwrite.cli.url": "http:\/\/xxxxxxxxxxxxxxxxxxxxxxxt\/nextcloud", "dbtype": "mysql", "version": "11.0.2.7", "dbname": "nextcloud_db", "dbhost": "localhost", "dbport": "", "dbtableprefix": "oc_", "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "logtimezone": "UTC", "installed": true, "memcache.distributed": "\\OC\\Memcache\\Redis", "memcache.local": "\\OC\\Memcache\\Redis", "memcache.locking": "\\OC\\Memcache\\Redis", "redis": { "host": "localhost", "port": 6379 }, "htaccess.RewriteBase": "\/", "mail_from_address": "nextcloud", "mail_smtpmode": "php", "mail_domain": "xxxxxxxxxxxxxxxxxxxxx", "maintenance": false, "updater.secret": "***REMOVED SENSITIVE VALUE***", "theme": "", "loglevel": 2 }, "apps": { "activity": { "enabled": "yes", "installed_version": "2.4.1", "types": "filesystem" }, "announcementcenter": { "enabled": "no", "installed_version": "3.0.0", "types": "logging" }, "backgroundjob": { "lastjob": "15" }, "calendar": { "enabled": "yes", "installed_version": "1.5.2", "ocsid": "168707", "types": "" }, "comments": { "enabled": "yes", "installed_version": "1.1.0", "types": "logging" }, "core": { "backgroundjobs_mode": "ajax", "installedat": "1489700149.0801", "lastcron": "1493378704", "lastupdateResult": "{\"version\":\"11.0.3.2\",\"versionstring\":\"Nextcloud 11.0.3\",\"url\":\"https:\\\/\\\/download.nextcloud.com\\\/server\\\/releases\\\/nextcloud-11.0.3.zip\",\"web\":\"https:\\\/\\\/docs.nextcloud.com\\\/server\\\/11\\\/admin_manual\\\/maintenance\\\/upgrade.html\",\"autoupdater\":\"1\",\"signature\":\"w0iy1vyJTo33IgQsr+fS9p+SNS8+VK5DLygY\\\/m2lZi4odWrnu1EHw9yY6L0vQZx3\\nTwu016evAkProWqbiRpOyplAfgiEZtnElRNf6YfqPJFcoSYDGrHronrBrYZr\\\/1xX\\ng2VxNQavCYZ5xKerWUyx5XfztURZsKRjd8+wy05AdCdS33JRnft6Z9Plt1i8zeZ9\\nZsQVCpfOVzrsFJ50SMLlewKl2ddGnIrn1woPicMA6biM7KKu38QU92L\\\/f\\\/Q4HqqK\\nnUOMeuRVG\\\/iT7nu4Qz0nzY8uE1GM7rfYiBxsRNTXtsjpzEOo3u4zEvC8jvJl136Q\\nW0N7qv9mCgCHNclh6gPcTQ==\"}", "lastupdatedat": "1493378693", "oc.integritycheck.checker": "[]", "public_files": "files_sharing\/public.php", "public_webdav": "dav\/appinfo\/v1\/publicwebdav.php", "shareapi_allow_group_sharing": "yes", "shareapi_allow_public_upload": "no", "shareapi_allow_resharing": "no", "shareapi_enabled": "yes", "shareapi_enforce_links_password": "yes", "shareapi_only_share_with_group_members": "yes", "updater.secret.created": "1493378710", "vendor": "nextcloud" }, "dav": { "enabled": "yes", "installed_version": "1.1.1", "types": "filesystem" }, "direct_menu": { "enabled": "yes", "installed_version": "0.10.1", "ocsid": "169148", "types": "" }, "federatedfilesharing": { "enabled": "yes", "installed_version": "1.1.1", "types": "" }, "federation": { "enabled": "no", "installed_version": "1.1.1", "types": "authentication" }, "files": { "cronjob_scan_files": "500", "enabled": "yes", "installed_version": "1.6.1", "types": "filesystem" }, "files_downloadactivity": { "enabled": "yes", "installed_version": "1.0.1", "types": "filesystem" }, "files_pdfviewer": { "enabled": "yes", "installed_version": "1.0.1", "ocsid": "166049", "types": "" }, "files_sharing": { "enabled": "yes", "incoming_server2server_share_enabled": "no", "installed_version": "1.1.1", "outgoing_server2server_share_enabled": "no", "types": "filesystem" }, "files_texteditor": { "enabled": "yes", "installed_version": "2.2", "ocsid": "166051", "types": "" }, "files_trashbin": { "enabled": "yes", "installed_version": "1.1.0", "types": "filesystem" }, "files_versions": { "enabled": "yes", "installed_version": "1.4.0", "types": "filesystem" }, "files_videoplayer": { "enabled": "yes", "installed_version": "1.0.0", "types": "" }, "firstrunwizard": { "enabled": "yes", "installed_version": "2.0", "types": "logging" }, "gallery": { "enabled": "yes", "installed_version": "16.0.0", "types": "" }, "logreader": { "enabled": "yes", "installed_version": "2.0.0", "ocsid": "170871", "types": "" }, "lookup_server_connector": { "enabled": "yes", "installed_version": "1.0.0", "types": "authentication" }, "nextcloud_announcements": { "enabled": "yes", "installed_version": "1.0", "notification_groups": "[\"admin\"]", "pub_date": "Sat, 10 Dec 2016 00:00:00 +0100", "types": "logging" }, "notifications": { "enabled": "yes", "installed_version": "1.0.1", "types": "logging" }, "password_policy": { "enabled": "yes", "enforceNumericCharacters": "1", "enforceSpecialCharacters": "1", "enforceUpperLowerCase": "1", "installed_version": "1.1.0", "minLength": "8", "types": "" }, "provisioning_api": { "enabled": "yes", "installed_version": "1.1.0", "types": "prevent_group_restriction" }, "serverinfo": { "enabled": "yes", "installed_version": "1.1.1", "types": "" }, "sharebymail": { "enabled": "yes", "installed_version": "1.0.1", "types": "filesystem" }, "survey_client": { "enabled": "yes", "installed_version": "0.1.5", "types": "" }, "systemtags": { "enabled": "yes", "installed_version": "1.1.3", "types": "logging" }, "theming": { "enabled": "yes", "installed_version": "1.1.1", "types": "logging" }, "twofactor_backupcodes": { "enabled": "yes", "installed_version": "1.0.0", "types": "" }, "updatenotification": { "calendar": "1.5.2", "core": "11.0.3.2", "direct_menu": "0.10.1", "enabled": "yes", "installed_version": "1.1.1", "types": "" }, "workflowengine": { "enabled": "yes", "installed_version": "1.1.1", "types": "filesystem" } } }

[LukasReschke]

The internet claims that this likely is because your /tmp has run out of space. Can you check that? see also http://stackoverflow.com/questions/11997012/mysql-cant-create-write-to-file-tmp-sql-3c6-0-myi-errcode-2-what-does

Thus let's better discuss this on https://help.nextcloud.com as this seems a better suited place :-)

[kash74]

No, disk space is not the issue here, anyway I moved to nextcloud.com. Note that the 'update error' screen points to this github page for help...