Although my installation is different from that of yours, I do agree with you that running the command files:scan --all in occ inflates the size of the database even when the number of files within my installation remains the same. Due to the issues that I have faced, I have so far determined that running the said occ command floods the database table occ_files_locks with entries and unleashes a flurry of PHP errors.
It would be great if the very knowledgeable people on the forum shares their experiences so that we could isolate the potential causes of your posted issue. Here are the details of my installation:
Background:
The Nextcloud package is installed, using an archive file, on a shared hosting server with some folders connected to external storage.
Nextcloud version: 18.0.4, 18.0.6 => 18.0.7
Operating system and version: Ubuntu 18.04
Apache or nginx version: Apache 2.4.29
PHP version: 7.4.3
The issue you are facing: refer to the first paragraph of my post in this topic.
The output of your Nextcloud log in Admin > Logging :
PASTE HERE
Is this the first time you’ve seen this error? N
The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):
<?php
$CONFIG = array (
'instanceid' => 'ocnssr8i2s5s',
'passwordsalt' => 'unsalted',
'secret' => 'notso',
'trusted_domains' =>
array (
0 => 'domain.tld',
),
'datadirectory' => '/home/ssh-user/domain.tld/nextcloud/data',
'dbtype' => 'mysql',
'version' => '18.0.7.1',
'overwrite.cli.url' => 'https://domain.tld/nextcloud',
'dbname' => 'honeysuckle_squirt',
'dbhost' => 'mysql.server.sticky-hosting.com',
'dbport' => '',
'dbtableprefix' => 'oc_',
'mysql.utf8mb4' => true,
'dbuser' => 'meee',
'dbpassword' => 'pass12345',
'installed' => true,
'maintenance' => false,
);
The output of your Apache/nginx/system log in /var/log/____ :
PASTE HERE