Skip to content
This repository was archived by the owner on Nov 14, 2023. It is now read-only.
This repository was archived by the owner on Nov 14, 2023. It is now read-only.

[11.0] session_store with worker > 0 #24

Description

@maitredede

Hi,

I am trying to use muk_session_store module with config worker = 10 on Odoo 11.

I have this error : AttributeError: 'PostgresSessionStore' object has no attribute 'cursor'

Can it be related to multithreading issues with SessionStore objects ?

Some log parts :

2019-11-04 05:45:39,143 24 INFO ? odoo.http: HTTP Configuring static files
2019-11-04 05:45:39,159 24 INFO ? odoo.sql_db: Connection to the database failed
2019-11-04 05:45:39,409 24 INFO ? werkzeug: 172.28.0.1 - - [04/Nov/2019 05:45:39] "GET / HTTP/1.1" 500 -
2019-11-04 05:45:39,417 24 ERROR ? werkzeug: Error on request:
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 205, in run_wsgi
    execute(self.server.app)
  File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 193, in execute
    application_iter = app(environ, start_response)
  File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 166, in application
    return application_unproxied(environ, start_response)
  File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 154, in application_unproxied
    result = handler(environ, start_response)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1321, in __call__
    return self.dispatch(environ, start_response)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1295, in __call__
    return self.app(environ, start_wrapped)
  File "/usr/lib/python3/dist-packages/werkzeug/wsgi.py", line 599, in __call__
    return self.app(environ, start_response)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1457, in dispatch
    explicit_session = self.setup_session(httprequest)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1364, in setup_session
    session_gc(self.session_store)
  File "/usr/lib/python3/dist-packages/odoo/tools/func.py", line 23, in __get__
    value = self.fget(obj)
  File "/var/lib/isi-addons/muk_session_store/patch/http.py", line 82, in session_store
    return postgres.PostgresSessionStore(session_class=http.OpenERPSession)
  File "/var/lib/isi-addons/muk_session_store/store/postgres.py", line 53, in __init__
    self._open_connection()
  File "/var/lib/isi-addons/muk_session_store/store/postgres.py", line 74, in _open_connection
    self._create_database()
  File "/var/lib/isi-addons/muk_session_store/store/postgres.py", line 64, in _create_database
    self._setup_db()
  File "/var/lib/isi-addons/muk_session_store/store/postgres.py", line 39, in wrapper
    return func(self, *args, **kwargs)
  File "/var/lib/isi-addons/muk_session_store/store/postgres.py", line 79, in _setup_db
    self.cursor.execute("""
AttributeError: 'PostgresSessionStore' object has no attribute 'cursor'
2019-11-04 05:45:39,649 31 INFO ? odoo: Odoo version 11.0-20191104
2019-11-04 05:45:39,649 31 INFO ? odoo: Using configuration file at /etc/odoo/odoo.conf

I am running a customized docker container (based on official script, adding your modules and some others). The odoo.conf contains workers = 10 . I encountered this error when trying to run unit tests with this image. It creates an empty database, and it fails at first authentication.
If I remove the worker parameter (leave it to default), it works fine.

Has someone of something I can try to make it work ? So I can try to improve my Odoo instance concurrent workload... Thanks :)

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions