Steps to reproduce
- 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.
- 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