MySQL Error 1071 on ugrading from 9.0 to 9.1

Server
,
1

Hi !
I just tried to upgrade my owncloud fron 9.0 to 9.1. The update failed =(.

Steps to reproduce

  1. Download owncloud-9.1.0.zip, checked with SHA256 and OGP
  2. Unzip in new owncloud dir
  3. Copying my config file and 3rd party apps to new installation
  4. Run [i]sudo -apache_user php oc upgrade[i]

Expected behaviour
Complete the upgrade to 9.1

Actual behaviour
Update failed withe this message:

Checking whether the database schema for can be updated (this can take a long time depending on the database size)
oc_calendarobjects
4/10 [===========>----------------] 40%OC\DB\MigrationException: An exception occurred while executing ‘ALTER TABLE oc_oc_calendarobjects_trc6y1obe3pjt ADD classification INT DEFAULT 0 COMMENT ‘0 - public, 1 - private, 2 - confidential’, CHANGE id id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, CHANGE uri uri VARCHAR(255) DEFAULT NULL, CHANGE etag etag VARCHAR(32) DEFAULT NULL, CHANGE size size BIGINT UNSIGNED NOT NULL, CHANGE componenttype componenttype VARCHAR(8) DEFAULT NULL, CHANGE firstoccurence firstoccurence BIGINT UNSIGNED DEFAULT NULL, CHANGE lastoccurence lastoccurence BIGINT UNSIGNED DEFAULT NULL, CHANGE uid uid VARCHAR(255) DEFAULT NULL’:

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
Update failed
Maintenance mode is kept active
Reset log level

Server configuration
Operating system: Debian Jessie
Web server: Apache 2.4.10
Database: MySQL Ver 14.14 Distrib 5.5.50, for debian-linux-gnu (i686) using readline 6.3
PHP version: 2.6.0
ownCloud version (see ownCloud admin page): 9.0.0
Updated from an older ownCloud or fresh install: Updated from 8.2
ownCloud log (data/owncloud.log, see How to find webserver or OC logfile / enable php logfile):

{“reqId”:“d7WJU95hTtc41aAAJeMv”,“remoteAddr”:“”,“app”:“core”,“message”:“starting upgrade from 9.0.0.19 to 9.1.0.15”,“level”:0,“time”:“2016-08-09T10:05:$
{“reqId”:“d7WJU95hTtc41aAAJeMv”,“remoteAddr”:”“,“app”:“core”,“message”:“Simulated database structure update failed (exception 'OC\DB\MigrationExcepti$
{“reqId”:“d7WJU95hTtc41aAAJeMv”,“remoteAddr”:””,“app”:“core”,“message”:“Exception: {"Exception":"OC\\DB\\MigrationException","Message":"An e$
{“reqId”:“d7WJU95hTtc41aAAJeMv”,“remoteAddr”:”“,“app”:“core”,“message”:“XCache opcode cache will not be cleared because "xcache.admin.enable_auth" is$
{“reqId”:“iosZ2zbD9in1p7ijiU4N”,“remoteAddr”:””,“app”:“core”,“message”:“Error while running background job (class: OC\BackgroundJob\Legacy\RegularJo$
{“reqId”:“4W42HkCg5HpQNafxSmRQ”,“remoteAddr”:”",“app”:“core”,“message”:"XCache opcode cache will not be cleared because "xcache.admin.enable_auth" is$

Special configuration (external storage, external authentication, reverse proxy, server-side-encryption): none

Integrity status for oC9+

Technical information
=====================
The following list covers which files have failed the integrity check. Please read
the previous linked documentation to learn more about the errors and how to fix
them.

Results
=======
- core
	- INVALID_HASH
		- 3rdparty/guzzlehttp/guzzle/src/Client.php
		- 3rdparty/patches.txt
	- EXTRA_FILE
		- config.sample.php

Raw output
==========
Array
(
    [core] => Array
        (
            [INVALID_HASH] => Array
                (
                    [3rdparty/guzzlehttp/guzzle/src/Client.php] => Array
                        (
                            [expected] => 34b6d5b6bf056c25c4986eef62b44dd5a8508affc120234394df55c6b9580312d19498b78398c78b55884b393f51c6997deff5c8bfd6578585c7a1fde8d9d604
                            [current] => def9cb679ae55b41a425a57ecb49bd010d948f47f5436e9c619e20fd1185fd9e9a21cc46d43c214bab69f70df771058b85c27f304bafddd54421e1aba3485fb3
                        )

                    [3rdparty/patches.txt] => Array
                        (
                            [expected] => c9c980044146368b809b774e171a2f08345c75a7c622f3153d3c2881ee06dcd9abbe3e342f3ea36b2e8e85c2f77610286de1576c60d14c3532b6ec2fca1a1e1e
                            [current] => 4e5c76601cd13c1122641fd50e47d81abdd5abe75390ab9d1cbb70e59f5d9f88e1c76dafebee17b62a1bccb0fa70b319b76511a3670cdec6398a6a1204026db2
                        )

                )

            [EXTRA_FILE] => Array
                (
                    [config.sample.php] => Array
                        (
                            [expected] => 
                            [current] => ea8a9408749c28474b6156ee7dcfc9f487bf1f54a02904d3da00030c1225adb3a082b0b0b865e7bd67f94d389d666a9c7ab0e6aff1318aec1f2c66c322d3bae4
                        )

                )

        )

)

Thanks for some help.

2

Are you using InnoDB engine?

3

yes, i’m using InnoDB

4

what is the charset of the db?

5

charset of owncloud db is utf8
Thx =)

6

Ref for an existing bugreport: