I installed German version of LibeOffice Workflow to reproduce issue: 1. Open large CSV file (approx. 650K rows) 2. replace text string 'NA' with '' (empty string) in whole file 3 Calc crashes with error message: "Fatal error: bad allocation"
Also tested with 4.1.5.3.: Same behaviour (AppCrash) except different message (Close App/search online for solution/...) br, WM
Hi, can you please attach a test file to reproduce this problem?
Created attachment 97461 [details] Test data - Part1 Test CSV file attached. br, WM
Created attachment 97462 [details] Test data, Part2 Part2
W. Muellner: rar isn't well managed on some envs, would it be possible you use zip + this page https://wiki.documentfoundation.org/QA/Bugzilla-Attachments (useful for files > 3MB)
Created attachment 97484 [details] Testcase with LESS data - still crashes This is approx. 1/4th of the data, still crashes with same workflow...
I also observed a crash by using a "multiple search & replace" on a string in a .csv file imported into Calc, version 4.2.x. Unfortunately I did not remember the exact subversion I was using (maybe 4.2.1), neither I can provide my file to test. This comment wants to be just an indirect confirmation in support to what W.Muellner reported. My version of LibO is the US one and my environment is Win 7 64 bit. Cheers, Leopoldo Saggin aka Topoldo
On pc Debian x86-64 with master sources updated yesterday, I waited for some minutes and didn't reproduce this. BUT, I've got 6GB and above all master sources have several memory leak fixes. Markus: I thought that perhaps you were still searching for big data files/use cases, so put you in cc.
Just tested once more with newest LibO Version (4.2.4.2) using the smaller file from my attachments here (most recent attachment). Still crashes with message (after crash, and in German): "Application has crashed..." and offering to recover the document. My environment: Windows7 Ultimate 64bit, 16GB Ram, Intel i7-860 processor regards, Walter
Version indicates the earliest version the bug can be reproduced. (see https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Version) Put it at NEW since Leopoldo confirmed in comment 7
I found, that searching and replacing content in a (uncertain where the limit is) large number of cells, CALC v. 4.3.0.2 seems to go into an endless loop. Quite annoying as I first thought it just takes some time and waited for the program to finish the job... Could it be that the list of replacement results (that i find useless anyway) that would become huge, produces some overflow error?
Please report for LO 4.3.5 and also 4.4.0 with regard to Bug 79422 and Bug 83141.
Following Timur's comment, I put it NEEDINFO.
Hu! I tested with the smaller csv (1.5MB) on the current 4.3.5.2 release, under win7 Ultimate, International version, set to use Swedish, 64-bit, and it still craches with the respose: "Libreoffice has stopped working". When I click on the pop-up generated to get more information I get this list (sorry it's in Swedish): Problemsignatur: Problemhändelsens namn: APPCRASH Programnamn: soffice.bin Programversion: 4.3.5.2 Programtidsstämpel: 548b440e Namn på felmodul: KERNELBASE.dll Modulens version: 6.1.7601.18409 Tidsstämpel för felmodul: 53159a86 Undantagskod: e06d7363 Undantagsförskjutning: 0000c42d OS-version: 6.1.7601.2.1.0.256.1 Språkvariant-ID: 1053 Ytterligare information 1: de7a Ytterligare information 2: de7a2bfc3e0a22039c4ff243444c0c9a Ytterligare information 3: aef1 Ytterligare information 4: aef1ebc4504b2e15aa6f5ca814040bd2 I you speak German to can probably understand most of it. This bug doesn't occur in OpenOffice 4.1.1 (I just tested it on Win7 Ultt-64-bit other PC.) I will test this on opensuse/libreoffice 4.1 later tonight(if I have time - otherwise later). I have seen similar problems with editing of large datasets like this in libreoffice (I dump csv from mysql and need to fix some details using calc before analysis in R). My current "fix" has been to run OO 4.1 - now verified on this testcase also! Best Per
Per, could you check 4.4.0.2 as well? http://www.libreoffice.org/download/pre-releases/
(In reply to foss from comment #15) > Per, could you check 4.4.0.2 as well? > http://www.libreoffice.org/download/pre-releases/ OK, I will do this tonight. I've just tested the small csv on opensuse 13.1 using LO 4.1.6 - works OK, but is somewhat slow (still acceptable). Best Per
(In reply to Per from comment #16) > (In reply to foss from comment #15) > > Per, could you check 4.4.0.2 as well? > > http://www.libreoffice.org/download/pre-releases/ > > OK, I will do this tonight. I've just tested the small csv on opensuse 13.1 > using LO 4.1.6 - works OK, but is somewhat slow (still acceptable). > Best Per "train.csv" now tested with LO 4.4.0.2 on win7 ultimate 64-bit swedish and it fails with this message (much like 4.3 does): Problemsignatur: Problemhändelsens namn: APPCRASH Programnamn: soffice.bin Programversion: 4.4.0.2 Programtidsstämpel: 54aee95a Namn på felmodul: KERNELBASE.dll Modulens version: 6.1.7601.18409 Tidsstämpel för felmodul: 53159a86 Undantagskod: e06d7363 Undantagsförskjutning: 0000c42d OS-version: 6.1.7601.2.1.0.256.1 Språkvariant-ID: 1053 Ytterligare information 1: 00cc Ytterligare information 2: 00ccc6ce44df1d7060705521c3cebf1d Ytterligare information 3: 3093 Ytterligare information 4: 30934ec3e31539528116278e022a9868
(In reply to Per from comment #17) >.... > "train.csv" now tested with LO 4.4.0.2 on win7 ultimate 64-bit swedish and > it fails with this message (much like 4.3 does): >.... Could you rename your LO directory profile (see https://wiki.documentfoundation.org/UserProfile#Windows) and give it a new try? Indeed, sometimes there's a problem in LO profie directory because of old and buggy remnants.
(In reply to Julien Nabet from comment #18) > (In reply to Per from comment #17) > >.... > > "train.csv" now tested with LO 4.4.0.2 on win7 ultimate 64-bit swedish and > > it fails with this message (much like 4.3 does): > >.... > Could you rename your LO directory profile (see > https://wiki.documentfoundation.org/UserProfile#Windows) and give it a new > try? > Indeed, sometimes there's a problem in LO profie directory because of old > and buggy remnants. I've done that (unfortunately a have performed a security update of win 7 sinse the last test) and the instability problem remains, but I now get a Bad Allocation error, without any details. Restating LO and replacing "NA" with other characters works fine though, it's just the empty string "" (leaving the "Replace by" empty) that kills LO Calc. That may be a key to where to look?
(In reply to foss from comment #15) > Per, could you check 4.4.0.2 as well? > http://www.libreoffice.org/download/pre-releases/ Tested the bug using above train csv test-case. Using development version: libo-44~2015-02-19_23.54.56_LibreOfficeDev_4.4.2.0.0_Win_x86.msi and it worked without problems om win7 ultimate 64bit Swedish(on AMD64 hw) One question though - why does the pop-up still show up after the replace, but empty (no list of replacements)? no big issue, just curious /per
So, according to comment and test. Fixed in 4.4.0.3. Probably a dupe of Bug 79422. (In reply to Per from comment #20) > One question though - why does the pop-up still show up after the replace, > but empty (no list of replacements)? no big issue, just curious /per Interesting, might be a bug, but it should be reported separately after examining the details.