Created attachment 201036 [details] Screenshot of spreadsheet with libraOffice "About" showing The solver had run successfully earlier, but I decided to run it again with cell M4 changed from 58% to 70%. Tools->Solver Parameters filled in automatically: Target cell $AG$9 By changing cells $AF$3:$AF$4 Options: Engine: Non-linear Swarm, with parameter 0 for Differential Evolution. Tried it again, after recovery and the crash did not happen. This has been normal behavior for a long time - crashes on 1 in 20 invocations. Recovery always successful. Crash report: https://crashreport.libreoffice.org/stats/crash_details/438c454b-1729-4a72-b6b5-613321fda44d
Hi, can you please share the file with the model you're running? I need to test it locally to see what causes this crash.
Created attachment 201037 [details] Spreadsheet for example of crash in Solver
I ran the model multiple times with 70% efficiency and using the Differential Evolution engine, but could not reproduce the crash. So you said that it happens occasionally, right? It may be an edge case, since it uses random numbers. Ideally this crash should have been caught after bug 162760 was fixed.
I tried to reproduce the bug but was unable to reproduce it. However, solving took quite a long time (about a minute) and the application became unresponsive during the solving process (and I thought it crashed). Eventually the solving finished and the application became responsive again. I tried this multiple times and the behaviour was always the same. Version: 25.2.3.2 (X86_64) / LibreOffice Community Build ID: bbb074479178df812d175f709636b368952c2ce3 CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Vulkan; VCL: win Locale: fi-FI (fi_FI); UI: en-GB Calc: CL threaded
(In reply to JussiS from comment #4) > I tried to reproduce the bug but was unable to reproduce it. However, > solving took quite a long time (about a minute) and the application became > unresponsive during the solving process (and I thought it crashed). The absence of a progress bar showing that the solver is actually running is a separate issue (maybe related to bug 162731). As for the crash itself, let's wait and see if anyone can reproduce it.
This crash is typical of the normal behavior I have had over the last six months. The solver takes 1 minute to run and crashes about 1 in 20 times. In all cases rerunning the solver with the same data has been successful, so it doesn't appear that the crashes are related to the spreadsheet content. And the bug is not reproducible, it occurs randomly. As recovery is always successful, the bug is infrequent and saving the file is much quicker than running the solver so can always be done without penalty, the bug is not a problem in practice. I submitted the bug report because it generated a crash dump and asked me to do so.