Kinook Software Forum

Kinook Software Forum (https://www.kinook.com/Forum/index.php)
-   [UR] General Discussion (https://www.kinook.com/Forum/forumdisplay.php?f=23)
-   -   Database is locked when editing external documents (https://www.kinook.com/Forum/showthread.php?t=5684)

cnewtonne 09-16-2020 10:12 AM

Database is locked when editing external documents
 
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

1 Attachment(s)
Error messages

cnewtonne 09-16-2020 10:17 AM

1 Attachment(s)
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 ...

Quote:

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/showthr...%2Ais%2Alocked

kinook 09-17-2020 12:42 PM

There is not.


All times are GMT -5. The time now is 12:33 PM.


Copyright © 1999-2023 Kinook Software, Inc.