https://bugs.kde.org/show_bug.cgi?id=492287

            Bug ID: 492287
           Summary: Skrooge 2.32.0 freezes while opening existing .skg
                    files, but import is fast
    Classification: Applications
           Product: skrooge
           Version: unspecified
          Platform: Other
                OS: Linux
            Status: REPORTED
          Severity: normal
          Priority: NOR
         Component: general
          Assignee: steph...@mankowski.fr
          Reporter: lassi.vaatamoi...@gmail.com
  Target Milestone: ---

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.

-- 
You are receiving this mail because:
You are watching all bug changes.

Reply via email to