Nextcloud version (eg, 10.0.2): 12.0.0
Operating system and version (eg, Ubuntu 16.04): Ubuntu 16.04.2 LTS
Apache or nginx version (eg, Apache 2.4.25): Apache/2.4.18 (Ubuntu)
PHP version (eg, 5.6): 7.0
Is this the first time you’ve seen this error?: No
Can you reliably replicate it? (If so, please outline steps):
SELECT * FROM oc_file_locks
The issue you are facing:
How many (aprox) entries should oc_file_locks maintain (given a number of existing files and users) and what does the ‘lock’ field (numeric) mean?
I have about 760000 files, and locks use to reach and overpass that amount in matter of hours (after cleaning, because we’re having some problems when syncing locked files)
The output of your Nextcloud log in Admin > Logging:
No matter here for now. I don’t know what I’m looking for yet.
The output of your config.php file in /path/to/nextcloud
(make sure you remove any identifiable information!):
<?php
$CONFIG = array (
'instanceid' => 'ocd51dc248e3',
'passwordsalt' => '*****************************************',
'trusted_domains' =>
array (
0 => 'owncloud.*******.**',
1 => '**********.******.**',
),
'datadirectory' => '/mnt/ocdata',
'dbtype' => 'mysql',
'version' => '12.0.0.29',
'dbname' => 'cloud',
'dbhost' => 'localhost',
'dbtableprefix' => 'oc_',
'dbuser' => 'cloud',
'dbpassword' => '***********',
'installed' => true,
'theme' => '',
'mail_smtpmode' => 'smtp',
'mail_smtphost' => '*****.*****.**',
'mail_smtpport' => '465',
'mail_smtpsecure' => 'ssl',
'mail_smtpauth' => 1,
'mail_smtpname' => 'owncloud',
'mail_smtppassword' => '***********',
'maintenance' => false,
'mail_from_address' => '************',
'mail_domain' => '*******.**',
'loglevel' => 2,
'secret' => '*****************************************',
'trashbin_retention_obligation' => '90',
'mail_smtpauthtype' => 'LOGIN',
'preview_libreoffice_path' => '/usr/bin/soffice',
'appstore.experimental.enabled' => true,
'ldapIgnoreNamingRules' => false,
'singleuser' => false,
'overwrite.cli.url' => 'http://*******************.**********.**',
'memcache.local' => '\\OC\\Memcache\\APCu',
);
The output of your Apache/nginx/system log in `/var/log/____`:
_No matter here, for now._
---
Remember, this information may be requested if it isn't supplied; for fastest response please provide as much as you can :heart: Feel free to use a pastebin service, otherwise log files can be indented with 4 spaces on each line to present them in a friendlier way on the forum.