Very slow outlogging and errors in the Logs

ℹ️ Support
1

Hi, since a few days, I am seeing the problem, that logging off is very slow, it takes something around 60 Seconds.
In addition I am seeing hundrets of errors in the Logs of Nextcloud.

Support intro

Nextcloud version: 17.0.0
Operating system and version : Ubuntu 19.10
Apache or nginx version : Apache 2.4.41
PHP version : 7.3

The issue you are facing:
In the logs are hundrets of the following entry, logging out is very slow, more precise ~ 60 Seconds.

Is this the first time you’ve seen this error? : Yes

Steps to replicate it:

  1. Log on to Nextcloud
  2. Log out of the Nextcloud

The output of your Nextcloud log in Admin > Logging:

[core] Error: OCP\AppFramework\Db\DoesNotExistException: Did expect one result but found none when executing: query "SELECT id, title, owner, color, archived, deleted_at, last_modified FROM `*PREFIX*deck_boards` WHERE `id` = ?"; parameters Array
(
    [0] => 
)
; limit ""; offset "" at <<closure>>

0. /var/www/nextcloud/lib/public/AppFramework/Db/Mapper.php line 372
   OCP\AppFramework\Db\Mapper->findOneQuery("SELECT id, titl ... ?", [null], null, null)
1. /var/www/nextcloud/apps/deck/lib/Db/BoardMapper.php line 73
   OCP\AppFramework\Db\Mapper->findEntity("SELECT id, titl ... ?", [null])
2. /var/www/nextcloud/apps/deck/lib/Notification/NotificationHelper.php line 170
   OCA\Deck\Db\BoardMapper->find(null)
3. /var/www/nextcloud/apps/deck/lib/Notification/NotificationHelper.php line 81
   OCA\Deck\Notification\NotificationHelper->getBoard(null)
4. /var/www/nextcloud/apps/deck/lib/Cron/ScheduledNotifications.php line 55
   OCA\Deck\Notification\NotificationHelper->sendCardDuedate(OCA\Deck\Db\Card {id: 5})
5. /var/www/nextcloud/lib/private/BackgroundJob/Job.php line 61
   OCA\Deck\Cron\ScheduledNotifications->run(null)
6. /var/www/nextcloud/cron.php line 124
   OC\BackgroundJob\Job->execute(OC\BackgroundJob\JobList {}, OC\Log {})

at 2019-10-26T18:05:04+00:00

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

<?php $CONFIG = array 
( 'passwordsalt' => '********', 
'secret' => '********', 
'trusted_domains' => array 
( 0 => '*********', ), 
'datadirectory' => '*************', 
'dbtype' => 'mysql', 
'version' => '17.0.0.9', 
'overwrite.cli.url' => 'http://nextcloudhost',
 'dbname' => 'nextcloud',
 'dbhost' => 'localhost', 'dbport' => '',
 'dbtableprefix' => 'oc_', 
'dbuser' => '*******', 
'dbpassword' => '********', 
'installed' => true, 
'htaccess.RewriteBase' => '/',
 'instanceid' => '*******', 
'memcache.local' => '\\OC\\Memcache\\APCu',
 'maintenance' => false, 'theme' => '',
 'loglevel' => 2, 
'memcache.distributed' => '\\OC\\Memcache\\Redis', 
'redis' => array ( 
'host' => '/var/run/redis/redis.sock', 
'port' => 0, 
'timeout' => 0, 
'password' => '************************************* ), 
'memcache.locking' => '\\OC\\Memcache\\Redis',
 'updater.release.channel' => 'stable',
 'twofactor_enforced' => 'true', 
'twofactor_enforced_groups' => array ( ),
 ), 'twofactor_enforced_excluded_groups' => array ( 0 => '***********', ),
 'trusted_proxies' => array ( 0 => '********', ),
 'data-fingerprint' => '************', );

The output of your Apache/nginx/system log in /var/log/____:

Nothing, no errors logged.