Opened 7 months ago

Closed 6 months ago

#1039 closed bug (fixed)

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

Reported by: pashazadeh Owned by:
Priority: minor Milestone: 8.5.1
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 (3)

comment:1 Changed 7 months ago by admin

  • Milestone 8.5.1 deleted
  • Priority changed from major to minor

comment:2 Changed 6 months ago by admin

Please report a clear list of actions to take in the GUI in order to replicate the issue

comment:3 Changed 6 months ago by admin

  • Milestone set to 8.5.1
  • Resolution set to fixed
  • Status changed from new to closed

ah, we understood, we fixed in 8.5.1

Note: See TracTickets for help on using tickets.