PDA

View Full Version : Database is locked when editing external documents


cnewtonne
09-16-2020, 10:12 AM
To get advanced editing features e.g. tables, I started using MSWord to open stored .docx files externally writable.

I noticed on at least 5 occasions at some point in time after keeping the doc open externally, I get a dialogue box 'Database is locked'. Hitting OK returns another message 'Error saving item: Access violation. Exception ...'. Hitting OK does not crash UR. I'm able to continue working with it.

I was not able to reproduce the AV error, but it seems to happen after a set number of minutes having the external doc open.

The urd file is stored on Dropbox and I can guarantee there are no other UR instance having this file open. Furthermore, I always run one instance of UR.

1. Why is DB locked in the above scenario?
2. If 'database is locked' not an error, simply informational, why is UR crashing with an AV error afterwards?

Thanks

cnewtonne
09-16-2020, 10:14 AM
Error messages

cnewtonne
09-16-2020, 10:17 AM
The av error message

cnewtonne
09-16-2020, 10:19 AM
Ultra Recall Professional 6.1 (x64)
Copyright © 2004-2020 Kinook Software, Inc.
Registered to: xxxxx(1-user license)
Windows version: Windows 10 Home
Install path: C:\Program Files\UltraRecall
HRW15.DLL version 15.0.0.1
HTW21.DLL version 21,0,0,0
MSPTLS.DLL version 16.0.11929.20048
msvcr100.dll version 10.00.40219.325
PolarSpellChecker.dll version 4.0.5.6
RICHED20.DLL version 16.0.11929.20048
SftPrintPreview_x64_U_20.dll version 2.07
TEW26.DLL version 26.0.0.7
UltraRecall.exe version 6.1.0.1
unins000.exe version 51.52.0.0
Database filename: C:\Users\xxxxx.urd
Database version: 4.0.1 [FTS]

kinook
09-16-2020, 05:02 PM
Does the problem persist after restarting your PC?

cnewtonne
09-17-2020, 07:54 AM
Thanks for taking the time to reply.

As per my above description, I'm able to continue working with UR even after receiving the AV exception. However, I do restart UR to be cautious.

As such, there is no need to restart Windows and, logically, the problem wouldn't persist.

And if I may, did you get the chance to address my two questions, above.

Thanks, again.

kinook
09-17-2020, 09:47 AM
1. I don't know.
2. It is a real error. It appears that another error occurs after that due to the first error.

I haven't been able to reproduce the problem.

cnewtonne
09-17-2020, 11:32 AM
I may have not been clear in my first question. I meant under which conditions UR return 'db is locked error'.

In a 2005 post, I have seen a user state ...

The only time we have seen "database is locked" error is with concurrent usage by multiple users or when cancelling a search or navigation using the Item Text or Item Notes virtual attributes

Is there a scenario where opening a stored document externally writable creates two users or processes trying to update same table/record?

https://www.kinook.com/Forum/showthread.php?t=1279&highlight=database%2Ais%2Alocked

kinook
09-17-2020, 12:42 PM
There is not.