Bug 69460 - Copy/Paste of a column in Calc file followed by Cmd-Q causes soffice process to consume all resources
Summary: Copy/Paste of a column in Calc file followed by Cmd-Q causes soffice process ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: Inherited From OOo
Hardware: x86-64 (AMD64) Mac OS X (All)
: high major
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-09-17 10:15 UTC by mercergeoinfo
Modified: 2013-09-17 14:05 UTC (History)
4 users (show)

See Also:
i915 platform:
i915 features:


Attachments
sampling trace (107.54 KB, text/plain)
2013-09-17 13:35 UTC, Alex Thurgood
Details
timer trace (107.54 KB, text/plain)
2013-09-17 13:37 UTC, Alex Thurgood
Details
ODS test document (9.61 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-09-17 13:57 UTC, Alex Thurgood
Details

Description mercergeoinfo 2013-09-17 10:15:43 UTC
This bug actually applies to OpenOffice, NeoOffice and LibreOffice.
When working with csv files in Calc, saving and exiting causes the program to hang but worse than this, it causes OSX to to slow to a halt. I cant access Force Quit by any method, using KILL in the terminal wont work because accessing Terminal, even if running already becomes incredibly slow. The only option is to power off or wait a long, long time.
It only happens if I save and exit in quick succession, without interacting with the program in any way been these actions, i.e. by using cmd-Q directly after saving.
This issue has been around for some time and isn't specific to 10.7 (my OS). Mostly I can avoid it, by clicking somewhere in LibreOffice, but occasionally I forgot and am suddenly dropped into a very slow process of restarting my work flow.
Sorry if this doesn't conform to standard bug descriptions.
Comment 1 Alex Thurgood 2013-09-17 11:00:53 UTC
Sorry, can not confirm on OSX 10.8.4 with LO 4.1.1.2

Please provide details :

OSX version
LO / AOO / NeoOffice version



Alex
Comment 2 mercergeoinfo 2013-09-17 11:14:05 UTC
LibreOffice Version: 4.1.1.2
OSX 10.7.5

But I have had this issue for some time, using OSX 10.6 and many versions of OO/LO/NeoOffice and it is specifically triggered by quitting directly after saving a csv file with "Save as" and "Edit filter settings" even if using the default settings.
Comment 3 Alex Thurgood 2013-09-17 11:15:58 UTC
Also, which CSV export settings are you using ?

A minimum size ODS file which you use to reproduce the problem would be necessary, otherwise we'll be running around all day trying to find out the specific cause.
Comment 4 Alex Thurgood 2013-09-17 11:22:20 UTC
I'm not saying that the behaviour you observed doesn't exist, just that I can't reproduce it, nor have I ever seen this, whether it be with LO, AOO, or Neo, and I've gone through 3 OSX upgrades in as many years from 10.6, to 10.7 and now to 10.8.

This would indicate on the face of it that there is something specific, either in your configuration files, or in the data that you are attempting to export, which causes the problem.


Alex
Comment 5 Alex Thurgood 2013-09-17 11:29:39 UTC
Just tried with 

AOO400m3(Build:9702)  -  Rev. 1503704
2013-07-16 14:51:10 (Tue, 16 Jul 2013)

No hang there either.
1) Start OOo app
2) Open new Calc document
3) Enter some text in A1
4) Enter some numbers in B1
5) Enter a number with decimals in C1
6) Enter a date in D1
7) Save as CSV - choose default export options
8) OpenOffice main menu > Quit

I did exactly the same with LO.

You need to provide us with that kind of detail, so we can try and reproduce.
Comment 6 mercergeoinfo 2013-09-17 11:42:38 UTC
Use cmd-Q to quit, no interaction with NO's GUI, that's what triggers it. I can avoid the crash by quitting via the menu but sometimes I'm in my "flow" and just use keyboard shortcuts, forgetting that disaster awaits.
Comment 7 mercergeoinfo 2013-09-17 11:51:52 UTC
So, tried again and had some difficulties  but managed to get a close match to the behaviour.
csv file of 1kb
Open in LibreOffice
Swap two columns
Save as
Edit Filter Settings
Press Enter key to save then cmd-Q to quit

I had prepared beforehand by closing everything else down and having the Force Quit window open. This eased the problem but it certainly triggered a crash in LO

Re previous comment about config file: I always clean install so it seems unlikely. Also, I think, though I cant be certain, that I had this issue with OO on 10.5
Comment 8 Alex Thurgood 2013-09-17 13:08:22 UTC
OK, I can reproduce now, but only :

- if I import an existing CSV file ;
- if I copy and paste one or more columns to another column position ;
- then use Cmd-Q to quit the application

Memory consumption of the soffice process steadily climbs over time, seemingly as 5 or 6 threads are polled/respawned, and memory continuously allocated.


Changing title to reflect findings.


Alex
Comment 9 Alex Thurgood 2013-09-17 13:10:18 UTC
Adding Markus, Kohei, and Eike to CC

Lifecycle memory allocation problem ?


Alex
Comment 10 Alex Thurgood 2013-09-17 13:18:08 UTC
Correction : after more testing, the problem can be reproduced with native ODS Calc documents too.
Comment 11 Alex Thurgood 2013-09-17 13:35:05 UTC
Created attachment 85983 [details]
sampling trace

Sample trace after Cmd-Q with soffice process still running
Comment 12 Alex Thurgood 2013-09-17 13:37:19 UTC
Created attachment 85984 [details]
timer trace

timings of process threads/calls after Cmd-Q is issued and soffice process still running
Comment 13 Alex Thurgood 2013-09-17 13:56:55 UTC
How to reproduce :

1) Open attached ODS test file
2) Select a whole column by clicking on column header
3) Copy/paste any column to another empty column
4) Save
5) Quit the application (Cmd-Q or LibreOffice > Quit)

Watch how the soffice process remains running, maintaining 5 or 6 threads, consuming processor availability til it hits 100%, at which point the OSX process monitor kicks in and states that the application is no longer responding. The processor occupancy drops, but memory continues to be allocated to the soffice process.



Alex
Comment 14 Alex Thurgood 2013-09-17 13:57:26 UTC
Created attachment 85988 [details]
ODS test document
Comment 15 Alex Thurgood 2013-09-17 13:59:14 UTC
Upping priority as the only way to escape this is to force kill the application.
Comment 16 Alex Thurgood 2013-09-17 14:00:45 UTC
I have only tested this back to LO 3.3.4, so can't say at the moment whether it does go back to OOo times
Comment 17 Alex Thurgood 2013-09-17 14:05:37 UTC
Confirming also in OOo 3.2.1. Changing version back to Inherited from OOo


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.