Git'Fellow

FYI this caused a regression affecting master and all versions (v26, v25): https://github.com/nextcloud/server/issues/38157

Situation remains the same on v27. ``` # Time: 231020 17:28:38 # User@Host: nextcloud[nextcloud] @ localhost [] # Thread_id: 825958 Schema: nextcloud QC_hit: No # Query_time: 86.054387 Lock_time: 0.000064 Rows_sent:...

@juliushaertl 1100 users. ``` SELECT COUNT(*) FROM oc_filecache; +----------+ | COUNT(*) | +----------+ | 3560945 | +----------+ ```

Does your DB set fit the buffer pool? In my case it doesn't. Also, query cache is OFF. So this can be a server size/tuning problem, not code related.

MySQLTuner script can print it (last line here). https://github.com/major/MySQLTuner-perl ``` -------- Recommendations --------------------------------------------------------------------------- General recommendations: Run ALTER TABLE ... FORCE or OPTIMIZE TABLE to defragment tables for better performance ALTER...

@Hiyoal mind to make a PR to review? Thanks.

Let me add 2 stack traces here if it helps. @PVince81 in both cases, these seem to be uploads, and in both, `$file` is null. ``` { "reqId": "7wajzDcxJ6mT7A0evgD3", "level":...

This is not a "all time" reproductible bug. I can observe this is produced when users uploads many (+200 files), no matter the client. I've applied the patch, I'll report...

@come-nc After applying above patch, I've seen an error I've never seen before, is it related? EDIT: it seem not related: https://github.com/nextcloud/server/issues/30626 ``` { "reqId": "M5e0U2kx3xYuqItjLr0s", "level": 3, "time": "2022-12-01T17:10:27+01:00",...

@come-nc same here after applying patch. ``` { "reqId": "2haKvYjpTfr6x4gBdgi5", "level": 3, "time": "2022-12-06T17:42:54+01:00", "app": "no app in context", "method": "PUT", "url": "/remote.php/dav/uploads/username/7e7988e2035558ee4452844e6dd363e9/0000000000000000-0000000001938191", "message": "Triggering post hook on null path,...