-
Bug
-
Resolution: Fixed
-
Medium
-
5.10.7, 6.0.3, 7.4.3
-
Location: https://extranet.atlassian.com/display/~lquiroga/Express+Lane+-+Maintenance+issues#
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.116 Safari/537.36
Referrer: https://extranet.atlassian.com/spaces/viewspace.action?key=~lquiroga
Screen Resolution: 1440 x 900
User Name: lquiroga
Current Dark Features: confluence.view.edit.transition,confluence-inline-comments-resolved,confluence-monitoring.hibernate.enable,federated.search,editor.advanced.paste,jirachart.createdvsresolved,file-annotations,confluence.efi.onboarding.rich.space.content,view-file-macro-placeholder,view-file-macro-insert-from-drag-and-drop,show.business.group.in.user.hover,remove.attachment.button,notification.batch,confluence-inline-comments-rich-editor,blueprint-retrospectives,confluence-table-enhancements.copy-cut-paste-cols,heatmapper,cql.search.screen,clc.quick.create,view-file-thumbnail,confluence-table-enhancements.sticky-headers,jirachart.twodimensional,confluence-table-enhancements.auto-row,nps.survey.inline.dialog,confluence.efi.onboarding.new.templates,total-comment-count,confluence.efi.onboarding.1185.demo-enabled,view-file-macro-convert-to-thumbnail,site-wide.shared-drafts,pdf-preview,blueprint-jirareports,previews.versions,confluence-monitoring.enable,confluence.wrap.macro,previews.conversion-service,editor.ajax.save,content.rank,wiki.macro.disable.antisamy,previews.trigger-all-file-types,view-file-macro-insert-from-exclamation-mark,view-file-thumbnail-polling,jira-placeholder,autoconvert-link-to-page-title,confluence.request.access.enable,email-tracking,confluence.dark.feature.view-storage,file-notifications,com.atlassian.analytics.auto.whitelist.grow.events,ondemand.marketplace.prototype,file-annotations.likes,site-wide.synchrony,blueprint-decisions,notification.plugin.api.enabled.com.atlassian.confluence.plugins.sharepage.api.ShareAttachmentEvent,confluence-inline-comments,hipchat.confluence.glance.experiment,confluence-inline-comments-dangling-comment,notification.plugin.api.enabled.com.atlassian.confluence.plugins.sharepage.api.ShareContentEvent,notification.plugin.api.enabled.com.atlassian.confluence.plugins.mentions.api.ConfluenceMentionEvent,notification.plugin.api.enabled.com.atlassian.confluence.event.events.security.ForgotPasswordEvent,notification.plugin.api.enabled.com.atlassian.confluence.plugins.tasklist.event.SendTaskEmailEvent,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.comment.CommentCreateEvent,notification.plugin.api.enabled.com.atlassian.confluence.event.events.follow.FollowEvent,notification.plugin.api.enabled.com.atlassian.confluence.plugins.inlinecomments.events.InlineCommentReplyEvent,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.blogpost.BlogPostCreateEvent,confluence.table.resizable,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.blogpost.BlogPostUpdateEvent,site-wide.synchrony.opt-in,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.page.async.PageCreatedEvent,notification.plugin.api.enabled.com.atlassian.confluence.plugins.files.notifications.event.FileContentMentionUpdateEvent,notification.plugin.api.enabled.com.atlassian.confluence.plugins.hipchat.api.events.HipChatUserMapped,quick-reload-inline-comments-flags,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.blogpost.BlogPostMovedEvent,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.page.async.PageMovedEvent,previews.sharing,notification.plugin.api.enabled.com.atlassian.confluence.plugins.files.notifications.event.FileContentUpdateEvent,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.attachment.AttachmentBatchUploadCompletedEvent,collaborative-audit-log,notification.plugin.api.enabled.com.atlassian.confluence.efi.emails.events.OnboardingLessUsersEvent,notification.plugin.api.enabled.com.atlassian.confluence.plugins.files.notifications.event.FileContentRemoveEvent,atlassian.aui.raphael.disabled,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.comment.CommentUpdateEvent,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.page.async.PageEditedEvent,notification.plugin.api.enabled.com.atlassian.confluence.plugins.inlinecomments.events.InlineCommentResolveEvent,notification.plugin.api.enabled.com.atlassian.confluence.event.events.like.LikeCreatedEvent,notification.plugin.api.enabled.com.atlassian.confluence.plugins.inlinecomments.events.InlineCommentCreateEvent,previews.sharing.pushstate,notification.plugin.api.enabled.com.atlassian.confluence.efi.emails.events.OnboardingNoSpaceCreatedEvent
SpaceTheme: theme-default aui-layout aui-theme-default
VersionNumber: 6.0.0-beta5Location : https://extranet.atlassian.com/display/~lquiroga/Express+Lane+-+Maintenance+issues# User-Agent : Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.116 Safari/537.36 Referrer : https://extranet.atlassian.com/spaces/viewspace.action?key=~lquiroga Screen Resolution : 1440 x 900 User Name : lquiroga Current Dark Features : confluence.view.edit.transition,confluence-inline-comments-resolved,confluence-monitoring.hibernate.enable,federated.search,editor.advanced.paste,jirachart.createdvsresolved,file-annotations,confluence.efi.onboarding.rich.space.content,view-file-macro-placeholder,view-file-macro-insert-from-drag-and-drop,show.business.group.in.user.hover,remove.attachment.button,notification.batch,confluence-inline-comments-rich-editor,blueprint-retrospectives,confluence-table-enhancements.copy-cut-paste-cols,heatmapper,cql.search.screen,clc.quick.create,view-file-thumbnail,confluence-table-enhancements.sticky-headers,jirachart.twodimensional,confluence-table-enhancements.auto-row,nps.survey.inline.dialog,confluence.efi.onboarding.new.templates,total-comment-count,confluence.efi.onboarding.1185.demo-enabled,view-file-macro-convert-to-thumbnail,site-wide.shared-drafts,pdf-preview,blueprint-jirareports,previews.versions,confluence-monitoring.enable,confluence.wrap.macro,previews.conversion-service,editor.ajax.save,content.rank,wiki.macro.disable.antisamy,previews.trigger-all-file-types,view-file-macro-insert-from-exclamation-mark,view-file-thumbnail-polling,jira-placeholder,autoconvert-link-to-page-title,confluence.request.access.enable,email-tracking,confluence.dark.feature.view-storage,file-notifications,com.atlassian.analytics.auto.whitelist.grow.events,ondemand.marketplace.prototype,file-annotations.likes,site-wide.synchrony,blueprint-decisions,notification.plugin.api.enabled.com.atlassian.confluence.plugins.sharepage.api.ShareAttachmentEvent,confluence-inline-comments,hipchat.confluence.glance.experiment,confluence-inline-comments-dangling-comment,notification.plugin.api.enabled.com.atlassian.confluence.plugins.sharepage.api.ShareContentEvent,notification.plugin.api.enabled.com.atlassian.confluence.plugins.mentions.api.ConfluenceMentionEvent,notification.plugin.api.enabled.com.atlassian.confluence.event.events.security.ForgotPasswordEvent,notification.plugin.api.enabled.com.atlassian.confluence.plugins.tasklist.event.SendTaskEmailEvent,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.comment.CommentCreateEvent,notification.plugin.api.enabled.com.atlassian.confluence.event.events.follow.FollowEvent,notification.plugin.api.enabled.com.atlassian.confluence.plugins.inlinecomments.events.InlineCommentReplyEvent,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.blogpost.BlogPostCreateEvent,confluence.table.resizable,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.blogpost.BlogPostUpdateEvent,site-wide.synchrony.opt-in,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.page.async.PageCreatedEvent,notification.plugin.api.enabled.com.atlassian.confluence.plugins.files.notifications.event.FileContentMentionUpdateEvent,notification.plugin.api.enabled.com.atlassian.confluence.plugins.hipchat.api.events.HipChatUserMapped,quick-reload-inline-comments-flags,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.blogpost.BlogPostMovedEvent,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.page.async.PageMovedEvent,previews.sharing,notification.plugin.api.enabled.com.atlassian.confluence.plugins.files.notifications.event.FileContentUpdateEvent,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.attachment.AttachmentBatchUploadCompletedEvent,collaborative-audit-log,notification.plugin.api.enabled.com.atlassian.confluence.efi.emails.events.OnboardingLessUsersEvent,notification.plugin.api.enabled.com.atlassian.confluence.plugins.files.notifications.event.FileContentRemoveEvent,atlassian.aui.raphael.disabled,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.comment.CommentUpdateEvent,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.page.async.PageEditedEvent,notification.plugin.api.enabled.com.atlassian.confluence.plugins.inlinecomments.events.InlineCommentResolveEvent,notification.plugin.api.enabled.com.atlassian.confluence.event.events.like.LikeCreatedEvent,notification.plugin.api.enabled.com.atlassian.confluence.plugins.inlinecomments.events.InlineCommentCreateEvent,previews.sharing.pushstate,notification.plugin.api.enabled.com.atlassian.confluence.efi.emails.events.OnboardingNoSpaceCreatedEvent SpaceTheme : theme-default aui-layout aui-theme-default VersionNumber : 6.0.0-beta5
-
3
-
Severity 3 - Minor
-
Summary
There is an excessive delay in loading the editor for a Confluence page that has several Jira Issue Macros (JIM) that are using the 'Total Issue Count' option in the 'Display Options'. This appears to be linked to Jira servers/clusters that have a million issues (or more).
Environment
Confluence 7.4.3.
Jira 8.5.8 (maybe other versions of JIRA as well)
Steps to Reproduce
- Install Jira 8.5.8 and Confluence 7.4.3 in test environment. I used PSQL db for the test.
- Populate the application data in JIRA to have 500k to 1 million issues. Confluence can be at default settings.
- Setup an application link between the two servers.
- In Confluence, create a new test page with 15 JIM macros each using JQL to filter the table and make sure that in the 'Display Options' in the macro, the 'Total Issue Count' option is selected. The filter should have a high amount of issues included (500k to 1 million) among several of the macros. Save the page.
- Notice it reaches out to JIRA to pull total issues for each macro.
- While on the test page, click the EDIT button (top right).
Expected Results
The editor should load in a reasonably quick time, or at least inline with how long it takes to query and retrieve the total issue values from Jira.
Actual Results
The editor takes 3x-5x the time it should to fully load before being available to edit the page.
Notes
- The delay comes from the editor reaching out to JIRA and requesting/loading the total issue counts after the EDIT button has been pressed. This is to include the total issue count for the macros in the editor.
- While viewing a page, there are asynchronous REST calls to get the total issue count for the macros (this is behaving normally) which is several times faster than in edit mode.
- Customers have observed that the delay in v6.15.9 is 50% less than in v7.4.3. for the editor with the same dataset in Jira.
Workaround
- Splitting page into smaller pages will help with page load.
- Starting from versions 7.8.1 and 6.13.18, in the dark features, we would need to add "confluence.extra.jira.edit.ignore.count" to prevent Confluence from making requests to Jira. Due to that change, instead of a real count number, we will see "x" in edit mode.
![[Confluence] Page](/images/icons/generic_link_16.png "[Confluence] Page"){kind=icon}