Bug 144975 - LibreCalc macro loop always freezes within 4295 seconds.
Summary: LibreCalc macro loop always freezes within 4295 seconds.
Status: RESOLVED DUPLICATE of bug 128715
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
6.1.5.2 release
Hardware: Other Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-10-07 03:49 UTC by Craig
Modified: 2021-12-06 10:58 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Craig 2021-10-07 03:49:21 UTC
I am running LibreCalc (6.1.5.2) on a Raspberry Pi 4, Raspbian version 10.  Macros that run continuously always freeze sometime within 4,295 seconds. This problem does not happen when running on a Windows PC.  Here is a simple example:

Sub Test
For i = 1 to 5000
    ThisComponent.calculateAll()
    Wait 1000
Next i
End Sub

The sheet I am running this on only has one cell filled with the formula Now(), so I can watch the seconds tick off and see when the macro hangs.

What is really strange is I can run this on two totally disconnected RPi's and the macros on both RPi's freeze at exactly the same time.  Even more strange, the times of day that they fail are always 4,295 seconds apart, no matter when I start the macro.  If it failed at say 1:00 pm, I can restart it anytime with in the next hour and it will fail at 2:11:35 (4,295 seconds after 1:00).  This is completely repeatable.  I asked a friend to try this, and both of our tests failed at exactly the same time.  It doesn't matter if the internal clock is not set correctly, it will still fail at the actual "appointed" time (not necessarily the time on the RPi's clock).
Comment 1 Eike Rathke 2021-10-07 09:45:57 UTC
That sounds much like some 32-bit counter overflow/wrap, 2^32/1000000 = 4294.9
Comment 2 Mike Kaganski 2021-10-07 16:18:48 UTC
I hoped to be able to reproduce it using 32-bit build on Windows; so I have tested both an old version (4.4), and current master (built in 32-bit binary).

Unfortunately, no repro on Windows 32-bit builds.

FTR, versions used for testing were

Version: 4.4.0.3
Build ID: de093506bcdc5fafd9023ee680b8c60e3e0645d7
Locale: ru_RU

and

Version: 7.3.0.0.alpha0+ (x86) / LibreOffice Community
Build ID: 961ebbe9ebd9becdefdeaa5fdea63cb0e7d27443
CPU threads: 12; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: CL
Comment 3 Jan-Marek Glogowski 2021-10-07 17:27:47 UTC
(In reply to Craig from comment #0)
> This problem does not happen when running on a Windows PC.

Please provide the info from "Help >> About LibreOffice" and reset the bug to UNCONFIRMED. Maybe it's VCL specific, or are you running headless?
Comment 4 Craig 2021-10-08 14:53:45 UTC
I have also tried this on Windows without any issue.  The bug shows up when I run on a Raspberry Pi (3 or 4) using Raspbian version 10.


Here is the LibreOffice version detail:

Version: 6.1.5.2
Build ID: 1:6.1.5-3+rpi1+deb10u7+rpt1
CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); Calc: group threaded
Comment 5 Craig 2021-10-08 16:00:32 UTC
I tried to reproduce the bug on a Raspberry Pi4 that was running the beta 64 bit Buster ( 2021-05-07-raspios-buster-arm64).  The bug did not occur. It shows up on the standard latest version of the 32bit operating system:

PRETTY_NAME="Debian GNU/Linux 10 (buster)"
NAME="Debian GNU/Linux"
VERSION_ID="10"
VERSION="10 (buster)"
VERSION_CODENAME=buster
ID=debian
Comment 6 Roman Kuznetsov 2021-12-05 17:46:27 UTC
https://gerrit.libreoffice.org/c/core/+/126379
Comment 7 Jan-Marek Glogowski 2021-12-06 10:58:46 UTC

*** This bug has been marked as a duplicate of bug 128715 ***