Chronically locked database [insufficient space in backup destination]

When Gramps thinks that now edits have occurred since a backup has been completed, it bypasses doing another backup.

Please ZIP archive the affected Tree’s database folder and attach it in a Private Message to me. We can invite a developer to the PM if they want help diagnose.

The import of the Feb. 2 backup produced the same errors in the C&R and the errors would be from before Feb 2, long standing. I created a new tree after exporting SQLite, then imported it and once I set the media path and home person it is perfect, even has my latest additions. But, it doesn’t back up properly and doesn’t want to give up the key, still locked upon closing. If I don’t make a change, it is fine. Next I will upgrade to the latest version.

Thanks, emyoulation. Will do that now.

@DaveShDaveSh and all, I uninstalled and installed the latest version. It tried to open the locked database. I opened my original db and it is fine. I added parent surnames to someone to test. I see that the command prompt is still open after this, with the message, “(gramps.exe:13496): Gtk-CRITICAL **: 11:41:56.510: gtk_tree_view_scroll_to_point: assertion ‘gtk_widget_get_realized (GTK_WIDGET (tree_view))’ failed”. I closed, same failed backup and command prompt closed at the same time gramps did. I opened again and database is locked.

ETA, command prompt isn’t there anymore when I open and no errors, other than it is locked each time I add something and the backup is empty.

Connie, what do you mean by “command prompt is still open after this”? what were your steps to add the parent surnames?

When I first installed the latest version command prompt was there but I don’t know if that error was showing yet because the program screen came up on top of it. I chose to open the original database, which wasn’t locked because I’d unlocked it and not added anything to it before. I closed and reoped with no problem. I tested it by chicking + new parents for the last new person I’d added a couple days ago. I just added surname for mom, dad’s was already there automatically. That was my test to see if it backed up, which it didn’t, or if it was staying locked, which it is. Command promt isn’t there now.

Ah good, I was just trying to make sure you used the GUI to add the parents and not using a command line interface to add things direct to the DB. (now I understand that you allowed Gramps to start from within the installer program which is a special case that starts Gramps in slightly different way)

Yes, that’s right, Lordemannd.

Connie, can I have a couple more questions?

  1. Have you noticed any case where Gramps just disappears? If so, it is possible that Windows is killing Gramps because of some violation. You can use Windows Administrative Tools → Event Viewer, see if there is any gramps events reported in the Application log about the time Gramps disappeared. (When Windows kills Gramps, Gramps doesn’t get a chance to clear the lock on the DB)

  2. have you looked at the Gramps log file?

  • Can you use Gramps to clear the lock on the DB.
  • close Gramps
  • reopen Gramps and follow your steps that you know will result in the DB lock.
  • close Gramps
  • examine “C:\Users\Owner\AppData\Roaming\gramps\Gramps60.log” (any error messages? then save a copy of the log file: Gramps60-1.log)
  • restart Gramps and clear the lock.
  • load the previously locked DB
  • close Gramps
  • again examine “C:\Users\Owner\AppData\Roaming\gramps\Gramps60.log” (any error messages? then save a copy of the log file: Gramps60-2.log)

No, I’ve never noticing it disappearing. The 60.log file is there but 0KB before and after breaking lock multiple times. It updates the time stamp each time but is still 0KB. Log 52 is also empty and log 51 has the following 1KB from a long time ago:

C:\Program Files\GrampsAIO64-5.1.6\lib\python36.zip\gi\overrides\GObject.py:553: Warning: ../../glib-2.54.3/gobject/gsignal.c:2641: instance ‘000000000bf5c0f0’ has no handler with id ‘90729’
C:\Program Files\GrampsAIO64-5.1.6\lib\python36.zip\gi\overrides\GObject.py:553: Warning: ../../glib-2.54.3/gobject/gsignal.c:2641: instance ‘000000000bf5c5b0’ has no handler with id ‘63804’
C:\Program Files\GrampsAIO64-5.1.6\lib\python36.zip\gi\overrides\GObject.py:553: Warning: ../../glib-2.54.3/gobject/gsignal.c:2641: instance ‘000000000bf5c350’ has no handler with id ‘56206’

Rats, that rules out 2 more edge cases.

The number in the log file name points to a Gramps version, so Gramps60.log has only things reported from versions 6.0.x. The 50 & 51 files are from older versions.

The log file is rewound/reset each time any Gramps 6.0.x version starts. which is why you need to make a copy/rename any log file you want to save.

With the new Gramps install, have you created a new database and imported the SQLite export file? After import, close Gramps like normal and a backup should be created for this new database. Is this new database locked when you restart Gramps?

Oh, silly me. That means I can delete the old ones.

Dave, I didn’t realize I couldn’t use one of the 3 already created databases. So, I just created a new tree with the SQLite export. Did as you directed then closed the new tree. It didn’t create a back up and was locked when I attempted to reopen.

anything in the log file after your last test?

I was able to access the Tree sent via PM and had no problems with the export/backup on a Windows10 box.

No. The time stamp is 3:14 pm, when I closed gramps and the file is still 0KB.

Yes, you can delete the older log files,

I attempted to open the backup file Emyoulation was kind enough to create (he was able to use it just fine) but I had more problems. For some reason a right click to open the file with gramps didn’t work. I told it to use Gramps but it just kept looping back to ask if I want to keep using Gramps. I clicked always use this app and clicked yes but it opens that same message, over and over. Now, I created a new tree and imported it that way and it imported but still has the same problem with locking. The backup files are emply, same as before.

I checked task manager and there is no sign of a creepy crawly that I can see. All scans have been clean too. I turned off the antivirus and it didn’t make any difference so that isn’t interferring. I’m out of ideas.

Connie, I can see a similar issue. If I use gramps.exe instead of grampsw.exe.

are you using gramps.exe for some reason?