[InterMine Dev] Unable to construct query - unable to get a connection to postgreSQL
julie at flymine.org
Tue Oct 30 09:28:28 GMT 2012
Yes, InterMine correctly uses connection pooling. FlyMine only ever has about 8
connections open, 1000 is far too many and I would recommend changing that back
to 50. (even with 6 people/mines on a single server this should be fine)
Since you are testing, it's likely you are generating errors and thus
incorrectly shutting down your builds and/or webapps - causing the connection to
not be returned to the pool.
I would restart postgres and see if it happens again. If so, let me know and you
and I can debug your processes and try to figure out what's going on.
On 30/10/12 03:57, Allan Kamau wrote:
> We are experiencing "Unable to construct query" error for some mines
> that previously did not have such and error. The PostgreSQL logs
> indicate that the number of connections to the database have been
> depleted and that the remaining connection slots have been reserved to
> the super user.
> I increased the number of connections in postgresql.conf file to 1000.
> We are 6 developers configuring several mines on a single server. Does
> Intermine make use of connection pooling in order to potentially
> reduce the number of connections to PostgreSQL?
> dev mailing list
> dev at intermine.org
More information about the dev