High disk usage after upgrading to Nextcloud 29.0.4

Support intro

Sorry to hear you’re facing problems :slightly_frowning_face:

help.nextcloud.com is for home/non-enterprise users. If you’re running a business, paid support can be accessed via portal.nextcloud.com where we can ensure your business keeps running smoothly.

In order to help you as quickly as possible, before clicking Create Topic please provide as much of the below as you can. Feel free to use a pastebin service for logs, otherwise either indent short log examples with four spaces:

example

Or for longer, use three backticks above and below the code snippet:

longer
example
here

Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can :heart:

Nextcloud version (eg, 29.0.5): 29.0.4
Operating system and version (eg, Ubuntu 24.04): FreeBSD 13.1-RELEASE-p9
Apache or nginx version (eg, Apache 2.4.25): Caddy v2.8.4
PHP version (eg, 8.3): 8.3.6

The issue you are facing:
A few days ago, I updated from Nextcloud 29.0.3 to 29.0.4. My Nextcloud instance is running inside a jail on TrueNAS Core (13.0-U6.2) and was installed using this script: https://github.com/danb35/freenas-iocage-nextcloud
The next day after the update, I noticed that my server got really loud because it is constantly reading or writng something to disk. When I restart the jail, the disk activity instantly stops, so I know it must be Nextcloud causing this.
So far, I was able to find out that something in mariadb is running whenever I notice the high disk activity. By running “SHOW FULL PROCESSLIST;”, I found out that the following query is taking very long to execute (~20 minutes or even longer):

SELECT `a`.`name`
FROM `oc_filecache` `a`
LEFT JOIN `oc_filecache` `b`
ON `a`.`name` = `b`.`fileid`
WHERE (`a`.`storage` = '2')
AND (`b`.`fileid` IS NULL)
AND (`a`.`path` LIKE 'appdata\\_oc8jw7se3j9i/preview/_/_/_/_/_/_/_/%')
AND (`a`.`mimetype` = '2')

Is this the first time you’ve seen this error? (Y/N): Y

Steps to replicate it:
None, it just happens automatically multiple times per day.

The output of your Nextcloud log in Admin > Logging:

Warning	no app in context	
DeadlockException An exception occurred while executing a query: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction
Error while updating parent storage_mtime, should be safe to ignore
"Aug 14, 2024, 12:33:54 AM"	
Error	cron	
Exception Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory
"Aug 10, 2024, 2:52:41 PM"	
Error	core	
ConnectionLost An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Error while running background job OC\Preview\BackgroundCleanupJob (id: 33, arguments: null)
"Aug 10, 2024, 2:52:41 PM"	
Error	cron	
Exception Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory
"Aug 10, 2024, 12:56:43 AM"	
Error	core	
ConnectionLost An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Error while running background job OC\Preview\BackgroundCleanupJob (id: 33, arguments: null)
"Aug 10, 2024, 12:56:43 AM"	
Error	cron	
Exception Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory
"Aug 9, 2024, 12:41:32 PM"	
Error	core	
ConnectionLost An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Error while running background job OC\Preview\BackgroundCleanupJob (id: 33, arguments: null)
"Aug 9, 2024, 12:41:32 PM"	
Error	cron	
Exception Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory
"Aug 9, 2024, 12:36:31 AM"	
Error	core	
ConnectionLost An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Error while running background job OC\Preview\BackgroundCleanupJob (id: 33, arguments: null)
"Aug 9, 2024, 12:36:31 AM"	
Error	index	
NotFoundException Exception thrown: OCP\Files\NotFoundException
Exception thrown: OCP\Files\NotFoundException
"Aug 8, 2024, 9:51:47 AM"

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

