Opened 3 weeks ago

Last modified 3 weeks ago

#1039 new bug

Issues when number of folders in a subfolder is more than 1000

Reported by: pashazadeh Owned by:
Priority: minor Milestone:
Component: Core Version: 8.5
Keywords: query folders Cc:


In FolderDAO, it first extracts sub-folder ids recursively, stores them in a Set<Long> and then does other operations on that.

  • counting total number of documents
  • calculating total size of documents
  • deleting/undeleting a folder
  • changing permissions on a folder


If total number of subfolders of a folder (recursively) exceeds 1000, Oracle database throws an exception on the query, and MySQL does not perform the operation on folderids which are exceed 1000 limit.

Logicaldoc counts the total number of documents, and total size of documents on administrator login. So if the total number of folders (recursively) exceed 1000, there will be an exception and Admin can not login at all.

This issue exists in 7.5.1, 7.5.2 and 8.5 (I've checked these versions, but I believe more versions have this issue).

Change History (1)

comment:1 Changed 3 weeks ago by admin

  • Milestone 8.5.1 deleted
  • Priority changed from major to minor
Note: See TracTickets for help on using tickets.