Bug 147432 - Many backups (like 1889 in 10 minutes) automatically created while editing queries in SQL-view
Summary: Many backups (like 1889 in 10 minutes) automatically created while editing qu...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.3.0.3 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-02-15 07:17 UTC by Robert Großkopf
Modified: 2022-03-24 07:08 UTC (History)
1 user (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2022-02-15 07:17:44 UTC
While editing queries in SQL-view I saw flickering in the status-bar. After it has been gone I had a look in backup folder.

LO has created 823 identical backups of my Base file. Could see the same yesterday: 1889 identical backups in 10 minutes. Had also deleted other identical backups of this file yesterday.

Couldn't upload the file - data are protected informations.

This all happens with a internal Firebird database, contains macros (which aren't working while creating a query in SQL-view). File has about 90kB.

This all happens with LO 7.3.0.3 and now 7.3.1.1 on OpenSUSE 15.3 64bit rpm Linux.
Comment 1 m.a.riosv 2022-02-15 16:08:03 UTC
Please test with a clean profile, Menu/Help/Restart in Safe Mode
Comment 2 Robert Großkopf 2022-02-16 07:08:51 UTC
(In reply to m.a.riosv from comment #1)
> Please test with a clean profile, Menu/Help/Restart in Safe Mode

Problem here: I couldn't describe in detail what will trigger the bug. So I couldn't test it. I only see the behavior at the screen with flickering and then have a look in backup folder.

I created queries and views yesterday for more than 5 hours in the database with the old profile. There doesn't appear flickering, there doesn't appear new backups.
Comment 3 Robert Großkopf 2022-02-16 07:17:03 UTC
I have added more bug descriptions with the same intention. Nobody knows exactly what leads to this backups, so nobody could reproduce it like other bugs. So two of the added bugs has been "solved" by closing them as "invalid" or "insufficient data".
Comment 4 Robert Großkopf 2022-02-16 07:24:35 UTC
Note: There is no function in LibreOffice which creates backups of Base files as there are created backups for Writer, Calc etc. If you set 
Tools → Options → Load/Save → General → Save → Always create backup copy 
there won't be created any backup for database files. I haven't activated this and the many backups of database files appeared.
Comment 5 Julien Nabet 2022-03-19 22:34:15 UTC
At which location do you see these backups, the same as the original file? /tmp? other?
Do you reproduce this only with this specific file or with any odb file? (or perhaps any odb file using Firebird embedded)
Comment 6 Robert Großkopf 2022-03-20 07:29:39 UTC
(In reply to Julien Nabet from comment #5)
> At which location do you see these backups, the same as the original file?
> /tmp? other?

It's in normal backup folder: libreoffice/4/user/backup

> Do you reproduce this only with this specific file or with any odb file? (or
> perhaps any odb file using Firebird embedded)

Has nothing special to do with the file. Have seen it produces the same backups yesterday with a HSQLDB-file (tested a query, which was very slow - ca. 120 Backups in one minute)
Another file has connected with JDBC to PostgreSQL.
The a database connected directly to PostgreSQL.

At this moment there are over 2000 *.odb-files in the backup folder. 

All this happens while developing databases. Seems it won't happen while working with a database.
Comment 7 Julien Nabet 2022-03-20 08:59:23 UTC
On pc Debian x86-64 with master sources updated yesterday, here are the subfolders I got in instdir/user and for LO Debian package 7.3.1.3 the folders I got in ~/.config/libreoffice/4/user/:
autocorr
autotext
basic
config
database
extensions
gallery
pack
psprint
uno_packages

so no "backup" directory.

In Tools/Options/ Load/Save / General, I noticed 2 options:
- "Always create backup copy" unchecked for me
- and some lines above ""Save Autorecovery information every", also unchecked for me

do you confirm both are unchecked for you?
Comment 8 Robert Großkopf 2022-03-20 13:34:28 UTC
(In reply to Julien Nabet from comment #7)
> folders I got in ~/.config/libreoffice/4/user/:
> 
> so no "backup" directory.

Have a look at Tools → Options → LibreOffice → Paths. There is a path for backups. Default has ever been  ~/.config/libreoffice/4/user/backup here.

Same path I get when resetting the profile for a new downloaded daily build.

Seem the path will be created when you first need it. Path for AutoCorrext, Autotext, Dictionaries and Templates could also be seen in Tools → Options → LibreOffice → Paths, but won't exist in a clean profile ~/.config/libreofficedev/4/user/ .

I am using the backup folder for writing backups every time I open an existing database file, but this backup files aren't numbered the same the automatic backups will be created.
I get this path with
oPath = createUnoService("com.sun.star.util.PathSettings")
oPath.Backup

So it is a path defined in LO.
Comment 9 Julien Nabet 2022-03-24 07:08:13 UTC
Since I don't reproduce this (I don't have the backup directory whereas I got by default config), can't help here=>uncc myself.