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.
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 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?
(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.
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.
Hello, It's been a while since this issue was reported. Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
It also happens with newer versions of LO. Got the same behavior with LO 24.8.4.2 on 2025-01-31. It happens with internal HSQLDB and also with internal Firebird database. But: I couldn't reproduce why this happens. I close Base when statusbar is flickering and then I restart Base. Seems it won't happen when input data into forms…
I can fully confirm Roberts comments, last one dated 2025-03-04 12:20:21 UTC. I'm using MANJARO Linux.
I can confirm this strange behavior, but with some nuances: - It has happened with a firebird database in external file - Although I have been working several days in a row with the same database, there are only backups of a specific date and very close in time -------------- Version: 25.2.1.2 (X86_64) / LibreOffice Community Build ID: d3abf4aee5fd705e4a92bba33a32f40bc4e56f49 CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: CL threaded
I should add, that here the (empty) backup-files are also produced wile editing forms or reports and - described here - also while editing queries. I'm using a PostgreSQL-Backend. May be, I'm also affected by bug 71550 https://bugs.documentfoundation.org/show_bug.cgi?id=71550.