← Back to team overview

openerp-expert-framework team mailing list archive

Re: [Openerp-community] Postgresql connection pool problem

 

See your postgres log, probably, postgres server was restarted, and you
must restart OpenERP too!.

2013/2/5 Baskhuu Jacara <baskhuujacara@xxxxxxxxx>

> 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?
>
>
> --
> Хүндэтгэсэн
> *Басхүү.Л*
> *
> *
> Хувь заяа бол магадлалын асуудал биш. Энэ бол сонголт. Түүнийг хүлээх биш,
> бүтээх учиртай.
> Хэрэв боломж хаалгыг чинь тогшихгүй байвал эхлээд хаалгаа барь.
>
> _______________________________________________
> Mailing list: https://launchpad.net/~openerp-community
> Post to     : openerp-community@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openerp-community
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
--------------------
Saludos Cordiales

Nhomar G. Hernandez M.
+58-414-4110269
Skype: nhomar00
Web-Blog: http://geronimo.com.ve
Servicios IT: http://vauxoo.com
Linux-Counter: 467724
Correos:
nhomar@xxxxxxxxxxxxxx
nhomar@xxxxxxxxxx
twitter @nhomar

Follow ups

References