You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2023/02/02 09:47:54 UTC

[Bug 66461] New: OOM occurs when the file is read.

https://bz.apache.org/bugzilla/show_bug.cgi?id=66461

            Bug ID: 66461
           Summary: OOM occurs when the file is read.
           Product: POI
           Version: 5.2.2-FINAL
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: POI Overall
          Assignee: dev@poi.apache.org
          Reporter: 572312204@qq.com
  Target Milestone: ---

Created attachment 38494
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=38494&action=edit
Memory change for reading 2 MB files

FileInputStream fis = FileUtils.openInputStream(importFile);
Workbook workbook = WorkbookFactory.create(fis);
When an Excel file is read, the size of the importFile file is only 2 MB, but
the workbook occupies more than 300 MB memory. As a result, OOM occurs. Can you
optimize the file reading, which is similar to the SXSSFWorkbook and reads some
lines?

-- 
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

[Bug 66461] OOM occurs when the file is read.

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=66461

Axel Howind <ax...@dua3.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO

--- Comment #1 from Axel Howind <ax...@dua3.com> ---
More information is needed: What format is the Excel file in (i.e. xls or
xlsx)? How many columns/rows are in the excel file? Can you provide the Excel
file? What happens if you increase VM memory?

-- 
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

[Bug 66461] OOM occurs when the file is read.

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=66461

cheng333 <57...@qq.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |All

-- 
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

[Bug 66461] OOM occurs when the file is read.

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=66461

Axel Howind <ax...@dua3.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |RESOLVED
         Resolution|---                         |DUPLICATE

--- Comment #2 from Axel Howind <ax...@dua3.com> ---


*** This bug has been marked as a duplicate of bug 66460 ***

-- 
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