[CONFSERVER-21043] Excel Sheets with large row count causes out of memory errors

Type: Bug
Resolution: Fixed
Priority: Medium
Fix Version/s: 4.0.5
Affects Version/s: 3.3, 3.3.1
Component/s: None
Labels:

Bug Fix Policy:
View Atlassian Server bug fix policy

I've been able to reproduce this problem easily in Confluence 3.3.

Steps:

Create an Excel spreadsheet with data in a very high row number (the attached one has data in rows 1, 2, and 65536). This file can actually be quite small (41kb). One of our users actually did this by accident!
Attach spreadsheet to a page
Use the viewxls macro to display the spreadsheet on your page.

Result: Most of the time, the page won't load - it times out or returns "Page Not Found". Sometimes it WILL load with a "viewxls: java.lang.OutOfMemoryError: Java heap space" error. Java VM Heap free space rapidly plummets (as reported by refreshing the System Info page of Confluence's Admin panel). The entire Confluence instance gets slower. Sometimes the entire Confluence installation stops responding for a little while (eventually it recovered itself).

sample stack trace

2010-11-24 11:18:12,051 ERROR [TP-Processor6] [renderer.v2.components.MacroRendererComponent] processMacro Unexpected error formatting macro: viewfile
 -- url: /display/spacekey/pageTitle | page: 34709164 | userName: admin | referer: https://confluenceURL/display/spacekey/pageTitle | action: viewpage
java.lang.OutOfMemoryError: Java heap space
	at java.util.Arrays.copyOf(Arrays.java:2882)
	at java.lang.AbstractStringBuilder.expandCapacity(AbstractStringBuilder.java:100)
	at java.lang.AbstractStringBuilder.append(AbstractStringBuilder.java:390)
	at java.lang.StringBuffer.append(StringBuffer.java:224)
	at java.io.StringWriter.write(StringWriter.java:84)
	at com.benryan.conversion.SpreadsheetConverter.writeHeaderStyles(SpreadsheetConverter.java:204)
	at com.benryan.conversion.SpreadsheetConverter.write(SpreadsheetConverter.java:65)
	at com.benryan.conversion.SpreadsheetConverter.convert(SpreadsheetConverter.java:395)
	at com.benryan.conversion.XlsConverter$1.doConversion(XlsConverter.java:42)
	at com.benryan.conversion.DocConverter.execute(DocConverter.java:59)
	at com.benryan.conversion.macro.ConverterMacro.execute(ConverterMacro.java:276)
	at com.atlassian.renderer.v2.macro.ResourceAwareMacroDecorator.execute(ResourceAwareMacroDecorator.java:51)
	at com.atlassian.renderer.v2.components.MacroRendererComponent.executeMacro(MacroRendererComponent.java:203)
	at com.atlassian.renderer.v2.components.MacroRendererComponent.processMacro(MacroRendererComponent.java:169)
	at com.atlassian.renderer.v2.components.MacroRendererComponent.makeMacro(MacroRendererComponent.java:67)
	at com.atlassian.renderer.v2.components.WikiContentRendererHandler.handleMacro(WikiContentRendererHandler.java:18)
	at com.atlassian.renderer.v2.WikiMarkupParser.makeMacro(WikiMarkupParser.java:120)
	at com.atlassian.renderer.v2.WikiMarkupParser.handlePotentialMacro(WikiMarkupParser.java:105)
	at com.atlassian.renderer.v2.WikiMarkupParser.parse(WikiMarkupParser.java:60)
	at com.atlassian.renderer.v2.components.MacroRendererComponent.render(MacroRendererComponent.java:46)
	at com.atlassian.renderer.v2.V2Renderer.render(V2Renderer.java:53)
	at com.atlassian.renderer.v2.plugin.PluggableV2Renderer.render(PluggableV2Renderer.java:30)
	at com.atlassian.renderer.v2.V2RendererFacade.convertWikiToXHtml(V2RendererFacade.java:57)
	at sun.reflect.GeneratedMethodAccessor393.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
	at com.atlassian.spring.interceptors.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:16)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)

