
SQLite Error 5 - database is locked
#1
Posted 30 November 2012 - 12:25 AM
Regards
Herman du Plooy
#2
Posted 30 November 2012 - 10:56 AM
RootsMagic
#3
Posted 01 December 2012 - 03:36 AM
#4
Posted 05 December 2012 - 10:19 AM
RootsMagic
#5
Posted 15 December 2012 - 11:37 PM
#6
Posted 23 June 2013 - 08:54 AM
I was creating a report LIST with selected names based on 3 criteria. Half way through the search the 'gas gauge' froze. I left it 'searching' for about 10 minutes and there was no movement on gauge. Canceled out of report and when I attempted to exit the program the error popped up. every attempt to exit the program gave the same 'database is locked' error. Finally had to use Task Manager to close the program.
#7
Posted 23 June 2013 - 09:07 AM
Select search criteria was
1. Suffix contains xxxxxx
and
2 Suffix does not contain xxxxx
and
3 Note General contains xxxx
#8
Posted 24 June 2013 - 12:01 PM
Do you have that file opened in some sql editor, at the same time? Try rebooting your computer.
What is the full path name where you are storing your data?
Have you run File>Database Tools - all options on consecutive order?
RootsMagic
#9
Posted 24 June 2013 - 06:55 PM
Is your error message: SQLite error 5 - database is locked
Do you have that file opened in some sql editor, at the same time? Try rebooting your computer.
What is the full path name where you are storing your data?
Have you run File>Database Tools - all options on consecutive order?
No SQL editor. File path same as it was before latest update, no errors until update. No I have not run those options.
#10
Posted 24 June 2013 - 08:12 PM
You should. If the integrity check does not report OK, you must do Rebuild Indexes and re-run Integrity Check. The others are not critical.No I have not run those options.
Tom user of RM7630 FTM2017 Ancestry.ca FamilySearch.org FindMyPast.com wiki, exploiting the database in special ways >>>
app, a bundle of RootsMagic utilities.
#11
Posted 24 June 2013 - 09:18 PM
Did my report search as above ... completed OK first time, crashed on second iteration. Same as before.
I'll try this with a different database.
#12
Posted 24 June 2013 - 09:32 PM
The 2nd database also passed the database integrity tests.
#13
Posted 24 June 2013 - 09:39 PM
#14
Posted 24 June 2013 - 09:59 PM
If it is repeatable, then document your step-by-step procedure so that others can duplicate and confirm if there is a bug. If it is unique to your database, then submit your database and your procedure to tech support.
Tom user of RM7630 FTM2017 Ancestry.ca FamilySearch.org FindMyPast.com wiki, exploiting the database in special ways >>>
app, a bundle of RootsMagic utilities.
#15
Posted 25 June 2013 - 10:26 PM
SUFFIX CONTAINS XXXXX
and
SUFFIX DOES NOT CONTAIN XXXXXX
and
NOTE GENERAL CONTAINS XXXXXX
If the database does not meet the search criteria for any record then there is no freeze.
#16
Posted 25 June 2013 - 10:58 PM
Update:
opened Rev 6 and it said there was an update. Installed the update and it says it is rev 6.2.0.0 - same ver I updated to a couple days ago. ?????
Ran the same search as above and on the second pass I get a new error. OUT OF MEMORY. ;-) Then when trying to close the program I get an ACCESS VIOLATION error in ROOTSL at 008864C5 - program will not close gracefully. Vulcan nerve pinch required. (task manager kill)
Seems to me we might have an indexing error occurring with a large database.
#17
Posted 25 June 2013 - 11:26 PM
No need to generate report to see this freeze. Just doing a manual search with the same three criteria will freeze the program on the second pass. Just checked Ver 5 and it does the same thing. Here is the search ...
SUFFIX CONTAINS XXXXX
and
SUFFIX DOES NOT CONTAIN XXXXXX
and
NOTE GENERAL CONTAINS XXXXXX
If the database does not meet the search criteria for any record then there is no freeze.
Confirmed.
#18
Posted 26 June 2013 - 08:14 AM
RootsMagic's own memory management and error handling failed to handle this exception gracefully. Freeing up memory by closing other programs did not unfreeze RM. Hitting Cancel repeatedly had no effect other than to tickle CPU utilisation - it was as though the program was being stepped by the clicks.
Tom user of RM7630 FTM2017 Ancestry.ca FamilySearch.org FindMyPast.com wiki, exploiting the database in special ways >>>
app, a bundle of RootsMagic utilities.
#19
Posted 26 June 2013 - 08:26 AM
Tom user of RM7630 FTM2017 Ancestry.ca FamilySearch.org FindMyPast.com wiki, exploiting the database in special ways >>>
app, a bundle of RootsMagic utilities.
#20
Posted 26 June 2013 - 10:00 AM
https://www3.gotomee...ister/769710494
RootsMagic