<?php
$CONFIG = array (
  'passwordsalt' => <censored>,
  'secret' => <censored>,
  'trusted_domains' =>
  array (
    0 => 'localhost',
    1 => <censored>,
    2 => <censored>,
  ),
  'trusted_proxies' =>
  array (
    0 => <censored>,
  ),
  'datadirectory' => '/mnt/files',
  'dbtype' => 'mysql',
  'version' => '29.0.4.1',
  'overwrite.cli.url' => <censored>,
  'dbname' => 'nextcloud',
  'dbhost' => 'localhost:/var/run/mysql/mysql.sock',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'nextcloud',
  'dbpassword' => <censored>,
  'installed' => true,
  'instanceid' => <censored>,
  'logtimezone' => 'Europe/Berlin',
  'default_phone_region' => 'DE',
  'log_type' => 'file',
  'logfile' => '/var/log/nextcloud/nextcloud.log',
  'loglevel' => 1,
  'logrotate_size' => '104847600',
  'memcache.local' => '\\OC\\Memcache\\APCu',
  'redis' =>
  array (
    'host' => '/var/run/redis/redis.sock',
    'port' => 0,
  ),
  'memcache.distributed' => '\\OC\\Memcache\\Redis',
  'memcache.locking' => '\\OC\\Memcache\\Redis',
  'overwritehost' => <censored>,
  'overwriteprotocol' => 'https',
  'htaccess.RewriteBase' => '/',
  'maintenance' => false,
  'theme' => '',
  'maintenance_window_start' => 2,
);

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

Shouldn't be necessary here since this is a database issue, or is it?

Output errors in nextcloud.log in /var/www/ or as admin user in top right menu, filtering for errors. Use a pastebin service if necessary.

