-
Bug
-
Resolution: Unresolved
-
Medium
-
None
-
6.7.3, 6.13.3, 6.15.1, 6.15.9
-
14
-
Severity 3 - Minor
-
2
-
Issue Summary
When adding the Word Doc macro to display a Word document which contains a copy of an Excel chart with a logarithmic scale, Confluence will encounter slow performance issues and encounter a Java Heap issue after saving the page with the Word document.
UPDATE: This bug can also occur when viewing directly an Excel file with logarithmic scale attached to a page or any office file that contains an Excel file with logarithmic scale.
Steps to Reproduce
- Create a Word Document and embed an Excel chart with a logarithmic scale.
- Upload file as an attachment to any Confluence Space (this alone will not cause the issue)
- Use the View Doc (Word ver) macro to display (not link) the Word Document on any page
- Save Page
Expected Results
Once saved, the Confluence page should show the contents of the Word Document on the page.
Actual Results
A Java Heap error will display on the page, causing slow performance on the instance. The following is shown in the logs:
2019-03-14 15:09:27,901 ERROR [http-nio-8090-exec-8] [xhtml.view.macro.ViewMacroMarshaller] handleMacroExecutionException Error rendering macro: viewdoc
-- url: /display/TT/test | page: 1998878 | traceId: b1461380347c5209 | userName: admin | referer: http://localhost:8090/pages/editpage.action?pageId=19
98878 | action: viewpage
java.lang.OutOfMemoryError: Java heap space
Notes
- Increasing the available memory the max allowed by the environment still causes the issue.
- The problem is not encountered if a normal chart is used in the word document.
- The problem word docs fairly small in size. Example of a doc that causes the issue:
Workaround
Currently, there is no known workaround for this behavior. A workaround will be added here when available
| Form Name | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
[CONFSERVER-58076] Word Doc w/ Embeded Excel Chart Causes Memory Issues
As this could be used as a denial of service attack it should have increased priority.
One user can bring down system with one action...
A "Stacked Bar" chart with logarithmic scale will also cause confluence to crash.
We found, for excel file, seems "Logarithmic scale" itself alone won't crash confluence.
But when an excel file contains chart with following 2 settings at the same time, it will crash confluence.
- Vertical axis with "Logarithmic scale" option is checked;
- Chart's type is "Stacked Column";
We tested, and found even an excel with following simple data will crash confluence immediately every time, when a chart is created with above settings on these data.
| x | y |
|---|---|
| a | 18 |
| b | 26 |
| c | 200 |
| d | 1500 |
This is confirmed in 7.3.2 as well. As this is crashing the instance, this should be fixed soon.
Hi All,
We have recently shipped sandboxing for office files in Confluence Data Center. This means that from 7.8 this issue will no longer have a negative impact on your overall instance stability and starting in 7.9 these files will also load asynchronously (allowing you to still access page content when there is a problematic file attached). Note that this does not fix the underlying issues and these files will still not display properly, but users will be given the option to download the file. More details in the Confluence 7.9 release notes.
I am going to leave this bug open to continue to track the overall solution but dropping the severity to Minor.
Please let us know if these fixes do not work in your situation.
Regards,
Matthew | PM Confluence Server + DC