if i sort rows with the auto filter function and want to delete the sorted rows, the programs crashes with the error message: bad allocation. I tested this with Win7 64bit and LO 4.2.1.1 german version
Can you provide the document or a document with which we can reproduce the crash you encounter. I can not reproduce: - I fill two columns with data - apply autofilter - delete the data in the second column => no crash. Set as needinfo - Sophie
Created attachment 94761 [details] csv-file to bug75486 zip-file contains only the large csv-file causing the crash
Hi, thanks for the document. Still I can not reproduce with Version: 4.2.1.1 Build ID: d7dbbd7842e6a58b0f521599204e827654e1fb8b Ubuntu 13.10 x64. Set back to unconfirmed - Sophie
I tried again and made screenshots. Please look the pics in the zip file. The error occured after i pressed right mouse button and choosed delete rows. the program worked for a while and then the error message appears.
Created attachment 94769 [details] screen shots for the csv-problem
is there any interest to solve this problem? I have a large ods-file but can not upload it because the size is about 8MByte. The files includes autofilter settings with a large amount of selected rows. Deletung this rows needs about hours.... Thanks for answer
The file is quite big since it's 40MB. Did you check memory consumption during your actions? I gave a try with 4.2 sources updated some days ago (with debug mode) but it's quite long to open it and still more to just save in ods file.
A file with 40Mb is not very large nowadays, the computer i work with has Win7 64Bit and 8GByte RAM, only LO running. I think not that it is a RAM-problem, i think it is a problem in the LO-code.
@Ray123: I do not reproduce the crash in Ubuntu 14.04, libreoffice 4.2.5.2. (My RAM is only 1GB. Althrough it took some time to load the file and process the delete operation, finally it succeeded with no error message) Maybe you can try the latest libreoffice version?
@Ray123: Also for the test, would you please try to reset your user profile to see if it works? For the location of your libreoffice user profile, see this wiki page: https://wiki.documentfoundation.org/UserProfile I set this to NEEDINFO. Once you have tested the reset-user-profile, make your comment here and put it back to UNCONFIRMED
i will do this but it need some days because i am actaully not in office but on a business trip. I try to test this all next week. thanks so far.
I checked this again with a smaller file but big enough anyway with LO 4.2.5.2 and it is working without crash, but still very slow, sorting and deleting need long time :(
So this is actually not a crash, but a performance problem, yes? The program did not crash, correct?
Please, could you confirm that the scenario to reproduce the crash is the following: 1/ open the csv file using semicolon as separator 2/ add autofilter : menu Data > Filter > AutoFilter 3/ go to column V, with the autofilter dropdown uncheck all but ERR and EWE 4/ click the first visible cell : A4 5/ ctrl+shift+End 6/ press Delete key. 7 wait I get a crash with version 4.3.4.0.0+ under Ubuntu 14.04 x86-64 with 4 GB of RAM. Set status to NEEDINFO. Please set it back to UNCONFIRMED once you have provided requested informations. Thank you for your understanding. Best regards. JBF
Same crash with the master Version: 4.4.0.0.alpha0+ Build ID: 6ba7f47de32074895b830e1ef3682fa1d0d1b6be Best regards. JBF
(In reply to Eike Rathke from comment #14) > So this is actually not a crash, but a performance problem, yes? The program > did not crash, correct? Its both, often crash and always very very slow, sometimes the action need about one hour with a core i5 cpu and 8GB Ram.
So, the Fatal Error in the screenshot indicates a crash. I tried to reproduce in master 4.4 1. load .csv with ; semicolon as separator 2. apply AutoFilter on first row 3. in column V (header "Hk") select only "ERR" and "EWE", hit OK 4. select A2:AMJ203409 (whole data range except header row) similar as indicated in "deleting rows.jpg" by using the Name Box (takes veeery looong time) 5. delete rows (takes looong time) but no crash. After the operation completed there were 201096 rows of data. Will try also in 4.3, and maybe non-/selection of row 1 makes a difference, i.e. entire data range including headers vs. data only excluding headers.
I tried with current 4-3 and 4-2 builds but could not reproduce a crash.
(In reply to Eike Rathke from comment #19) > I tried with current 4-3 and 4-2 builds but could not reproduce a crash. Ok, could we say that the crash I reported is caused by a run out of memory? I have only 4 GB of RAM on my PC. Best regards. JBF
Ok, got it, that's the difference: I, delete entire rows, get no crash. You, select only data range and press delete key that does not delete the rows but only the selected content, get a crash, I can reproduce. Loads of memory are comsumed, started to use swap here, all together 8-9GB The original reporter used the delete rows method though..
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.0.4 or later) https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-12-20
Reproducing scenario from comment #15 still crashing with LibreOffice 5.1.0.1.0+ Build ID: f284ec139beb920486e8351f9e758966969349ab CPU Threads: 4; OS Version: Linux 4.2; UI Render: default; Ubuntu_15.10_x86-64 Locale : fr-FR (fr_FR.UTF-8) Best regards. JBF
(In reply to Jean-Baptiste Faure from comment #23) > Reproducing scenario from comment #15 still crashing with LibreOffice > 5.1.0.1.0+ > Build ID: f284ec139beb920486e8351f9e758966969349ab > CPU Threads: 4; OS Version: Linux 4.2; UI Render: default; > Ubuntu_15.10_x86-64 > Locale : fr-FR (fr_FR.UTF-8) > > Best regards. JBF I can't reproduce it in Version: 5.4.0.0.alpha0+ Build ID: e9e6228533b336317aa809a7aaaa4fd1c338d4f7 CPU Threads: 4; OS Version: Linux 4.8; UI Render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); Calc: group Could you please try again with the latest version?
I tested it again with LO 5.1.3.2, it works, no crash but the performance of LO with this file is very poor although the CPU shows only 25% duty and the used memory is only about 2GB of the 8GB memory during the deletion of the rows. LO works about 30 minutes.
Let's put this one to WFM since there's no more crash. Perf issue is another problem.
No crash for me with LO 5.3.2.0.0+ under Ubuntu 16.04 x86-64 with 4Go of RAM. Performance seems correct for my 5 years old i7 computer. Best regards. JBF