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: 2025-04-30 03:10 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
Comment 5 QA Administrators 2025-04-30 03:10:53 UTC
Dear Paul Ward,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug