Nextcloud version 16 / 17 / 18
Operating system and version CentOS 8 (16Gb Ram, 2x CPU)
Apache from the official repo (2.4x)
PHP version 7.3 from remi repo (7.4. also tested, same issue)
The issue you are facing:
Is this the first time you’ve seen this error? : yes, changed from owncloud to nextcloud but did not see it on owncloud before…
The Problem is:
- Using a search inputs will rise the load of the database deamon to 100% and more…
- When more inputs (start with Thom, Thoma, Thomas… etc) are given the load will rise up to 15+ (in top command)
- It will take several minutes until the load will come down to normal again…
This issue is reproduceable in Nextcloud 16 / 17 / 18 with our LDAP (Active Directory, 20.000 active Users in serveral OUs) and MariaDB as local database.
- In Owncloud there was a occ command to sync ldap users to local database to improve performance (sudo -u apache ./occ user:sync “OCA\User_LDAP\User_Proxy” -m disable).
In Nextcloud this command is not available anymore…
Owncloud 10.3.2. does not have this issue
Steps to replicate it:
- Install either Nextcloud 16 / 17 / 18
- Install user_ldap app (Active Directory with about 20000 Users)
- Running mariadb as database (local on nextcloudserver)
- all caching mechanism activated…
The output of your Nextcloud log in Admin > Logging:
https://grelli.eu/share/ldap-nextcloud.txt
The output of your config.php file in /path/to/nextcloud
(make sure you remove any identifiable information!):
$CONFIG = array (
'instanceid' => 'oc2e7ps1rkhh',
'passwordsalt' => 'XXX',
'secret' => 'XXXX',
'trusted_domains' =>
array (
0 => 'nxtcld.XXX',
),
'datadirectory' => '/mnt/dfs/data',
'dbtype' => 'mysql',
'version' => '18.0.1.3',
'overwrite.cli.url' => 'http://nxtcld.XXXX.XX/nextcloud',
'dbname' => 'cloud',
'dbhost' => 'localhost',
'dbport' => '',
'dbtableprefix' => 'oc_',
'mysql.utf8mb4' => true,
'dbuser' => 'XXXX',
'dbpassword' => 'XXXX',
'dbdriveroptions' =>
array (
1002 => 'SET wait_timeout = 300',
),
'installed' => true,
'ldapIgnoreNamingRules' => false,
'ldaZVoviderFactory' => 'OCA\\User_LDAP\\LDAZVoviderFactory',
'lost_password_link' => 'disabled',
'has_internet_connection' => true,
'check_for_working_wellknown_setup' => false,
'proxy' => 'XXX.XXX.XXX.XXX:XXXX',
'updater.release.channel' => 'stable',
'memcache.local' => '\\OC\\Memcache\\APCu',
'maintenance' => false,
'skeletondirectory' => '/mnt/dfs/data/skeleton',
'theme' => '',
'updater.secret' => 'XXXX',
'sharing.minSearchStringLength' => 3,
'login_form_autocomplete' => false,
'loglevel' => 2,
'log_type' => 'file',
'logfile' => '/mnt/dfs/data/nextcloud.log',
'default_language' => 'de',
'allow_user_to_change_display_name' => false,
'session_lifetime' => 86400,
'remember_login_cookie_lifetime' => 86400,
'filelocking.enabled' => 'true',
'memcache.locking' => '\\OC\\Memcache\\Redis',
'redis' =>
array (
'host' => '/var/run/redis/redis.sock',
'port' => 0,
'timeout' => 0.0,
),
'memcache.distributed' => '\\OC\\Memcache\\Memcached',
'memcached_servers' =>
array (
0 =>
array (
0 => 'localhost',
1 => 11211,
),
),
'enable_avatars'=>false,
);
The output of your Apache/nginx/system log in /var/log/httpd/ssl_error.log
:
[Wed Feb 19 05:33:06.345273 2020] [proxy_fcgi:error] [pid 12708:tid 139821267785472] (70007)The timeout specified has expired: [client 10.24.22.202:60966] AH01075: Error dispatching request to : (polling)
[Wed Feb 19 05:47:25.839977 2020] [proxy_fcgi:error] [pid 12709:tid 139821653620480] (70007)The timeout specified has expired: [client 10.24.22.202:61110] AH01075: Error dispatching request to : (polling)