← Back to team overview

openerp-expert-framework team mailing list archive

Re: [Openerp-community] Postgresql connection pool problem

 

No no.

I have 5 application servers and 1 database server. There is only one
server getting connection problem and others has no problem every night.
Database server working fine.

On Wed, Feb 6, 2013 at 10:40 AM, Nhomar Hernández <nhomar@xxxxxxxxx> wrote:

> 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




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

References