From user-return-23230-archive-asf-public=cust-asf.ponee.io@poi.apache.org Thu Nov 1 01:19:10 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id D00EB18065D for ; Thu, 1 Nov 2018 01:19:09 +0100 (CET) Received: (qmail 89995 invoked by uid 500); 1 Nov 2018 00:19:08 -0000 Mailing-List: contact user-help@poi.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "POI Users List" Delivered-To: mailing list user@poi.apache.org Received: (qmail 89978 invoked by uid 99); 1 Nov 2018 00:19:08 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Nov 2018 00:19:08 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id B1FB41A0F48 for ; Thu, 1 Nov 2018 00:19:07 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 3 X-Spam-Level: *** X-Spam-Status: No, score=3 tagged_above=-999 required=6.31 tests=[HTML_MESSAGE=2, KAM_LAZY_DOMAIN_SECURITY=1, RCVD_IN_DNSWL_NONE=-0.0001] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id jen1WURMzOkE for ; Thu, 1 Nov 2018 00:19:06 +0000 (UTC) Received: from mout.kundenserver.de (mout.kundenserver.de [212.227.126.187]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 103385F1D3 for ; Thu, 1 Nov 2018 00:19:05 +0000 (UTC) Received: from ryzen ([183.88.9.149]) by mrelayeu.kundenserver.de (mreue010 [212.227.15.167]) with ESMTPSA (Nemesis) id 1MS43X-1g6i0P3e7n-00TS8c for ; Thu, 01 Nov 2018 01:18:59 +0100 Received: from ryzen ([183.88.9.149]) by mrelayeu.kundenserver.de (mreue010 [212.227.15.167]) with ESMTPSA (Nemesis) id 1MS43X-1g6i0P3e7n-00TS8c for ; Thu, 01 Nov 2018 01:18:59 +0100 Message-ID: Subject: Re: POI 4.0 SXSSF: This archive contains unclosed entries From: Andreas Reichel To: user@poi.apache.org Date: Thu, 01 Nov 2018 07:18:40 +0700 In-Reply-To: References: <872c57c41da2e1e1dc714c43dc3ce0ca59b60b51.camel@manticore-projects.com> <6c91fc226657203964f2918d2bc8e7ac38105f1d.camel@manticore-projects.com> Content-Type: multipart/alternative; boundary="=-VAp42Sqp7JI43nMa3TZY" User-Agent: Evolution 3.30.2 Mime-Version: 1.0 X-Provags-ID: V03:K1:rmORd94LJxymcAzIYq5D8JmCLinWGV72dgtiwlgnrNVJDQMKwLP 8v37esRgfeTbNe49Ks7YCXipHlgVJWY/EniFupqmu+A8eMaus4sIit1Oiz74YWtrCsWt7mM hTJUoFKV6etyMTwBYzOCViOsMJG+WLhB+6wGLtb4i4jGVjZgBYBb3902kDgR87bcqOU2unx 8bsSpytSeDqEkCjmm3Lgw== X-UI-Out-Filterresults: notjunk:1;V01:K0:RUm2qdoXMIA=:kxR30RYiBYGGwiMGCtkXfJ uKOJLsNYTbsUlF8nDe68ConMnrxU4LWMsbOnT6aN81iYjVL665e6j5ncOsZBouyce6TU0BPh5 anvfDy8KOhYQljlIpTCgEyyHuAE2/KRLn9UwDuvpiU53dUSJKI4ukeXYthENXaEAUsWk4qFOc OVmMb6fb64uf0qiwKzn3CXm2Go2oBced82EnKk2pPwAxoJ2M/FAFQTIgdfnwsIxl2jnvcQOS4 R4WrSpDKhsLtenpeiA5S2ANAGHvVYIqxV4TqUkZq/b6axynhaLZtCm8g8PHKz3p3fpCL/Jy0Z k9jc8Gg13bwq/bjz6WD6jbrzC05oSHORjeEWns6jLb7wr+zFnyJozWsF3wjzhw0uCx25ZkYOS FcdXf3OPiu6ulRbTIvtlyxx1ow+bt33mFWgFjRsxx5eDIc3gUZm/vVMuNcBRZkaT+3AvRsCOI k9SpAmIIWSZbZtBfMLSGiMC8SQDQE1vYT00TGgJRgr5nsuqY+dJMWkbf2FHwxzZGH80g2gFci MHiQdvSp4uUW8ze7VODnSlipHD5f1jR9tRu9iMXzMRzH7gltz+EjjtC9q7vQPMS/BPoCN9HRI sboio/xz4kLIZYhoG37Obj3KGBG5IG+XxI4yWqfTghy8K24xqsG0+f8CiXPvFJEBOTj0P6KAb SFR/TzpsYO6rusG01O2htaBRky+T3l/p3Y6ogwFg/5klXKa2HIyDBL+zRvVJGnIUhHwmfuUkX BGw48caIKIY2rww9 --=-VAp42Sqp7JI43nMa3TZY Content-Type: text/plain; charset="ISO-8859-15" Content-Transfer-Encoding: 7bit Thank you very much Dominik, I have captured the bug report 62872 with a very simple test case.Best regards and cheers Andreas On Wed, 2018-10-31 at 20:09 +0100, Dominik Stadler wrote: > Hi, > Thanks for the report, sounds like a problem introduced by moving > frompure-Java ZIP to the ZIP-classes from commons-compress (this was > necessaryfor Zip-Bomb-Protection with newer Java versions). > However I could not reproduce this with a quick test, also our > defaultperformance-test in class SSPerformanceTest does not show this > problem whencalled with "SXSSF 300000 20 1", so there seems to be > something more thatis needed to trigger the exception. > Maybe you are closing something too early here, e.g. the workbook > itself? > If you can provide a ready-to-run sample then please open a bug- > report athttps://bz.apache.org/bugzilla/ and include some code that > you use totrigger this? > Thanks... Dominik. > On Wed, Oct 31, 2018 at 3:08 PM Andreas Reichel < > andreas@manticore-projects.com> wrote: > > We have tested our particular use case 3 times each with 4.0 and > > 3.17(exactly the same code, exactly the same data). While 3.17 > > works w/oany adjustments, 4.0 throws this error and leaves an > > invalid XLSX file.Best regardsAndreasOn Wed, 2018-10-31 at 18:42 > > +0700, Andreas Reichel wrote: > > > Dear All,the new 4.0 seems to have a problem when writing large > > > XLSX files(e.g. >100k rows but less than 1 Mill. rows) using > > > SXSSFWorkbook:java.io.IOException: This archive contains > > > unclosedentries. atorg.apache.commons.compress.archivers.z > > > ip.ZipArchiveOutputStream.finish(ZipArchiveOutputStream.java:467) > > > atorg.apache.poi.xssf.streaming.SXSSFWorkbook.injectData( > > > SXSSFWorkbook.java:406) atorg.apache.poi.xssf.streaming.SX > > > SSFWorkbook.write(SXSSFWorkbook.java:936)Please note, small files > > > (e.g. less than 100k rows seem to work fine)and also everything > > > works fine with 3.18 (same code, same data).Also,other people > > > seem to have this problem: > > https://stackoverflow.com/questions/53080171/java-apache-poi-and-large-result-set-from-db2-runs-into-exception > > > My suspision is that the Workbook is closed before the ZIP stream > > > isready?Thank you already for helping, best regardsAndreas --=-VAp42Sqp7JI43nMa3TZY--