Bug 102344 - When Base form and query open, Libreoffice starts creating backup copies in %appdata% (Windows specific)
Summary: When Base form and query open, Libreoffice starts creating backup copies in %...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected)
3.3.0 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2016-09-22 01:08 UTC by niek
Modified: 2022-02-16 07:12 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:

Backups created in the appdata backup directory (118.48 KB, image/jpeg)
2016-09-22 01:31 UTC, niek

Note You need to log in before you can comment on or make changes to this bug.
Description niek 2016-09-22 01:08:12 UTC
LibreOffice Base on Windows 10. I have a Base Form with embedded Forms open (invoices). I open a Base Query (invoices). When going back to the form and scrolling through records while the query screen is still open, LibreOffice starts making copies of the Base file (*.odb) in %appdata%\Roaming\LibreOffice \4\user\backup at a rate of 5 per minute. I know that it's happening when LibreOffice becomes slow and unresponsive and the cursor starts changing to a circle about once a second.

This is a longstanding issue that I have had in consecutive versions since version 3.x of OpenOffice and LibreOffice, on Windows XP, Windows 7 and Windows 10 respectively. Can't remember if I reported this earlier. In any case, I could not find it in the existing bug search.
Comment 1 niek 2016-09-22 01:31:24 UTC
Created attachment 127538 [details]
Backups created in the appdata backup directory
Comment 2 niek 2016-09-22 01:34:28 UTC
A new observation. When working on a Writer document while the Base Query window is still open, the backups accelerate. But when I close the Base Query window, the backups stop, and right at that moment a backup copy of the Writer document appears. So it looks like some condition where LO tries to create a backup copy of a Writer document but somehow is blocked by Base. I don't know. Just an observation.
Comment 3 Buovjaga 2016-10-09 13:33:45 UTC
Could you create an example db with dummy data so we can test quicker?

Change back to UNCONFIRMED after you have provided the file.
Comment 4 niek 2016-10-23 03:46:35 UTC
I anonymized data and table/column names. Furthermore anonymized labels, field names, etc in the LO Base application as needed. This forced me to delete the existing queries as it was too time consuming to manually update all field and table names, and create new ones. Now I am waiting for the issue to reproduce in the anonymized Base app. I will post the database and Base file when reproduction has occurred.
Comment 5 QA Administrators 2017-05-02 11:36:34 UTC Comment hidden (obsolete)
Comment 6 QA Administrators 2017-05-31 10:45:56 UTC
Dear Bug Submitter,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team