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 184.108.40.206 and now 220.127.116.11 on OpenSUSE 15.3 64bit rpm Linux.
Please test with a clean profile, Menu/Help/Restart in Safe Mode
(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.
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".
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.
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)
(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.
On pc Debian x86-64 with master sources updated yesterday, here are the subfolders I got in instdir/user and for LO Debian package 18.104.22.168 the folders I got in ~/.config/libreoffice/4/user/:
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?
(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")
So it is a path defined in LO.
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.