External storage folder not listing any files

Nextcloud version: 29.0.3
Operating system and version: Debian 12 Bookworm
Apache or nginx version: 2.4.59-1~deb12u1
PHP version: 8.2 FPM

The issue you are facing:

On certain folders on a SMB Share mounted with external storage in Nextcloud there’s no files listed. The page gets loaded, the file list seems to be requested (the circle is shown) but after a minute or so it tells me “No files in here” even though there are some. If I manually type in the path of a subfolder then most of them work just fine and on some others no files are shown.
I can see a PHP Process working for a longer time using some CPU time which makes me believe that there’s still a filelist getting compiled but not actually shown in the Page because it times out first.

I have this problem on one external storage containing many pictures. Testet another share on the same server with the same user and that one works fine.

Also I want to note that when I do a files:scan --all they actually get scanned. I’m also currently running preview generation since there’s many pictures in there and those get run through just fine.

The output of your Nextcloud log in Admin > Logging:

nextcloud-log
Warning	cron	
Used memory grew by more than 10 MB when executing job OCA\UpdateNotification\BackgroundJob\UpdateAvailableNotifications (id: 1, arguments: null): 32.6 MB (before: 22.7 MB)

"Jul 17, 2024, 12:55:30 AM"	

Error	webdav	
LockWaitTimeoutException
An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction

"Jul 16, 2024, 1:57:12 PM"	

Error	webdav	
LockWaitTimeoutException
An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction

"Jul 16, 2024, 1:57:12 PM"	

Error	webdav	
LockWaitTimeoutException
An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction

"Jul 16, 2024, 1:56:22 PM"	

Error	webdav	
LockWaitTimeoutException
An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction

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

nextcloud-config.php
<?php
$CONFIG = array (
  'instanceid' => '...',
  'passwordsalt' => '...',
  'secret' => '...',
  'trusted_domains' => 
  array (
    0 => 'cloud...',
  ),
  'datadirectory' => '/var/www/html/data',
  'dbtype' => 'mysql',
  'version' => '29.0.3.4',
  'overwrite.cli.url' => 'https://cloud...',
  'dbname' => 'nextcloud',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'nextcloud',
  'dbpassword' => '...',
  'installed' => true,
  'memcache.local' => '\\OC\\Memcache\\Redis',
  'memcache.locking' => '\\OC\\Memcache\\Redis',
  'filelocking.enabled' => true,
  'redis' => 
  array (
    'host' => '/var/run/redis/redis-server.sock',
    'port' => 0,
    'password' => '...',
  ),
  'defaultapp' => 'files',
  'default_phone_region' => 'IT',
  'maintenance_window_start' => 1,
  'mail_from_address' => 'cloud',
  'mail_smtpmode' => 'smtp',
  'mail_sendmailmode' => 'smtp',
  'mail_domain' => '...',
  'mail_smtphost' => '...',
  'mail_smtpport' => '25',
  'ldapProviderFactory' => 'OCA\\User_LDAP\\LDAPProviderFactory',
);

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

apache-error.log

Notes: LogLevel atm is info, I think most of these connections are actually the preview generation, client has a different IP than the x.x.x.240

