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