Oc_filecache table goes into "Waiting for table metadata lock" state when searching for users

ℹ️ Support
, ,
1

Hi,
We have a Nextcloud 28.0.11.1 instance running on:

  • Ubuntu 22.04 LTS
  • MariaDB: Ver 15.1 Distrib 10.6.18-MariaDB
  • Apache/2.4.52
    We are testing this system, it is not yet in production. We migrated it from an owncloud setup and we are testing it before putting it into production. Everything seems to be working but each time we do a search for users, the system starts to hang, MariaDB CPU usage goes up to 300% and we have some queries with the “Waiting for table metadata lock” state. All of these queries are related to the oc_filecache table (which is 26GB). The queries are similar to this:

INSERT INTO oc_filecache (mimepart, mimetype, mtime, size, etag, storage_mtime, permissions, name, parent, checksum, path_hash, path, storage) VALUES(‘5’, ‘16’, ‘1731517772’, ‘1340’, ‘7aaaee11b6194fd054cd4c920ecfc06b’, ‘1731517772’, ‘27’, ‘avatar-dark.64.png’, ‘26273761’, ‘’, ‘312578521c7e9fa02216c699ebdb89bd’, ‘appdata_oc00zt3t7bwy/avatar/Maxime_Allard/avatar-dark.64.png’, ‘135107’)

I have already checked for indexes on oc_filecache and running also occ files:cleanup. Same thing.
Any ideas will be appreciated.

Thx in advance!

2

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.