Photo Supreme Server on NAS is not responding

[smgaetano]

I started an import of images and then I searched for an image, then a PSU hung and appeared as Not Responding app in the Activity Monitor.

How is it possible to understand if it is waiting from the DB server (which is on the NAS server) or is completely hung ?
Is always safe to kill it?
I am using the last version of PSU, on Mac M2 machine

PSU not responding.jpg (197.21 KiB) Viewed 2320 times

It's about 30 minutes that is running without updating the process cursor, see image.

Screenshot 2024-08-18 at 18.07.21.png (2.59 MiB) Viewed 2320 times

May be very useful to have a way to understand what is doing in any case...

[edit admin]Edited the topic title to better match the content

[RobiWan]

How is it possible to understand if it is waiting from the DB server (which is on the NAS server) or is completely hung ?

The best way to check this is look into logfiles and show pg_top on your server

which is on the NAS server

Not the best solution. Separate server is always better.

Is always safe to kill it?

PSU uses in your case - relational database (postgreSQL) which has "rollback" function all operations that has been not committed
Not responding is not responding - kill your process. Possible you have wait 5 minutes because your license is locked.

[smgaetano]

HI
Thank you for the reply.
I would like to investigate a little bit more.

I have run a search of a keyword that take about 5-6 hours to have the result, which is quite a huge amount of time for 853 result record I believe.

The query that was run is this:

Code: Select all

prepare s932 as select distinct idtbl.GUID as GUID
,idtbl.GroupGUID as GroupGUID
,idtbl.GroupOrder as GroupOrder
,idtbl.GroupMarkers as GroupMarkers
,idtbl.idSimilarityCode as idSimilarityCode
,idtbl.FileName as FileName
 from (select  idSub1.GUID as GUID
,idSub1.GroupGUID as GroupGUID
,idSub1.GroupOrder as GroupOrder
,idSub1.GroupMarkers as GroupMarkers
,idSub1.idSimilarityCode as idSimilarityCode
,idSub1.FileName as FileName
 from (select    i.GUID as GUID
,i.GroupGUID as GroupGUID
,i.GroupOrder as GroupOrder
,i.GroupMarkers as GroupMarkers
,i.idSimilarityCode as idSimilarityCode
,i.FileName as FileName
 from      v_CatalogItem i ) as idSub1, (select distinct GUID from (with tblSearchData as materialized (select distinct RelatedGUID from   idSearchData x where  x.ContentType in ('PROP','XMP','CATITEM','PATH','CAT','REL','PLACEHO','COLL','MODEL','AREA','GROUP','AI')  and x.GUID in (            select  xv.GUID             from    idSearchDataValue xv             where   xv.ContentValue ilike 'bormio%'       

My server configuration is running on a TrueNAS VM using Ubuntu and Postgres DB.
Attached will find the screen shot of the configuration and some more.


Where I am wrong?
Where may I investigate to speed up search?

Thank you
Sergio

[Hert]

To configure your NAS for fast PostgreSQL performance when running on Linux in a VM, you need to optimize several aspects of the NAS, VM, and PostgreSQL setup.

Can you share some more details about the hardware?

- What NAS brand/model?
- What CPU processor(s) is installed in the NAS?
- How much internal memory in installed in the NAS?
- What kinds of drives are installed in the NAS (HDD/SDD...what speed)?
- How are the disks configured (JBOD or RAID? if RAID, what kind)?
- What VM software are you using?
- How much memory did you allocate for the VM?
- How much processor capacity did you allocate for the VM?
- What Linux is installed on the VM?
- What main PostgreSQL version is installed in Linux?

[RobiWan]

I started an import of images and

How many images you are trying to import?
From your screenshot - by "many" images the point "XYZ import profile" needs very long time.

[smgaetano]

Hi

Sorry for the late of my reply but I was away for work and holidays.

The configuration of my server is:
TRUENas server
OS: TrueNAS-13.0-U6.2
HW (I have build it):
Manufacturer board: Supermicro model X11SSM-F
Processor: Intel(R) Xeon(R) CPU E3-1230 v6 @ 3.50GHz
Physical Memory Capacity: 64 GB
Disk:
3 Western Digital WD Red NAS 4TB 5400 rpm
RAID
Disk OS+DB PostgresSQL
Crucial MX500 250GB SATA 2.5 Inch Internal SSD

Virtual DB Postgres server:
Virtual CPUs:
2
Cores:
2
Threads:
4
Memory Size:
20.00 GiB
OS:
Ubuntu Linux 22.04.4
DB:
Postgresql 13.13

I was not importing images, but was a key search.

PSU is managing about 57.000 images

Thank you for any idea on how to speed up PSU.