Server: Database Error while upgading Talk (spreed)

[derspotter]

How to use GitHub

• Please use the 👍 reaction to show that you are affected by the same issue.
• Please don't comment if you have no relevant information to add. It's just extra noise for everyone subscribed to this issue.
• Subscribe to receive notifications on status change and new comments.

Steps to reproduce

Upgrade Nextcloud Talk via the webinterface

Expected behaviour

upgrade should run smoothly

Actual behaviour

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'CREATE UNIQUE INDEX tp_ident ON oc_talk_participants (room_id, user_id, session_id)':

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
Update failed

Server configuration

Operating system:
Debian 9

Web server:
Apache

Database:
mariadb
utf8mb4

PHP version:
7.3.13

Nextcloud version: (see Nextcloud admin page)
18.0.3

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

Where did you install Nextcloud from:
wget

Signing status:

Signing status

Login as admin user into your Nextcloud and access 
http://example.com/index.php/settings/integrity/failed 
paste the results here.
no errors
</details>

**List of activated apps:**
  - accessibility: 1.4.0
  - activity: 2.11.0
  - apporder: 0.9.0
  - bruteforcesettings: 1.5.0
  - calendar: 2.0.2
  - circles: 0.18.4
  - cloud_federation_api: 1.1.0
  - comments: 1.8.0
  - contacts: 3.2.0
  - dav: 1.14.0
  - deck: 0.8.0
  - documentserver_community: 0.1.5
  - external: 3.5.0
  - extract: 1.2.3
  - federatedfilesharing: 1.8.0
  - federation: 1.8.0
  - files: 1.13.1
  - files_accesscontrol: 1.8.1
  - files_pdfviewer: 1.7.0
  - files_rightclick: 0.15.2
  - files_sharing: 1.10.1
  - files_trashbin: 1.8.0
  - files_versions: 1.11.0
  - files_videoplayer: 1.7.0
  - firstrunwizard: 2.7.0
  - groupfolders: 6.0.3
  - logreader: 2.3.0
  - lookup_server_connector: 1.6.0
  - nextcloud_announcements: 1.7.0
  - notifications: 2.6.0
  - oauth2: 1.6.0
  - onlyoffice: 4.1.4
  - password_policy: 1.8.0
  - photos: 1.0.0
  - privacy: 1.2.0
  - provisioning_api: 1.8.0
  - recommendations: 0.6.0
  - serverinfo: 1.8.0
  - settings: 1.0.0
  - sharebymail: 1.8.0
  - support: 1.1.0
  - survey_client: 1.6.0
  - systemtags: 1.8.0
  - talk_simple_poll: 1.1.0
  - text: 2.0.0
  - theming: 1.9.0
  - twofactor_backupcodes: 1.7.0
  - updatenotification: 1.8.0
  - viewer: 1.2.0
  - workflowengine: 2.0.0
Disabled:
  - admin_audit
  - encryption
  - files_external
  - spreedold
  - user_ldap


**Nextcloud configuration:**
{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "productive.designing-history.world"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "18.0.3.0",
        "overwrite.cli.url": "http:\/\/productive.designing-history.world",
        "htaccess.RewriteBase": "\/",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "maintenance": false,
        "theme": "",
        "loglevel": 2,
        "mysql.utf8mb4": true,
        "memcache.local": "\\OC\\Memcache\\APCu",
        "updater.release.channel": "stable",
        "mail_smtpmode": "smtp",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_sendmailmode": "smtp",
        "mail_smtpport": "587",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpauthtype": "LOGIN",
        "mail_smtpauth": 1,
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpsecure": "tls"
    }
}




### Client configuration
Firefox, Debian 10

### Logs

<!--- Reports without logs might be closed as unqualified reports! -->

#### Web server error log
<details>
<summary>Web server error log</summary>

Insert your webserver log here

</details>

#### Nextcloud log (data/nextcloud.log)

