openerp-community team mailing list archive
-
openerp-community team
-
Mailing list archive
-
Message #02167
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