a big folder inside a goupfolder is no more visible

[rodinux]

Steps to reproduce

1. Upgrade nextcloud from 28.0.9 to 29.0.6
2. Go to a groupfolder with few folders
3. a big folder is not visible
4. Try search the folder
5. the search can't found the folder

Expected behaviour

The folder must be visible

Actual behaviour

Can't found the folder

Server configuration

Operating system: docker installation with a build of apache version Linux 4.19.0-25-amd64 x86_64

Web server: using traefik

**Database: postgresql container PostgreSQL 14.7 (Debian 14.7-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit **

PHP version: 8.2.23

Nextcloud version: 29.0.6 (see Nextcloud admin page)

Group folders version: 17.0.3

Updated from an older Nextcloud: 28.0.9

Where did you install Nextcloud from: a docker-compose

Are you using external storage, if yes which one: no

Are you using encryption: no

Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/Saml/...

Client configuration

Browser: firefox

Operating system: Debian

Logs

the folder is called n-marque

I can see it on the groupfolder

docker exec -t container-nextcloud-1 ls  data/__groupfolders/1/ |grep n-marque
 n-marque_mycompany

docker exec -t container-nextcloud-1 ls -l data/__groupfolders/1/n-marque_mycompany/
total 1600
-rw-r--r--  1 www-data www-data   20116 Jan 23  2019 'Charte du collectif des m'$'\303\251''tiers du num'$'\303\251''rique.odt'
drwxr-xr-x  2 www-data www-data    4096 Mar  4  2024  Coopaname
drwxr-x---  2 www-data www-data    4096 May 20  2019 'Echanges de Services'
-rw-r--r--  1 www-data www-data   24695 Jan 23  2019 'M'$'\303\251''tiers du num'$'\303\251''rique.ods'
drwxr-x---  3 www-data www-data    4096 Feb 27  2023 'Outils de la marque'
drwxr-xr-x  3 www-data www-data    4096 Jul  8  2019  Partenaires
-rw-r--r--  1 www-data www-data     722 Apr 10  2023 'Pr'$'\303\251''sentation Martin.md'
-rw-r--r--  1 www-data www-data     109 Mar 27 10:30  Test_talk.pad
drwxr-x---  4 www-data www-data    4096 Mar 11  2024  n-Juridique
drwxr-xr-x  4 www-data www-data    4096 Sep 11 16:57  n-commercial
drwxr-x--- 17 www-data www-data    4096 Sep 16 15:45  n-communication
drwxr-x--- 14 www-data www-data    4096 Apr  8 07:03  n-compta
drwxr-xr-x  3 www-data www-data    4096 Jul 25 07:25  n-ecologie
drwxr-x---  7 www-data www-data    4096 Feb 27  2023  n-gouvernance
drwxr-x---  7 www-data www-data    4096 Mar 20 09:35  n-logo
drwxr-x---  6 www-data www-data    4096 Jan  2  2024 'n-mod'$'\303\250''les'
drwxr-x---  5 www-data www-data    4096 Sep 27  2023  n-siteweb
drwxr-xr-x  2 www-data www-data    4096 Apr 14  2020  n-wiki-colibris
drwxr-x---  3 www-data www-data    4096 Feb 27  2023 'n-'$'\303\251''quipe'
-rw-r--r--  1 www-data www-data      72 Feb  9  2023 'pr'$'\303\251''sentation Marie.md'
-rw-r--r--  1 www-data www-data      77 Mar  2  2023 'test pad-nextcloud.md'

Is a big folder

du -sh /mnt/path/nextcloud_data/__groupfolders/1/n-marque_mycompany
678M    /mnt/path/nextcloud_data/__groupfolders/1/n-marque_mycompany

cat /mnt/pp/mynextcloud-sata/nxc/nextcloud_data/nextcloud.log | grep "n-marque"
cat /mnt/pp/mynextcloud-sata/nxc/nextcloud_data/nextcloud.log | grep "n-marque"
{"reqId":"wHott8yIPiribLZQPjvP","level":0,"time":"2024-09-18T08:34:49+00:00","remoteAddr":"xx.xxx.xx.xx","user":"Adminmynextcloud","app":"no app in context","method":"GET","url":"/ocs/v2.php/search/providers/files/search?term=n-marque&limit=10&from=%2Fapps%2Ffiles%2Ffiles%3Fdir%3D%2FFolder1","message":"Unable to find limit definition","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0","version":"29.0.6.1","data":{"value":"10"}}
{"reqId":"wHott8yIPiribLZQPjvP","level":0,"time":"2024-09-18T08:34:49+00:00","remoteAddr":"xx.xxx.xx.xx","user":"Adminmynextcloud","app":"no app in context","method":"GET","url":"/ocs/v2.php/search/providers/files/search?term=n-marque&limit=10&from=%2Fapps%2Ffiles%2Ffiles%3Fdir%3D%2FFolder1","message":"Unable to find from definition","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0","version":"29.0.6.1","data":{"value":"/apps/files/files?dir=/Folder1"}}
{"reqId":"wHott8yIPiribLZQPjvP","level":0,"time":"2024-09-18T08:34:49+00:00","remoteAddr":"xx.xxx.xx.xx","user":"Adminmynextcloud","app":"no app in context","method":"GET","url":"/ocs/v2.php/search/providers/files/search?term=n-marque&limit=10&from=%2Fapps%2Ffiles%2Ffiles%3Fdir%3D%2FFolder1","message":"Unable to find providerId definition","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0","version":"29.0.6.1","data":{"value":"files"}}
{"reqId":"wHott8yIPiribLZQPjvP","level":0,"time":"2024-09-18T08:34:49+00:00","remoteAddr":"xx.xxx.xx.xx","user":"Adminmynextcloud","app":"no app in context","method":"GET","url":"/ocs/v2.php/search/providers/files/search?term=n-marque&limit=10&from=%2Fapps%2Ffiles%2Ffiles%3Fdir%3D%2FFolder1","message":"Unable to find _route definition","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0","version":"29.0.6.1","data":{"value":"ocs.core.unifiedsearch.search"}}
{"reqId":"oOHZXhG6ASwVAPoRImDx","level":0,"time":"2024-09-18T08:34:55+00:00","remoteAddr":"xx.xxx.xx.xx","user":"Adminmynextcloud","app":"no app in context","method":"GET","url":"/ocs/v2.php/search/providers/files/search?term=n-marque&from=%2Fapps%2Ffiles%2Ffiles%3Fdir%3D%2FFolder1","message":"Unable to find from definition","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0","version":"29.0.6.1","data":{"value":"/apps/files/files?dir=/Folder1"}}
{"reqId":"oOHZXhG6ASwVAPoRImDx","level":0,"time":"2024-09-18T08:34:55+00:00","remoteAddr":"xx.xxx.xx.xx","user":"Adminmynextcloud","app":"no app in context","method":"GET","url":"/ocs/v2.php/search/providers/files/search?term=n-marque&from=%2Fapps%2Ffiles%2Ffiles%3Fdir%3D%2FFolder1","message":"Unable to find providerId definition","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0","version":"29.0.6.1","data":{"value":"files"}}
{"reqId":"oOHZXhG6ASwVAPoRImDx","level":0,"time":"2024-09-18T08:34:55+00:00","remoteAddr":"xx.xxx.xx.xx","user":"Adminmynextcloud","app":"no app in context","method":"GET","url":"/ocs/v2.php/search/providers/files/search?term=n-marque&from=%2Fapps%2Ffiles%2Ffiles%3Fdir%3D%2FFolder1","message":"Unable to find _route definition","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0","version":"29.0.6.1","data":{"value":"ocs.core.unifiedsearch.search"}}

I have also try

docker exec -u www-data -it container-nextcloud-1 php occ groupfolders:scan 1

Web server error log

Web server error log

Insert your webserver log here

Nextcloud log (data/nextcloud.log)

Not sure if it could be related ???

{"reqId":"mUiGx6wtqIqi9x6yklv3","level":0,"time":"2024-09-18T08:52:17+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3) ORDER BY `last_checked` ASC LIMIT 1","userAgent":"--","version":"29.0.6.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3) ORDER BY `last_checked` ASC LIMIT 1","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3) ORDER BY `last_checked` ASC LIMIT 1",[1726606337,1726649537,1],[1,1,1],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/BackgroundJob/JobList.php","line":230,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/cron.php","line":163,"function":"getNext","class":"OC\\BackgroundJob\\JobList","type":"->","args":[true]}],"File":"/var/www/html/lib/private/DB/Connection.php","Line":320,"message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3) ORDER BY `last_checked` ASC LIMIT 1","tables":["oc_appconfig","oc_jobs","oc_preferences","oc_filecache","oc_direct_edit","oc_activity_mq","oc_mounts","oc_notifications_settings","oc_filecache_extended","oc_files_metadata","oc_files_metadata_index"],"reads":["oc_jobs"],"exception":[],"CustomMessage":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3) ORDER BY `last_checked` ASC LIMIT 1"},"id":"66ea94c65ed10"}

