ownCloud 10.9.1 to 10.10.1 update failure - database problem

Steps to reproduce

  1. Originally had a database collate issue that has been corrected when migrating from a locally hosted Debian 10 server to a VPS Debian 10 Server.
  2. Executed an upgrade via the CLI command after enabling Maintenance Mode
    3.Syntax sudo -u www-data ./occ upgrade

Expected behaviour

Tell us what should happen
The update should proceed and complete after some amount of time

Actual behaviour

Tell us what happens instead
The server complains with the following error:
root@k1imd:/var/www/html/owncloud# sudo -u www-data ./occ upgrade
ownCloud 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
2022-06-27T02:21:36+00:00 Set log level to debug
2022-06-27T02:21:36+00:00 Repair step: Upgrade app code from the marketplace
2022-06-27T02:21:36+00:00 Repair info: Using market to update existing apps
2022-06-27T02:21:36+00:00 Repair info: Attempting to update the following existing compatible apps from market: calendar, dav, federatedfilesharing, files, files_mediaviewer, files_pdfviewer, files_sharing, files_texteditor, files_trashbin, gallery, market, updatenotification
2022-06-27T02:21:36+00:00 Repair info: Fetching app from market: calendar
2022-06-27T02:21:37+00:00 Repair info:
2022-06-27T02:21:37+00:00 Repair info: Fetching app from market: dav
2022-06-27T02:21:37+00:00 Repair info: App (dav) is not known at the marketplace.
2022-06-27T02:21:37+00:00 Repair info: Fetching app from market: federatedfilesharing
2022-06-27T02:21:37+00:00 Repair info: App (federatedfilesharing) is not known at the marketplace.
2022-06-27T02:21:37+00:00 Repair info: Fetching app from market: files
2022-06-27T02:21:37+00:00 Repair info: App (files) is not known at the marketplace.
2022-06-27T02:21:37+00:00 Repair info: Fetching app from market: files_mediaviewer
2022-06-27T02:21:37+00:00 Repair info:
2022-06-27T02:21:37+00:00 Repair info: Fetching app from market: files_pdfviewer
2022-06-27T02:21:37+00:00 Repair info:
2022-06-27T02:21:37+00:00 Repair info: Fetching app from market: files_sharing
2022-06-27T02:21:37+00:00 Repair info: App (files_sharing) is not known at the marketplace.
2022-06-27T02:21:37+00:00 Repair info: Fetching app from market: files_texteditor
2022-06-27T02:21:37+00:00 Repair info:
2022-06-27T02:21:37+00:00 Repair info: Fetching app from market: files_trashbin
2022-06-27T02:21:37+00:00 Repair info: App (files_trashbin) is not known at the marketplace.
2022-06-27T02:21:37+00:00 Repair info: Fetching app from market: gallery
2022-06-27T02:21:37+00:00 Repair info:
2022-06-27T02:21:37+00:00 Repair info: Fetching app from market: market
2022-06-27T02:21:37+00:00 Repair info:
2022-06-27T02:21:37+00:00 Repair info: Fetching app from market: updatenotification
2022-06-27T02:21:37+00:00 Repair info: App (updatenotification) is not known at the marketplace.
2022-06-27T02:21:37+00:00 Repair info: App was not updated: calendar
2022-06-27T02:21:37+00:00 Repair info: App was not updated: dav
2022-06-27T02:21:37+00:00 Repair info: App was not updated: federatedfilesharing
2022-06-27T02:21:37+00:00 Repair info: App was not updated: files
2022-06-27T02:21:37+00:00 Repair info: App was not updated: files_mediaviewer
2022-06-27T02:21:37+00:00 Repair info: App was not updated: files_pdfviewer
2022-06-27T02:21:37+00:00 Repair info: App was not updated: files_sharing
2022-06-27T02:21:37+00:00 Repair info: App was not updated: files_texteditor
2022-06-27T02:21:37+00:00 Repair info: App was not updated: files_trashbin
2022-06-27T02:21:37+00:00 Repair info: App was not updated: gallery
2022-06-27T02:21:37+00:00 Repair info: App was not updated: market
2022-06-27T02:21:37+00:00 Repair info: App was not updated: updatenotification
2022-06-27T02:21:37+00:00 Repair step: Repair MySQL database engine
2022-06-27T02:21:37+00:00 Repair step: Repair MySQL collation
2022-06-27T02:21:37+00:00 Repair info: Change collation for oc_activity …
2022-06-27T02:21:37+00:00 Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘ALTER TABLE oc_activity CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;’:

SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
2022-06-27T02:21:37+00:00 Update failed
2022-06-27T02:21:37+00:00 Maintenance mode is kept active
2022-06-27T02:21:37+00:00 Reset log level

