Grouper issue

[attilhacks]

Hello, I'm getting this error, path to dupes.db is absolute and +r: any idea? thanks

Hamming distance = 5 /usr/local/bundle/gems/sqlite3-1.7.0-x86_64-linux/lib/sqlite3/database.rb:116:in open_v2': unable to open database file (SQLite3::CantOpenException) from /usr/local/bundle/gems/sqlite3-1.7.0-x86_64-linux/lib/sqlite3/database.rb:116:ininitialize' from ./main:13:in new' from ./main:13:in

'

[agross]

I don't know what +r is supposed to mean. But the file needs to be writable.

Otherwise, no idea why this happens. Did you use the docker container?

[attilhacks]

Hello Alexander,

the file is readable and writable

-rwxrwxrwx 1 root root 25870336 Aug 6 10:42 dupes.db

yes I used docker container

docker container run \ --rm \ --volume /root/grouper/dupes.db/:/app/data/ \ ghcr.io/agross/immich-duplicates-grouper \ 5

thanks

On Wed, Aug 7, 2024 at 8:18 AM Alexander Groß @.***> wrote:

I don't know what +r is supposed to mean. But the file needs to be writable.

Otherwise, no idea why this happens. Did you use the docker container?

— Reply to this email directly, view it on GitHub https://github.com/agross/immich-duplicates/issues/24#issuecomment-2272701124, or unsubscribe https://github.com/notifications/unsubscribe-auth/BDPJUHVN3HA3O3SXGFRDHBDZQG33JAVCNFSM6AAAAABMDVZZIOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDENZSG4YDCMJSGQ . You are receiving this because you authored the thread.Message ID: @.***>

--

Gabriele Morasso Landline +39 02320623600 Mobile: +968 95 90 2110

[agross]

Still no idea. This is what I just tested:

#!/usr/bin/env bash

set -euo pipefail

userid=ad2055bf-3ce4-4bc0-9884-87707fa0ee04

docker container run \
                 --rm \
                 --volume /fs/data/immich/app/thumbs/:/thumbs/ \
                 --volume "$PWD:/output/" \
                 ghcr.io/agross/immich-duplicates-findimagedupes \
                 --prune \
                 --fingerprints /output/dupes.db \
                 --recurse \
                 --no-compare \
                 --exclude '-[0-9A-Fa-f]{12}\.webp$' \
                 --exclude '-thumbnail\.(webp|jpeg)$' \
                 "/thumbs/$userid"

docker container run \
                 --rm \
                 --volume "$PWD:/app/data/" \
                 ghcr.io/agross/immich-duplicates-grouper \
                 5

[attilhacks]

guess what?

this worked for me! it was missing the " ", also in the documentation it's missing

docker container run \ --rm \ --volume "$PWD:/app/data/" \ ghcr.io/agross/immich-duplicates-grouper \ 5

thanks

On Wed, Aug 7, 2024 at 8:44 AM Alexander Groß @.***> wrote:

Still no idea. This is what I just tested:

!/usr/bin/env bash

set -euo pipefail

userid=ad2055bf-3ce4-4bc0-9884-87707fa0ee04

docker container run \ --rm \ --volume /fs/data/immich/app/thumbs/:/thumbs/ \ --volume "$PWD:/output/" \ ghcr.io/agross/immich-duplicates-findimagedupes \ --prune \ --fingerprints /output/dupes.db \ --recurse \ --no-compare \ --exclude '-[0-9A-Fa-f]{12}.webp$' \ --exclude '-(thumbnail|preview).(webp|jpeg)$' \ "/thumbs/$userid"

docker container run \ --rm \ --volume "$PWD:/app/data/" \ ghcr.io/agross/immich-duplicates-grouper \ 5

— Reply to this email directly, view it on GitHub https://github.com/agross/immich-duplicates/issues/24#issuecomment-2272738205, or unsubscribe https://github.com/notifications/unsubscribe-auth/BDPJUHWV2U732EDICHFN6HTZQG65HAVCNFSM6AAAAABMDVZZIOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDENZSG4ZTQMRQGU . You are receiving this because you authored the thread.Message ID: @.***>

--

Gabriele Morasso Landline +39 02320623600 Mobile: +968 95 90 2110

[agross]

--volume /path/to/immich/thumbs/:/thumbs/ \ does not contain spaces and hence does not need quoting.

Also, the documentation is not the place to explain shell quoting rules.