Odoo11: Error in Inventory Products page

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Accounting
Inventory
PoS
Project management
MRP

Take the tour

Posts People Badges

Tags View all

odoo accounting v7 pos invoice

About this forum

Help

Odoo11: Error in Inventory Products page

2 Replies

2635 Views

log connection pool odoo11 ErrorTraceback

Filippo

I've noticed, suddenly, that opening the inventory/product page I get the following error in the console:

/web/image?model=product.template&field=image_small&id=3513&unique= 500
/web/image?model=product.template&field=image_small&id=3179&unique= 403

Also in server log i can found starting from the last days the following error:

2020-10-02 10:07:53,265 5892 INFO matranga werkzeug: [MyIpAddress with admin user] - - [02/Oct/2020 10:07:53] "GET /web/image?model=product.product&field=image_medium&id=1319 HTTP/1.1" 403 -
2020-10-02 10:07:53,281 5892 ERROR matranga werkzeug: Error on request:
Traceback (most recent call last):
  File "C:\Program Files (x86)\Odoo 11.0\python\lib\site-packages\werkzeug\serving.py", line 209, in run_wsgi
    execute(self.server.app)
  File "C:\Program Files (x86)\Odoo 11.0\python\lib\site-packages\werkzeug\serving.py", line 197, in execute
    application_iter = app(environ, start_response)
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\service\server.py", line 252, in app
    return self.app(e, s)
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\service\wsgi_server.py", line 164, in application
    return werkzeug.contrib.fixers.ProxyFix(application_unproxied)(environ, start_response)
  File "C:\Program Files (x86)\Odoo 11.0\python\lib\site-packages\werkzeug\contrib\fixers.py", line 152, in __call__
    return self.app(environ, start_response)
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\service\wsgi_server.py", line 154, in application_unproxied
    result = handler(environ, start_response)
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\http.py", line 1313, in __call__
    return self.dispatch(environ, start_response)
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\http.py", line 1287, in __call__
    return self.app(environ, start_wrapped)
  File "C:\Program Files (x86)\Odoo 11.0\python\lib\site-packages\werkzeug\wsgi.py", line 600, in __call__
    return self.app(environ, start_response)
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\http.py", line 1477, in dispatch
    result = ir_http._dispatch()
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\addons\website_sale\models\ir_http.py", line 15, in _dispatch
    return super(IrHttp, cls)._dispatch()
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\addons\auth_signup\models\ir_http.py", line 19, in _dispatch
    return super(Http, cls)._dispatch()
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\addons\web_editor\models\ir_http.py", line 21, in _dispatch
    return super(IrHttp, cls)._dispatch()
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\addons\http_routing\models\ir_http.py", line 391, in _dispatch
    result = super(IrHttp, cls)._dispatch()
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\addons\utm\models\ir_http.py", line 16, in _dispatch
    for var, dummy, cook in request.env['utm.mixin'].tracking_fields():
  File "C:\Program Files (x86)\Odoo 11.0\python\lib\site-packages\werkzeug\local.py", line 347, in __getattr__
    return getattr(self._get_current_object(), name)
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\http.py", line 253, in env
    self._env = odoo.api.Environment(self.cr, self.uid, self.context)
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\http.py", line 225, in cr
    self._cr = self.registry.cursor()
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\modules\registry.py", line 484, in cursor
    return self._db.cursor()
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\sql_db.py", line 634, in cursor
    return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\sql_db.py", line 178, in __init__
    self._cnx = pool.borrow(dsn)
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\sql_db.py", line 517, in _locked
    return fun(self, *args, **kwargs)
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\sql_db.py", line 580, in borrow
    raise PoolError('The Connection Pool Is Full')
psycopg2.pool.PoolError: The Connection Pool Is Full2020-10-02 10:07:53,265 5892 INFO matranga werkzeug: [MyIpAddress with admin user] - - [02/Oct/2020 10:07:53] "GET /web/image?model=product.product&field=image_medium&id=1319 HTTP/1.1" 403 -
2020-10-02 10:07:53,281 5892 ERROR matranga werkzeug: Error on request:
Traceback (most recent call last):
  File "C:\Program Files (x86)\Odoo 11.0\python\lib\site-packages\werkzeug\serving.py", line 209, in run_wsgi
    execute(self.server.app)
  File "C:\Program Files (x86)\Odoo 11.0\python\lib\site-packages\werkzeug\serving.py", line 197, in execute
    application_iter = app(environ, start_response)
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\service\server.py", line 252, in app
    return self.app(e, s)
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\service\wsgi_server.py", line 164, in application
    return werkzeug.contrib.fixers.ProxyFix(application_unproxied)(environ, start_response)
  File "C:\Program Files (x86)\Odoo 11.0\python\lib\site-packages\werkzeug\contrib\fixers.py", line 152, in __call__
    return self.app(environ, start_response)
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\service\wsgi_server.py", line 154, in application_unproxied
    result = handler(environ, start_response)
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\http.py", line 1313, in __call__
    return self.dispatch(environ, start_response)
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\http.py", line 1287, in __call__
    return self.app(environ, start_wrapped)
  File "C:\Program Files (x86)\Odoo 11.0\python\lib\site-packages\werkzeug\wsgi.py", line 600, in __call__
    return self.app(environ, start_response)
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\http.py", line 1477, in dispatch
    result = ir_http._dispatch()
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\addons\website_sale\models\ir_http.py", line 15, in _dispatch
    return super(IrHttp, cls)._dispatch()
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\addons\auth_signup\models\ir_http.py", line 19, in _dispatch
    return super(Http, cls)._dispatch()
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\addons\web_editor\models\ir_http.py", line 21, in _dispatch
    return super(IrHttp, cls)._dispatch()
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\addons\http_routing\models\ir_http.py", line 391, in _dispatch
    result = super(IrHttp, cls)._dispatch()
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\addons\utm\models\ir_http.py", line 16, in _dispatch
    for var, dummy, cook in request.env['utm.mixin'].tracking_fields():
  File "C:\Program Files (x86)\Odoo 11.0\python\lib\site-packages\werkzeug\local.py", line 347, in __getattr__
    return getattr(self._get_current_object(), name)
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\http.py", line 253, in env
    self._env = odoo.api.Environment(self.cr, self.uid, self.context)
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\http.py", line 225, in cr
    self._cr = self.registry.cursor()
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\modules\registry.py", line 484, in cursor
    return self._db.cursor()
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\sql_db.py", line 634, in cursor
    return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\sql_db.py", line 178, in __init__
    self._cnx = pool.borrow(dsn)
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\sql_db.py", line 517, in _locked
    return fun(self, *args, **kwargs)
  File "C:\Program Files (x86)\Odoo 11.0\server\odoo\sql_db.py", line 580, in borrow
    raise PoolError('The Connection Pool Is Full')
