[Bug]: Upgrade tries to change row format in MySQL, even if it's already correct

[nalt]

⚠️ This issue respects the following points: ⚠️

• This is a bug, not a question or a configuration/webserver/proxy issue.
• This issue is not already reported on Github OR Nextcloud Community Forum (I've searched it).
• Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
• I agree to follow Nextcloud's Code of Conduct.

Bug description

The upgrade command changes the row format of many tables to dynamic, even if it is already set to dynamic. The attempted change is repeated, apparently for each app that is upgraded. This takes almost an hour on larger installation, several minutes alone on oc_filecache.

Steps to reproduce

1. Check on oc_filecache for format: dynamic; options:row_format=DYNAMIC.
2. Run occ upgrade
3. Monitor MySQL status, you will see ALTER TABLE oc_filecache ROW_FORMAT = DYNAMIC

Expected behavior

No change of DB format if it is already correctly set

Installation method

Community Docker image

Nextcloud Server version

29

Operating system

Debian/Ubuntu

PHP engine version

None

Web server

None

Database engine version

MariaDB

Is this bug present after an update or on a fresh install?

Upgraded to a MAJOR version (ex. 28 to 29)

Are you using the Nextcloud Server Encryption module?

None

What user-backends are you using?

• Default user-backend (database)
• LDAP/ Active Directory
• SSO - SAML
• Other

Configuration report

No response

List of activated Apps

No response

Nextcloud Signing status

No response

Nextcloud Logs

No response

Additional info

No response

[provokateurin]

From looking at the code it selects all tables (or tables with rows) that do not have the right collation set. Afterwards it only performs the ROW_FORMAT = DYNAMIC on those affected tables and the changes the collation. This means if you run into this over and over something with changing the collation isn't working successfully. Once the collation was changed for a table, it should never do it again, like you expected.
Can you please share the logs (with loglevel=0 and debug=true) from when you run the upgrade command?

[nextcloud-command]

This issue has been automatically marked as stale because it has not had recent activity and seems to be missing some essential information. It will be closed if no further activity occurs. Thank you for your contributions.

[tgoeg]

Seeing the same here.

The occ upgrade or occ maintenance:repair step seem to try to change the row format to dynamic:

MariaDB [(none)]> show processlist;
+--------+------------------+-----------+----------------------+---------+------+----------------+-------------------------------------------------+----------+
| Id     | User             | Host      | db                   | Command | Time | State          | Info                                            | Progress |
+--------+------------------+-----------+----------------------+---------+------+----------------+-------------------------------------------------+----------+
| 618905 | nextcloud        | localhost | nextcloud            | Query   |   20 | altering table | ALTER TABLE `oc_filecache` ROW_FORMAT = DYNAMIC |    0.000 |

when it already is:

MariaDB [(none)]> SELECT * FROM information_schema.INNODB_SYS_TABLES WHERE name='nextcloud/oc_filecache';
+----------+------------------------+------+--------+--------+------------+---------------+------------+
| TABLE_ID | NAME                   | FLAG | N_COLS | SPACE  | ROW_FORMAT | ZIP_PAGE_SIZE | SPACE_TYPE |
+----------+------------------------+------+--------+--------+------------+---------------+------------+
|   134593 | nextcloud/oc_filecache |   33 |     19 | 134520 | Dynamic    |             0 | Single     |
+----------+------------------------+------+--------+--------+------------+---------------+------------+

also,

MariaDB [(none)]> select @@innodb_default_row_format;
+-----------------------------+
| @@innodb_default_row_format |
+-----------------------------+
| dynamic                     |
+-----------------------------+

However (the table is just an example, it is like that with all the others as well):

MariaDB [(none)]> SELECT collation_name FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME LIKE 'oc_filecache';
+----------------+
| collation_name |
+----------------+
| NULL           |
| NULL           |
| utf8mb3_bin    |
| utf8mb3_bin    |
| NULL           |
| utf8mb3_bin    |
| NULL           |
| NULL           |
| NULL           |
| NULL           |
| NULL           |
| NULL           |
| NULL           |
| utf8mb3_bin    |
| NULL           |
| utf8mb3_bin    |
+----------------+

This could be the culprit, maybe it tries to convert to utf8mb4?

My server supports it, I guess?

MariaDB [(none)]> select @@collation_server; select @@character_set_server;
+--------------------+
| @@collation_server |
+--------------------+
| utf8mb4_general_ci |
+--------------------+

+------------------------+
| @@character_set_server |
+------------------------+
| utf8mb4                |
+------------------------+

MariaDB logs don't show any errors.

Nextcloud debug logs (don't look error-free but I don't see anything relevant?) with 'loglevel' => 0 and 'debug' => true set in config.php:

{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:02+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"The loading of lazy AppConfig values have been requested","userAgent":"--","version":"30.0.1.2","exception":{"Exception":"RuntimeException","Message":"ignorable exception","Code":0,"Trace":[{"file":"/var/www/nextcloud.mydomain.at/lib/private/AppConfig.php","line":1180,"function":"loadConfig","class":"OC\\AppConfig","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/AppConfig.php","line":100,"function":"loadConfigAll","class":"OC\\AppConfig","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/AllConfig.php","line":169,"function":"getKeys","class":"OC\\AppConfig","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/apps/user_ldap/lib/Helper.php","line":111,"function":"getAppKeys","class":"OC\\AllConfig","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/apps/user_ldap/lib/Helper.php","line":52,"function":"getServersConfig","class":"OCA\\User_LDAP\\Helper","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/apps/user_ldap/lib/AppInfo/Application.php","line":114,"function":"getServerConfigurationPrefixes","class":"OCA\\User_LDAP\\Helper","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/AppFramework/Bootstrap/FunctionInjector.php","line":49,"function":"OCA\\User_LDAP\\AppInfo\\{closure}","class":"OCA\\User_LDAP\\AppInfo\\Application","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud.mydomain.at/lib/private/AppFramework/Bootstrap/BootContext.php","line":32,"function":"injectFn","class":"OC\\AppFramework\\Bootstrap\\FunctionInjector","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/apps/user_ldap/lib/AppInfo/Application.php","line":128,"function":"injectFn","class":"OC\\AppFramework\\Bootstrap\\BootContext","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/AppFramework/Bootstrap/Coordinator.php","line":157,"function":"boot","class":"OCA\\User_LDAP\\AppInfo\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/App/AppManager.php","line":434,"function":"bootApp","class":"OC\\AppFramework\\Bootstrap\\Coordinator","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/App/AppManager.php","line":211,"function":"loadApp","class":"OC\\App\\AppManager","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Console/Application.php","line":84,"function":"loadApps","class":"OC\\App\\AppManager","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/console.php","line":81,"function":"loadCommands","class":"OC\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/occ","line":11,"args":["/var/www/nextcloud.mydomain.at/console.php"],"function":"require_once"}],"File":"/var/www/nextcloud.mydomain.at/lib/private/AppConfig.php","Line":1194,"message":"The loading of lazy AppConfig values have been requested","exception":{},"CustomMessage":"The loading of lazy AppConfig values have been requested"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:11+00:00","remoteAddr":"","user":"--","app":"user_ldap","method":"","url":"--","message":"Calling LDAP function ldap_explode_dn with parameters [\"***REDACTED SENSITIVE VALUE***\",0]","userAgent":"--","version":"30.0.1.2","data":{"app":"user_ldap"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:11+00:00","remoteAddr":"","user":"--","app":"user_ldap","method":"","url":"--","message":"Calling LDAP function ldap_explode_dn with parameters [\"***REDACTED SENSITIVE VALUE***\",0]","userAgent":"--","version":"30.0.1.2","data":{"app":"user_ldap"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:11+00:00","remoteAddr":"","user":"--","app":"user_ldap","method":"","url":"--","message":"Calling LDAP function ldap_explode_dn with parameters [\"***REDACTED SENSITIVE VALUE***\",0]","userAgent":"--","version":"30.0.1.2","data":{"app":"user_ldap"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:11+00:00","remoteAddr":"","user":"--","app":"user_ldap","method":"","url":"--","message":"Calling LDAP function ldap_explode_dn with parameters [\"***REDACTED SENSITIVE VALUE***\",0]","userAgent":"--","version":"30.0.1.2","data":{"app":"user_ldap"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:11+00:00","remoteAddr":"","user":"--","app":"user_ldap","method":"","url":"--","message":"Calling LDAP function ldap_explode_dn with parameters [\"***REDACTED SENSITIVE VALUE***\",0]","userAgent":"--","version":"30.0.1.2","data":{"app":"user_ldap"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:11+00:00","remoteAddr":"","user":"--","app":"user_ldap","method":"","url":"--","message":"Calling LDAP function ldap_explode_dn with parameters [\"***REDACTED SENSITIVE VALUE***\",0]","userAgent":"--","version":"30.0.1.2","data":{"app":"user_ldap"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:11+00:00","remoteAddr":"","user":"--","app":"user_ldap","method":"","url":"--","message":"Calling LDAP function ldap_explode_dn with parameters [\"***REDACTED SENSITIVE VALUE***\",0]","userAgent":"--","version":"30.0.1.2","data":{"app":"user_ldap"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:11+00:00","remoteAddr":"","user":"--","app":"user_ldap","method":"","url":"--","message":"Calling LDAP function ldap_explode_dn with parameters [\"***REDACTED SENSITIVE VALUE***\",0]","userAgent":"--","version":"30.0.1.2","data":{"app":"user_ldap"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:11+00:00","remoteAddr":"","user":"--","app":"user_ldap","method":"","url":"--","message":"Calling LDAP function ldap_explode_dn with parameters [\"***REDACTED SENSITIVE VALUE***\",0]","userAgent":"--","version":"30.0.1.2","data":{"app":"user_ldap"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:11+00:00","remoteAddr":"","user":"--","app":"user_ldap","method":"","url":"--","message":"Calling LDAP function ldap_explode_dn with parameters [\"***REDACTED SENSITIVE VALUE***\",0]","userAgent":"--","version":"30.0.1.2","data":{"app":"user_ldap"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:11+00:00","remoteAddr":"","user":"--","app":"user_ldap","method":"","url":"--","message":"Calling LDAP function ldap_explode_dn with parameters [\"***REDACTED SENSITIVE VALUE***\",0]","userAgent":"--","version":"30.0.1.2","data":{"app":"user_ldap"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:11+00:00","remoteAddr":"","user":"--","app":"user_ldap","method":"","url":"--","message":"Calling LDAP function ldap_explode_dn with parameters [\"***REDACTED SENSITIVE VALUE***\",0]","userAgent":"--","version":"30.0.1.2","data":{"app":"user_ldap"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:12+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","userAgent":"--","version":"30.0.1.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","Code":0,"Trace":[{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/QueryBuilder/QueryBuilder.php","line":292,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/BackgroundJob/JobList.php","line":127,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/BackgroundJob/JobList.php","line":47,"function":"has","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair/NC14/AddPreviewBackgroundCleanupJob.php","line":29,"function":"add","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair.php","line":100,"function":"run","class":"OC\\Repair\\NC14\\AddPreviewBackgroundCleanupJob","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/core/Command/Maintenance/Repair.php","line":99,"function":"run","class":"OC\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Command/Command.php","line":298,"function":"execute","class":"OC\\Core\\Command\\Maintenance\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":1040,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":301,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":171,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Console/Application.php","line":183,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/occ","line":11,"args":["/var/www/nextcloud.mydomain.at/console.php"],"function":"require_once"}],"File":"/var/www/nextcloud.mydomain.at/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","tables":["oc_oauth2_access_tokens","oc_oauth2_clients","oc_jobs"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:12+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","userAgent":"--","version":"30.0.1.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","Code":0,"Trace":[{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/QueryBuilder/QueryBuilder.php","line":292,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/BackgroundJob/JobList.php","line":127,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/BackgroundJob/JobList.php","line":47,"function":"has","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair/AddCleanupUpdaterBackupsJob.php","line":26,"function":"add","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair.php","line":100,"function":"run","class":"OC\\Repair\\AddCleanupUpdaterBackupsJob","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/core/Command/Maintenance/Repair.php","line":99,"function":"run","class":"OC\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Command/Command.php","line":298,"function":"execute","class":"OC\\Core\\Command\\Maintenance\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":1040,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":301,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":171,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Console/Application.php","line":183,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/occ","line":11,"args":["/var/www/nextcloud.mydomain.at/console.php"],"function":"require_once"}],"File":"/var/www/nextcloud.mydomain.at/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","tables":["oc_oauth2_access_tokens","oc_oauth2_clients","oc_jobs"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:12+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","userAgent":"--","version":"30.0.1.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","Code":0,"Trace":[{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/QueryBuilder/QueryBuilder.php","line":292,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/BackgroundJob/JobList.php","line":127,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/BackgroundJob/JobList.php","line":47,"function":"has","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair/NC16/AddClenupLoginFlowV2BackgroundJob.php","line":29,"function":"add","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair.php","line":100,"function":"run","class":"OC\\Repair\\NC16\\AddClenupLoginFlowV2BackgroundJob","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/core/Command/Maintenance/Repair.php","line":99,"function":"run","class":"OC\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Command/Command.php","line":298,"function":"execute","class":"OC\\Core\\Command\\Maintenance\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":1040,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":301,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":171,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Console/Application.php","line":183,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/occ","line":11,"args":["/var/www/nextcloud.mydomain.at/console.php"],"function":"require_once"}],"File":"/var/www/nextcloud.mydomain.at/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","tables":["oc_oauth2_access_tokens","oc_oauth2_clients","oc_jobs"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:12+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","userAgent":"--","version":"30.0.1.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","Code":0,"Trace":[{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/QueryBuilder/QueryBuilder.php","line":292,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/BackgroundJob/JobList.php","line":127,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/BackgroundJob/JobList.php","line":47,"function":"has","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair/AddBruteForceCleanupJob.php","line":29,"function":"add","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair.php","line":100,"function":"run","class":"OC\\Repair\\AddBruteForceCleanupJob","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/core/Command/Maintenance/Repair.php","line":99,"function":"run","class":"OC\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Command/Command.php","line":298,"function":"execute","class":"OC\\Core\\Command\\Maintenance\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":1040,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":301,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":171,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Console/Application.php","line":183,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/occ","line":11,"args":["/var/www/nextcloud.mydomain.at/console.php"],"function":"require_once"}],"File":"/var/www/nextcloud.mydomain.at/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","tables":["oc_oauth2_access_tokens","oc_oauth2_clients","oc_jobs"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:12+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","userAgent":"--","version":"30.0.1.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","Code":0,"Trace":[{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/QueryBuilder/QueryBuilder.php","line":292,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/BackgroundJob/JobList.php","line":127,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/BackgroundJob/JobList.php","line":47,"function":"has","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair/NC22/LookupServerSendCheck.php","line":31,"function":"add","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair.php","line":100,"function":"run","class":"OC\\Repair\\NC22\\LookupServerSendCheck","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/core/Command/Maintenance/Repair.php","line":99,"function":"run","class":"OC\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Command/Command.php","line":298,"function":"execute","class":"OC\\Core\\Command\\Maintenance\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":1040,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":301,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":171,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Console/Application.php","line":183,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/occ","line":11,"args":["/var/www/nextcloud.mydomain.at/console.php"],"function":"require_once"}],"File":"/var/www/nextcloud.mydomain.at/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","tables":["oc_oauth2_access_tokens","oc_oauth2_clients","oc_jobs"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:12+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","userAgent":"--","version":"30.0.1.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","Code":0,"Trace":[{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/QueryBuilder/QueryBuilder.php","line":292,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/BackgroundJob/JobList.php","line":127,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/BackgroundJob/JobList.php","line":47,"function":"has","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair/NC24/AddTokenCleanupJob.php","line":28,"function":"add","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair.php","line":100,"function":"run","class":"OC\\Repair\\NC24\\AddTokenCleanupJob","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/core/Command/Maintenance/Repair.php","line":99,"function":"run","class":"OC\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Command/Command.php","line":298,"function":"execute","class":"OC\\Core\\Command\\Maintenance\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":1040,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":301,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":171,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Console/Application.php","line":183,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/occ","line":11,"args":["/var/www/nextcloud.mydomain.at/console.php"],"function":"require_once"}],"File":"/var/www/nextcloud.mydomain.at/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","tables":["oc_oauth2_access_tokens","oc_oauth2_clients","oc_jobs"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:12+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","userAgent":"--","version":"30.0.1.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","Code":0,"Trace":[{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/QueryBuilder/QueryBuilder.php","line":292,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/BackgroundJob/JobList.php","line":127,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/BackgroundJob/JobList.php","line":47,"function":"has","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair/AddRemoveOldTasksBackgroundJob.php","line":30,"function":"add","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair.php","line":100,"function":"run","class":"OC\\Repair\\AddRemoveOldTasksBackgroundJob","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/core/Command/Maintenance/Repair.php","line":99,"function":"run","class":"OC\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Command/Command.php","line":298,"function":"execute","class":"OC\\Core\\Command\\Maintenance\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":1040,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":301,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":171,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Console/Application.php","line":183,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/occ","line":11,"args":["/var/www/nextcloud.mydomain.at/console.php"],"function":"require_once"}],"File":"/var/www/nextcloud.mydomain.at/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","tables":["oc_oauth2_access_tokens","oc_oauth2_clients","oc_jobs","oc_appconfig"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:12+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","userAgent":"--","version":"30.0.1.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","Code":0,"Trace":[{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/QueryBuilder/QueryBuilder.php","line":292,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/BackgroundJob/JobList.php","line":127,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/BackgroundJob/JobList.php","line":47,"function":"has","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair/AddRemoveOldTasksBackgroundJob.php","line":31,"function":"add","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair.php","line":100,"function":"run","class":"OC\\Repair\\AddRemoveOldTasksBackgroundJob","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/core/Command/Maintenance/Repair.php","line":99,"function":"run","class":"OC\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Command/Command.php","line":298,"function":"execute","class":"OC\\Core\\Command\\Maintenance\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":1040,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":301,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":171,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Console/Application.php","line":183,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/occ","line":11,"args":["/var/www/nextcloud.mydomain.at/console.php"],"function":"require_once"}],"File":"/var/www/nextcloud.mydomain.at/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","tables":["oc_oauth2_access_tokens","oc_oauth2_clients","oc_jobs","oc_appconfig"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:12+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","userAgent":"--","version":"30.0.1.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","Code":0,"Trace":[{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/QueryBuilder/QueryBuilder.php","line":292,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/BackgroundJob/JobList.php","line":127,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/BackgroundJob/JobList.php","line":47,"function":"has","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair/AddRemoveOldTasksBackgroundJob.php","line":32,"function":"add","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair.php","line":100,"function":"run","class":"OC\\Repair\\AddRemoveOldTasksBackgroundJob","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/core/Command/Maintenance/Repair.php","line":99,"function":"run","class":"OC\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Command/Command.php","line":298,"function":"execute","class":"OC\\Core\\Command\\Maintenance\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":1040,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":301,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":171,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Console/Application.php","line":183,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/occ","line":11,"args":["/var/www/nextcloud.mydomain.at/console.php"],"function":"require_once"}],"File":"/var/www/nextcloud.mydomain.at/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","tables":["oc_oauth2_access_tokens","oc_oauth2_clients","oc_jobs","oc_appconfig"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:12+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","userAgent":"--","version":"30.0.1.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","Code":0,"Trace":[{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/QueryBuilder/QueryBuilder.php","line":292,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/BackgroundJob/JobList.php","line":127,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/BackgroundJob/JobList.php","line":47,"function":"has","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair/AddMetadataGenerationJob.php","line":24,"function":"add","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair.php","line":100,"function":"run","class":"OC\\Repair\\AddMetadataGenerationJob","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/core/Command/Maintenance/Repair.php","line":99,"function":"run","class":"OC\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Command/Command.php","line":298,"function":"execute","class":"OC\\Core\\Command\\Maintenance\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":1040,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":301,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":171,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Console/Application.php","line":183,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/occ","line":11,"args":["/var/www/nextcloud.mydomain.at/console.php"],"function":"require_once"}],"File":"/var/www/nextcloud.mydomain.at/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","tables":["oc_oauth2_access_tokens","oc_oauth2_clients","oc_jobs","oc_appconfig"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:12+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"The loading of lazy AppConfig values have been requested","userAgent":"--","version":"30.0.1.2","exception":{"Exception":"RuntimeException","Message":"ignorable exception","Code":0,"Trace":[{"file":"/var/www/nextcloud.mydomain.at/lib/private/AppConfig.php","line":1180,"function":"loadConfig","class":"OC\\AppConfig","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/AppConfig.php","line":953,"function":"loadConfigAll","class":"OC\\AppConfig","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair/AddAppConfigLazyMigration.php","line":39,"function":"updateLazy","class":"OC\\AppConfig","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair.php","line":100,"function":"run","class":"OC\\Repair\\AddAppConfigLazyMigration","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/core/Command/Maintenance/Repair.php","line":99,"function":"run","class":"OC\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Command/Command.php","line":298,"function":"execute","class":"OC\\Core\\Command\\Maintenance\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":1040,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":301,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":171,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Console/Application.php","line":183,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/occ","line":11,"args":["/var/www/nextcloud.mydomain.at/console.php"],"function":"require_once"}],"File":"/var/www/nextcloud.mydomain.at/lib/private/AppConfig.php","Line":1194,"message":"The loading of lazy AppConfig values have been requested","exception":{},"CustomMessage":"The loading of lazy AppConfig values have been requested"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:12+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT `appid`, `configkey`, `configvalue`, `type`, `lazy` FROM `*PREFIX*appconfig`","userAgent":"--","version":"30.0.1.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `appid`, `configkey`, `configvalue`, `type`, `lazy` FROM `*PREFIX*appconfig`","Code":0,"Trace":[{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/QueryBuilder/QueryBuilder.php","line":292,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/AppConfig.php","line":1218,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/AppConfig.php","line":1180,"function":"loadConfig","class":"OC\\AppConfig","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/AppConfig.php","line":953,"function":"loadConfigAll","class":"OC\\AppConfig","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair/AddAppConfigLazyMigration.php","line":39,"function":"updateLazy","class":"OC\\AppConfig","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair.php","line":100,"function":"run","class":"OC\\Repair\\AddAppConfigLazyMigration","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/core/Command/Maintenance/Repair.php","line":99,"function":"run","class":"OC\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Command/Command.php","line":298,"function":"execute","class":"OC\\Core\\Command\\Maintenance\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":1040,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":301,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":171,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Console/Application.php","line":183,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/occ","line":11,"args":["/var/www/nextcloud.mydomain.at/console.php"],"function":"require_once"}],"File":"/var/www/nextcloud.mydomain.at/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT `appid`, `configkey`, `configvalue`, `type`, `lazy` FROM `*PREFIX*appconfig`","tables":["oc_oauth2_access_tokens","oc_oauth2_clients","oc_jobs","oc_appconfig"],"reads":["oc_appconfig"],"exception":{},"CustomMessage":"dirty table reads: SELECT `appid`, `configkey`, `configvalue`, `type`, `lazy` FROM `*PREFIX*appconfig`"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":1,"time":"2024-10-22T16:59:12+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"core/BackgroundJobs/AppConfigLazyMigration: 0 config values updated","userAgent":"--","version":"30.0.1.2","data":[]}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:12+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT `c`.`id` FROM `*PREFIX*calendarobjects` `c` LEFT JOIN `*PREFIX*calendars` `p` ON `c`.`calendarid` = `p`.`id` WHERE (`p`.`id` IS NULL) AND (`c`.`calendartype` = :dcValue1)","userAgent":"--","version":"30.0.1.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `c`.`id` FROM `*PREFIX*calendarobjects` `c` LEFT JOIN `*PREFIX*calendars` `p` ON `c`.`calendarid` = `p`.`id` WHERE (`p`.`id` IS NULL) AND (`c`.`calendartype` = :dcValue1)","Code":0,"Trace":[{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/QueryBuilder/QueryBuilder.php","line":292,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/QueryBuilder/QueryBuilder.php","line":266,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/apps/dav/lib/Migration/RemoveOrphanEventsAndContacts.php","line":70,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/apps/dav/lib/Migration/RemoveOrphanEventsAndContacts.php","line":37,"function":"removeOrphanChildren","class":"OCA\\DAV\\Migration\\RemoveOrphanEventsAndContacts","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair.php","line":100,"function":"run","class":"OCA\\DAV\\Migration\\RemoveOrphanEventsAndContacts","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/core/Command/Maintenance/Repair.php","line":99,"function":"run","class":"OC\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Command/Command.php","line":298,"function":"execute","class":"OC\\Core\\Command\\Maintenance\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":1040,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":301,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":171,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Console/Application.php","line":183,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/occ","line":11,"args":["/var/www/nextcloud.mydomain.at/console.php"],"function":"require_once"}],"File":"/var/www/nextcloud.mydomain.at/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT `c`.`id` FROM `*PREFIX*calendarobjects` `c` LEFT JOIN `*PREFIX*calendars` `p` ON `c`.`calendarid` = `p`.`id` WHERE (`p`.`id` IS NULL) AND (`c`.`calendartype` = :dcValue1)","tables":["oc_oauth2_access_tokens","oc_oauth2_clients","oc_jobs","oc_appconfig","oc_calendars"],"reads":["oc_calendarobjects","oc_calendars"],"exception":{},"CustomMessage":"dirty table reads: SELECT `c`.`id` FROM `*PREFIX*calendarobjects` `c` LEFT JOIN `*PREFIX*calendars` `p` ON `c`.`calendarid` = `p`.`id` WHERE (`p`.`id` IS NULL) AND (`c`.`calendartype` = :dcValue1)"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:12+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT `c`.`id` FROM `*PREFIX*calendarchanges` `c` LEFT JOIN `*PREFIX*calendars` `p` ON `c`.`calendarid` = `p`.`id` WHERE (`p`.`id` IS NULL) AND (`c`.`calendartype` = :dcValue1)","userAgent":"--","version":"30.0.1.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `c`.`id` FROM `*PREFIX*calendarchanges` `c` LEFT JOIN `*PREFIX*calendars` `p` ON `c`.`calendarid` = `p`.`id` WHERE (`p`.`id` IS NULL) AND (`c`.`calendartype` = :dcValue1)","Code":0,"Trace":[{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/QueryBuilder/QueryBuilder.php","line":292,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/QueryBuilder/QueryBuilder.php","line":266,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/apps/dav/lib/Migration/RemoveOrphanEventsAndContacts.php","line":70,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/apps/dav/lib/Migration/RemoveOrphanEventsAndContacts.php","line":41,"function":"removeOrphanChildren","class":"OCA\\DAV\\Migration\\RemoveOrphanEventsAndContacts","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair.php","line":100,"function":"run","class":"OCA\\DAV\\Migration\\RemoveOrphanEventsAndContacts","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/core/Command/Maintenance/Repair.php","line":99,"function":"run","class":"OC\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Command/Command.php","line":298,"function":"execute","class":"OC\\Core\\Command\\Maintenance\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":1040,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":301,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":171,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Console/Application.php","line":183,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/occ","line":11,"args":["/var/www/nextcloud.mydomain.at/console.php"],"function":"require_once"}],"File":"/var/www/nextcloud.mydomain.at/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT `c`.`id` FROM `*PREFIX*calendarchanges` `c` LEFT JOIN `*PREFIX*calendars` `p` ON `c`.`calendarid` = `p`.`id` WHERE (`p`.`id` IS NULL) AND (`c`.`calendartype` = :dcValue1)","tables":["oc_oauth2_access_tokens","oc_oauth2_clients","oc_jobs","oc_appconfig","oc_calendars"],"reads":["oc_calendarchanges","oc_calendars"],"exception":{},"CustomMessage":"dirty table reads: SELECT `c`.`id` FROM `*PREFIX*calendarchanges` `c` LEFT JOIN `*PREFIX*calendars` `p` ON `c`.`calendarid` = `p`.`id` WHERE (`p`.`id` IS NULL) AND (`c`.`calendartype` = :dcValue1)"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:12+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT `c`.`principaluri`, `o`.`calendarid`, `o`.`uid` FROM `*PREFIX*calendarobjects` `o` LEFT JOIN `*PREFIX*calendars` `c` ON `c`.`id` = `o`.`calendarid` WHERE `o`.`classification` = :dcValue1","userAgent":"--","version":"30.0.1.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `c`.`principaluri`, `o`.`calendarid`, `o`.`uid` FROM `*PREFIX*calendarobjects` `o` LEFT JOIN `*PREFIX*calendars` `c` ON `c`.`id` = `o`.`calendarid` WHERE `o`.`classification` = :dcValue1","Code":0,"Trace":[{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/QueryBuilder/QueryBuilder.php","line":292,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/QueryBuilder/QueryBuilder.php","line":266,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/apps/dav/lib/Migration/RemoveClassifiedEventActivity.php","line":61,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/apps/dav/lib/Migration/RemoveClassifiedEventActivity.php","line":40,"function":"removePrivateEventActivity","class":"OCA\\DAV\\Migration\\RemoveClassifiedEventActivity","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair.php","line":100,"function":"run","class":"OCA\\DAV\\Migration\\RemoveClassifiedEventActivity","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/core/Command/Maintenance/Repair.php","line":99,"function":"run","class":"OC\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Command/Command.php","line":298,"function":"execute","class":"OC\\Core\\Command\\Maintenance\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":1040,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":301,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":171,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Console/Application.php","line":183,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/occ","line":11,"args":["/var/www/nextcloud.mydomain.at/console.php"],"function":"require_once"}],"File":"/var/www/nextcloud.mydomain.at/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT `c`.`principaluri`, `o`.`calendarid`, `o`.`uid` FROM `*PREFIX*calendarobjects` `o` LEFT JOIN `*PREFIX*calendars` `c` ON `c`.`id` = `o`.`calendarid` WHERE `o`.`classification` = :dcValue1","tables":["oc_oauth2_access_tokens","oc_oauth2_clients","oc_jobs","oc_appconfig","oc_calendars"],"reads":["oc_calendarobjects","oc_calendars"],"exception":{},"CustomMessage":"dirty table reads: SELECT `c`.`principaluri`, `o`.`calendarid`, `o`.`uid` FROM `*PREFIX*calendarobjects` `o` LEFT JOIN `*PREFIX*calendars` `c` ON `c`.`id` = `o`.`calendarid` WHERE `o`.`classification` = :dcValue1"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:12+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT `c`.`principaluri`, `o`.`calendarid`, `o`.`uid` FROM `*PREFIX*calendarobjects` `o` LEFT JOIN `*PREFIX*calendars` `c` ON `c`.`id` = `o`.`calendarid` WHERE `o`.`classification` = :dcValue1","userAgent":"--","version":"30.0.1.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `c`.`principaluri`, `o`.`calendarid`, `o`.`uid` FROM `*PREFIX*calendarobjects` `o` LEFT JOIN `*PREFIX*calendars` `c` ON `c`.`id` = `o`.`calendarid` WHERE `o`.`classification` = :dcValue1","Code":0,"Trace":[{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/QueryBuilder/QueryBuilder.php","line":292,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/QueryBuilder/QueryBuilder.php","line":266,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/apps/dav/lib/Migration/RemoveClassifiedEventActivity.php","line":95,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/apps/dav/lib/Migration/RemoveClassifiedEventActivity.php","line":41,"function":"removeConfidentialUncensoredEventActivity","class":"OCA\\DAV\\Migration\\RemoveClassifiedEventActivity","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair.php","line":100,"function":"run","class":"OCA\\DAV\\Migration\\RemoveClassifiedEventActivity","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/core/Command/Maintenance/Repair.php","line":99,"function":"run","class":"OC\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Command/Command.php","line":298,"function":"execute","class":"OC\\Core\\Command\\Maintenance\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":1040,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":301,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":171,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Console/Application.php","line":183,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/occ","line":11,"args":["/var/www/nextcloud.mydomain.at/console.php"],"function":"require_once"}],"File":"/var/www/nextcloud.mydomain.at/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT `c`.`principaluri`, `o`.`calendarid`, `o`.`uid` FROM `*PREFIX*calendarobjects` `o` LEFT JOIN `*PREFIX*calendars` `c` ON `c`.`id` = `o`.`calendarid` WHERE `o`.`classification` = :dcValue1","tables":["oc_oauth2_access_tokens","oc_oauth2_clients","oc_jobs","oc_appconfig","oc_calendars"],"reads":["oc_calendarobjects","oc_calendars"],"exception":{},"CustomMessage":"dirty table reads: SELECT `c`.`principaluri`, `o`.`calendarid`, `o`.`uid` FROM `*PREFIX*calendarobjects` `o` LEFT JOIN `*PREFIX*calendars` `c` ON `c`.`id` = `o`.`calendarid` WHERE `o`.`classification` = :dcValue1"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:12+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*oauth2_access_tokens`","userAgent":"--","version":"30.0.1.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT * FROM `*PREFIX*oauth2_access_tokens`","Code":0,"Trace":[{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/QueryBuilder/QueryBuilder.php","line":292,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/QueryBuilder/QueryBuilder.php","line":266,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/apps/oauth2/lib/Migration/SetTokenExpiration.php","line":47,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair.php","line":100,"function":"run","class":"OCA\\OAuth2\\Migration\\SetTokenExpiration","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/core/Command/Maintenance/Repair.php","line":99,"function":"run","class":"OC\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Command/Command.php","line":298,"function":"execute","class":"OC\\Core\\Command\\Maintenance\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":1040,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":301,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":171,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Console/Application.php","line":183,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/occ","line":11,"args":["/var/www/nextcloud.mydomain.at/console.php"],"function":"require_once"}],"File":"/var/www/nextcloud.mydomain.at/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT * FROM `*PREFIX*oauth2_access_tokens`","tables":["oc_oauth2_access_tokens","oc_oauth2_clients","oc_jobs","oc_appconfig","oc_calendars","oc_properties"],"reads":["oc_oauth2_access_tokens"],"exception":{},"CustomMessage":"dirty table reads: SELECT * FROM `*PREFIX*oauth2_access_tokens`"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:12+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","userAgent":"--","version":"30.0.1.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","Code":0,"Trace":[{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/QueryBuilder/QueryBuilder.php","line":292,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/BackgroundJob/JobList.php","line":127,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/apps/survey_client/lib/Migration/SendAdminNotification.php","line":31,"function":"has","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair.php","line":100,"function":"run","class":"OCA\\Survey_Client\\Migration\\SendAdminNotification","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/core/Command/Maintenance/Repair.php","line":99,"function":"run","class":"OC\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Command/Command.php","line":298,"function":"execute","class":"OC\\Core\\Command\\Maintenance\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":1040,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":301,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":171,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Console/Application.php","line":183,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/occ","line":11,"args":["/var/www/nextcloud.mydomain.at/console.php"],"function":"require_once"}],"File":"/var/www/nextcloud.mydomain.at/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","tables":["oc_oauth2_access_tokens","oc_oauth2_clients","oc_jobs","oc_appconfig","oc_calendars","oc_properties"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:12+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","userAgent":"--","version":"30.0.1.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","Code":0,"Trace":[{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/QueryBuilder/QueryBuilder.php","line":292,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/BackgroundJob/JobList.php","line":127,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/BackgroundJob/JobList.php","line":47,"function":"has","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/apps/survey_client/lib/Migration/SendAdminNotification.php","line":32,"function":"add","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair.php","line":100,"function":"run","class":"OCA\\Survey_Client\\Migration\\SendAdminNotification","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/core/Command/Maintenance/Repair.php","line":99,"function":"run","class":"OC\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Command/Command.php","line":298,"function":"execute","class":"OC\\Core\\Command\\Maintenance\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":1040,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":301,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":171,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Console/Application.php","line":183,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/occ","line":11,"args":["/var/www/nextcloud.mydomain.at/console.php"],"function":"require_once"}],"File":"/var/www/nextcloud.mydomain.at/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","tables":["oc_oauth2_access_tokens","oc_oauth2_clients","oc_jobs","oc_appconfig","oc_calendars","oc_properties"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:12+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","userAgent":"--","version":"30.0.1.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","Code":0,"Trace":[{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/QueryBuilder/QueryBuilder.php","line":292,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/BackgroundJob/JobList.php","line":127,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/BackgroundJob/JobList.php","line":47,"function":"has","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/apps/theming/lib/Migration/InitBackgroundImagesMigration.php","line":29,"function":"add","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair.php","line":100,"function":"run","class":"OCA\\Theming\\Migration\\InitBackgroundImagesMigration","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/core/Command/Maintenance/Repair.php","line":99,"function":"run","class":"OC\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Command/Command.php","line":298,"function":"execute","class":"OC\\Core\\Command\\Maintenance\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":1040,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":301,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":171,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Console/Application.php","line":183,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/occ","line":11,"args":["/var/www/nextcloud.mydomain.at/console.php"],"function":"require_once"}],"File":"/var/www/nextcloud.mydomain.at/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","tables":["oc_oauth2_access_tokens","oc_oauth2_clients","oc_jobs","oc_appconfig","oc_calendars","oc_properties"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1"}}
{"reqId":"JhvFDc8wuvtqpOzh4ojN","level":0,"time":"2024-10-22T16:59:12+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","userAgent":"--","version":"30.0.1.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","Code":0,"Trace":[{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/DB/QueryBuilder/QueryBuilder.php","line":292,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/BackgroundJob/JobList.php","line":127,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/BackgroundJob/JobList.php","line":47,"function":"has","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/apps/twofactor_backupcodes/lib/Migration/CheckBackupCodes.php","line":29,"function":"add","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Repair.php","line":100,"function":"run","class":"OCA\\TwoFactorBackupCodes\\Migration\\CheckBackupCodes","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/core/Command/Maintenance/Repair.php","line":99,"function":"run","class":"OC\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Command/Command.php","line":298,"function":"execute","class":"OC\\Core\\Command\\Maintenance\\Repair","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":1040,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":301,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/3rdparty/symfony/console/Application.php","line":171,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/lib/private/Console/Application.php","line":183,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud.mydomain.at/occ","line":11,"args":["/var/www/nextcloud.mydomain.at/console.php"],"function":"require_once"}],"File":"/var/www/nextcloud.mydomain.at/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","tables":["oc_oauth2_access_tokens","oc_oauth2_clients","oc_jobs","oc_appconfig","oc_calendars","oc_properties"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1"}}

Can you point me to the exact SQL queries that should be performed so I can try and debug them directly?
Thanks in advance!

[tgoeg]

Alright, I think I fixed this.

The problem is that utf8mb3 collations on MariaDB are not (unconditionally) utf8 but utf8mb3 (or at least they should be, and we'll enforce that).

This is quite elaborate.

For mySQL, I couldn't find any documentation mentioning utf8 as a valid collation (but I may be wrong).
For mariaDB, I do not consider anything older than 10.6, which is a system requirement for NC30 (https://docs.nextcloud.com/server/30/admin_manual/installation/system_requirements.html).
mariaDB has an OLD_MODE which supports utf8 to mean utf8mb3 when UTF8_IS_UTF8MB3 is set. So yes, there could be installations where the collation in the information schema returns utf8.

I do have mariaDB 10.6 and OLD_MODE and UTF8_IS_UTF8MB3 set (not that I did so intentionally, this just stems from upgrades). Still, all my tables have a utf8mb3 collation, so I am not sure whether the above ("real" utf8) will ever be case.

It does not matter, however.

I'll add the sketch for a function further down that tries to explicitly handle this OLD_MODE but I am pretty convinced that this is unnecessary. Instead, we should just

• check whether we have mb3 variants and
• unconditionally upgrade to utf8mb3 as even setups in OLD_MODE with UTF8_IS_UTF8MB3 set do support this (and all current mySQL and mariaDB versions support this)

Therefore, I changed to the following (the , false is default anyway and irritating as one might think it gets checked for being false, that's why I removed it while at it):

--- ./lib/private/Repair/Collation.php.bak	2024-10-23 07:45:19.284506542 +0000
+++ ./lib/private/Repair/Collation.php	2024-10-23 08:42:03.495159990 +0000
@@ -54,7 +54,7 @@
 		                return;
 	        }

-	        $characterSet = $this->config->getSystemValueBool('mysql.utf8mb4', false) ? 'utf8mb4' : 'utf8';
+	        $characterSet = $this->config->getSystemValueBool('mysql.utf8mb4') ? 'utf8mb4' : 'utf8mb3';

 	        $tables = $this->getAllNonUTF8BinTables($this->connection);
 	        foreach ($tables as $table) {
@@ -93,7 +93,7 @@
 	 */
 	protected function getAllNonUTF8BinTables(IDBConnection $connection) {
 	        $dbName = $this->config->getSystemValueString("dbname");
-	        $characterSet = $this->config->getSystemValueBool('mysql.utf8mb4', false) ? 'utf8mb4' : 'utf8';
+	        $characterSet = $this->config->getSystemValueBool('mysql.utf8mb4') ? 'utf8mb4' : 'utf8mb3';

 	        // fetch tables by columns
 	        $statement = $connection->executeQuery(

I am just a sysadmin, no real dev, so I couldn't fix the (previously existing) double lines getting the config value. This should be optimized as well.

This solves it for me but it might need further tests or a real dev's pair of eyes.
I can send a PR if need be.

I don't understand the rationale behind unconditionally changing the row format to dynamic. I'd suggest to only do this if necessary, as well. It takes a few seconds for every one of my (small test setup) tables, so I don't consider this a good solution.

If I am wrong and this might be needed, here is a sketch for handling OLD_MODE explicitly.
However, the SQL queries would have to be adapted to check for either variation when UTF8_IS_UTF8MB3 is set.
The run() function would need adaption as well.

protected function getAllNonUTF8BinTables(IDBConnection $connection) {
    $dbName = $this->config->getSystemValueString("dbname");
    // determine the character set
    if ($this->config->getSystemValueBool('mysql.utf8mb4')) {
        $characterSet = 'utf8mb4';
    } else {
        // Check if UTF8_IS_UTF8MB3 mode is set in OLD_MODE
        // TODO: https://mariadb.com/kb/en/old-mode/ mentions that, starting from MariaDB 11.3, the query may be different.
        //       Tests with a MariaDB 11.3 setup in OLD_MODE and UTF8_IS_UTF8MB3 necessary!
        //
        //       MariaDB >= 10.6 (which is a system requirement for Nextcloud as of 30.x)
        //       understands utf8mb3 even when running in OLD_MODE and UTF8_IS_UTF8MB3
        //       It is just that utf8 MAY be a set location
        //       So, check for utf8 OR utf8mb3 in this scenario and upgrade to utf8mb3 unconditionally
        $oldModeStatement = $connection->executeQuery("SELECT @@old_mode");
        $oldMode = $oldModeStatement->fetchColumn();
        $Utf8IsUtf8mb3 = strpos($oldMode, 'UTF8_IS_UTF8MB3') !== false;
        if ($Utf8IsUtf8mb3) {
            $characterSet = 'utf8'; // This is not correct. It MAY be like this, but it does not have to be.
                                    // Therefore, I stopped checking for OLD_MODE altogether, as we can
                                    // just unconditionally upgrade to utf8mb3 regardless whether we have
                                    // utf8 with or without OLD_MODE as MariaDB >=10.6 definitely supports utf8mb3 even in OLD_MODE
        } else {
            $characterSet = 'utf8mb3';
        }
    }
    // fetch tables by columns
    $statement = $connection->executeQuery(
        "SELECT DISTINCT(TABLE_NAME) AS `table`" .
        "   FROM INFORMATION_SCHEMA . COLUMNS" .
        "   WHERE TABLE_SCHEMA = ?" .
        "   AND (COLLATION_NAME <> '" . $characterSet . "_bin' OR CHARACTER_SET_NAME <> '" . $characterSet . "')" .
        "   AND TABLE_NAME LIKE '*PREFIX*%'",
        [$dbName]
    );
    $rows = $statement->fetchAll();
    $result = [];
    foreach ($rows as $row) {
        $result[$row['table']] = true;
    }
    // fetch tables by collation
    $statement = $connection->executeQuery(
        "SELECT DISTINCT(TABLE_NAME) AS `table`" .
        "   FROM INFORMATION_SCHEMA . TABLES" .
        "   WHERE TABLE_SCHEMA = ?" .
        "   AND TABLE_COLLATION <> '" . $characterSet . "_bin'" .
        "   AND TABLE_NAME LIKE '*PREFIX*%'",
        [$dbName]
    );
    $rows = $statement->fetchAll();
    foreach ($rows as $row) {
        $result[$row['table']] = true;
    }
    return array_keys($result);
}

[provokateurin]

IIRC @Altahrim you did something with mysql and row formats, could you take a look?