Johannes, On 08/02/13 21:54, johannes hanika wrote: > On Fri, Feb 8, 2013 at 10:36 PM, Tony Arnold > <[email protected]> wrote: >> Johannes, >> >> On 08/02/13 00:29, johannes hanika wrote: >>> On Fri, Feb 8, 2013 at 12:14 PM, Tony Arnold >>> <[email protected]> wrote: >>>> I have a load of images that are in darktable's database but no longer >>>> on my disk. How can I clean up the database to get rid of these entries. >>> >>> ./tools/purge_non_existing_images.sh >>> >>> or see here if you're not fortunate enough to install from git: >>> >>> https://github.com/darktable-org/darktable/blob/master/tools/purge_non_existing_images.sh >> >> Thanks, but this does not work. It tries to invoke sqlite3 to delete a >> record while sqlite3 is already doing a select so I get an erro saying >> the database is locked. > > you probably had dt running in the background.
I checked that and I didn't. >> Attached is a working version. > > it's exactly the same but the line that says uncomment me you uncommented? No it isn't. The original took the first sqlite3 statement and piped into he while statement. The problem is that the first sqlite is still running when the second one tries to delete a record and you get a database locked error. Mine feeds the output from the first sqlite statement into a temporary file. That file is then piped to the while statement. Thus sqlite is only ever running once. I uncommented the line as I posted the version that actually worked. Regards, Tony. -- Tony Arnold, Tel: +44 (0) 161 275 6093 Head of IT Security, Fax: +44 (0) 705 344 3082 University of Manchester, Mob: +44 (0) 773 330 0039 Manchester M13 9PL. Email: [email protected] ------------------------------------------------------------------------------ Free Next-Gen Firewall Hardware Offer Buy your Sophos next-gen firewall before the end March 2013 and get the hardware for free! Learn more. http://p.sf.net/sfu/sophos-d2d-feb _______________________________________________ Darktable-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/darktable-users
