BUG #12560: can not run alot of databases

Started by Nonameabout 11 years ago2 messagesbugs
Jump to latest
#1Noname
cadabreenow@gmail.com

The following bug has been logged on the website:

Bug reference: 12560
Logged by: haydar
Email address: cadabreenow@gmail.com
PostgreSQL version: 9.1.0
Operating system: debian 7.8
Description:

hello,
i use postgresql on my server and i run isida jabber bot on my server with
postgresql
but i have a FATAL error when i run too many bots about 200 bot
my server ram is 48 GB
and see the error message

root@Boy /bots/linux/cham/is # cd /bots/linux/cham/is; ./launch.sh
[02:09:22] --------------------------------------------------

********************************************************
*** Isida is crashed! It's imposible, but You do it! ***
********************************************************

FATAL: sorry, too many clients already
FATAL: sorry, too many clients already

Traceback (most recent call last):
File "isida.py", line 137, in <module>
try: execfile('kernel.py')
File "kernel.py", line 1780, in <module>
if base_type == 'pgsql': conn = psycopg2.connect(database=base_name,
user=ba
se_user, host=base_host, password=base_pass, port=base_port)
File "/usr/local/lib/python2.7/site-packages/psycopg2/__init__.py", line
179,
in connect
connection_factory=connection_factory, async=async)
OperationalError: FATAL: sorry, too many clients already
FATAL: sorry, too many clients already

==================================================================

please ineed help about that faster

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

#2Mike Porter
mike@udel.edu
In reply to: Noname (#1)
Re: BUG #12560: can not run alot of databases

On Fri, 16 Jan 2015, cadabreenow@gmail.com wrote:

Trying increasing max_connections in the postgresql.conf file.

The following bug has been logged on the website:

Bug reference: 12560
Logged by: haydar
Email address: cadabreenow@gmail.com
PostgreSQL version: 9.1.0
Operating system: debian 7.8
Description:

hello,
i use postgresql on my server and i run isida jabber bot on my server with
postgresql
but i have a FATAL error when i run too many bots about 200 bot
my server ram is 48 GB
and see the error message

root@Boy /bots/linux/cham/is # cd /bots/linux/cham/is; ./launch.sh
[02:09:22] --------------------------------------------------

********************************************************
*** Isida is crashed! It's imposible, but You do it! ***
********************************************************

FATAL: sorry, too many clients already
FATAL: sorry, too many clients already

Traceback (most recent call last):
File "isida.py", line 137, in <module>
try: execfile('kernel.py')
File "kernel.py", line 1780, in <module>
if base_type == 'pgsql': conn = psycopg2.connect(database=base_name,
user=ba
se_user, host=base_host, password=base_pass, port=base_port)
File "/usr/local/lib/python2.7/site-packages/psycopg2/__init__.py", line
179,
in connect
connection_factory=connection_factory, async=async)
OperationalError: FATAL: sorry, too many clients already
FATAL: sorry, too many clients already

==================================================================

please ineed help about that faster

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

-
Mike Porter
PGP Fingerprint: F4 AE E1 9F 67 F7 DA EA 2F D2 37 F3 99 ED D1 C2

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs