Opened 4 years ago
Closed 4 years 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: |
Description
In FolderDAO, it first extracts sub-folder ids recursively, stores them in a Set<Long> and then does other operations on that.
Including:
- 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 4 years ago by admin
- Milestone 8.5.1 deleted
- Priority changed from major to minor
comment:2 Changed 4 years ago by admin
comment:3 Changed 4 years 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
Please report a clear list of actions to take in the GUI in order to replicate the issue