This question has been flagged
1 Reply
10541 Views
serverOdoo9
Avatar
Tenth Planet

I am using Odoo9 and PostgreSQL 9.5, I am getting following error and server is stopped automatically.

Total Odoo Users 70 members

Active connections 40 - 50 

2019-12-02 12:56:06,216 24842 ERROR ? openerp.service.server: Exception happened during processing of request from ('192.168.1.192', 61333)
Traceback (most recent call last):
File "/usr/lib/python2.7/SocketServer.py", line 290, in _handle_request_noblock
self.process_request(request, client_address)
File "/usr/lib/python2.7/SocketServer.py", line 607, in process_request
t.start()
File "/usr/lib/python2.7/threading.py", line 736, in start
_start_new_thread(self.__bootstrap, ())
error: can't start new thread

Avatar
Discard
Avatar
Hilar Andikkadavath
Best Answer

I think you should properly configure the workers for your servers. This error almost certainly due to the fact that you have already had too many threads running within your python process, and due to a resource limit of some kind the request to create a new thread is refused.


Configuration sample

  • Server with 4 CPU, 8 Thread
  • 60 concurrent users
  • 60 users / 6 = 10 <- theoretical number of worker needed
  • (4 * 2) + 1 = 9 <- theoretical maximal number of worker
  • We’ll use 8 workers + 1 for CRON. We’ll also use a monitoring system to measure CPU load and check if it’s between 7 and 7.5.
  • RAM = 9 * ((0.8*150) + (0.2*1024)) ~= 3Go RAM for Odoo

In Odoo.Conf


[options]
limit_memory_hard = 1677721600
limit_memory_soft = 629145600
limit_request = 8192
limit_time_cpu = 600
limit_time_real = 1200
max_cron_threads = 1
workers = 8
For more details Read Odoo Deployment Documentation.
https://www.odoo.com/documentation/11.0/setup/deploy.html#builtin-server



Avatar
Discard