Bug 152472 - LO Base leaves orphaned temp files after running a report from a Firebird database (Win-only)
Summary: LO Base leaves orphaned temp files after running a report from a Firebird dat...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.4.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: low minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Firebird-Default
  Show dependency treegraph
 
Reported: 2022-12-11 21:20 UTC by Paul Ward
Modified: 2023-04-30 08:07 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Paul Ward 2022-12-11 21:20:11 UTC
Description:
Every time I run a report in LO Base two folders and two files get left behind in C:\Users\UserName\AppData\Local\Temp\:
Main folder name is like lu117481aorl9.tm
Subfolder in main folder is like lu117481aorlb.tmp
Files in subfolder are like fb_trace_wwvr4t and fb12_trace.1


Steps to Reproduce:
1. Run a report from LO Base
2. Exit LO
3.

Actual Results:
Two folders and two files still in Appdata\Local\Temp

Expected Results:
All temp files deleted on exit


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.4.3.2 (x64) / LibreOffice Community
Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Comment 1 Robert Großkopf 2022-12-12 18:17:46 UTC
Tested it with OpenSUSE 15.3 64bit rpm Linux, LO 7.4.3.2

Executed a report.
Folder in tmp-folder has been created.
2 files have been created, both the same content.
One file is named "Report1.odt", second file is named "lu….tmp", but also a Writer file.
Closed the report. → "lu….tmp" has been gone.
Closed LO. → File "Report1.odt" and also the folder has been gone.

So I couldn't find any buggy behavior here. Might be special to Windows?
Comment 2 Paul Ward 2022-12-31 19:39:01 UTC
Similarly, temporary folders and files are left behind after doing either of the following:

-- displaying the list of queries by clicking the query button on the LO Base main page (even without running or editing a query)

-- opening the Tools:SQL window from the LO Base main page (even without executing an SQL command)
Comment 3 Robert Großkopf 2023-01-01 10:57:12 UTC
(In reply to Paul Ward from comment #2)
> Similarly, temporary folders and files are left behind after doing either of
> the following:
> 
> -- displaying the list of queries by clicking the query button on the LO
> Base main page (even without running or editing a query)
> 
> -- opening the Tools:SQL window from the LO Base main page (even without
> executing an SQL command)

No wonder - the database will be opened. Connecting to queries and tables and also tools → sql will open the database. Looking at the report you are using Firebird. The database will be unpacked in the tmp-folder for getting the data.

Buggy behavior you reported is the files in tmp-folder aren't deleted when LO has been closed. And this I couldn't confirm. No more files here when LO has been closed.

All old lu… folders in tmp I could find are folders, which weren't deleted because LO crashed/hanged - for example while testing macro code.
Comment 4 Buovjaga 2023-03-15 13:09:05 UTC
I repro, but only with Firebird and only on Windows. You can test with this: attachment 142449 [details]

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 668c44e841a10cec8932a446a941e6d7c386bf3b
CPU threads: 2; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: en-US (en_FI); UI: en-US
Calc: threaded