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 | etc.
I get this "500 Internal Server Error", can anyone please help to find out how to solve this issue ?
Odoo Server Error
Traceback (most recent call last): File "/opt/odoo/odoo/openerp/http.py", line 539, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/opt/odoo/odoo/openerp/http.py", line 576, in dispatch result = self._call_function(**self.params) File "/opt/odoo/odoo/openerp/http.py", line 312, in _call_function return checked_call(self.db, *args, **kwargs) File "/opt/odoo/odoo/openerp/service/model.py", line 118, in wrapper return f(dbname, *args, **kwargs) File "/opt/odoo/odoo/openerp/http.py", line 309, in checked_call return self.endpoint(*a, **kw) File "/opt/odoo/odoo/openerp/http.py", line 805, in __call__ return self.method(*args, **kw) File "/opt/odoo/odoo/openerp/http.py", line 405, in response_wrap response = f(*args, **kw) File "/opt/odoo/odoo/addons/web/controllers/main.py", line 944, in call_kw return self._call_kw(model, method, args, kwargs) File "/opt/odoo/odoo/addons/web/controllers/main.py", line 936, in _call_kw return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/werkzeug/local.py", line 338, in __getattr__ return getattr(self._get_current_object(), name) File "/opt/odoo/odoo/openerp/http.py", line 248, in cr self._cr = self.registry.cursor() File "/opt/odoo/odoo/openerp/modules/registry.py", line 272, in cursor return self._db.cursor() File "/opt/odoo/odoo/openerp/sql_db.py", line 609, in cursor return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized) File "/opt/odoo/odoo/openerp/sql_db.py", line 181, in __init__ self._cnx = pool.borrow(dsn) File "/opt/odoo/odoo/openerp/sql_db.py", line 498, in _locked return fun(self, *args, **kwargs) File "/opt/odoo/odoo/openerp/sql_db.py", line 560, in borrow result = psycopg2.connect(dsn=dsn, connection_factory=PsycoConnection) File "/usr/lib/python2.7/dist-packages/psycopg2/__init__.py", line 179, in connect connection_factory=connection_factory, async=async) OperationalError: FATAL: remaining connection slots are reserved for non-replication superuser connections
For now just restart your PostgreSQL which will close the all active connectionFor permanent solution You either need to increase the
configuration setting or (probably better) use connection polling (PgBouncer and Pgpool) to route a large number of user requests through a smaller connection pool.
thank you for your reply. I'm running odoo on Ubuntu server in the cloud: 2 GB Memory / 2 CPUs / 40 GB SSD Disk. We are 10 users.
I have edit default installation postgresql.conf file as follow and this has generated the problem:
max_connections = 15
shared_buffers = 512MB
effective_cache_size = 1024MB
checkpoint_segments = 10
checkpoint_completion_target = 0.9
work_mem = 8MB
maintenance_work_mem = 32MB
I will now change max_connections to 30 and let me ask you, the other configuration you see above do you think they are correct ?
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 5/11/16, 9:58 AM|
|Seen: 1386 times|
|Last updated: 5/11/16, 1:51 PM|