View Issue Details

IDProjectCategoryView StatusLast Update
0008390ADK-Xojo-V4RBAPIpublic2018-11-02 13:52
ReporterBeatrix WilliusAssigned To 
PrioritynormalSeverityminorReproducibilitysometimes
Status newResolutionopen 
Product Version8.3.x 
Target VersionFixed in Version 
Summary0008390: Journal file not always deleted when closing db
DescriptionWhen closing a database then the journal file should be deleted. It seems that on Mojave this isn't always done. The following code

try
      theDatabase.Close
      theDatabase = nil
catch err as VException
      Globals.theErrorLog.DialogErrorProceed(app.kErrorValentina + " " + str(err.ErrorNumber) + " " + err.Message)
end try

gives an error -47 (file is busy). I'm able to delete the file with NSWorkspace as a workaround. From experience I know that this will confuse some of the more detail oriented users.
TagsNo tags attached.

Activities

Beatrix Willius

Beatrix Willius

2018-10-26 09:24

reporter   ~0010518

When cloning I get a similar error.

- The user had made a clone.
- The user moved the clone to the trash.
- On trying to clone again to the same location there is an error -47.

2018-10-23, 10:15:00 PM --------------------------
2018-10-23, 10:15:00 PM An error happened:
2018-10-23, 10:15:00 PM Class/Method: DBUtilities.CloneDatabase
2018-10-23, 10:15:00 PM Time: Tuesday, October 23, 2018 10:15:00 PM 3020319
2018-10-23, 10:15:00 PM Type of Error: VException -47
2018-10-23, 10:15:00 PM --------------------------
2018-10-23, 10:15:00 PM Stack:
2018-10-23, 10:15:00 PM
Sub VDatabase.Close()
Function DBUtilities.CloneDatabase(boolean) as boolean
Sub DBUtilities.CompactDatabase()
Sub MaxModel.DatabaseCompact()
Sub MainWindowController.DatabaseCompact()
Function DBWindow._databaseCompactNew_Action() as boolean
Sub Application._CallFunctionWithExceptionHandling()
2018-10-23, 10:15:00 PM Stack done
2018-10-23, 10:15:00 PM ErrorReportWindow.Constructor
Ivan Smahin

Ivan Smahin

2018-11-02 12:56

manager   ~0010522

Can not reproduce it. Could you please make some relevant example for testing?
Beatrix Willius

Beatrix Willius

2018-11-02 13:52

reporter   ~0010523

I have made the customer an example for cloning. For the leftover journal file I have told the customer to run lsof so that we can see why the file is busy.

Issue History

Date Modified Username Field Change
2018-10-25 05:20 Beatrix Willius New Issue
2018-10-26 09:24 Beatrix Willius Note Added: 0010518
2018-11-02 12:56 Ivan Smahin Note Added: 0010522
2018-11-02 13:52 Beatrix Willius Note Added: 0010523