Bug 145263 - File size randomly increases Dramatically
Summary: File size randomly increases Dramatically
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-10-21 19:11 UTC by Kurt
Modified: 2022-11-10 15:07 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Small example file (46.01 KB, application/vnd.oasis.opendocument.database)
2022-11-09 15:30 UTC, Buovjaga
Details
Big example file (4.75 MB, application/vnd.oasis.opendocument.database)
2022-11-09 15:31 UTC, Buovjaga
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Kurt 2021-10-21 19:11:32 UTC
Description:
When editing a form sometimes the file size of a form will jump from a few KB to a few MB. Something hidden is being embedded in the form. Tested with both Linux Mint UMA 20.2 and a completely separate Win 10 Pro 21H1 system.
Started from scratch in both systems observed the same behavior in both.
The file size of the Database can sometimes jump over 20 times by a simple edit of a form. Also form size will just increase in size over time when repeated editing/ saving of a form.

Steps to Reproduce:
1.Repeatedly editing a Form and testing of a form before saving a form. 
2.
3.

Actual Results:
File size dramatically increases

Expected Results:
little or none file size increase


Reproducible: Sometimes


User Profile Reset: Yes



Additional Info:
Links to two base files
Both Files contain the same data, same forms one is 47 KB the other is 5 MB. Over a 100 times bigger for the same database. The added garbage/data is somehow contained in the form "frm_add_parts" in the larger DB file.
https://drive.google.com/file/d/1sJxJSr2-bF7f8Eh8Vit0ithE6Zpf6d5n/view?usp=sharing
https://drive.google.com/file/d/1ouEGfqz3Q2DudmqHYzQizhXXJUxyA3Oj/view?usp=sharing


Someone reported this problem several years ago. Seems people didn't understand the error being described. I observed the same thing with and without crashes.
https://ask.libreoffice.org/t/base-file-size-randomly-increases-dramatically/47543
Comment 1 Buovjaga 2022-11-09 15:30:52 UTC
Created attachment 183499 [details]
Small example file
Comment 2 Buovjaga 2022-11-09 15:31:13 UTC
Created attachment 183500 [details]
Big example file
Comment 3 Buovjaga 2022-11-09 15:34:36 UTC
I tested by editing and saving Form1 in the small file twice. First I moved an element and then I added a new element. The file size did not increase drastically, but only by 2k bytes.

Can you still reproduce this with 7.4?
Set to NEEDINFO.
Change back to UNCONFIRMED, if the problem persists. Change to RESOLVED WORKSFORME, if the problem went away.

Arch Linux 64-bit
Version: 7.4.2.3 / LibreOffice Community
Build ID: 40(Build:3)
CPU threads: 8; OS: Linux 6.0; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
7.4.2-1
Calc: threaded
Comment 4 Robert Großkopf 2022-11-10 14:03:01 UTC
There are many pictures saved in two forms of "Big example file". Forms are frm_Add_Items1 and the original FRM_Add_Items. Biggest file in subfolder "pictures" of both forms is a *.pdf (16 pages) from Texas Instruments.

Seems you have tested a little bit with svaing a default-image in an image control. There are 2 image controls in FRM_Add_Items. The second, very small, contains such an image.

Have added other images while editing the form, not input data. Added a document with 1,8 MB this way, which couldn't be removed.

There is no possibility to delete this images you have added in the Base file without opening the file with a packaging program, move to 
forms → Obj51 → Pictures
and delete all the pictures (or the whole folder "Pictures").
Same for Obj42

The bug I see here: If a new file will be inserted in this folder, the old file has to be removed. But at this moment you could only add pictures (or other files) and nothing will be removed …

Have tested this with LO 7.4.2.3 on OpenSUSE 15.3 64bit rpm Linux.
Will set this bug to NEW, but it will be a very old bug, inherited by OOo.
Comment 5 Robert Großkopf 2022-11-10 14:11:26 UTC
Seems it is an duplicate of bug 50816. But in that bug it has been described for images in the background of the form, not in form control.