Update 19.0.7 to 20.0.5 unsuccessful

Support intro

Sorry to hear you’re facing problems :slightly_frowning_face:

help.nextcloud.com is for home/non-enterprise users. If you’re running a business, paid support can be accessed via portal.nextcloud.com where we can ensure your business keeps running smoothly.

In order to help you as quickly as possible, before clicking Create Topic please provide as much of the below as you can. Feel free to use a pastebin service for logs, otherwise either indent short log examples with four spaces:

example

Or for longer, use three backticks above and below the code snippet:

longer
example
here

Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can :heart:

Nextcloud version (eg, 18.0.2): 19.0.7.1.
Operating system and version (eg, Ubuntu 20.04): Debian 9
Apache or nginx version (eg, Apache 2.4.25): 2.4.25 (Debian)
PHP version (eg, 7.1): 7.3

The issue you are facing:

I was upgraded from 19.0.7.1 to 20.0.5. The upgrade failed. It prints out:

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘ALTER TABLE oc_authtoken CHANGE password_invalid password_invalid TINYINT(1) DEFAULT ‘0’’: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

and when I click on detailed logs it gives:

Preparing update
Set log level to debug
Turned on maintenance mode
Repair step: Repair MySQL collation
Repair info: All tables already have the correct collation -> nothing to do
Repair step: Repair SQLite autoincrement
Repair step: Copy data from accounts table when migrating from ownCloud
Repair step: Drop account terms table when migrating from ownCloud
Updating database schema
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'ALTER TABLE oc_authtoken CHANGE `password_invalid` password_invalid TINYINT(1) DEFAULT '0'': SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
The update was unsuccessful. Please report this issue to the Nextcloud community.

The last line says to report the issue to the Nextcloud community :-). I hope someone can help.

Is this the first time you’ve seen this error? (Y/N): Y

Steps to replicate it:

  1. Upgrade from 19.0.7.1 to 20.0.5

The output of your Nextcloud log in Admin > Logging:

I do not understand what this is asking for.

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

<?php
$CONFIG = array (
  'instanceid' => 'ocrw4uc0l9o2',
  'passwordsalt' => 'redacted',
  'secret' => 'redacted',
  'trusted_domains' =>
  array (
    0 => 'cloud.grwelch.com',
  ),
  'datadirectory' => '/path/to/nextcloud/data',
  'dbtype' => 'mysql',
  'version' => '19.0.7.1',
  'overwrite.cli.url' => 'http://cloud.grwelch.com',
  'dbname' => 'cloud',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'dbuser' => 'cloud',
  'dbpassword' => 'redacted',
  'installed' => true,
  'maintenance' => true,
  'mysql.utf8mb4' => true,
  'simpleSignUpLink.shown' => false,
  'theme' => '',
  'loglevel' => 2,
  'updater.secret' => 'redacted',
);

The output of your Apache/nginx/system log in /var/log/____:

The file is nearly 3000 lines.  Here are the last few.  If someone thinks more would be useful I'd be delighted to upload the whole thing.
128.194.161.84 - - [19/Jan/2021:14:23:57 -0600] "GET / HTTP/1.1" 200 9087 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:84.0) Gecko/20100101 Firefox/84.0"
128.194.161.84 - - [19/Jan/2021:14:23:57 -0600] "GET /core/css/guest.css?v=9095c56f-5 HTTP/1.1" 200 5933 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:84.0) Gecko/20100101 Firefox/84.0"
128.194.161.84 - - [19/Jan/2021:14:23:57 -0600] "GET /core/js/update.js?v=9095c56f-5 HTTP/1.1" 200 1991 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:84.0) Gecko/20100101 Firefox/84.0"
128.194.161.84 - - [19/Jan/2021:14:23:57 -0600] "GET /core/img/background.png?v=2 HTTP/1.1" 200 9949 "https://cloud.grwelch.com/core/css/guest.css?v=9095c56f-5" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:84.0) Gecko/20100101 Firefox/84.0"
128.194.161.84 - - [19/Jan/2021:14:23:57 -0600] "GET /core/img/logo/logo.svg?v=1 HTTP/1.1" 304 193 "https://cloud.grwelch.com/core/css/guest.css?v=9095c56f-5" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:84.0) Gecko/20100101 Firefox/84.0"
128.194.161.84 - - [19/Jan/2021:14:23:57 -0600] "GET /core/js/dist/main.js?v=9095c56f-5 HTTP/1.1" 200 446034 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:84.0) Gecko/20100101 Firefox/84.0"
128.194.161.84 - - [19/Jan/2021:14:23:58 -0600] "GET /core/img/favicon.ico HTTP/1.1" 200 3604 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:84.0) Gecko/20100101 Firefox/84.0"
128.194.161.84 - - [19/Jan/2021:14:23:58 -0600] "GET /core/img/favicon-touch.png HTTP/1.1" 200 3245 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:84.0) Gecko/20100101 Firefox/84.0"
128.194.161.84 - george [19/Jan/2021:14:24:14 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 981 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:24:15 -0600] "GET /ocs/v2.php/apps/notifications/api/v2/notifications?format=json HTTP/1.1" 503 1112 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:24:44 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 981 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:25:14 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 981 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:25:44 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 981 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:26:14 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 981 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:26:44 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 981 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:27:14 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 981 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:27:44 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 4103 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:28:14 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 981 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:28:44 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 981 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:29:14 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 981 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:29:15 -0600] "GET /ocs/v2.php/apps/notifications/api/v2/notifications?format=json HTTP/1.1" 503 1112 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:29:44 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 981 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:30:14 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 981 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:30:44 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 981 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:31:14 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 981 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:31:44 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 981 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:32:14 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 981 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:32:44 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 981 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:33:14 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 4103 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:33:44 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 981 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:34:14 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 981 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:34:15 -0600] "GET /ocs/v2.php/apps/notifications/api/v2/notifications?format=json HTTP/1.1" 503 1112 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:34:44 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 981 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:35:14 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 981 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:35:44 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 981 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:36:14 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 981 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:36:44 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 981 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:37:14 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 981 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:37:44 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 981 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:38:14 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 981 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:38:44 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 4103 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:39:14 -0600] "PROPFIND /remote.php/dav/files/george/ HTTP/1.1" 503 981 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"
128.194.161.84 - george [19/Jan/2021:14:39:15 -0600] "GET /ocs/v2.php/apps/notifications/api/v2/notifications?format=json HTTP/1.1" 503 1112 "-" "Mozilla/5.0 (Macintosh) mirall/3.1.1git (build 4316) (Nextcloud)"

Maybe this can help:

1 Like

You are seriously my hero! Yes, that did it.

By the way, I also had to set innodb_file_format=Barracuda

1 Like