Bug Hunting Session
Bug 93409 - Memory leak when setting cell value from a macro: EDITING
Summary: Memory leak when setting cell value from a macro: EDITING
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Memory
  Show dependency treegraph
Reported: 2015-08-13 12:40 UTC by Mikhail Zemlyanukha
Modified: 2019-01-11 13:01 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

crash popup message (80.19 KB, image/jpeg)
2015-08-13 12:40 UTC, Mikhail Zemlyanukha

Note You need to log in before you can comment on or make changes to this bug.
Description Mikhail Zemlyanukha 2015-08-13 12:40:06 UTC
Created attachment 117890 [details]
crash popup message

This bug was reported by my customer for LibO Calc on MS Windows platform. 

I tested it in a daily build Build ID: 9ef671364ff9fbb552a5433053af9283d12d90c7 on Linux platform, and it seems to be reproducible there as well. I saw increasing memory usage by soffice process, using 'ps' tool. My customer reports that LibO crashes when all memory goes away, reporting an com.sun.star.uno.RuntimeException, screen shot attached

I tested on Version: Build ID: Arch Linux build-1 and I do _not_ observe the issue there (ps command doesn't show that memory usage by soffice increases).

Steps to reproduce:

1. Launch LibO calc
2. create following macro:
Sub Main
  Sheet = thisComponent.Sheets("Sheet1")
  For i =0 to 10000000
      dann ="42202705"
      Sheet.getCellByPosition(0, 0).String = dann & "   i=" & i
  Next i
End Sub
3. run the macro
4. observe memory usage with 
ps -aef |grep soffice

in some time RAM goes out and LibO crashes
Comment 1 Mikhail Zemlyanukha 2015-08-13 12:41:56 UTC
These bugs may be related: #88006 #93392
Comment 2 Mikhail Zemlyanukha 2015-08-13 12:50:52 UTC
My customer says that the issue is _not_ reproducible in OpenOffice 4.1.1 on MS Windows
Comment 3 raal 2015-08-20 18:49:33 UTC
I can not confirm with Version:
Build ID: 6b7354ae66db40246a09e00aa876443057655a43
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2015-08-19_01:05:16

After ~3 hours of run macro ended without crash, "42202705   i=10000000"
Comment 4 raal 2015-08-20 18:59:53 UTC
But soffice takes 50% of memory (6GB of RAM)
Comment 5 Mikhail Zemlyanukha 2015-08-21 19:13:30 UTC
I didn't saw the crash on LibO 5.1 master branch either, just increasing memory usage.

Did you test with patch for https://bugs.documentfoundation.org/show_bug.cgi?id=93392 integrated? I feel it may fix the issue.
Comment 6 Mikhail Zemlyanukha 2015-08-21 19:30:02 UTC
Hm, I see from source code that the fix for #93392 does not affect current case, it's for HTML parsing.

And I tested against the latest /daily/master/Linux-rpm_deb-x86_64@70-TDF-dbg/2015-08-21_07.14.55 and it behavior remains the same.
Comment 7 QA Administrators 2016-09-20 10:26:00 UTC Comment hidden (obsolete)
Comment 8 Noel Grandin 2018-03-26 13:13:37 UTC
I can't reproduce this leak with current master on Linux.
Comment 9 Julien Nabet 2018-11-14 14:24:13 UTC
Mikhail/Raal: following Noel's comment, do you reproduce the memory leak with 6.1.3?
Comment 10 Mikhail Zemlyanukha 2018-11-14 15:18:58 UTC
Yes, the issue still reproduces in LibO - running macro eats RAM indefinitely.
Comment 11 Mikhail Zemlyanukha 2018-11-14 15:38:10 UTC
Build ID: 6.1.3-1
CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); Calc: group threaded

From Arch Linux distro