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.
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.)
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.
(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.
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