Server configuration

Operating system:
Debian 10 Buster

Web server:
Apache

Database:
mariadb

PHP version:
PHP 7.4.29 (cli) (built: Apr 22 2022 06:44:32) ( NTS )
Copyright (c) The PHP Group
Zend Engine v3.4.0, Copyright (c) Zend Technologies
with Zend OPcache v7.4.29, Copyright (c), by Zend Technologies

ownCloud version: (see ownCloud admin page)
10.9.1 → 10.10.1 (Cannot access the admin page)

Updated from an older ownCloud or fresh install:
Update failure

Where did you install ownCloud from:
Web Repo

Signing status (ownCloud 9.0 and above):

Login as admin user into your ownCloud and access 
http://example.com/index.php/settings/integrity/failed 
paste the results into https://gist.github.com/ and puth the link here.
No Access

The content of config/config.php:
root@k1imd:/var/www/html/owncloud# sudo -u www-data php occ config:list system
ownCloud 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”: {
“instanceid”: “ocl06yd2d13j”,
“passwordsalt”: “REMOVED SENSITIVE VALUE”,
“secret”: “REMOVED SENSITIVE VALUE”,
“trusted_domains”: [
“localhost”,
“REMOVED SENSITIVE VALUE”,
“REMOVED SENSITIVE VALUE”,
“REMOVED SENSITIVE VALUE”
],
“datadirectory”: “/var/www/html/owncloud/data”,
“overwrite.cli.url”: “http://REMOVED SENSITIVE VALUE/owncloud”,
“dbtype”: “mysql”,
“version”: “10.9.1.2”,
“dbname”: “owncloud”,
“dbhost”: “localhost”,
“dbtableprefix”: “oc_”,
“mysql.utf8mb4”: true,
“dbuser”: “REMOVED SENSITIVE VALUE”,
“dbpassword”: “REMOVED SENSITIVE VALUE”,
“allow_user_to_change_mail_address”: “”,
“logtimezone”: “UTC”,
“apps_paths”: [
{
“path”: “/var/www/html/owncloud/apps”,
“url”: “/apps”,
“writable”: false
},
{
“path”: “/var/www/html/owncloud/apps-external”,
“url”: “/apps-external”,
“writable”: true
}
],
“installed”: true,
“mail_domain”: “REMOVED SENSITIVE VALUE”,
“mail_from_address”: “REMOVED SENSITIVE VALUE”,
“mail_smtpmode”: “smtp”,
“mail_smtpauthtype”: “LOGIN”,
“mail_smtpauth”: 1,
“mail_smtphost”: “REMOVED SENSITIVE VALUE”,
“mail_smtpport”: “25”,
“mail_smtpname”: “REMOVED SENSITIVE VALUE”,
“mail_smtppassword”: “REMOVED SENSITIVE VALUE”,
“maintenance”: true,
“updater.secret”: “REMOVED SENSITIVE VALUE”,
“loglevel”: 2,
“theme”: “”
}
}

Log in to the web-UI with an administrator account and click on
'admin' -> 'Generate Config Report' -> 'Download ownCloud config report'
This report includes the config.php settings, the list of activated apps
and other details in a well sanitized form.
or 
If you have access to your command line run e.g.:
sudo -u www-data php occ config:list system
from within your ownCloud installation folder

List of activated apps:
root@k1imd:/var/www/html/owncloud# sudo -u www-data php occ app:list
ownCloud 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:

  • calendar:
    • Version: 1.6.4
    • Path: /var/www/html/owncloud/apps-external/calendar
  • dav:
    • Version: 0.7.0
    • Path: /var/www/html/owncloud/apps/dav
  • federatedfilesharing:
    • Version: 0.5.0
    • Path: /var/www/html/owncloud/apps/federatedfilesharing
  • files:
    • Version: 1.5.2
    • Path: /var/www/html/owncloud/apps/files
  • files_mediaviewer:
    • Version: 1.0.5
    • Path: /var/www/html/owncloud/apps/files_mediaviewer
  • files_pdfviewer:
    • Version: 1.0.1
    • Path: /var/www/html/owncloud/apps-external/files_pdfviewer
  • files_sharing:
    • Version: 0.14.0
    • Path: /var/www/html/owncloud/apps/files_sharing
  • files_texteditor:
    • Version: 2.4.1
    • Path: /var/www/html/owncloud/apps-external/files_texteditor
  • files_trashbin:
    • Version: 0.9.1
    • Path: /var/www/html/owncloud/apps/files_trashbin
  • gallery:
    • Version: 16.1.2
    • Path: /var/www/html/owncloud/apps-external/gallery
  • market:
    • Version: 0.6.3
    • Path: /var/www/html/owncloud/apps/market
  • updatenotification:
    • Version: 0.2.1
    • Path: /var/www/html/owncloud/apps/updatenotification
      Disabled:
  • comments:
    • Path: /var/www/html/owncloud/apps/comments
  • configreport:
    • Path: /var/www/html/owncloud/apps/configreport
  • encryption:
    • Path: /var/www/html/owncloud/apps/encryption
  • external:
    • Path: /var/www/html/owncloud/apps/external
  • federation:
    • Path: /var/www/html/owncloud/apps/federation
  • files_external:
    • Path: /var/www/html/owncloud/apps/files_external
  • files_versions:
    • Path: /var/www/html/owncloud/apps/files_versions
  • firstrunwizard:
    • Path: /var/www/html/owncloud/apps/firstrunwizard
  • notifications:
    • Path: /var/www/html/owncloud/apps/notifications
  • provisioning_api:
    • Path: /var/www/html/owncloud/apps/provisioning_api
  • systemtags:
    • Path: /var/www/html/owncloud/apps/systemtags
  • user_external:
    • Path: /var/www/html/owncloud/apps/user_external
