Bug 58690

Summary: creating a chart hangs the system.
Product: LibreOffice Reporter: OldETC <hlhowell>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED INVALID    
Severity: critical CC: jorendc, miguelangelrv
Priority: medium    
Version: 3.5.7.2 release   
Hardware: x86-64 (AMD64)   
OS: Linux (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: columns to describe a phasing ssb exciter signal

Description OldETC 2012-12-23 19:19:20 UTC
Starting with this version of Calc (Spreadsheet) any of my technical chargs hangs the system.

The spreadsheet is always destroyed, so I have to show you the data as below.

Example:

row     cell name     value
1       a1   phase1  =0/57.3
2-2049  a2            =sin(2*PI()*(row()-2)*5/2048+phase1)
1       b1  phase2    =0/57.3
2-2049  b2            =sin(2*PI()*(row()-2)*100/2048+phase2)
1       c1 phase3    =90/57.3
2-2049  c2            =sin(2*PI()*(row()-2)*5/2048+phase3)
1       d1 phase4   =90/57.3
2=2049  d2           =sin(2*PI()*(row()-2)*100/2048+phase4)

when done, these will have the numerical representations of 4 sinewaves, 2 at 5 cycles, 2 at 100 cycles

Multiply them to get a double sideband signal:

1       e1            DSBI       
2:2049  e2            =a2*b2
1       f1            DSQQ
2:2049  f2           =c2*d2

Add these two waves to get a single sideband wave

1      g1             SSB
2:2049 g2             e2+f2

chart1  show the sigle sideband result:

data series    $sheet1.$g1
data range     name: $sheet1:$g$11
               yvalues: $sheet1:$g$2:$g$2049

As I finish entering the range and hit return, the sheet hangs for minutes, and one processor goes to 100% the whole time.

After waiting about 10minutes I terminate the program.

Fedora 17 AMD64 Phenom 6 processor system with 8G or RAM.
Kernel Linux 3.6.10-2.fc17x86+64
GNOME 3.4.2
memory 7.8GiB
Processor: AMD Phenom(tm) II X6 1035^ processor x 6
Available disk Space 347.1GiB

LibreOffice 3.5.7.2
buildID: 359m1(build:2)
Comment 1 m_a_riosv 2012-12-24 01:47:23 UTC
Hi OldETC, thanks for reporting.

Please can you attach a file sample, with the data.
Comment 2 Jorendc 2012-12-29 17:24:31 UTC
(In reply to comment #1)
> Hi OldETC, thanks for reporting.
> 
> Please can you attach a file sample, with the data.

Status of bug -> NEEDINFO
Comment 3 OldETC 2012-12-30 18:04:08 UTC
Created attachment 72310 [details]
columns to describe a phasing ssb exciter signal

This is the data only.  The chart would use the column G and should show a sine wave signal.  The other two charts should show a waveform like a string of pearls.
These are for columns E and F.
Comment 4 Jorendc 2012-12-30 18:15:12 UTC
Comment on attachment 72310 [details]
columns to describe a phasing ssb exciter signal

Changed mime type to application/vnd.oasis.opendocument.spreadsheet
Comment 5 Jorendc 2012-12-30 18:21:16 UTC
(In reply to comment #0)
> chart1  show the sigle sideband result:
> 
> data series    $sheet1.$g1
> data range     name: $sheet1:$g$11
>                yvalues: $sheet1:$g$2:$g$2049

I'm not that familiar with Calc and databars, but what's the result when you set yvalues as '$g$2:$g$2049'in stead of '$sheet1:$g$2:$g$2049'?

I can't reproduce hanging/crashing on Mac OSX 10.8.2 and LO 4.0b2.
Comment 6 OldETC 2012-12-31 17:43:47 UTC
The system fans come on, the system slows down greatly, Calc seems frozen, but I can activate other windows using the activities button.  I tried taking a screen shot, but that was three minutes ago, and the file doesn't exist yet.  Slowed way down.  

It has now been 10 minutes, and the screenshot file still doesn't exist.  I have no idea what calc is doing.  There doesn't seem to be any disk activity, nor do I get any error messages, nor does the system actually apear hung, only Calc has stopped responding, not even the cancel button on the create chart window.

I really need this to work, I am in the middle of creating two large documents.

Do you have any suggestions to debug this?  Can I maybe invoke calc from the command line with some debug arguments to get more error messages or something?

OK, some progress has been made.  twenty minutes to do the one chart.  This is new, before it would not even generate the chart and sometimes would completely crash the system.

I can still debug the issue if there is some command to let me see some log of the chart applications operations.

I guess I could change the error to "SLOWS the chart application tremendously"

But this is still unconscienable on a 3.2GHz 6 processor system.  And since I need about 50 charts for each book, how long would that take?
Comment 7 Linus Drumbler 2013-01-21 20:25:34 UTC
Attempted to reproduce on Windows 7, LO version 3.6.4. I don't know enough about using spreadsheets to enter the series and range, so I couldn't complete the crucial operation. However, I had the task manager open at the time, and as I gave up trying and closed Calc I noticed that there had been enormous spikes in the CPU usage as I was working. I hope this offers some help.
Comment 8 m_a_riosv 2013-01-21 20:45:44 UTC
I can not reproduce.
Windows7x64 Ult.
LibreOffice 3.5.7.2 Build ID: 3215f89-f603614-ab984f2-7348103-1225a5b.

No delays, no high cpu usage.

Maybe two tries.
Change the memory settings in:
Menu/Tools/Options/Memory, default is very low.

Resetting the user profiles, sometimes solve strange issues.
https://wiki.documentfoundation.org/UserProfile
Comment 9 OldETC 2013-01-22 17:11:42 UTC
changing the reference method and deleting the profile, together or individually, do not affect the problem.

I have a workbook I created a long time ago with many sheets and multiple charts but no function calls other than sum or average, and that works very well.  Even after saving it or modifying one of the charts (although modifying a chart now takes about 3x as long as when I originally prepared the sheet in F14)  The same is true of one I created in F16, it works but much slower.
Comment 10 m_a_riosv 2013-01-22 21:37:07 UTC
Hi @OldETC,
If memory settings do not solve the issue, have you try changing the settings in Menu/Tools/Options/LibreOffice/View - Graphics output.

I remember have seen some comments about troubles with graphics cards, time ago. Looking for something, I have found this thread: http://forums.fedoraforum.org/showthread.php?t=280450
Comment 11 Petr Mladek 2013-01-23 16:59:51 UTC
Hmm, 3.5 version is pretty old and not longer supported. Could you please try the version 3.6?

I do not see the problem with LO-3.6. It takes few seconds to draw the chart. The memory usage is less than 1GB and it does not increase too much when creating the chart.

Such hard to reproduce bugs can't block the release => lowering the severity a bit.

Do you see the same problem with the last LO-3.6 release, please?
Comment 12 QA Administrators 2013-09-24 01:54:38 UTC
Dear Bug Submitter,

This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information.

For more information about our NEEDINFO policy please read the wiki located here: 
https://wiki.documentfoundation.org/QA/FDO/NEEDINFO

If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed.


Thank you for helping us make LibreOffice even better for everyone!


Warm Regards,
QA Team
Comment 13 QA Administrators 2013-10-25 15:13:17 UTC
Dear Bug Submitter,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INVALID due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided):

a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. 
Please do not:
a) respond via email 
b) update the version field in the bug or any of the other details on the top section of FDO