Browser log

Browser log

Insert your browser log here, this could for example include:

a) The javascript console log
b) The network log
c) ...

[provokateurin]

Is the folder that is no longer visible a nested groupfolder? Is there anything else that might be special about it?

[rodinux]

Is the folder that is no longer visible a nested groupfolder? Is there anything else that might be special about it?

No it not a nested groupfolder and nothing special except there is a lot of subfolders inside....

Here is the groupfolder arthitecture

docker exec -t numericloud-nxc-pp-nextcloud-1 ls -l data/__groupfolders/1/
total 252

-rw-r--r--   1 www-data www-data   2412 Mar 12  2024 '-- NOTICE DE RANGEMENT.txt'
-rw-r--r--   1 www-data www-data    506 Mar 12  2024 'Lisez moi.md'
drwxr-xr-x   2 www-data www-data   4096 Oct  2  2023  Talk
drwxr-x---   8 www-data www-data   4096 Mar 23  2023 'Z_ A classer'
drwxr-xr-x   3 www-data www-data   4096 May 23  2022  Z_Archives
drwxr-xr-x   3 www-data www-data   4096 Mar 23  2023  e-exemples
drwxr-x---   4 www-data www-data   4096 May  6  2019  gt-groupes_de_travail
drwxr-x---  17 www-data www-data   4096 Jul 25 07:25  n-marque_mycompany
drwxr-x---  10 www-data www-data   4096 Mar 11  2024  noa-num.-outils-applications
-rw-r--r--   1 www-data www-data  47669 Jan 29  2019 'mycompany - Proc'$'\303\251''dures.odt'
drwxr-xr-x   5 www-data www-data   4096 Sep 10 07:32 'o-offres mycompany'
drwxr-x--- 135 www-data www-data  12288 Sep 11 07:14  p-projets_propects-clients
-rw-r--r--   1 www-data www-data 149104 Jan 23  2024  paico-oficial-NIpx9ZUSiZg-unsplash_petit.jpg
drwxr-xr-x   6 www-data www-data   4096 Sep 12 16:07  t-technique

all of this is a on a preproduction, I still have the production stack running on a version 28.0.9 .
I can watch if necessary how is it before upgrading...

[rodinux]

all of this is a on a preproduction, I still have the production stack running on a version 28.0.9 .
I can watch if necessary how is it before upgrading...

Ok, I found perhaps something special in this folder on production. Incoherent advanced permissions. Sorry if it's only this...

[rodinux]

Well I don't known... It is 2 different groups Nu1 and Nu2

docker exec -u www-data -it  container-nextcloud-1 php occ groupfolders:permissions 1

+------------------------------------------------------------------------------+-----------------------------+-----------------------------------------------------------+
| Path | User/Group | Permissions |
+------------------------------------------------------------------------------+-----------------------------+-----------------------------------------------------------+
| n-marque_mycompany | group: Nu1 | |
| | group: Nu2 | -read, -write, -create, -delete, -share |

The groupfolder is owned by Nu1 and Nu2 with the permissions Write, Share,Delete

The groups Nu1 and Nu2 have the same 5 Users

[provokateurin]

Then this is a duplicate of #598