- - Sort By Name
  - Sort By Date
  - Ascending
  - Descending
  - Thumbnails
  - List

ConfluenceBreakageTestCase.xls
41 kB
13/Oct/2010 11:57 AM

is duplicated by

CONFSERVER-20672 Using viewfile macro with large Excel spreadsheet causes OutOfMemoryError

Closed

CONFSERVER-21257 Office Connector OOM OutOfMemory on Excel file

Closed

CONFSERVER-21840 OutofMemory Errors when using viewfile macro for Excel xlsx.

Closed

CONFSERVER-29997 Rendering a large spreadsheet can cause OutOfMemory errors

Closed

is incorporated by

CONFSERVER-24692 Excel viewfile umbrella issue

Closed

is related to

CONFSERVER-21057 Excel file with incorrect suffix can cause OutOfMemory errors

Closed

CONFSERVER-27037 Viewxls macro renders an error message if the file is bigger than 2MB or has more than has more than 100000 cells

Closed

CONFSERVER-25709 Unable to open xlsx files bigger than 2MB

Closed

relates to

CONFSERVER-20672 Using viewfile macro with large Excel spreadsheet causes OutOfMemoryError

Closed

CONFSERVER-19674 OutOfMemoryError indexing Excel Documents

Closed

CONFSERVER-24599 Provide an ability to change the wording on com.benryan.conversion.ConversionException of CONF-21043 fix

Closed

CONFSERVER-24601 Provide an option to configure the maximum number of allowed cells for viewxls macro

Closed

(3 is related to, 4 relates to)

Katherine Yabut made changes - 13/Nov/2018 4:42 AM

Workflow

Original: JAC Bug Workflow v3 [ 2877079 ]

New: CONFSERVER Bug Workflow v4 [ 2984185 ]

Owen made changes - 11/Oct/2018 8:39 AM

Workflow	Original: JAC Bug Workflow v2 [ 2777094 ]	New: JAC Bug Workflow v3 [ 2877079 ]
Status	Original: Resolved [ 5 ]	New: Closed [ 6 ]

Owen made changes - 29/Aug/2018 11:12 PM

Workflow

Original: JAC Bug Workflow [ 2714216 ]

New: JAC Bug Workflow v2 [ 2777094 ]

Owen made changes - 02/Jul/2018 6:50 AM

Workflow

Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2379943 ]

New: JAC Bug Workflow [ 2714216 ]

Katherine Yabut made changes - 22/Jun/2017 6:47 AM

Workflow

Original: Confluence Workflow - Public Facing - Restricted v5 [ 2270809 ]

New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2379943 ]

Katherine Yabut made changes - 31/May/2017 5:32 AM

Workflow

Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2216048 ]

New: Confluence Workflow - Public Facing - Restricted v5 [ 2270809 ]

Katherine Yabut made changes - 31/May/2017 4:55 AM

Workflow

Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2167509 ]

New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2216048 ]

Katherine Yabut made changes - 31/May/2017 1:58 AM

Workflow

Original: Confluence Workflow - Public Facing - Restricted v5 [ 1925762 ]

New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2167509 ]

Katherine Yabut made changes - 03/Apr/2017 3:58 AM

Workflow

Original: Confluence Workflow - Public Facing - Restricted v3 [ 1727796 ]

New: Confluence Workflow - Public Facing - Restricted v5 [ 1925762 ]

Katherine Yabut made changes - 28/Feb/2017 6:34 AM

Workflow

Original: CONF Bug Subtask WF (TEMP) [ 1684152 ]

New: Confluence Workflow - Public Facing - Restricted v3 [ 1727796 ]

Assignee:: Steve Lancashire (Inactive)

Reporter:: Rome Reginelli

Affected customers:: 16 This affects my team

Watchers:: 24 Start watching this issue

Created:: 13/Oct/2010 11:57 AM

Updated:: 11/Oct/2018 8:39 AM

Resolved:: 22/Nov/2011 6:16 AM

Details

Description

Attachments

Attachments

Issue Links

Forms

Activity

People

Dates