poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 57842] Using POI 3.9 API memory consumed reading an xlsx file is not released back to the operating system after completion
Date Thu, 23 Apr 2015 12:23:33 GMT
https://bz.apache.org/bugzilla/show_bug.cgi?id=57842

--- Comment #6 from pcllau@gmail.com ---
Test-case-1:

Configuration:
    Apache Tomcat 7.0.61
    JDK 1.7.0_79
    POI-3.12-beta1
Code: 
    // open a 6.2MB xlsx file containg 910,000 rows data 
    Workbook wb = new XSSFWorkbook(new File("file_name")); 
    wb.close(); 

Test-case-1 result: memory-use: 1.9GB (doesn't release after closing workbook).
On subsequently re-opening the same workbook the memory use remains at 1.9GB,
and tomcat stderr logs the following severe messages:
Apr 23, 2015 1:12:24 PM org.apache.catalina.loader.WebappClassLoader
checkThreadLocalMapForLeaks
SEVERE: The web application [/ProVista] created a ThreadLocal with key of type
[org.apache.xmlbeans.XmlBeans$1] (value
[org.apache.xmlbeans.XmlBeans$1@3c59c852]) and a value of type
[java.lang.ref.SoftReference] (value [java.lang.ref.SoftReference@2b19a30e])
but failed to remove it when the web application was stopped. Threads are going
to be renewed over time to try and avoid a probable memory leak.


Test-case2:

Configuration:
    Apache Tomcat 7.0.61
    JDK 1.7.0_79
    POI-3.11
Code: 
    // open a 6.2MB xlsx file containg 910,000 rows data 
    Workbook wb = new XSSFWorkbook(new File("file_name")); 
    wb.close(); 

Test-case-2 result: memory-use: 1.8GB (doesn't release after closing workbook).
On subsequently re-opening the same workbook the memory use remains at 1.8GB

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message