Postgres exception: Cannot create 144 scidb instances


#1

Found this error when trying to create 144 instance SciDB cluster:

scidb.py: ERROR: Postgres exception: 

Cannot create 144 scidb instances: Postgres (max_connections) currently allows only 100 connections!

Here is the solution:

The error is related to a limit set in postgresql.conf (at: /etc/postgresql/[VERSION]/main/postgresql.conf).

Raise it and then restart Postgres.

sudo /etc/init.d/postgresql restart

#2

I know, right? There I was innocently trying to start 272 instances when I ran into this silly error.

I wonder how many instances are in the largest (non-test) SciDB cluster?


#3

Any ideas @apoliakov, @plumber?


#4

We see 128 to 192 pretty often.
I heard rumors about 512 somewhere.