Errors during Geo-Tagging

Post Reply
Al_M
Posts: 23
Joined: 21 Jun 19 14:09
Location: Kansas City, USA

Errors during Geo-Tagging

Post by Al_M » 19 Jun 20 19:51

After about a week of installing PostgreSQL, migrating from the single-user edition to server edition (converting databases), researching and implementing a backup strategy and overall familiarization with my new server setup, I got back to the business of photo collection curation.

One task is geo-location details and as I went back to work on this, I got the following error(s):
Screen Shot 2020-06-19 at 1.06.53 PM.png
Screen Shot 2020-06-19 at 1.06.53 PM.png (118.43 KiB) Viewed 209 times
Too many clients? Huh? I had one client open on the server machine (MacPro). I checked the licenses in use under User Management; it showed 2 Loaded, 1 Available, 1 In Use.

No other clients are connected to the database server.

The error immediately came up as soon as I hit the Apply button after changing some geo details on 130 images.

Any ideas about what may be happening???
Photo Supreme V5 Server Edition (build 2971)
PostgreSQL 12
macOS 10.15.4 (Catalina)
Mac Pro (Late 2013), 3.0 GHz 8-Core Xeon E5, 64 GB DDR3
MacBook Pro (Mid 2015), 2.5 GHz Quad-Core i7, 16 GB DDR3L

Hert
Posts: 6210
Joined: 13 Sep 03 7:24

Re: Errors during Geo-Tagging

Post by Hert » 19 Jun 20 20:42

This is a message from the database.
Increase the max_connections Setting in your PostgreSQL config. Also see the installation instructions for the Server Edition with PostgreSQL
This is a User-to-User forum which means that users post questions here for other users.
Feature requests, change suggestions, or bugs can be logged in the ticketing system

Al_M
Posts: 23
Joined: 21 Jun 19 14:09
Location: Kansas City, USA

Re: Errors during Geo-Tagging

Post by Al_M » 20 Jun 20 16:49

Hert,

Yes, I followed the recommendation in the PostgreSQL Installation Manual, but apparently it wasn't enough for the max_connections (50 x # of concurrent users = 100). So I bumped it up to 250 and that seems to have taken care of the errors.

Thanks again for the support Hert! Again very impressed with your prompt responses for support.
Photo Supreme V5 Server Edition (build 2971)
PostgreSQL 12
macOS 10.15.4 (Catalina)
Mac Pro (Late 2013), 3.0 GHz 8-Core Xeon E5, 64 GB DDR3
MacBook Pro (Mid 2015), 2.5 GHz Quad-Core i7, 16 GB DDR3L

HCS
Posts: 153
Joined: 19 Feb 14 22:08

Re: Errors during Geo-Tagging

Post by HCS » 30 Jun 20 10:04

Yeah, the current system seems to require roughly 250 - 300 connections to allow for larger workloads like copying large(r) batches of files to drives or updating large(r) batches of files with tags etc.

@Hert, perhaps the lower limit of 250 could be mentioned as a tip in the documentation.

@Hert, it would be awesome if we could get DB control parameters in the client application, so that the application manages some of these workloads within the scope of the actual DB setting, as to prevent out of memory and too many client exceptions. Is there already some Mantis ticket about this?

Post Reply