Insert your Nextcloud log here
{"reqId":"laNqH1lKOfsOH3wiz4am","level":3,"time":"2020-04-02T18:52:55+00:00","remoteAddr":"212.92.114.238","user":"--","app":"jsresourceloader","method":"GET","url":"/","message":"Could not find resource js/config.js to load","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Firefox/68.0","version":"18.0.3.0"}
{"reqId":"6V0FtZYTDsgS4X6ER9np","level":3,"time":"2020-04-02T18:52:55+00:00","remoteAddr":"212.92.114.238","user":"--","app":"jsresourceloader","method":"GET","url":"/apps/theming/image/logo?useSvg=1&v=7","message":"Could not find resource js/config.js to load","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Firefox/68.0","version":"18.0.3.0"}
{"reqId":"82QfpraKYYiMbqOgm7XV","level":1,"time":"2020-04-02T18:53:26+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\OC\Updater::maintenanceEnabled: Turned on maintenance mode","userAgent":"--","version":"18.0.3.0"}
{"reqId":"82QfpraKYYiMbqOgm7XV","level":0,"time":"2020-04-02T18:53:26+00:00","remoteAddr":"","user":"--","app":"core","method":"","url":"--","message":"starting upgrade from 18.0.3.0 to 18.0.3.0","userAgent":"--","version":"18.0.3.0"}
{"reqId":"82QfpraKYYiMbqOgm7XV","level":0,"time":"2020-04-02T18:53:26+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"Deprecated event type for \OC\Repair::step: Symfony\Component\EventDispatcher\GenericEvent","userAgent":"--","version":"18.0.3.0"}
{"reqId":"82QfpraKYYiMbqOgm7XV","level":1,"time":"2020-04-02T18:53:26+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\OC\Repair::step: Repair step: Repair MySQL collation","userAgent":"--","version":"18.0.3.0"}
{"reqId":"82QfpraKYYiMbqOgm7XV","level":0,"time":"2020-04-02T18:53:26+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"Deprecated event type for \OC\Repair::info: Symfony\Component\EventDispatcher\GenericEvent","userAgent":"--","version":"18.0.3.0"}
{"reqId":"82QfpraKYYiMbqOgm7XV","level":1,"time":"2020-04-02T18:53:26+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\OC\Repair::info: Repair info: All tables already have the correct collation -> nothing to do","userAgent":"--","version":"18.0.3.0"}
{"reqId":"82QfpraKYYiMbqOgm7XV","level":0,"time":"2020-04-02T18:53:26+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"Deprecated event type for \OC\Repair::step: Symfony\Component\EventDispatcher\GenericEvent","userAgent":"--","version":"18.0.3.0"}
{"reqId":"82QfpraKYYiMbqOgm7XV","level":1,"time":"2020-04-02T18:53:26+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\OC\Repair::step: Repair step: Repair SQLite autoincrement","userAgent":"--","version":"18.0.3.0"}
{"reqId":"82QfpraKYYiMbqOgm7XV","level":0,"time":"2020-04-02T18:53:26+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"Deprecated event type for \OC\Repair::step: Symfony\Component\EventDispatcher\GenericEvent","userAgent":"--","version":"18.0.3.0"}
{"reqId":"82QfpraKYYiMbqOgm7XV","level":1,"time":"2020-04-02T18:53:26+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\OC\Repair::step: Repair step: Copy data from accounts table when migrating from ownCloud","userAgent":"--","version":"18.0.3.0"}
{"reqId":"82QfpraKYYiMbqOgm7XV","level":0,"time":"2020-04-02T18:53:26+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"Deprecated event type for \OC\Repair::step: Symfony\Component\EventDispatcher\GenericEvent","userAgent":"--","version":"18.0.3.0"}
{"reqId":"82QfpraKYYiMbqOgm7XV","level":1,"time":"2020-04-02T18:53:26+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\OC\Repair::step: Repair step: Drop account terms table when migrating from ownCloud","userAgent":"--","version":"18.0.3.0"}
{"reqId":"82QfpraKYYiMbqOgm7XV","level":1,"time":"2020-04-02T18:53:26+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\OC\Updater::dbUpgradeBefore: Updating database schema","userAgent":"--","version":"18.0.3.0"}
{"reqId":"82QfpraKYYiMbqOgm7XV","level":1,"time":"2020-04-02T18:53:26+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\OC\Updater::dbUpgrade: Updated database","userAgent":"--","version":"18.0.3.0"}
{"reqId":"82QfpraKYYiMbqOgm7XV","level":1,"time":"2020-04-02T18:53:26+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\OC\Updater::appUpgradeStarted: Updating ...","userAgent":"--","version":"18.0.3.0"}
{"reqId":"82QfpraKYYiMbqOgm7XV","level":0,"time":"2020-04-02T18:53:26+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"Deprecated event type for \OC\Repair::step: Symfony\Component\EventDispatcher\GenericEvent","userAgent":"--","version":"18.0.3.0"}
{"reqId":"82QfpraKYYiMbqOgm7XV","level":1,"time":"2020-04-02T18:53:26+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\OC\Repair::step: Repair step: Fix the namespace in database tables","userAgent":"--","version":"18.0.3.0"}
{"reqId":"82QfpraKYYiMbqOgm7XV","level":3,"time":"2020-04-02T18:53:27+00:00","remoteAddr":"","user":"--","app":"core","method":"","url":"--","message":{"Exception":"Doctrine\DBAL\Exception\DriverException","Message":"An exception occurred while executing 'CREATE UNIQUE INDEX tp_ident ON oc_talk_participants (room_id, user_id, session_id)':\n\nSQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes","Code":0,"Trace":[{"file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php","line":169,"function":"convertException","class":"Doctrine\DBAL\Driver\AbstractMySQLDriver","type":"->","args":["An exception occurred while executing 'CREATE UNIQUE INDEX tp_ident ON oc_talk_participants (room_id, user_id, session_id)':\n\nSQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes",{"errorInfo":["42000",1071,"Specified key was too long; max key length is 767 bytes"],"__class__":"Doctrine\DBAL\Driver\PDOException"}]},{"file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php","line":145,"function":"wrapException","class":"Doctrine\DBAL\DBALException","type":"::","args":[{"__class__":"Doctrine\DBAL\Driver\PDOMySql\Driver"},{"errorInfo":["42000",1071,"Specified key was too long; max key length is 767 bytes"],"__class__":"Doctrine\DBAL\Driver\PDOException"},"An exception occurred while executing 'CREATE UNIQUE INDEX tp_ident ON oc_talk_participants (room_id, user_id, session_id)':\n\nSQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes"]},{"file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":1012,"function":"driverExceptionDuringQuery","class":"Doctrine\DBAL\DBALException","type":"::","args":[{"__class__":"Doctrine\DBAL\Driver\PDOMySql\Driver"},{"errorInfo":["42000",1071,"Specified key was too long; max key length is 767 bytes"],"__class__":"Doctrine\DBAL\Driver\PDOException"},"CREATE UNIQUE INDEX tp_ident ON oc_talk_participants (room_id, user_id, session_id)"]},{"file":"/var/www/html/nextcloud/lib/private/DB/Migrator.php","line":262,"function":"query","class":"Doctrine\DBAL\Connection","type":"->","args":["CREATE UNIQUE INDEX tp_ident ON oc_talk_participants (room_id, user_id, session_id)"]},{"file":"/var/www/html/nextcloud/lib/private/DB/Migrator.php","line":85,"function":"applySchema","class":"OC\DB\Migrator","type":"->","args":[{"__class__":"Doctrine\DBAL\Schema\Schema"}]},{"file":"/var/www/html/nextcloud/lib/private/DB/Connection.php","line":457,"function":"migrate","class":"OC\DB\Migrator","type":"->","args":[{"__class__":"Doctrine\DBAL\Schema\Schema"}]},{"file":"/var/www/html/nextcloud/lib/private/DB/MigrationService.php","line":486,"function":"migrateToSchema","class":"OC\DB\Connection","type":"->","args":[{"__class__":"Doctrine\DBAL\Schema\Schema"}]},{"file":"/var/www/html/nextcloud/lib/private/DB/MigrationService.php","line":414,"function":"executeStep","class":"OC\DB\MigrationService","type":"->","args":["8000Date20200331144101",false]},{"file":"/var/www/html/nextcloud/lib/private/legacy/app.php","line":915,"function":"migrate","class":"OC\DB\MigrationService","type":"->","args":[]},{"file":"/var/www/html/nextcloud/lib/private/Updater.php","line":376,"function":"updateApp","class":"OC_App","type":"::","args":["* sensitive parameters replaced "]},{"file":"/var/www/html/nextcloud/lib/private/Updater.php","line":255,"function":"doAppUpgrade","class":"OC\Updater","type":"->","args":[]},{"file":"/var/www/html/nextcloud/lib/private/Updater.php","line":131,"function":"doUpgrade","class":"OC\Updater","type":"->","args":["18.0.3.0","18.0.3.0"]},{"file":"/var/www/html/nextcloud/core/Command/Upgrade.php","line":257,"function":"upgrade","class":"OC\Updater","type":"->","args":[]},{"file":"/var/www/html/nextcloud/3rdparty/symfony/console/Command/Command.php","line":255,"function":"execute","class":"OC\Core\Command\Upgrade","type":"->","args":[{"__class__":"Symfony\Component\Console\Input\ArgvInput"},{"__class__":"Symfony\Component\Console\Output\ConsoleOutput"}]},{"file":"/var/www/html/nextcloud/3rdparty/symfony/console/Application.php","line":915,"function":"run","class":"Symfony\Component\Console\Command\Command","type":"->","args":[{"__class__":"Symfony\Component\Console\Input\ArgvInput"},{"__class__":"Symfony\Component\Console\Output\ConsoleOutput"}]},{"file":"/var/www/html/nextcloud/3rdparty/symfony/console/Application.php","line":272,"function":"doRunCommand","class":"Symfony\Component\Console\Application","type":"->","args":[{"installer":{"__class__":"OC\Installer"},"__class__":"OC\Core\Command\Upgrade"},{"__class__":"Symfony\Component\Console\Input\ArgvInput"},{"__class__":"Symfony\Component\Console\Output\ConsoleOutput"}]},{"file":"/var/www/html/nextcloud/3rdparty/symfony/console/Application.php","line":148,"function":"doRun","class":"Symfony\Component\Console\Application","type":"->","args":[{"__class__":"Symfony\Component\Console\Input\ArgvInput"},{"__class__":"Symfony\Component\Console\Output\ConsoleOutput"}]},{"file":"/var/www/html/nextcloud/lib/private/Console/Application.php","line":214,"function":"run","class":"Symfony\Component\Console\Application","type":"->","args":[{"__class__":"Symfony\Component\Console\Input\ArgvInput"},{"__class__":"Symfony\Component\Console\Output\ConsoleOutput"}]},{"file":"/var/www/html/nextcloud/console.php","line":99,"function":"run","class":"OC\Console\Application","type":"->","args":[]},{"file":"/var/www/html/nextcloud/occ","line":11,"args":["/var/www/html/nextcloud/console.php"],"function":"require_once"}],"File":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php","Line":106,"Previous":{"Exception":"Doctrine\DBAL\Driver\PDOException","Message":"SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes","Code":"42000","Trace":[{"file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":1010,"function":"query","class":"Doctrine\DBAL\Driver\PDOConnection","type":"->","args":["CREATE UNIQUE INDEX tp_ident ON oc_talk_participants (room_id, user_id, session_id)"]},{"file":"/var/www/html/nextcloud/lib/private/DB/Migrator.php","line":262,"function":"query","class":"Doctrine\DBAL\Connection","type":"->","args":["CREATE UNIQUE INDEX tp_ident ON oc_talk_participants (room_id, user_id, session_id)"]},{"file":"/var/www/html/nextcloud/lib/private/DB/Migrator.php","line":85,"function":"applySchema","class":"OC\DB\Migrator","type":"->","args":[{"__class__":"Doctrine\DBAL\Schema\Schema"}]},{"file":"/var/www/html/nextcloud/lib/private/DB/Connection.php","line":457,"function":"migrate","class":"OC\DB\Migrator","type":"->","args":[{"__class__":"Doctrine\DBAL\Schema\Schema"}]},{"file":"/var/www/html/nextcloud/lib/private/DB/MigrationService.php","line":486,"function":"migrateToSchema","class":"OC\DB\Connection","type":"->","args":[{"__class__":"Doctrine\DBAL\Schema\Schema"}]},{"file":"/var/www/html/nextcloud/lib/private/DB/MigrationService.php","line":414,"function":"executeStep","class":"OC\DB\MigrationService","type":"->","args":["8000Date20200331144101",false]},{"file":"/var/www/html/nextcloud/lib/private/legacy/app.php","line":915,"function":"migrate","class":"OC\DB\MigrationService","type":"->","args":[]},{"file":"/var/www/html/nextcloud/lib/private/Updater.php","line":376,"function":"updateApp","class":"OC_App","type":"::","args":[" sensitive parameters replaced "]},{"file":"/var/www/html/nextcloud/lib/private/Updater.php","line":255,"function":"doAppUpgrade","class":"OC\Updater","type":"->","args":[]},{"file":"/var/www/html/nextcloud/lib/private/Updater.php","line":131,"function":"doUpgrade","class":"OC\Updater","type":"->","args":["18.0.3.0","18.0.3.0"]},{"file":"/var/www/html/nextcloud/core/Command/Upgrade.php","line":257,"function":"upgrade","class":"OC\Updater","type":"->","args":[]},{"file":"/var/www/html/nextcloud/3rdparty/symfony/console/Command/Command.php","line":255,"function":"execute","class":"OC\Core\Command\Upgrade","type":"->","args":[{"__class__":"Symfony\Component\Console\Input\ArgvInput"},{"__class__":"Symfony\Component\Console\Output\ConsoleOutput"}]},{"file":"/var/www/html/nextcloud/3rdparty/symfony/console/Application.php","line":915,"function":"run","class":"Symfony\Component\Console\Command\Command","type":"->","args":[{"__class__":"Symfony\Component\Console\Input\ArgvInput"},{"__class__":"Symfony\Component\Console\Output\ConsoleOutput"}]},{"file":"/var/www/html/nextcloud/3rdparty/symfony/console/Application.php","line":272,"function":"doRunCommand","class":"Symfony\Component\Console\Application","type":"->","args":[{"installer":{"__class__":"OC\Installer"},"__class__":"OC\Core\Command\Upgrade"},{"__class__":"Symfony\Component\Console\Input\ArgvInput"},{"__class__":"Symfony\Component\Console\Output\ConsoleOutput"}]},{"file":"/var/www/html/nextcloud/3rdparty/symfony/console/Application.php","line":148,"function":"doRun","class":"Symfony\Component\Console\Application","type":"->","args":[{"__class__":"Symfony\Component\Console\Input\ArgvInput"},{"__class__":"Symfony\Component\Console\Output\ConsoleOutput"}]},{"file":"/var/www/html/nextcloud/lib/private/Console/Application.php","line":214,"function":"run","class":"Symfony\Component\Console\Application","type":"->","args":[{"__class__":"Symfony\Component\Console\Input\ArgvInput"},{"__class__":"Symfony\Component\Console\Output\ConsoleOutput"}]},{"file":"/var/www/html/nextcloud/console.php","line":99,"function":"run","class":"OC\Console\Application","type":"->","args":[]},{"file":"/var/www/html/nextcloud/occ","line":11,"args":["/var/www/html/nextcloud/console.php"],"function":"require_once"}],"File":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php","Line":90,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes","Code":"42000","Trace":[{"file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php","line":88,"function":"query","class":"PDO","type":"->","args":["CREATE UNIQUE INDEX tp_ident ON oc_talk_participants (room_id, user_id, session_id)"]},{"file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":1010,"function":"query","class":"Doctrine\DBAL\Driver\PDOConnection","type":"->","args":["CREATE UNIQUE INDEX tp_ident ON oc_talk_participants (room_id, user_id, session_id)"]},{"file":"/var/www/html/nextcloud/lib/private/DB/Migrator.php","line":262,"function":"query","class":"Doctrine\DBAL\Connection","type":"->","args":["CREATE UNIQUE INDEX tp_ident ON oc_talk_participants (room_id, user_id, session_id)"]},{"file":"/var/www/html/nextcloud/lib/private/DB/Migrator.php","line":85,"function":"applySchema","class":"OC\DB\Migrator","type":"->","args":[{"__class__":"Doctrine\DBAL\Schema\Schema"}]},{"file":"/var/www/html/nextcloud/lib/private/DB/Connection.php","line":457,"function":"migrate","class":"OC\DB\Migrator","type":"->","args":[{"__class__":"Doctrine\DBAL\Schema\Schema"}]},{"file":"/var/www/html/nextcloud/lib/private/DB/MigrationService.php","line":486,"function":"migrateToSchema","class":"OC\DB\Connection","type":"->","args":[{"__class__":"Doctrine\DBAL\Schema\Schema"}]},{"file":"/var/www/html/nextcloud/lib/private/DB/MigrationService.php","line":414,"function":"executeStep","class":"OC\DB\MigrationService","type":"->","args":["8000Date20200331144101",false]},{"file":"/var/www/html/nextcloud/lib/private/legacy/app.php","line":915,"function":"migrate","class":"OC\DB\MigrationService","type":"->","args":[]},{"file":"/var/www/html/nextcloud/lib/private/Updater.php","line":376,"function":"updateApp","class":"OC_App","type":"::","args":[" sensitive parameters replaced *"]},{"file":"/var/www/html/nextcloud/lib/private/Updater.php","line":255,"function":"doAppUpgrade","class":"OC\Updater","type":"->","args":[]},{"file":"/var/www/html/nextcloud/lib/private/Updater.php","line":131,"function":"doUpgrade","class":"OC\Updater","type":"->","args":["18.0.3.0","18.0.3.0"]},{"file":"/var/www/html/nextcloud/core/Command/Upgrade.php","line":257,"function":"upgrade","class":"OC\Updater","type":"->","args":[]},{"file":"/var/www/html/nextcloud/3rdparty/symfony/console/Command/Command.php","line":255,"function":"execute","class":"OC\Core\Command\Upgrade","type":"->","args":[{"__class__":"Symfony\Component\Console\Input\ArgvInput"},{"__class__":"Symfony\Component\Console\Output\ConsoleOutput"}]},{"file":"/var/www/html/nextcloud/3rdparty/symfony/console/Application.php","line":915,"function":"run","class":"Symfony\Component\Console\Command\Command","type":"->","args":[{"__class__":"Symfony\Component\Console\Input\ArgvInput"},{"__class__":"Symfony\Component\Console\Output\ConsoleOutput"}]},{"file":"/var/www/html/nextcloud/3rdparty/symfony/console/Application.php","line":272,"function":"doRunCommand","class":"Symfony\Component\Console\Application","type":"->","args":[{"installer":{"__class__":"OC\Installer"},"__class__":"OC\Core\Command\Upgrade"},{"__class__":"Symfony\Component\Console\Input\ArgvInput"},{"__class__":"Symfony\Component\Console\Output\ConsoleOutput"}]},{"file":"/var/www/html/nextcloud/3rdparty/symfony/console/Application.php","line":148,"function":"doRun","class":"Symfony\Component\Console\Application","type":"->","args":[{"__class__":"Symfony\Component\Console\Input\ArgvInput"},{"__class__":"Symfony\Component\Console\Output\ConsoleOutput"}]},{"file":"/var/www/html/nextcloud/lib/private/Console/Application.php","line":214,"function":"run","class":"Symfony\Component\Console\Application","type":"->","args":[{"__class__":"Symfony\Component\Console\Input\ArgvInput"},{"__class__":"Symfony\Component\Console\Output\ConsoleOutput"}]},{"file":"/var/www/html/nextcloud/console.php","line":99,"function":"run","class":"OC\Console\Application","type":"->","args":[]},{"file":"/var/www/html/nextcloud/occ","line":11,"args":["/var/www/html/nextcloud/console.php"],"function":"require_once"}],"File":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php","Line":88}},"CustomMessage":"--"},"userAgent":"--","version":"18.0.3.0"}
{"reqId":"82QfpraKYYiMbqOgm7XV","level":3,"time":"2020-04-02T18:53:27+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\OC\Updater::failure: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'CREATE UNIQUE INDEX tp_ident ON oc_talk_participants (room_id, user_id, session_id)':\n\nSQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes","userAgent":"--","version":"18.0.3.0"}
{"reqId":"82QfpraKYYiMbqOgm7XV","level":3,"time":"2020-04-02T18:53:27+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\OC\Updater::updateEnd: Update failed","userAgent":"--","version":"18.0.3.0"}
{"reqId":"82QfpraKYYiMbqOgm7XV","level":1,"time":"2020-04-02T18:53:27+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\OC\Updater::maintenanceActive: Maintenance mode is kept active","userAgent":"--","version":"18.0.3.0"}
{"reqId":"82QfpraKYYiMbqOgm7XV","level":1,"time":"2020-04-02T18:53:27+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\OC\Updater::resetLogLevel: Reset log level to Warning(2)","userAgent":"--","version":"18.0.3.0"}
{"reqId":"vkzX4U7dVVxpvZhInuhg","level":3,"time":"2020-04-02T18:57:08+00:00","remoteAddr":"2a02:908:1396:d20:4455:80dc:4fd5:c3fd","user":"--","app":"jsresourceloader","method":"GET","url":"/csrftoken","message":"Could not find resource js/config.js to load","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.132 Safari/537.36","version":"18.0.3.0"}
{"reqId":"2gDC12YK56K5qS2DyHTy","level":3,"time":"2020-04-02T18:58:00+00:00","remoteAddr":"212.92.114.238","user":"--","app":"jsresourceloader","method":"GET","url":"/","message":"Could not find resource js/config.js to load","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Firefox/68.0","version":"18.0.3.0"}
{"reqId":"wDvbC5rGZaC6ySSsx8yS","level":3,"time":"2020-04-02T18:58:03+00:00","remoteAddr":"212.92.114.238","user":"--","app":"jsresourceloader","method":"GET","url":"/apps/theming/image/logo?useSvg=1&v=7","message":"Could not find resource js/config.js to load","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Firefox/68.0","version":"18.0.3.0"}
{"reqId":"GQQ4soRU3KbTAKHBJZoV","level":3,"time":"2020-04-02T18:58:05+00:00","remoteAddr":"212.92.114.238","user":"--","app":"jsresourceloader","method":"GET","url":"/apps/theming/icon?v=7","message":"Could not find resource js/config.js to load","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Firefox/68.0","version":"18.0.3.0"}
{"reqId":"dvFJS7oqYVXDg0WAlvQP","level":3,"time":"2020-04-02T18:58:44+00:00","remoteAddr":"212.92.114.238","user":"--","app":"jsresourceloader","method":"GET","url":"/csrftoken","message":"Could not find resource js/config.js to load","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Firefox/68.0","version":"18.0.3.0"}
{"reqId":"VuaWd2ll2fEvdOW7TuVc","level":3,"time":"2020-04-02T18:58:56+00:00","remoteAddr":"212.92.114.238","user":"--","app":"jsresourceloader","method":"GET","url":"/csrftoken","message":"Could not find resource js/config.js to load","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Firefox/68.0","version":"18.0.3.0"}
{"reqId":"Qd4whZs5IYBpSK9TZJ77","level":3,"time":"2020-04-02T19:01:23+00:00","remoteAddr":"212.92.114.238","user":"--","app":"jsresourceloader","method":"GET","url":"/csrftoken","message":"Could not find resource js/config.js to load","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Firefox/68.0","version":"18.0.3.0"}

[derspotter]

Sorry for Duplicate. This fixed it:
$ sudo mysql -u root -p
MariaDB [(none)]> use nextcloud;
MariaDB [nextcloud]> set global innodb_large_prefix=on;
MariaDB [nextcloud]> set global innodb_file_format=Barracuda;
$ sudo -u www-data php occ maintenance:repair

[IanNicki]

Hi derspotter,
I‘m in exactly the same situation as you’ve been with the same settings, except of the fact that I run on MySQL.
I followed your five command line instructions, but I still have the same issue.
Do you have any other idea how to solve that issue?
Here the message from Nextcloud:

Thank you!

[Alex9001]

Sorry for Duplicate. This fixed it:
$ sudo mysql -u root -p
MariaDB [(none)]> use nextcloud;
MariaDB [nextcloud]> set global innodb_large_prefix=on;
MariaDB [nextcloud]> set global innodb_file_format=Barracuda;
$ sudo -u www-data php occ maintenance:repair

I tried that but it won't work because it is a read only variable.

Database changed
MariaDB [nextcloud]> set global innodb_large_prefix=on;
ERROR 1238 (HY000): Variable 'innodb_large_prefix' is a read only variable
MariaDB [nextcloud]> set global innodb_file_format=Barracuda;
ERROR 1238 (HY000): Variable 'innodb_file_format' is a read only variable

[derspotter]

Are you sure you are logged into mariadb as root? Otherwise you could try changing it directly in the /etc/mysql/my.cnf file.

[derspotter]

Hi derspotter,
I‘m in exactly the same situation as you’ve been with the same settings, except of the fact that I run on MySQL.
I followed your five command line instructions, but I still have the same issue.
Do you have any other idea how to solve that issue?
Here the message from Nextcloud:

Thank you!

Have you found a solution yet? I you look closely you can see, that we don't have the same error code although both are related to our sql databases.