Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | DataPilot uses large amounts of memory when selecting multiple "row fields" | ||
---|---|---|---|
Product: | Calc | Reporter: | cpinney <chuck> |
Component: | open-import | Assignee: | oc |
Status: | CLOSED FIXED | QA Contact: | issues@sc <issues> |
Severity: | Trivial | ||
Priority: | P3 | CC: | can4is, issues, kpalagin, kyoshida, ooo, pagalmes.lists, rainerbielefeld_ooo_qa |
Version: | OOO 2.0 Beta2 | Keywords: | crash, oooqa |
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | All | ||
Issue Type: | DEFECT | Latest Confirmation in: | --- |
Developer Difficulty: | --- | ||
Attachments: |
Description
cpinney
2005-09-30 00:39:50 UTC
Created attachment 30016 [details]
DataPilot sample, try changing zip code, Windows memory usage increases over 600MB
Hi Niklas, have a look at this one please. Re-target as needed. Frank *** Issue 69302 has been marked as a duplicate of this issue. *** Confirming with m180 and 2.0.4 RC2 on Windows - just clicking arrow in cell B2 of "DataPilot_Sample.ods" makes soffice.bin start consuming RAM at rate of several MB/s. Once it hits 800MB I have to kill the process to regain control over the machine. Any chance of targeting this for 2.1? hi kpalagin, please don't change the version field of any Issue except your are asked for it by a developer. This field defines the first occurens of the defect and is therefore an important information. If an Issue is assigned to a developer, he has it on his schedule, so if you can give valuable information, just add a comment but do not change any fields. Thanks for your understanding. Frank *** Issue 77341 has been marked as a duplicate of this issue. *** *** Issue 79948 has been marked as a duplicate of this issue. *** Any chance for 3.0? Hm, I was bet on high priority of such issues. Because of this Calc CRASHES working with pivot tables. Is not this the sufficient cause for solving this issue? hello, any chances this issue gets fixed anytime soon? 2.4.1 is still unusable because of this bug (~10krows -> datapilot -> boom: oom a gogo, may even bring down the whole multi-user machine). Pls note that pivot-table/datapilot is a critical feature for any serious calc in biz (and elsewhere). I had high hopes for 2.0.x which seemed to work where 1.x failed on a few 100s rows, but since then all the pivot stuff is left to externals running MS-X (or else, for that matter). Please rise P to no less than P2, this issue is a showstopper for many users, and 3+ years old. tried OOO300m5 build 9350: - calc starts as a 130MB (vm) process - after recovering a 18000 rows by 6 cols + datapilot sheet .ods the vm usage is ~173 MB - refresh datapilot table ... vm skyrockets quickly consuming the 1GB RAM, then swapper kicks in till the whole thing hangs at ~98% cpu, 1600MB vm. - killed after a few mins before going into troubles. That's on Debian Etch (Linux x86 2.6.26.5, libc 2.3.6) Modify OS due to comments from oopla Mon Sep 15. Still a problem with "Ooo 3.0.0 RC3 Multilingual version German UI WIN XP: [OOO300m8 (Build9357)]" Issue 95509 seems to have the same roots like this one. I do not believe that "Later" is an appropriate TM for this issue FWIW, technically it is not a crash as Calc is able to complete operation once it allocates more than 1GB of RAM. Nonetheless, I do not think that such behavior is acceptable. Niklas, please see if you can make Calc use less RAM for this trivial task. Thanks a lot. I have encountered a similar problem with DataPilot in OOo 3.0.0 (Windows XP SP3) when trying to group a small amount of data (4124 rows at 7 columns per row). I took two rows for the filter (page fields) and placed two rows into the row fields. No rows in any other fields. When clicking OK the CPU load is going up to 100% and OOo is starting consuming memory up to 1.5GB. This takes only a few seconds. Then a system sound is played and one time a error message was displayed from DataPilot, but only once. The other times I reproduced the issue no message box was displayed, only the sound. The only way to close Calc now is to kill the process. The hardware is a Toshiba Tecra with 2GB of RAM and an 1.8GHz Intel Centrino. As oopla wrote, this is a no-go for using OOo Calc in any serious data processing, where PivotTables are daily business. I can supply a sample file if needed. Created attachment 65869 [details]
Example file with grouped items, which makes problems
Created attachment 66065 [details]
This file contains two DataPilot tables with numeric groups
Created attachment 66142 [details]
Example with date grouping
Created attachment 66345 [details]
Example file with hidden details for some items
Fixed in CWS "datapilotperf". See also http://wiki.services.openoffice.org/wiki/Calc/Proposal_DataPilot_byIBM Reassigning to QA for verification. verified in internal build cws_datapilotperf ok in DEV300_m76, issue closing Created attachment 73218 |