Fatal	cron	
Background job OC\Core\BackgroundJobs\GenerateMetadataJob (id: 21521, arguments: null) ran for 43009 seconds
"Aug 7, 2024, 8:37:00 AM"	
Fatal	cron	
Background job OC\Core\BackgroundJobs\GenerateMetadataJob (id: 21521, arguments: null) ran for 43009 seconds
"Aug 7, 2024, 8:37:00 AM"	
Error	cron	
Exception Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory
"Aug 10, 2024, 2:52:41 PM"	
Error	core	
ConnectionLost An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Error while running background job OC\Preview\BackgroundCleanupJob (id: 33, arguments: null)
"Aug 10, 2024, 2:52:41 PM"	
Error	cron	
Exception Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory
"Aug 10, 2024, 2:52:41 PM"	
Error	core	
ConnectionLost An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Error while running background job OC\Preview\BackgroundCleanupJob (id: 33, arguments: null)
"Aug 10, 2024, 2:52:41 PM"	
Error	cron	
Exception Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory
"Aug 10, 2024, 12:56:43 AM"	
Error	core	
ConnectionLost An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Error while running background job OC\Preview\BackgroundCleanupJob (id: 33, arguments: null)
"Aug 10, 2024, 12:56:43 AM"	
Error	cron	
Exception Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory
"Aug 10, 2024, 12:56:43 AM"	
Error	core	
ConnectionLost An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Error while running background job OC\Preview\BackgroundCleanupJob (id: 33, arguments: null)
"Aug 10, 2024, 12:56:43 AM"	
Error	cron	
Exception Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory
"Aug 9, 2024, 12:41:32 PM"	
Error	core	
ConnectionLost An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Error while running background job OC\Preview\BackgroundCleanupJob (id: 33, arguments: null)
"Aug 9, 2024, 12:41:32 PM"	
Error	cron	
Exception Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory
"Aug 9, 2024, 12:41:32 PM"	
Error	core	
ConnectionLost An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Error while running background job OC\Preview\BackgroundCleanupJob (id: 33, arguments: null)
"Aug 9, 2024, 12:41:32 PM"	
Error	cron	
Exception Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory
"Aug 9, 2024, 12:36:31 AM"	
Error	core	
ConnectionLost An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Error while running background job OC\Preview\BackgroundCleanupJob (id: 33, arguments: null)
"Aug 9, 2024, 12:36:31 AM"	
Error	cron	
Exception Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory
"Aug 9, 2024, 12:36:31 AM"	
Error	core	
ConnectionLost An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Error while running background job OC\Preview\BackgroundCleanupJob (id: 33, arguments: null)
"Aug 9, 2024, 12:36:31 AM"	
Error	index	
NotFoundException Exception thrown: OCP\Files\NotFoundException
Exception thrown: OCP\Files\NotFoundException
"Aug 8, 2024, 9:51:47 AM"	
Error	index	
NotFoundException Exception thrown: OCP\Files\NotFoundException
Exception thrown: OCP\Files\NotFoundException
"Aug 8, 2024, 9:51:47 AM"	
Error	cron	
Exception Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory
"Aug 8, 2024, 8:21:53 AM"	
Error	core	
ConnectionLost An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Error while running background job OC\Preview\BackgroundCleanupJob (id: 33, arguments: null)
"Aug 8, 2024, 8:21:53 AM"	
Error	cron	
Exception Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory
"Aug 8, 2024, 8:21:53 AM"	
Error	core	
ConnectionLost An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Error while running background job OC\Preview\BackgroundCleanupJob (id: 33, arguments: null)
"Aug 8, 2024, 8:21:53 AM"	
Error	cron	
Exception Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory
"Aug 7, 2024, 8:37:00 AM"	
Error	core	
ConnectionException An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory
Error while running background job OC\Core\BackgroundJobs\GenerateMetadataJob (id: 21521, arguments: null)
"Aug 7, 2024, 8:37:00 AM"	
Error	cron	
Exception Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory
"Aug 7, 2024, 8:37:00 AM"	
Error	core	
ConnectionLost An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Error while running background job OC\Preview\BackgroundCleanupJob (id: 33, arguments: null)
"Aug 7, 2024, 8:37:00 AM"	
Error	cron	
Exception Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory
"Aug 7, 2024, 8:37:00 AM"	
Error	core	
ConnectionException An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory
Error while running background job OC\Core\BackgroundJobs\GenerateMetadataJob (id: 21521, arguments: null)
"Aug 7, 2024, 8:37:00 AM"	
Error	cron	
Exception Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory
"Aug 7, 2024, 8:37:00 AM"	
Error	core	
ConnectionLost An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Error while running background job OC\Preview\BackgroundCleanupJob (id: 33, arguments: null)
"Aug 7, 2024, 8:37:00 AM"	
Error	PHP	
Undefined array key 1 at /usr/local/www/nextcloud/3rdparty/wapmorgan/mp3info/src/Mp3Info.php#1061
"Aug 7, 2024, 1:23:42 AM"	
Error	PHP	
Undefined array key 1 at /usr/local/www/nextcloud/3rdparty/wapmorgan/mp3info/src/Mp3Info.php#1061
"Aug 7, 2024, 1:23:42 AM"	
Error	PHP	
Undefined array key 1 at /usr/local/www/nextcloud/3rdparty/wapmorgan/mp3info/src/Mp3Info.php#1061
"Aug 7, 2024, 1:23:41 AM"	
Error	PHP	
Undefined array key 1 at /usr/local/www/nextcloud/3rdparty/wapmorgan/mp3info/src/Mp3Info.php#1061
"Aug 7, 2024, 1:23:41 AM"	
Error	PHP	
Undefined array key 1 at /usr/local/www/nextcloud/3rdparty/wapmorgan/mp3info/src/Mp3Info.php#1061
"Aug 7, 2024, 1:23:40 AM"	
Error	PHP	
Undefined array key 1 at /usr/local/www/nextcloud/3rdparty/wapmorgan/mp3info/src/Mp3Info.php#1061
"Aug 7, 2024, 1:23:40 AM"	
Error	PHP	
Undefined array key 1 at /usr/local/www/nextcloud/3rdparty/wapmorgan/mp3info/src/Mp3Info.php#1061
"Aug 7, 2024, 1:23:40 AM"	
Error	PHP	
Undefined array key 1 at /usr/local/www/nextcloud/3rdparty/wapmorgan/mp3info/src/Mp3Info.php#1061
"Aug 7, 2024, 1:23:40 AM"	
Error	PHP	
Undefined array key 1 at /usr/local/www/nextcloud/3rdparty/wapmorgan/mp3info/src/Mp3Info.php#1061
"Aug 7, 2024, 1:23:40 AM"	
Error	PHP	
Undefined array key 1 at /usr/local/www/nextcloud/3rdparty/wapmorgan/mp3info/src/Mp3Info.php#1061
"Aug 7, 2024, 1:23:40 AM"	
Error	PHP	
Undefined array key 1 at /usr/local/www/nextcloud/3rdparty/wapmorgan/mp3info/src/Mp3Info.php#1061
"Aug 7, 2024, 1:23:39 AM"	
Error	PHP	
Undefined array key 1 at /usr/local/www/nextcloud/3rdparty/wapmorgan/mp3info/src/Mp3Info.php#1061
"Aug 7, 2024, 1:23:39 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_SNxVvZ" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:34 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_SNxVvZ" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:34 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_xDaJRH" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:33 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_xDaJRH" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:33 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_j1YRZi" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:32 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_wskCll" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:32 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_LaoG8N" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:32 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_j1YRZi" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:32 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_wskCll" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:32 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_LaoG8N" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:32 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_eLOv0w" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:22 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_eLOv0w" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:22 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_QIziSj" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:21 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_QIziSj" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:21 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_ab6Mv4" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:20 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_nKB6fU" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:20 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_JYwXHB" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:20 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_ab6Mv4" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:20 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_nKB6fU" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:20 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_JYwXHB" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:20 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_4ejxlm" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:12 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_4ejxlm" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:12 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_mxTfVU" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:11 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_mxTfVU" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:11 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_gEqaKf" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:10 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_2rcWNR" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:10 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_aj7ygR" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:10 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_gEqaKf" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:10 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_2rcWNR" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:10 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_aj7ygR" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:10 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_SwmxR0" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:02 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_SwmxR0" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:02 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_6Udlcq" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:01 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_6Udlcq" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:01 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_wiQhub" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:00 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_yAZT28" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:00 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_nqVL2O" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:00 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_wiQhub" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:00 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_yAZT28" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:00 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_nqVL2O" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 7, 2024, 1:18:00 AM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_tGb7ZY" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 6, 2024, 9:00:04 PM"	
Error	PHP	
imagecreatefrombmp(): "/tmp/oc_tmp_tGb7ZY" is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Aug 6, 2024, 9:00:04 PM"	
Error	related_resources	
RelatedResourceProviderNotFound Exception thrown: OCA\RelatedResources\Exceptions\RelatedResourceProviderNotFound
Exception thrown: OCA\RelatedResources\Exceptions\RelatedResourceProviderNotFound
"Aug 5, 2024, 10:14:09 AM"	
Error	related_resources	
RelatedResourceProviderNotFound Exception thrown: OCA\RelatedResources\Exceptions\RelatedResourceProviderNotFound
Exception thrown: OCA\RelatedResources\Exceptions\RelatedResourceProviderNotFound
"Aug 5, 2024, 10:14:09 AM"	
Error	related_resources	
RelatedResourceProviderNotFound Exception thrown: OCA\RelatedResources\Exceptions\RelatedResourceProviderNotFound
Exception thrown: OCA\RelatedResources\Exceptions\RelatedResourceProviderNotFound
"Aug 5, 2024, 10:14:09 AM"	
Error	related_resources	
RelatedResourceProviderNotFound Exception thrown: OCA\RelatedResources\Exceptions\RelatedResourceProviderNotFound
Exception thrown: OCA\RelatedResources\Exceptions\RelatedResourceProviderNotFound
"Aug 5, 2024, 10:14:09 AM"	
Error	webdav	
DbalException An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '347905-1661878862' for key 'files_versions_uniq_index'
"Jul 21, 2024, 10:17:04 AM"	
Error	webdav	
DbalException An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '347905-1661878862' for key 'files_versions_uniq_index'
"Jul 21, 2024, 10:17:04 AM"	
Error	PHP	
imagecreatefrombmp(): &quot;/tmp/oc_tmp_vWTtJm&quot; is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Jul 13, 2024, 10:14:49 AM"	
Error	PHP	
imagecreatefrombmp(): &quot;/tmp/oc_tmp_vWTtJm&quot; is not a valid BMP file at /usr/local/www/nextcloud/lib/private/legacy/OC_Image.php#744
"Jul 13, 2024, 10:14:49 AM"	
Error	no app in context	
Exception HMAC does not match.
Could not decrypt or decode encrypted session data
"Jul 13, 2024, 1:52:45 AM"	
Error	no app in context	
Exception HMAC does not match.
Could not decrypt or decode encrypted session data
"Jul 13, 2024, 1:52:45 AM"	
Error	no app in context	
Exception HMAC does not match.
Could not decrypt or decode encrypted session data
"Jul 13, 2024, 1:52:41 AM"	
Error	no app in context	
Exception HMAC does not match.
Could not decrypt or decode encrypted session data
"Jul 13, 2024, 1:52:41 AM"	
Error	no app in context	
Exception HMAC does not match.
Could not decrypt or decode encrypted session data
"Jul 13, 2024, 1:52:32 AM"	
Error	no app in context	
Exception HMAC does not match.
Could not decrypt or decode encrypted session data
"Jul 13, 2024, 1:52:32 AM"	
Error	no app in context	
Exception HMAC does not match.
Could not decrypt or decode encrypted session data
"Jul 13, 2024, 1:52:32 AM"	
Error	no app in context	
Exception HMAC does not match.
Could not decrypt or decode encrypted session data
"Jul 13, 2024, 1:52:32 AM"	
Error	no app in context	
Exception HMAC does not match.
Could not decrypt or decode encrypted session data
"Jul 13, 2024, 1:52:32 AM"	
Error	no app in context	
Exception HMAC does not match.
Could not decrypt or decode encrypted session data
"Jul 13, 2024, 1:52:32 AM"	
Error	no app in context	
SyntaxErrorException An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) AND (`sh`.`parent` IS NULL)' at line 1
Exception thrown: Doctrine\DBAL\Exception\SyntaxErrorException
"Jul 12, 2024, 7:44:06 PM"	
Error	no app in context	
SyntaxErrorException An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) AND (`sh`.`parent` IS NULL)' at line 1
Exception thrown: Doctrine\DBAL\Exception\SyntaxErrorException
"Jul 12, 2024, 7:44:06 PM"	
Error	no app in context	
DbalException An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '<censored>' for key 'user_status_uid_ix'
"Jul 7, 2024, 10:23:14 AM"	
Error	no app in context	
DbalException An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '<censored>' for key 'user_status_uid_ix'
"Jul 7, 2024, 10:23:14 AM"	

@ccman32 welcome…

see issue

being a snap user, but recognising the symptoms you’ve mentioned, that sounds very much like this issue with the ‘Preview generator app’.

1 Like

Thanks for the suggestion! I actually do not use the ‘Preview generator app’ or at least I’m not aware of it, but this does indeed sound like a similar issue. What would you suggest doing? Can I just delete the preview folder, or is there anything else I should do in advance?

@ccman32, no problem, glad I could help…

your logs:

mentioned the culprit.

this makes me wonder… so I’m going to be careful recommending anything :face_with_hand_over_mouth:

keep an eye on that reference issue and preferably wait for a supporters opinion :thinking:

Since I won’t be at home for one week, I’ve decided to shutdown my Nextcloud in the meanwhile. I am now starting to get warning logs about the background cleanup job taking longer and longer and I do not feel comfortable leaving the system running like this.

Any other suggestions what I can try here? I’ve already tried to manually execute the SQL query I mentioned earlier and it returned more than 165000 results. Is this normal, or should it return less entries under normal circumstances?