← Back to team overview

openerp-community team mailing list archive

Postgresql connection pool problem

 

Hello

I'm using openerp 6.1 version with postgresql server 9.1 on Ubuntu 12.04.

Everything works fine during a day. But in night or morning becomes
connection pool problem.


2013-02-06 08:48:07,509 24520 ERROR ? netsvc: Could not authenticate
Traceback (most recent call last):
  File "/home/openerp/openerp-server/openerp/addons/base_crypt/crypt.py",
line 197, in login
    with closing(pooler.get_db(db).cursor()) as cr:
  File "/home/openerp/openerp-server/openerp/sql_db.py", line 469, in cursor
    return Cursor(self._pool, self.dbname, serialized=serialized)
  File "/home/openerp/openerp-server/openerp/sql_db.py", line 180, in
__init__
    self.autocommit(False)
  File "/home/openerp/openerp-server/openerp/sql_db.py", line 152, in
wrapper
    return f(self, *args, **kwargs)
  File "/home/openerp/openerp-server/openerp/sql_db.py", line 325, in
autocommit
    self._cnx.set_isolation_level(isolation_level)
OperationalError: no connection to the server

2013-02-06 08:48:07,510 24520 WARNING ? openerp.sql_db: Cursor not closed
explicitly
Please enable sql debugging to trace the caller.
2013-02-06 08:48:07,510 24520 WARNING ? openerp.sql_db:
ConnectionPool(used=0/count=4/max=256): Free leaked connection to
'host=10.0.6.2 user=openerp dbname=openerpdb'
2013-02-06 08:48:07,511 24520 ERROR ? openerp.netsvc: no connection to the
server

2013-02-06 08:48:07,511 24520 WARNING ? openerp.sql_db: Cursor not closed
explicitly
Please enable sql debugging to trace the caller.


Why this is happening and how do i fix this problem?


-- 
Хүндэтгэсэн
*Басхүү.Л*
*
*
Хувь заяа бол магадлалын асуудал биш. Энэ бол сонголт. Түүнийг хүлээх биш,
бүтээх учиртай.
Хэрэв боломж хаалгыг чинь тогшихгүй байвал эхлээд хаалгаа барь.

Follow ups