Photo Supreme Server on NAS is not responding

Post Reply
smgaetano
Posts: 7
Joined: 02 Aug 18 17:50

Photo Supreme Server on NAS is not responding

Post by 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
PSU not responding.jpg (197.21 KiB) Viewed 2318 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
Screenshot 2024-08-18 at 18.07.21.png (2.59 MiB) Viewed 2318 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
moderator
Posts: 210
Joined: 03 Nov 17 8:14

Re: Photosupreme server not responding

Post by RobiWan »

smgaetano wrote: 18 Aug 24 16:15 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
smgaetano wrote: 18 Aug 24 16:15 which is on the NAS server
Not the best solution. Separate server is always better.
smgaetano wrote: 18 Aug 24 16:15 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
Posts: 7
Joined: 02 Aug 18 17:50

Re: Photosupreme server not responding

Post by 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
Attachments
PSU search speed.zip
(6.81 MiB) Downloaded 106 times
Hert
Posts: 7828
Joined: 13 Sep 03 6:24

Re: Photosupreme server not responding

Post by 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?
This is a user-to-user forum. If you need product support then please send a message
RobiWan
moderator
Posts: 210
Joined: 03 Nov 17 8:14

Re: Photo Supreme Server on NAS is not responding

Post by RobiWan »

smgaetano wrote: 18 Aug 24 16:15 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
Posts: 7
Joined: 02 Aug 18 17:50

Re: Photo Supreme Server on NAS is not responding

Post by 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.
Post Reply