psycopg2.pool.PoolError: The Connection Pool Is Full

This is appening even if there are not a lot of connection, I can see from Analytics about 5 user connected during the issue.

Also , a couple of time, trying to open a product detail page, I've got a Memory Error and I was forced to restart the server.

Can anyone please help to better understand the issue to find a solution?

The following is my odoo conf

Sudhir Arya (ERP Harbor Consulting Services)

Best Answer

This happens when postgres request reaches its limit. Try to increase "db_maxconn" value to something bigger like 100 in the Odoo config file and restart the server.

Please post the memory error logs to find the exact issue. It could be due to RAM is very less.

Filippo

Author

Hi, I have still the error on connection pool and now also another error about thread:

_start_new_thread(self._bootstrap, ())

RuntimeError: can't start new thread

this error where not there since some week ago, the only major difference is on the http2 activation on the server.

Any suggestion on how to configure the server or on the specific error?

Thanks.

Filippo

Author

Sudhir, about the MemoryError, this is the log:

2020-10-16 07:54:32,107 4000 ERROR matranga odoo.http: Exception during JSON request handling.

Traceback (most recent call last):

File "C:\Program Files (x86)\Odoo 11.0\server\odoo\http.py", line 647, in _handle_exception

return super(JsonRequest, self)._handle_exception(exception)

File "C:\Program Files (x86)\Odoo 11.0\server\odoo\http.py", line 307, in _handle_exception

raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])

File "C:\Program Files (x86)\Odoo 11.0\server\odoo\tools\pycompat.py", line 87, in reraise

raise value

File "C:\Program Files (x86)\Odoo 11.0\server\odoo\http.py", line 703, in dispatch

return self._json_response(result)

File "C:\Program Files (x86)\Odoo 11.0\server\odoo\http.py", line 635, in _json_response

body = json.dumps(response, default=ustr)

File "C:\Program Files (x86)\Odoo 11.0\python\lib\json\__init__.py", line 238, in dumps

**kw).encode(obj)

File "C:\Program Files (x86)\Odoo 11.0\python\lib\json\encoder.py", line 199, in encode

chunks = self.iterencode(o, _one_shot=True)

File "C:\Program Files (x86)\Odoo 11.0\python\lib\json\encoder.py", line 257, in iterencode

return _iterencode(o, 0)

MemoryError

During the error, the Python (32 bit) windows process was consuming 322,9MB of RAM and the system total Ram cosumed was at 58% so there was 42% of free RAM

And this is my server hardware:

Processor: Intel Xeon CPU E5-2640 v4 @2.40Ghz 2.40 GHz

Memory (RAM): 4.00 GB

Windows Server 2012 64bit

the following is my odoo.conf file:

[options]

db_maxconn = 90

limit_memory_hard = None

limit_memory_soft = None

limit_request = None

limit_time_cpu = None

limit_time_real = None

limit_time_real_cron = None

list_db = True

log_db = False

log_db_level = warning

log_handler = :INFO

log_level = info

logfile = C:\Program Files (x86)\Odoo 11.0\server\odoo.log

logrotate = False

longpolling_port = 8072

max_cron_threads = 2

osv_memory_age_limit = 1.0

osv_memory_count_limit = False

pg_path = C:\Program Files (x86)\Odoo 11.0\PostgreSQL\bin

pidfile = False

proxy_mode = True

reportgz = False

server_wide_modules = web

syslog = False

test_commit = False

test_enable = False

test_file = False

test_report_directory = False

translate_modules = ['all']

unaccent = False

without_demo = False

workers = None

Any help would be appreciated.

Filippo

Author

I was not sure about this solution, since the user connected were low during the error. By the way I've modified the db_maxconn parameter and now seems ok.

I will check the log in next days to be sure about the solution.

Thank,

Filippo.

This question has been flagged