GnuCash
Contact   Instructions
Bug 797906 - GnuCash data file is locked after a "save-as" to mysql database
Summary: GnuCash data file is locked after a "save-as" to mysql database
Status: RESOLVED FIXED
Alias: None
Product: GnuCash
Classification: Unclassified
Component: General (show other bugs)
Version: 4.1
Hardware: PC Windows
: Normal minor
Target Milestone: ---
Assignee: general
QA Contact: general
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-08-14 12:46 EDT by John
Modified: 2021-03-23 14:28 EDT (History)
5 users (show)

See Also:

Attachments
Screen shot of referenced dialog (28.84 KB, image/png)
2020-08-14 12:46 EDT, John 		no flags Details
Bug flow Screenshot (deleted)
2020-09-29 10:46 EDT, John 		no flags Details
Show Obsolete (1) View All Add an attachment (proposed patch, testcase, etc.)

Description John 2020-08-14 12:46:04 EDT 
Created attachment 373821 [details]
Screen shot of referenced dialog

When I open my .gnucash file on Windows 10 and then do a "Save-As" to MySQL the original file remains locked. When I attempt to open the .gnucash file after the save-as I gen the "GnuCash could not obtain the lock for ..." dialog box.

The work-around is simple. I simple click the "Open Anyway" button on the dialog.

This is low priority, IMO. I use mysql as a backup and for data analytics. So I run into this only a couple times a month.
Comment 1 znoyhhcsikvxdlxdmv 2020-09-08 07:48:03 EDT 
Hello, I have the same bug and same solution as the user above, but on mac using Version: 4.1 Build ID: 4.1+(2020-07-25)

gnucash could not obtain the lock for file.gnucash. The database may be in use by another user etc

Thanks
Comment 2 John 2020-09-29 10:46:54 EDT 
Created attachment 373878 [details]
Bug flow Screenshot
Comment 3 John Ralls 2020-09-29 11:41:51 EDT 
(In reply to John from comment #2)
> Created attachment 373878 [details]
> Bug flow Screenshot

I think you put that on the wrong bug, doesn't it belong to bug 797959?
Comment 4 John 2020-09-29 14:43:56 EDT 
Indeed! So sorry. It is I that is "buggy". I do not see a way to remove it here.

Thanks for all your work on this program John Ralls.
Comment 5 John Ralls 2020-09-29 14:54:08 EDT 
Click the [details] link then click edit details. There should be a delete link at the bottom.
Comment 6 John 2020-09-29 15:17:37 EDT 
Could not find Delete link. Tried multiple browsers. I was able to Obsolete it.
Comment 7 John Ralls 2020-09-29 15:20:45 EDT 
The content of attachment 373878 [details] has been deleted
Comment 8 John Ralls 2020-09-29 15:21:36 EDT 
I guess only admins can delete.
Comment 9 John Ralls 2021-03-23 14:28:58 EDT 
Fixed for GnuCash 4.5.
Note You need to log in before you can comment on or make changes to this bug.