OuafnicO
OuafnicO
PostsComments
IImmich
Created by OuafnicO on 5/9/2023 in #help-desk-support
Map error after upgrade to 1.55.
I can test other queries if needed
51 replies
IImmich
Created by OuafnicO on 5/9/2023 in #help-desk-support
Map error after upgrade to 1.55.
yes, 45s to 70s, according some retries
51 replies
IImmich
Created by OuafnicO on 5/9/2023 in #help-desk-support
Map error after upgrade to 1.55.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Finalize Aggregate  (cost=5893.49..5893.50 rows=1 width=8) (actual time=133.384..139.437 rows=1 loops=1)
   ->  Gather  (cost=5893.38..5893.49 rows=1 width=8) (actual time=132.936..139.424 rows=2 loops=1)
         Workers Planned: 1
         Workers Launched: 1
         ->  Partial Aggregate  (cost=4893.38..4893.39 rows=1 width=8) (actual time=125.894..125.897 rows=1 loops=2)
               ->  Nested Loop  (cost=0.42..4892.39 rows=396 width=0) (actual time=0.151..124.256 rows=3324 loops=2)
                     ->  Parallel Seq Scan on exif  (cost=0.00..2395.57 rows=401 width=16) (actual time=0.022..26.540 rows=3324 loops=2)
                           Filter: ((latitude IS NOT NULL) AND (longitude IS NOT NULL))
                           Rows Removed by Filter: 32646
                     ->  Index Scan using "PK_da96729a8b113377cfb6a62439c" on assets  (cost=0.42..6.23 rows=1 width=16) (actual time=0.027..0.027 rows=1 loops=6647)
                           Index Cond: (id = exif."assetId")
                           Filter: (("resizePath" IS NOT NULL) AND "isVisible")
 Planning Time: 4.687 ms
 Execution Time: 139.731 ms
(14 rows)
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Finalize Aggregate  (cost=5893.49..5893.50 rows=1 width=8) (actual time=133.384..139.437 rows=1 loops=1)
   ->  Gather  (cost=5893.38..5893.49 rows=1 width=8) (actual time=132.936..139.424 rows=2 loops=1)
         Workers Planned: 1
         Workers Launched: 1
         ->  Partial Aggregate  (cost=4893.38..4893.39 rows=1 width=8) (actual time=125.894..125.897 rows=1 loops=2)
               ->  Nested Loop  (cost=0.42..4892.39 rows=396 width=0) (actual time=0.151..124.256 rows=3324 loops=2)
                     ->  Parallel Seq Scan on exif  (cost=0.00..2395.57 rows=401 width=16) (actual time=0.022..26.540 rows=3324 loops=2)
                           Filter: ((latitude IS NOT NULL) AND (longitude IS NOT NULL))
                           Rows Removed by Filter: 32646
                     ->  Index Scan using "PK_da96729a8b113377cfb6a62439c" on assets  (cost=0.42..6.23 rows=1 width=16) (actual time=0.027..0.027 rows=1 loops=6647)
                           Index Cond: (id = exif."assetId")
                           Filter: (("resizePath" IS NOT NULL) AND "isVisible")
 Planning Time: 4.687 ms
 Execution Time: 139.731 ms
(14 rows)
51 replies
IImmich
Created by OuafnicO on 5/9/2023 in #help-desk-support
Map error after upgrade to 1.55.
you have specifics hardware requirement for immich ?
51 replies
IImmich
Created by OuafnicO on 5/9/2023 in #help-desk-support
Map error after upgrade to 1.55.
sure
51 replies
IImmich
Created by OuafnicO on 5/9/2023 in #help-desk-support
Map error after upgrade to 1.55.
I can tell after the next version
51 replies
IImmich
Created by OuafnicO on 5/9/2023 in #help-desk-support
Map error after upgrade to 1.55.
and the cpu is quite old 😉
51 replies
IImmich
Created by OuafnicO on 5/9/2023 in #help-desk-support
Map error after upgrade to 1.55.
but seems hard with this number of assets
51 replies
IImmich
Created by OuafnicO on 5/9/2023 in #help-desk-support
Map error after upgrade to 1.55.
I'm running immich in a KVM, with 8GB memory and 4 vcpus
51 replies
IImmich
Created by OuafnicO on 5/9/2023 in #help-desk-support
Map error after upgrade to 1.55.
above 45sec
51 replies
IImmich
Created by OuafnicO on 5/9/2023 in #help-desk-support
Map error after upgrade to 1.55.
so it's just my conf, maybe too slow for this number of assets
51 replies
IImmich
Created by OuafnicO on 5/9/2023 in #help-desk-support
Map error after upgrade to 1.55.
it's working 🙂
51 replies
IImmich
Created by OuafnicO on 5/9/2023 in #help-desk-support
Map error after upgrade to 1.55.
testing the map again..
51 replies
IImmich
Created by OuafnicO on 5/9/2023 in #help-desk-support
Map error after upgrade to 1.55.
the api is now responding
51 replies
IImmich
Created by OuafnicO on 5/9/2023 in #help-desk-support
Map error after upgrade to 1.55.
I've changed the defaults timeout of haproxy, to 60s, in place of 30s
51 replies
IImmich
Created by OuafnicO on 5/9/2023 in #help-desk-support
Map error after upgrade to 1.55.
I know immich is in big development, but trying to feedback if I can (i'm not a dev, but a sysadmin)
51 replies
IImmich
Created by OuafnicO on 5/9/2023 in #help-desk-support
Map error after upgrade to 1.55.
ok 🙂
51 replies
IImmich
Created by OuafnicO on 5/9/2023 in #help-desk-support
Map error after upgrade to 1.55.
maybe I can check some timeout
51 replies
IImmich
Created by OuafnicO on 5/9/2023 in #help-desk-support
Map error after upgrade to 1.55.
got an haproxy on front of the immich server; but no filtering or curious things on the configuration
51 replies
IImmich
Created by OuafnicO on 5/9/2023 in #help-desk-support
Map error after upgrade to 1.55.
above 72K
51 replies