i see.. pushed your version now, thanks :)
-jo
On Sat, Feb 9, 2013 at 12:29 PM, Tony Arnold
<[email protected]>wrote:
> 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]
>
------------------------------------------------------------------------------
Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire
the most talented Cisco Certified professionals. Visit the
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html
_______________________________________________
Darktable-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/darktable-users