[Wed Jul 17 11:29:39.297894 2024] [ssl:info] [pid 131877:tid 140485846865600] [client x.x.x.240:39322] AH01964: Connection to child 8 established (server cloud...:443)
[Wed Jul 17 11:29:42.612448 2024] [ssl:info] [pid 131877:tid 140485855258304] [client x.x.x.240:39334] AH01964: Connection to child 7 established (server cloud...:443)
[Wed Jul 17 11:29:55.880395 2024] [ssl:info] [pid 131877:tid 140485679109824] [client x.x.x.240:50678] AH01964: Connection to child 11 established (server cloud...:443)
[Wed Jul 17 11:29:59.330620 2024] [reqtimeout:info] [pid 131877:tid 140485846865600] [client x.x.x.240:39322] AH01382: Request header read timeout
[Wed Jul 17 11:30:07.598353 2024] [ssl:info] [pid 131877:tid 140485880436416] [client x.x.x.240:37304] AH01964: Connection to child 4 established (server cloud...:443)
[Wed Jul 17 11:30:17.705756 2024] [ssl:info] [pid 131877:tid 140485662324416] [client x.x.x.240:50626] AH01964: Connection to child 13 established (server cloud...:443)
[Wed Jul 17 11:30:27.808450 2024] [ssl:info] [pid 131877:tid 140484949305024] [client x.x.x.240:60886] AH01964: Connection to child 20 established (server cloud...:443)
[Wed Jul 17 11:30:37.902228 2024] [ssl:info] [pid 131877:tid 140484915734208] [client x.x.x.240:43822] AH01964: Connection to child 24 established (server cloud...:443)
[Wed Jul 17 11:30:39.212650 2024] [ssl:info] [pid 131877:tid 140485897221824] [client x.x.x.240:43824] AH01964: Connection to child 2 established (server cloud...:443)
[Wed Jul 17 11:30:39.216534 2024] [ssl:info] [pid 131877:tid 140485987387072] [client x.x.x.240:43830] AH01964: Connection to child 0 established (server cloud...:443)
[Wed Jul 17 11:30:39.218083 2024] [ssl:info] [pid 131877:tid 140485863651008] [client x.x.x.240:43836] AH01964: Connection to child 6 established (server cloud...:443)
[Wed Jul 17 11:30:39.219275 2024] [ssl:info] [pid 131877:tid 140484672476864] [client x.x.x.240:43852] AH01964: Connection to child 18 established (server cloud...:443)
[Wed Jul 17 11:30:39.304696 2024] [ssl:info] [pid 131877:tid 140485978994368] [client x.x.x.240:43866] AH01964: Connection to child 1 established (server cloud...:443)
[Wed Jul 17 11:30:48.014123 2024] [ssl:info] [pid 131876:tid 140485159024320] [client x.x.x.240:38832] AH01964: Connection to child 80 established (server cloud...:443)
[Wed Jul 17 11:30:58.128488 2024] [ssl:info] [pid 131876:tid 140485133846208] [client x.x.x.240:52124] AH01964: Connection to child 83 established (server cloud...:443)
[Wed Jul 17 11:31:08.258908 2024] [ssl:info] [pid 131877:tid 140485880436416] [client x.x.x.240:52326] AH01964: Connection to child 4 established (server cloud...:443)
[Wed Jul 17 11:31:18.359320 2024] [ssl:info] [pid 131877:tid 140485888829120] [client x.x.x.240:51668] AH01964: Connection to child 3 established (server cloud...:443)
[Wed Jul 17 11:31:28.463833 2024] [ssl:info] [pid 131877:tid 140485670717120] [client x.x.x.240:60024] AH01964: Connection to child 12 established (server cloud...:443)
[Wed Jul 17 11:31:38.564172 2024] [ssl:info] [pid 131877:tid 140484932519616] [client x.x.x.240:44654] AH01964: Connection to child 22 established (server cloud...:443)
[Wed Jul 17 11:31:39.215710 2024] [ssl:info] [pid 131877:tid 140484915734208] [client x.x.x.240:44656] AH01964: Connection to child 24 established (server cloud...:443)
[Wed Jul 17 11:31:39.217213 2024] [ssl:info] [pid 131877:tid 140485897221824] [client x.x.x.240:44666] AH01964: Connection to child 2 established (server cloud...:443)
[Wed Jul 17 11:31:39.219456 2024] [ssl:info] [pid 131877:tid 140485987387072] [client x.x.x.240:44676] AH01964: Connection to child 0 established (server cloud...:443)
[Wed Jul 17 11:31:39.220731 2024] [ssl:info] [pid 131877:tid 140484672476864] [client x.x.x.240:44690] AH01964: Connection to child 18 established (server cloud...:443)
[Wed Jul 17 11:31:39.224479 2024] [ssl:info] [pid 131877:tid 140485863651008] [client x.x.x.240:44700] AH01964: Connection to child 6 established (server cloud...:443)
[Wed Jul 17 11:31:39.299422 2024] [ssl:info] [pid 131877:tid 140485687502528] [client x.x.x.240:44716] AH01964: Connection to child 10 established (server cloud...:443)
[Wed Jul 17 11:31:48.667517 2024] [ssl:info] [pid 131876:tid 140484747978432] [client x.x.x.240:60972] AH01964: Connection to child 88 established (server cloud...:443)
[Wed Jul 17 11:31:58.770932 2024] [ssl:info] [pid 131876:tid 140485108668096] [client x.x.x.240:50982] AH01964: Connection to child 86 established (server cloud...:443)
[Wed Jul 17 11:31:59.341585 2024] [reqtimeout:info] [pid 131877:tid 140485687502528] [client x.x.x.240:44716] AH01382: Request header read timeout
[Wed Jul 17 11:32:08.878854 2024] [ssl:info] [pid 131877:tid 140485653931712] [client x.x.x.240:50780] AH01964: Connection to child 14 established (server cloud...:443)
[Wed Jul 17 11:32:12.568208 2024] [ssl:info] [pid 131877:tid 140484680869568] [client x.x.x.240:50796] AH01964: Connection to child 17 established (server cloud...:443)
[Wed Jul 17 11:32:18.974235 2024] [ssl:info] [pid 131876:tid 140485846865600] [client x.x.x.240:54250] AH01964: Connection to child 72 established (server cloud...:443)
[Wed Jul 17 11:32:29.067669 2024] [ssl:info] [pid 131876:tid 140485393888960] [client x.x.x.240:47858] AH01964: Connection to child 77 established (server cloud...:443)
[Wed Jul 17 11:32:39.160104 2024] [ssl:info] [pid 131877:tid 140484932519616] [client x.x.x.240:51296] AH01964: Connection to child 22 established (server cloud...:443)
[Wed Jul 17 11:32:39.218819 2024] [ssl:info] [pid 131876:tid 140485402281664] [client x.x.x.240:51308] AH01964: Connection to child 76 established (server cloud...:443)
[Wed Jul 17 11:32:39.219554 2024] [ssl:info] [pid 131877:tid 140485897221824] [client x.x.x.240:51312] AH01964: Connection to child 2 established (server cloud...:443)
[Wed Jul 17 11:32:39.220703 2024] [ssl:info] [pid 131877:tid 140484915734208] [client x.x.x.240:51322] AH01964: Connection to child 24 established (server cloud...:443)
[Wed Jul 17 11:32:39.221115 2024] [ssl:info] [pid 131876:tid 140485897221824] [client x.x.x.240:51338] AH01964: Connection to child 66 established (server cloud...:443)
[Wed Jul 17 11:32:39.305168 2024] [ssl:info] [pid 131877:tid 140485863651008] [client x.x.x.240:51344] AH01964: Connection to child 6 established (server cloud...:443)
[Wed Jul 17 11:32:49.251484 2024] [ssl:info] [pid 131877:tid 140485679109824] [client x.x.x.240:51028] AH01964: Connection to child 11 established (server cloud...:443)
[Wed Jul 17 11:32:59.357445 2024] [ssl:info] [pid 131877:tid 140485978994368] [client x.x.x.240:50702] AH01964: Connection to child 1 established (server cloud...:443)
[Wed Jul 17 11:33:09.471658 2024] [ssl:info] [pid 131877:tid 140485880436416] [client x.x.x.240:58304] AH01964: Connection to child 4 established (server cloud...:443)
[Wed Jul 17 11:33:19.574755 2024] [ssl:info] [pid 131877:tid 140484680869568] [client x.x.x.240:33916] AH01964: Connection to child 17 established (server cloud...:443)
[Wed Jul 17 11:33:29.665356 2024] [ssl:info] [pid 131876:tid 140485978994368] [client x.x.x.240:53746] AH01964: Connection to child 65 established (server cloud...:443)
[Wed Jul 17 11:33:39.231376 2024] [ssl:info] [pid 131876:tid 140485142238912] [client x.x.x.240:41488] AH01964: Connection to child 82 established (server cloud...:443)
[Wed Jul 17 11:33:39.231423 2024] [ssl:info] [pid 131876:tid 140485419067072] [client x.x.x.240:41490] AH01964: Connection to child 74 established (server cloud...:443)
[Wed Jul 17 11:33:39.235914 2024] [ssl:info] [pid 131876:tid 140485410674368] [client x.x.x.240:41504] AH01964: Connection to child 75 established (server cloud...:443)
[Wed Jul 17 11:33:39.238368 2024] [ssl:info] [pid 131877:tid 140485662324416] [client x.x.x.240:41510] AH01964: Connection to child 13 established (server cloud...:443)
[Wed Jul 17 11:33:39.241330 2024] [ssl:info] [pid 131876:tid 140485117060800] [client x.x.x.240:41526] AH01964: Connection to child 85 established (server cloud...:443)
[Wed Jul 17 11:33:39.242632 2024] [ssl:info] [pid 131877:tid 140485670717120] [client x.x.x.240:41542] AH01964: Connection to child 12 established (server cloud...:443)
[Wed Jul 17 11:33:39.758446 2024] [ssl:info] [pid 131877:tid 140484932519616] [client x.x.x.240:41550] AH01964: Connection to child 22 established (server cloud...:443)
[Wed Jul 17 11:33:49.843776 2024] [ssl:info] [pid 131876:tid 140485133846208] [client x.x.x.240:57614] AH01964: Connection to child 83 established (server cloud...:443)
[Wed Jul 17 11:33:59.948528 2024] [ssl:info] [pid 131876:tid 140484747978432] [client x.x.x.240:58690] AH01964: Connection to child 88 established (server cloud...:443)
[Wed Jul 17 11:34:10.051112 2024] [ssl:info] [pid 131876:tid 140485108668096] [client x.x.x.240:50314] AH01964: Connection to child 86 established (server cloud...:443)
[Wed Jul 17 11:34:20.157089 2024] [ssl:info] [pid 131877:tid 140485855258304] [client x.x.x.240:38992] AH01964: Connection to child 7 established (server cloud...:443)
[Wed Jul 17 11:34:25.679662 2024] [ssl:info] [pid 131877:tid 140485695895232] [client x.x.x.240:39004] AH01964: Connection to child 9 established (server cloud...:443)
[Wed Jul 17 11:34:39.221129 2024] [ssl:info] [pid 131876:tid 140485872043712] [client x.x.x.240:56190] AH01964: Connection to child 69 established (server cloud...:443)
[Wed Jul 17 11:34:39.226350 2024] [ssl:info] [pid 131876:tid 140485393888960] [client x.x.x.240:56194] AH01964: Connection to child 77 established (server cloud...:443)
[Wed Jul 17 11:34:39.229194 2024] [ssl:info] [pid 131876:tid 140484756371136] [client x.x.x.240:56208] AH01964: Connection to child 87 established (server cloud...:443)
[Wed Jul 17 11:34:39.229511 2024] [ssl:info] [pid 131877:tid 140484957697728] [client x.x.x.240:56216] AH01964: Connection to child 19 established (server cloud...:443)
[Wed Jul 17 11:34:39.377154 2024] [ssl:info] [pid 131876:tid 140485897221824] [client x.x.x.240:56230] AH01964: Connection to child 66 established (server cloud...:443)
[Wed Jul 17 11:34:40.312142 2024] [ssl:info] [pid 131877:tid 140485978994368] [client x.x.x.240:56238] AH01964: Connection to child 1 established (server cloud...:443)
[Wed Jul 17 11:34:50.411294 2024] [ssl:info] [pid 131876:tid 140485863651008] [client x.x.x.240:40008] AH01964: Connection to child 70 established (server cloud...:443)
[Wed Jul 17 11:34:59.413130 2024] [reqtimeout:info] [pid 131876:tid 140485897221824] [client x.x.x.240:56230] AH01382: Request header read timeout
[Wed Jul 17 11:35:00.526685 2024] [ssl:info] [pid 131876:tid 140485410674368] [client x.x.x.240:43916] AH01964: Connection to child 75 established (server cloud...:443)
[Wed Jul 17 11:35:10.624120 2024] [ssl:info] [pid 131876:tid 140485385496256] [client x.x.x.240:41012] AH01964: Connection to child 78 established (server cloud...:443)
[Wed Jul 17 11:35:20.716629 2024] [ssl:info] [pid 131876:tid 140485159024320] [client x.x.x.240:49176] AH01964: Connection to child 80 established (server cloud...:443)
[Wed Jul 17 11:35:30.808424 2024] [ssl:info] [pid 131877:tid 140485653931712] [client x.x.x.240:43250] AH01964: Connection to child 14 established (server cloud...:443)
[Wed Jul 17 11:35:39.212947 2024] [ssl:info] [pid 131876:tid 140485133846208] [client x.x.x.240:47348] AH01964: Connection to child 83 established (server cloud...:443)
[Wed Jul 17 11:35:39.214094 2024] [ssl:info] [pid 131876:tid 140485888829120] [client x.x.x.240:47358] AH01964: Connection to child 67 established (server cloud...:443)
[Wed Jul 17 11:35:39.219439 2024] [ssl:info] [pid 131876:tid 140484747978432] [client x.x.x.240:47360] AH01964: Connection to child 88 established (server cloud...:443)
[Wed Jul 17 11:35:39.222356 2024] [ssl:info] [pid 131877:tid 140484680869568] [client x.x.x.240:47362] AH01964: Connection to child 17 established (server cloud...:443)
[Wed Jul 17 11:35:39.302806 2024] [ssl:info] [pid 131877:tid 140485888829120] [client x.x.x.240:47374] AH01964: Connection to child 3 established (server cloud...:443)
[Wed Jul 17 11:35:40.904291 2024] [ssl:info] [pid 131877:tid 140485670717120] [client x.x.x.240:47376] AH01964: Connection to child 12 established (server cloud...:443)
[Wed Jul 17 11:35:50.994866 2024] [ssl:info] [pid 131876:tid 140485872043712] [client x.x.x.240:49220] AH01964: Connection to child 69 established (server cloud...:443)
[Wed Jul 17 11:36:01.085148 2024] [ssl:info] [pid 131877:tid 140485987387072] [client x.x.x.240:59376] AH01964: Connection to child 0 established (server cloud...:443)
[Wed Jul 17 11:36:11.183332 2024] [ssl:info] [pid 131877:tid 140484924126912] [client x.x.x.240:51810] AH01964: Connection to child 23 established (server cloud...:443)
[Wed Jul 17 11:36:21.273825 2024] [ssl:info] [pid 131876:tid 140485393888960] [client x.x.x.240:55350] AH01964: Connection to child 77 established (server cloud...:443)
[Wed Jul 17 11:36:31.370580 2024] [ssl:info] [pid 131876:tid 140485987387072] [client x.x.x.240:55780] AH01964: Connection to child 64 established (server cloud...:443)
[Wed Jul 17 11:36:39.214368 2024] [ssl:info] [pid 131876:tid 140485978994368] [client x.x.x.240:52632] AH01964: Connection to child 65 established (server cloud...:443)
[Wed Jul 17 11:36:39.216733 2024] [ssl:info] [pid 131877:tid 140485645539008] [client x.x.x.240:52644] AH01964: Connection to child 15 established (server cloud...:443)
[Wed Jul 17 11:36:39.218129 2024] [ssl:info] [pid 131877:tid 140485695895232] [client x.x.x.240:52658] AH01964: Connection to child 9 established (server cloud...:443)
[Wed Jul 17 11:36:39.218161 2024] [ssl:info] [pid 131876:tid 140485863651008] [client x.x.x.240:52648] AH01964: Connection to child 70 established (server cloud...:443)
[Wed Jul 17 11:36:39.300819 2024] [ssl:info] [pid 131877:tid 140485679109824] [client x.x.x.240:52668] AH01964: Connection to child 11 established (server cloud...:443)

I just did another test by installing the Nextcloud Desktop Client on Windows and there the files are shown correctly. It really seems to me that it’s just die Browser client that doesn’t show the files.

Create a new file in a directory that isn’t showing files. Afterwards, do the files show?

Just tried creating a simple text file on the test client and let the nextcloud client sync it (so that the database is aware of the change) but the problem remains. Also I noticed, that in the browser i cannot add any new files. The “+ New” button is greyed out.

while on the files tab > bottom left, Files settings > uncheck Show folder description

That’s it. After setting this the folder shows up normally.

This topic was automatically closed 8 days after the last reply. New replies are no longer allowed.