songs.sqlite will not be downsized when deleting songs
Bug #636835 reported by
rimach
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenLP |
Fix Released
|
Low
|
Tim Bentley |
Bug Description
Do the following steps for easy reproduction. (tested on windows)
1. rename songs.sqlite to songs.sqlite.orig
2. start openlp
3. import songs.sqlite.orig
4. close openlp
5. See in filemanager -> sizeof songs.sqlite
6. do the same steps 2-5 -> size of songs.sqlite is grown (thats correct)
7. start openlp
8. clean all double entries (because of they all existing twice after the second import)
9. close openlp
10. See in filemanager -> sizeof songs.sqlite => its the same size as step 6 (but, we have only the half of entries now???)
Related branches
lp:~trb143/openlp/bugs
- Andreas Preikschat (community): Approve
- Jon Tibble (community): Approve
- Raoul Snyman: Approve
-
Diff: 103 lines (+37/-1)1 file modifiedopenlp/core/ui/maindisplay.py (+37/-1)
Changed in openlp: | |
importance: | Undecided → Low |
status: | New → Confirmed |
milestone: | none → 1.9.4 |
Changed in openlp: | |
assignee: | nobody → Raoul Snyman (raoul-snyman) |
Changed in openlp: | |
assignee: | Raoul Snyman (raoul-snyman) → Tim Bentley (trb143) |
Changed in openlp: | |
status: | Confirmed → Fix Committed |
Changed in openlp: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
Oh I forgot:
11. After renaming the database from step 10, restarting OpenLP and import the database, we have the correct filesize from step 6