Skip to content

Instantly share code, notes, and snippets.

@centralhardware
Created July 22, 2022 15:06
Show Gist options
  • Save centralhardware/db6dfd610500784a8ea3c9ed9e333a06 to your computer and use it in GitHub Desktop.
Save centralhardware/db6dfd610500784a8ea3c9ed9e333a06 to your computer and use it in GitHub Desktop.
alex@photoprism ~/photoprisme> sudo docker-compose exec photoprism photoprism purge
DEBU[2022-07-22T14:57:19Z] config: successfully initialized [2.629138ms]
DEBU[2022-07-22T14:57:20Z] migrate: found 19 previous migrations
DEBU[2022-07-22T14:57:20Z] migrate: 20211121-094727 skipped
DEBU[2022-07-22T14:57:20Z] migrate: 20211124-120008 skipped
DEBU[2022-07-22T14:57:20Z] migrate: 20220329-030000 skipped
DEBU[2022-07-22T14:57:20Z] migrate: 20220329-040000 skipped
DEBU[2022-07-22T14:57:20Z] migrate: 20220329-050000 skipped
DEBU[2022-07-22T14:57:20Z] migrate: 20220329-060000 skipped
DEBU[2022-07-22T14:57:20Z] migrate: 20220329-061000 skipped
DEBU[2022-07-22T14:57:20Z] migrate: 20220329-070000 skipped
DEBU[2022-07-22T14:57:20Z] migrate: 20220329-071000 skipped
DEBU[2022-07-22T14:57:20Z] migrate: 20220329-080000 skipped
DEBU[2022-07-22T14:57:20Z] migrate: 20220329-081000 skipped
DEBU[2022-07-22T14:57:20Z] migrate: 20220329-083000 skipped
DEBU[2022-07-22T14:57:20Z] migrate: 20220329-090000 skipped
DEBU[2022-07-22T14:57:20Z] migrate: 20220329-091000 skipped
DEBU[2022-07-22T14:57:20Z] migrate: 20220329-093000 skipped
DEBU[2022-07-22T14:57:20Z] migrate: 20220421-200000 skipped
DEBU[2022-07-22T14:57:20Z] migrate: 20220521-000001 skipped
DEBU[2022-07-22T14:57:20Z] migrate: 20220521-000002 skipped
DEBU[2022-07-22T14:57:20Z] migrate: 20220521-000003 skipped
DEBU[2022-07-22T14:57:20Z] migrate: completed in 399.516225ms
INFO[2022-07-22T14:57:20Z] purge: removing missing files in originals
INFO[2022-07-22T14:57:27Z] purge: flagged file 'family <original_folder>/00005.MTS.jpg' as missing
INFO[2022-07-22T14:57:27Z] purge: cannot find primary file for pre41ph2lnw0fn8w
INFO[2022-07-22T14:57:27Z] purge: flagged file 'family <original_folder>/00012.MTS.jpg' as missing
INFO[2022-07-22T14:57:27Z] purge: cannot find primary file for pre41ph30frzohsd
...
INFO[2022-07-22T14:57:27Z] purge: flagged file 'family <original_folder>/HDV_0475.MP4.jpg' as missing
INFO[2022-07-22T14:57:27Z] purge: cannot find primary file for pre429vmfdjqmlzl
INFO[2022-07-22T14:57:27Z] purge: flagged file 'family <original_folder>/HDV_0476.MP4.jpg' as missing
INFO[2022-07-22T14:57:27Z] purge: cannot find primary file for pre42a33cq0xs5x9
INFO[2022-07-22T14:57:28Z] purge: flagged file 'family <original_folder>/VID_20141204_152035.mp4.jpg' as missing
ERRO[2022-07-22T14:57:28Z] files: Error 1052: Column 'photo_uid' in where clause is ambiguous (regenerate photo_taken_at)
DEBU[2022-07-22T14:57:28Z] search: updated partial file index [2.145621ms]
INFO[2022-07-22T14:57:28Z] purge: flagged file 'family <original_folder>/VID_20141204_163414.mp4.jpg' as missing
ERRO[2022-07-22T14:57:28Z] files: Error 1052: Column 'photo_uid' in where clause is ambiguous (regenerate photo_taken_at)
DEBU[2022-07-22T14:57:28Z] search: updated partial file index [1.210546ms]
INFO[2022-07-22T14:57:28Z] purge: flagged file 'family <original_folder>/VID_20141204_152035.mkv.jpg' as missing
INFO[2022-07-22T14:57:28Z] purge: flagged file 'family <original_folder>/VID_20141204_163414.mkv.jpg' as missing
INFO[2022-07-22T14:57:28Z] purge: flagged file 'family <original_folder>/VID_20141206_114939.mp4.jpg' as missing
ERRO[2022-07-22T14:57:28Z] files: Error 1052: Column 'photo_uid' in where clause is ambiguous (regenerate photo_taken_at)
DEBU[2022-07-22T14:57:28Z] search: updated partial file index [1.221305ms]
INFO[2022-07-22T14:57:28Z] purge: flagged file 'family <original_folder>/VID_20141206_114939.mkv.jpg' as missing
INFO[2022-07-22T14:57:28Z] purge: flagged file 'family <original_folder>/VID_20141206_151450.mp4.jpg' as missing
ERRO[2022-07-22T14:57:28Z] files: Error 1052: Column 'photo_uid' in where clause is ambiguous (regenerate photo_taken_at)
DEBU[2022-07-22T14:57:28Z] search: updated partial file index [1.217717ms]
INFO[2022-07-22T14:57:28Z] purge: flagged file 'family <original_folder>/VID_20141206_151450.mkv.jpg' as missing
INFO[2022-07-22T14:57:28Z] purge: flagged file 'family <original_folder>/VID_20141207_102135.mp4.jpg' as missing
ERRO[2022-07-22T14:57:28Z] files: Error 1052: Column 'photo_uid' in where clause is ambiguous (regenerate photo_taken_at)
DEBU[2022-07-22T14:57:28Z] search: updated partial file index [1.973572ms]
INFO[2022-07-22T14:57:28Z] purge: flagged file 'family <original_folder>/VID_20141207_102135.mkv.jpg' as missing
INFO[2022-07-22T14:57:28Z] purge: flagged file 'family <original_folder>/VID_20141207_102232.mp4.jpg' as missing
ERRO[2022-07-22T14:57:28Z] files: Error 1052: Column 'photo_uid' in where clause is ambiguous (regenerate photo_taken_at)
DEBU[2022-07-22T14:57:28Z] search: updated partial file index [1.601116ms]
INFO[2022-07-22T14:57:28Z] purge: flagged file 'family <original_folder>/VID_20141207_102232.mkv.jpg' as missing
INFO[2022-07-22T14:57:28Z] purge: flagged file 'family <original_folder>/VID_20141207_124206.mp4.jpg' as missing
ERRO[2022-07-22T14:57:28Z] files: Error 1052: Column 'photo_uid' in where clause is ambiguous (regenerate photo_taken_at)
DEBU[2022-07-22T14:57:28Z] search: updated partial file index [1.383068ms]
INFO[2022-07-22T14:57:28Z] purge: flagged file 'family <original_folder>/VID_20141207_102306.mp4.jpg' as missing
ERRO[2022-07-22T14:57:28Z] files: Error 1052: Column 'photo_uid' in where clause is ambiguous (regenerate photo_taken_at)
DEBU[2022-07-22T14:57:28Z] search: updated partial file index [1.267152ms]
INFO[2022-07-22T14:57:28Z] purge: flagged file 'family <original_folder>/VID_20141207_124206.mkv.jpg' as missing
INFO[2022-07-22T14:57:28Z] purge: flagged file 'family <original_folder>/VID_20141207_102306.mkv.jpg' as missing
INFO[2022-07-22T14:57:28Z] purge: flagged file 'family <original_folder>/VID_20141207_124548.mp4.jpg' as missing
ERRO[2022-07-22T14:57:28Z] files: Error 1052: Column 'photo_uid' in where clause is ambiguous (regenerate photo_taken_at)
DEBU[2022-07-22T14:57:28Z] search: updated partial file index [1.32103ms]
INFO[2022-07-22T14:57:28Z] purge: flagged file 'family <original_folder>/VID_20141207_124548.mkv.jpg' as missing
INFO[2022-07-22T14:57:28Z] purge: flagged file 'family <original_folder>/VID_20141207_125157.mp4.jpg' as missing
ERRO[2022-07-22T14:57:28Z] files: Error 1052: Column 'photo_uid' in where clause is ambiguous (regenerate photo_taken_at)
DEBU[2022-07-22T14:57:28Z] search: updated partial file index [1.237559ms]
INFO[2022-07-22T14:57:28Z] purge: flagged file 'family <original_folder>/VID_20141207_125157.mkv.jpg' as missing
INFO[2022-07-22T14:57:32Z] purge: flagged file 'family <original_folder>/_MG_8184.CR2.jpg' as missing
INFO[2022-07-22T14:57:32Z] purge: cannot find primary file for pre4gxg21dg3rdzd
...
INFO[2022-07-22T14:57:35Z] purge: cannot find primary file for pre4py618576buyq
INFO[2022-07-22T14:57:35Z] purge: flagged file 'family <original_folder>comp 6/Pre-comp 6_00257.png.jpg' as missing
INFO[2022-07-22T14:57:35Z] purge: cannot find primary file for pre4py62w3nuqikd
DEBU[2022-07-22T14:57:37Z] index: searching primary file for pre3t8s3kxmkpuwq
INFO[2022-07-22T14:57:37Z] index: found no jpeg for photo uid pre3t8s3kxmkpuwq
DEBU[2022-07-22T14:57:37Z] index: searching primary file for pre3uh213dghbkau
INFO[2022-07-22T14:57:37Z] index: found no jpeg for photo uid pre3uh213dghbkau
DEBU[2022-07-22T14:57:37Z] index: searching primary file for pre3uh42fb04bmf0
INFO[2022-07-22T14:57:37Z] index: found no jpeg for photo uid pre3uh42fb04bmf0
DEBU[2022-07-22T14:57:37Z] index: searching primary file for pre3uh5315ffm4dw
...
DEBU[2022-07-22T14:57:38Z] index: searching primary file for prf1v2k3a0h5ctzx
INFO[2022-07-22T14:57:38Z] index: found no jpeg for photo uid prf1v2k3a0h5ctzx
DEBU[2022-07-22T14:57:38Z] index: updated primary files [703.9112ms]
INFO[2022-07-22T14:57:38Z] index: flagged 890 photos as hidden or missing [125.748126ms]
INFO[2022-07-22T14:57:38Z] index: found no orphan files [81.230431ms]
DEBU[2022-07-22T14:57:39Z] search: updated file index [232.978109ms]
DEBU[2022-07-22T14:57:39Z] index: updating counts
DEBU[2022-07-22T14:57:39Z] counts: updated 1 place [40.903515ms]
DEBU[2022-07-22T14:57:39Z] counts: updated 6 subjects [32.078694ms]
DEBU[2022-07-22T14:57:39Z] counts: updated 8 labels [89.549887ms]
DEBU[2022-07-22T14:57:39Z] index: updating covers
DEBU[2022-07-22T14:57:39Z] covers: updated 0 albums [2.439086ms]
DEBU[2022-07-22T14:57:40Z] covers: updated 8 folders [71.898414ms]
DEBU[2022-07-22T14:57:40Z] covers: updated 0 months [24.279702ms]
DEBU[2022-07-22T14:57:40Z] covers: updated 0 labels [106.882331ms]
DEBU[2022-07-22T14:57:40Z] covers: updated 0 subjects [15.136319ms]
INFO[2022-07-22T14:57:40Z] purged 900 files and 0 photos in 20.475072156s
INFO[2022-07-22T14:57:40Z] closed database connection
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment