### ⚠️ This issue respects the following points: ⚠️
- [x] This is a **bug**, no…t a question or a configuration/webserver/proxy issue.
- [x] This issue is **not** already reported on [Github](https://github.com/nextcloud/server/issues?q=is%3Aopen+is%3Aissue+label%3Abug) OR [Nextcloud Community Forum](https://help.nextcloud.com/) _(I've searched it)_.
- [x] Nextcloud Server **is** up to date. See [Maintenance and Release Schedule](https://github.com/nextcloud/server/wiki/Maintenance-and-Release-Schedule) for supported versions.
- [x] I agree to follow Nextcloud's [Code of Conduct](https://nextcloud.com/contribute/code-of-conduct/).
### Bug description
When doing an update (e.g. here from 30.0.6 to 30.0.7) the messages about `dirty table reads` below are showing up in the `nextcloud.log`.
As discussed here these are no errors:
- #49088
- https://help.nextcloud.com/t/dirty-table-reads-excessive-logging-reproducible/194809
and are only shown if the Loglevel is set to `0`.
The problems here are:
1. the updater is setting the Loglevel to `0` / this value automatically during an update (see next log)
2. this is causing a flood of the logs (`grep "dirty table reads" nextcloud.log | wc -l` showed `40` entries just happening during an update), especially as these messages seems to be quite big / long
3. this prevents the focus on the actual important info happening during an update
4. users might get confused by such messages including e.g. `dirty` during updates
```
{
"reqId": "***",
"level": 1,
"time": "***",
"remoteAddr": "",
"user": "--",
"app": "updater",
"method": "",
"url": "--",
"message": "\\OC\\Updater::resetLogLevel: Reset log level to Warning(2)",
"userAgent": "--",
"version": "30.0.7.2",
"data": {
"app": "updater"
}
}
```
### Steps to reproduce
1. Have 30.0.6 installed
2. Update to 30.0.7 manually (`sudo -u www-data php occ upgrade`)
3. Check `data/nextcloud.log`
### Expected behavior
No `dirty table reads` messages in the log file during an update (updater could "hide" these kind of messages during an update by default) so that one can focus on the relevant info on the update (e.g. done repair steps etc.).
### Nextcloud Server version
30
### Operating system
Debian/Ubuntu
### PHP engine version
PHP 8.2
### Web server
Nginx
### Database engine version
MariaDB
### Is this bug present after an update or on a fresh install?
Updated from a MINOR version (ex. 32.0.1 to 32.0.2)
### Are you using the Nextcloud Server Encryption module?
Encryption is Disabled
### What user-backends are you using?
- [x] Default user-backend _(database)_
- [ ] LDAP/ Active Directory
- [ ] SSO - SAML
- [ ] Other
### Configuration report
Only relevant entry from `config.php`:
```php
'loglevel' => 2,
```
### List of activated Apps
```shell
```
### Nextcloud Signing status
```shell
```
### Nextcloud Logs
```json
{
"reqId": "***",
"level": 0,
"time": "***",
"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.6.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": "/***/lib/private/DB/ConnectionAdapter.php",
"line": 50,
"function": "executeQuery",
"class": "OC\\DB\\Connection",
"type": "->"
},
{
"file": "/***/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 289,
"function": "executeQuery",
"class": "OC\\DB\\ConnectionAdapter",
"type": "->"
},
{
"file": "/***/lib/private/BackgroundJob/JobList.php",
"line": 127,
"function": "executeQuery",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->"
},
{
"file": "/***/lib/private/BackgroundJob/JobList.php",
"line": 47,
"function": "has",
"class": "OC\\BackgroundJob\\JobList",
"type": "->"
},
{
"file": "/***/lib/private/Setup.php",
"line": 415,
"function": "add",
"class": "OC\\BackgroundJob\\JobList",
"type": "->"
},
{
"file": "/***/lib/private/Updater.php",
"line": 227,
"function": "installBackgroundJobs",
"class": "OC\\Setup",
"type": "::"
},
{
"file": "/***/lib/private/Updater.php",
"line": 98,
"function": "doUpgrade",
"class": "OC\\Updater",
"type": "->"
},
{
"file": "/***/core/Command/Upgrade.php",
"line": 190,
"function": "upgrade",
"class": "OC\\Updater",
"type": "->"
},
{
"file": "/***/3rdparty/symfony/console/Command/Command.php",
"line": 326,
"function": "execute",
"class": "OC\\Core\\Command\\Upgrade",
"type": "->"
},
{
"file": "/***/3rdparty/symfony/console/Application.php",
"line": 1078,
"function": "run",
"class": "Symfony\\Component\\Console\\Command\\Command",
"type": "->"
},
{
"file": "/***/3rdparty/symfony/console/Application.php",
"line": 324,
"function": "doRunCommand",
"class": "Symfony\\Component\\Console\\Application",
"type": "->"
},
{
"file": "/***/3rdparty/symfony/console/Application.php",
"line": 175,
"function": "doRun",
"class": "Symfony\\Component\\Console\\Application",
"type": "->"
},
{
"file": "/***/lib/private/Console/Application.php",
"line": 183,
"function": "run",
"class": "Symfony\\Component\\Console\\Application",
"type": "->"
},
{
"file": "/***/console.php",
"line": 87,
"function": "run",
"class": "OC\\Console\\Application",
"type": "->"
},
{
"file": "/***/occ",
"line": 33,
"args": [
"/***/console.php"
],
"function": "require_once"
}
],
"File": "/***/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_jobs"
],
"reads": [
"oc_jobs"
],
"exception": {},
"CustomMessage": "dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1"
}
}
```
### Additional info
_No response_