If you have access to your command line run e.g.:
sudo -u www-data php occ app:list

Are you using external storage, if yes which one: local/smb/sftp/…
No
Are you using encryption: yes/no
No

ownCloud log (data/owncloud.log)

{“reqId”:“YrfQTRMLwtU6UDqpbhaibQAAAAA”,“level”:3,“time”:“2022-06-26T03:19:42+00:00”,“remoteAddr”:“108.58.17.122”,“user”:"–",“app”:“core”,“method”:“GET”,“url”:"/owncloud/core/ajax/update.php?requesttoken=QXNDAC8HJWptLxwWYAAOPgIFLX4gODoCYiY8Li07Vx0%3D%3ApJ1cMkN%2F9XZeXCyDAJTOSirv1hfVZO5KVRCtsgEaOdQ%3D",“message”:“Caused by: {“Exception”:“PDOException”,“Message”:“SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs”,“Code”:“42000”,“Trace”:”#0 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php(117): PDOStatement->execute()\n#1 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Statement.php(179): Doctrine\\DBAL\\Driver\\PDOStatement->execute()\n#2 \/var\/www\/html\/owncloud\/lib\/private\/Repair\/Collation.php(70): Doctrine\\DBAL\\Statement->execute()\n#3 \/var\/www\/html\/owncloud\/lib\/private\/Repair.php(90): OC\\Repair\\Collation->run()\n#4 \/var\/www\/html\/owncloud\/lib\/private\/Updater.php(261): OC\\Repair->run()\n#5 \/var\/www\/html\/owncloud\/lib\/private\/Updater.php(114): OC\\Updater->doUpgrade()\n#6 \/var\/www\/html\/owncloud\/core\/ajax\/update.php(191): OC\\Updater->upgrade()\n#7 {main}",“File”:"\/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php",“Line”:117}"}
{“reqId”:“vNVaNemeZAkTtiY4ExHh”,“level”:0,“time”:“2022-06-26T03:37:21+00:00”,“remoteAddr”:"",“user”:"–",“app”:“core”,“method”:"–",“url”:"–",“message”:“starting upgrade from 10.9.1.2 to 10.10.0.3”}
{“reqId”:“vNVaNemeZAkTtiY4ExHh”,“level”:3,“time”:“2022-06-26T03:37:22+00:00”,“remoteAddr”:"",“user”:"–",“app”:“core”,“method”:"–",“url”:"–",“message”:“Exception: {“Exception”:“Doctrine\\DBAL\\Exception\\DriverException”,“Message”:“An exception occurred while executing ‘ALTER TABLE oc_activity CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;’:\n\nSQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs”,“Code”:0,“Trace”:”#0 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php(182): Doctrine\\DBAL\\Driver\\AbstractMySQLDriver->convertException()\n#1 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php(159): Doctrine\\DBAL\\DBALException::wrapException()\n#2 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php(2226): Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery()\n#3 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Statement.php(185): Doctrine\\DBAL\\Connection->handleExceptionDuringQuery()\n#4 \/var\/www\/html\/owncloud\/lib\/private\/Repair\/Collation.php(70): Doctrine\\DBAL\\Statement->execute()\n#5 \/var\/www\/html\/owncloud\/lib\/private\/Repair.php(90): OC\\Repair\\Collation->run()\n#6 \/var\/www\/html\/owncloud\/lib\/private\/Updater.php(261): OC\\Repair->run()\n#7 \/var\/www\/html\/owncloud\/lib\/private\/Updater.php(114): OC\\Updater->doUpgrade()\n#8 \/var\/www\/html\/owncloud\/core\/Command\/Upgrade.php(269): OC\\Updater->upgrade()\n#9 \/var\/www\/html\/owncloud\/lib\/composer\/symfony\/console\/Command\/Command.php(255): OC\\Core\\Command\\Upgrade->execute()\n#10 \/var\/www\/html\/owncloud\/lib\/composer\/symfony\/console\/Application.php(1009): Symfony\\Component\\Console\\Command\\Command->run()\n#11 \/var\/www\/html\/owncloud\/lib\/composer\/symfony\/console\/Application.php(273): Symfony\\Component\\Console\\Application->doRunCommand()\n#12 \/var\/www\/html\/owncloud\/lib\/composer\/symfony\/console\/Application.php(149): Symfony\\Component\\Console\\Application->doRun()\n#13 \/var\/www\/html\/owncloud\/lib\/private\/Console\/Application.php(165): Symfony\\Component\\Console\\Application->run()\n#14 \/var\/www\/html\/owncloud\/console.php(116): OC\\Console\\Application->run()\n#15 \/var\/www\/html\/owncloud\/occ(11): require_once(’\/var\/www\/html\/o…’)\n#16 {main}",“File”:"\/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/AbstractMySQLDriver.php",“Line”:128}"}
{“reqId”:“vNVaNemeZAkTtiY4ExHh”,“level”:3,“time”:“2022-06-26T03:37:22+00:00”,“remoteAddr”:"",“user”:"–",“app”:“core”,“method”:"–",“url”:"–",“message”:“Caused by: {“Exception”:“Doctrine\\DBAL\\Driver\\PDO\\Exception”,“Message”:“SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs”,“Code”:“42000”,“Trace”:”#0 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php(119): Doctrine\\DBAL\\Driver\\PDO\\Exception::new()\n#1 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Statement.php(179): Doctrine\\DBAL\\Driver\\PDOStatement->execute()\n#2 \/var\/www\/html\/owncloud\/lib\/private\/Repair\/Collation.php(70): Doctrine\\DBAL\\Statement->execute()\n#3 \/var\/www\/html\/owncloud\/lib\/private\/Repair.php(90): OC\\Repair\\Collation->run()\n#4 \/var\/www\/html\/owncloud\/lib\/private\/Updater.php(261): OC\\Repair->run()\n#5 \/var\/www\/html\/owncloud\/lib\/private\/Updater.php(114): OC\\Updater->doUpgrade()\n#6 \/var\/www\/html\/owncloud\/core\/Command\/Upgrade.php(269): OC\\Updater->upgrade()\n#7 \/var\/www\/html\/owncloud\/lib\/composer\/symfony\/console\/Command\/Command.php(255): OC\\Core\\Command\\Upgrade->execute()\n#8 \/var\/www\/html\/owncloud\/lib\/composer\/symfony\/console\/Application.php(1009): Symfony\\Component\\Console\\Command\\Command->run()\n#9 \/var\/www\/html\/owncloud\/lib\/composer\/symfony\/console\/Application.php(273): Symfony\\Component\\Console\\Application->doRunCommand()\n#10 \/var\/www\/html\/owncloud\/lib\/composer\/symfony\/console\/Application.php(149): Symfony\\Component\\Console\\Application->doRun()\n#11 \/var\/www\/html\/owncloud\/lib\/private\/Console\/Application.php(165): Symfony\\Component\\Console\\Application->run()\n#12 \/var\/www\/html\/owncloud\/console.php(116): OC\\Console\\Application->run()\n#13 \/var\/www\/html\/owncloud\/occ(11): require_once(’\/var\/www\/html\/o…’)\n#14 {main}",“File”:"\/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDO\/Exception.php",“Line”:18}"}
{“reqId”:“vNVaNemeZAkTtiY4ExHh”,“level”:3,“time”:“2022-06-26T03:37:22+00:00”,“remoteAddr”:"",“user”:"–",“app”:“core”,“method”:"–",“url”:"–",“message”:“Caused by: {“Exception”:“PDOException”,“Message”:“SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs”,“Code”:“42000”,“Trace”:”#0 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php(117): PDOStatement->execute()\n#1 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Statement.php(179): Doctrine\\DBAL\\Driver\\PDOStatement->execute()\n#2 \/var\/www\/html\/owncloud\/lib\/private\/Repair\/Collation.php(70): Doctrine\\DBAL\\Statement->execute()\n#3 \/var\/www\/html\/owncloud\/lib\/private\/Repair.php(90): OC\\Repair\\Collation->run()\n#4 \/var\/www\/html\/owncloud\/lib\/private\/Updater.php(261): OC\\Repair->run()\n#5 \/var\/www\/html\/owncloud\/lib\/private\/Updater.php(114): OC\\Updater->doUpgrade()\n#6 \/var\/www\/html\/owncloud\/core\/Command\/Upgrade.php(269): OC\\Updater->upgrade()\n#7 \/var\/www\/html\/owncloud\/lib\/composer\/symfony\/console\/Command\/Command.php(255): OC\\Core\\Command\\Upgrade->execute()\n#8 \/var\/www\/html\/owncloud\/lib\/composer\/symfony\/console\/Application.php(1009): Symfony\\Component\\Console\\Command\\Command->run()\n#9 \/var\/www\/html\/owncloud\/lib\/composer\/symfony\/console\/Application.php(273): Symfony\\Component\\Console\\Application->doRunCommand()\n#10 \/var\/www\/html\/owncloud\/lib\/composer\/symfony\/console\/Application.php(149): Symfony\\Component\\Console\\Application->doRun()\n#11 \/var\/www\/html\/owncloud\/lib\/private\/Console\/Application.php(165): Symfony\\Component\\Console\\Application->run()\n#12 \/var\/www\/html\/owncloud\/console.php(116): OC\\Console\\Application->run()\n#13 \/var\/www\/html\/owncloud\/occ(11): require_once(’\/var\/www\/html\/o…’)\n#14 {main}",“File”:"\/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php",“Line”:117}"}
{“reqId”:“UTjXVajB0Bbc9dzBG3FZ”,“level”:0,“time”:“2022-06-27T02:21:36+00:00”,“remoteAddr”:"",“user”:"–",“app”:“core”,“method”:"–",“url”:"–",“message”:“starting upgrade from 10.9.1.2 to 10.10.0.3”}
{“reqId”:“UTjXVajB0Bbc9dzBG3FZ”,“level”:3,“time”:“2022-06-27T02:21:37+00:00”,“remoteAddr”:"",“user”:"–",“app”:“core”,“method”:"–",“url”:"–",“message”:“Exception: {“Exception”:“Doctrine\\DBAL\\Exception\\DriverException”,“Message”:“An exception occurred while executing ‘ALTER TABLE oc_activity CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;’:\n\nSQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs”,“Code”:0,“Trace”:”#0 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php(182): Doctrine\\DBAL\\Driver\\AbstractMySQLDriver->convertException()\n#1 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php(159): Doctrine\\DBAL\\DBALException::wrapException()\n#2 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php(2226): Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery()\n#3 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Statement.php(185): Doctrine\\DBAL\\Connection->handleExceptionDuringQuery()\n#4 \/var\/www\/html\/owncloud\/lib\/private\/Repair\/Collation.php(70): Doctrine\\DBAL\\Statement->execute()\n#5 \/var\/www\/html\/owncloud\/lib\/private\/Repair.php(90): OC\\Repair\\Collation->run()\n#6 \/var\/www\/html\/owncloud\/lib\/private\/Updater.php(261): OC\\Repair->run()\n#7 \/var\/www\/html\/owncloud\/lib\/private\/Updater.php(114): OC\\Updater->doUpgrade()\n#8 \/var\/www\/html\/owncloud\/core\/Command\/Upgrade.php(269): OC\\Updater->upgrade()\n#9 \/var\/www\/html\/owncloud\/lib\/composer\/symfony\/console\/Command\/Command.php(255): OC\\Core\\Command\\Upgrade->execute()\n#10 \/var\/www\/html\/owncloud\/lib\/composer\/symfony\/console\/Application.php(1009): Symfony\\Component\\Console\\Command\\Command->run()\n#11 \/var\/www\/html\/owncloud\/lib\/composer\/symfony\/console\/Application.php(273): Symfony\\Component\\Console\\Application->doRunCommand()\n#12 \/var\/www\/html\/owncloud\/lib\/composer\/symfony\/console\/Application.php(149): Symfony\\Component\\Console\\Application->doRun()\n#13 \/var\/www\/html\/owncloud\/lib\/private\/Console\/Application.php(165): Symfony\\Component\\Console\\Application->run()\n#14 \/var\/www\/html\/owncloud\/console.php(116): OC\\Console\\Application->run()\n#15 \/var\/www\/html\/owncloud\/occ(11): require_once(’\/var\/www\/html\/o…’)\n#16 {main}",“File”:"\/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/AbstractMySQLDriver.php",“Line”:128}"}
{“reqId”:“UTjXVajB0Bbc9dzBG3FZ”,“level”:3,“time”:“2022-06-27T02:21:37+00:00”,“remoteAddr”:"",“user”:"–",“app”:“core”,“method”:"–",“url”:"–",“message”:“Caused by: {“Exception”:“Doctrine\\DBAL\\Driver\\PDO\\Exception”,“Message”:“SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs”,“Code”:“42000”,“Trace”:”#0 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php(119): Doctrine\\DBAL\\Driver\\PDO\\Exception::new()\n#1 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Statement.php(179): Doctrine\\DBAL\\Driver\\PDOStatement->execute()\n#2 \/var\/www\/html\/owncloud\/lib\/private\/Repair\/Collation.php(70): Doctrine\\DBAL\\Statement->execute()\n#3 \/var\/www\/html\/owncloud\/lib\/private\/Repair.php(90): OC\\Repair\\Collation->run()\n#4 \/var\/www\/html\/owncloud\/lib\/private\/Updater.php(261): OC\\Repair->run()\n#5 \/var\/www\/html\/owncloud\/lib\/private\/Updater.php(114): OC\\Updater->doUpgrade()\n#6 \/var\/www\/html\/owncloud\/core\/Command\/Upgrade.php(269): OC\\Updater->upgrade()\n#7 \/var\/www\/html\/owncloud\/lib\/composer\/symfony\/console\/Command\/Command.php(255): OC\\Core\\Command\\Upgrade->execute()\n#8 \/var\/www\/html\/owncloud\/lib\/composer\/symfony\/console\/Application.php(1009): Symfony\\Component\\Console\\Command\\Command->run()\n#9 \/var\/www\/html\/owncloud\/lib\/composer\/symfony\/console\/Application.php(273): Symfony\\Component\\Console\\Application->doRunCommand()\n#10 \/var\/www\/html\/owncloud\/lib\/composer\/symfony\/console\/Application.php(149): Symfony\\Component\\Console\\Application->doRun()\n#11 \/var\/www\/html\/owncloud\/lib\/private\/Console\/Application.php(165): Symfony\\Component\\Console\\Application->run()\n#12 \/var\/www\/html\/owncloud\/console.php(116): OC\\Console\\Application->run()\n#13 \/var\/www\/html\/owncloud\/occ(11): require_once(’\/var\/www\/html\/o…’)\n#14 {main}",“File”:"\/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDO\/Exception.php",“Line”:18}"}
{“reqId”:“UTjXVajB0Bbc9dzBG3FZ”,“level”:3,“time”:“2022-06-27T02:21:37+00:00”,“remoteAddr”:"",“user”:"–",“app”:“core”,“method”:"–",“url”:"–",“message”:“Caused by: {“Exception”:“PDOException”,“Message”:“SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs”,“Code”:“42000”,“Trace”:”#0 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php(117): PDOStatement->execute()\n#1 \/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Statement.php(179): Doctrine\\DBAL\\Driver\\PDOStatement->execute()\n#2 \/var\/www\/html\/owncloud\/lib\/private\/Repair\/Collation.php(70): Doctrine\\DBAL\\Statement->execute()\n#3 \/var\/www\/html\/owncloud\/lib\/private\/Repair.php(90): OC\\Repair\\Collation->run()\n#4 \/var\/www\/html\/owncloud\/lib\/private\/Updater.php(261): OC\\Repair->run()\n#5 \/var\/www\/html\/owncloud\/lib\/private\/Updater.php(114): OC\\Updater->doUpgrade()\n#6 \/var\/www\/html\/owncloud\/core\/Command\/Upgrade.php(269): OC\\Updater->upgrade()\n#7 \/var\/www\/html\/owncloud\/lib\/composer\/symfony\/console\/Command\/Command.php(255): OC\\Core\\Command\\Upgrade->execute()\n#8 \/var\/www\/html\/owncloud\/lib\/composer\/symfony\/console\/Application.php(1009): Symfony\\Component\\Console\\Command\\Command->run()\n#9 \/var\/www\/html\/owncloud\/lib\/composer\/symfony\/console\/Application.php(273): Symfony\\Component\\Console\\Application->doRunCommand()\n#10 \/var\/www\/html\/owncloud\/lib\/composer\/symfony\/console\/Application.php(149): Symfony\\Component\\Console\\Application->doRun()\n#11 \/var\/www\/html\/owncloud\/lib\/private\/Console\/Application.php(165): Symfony\\Component\\Console\\Application->run()\n#12 \/var\/www\/html\/owncloud\/console.php(116): OC\\Console\\Application->run()\n#13 \/var\/www\/html\/owncloud\/occ(11): require_once(’\/var\/www\/html\/o…’)\n#14 {main}",“File”:"\/var\/www\/html\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php",“Line”:117}"}

Update log

[info] Execution of upgrade:detect command started
[info] ownCloud 10.9.1.2 found
[info] Execution of upgrade:detect command stopped. Exit code is 0
[info] Execution of upgrade:checkSystem command started
[info] Execution of upgrade:checkSystem command stopped. Exit code is 0
[info] Execution of upgrade:checkpoint command started
[info] Execution of upgrade:checkpoint command stopped. Exit code is 0
[info] Execution of upgrade:detect command started
[info] ownCloud 10.9.1.2 found
[info] Execution of upgrade:detect command stopped. Exit code is 0
[info] Execution of upgrade:executeCoreUpgradeScripts command started
[debug] Replacing 3rdparty
[debug] Replacing config
[debug] Replacing core
[debug] Replacing l10n
[debug] Replacing lib
[debug] Replacing ocm-provider
[debug] Replacing ocs
[debug] Replacing ocs-provider
[debug] Replacing resources
[debug] Replacing settings
[debug] Replacing .htaccess
[debug] Replacing .mailmap
[debug] Replacing .tag
[debug] Replacing .user.ini
[debug] Replacing AUTHORS
[debug] Replacing CHANGELOG.md
[debug] Replacing console.php
[debug] Replacing COPYING
[debug] Replacing cron.php
[debug] Replacing db_structure.xml
[debug] Replacing index.html
[debug] Replacing index.php
[debug] Replacing indie.json
[debug] Replacing occ
[debug] Replacing public.php
[debug] Replacing remote.php
[debug] Replacing robots.txt
[debug] Replacing status.php
[debug] Replacing version.php
[debug] Replacing README.md
[info] Execution of upgrade:executeCoreUpgradeScripts command stopped. Exit code is 0

I’d try to restart the upgrade without the activity app. Remove it.

BTW & OT: Review your app list. The newer files_mediaviewer and the older gallery are conflicting. I think the latter doesn’t work if the newer in installed.

1 Like

Good Day All!
I attempted to rerun the update and I don’t see the activity app installed. I may have been installed in previously on a server that I migrated from but not present now.
App List:
root@k1imd:/var/www/html/owncloud# sudo -u www-data php occ app:list
ownCloud 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:

  • calendar:
    • Version: 1.6.4
    • Path: /var/www/html/owncloud/apps-external/calendar
  • dav:
    • Version: 0.7.0
    • Path: /var/www/html/owncloud/apps/dav
  • federatedfilesharing:
    • Version: 0.5.0
    • Path: /var/www/html/owncloud/apps/federatedfilesharing
  • files:
    • Version: 1.5.2
    • Path: /var/www/html/owncloud/apps/files
  • files_mediaviewer:
    • Version: 1.0.5
    • Path: /var/www/html/owncloud/apps/files_mediaviewer
  • files_pdfviewer:
    • Version: 1.0.1
    • Path: /var/www/html/owncloud/apps-external/files_pdfviewer
  • files_sharing:
    • Version: 0.14.0
    • Path: /var/www/html/owncloud/apps/files_sharing
  • files_texteditor:
    • Version: 2.4.1
    • Path: /var/www/html/owncloud/apps-external/files_texteditor
  • files_trashbin:
    • Version: 0.9.1
    • Path: /var/www/html/owncloud/apps/files_trashbin
  • gallery:
    • Version: 16.1.2
    • Path: /var/www/html/owncloud/apps-external/gallery
  • market:
    • Version: 0.6.3
    • Path: /var/www/html/owncloud/apps/market
  • updatenotification:
    • Version: 0.2.1
    • Path: /var/www/html/owncloud/apps/updatenotification
      Disabled:
  • comments:
    • Path: /var/www/html/owncloud/apps/comments
  • configreport:
    • Path: /var/www/html/owncloud/apps/configreport
  • encryption:
    • Path: /var/www/html/owncloud/apps/encryption
  • external:
    • Path: /var/www/html/owncloud/apps/external
  • federation:
    • Path: /var/www/html/owncloud/apps/federation
  • files_external:
    • Path: /var/www/html/owncloud/apps/files_external
  • files_versions:
    • Path: /var/www/html/owncloud/apps/files_versions
  • firstrunwizard:
    • Path: /var/www/html/owncloud/apps/firstrunwizard
  • gallery_:
    • Path: /var/www/html/owncloud/apps-external/gallery_
  • notifications:
    • Path: /var/www/html/owncloud/apps/notifications
  • provisioning_api:
    • Path: /var/www/html/owncloud/apps/provisioning_api
  • systemtags:
    • Path: /var/www/html/owncloud/apps/systemtags
  • user_external:
    • Path: /var/www/html/owncloud/apps/user_external
      root@k1imd:/var/www/html/owncloud#

Actual owncloud/apps directory:
apps2
apps

Attempted update:
root@k1imd:/var/www/html/owncloud# sudo -u www-data ./occ upgrade
ownCloud 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
2022-07-03T13:21:25+00:00 Set log level to debug
2022-07-03T13:21:25+00:00 Repair step: Upgrade app code from the marketplace
2022-07-03T13:21:26+00:00 Repair info: Using market to update existing apps
2022-07-03T13:21:26+00:00 Repair info: Attempting to update the following existing compatible apps from market: calendar, dav, federatedfilesharing, files, files_mediaviewer, files_pdfviewer, files_sharing, files_texteditor, files_trashbin, gallery, market, updatenotification
2022-07-03T13:21:26+00:00 Repair info: Fetching app from market: calendar
2022-07-03T13:21:27+00:00 Repair info:
2022-07-03T13:21:27+00:00 Repair info: Fetching app from market: dav
2022-07-03T13:21:27+00:00 Repair info: App (dav) is not known at the marketplace.
2022-07-03T13:21:27+00:00 Repair info: Fetching app from market: federatedfilesharing
2022-07-03T13:21:27+00:00 Repair info: App (federatedfilesharing) is not known at the marketplace.
2022-07-03T13:21:27+00:00 Repair info: Fetching app from market: files
2022-07-03T13:21:27+00:00 Repair info: App (files) is not known at the marketplace.
2022-07-03T13:21:27+00:00 Repair info: Fetching app from market: files_mediaviewer
2022-07-03T13:21:27+00:00 Repair info:
2022-07-03T13:21:27+00:00 Repair info: Fetching app from market: files_pdfviewer
2022-07-03T13:21:27+00:00 Repair info:
2022-07-03T13:21:27+00:00 Repair info: Fetching app from market: files_sharing
2022-07-03T13:21:27+00:00 Repair info: App (files_sharing) is not known at the marketplace.
2022-07-03T13:21:27+00:00 Repair info: Fetching app from market: files_texteditor
2022-07-03T13:21:27+00:00 Repair info:
2022-07-03T13:21:27+00:00 Repair info: Fetching app from market: files_trashbin
2022-07-03T13:21:27+00:00 Repair info: App (files_trashbin) is not known at the marketplace.
2022-07-03T13:21:27+00:00 Repair info: Fetching app from market: gallery
2022-07-03T13:21:27+00:00 Repair info:
2022-07-03T13:21:27+00:00 Repair info: Fetching app from market: market
2022-07-03T13:21:27+00:00 Repair info:
2022-07-03T13:21:27+00:00 Repair info: Fetching app from market: updatenotification
2022-07-03T13:21:27+00:00 Repair info: App (updatenotification) is not known at the marketplace.
2022-07-03T13:21:27+00:00 Repair info: App was not updated: calendar
2022-07-03T13:21:27+00:00 Repair info: App was not updated: dav
2022-07-03T13:21:27+00:00 Repair info: App was not updated: federatedfilesharing
2022-07-03T13:21:27+00:00 Repair info: App was not updated: files
2022-07-03T13:21:27+00:00 Repair info: App was not updated: files_mediaviewer
2022-07-03T13:21:27+00:00 Repair info: App was not updated: files_pdfviewer
2022-07-03T13:21:27+00:00 Repair info: App was not updated: files_sharing
2022-07-03T13:21:27+00:00 Repair info: App was not updated: files_texteditor
2022-07-03T13:21:27+00:00 Repair info: App was not updated: files_trashbin
2022-07-03T13:21:27+00:00 Repair info: App was not updated: gallery
2022-07-03T13:21:27+00:00 Repair info: App was not updated: market
2022-07-03T13:21:27+00:00 Repair info: App was not updated: updatenotification
2022-07-03T13:21:27+00:00 Repair step: Repair MySQL database engine
2022-07-03T13:21:27+00:00 Repair step: Repair MySQL collation
2022-07-03T13:21:27+00:00 Repair info: Change collation for oc_activity …
2022-07-03T13:21:27+00:00 Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘ALTER TABLE oc_activity CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;’:

SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
2022-07-03T13:21:27+00:00 Update failed
2022-07-03T13:21:27+00:00 Maintenance mode is kept active
2022-07-03T13:21:27+00:00 Reset log level
root@k1imd:/var/www/html/owncloud#

Since the activity app is not in use should I somehow delete that table oc_activity from the sql database?

Capnjb

Yes, this would be my next suggestion. Maybe you can create an SQL dump of this table before dropping it. Just in case you want to work with it later on.

1 Like

Keep in mind that activity app has also some background jobs registered. Missing their code, they will flood your owncloud.log with errors. Not much, but I like to have it clean.

Table: oc_jobs

I nearly had everything working given the guidance but have not been able to access the VPS for over 3 weeks. The host VirMach migrated to new hardware and ever since there has been no public IP to access the server. This is very frustrating! I have 2 VPS’s with them and both are not accessible.

What a disaster, unable to bring a system back to life within three weeks. These are the real professionals. :astonished: SCNR, I know that this is not helpful.