[Bug 63482] New: Application hang because of autoSizeColumn

classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

[Bug 63482] New: Application hang because of autoSizeColumn

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=63482

            Bug ID: 63482
           Summary: Application hang because of autoSizeColumn
           Product: POI
           Version: 4.0.0-FINAL
          Hardware: PC
            Status: NEW
          Severity: critical
          Priority: P2
         Component: XSSF
          Assignee: [hidden email]
          Reporter: [hidden email]
  Target Milestone: ---

I have a problem with autoSizeColumn with small number of columns and data.
I have an application which generates XLSX files in different threads.
I have changed the POI version from 3.17 to 4.1.0 and the application became to
hang on the autoSizeColumn(sheet, true) line.
When I had removed this line or had changed to sheet.setColumnWidth(i,
SMALL_COLUMN_WIDTH) the problem was resolved.

There aren't excpetions in the log file!


-----Versions-----

1) OS: Windows 10

2) Java
java version "11.0.3" 2019-04-16 LTS
Java(TM) SE Runtime Environment 18.9 (build 11.0.3+12-LTS)
Java HotSpot(TM) 64-Bit Server VM 18.9 (build 11.0.3+12-LTS, mixed mode)

3)
POI version: 4.1.0

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 63482] Application hang because of autoSizeColumn

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=63482

Vladimir <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |Windows 10

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 63482] Application hang because of autoSizeColumn

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=63482

Vladimir <[hidden email]> changed:

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

--- Comment #1 from Vladimir <[hidden email]> ---
Small clarification: autoSizeColumn() works fine wit POI version 3.17 and Java
8

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 63482] Application hang because of autoSizeColumn

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=63482

Dominik Stadler <[hidden email]> changed:

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

--- Comment #2 from Dominik Stadler <[hidden email]> ---
Can you provide a small sample application which reproduces the problem?
Without it is very hard to investigate such a bug-report.

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 63482] Application hang because of autoSizeColumn

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=63482

--- Comment #3 from Cody Lerum <[hidden email]> ---
I ran into this same issue today when making the move from Java 8 to Java 11
and from POI 3.17 to 4.1.0 and I've narrowed this down to a slowdown with Java
11. It doesn't matter if you are running 3.17 or 4.1.0

When running the simple reproducer (taken from the SSPerformanceTest) below
with POI 4.1.0


Elapsed 2.71 seconds for arguments [HSSF, 5000, 15, 1] on Java 1.8.0_212

Elapsed 35.08 seconds for arguments [HSSF, 5000, 15, 1] on Java 11.0.4

Elapsed 33.27 seconds for arguments [HSSF, 5000, 15, 1] on Java 12.0.1

The situation seems resolved in Java 13

Elapsed 3.44 seconds for arguments [HSSF, 5000, 15, 1] on Java 13


FYI this This is still an issue on the latest nightly pulled from AdoptOpenJDK:

Elapsed 37.13 seconds for arguments [HSSF, 5000, 15, 1] on Java 11.0.5

Commenting out the sheet.autoSizeColumn(i) yields:
Elapsed 0.54 seconds for arguments [HSSF, 5000, 15, 1] on Java 11.0.5



https://gist.github.com/codylerum/5e302c4cd69e133206ddde9e50f44daa

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 63482] Application hang because of autoSizeColumn

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=63482

Cody Lerum <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 63482] Application hang because of autoSizeColumn

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=63482

Axel Howind <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]