Details
-
Bug
-
Resolution: Fixed
-
Medium
-
4.1.4
-
Severity 3 - Minor
-
Description
NOTE: This bug report is for Confluence Server. Using Confluence Cloud? See the corresponding bug report.
Steps to Reproduce
- Set up Confluence and Team Calendars, with many users and calendars (use existing test data if required)
- Enable detailed SQL logging
- Log in to Confluence and go to Calendars
- Click to Add Calendar
- Select Existing Calendar
- Enter part of the name of an existing calendar
- Tail the confluence log - you will see many lines like this:
2014-01-28 00:47:05,045 TRACE [http-10523-13] [sf.hibernate.type.StringType] nullSafeGet returning 'fc72b896-a4d1-44ff-b164-7715a9f2e3e9' as column: x0_0_
- After 2 minutes, the front end will time out and say "No results found for .."
- Keep watching the logs. After around 6 minutes total on my instance, the logging stopped.
NB: Without detailed SQL logging enabled these requests complete and calendars can be found and added, however I'm concerned this is simply highlighting a larger performance issue that should be investigated. If there is a performance issue, any environmental latency could cause the above timeout, or just very slow calendar retrieval.
Attachments
Issue Links
- relates to
-
CONFCLOUD-49590 Searching for an existing calendar to add is slow and appears to execute many SQL statements when SQL Logging is enabled, potentially causing the request to time out.
- Closed