Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Financeiro
Inventário
PoS
Projeto
MRP

All apps

Todas as publicações Pessoas Emblemas

Marcadores (Ver tudo)

odoo accounting v14 pos v15

Sobre este fórum

Ajuda

"PoolError: The Connection Pool Is Full" with 100 users

users login

4 Respostas

40730 Visualizações

Landy

I run 100 user on OpenERP, I have some error message.....

would you please kindly help me, Thank you....

1ã
2014-01-05 15:49:14,305 7295 ERROR ? openerp.netsvc: FATAL:  sorry, too many clients already
Traceback (most recent call last):
  File "/home/landy/openerp-7.0-20131121-002445/openerp/netsvc.py", line 292, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)

  File "/home/landy/openerp-7.0-20131121-002445/openerp/service/web_services.py", line 122, in dispatch
    return fn(*params)

  File "/home/landy/openerp-7.0-20131121-002445/openerp/service/web_services.py", line 359, in exp_list
    cr = db.cursor()

  File "/home/landy/openerp-7.0-20131121-002445/openerp/sql_db.py", line 484, in cursor
    return Cursor(self._pool, self.dbname, serialized=serialized)

  File "/home/landy/openerp-7.0-20131121-002445/openerp/sql_db.py", line 182, in __init__
    self._cnx = pool.borrow(dsn(dbname))

  File "/home/landy/openerp-7.0-20131121-002445/openerp/sql_db.py", line 377, in _locked
    return fun(self, *args, **kwargs)

  File "/home/landy/openerp-7.0-20131121-002445/openerp/sql_db.py", line 440, in borrow
    result = psycopg2.connect(dsn=dsn, connection_factory=PsycoConnection)

  File "/usr/lib/python2.7/dist-packages/psycopg2/__init__.py", line 179, in connect
    connection_factory=connection_factory, async=async)

OperationalError: FATAL:  sorry, too many clients already



2ã
2013-12-23 08:43:51,600 2347 ERROR ? openerp.netsvc: The Connection Pool Is Full
Traceback (most recent call last):

  File "/home/landy/openerp-7.0-20131121-002445/openerp/netsvc.py", line 292, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)

  File "/home/landy/openerp-7.0-20131121-002445/openerp/service/web_services.py", line 122, in dispatch
    return fn(*params)

  File "/home/landy/openerp-7.0-20131121-002445/openerp/service/web_services.py", line 359, in exp_list
    cr = db.cursor()

  File "/home/landy/openerp-7.0-20131121-002445/openerp/sql_db.py", line 484, in cursor
    return Cursor(self._pool, self.dbname, serialized=serialized)

  File "/home/landy/openerp-7.0-20131121-002445/openerp/sql_db.py", line 182, in __init__
    self._cnx = pool.borrow(dsn(dbname))

  File "/home/landy/openerp-7.0-20131121-002445/openerp/sql_db.py", line 377, in _locked
    return fun(self, *args, **kwargs)

  File "/home/landy/openerp-7.0-20131121-002445/openerp/sql_db.py", line 437, in borrow
    raise PoolError('The Connection Pool Is Full')

PoolError: The Connection Pool Is Full

Gustavo

Melhor resposta

Try increasing the db_maxconn parameter in the openerp-server.conf file, that parameter allows you to increase the number con connections in your database

Landy

Autor

I set db_maxconn=1000 in file of openerp-server.conf and set max_connections = 1000 in file of Postgresql.conf, but there exists the same error in both files. What can I do?

This is my openerp-server.conf file as follow?

[options]

; This is the password that allows database operations:

; admin_passwd = admin

db_host = False

db_port = False

db_user = landy

db_password = xxxxxxxx

db_maxconn=1000

logfile = /var/log/openerp/openerp-server.log

logrotate = True

syslog = False

log_handler = [':INFO']

log_level = debug

howaryoo

Hi,

I also has this error, and noticed that starting openerp with (the new built-in multiprocess mode in v7):

â«./openerp-server --workers=4

(or higher number of workers) solved this problem.

@Landy would you please share the tool you used to make your 100 concurrent user test ?

Nimesh

I have resolved the same error by following :

--max-cron-threads <count>

number of workers dedicated to cron jobs. Defaults to 2. The workers are threads in multithreading mode and processes in multiprocessing mode.

Landy

Autor

I set db_maxconn=1000 in file of openerp-server.conf and set max_connections = 1000 in file of Postgresql.conf, but there exists the same error in both files. What can I do?

This is my openerp-server.conf file as follow?

[options]

; This is the password that allows database operations:

; admin_passwd = admin

db_host = False

db_port = False

db_user = landy

db_password = xxxxxxxx

db_maxconn=1000

logfile = /var/log/openerp/openerp-server.log

logrotate = True

syslog = False

log_handler = [':INFO']

log_level = debug

Está gostando da discussão? Não fique apenas lendo, participe!

Crie uma conta hoje mesmo para aproveitar os recursos exclusivos e interagir com nossa incrível comunidade!

Publicações relacionadas	Respostas	Visualizações
How to link user to custom model in Odoo to sing up and log in? users login	1 nov. 20	5413
Limited User can access Openerp 7 users login	0 mar. 15	3558
Odoo Community Edition 18 Adding Users Without Email Resolvido users user login	1 nov. 24	3826
Getting internal server error in database. Resolvido web users login	2 jul. 19	5309
Someone Deleted Default and Public users Resolvido users login user_management	2 mar. 24	6539

Esta pergunta foi sinalizada

This is my openerp-server.conf file as follow?

Está gostando da discussão? Não fique apenas lendo, participe!