Bug 492287

Summary: Skrooge 2.32.0 freezes while opening existing .skg files, but import is fast
Product: [Applications] skrooge Reporter: Lassi Väätämöinen <lassi.vaatamoinen>
Component: generalAssignee: Stephane MANKOWSKI <stephane>
Status: RESOLVED FIXED    
Severity: normal    
Priority: NOR    
Version: unspecified   
Target Milestone: 25.1.0   
Platform: openSUSE   
OS: Linux   
Latest Commit: https://invent.kde.org/office/skrooge/-/commit/12de0ee9e2dd0f2614ce4af3cfef017253b88e35 Version Fixed In:
Sentry Crash Report:

Description Lassi Väätämöinen 2024-08-27 21:51:23 UTC 
Skrooge version 2.32.0.

SUMMARY
Skrooge freezes while opening an existing .skg file, regardless if opening during Skrooge startup or opening after Skrooge as been started.

Also, after opening Skrooge complains that "database disk image is malformed". From console:

##WARNING: SELECT DISTINCT t_object_table FROM doctransactionitem WHERE (rd_doctransaction_id=0) ORDER BY t_object_table COLLATE NOCASE
##         returns :database disk image is malformed Unable to fetch row
##WARNING: UPDATE doctransactionitem set rd_doctransaction_id=13 WHERE rd_doctransaction_id=0;
##         returns :database disk image is malformed Unable to fetch row

But also other SELECT clauses have been observed in other cases.


STEPS TO REPRODUCE
1. Open Dolphin and  open an existing .skg file
2. Observe Skrooge splash screen appear.  
3. Wait until project loads

OBSERVED RESULT
Splash screen stuck at 25/25, opening unit plugin. Goes grey.
After that splash screen either disappears and nothing happens, or Skrooge opens with "Untitled" project, and theres a red notification about failed database transactions.

EXPECTED RESULT
Skrooge opens normally with existing project.

SOFTWARE/OS VERSIONS
Operating System: openSUSE Tumbleweed 20240826
KDE Plasma Version: 6.1.4
KDE Frameworks Version: 6.5.0
Qt Version: 6.7.2
Kernel Version: 6.10.5-1-default (64-bit)
Graphics Platform: Wayland
Processors: 12 × AMD Ryzen 5 3600 6-Core Processor
Memory: 31,3 GiB of RAM
Graphics Processor: AMD Radeon RX 580 Series
Manufacturer: Micro-Star International Co., Ltd.
Product Name: MS-7B79
System Version: 4.0


ADDITIONAL INFORMATION
Last time when I used Skrooge on 11th August, the same projects worked fine. Now they don't.

Also, noticed that the hidden .*.skg.wrk files are slowly growing during startup, maybe 200KB every second or so. Eventually the .skg.wrk file size is about 57,7MB for a particular project, but the .skg file size originally is 672 KB.

Also, after Skrooge says "database disk image is malformed Unable to fetch row", user can create a new Untitled project and the previously failed .skg project can be imported via File -> Import, and the import process is instantaneous. But then reopening this new project is slow again, and fails similar to the previous one.
Comment 1 Lassi Väätämöinen 2024-08-28 17:38:41 UTC 
I tried on another system, and same thing happened there with this particular file. There should be nothing too special there. Only special things were about a dozen timed, repeated transactions. And there has been a due date for all of them between the previous usage date 11th August and today (28th Aug.)
Comment 2 Stephane MANKOWSKI 2024-08-30 21:11:14 UTC 
Hi,

Could you generate an anonymized file (see Tool / Anonymize) ?
If you have the same issue with the anonymized file, could you send me it by email (you can find my email address in the "About" of Skrooge) ?

The aim of this request is to be able to reproduce this issue to be able to analyze it.

Regards.
Comment 3 Lassi Väätämöinen 2024-09-01 18:57:47 UTC 
(In reply to Stephane MANKOWSKI from comment #2)
> Hi,
> 
> Could you generate an anonymized file (see Tool / Anonymize) ?
> 
> The aim of this request is to be able to reproduce this issue to be able to
> analyze it.

Sure, I also did check some traces by setting the debugging environment variables, and I saw at least some errors for the recurring transactions. But I'll do the anonymous file once I'm back at my desktop.
Comment 4 Stephane MANKOWSKI 2024-09-09 20:38:31 UTC 
Git commit 12de0ee9e2dd0f2614ce4af3cfef017253b88e35 by Stephane MANKOWSKI.
Committed on 09/09/2024 at 20:38.
Pushed by smankowski into branch 'master'.

Skrooge 2.32.0 freezes while opening existing .skg files, but import is fast

M  +1    -0    CHANGELOG
M  +1    -0    plugins/skrooge/skrooge_scheduled/skgscheduledplugin.cpp
M  +4    -2    skgbankmodeler/skgoperationobject.cpp
M  +7    -0    tests/skgbankmodelertest/skgtestrecurrent.cpp

https://invent.kde.org/office/skrooge/-/commit/12de0ee9e2dd0f2614ce4af3cfef017253b88e35