Re: pgadmin4 exception: session['_id'] not in self.managers

sure Dave

--
*Harshal Dhumal*
*Sr. Software Engineer*

EnterpriseDB India: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Mon, Oct 9, 2017 at 1:16 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:

> Harshal, can you help with this please?
>
> On Sun, Oct 8, 2017 at 12:39 AM, David Gilman <davidgilman1(at)gmail(dot)com>
> wrote:
>
>> I'm trying out pgadmin4 v2.0 for the first time. It seems that after
>> only a few minutes (maybe even less than five) my pgadmin4 session will get
>> logged out and I'll need to log in again and reopen everything from
>> scratch. This exception is thrown in the mod_wsgi logs:
>>
>> mod_wsgi (pid=5965): Exception occurred processing WSGI script
>> '/home/pgadmin/venv/lib/python2.7/site-packages/pgadmin4/pgAdmin4.wsgi'.
>> Traceback (most recent call last):
>> File "/home/pgadmin/venv/local/lib/python2.7/site-packages/flask/app.py",
>> line 2000, in __call__
>> return self.wsgi_app(environ, start_response)
>> File "/home/pgadmin/venv/local/lib/python2.7/site-packages/flask/app.py",
>> line 1991, in wsgi_app
>> response = self.make_response(self.handle_exception(e))
>> File "/home/pgadmin/venv/local/lib/python2.7/site-packages/flask/app.py",
>> line 1567, in handle_exception
>> reraise(exc_type, exc_value, tb)
>> File "/home/pgadmin/venv/local/lib/python2.7/site-packages/flask/app.py",
>> line 1988, in wsgi_app
>> response = self.full_dispatch_request()
>> File "/home/pgadmin/venv/local/lib/python2.7/site-packages/flask/app.py",
>> line 1641, in full_dispatch_request
>> rv = self.handle_user_exception(e)
>> File "/home/pgadmin/venv/local/lib/python2.7/site-packages/flask/app.py",
>> line 1544, in handle_user_exception
>> reraise(exc_type, exc_value, tb)
>> File "/home/pgadmin/venv/local/lib/python2.7/site-packages/flask/app.py",
>> line 1639, in full_dispatch_request
>> rv = self.dispatch_request()
>> File "/home/pgadmin/venv/local/lib/python2.7/site-packages/flask/app.py",
>> line 1625, in dispatch_request
>> return self.view_functions[rule.endpoint](**req.view_args)
>> File "/home/pgadmin/venv/local/lib/python2.7/site-packages/flask_login.py",
>> line 792, in decorated_view
>> return func(*args, **kwargs)
>> File "/home/pgadmin/venv/lib/python2.7/site-packages/pgadmin4/
>> pgadmin/dashboard/__init__.py", line 169, in wrap
>> kwargs['sid']
>> File "/home/pgadmin/venv/lib/python2.7/site-packages/pgadmin4/
>> pgadmin/utils/driver/psycopg2/__init__.py", line 2000, in
>> connection_manager
>> if session['_id'] not in self.managers:
>> File "/home/pgadmin/venv/local/lib/python2.7/site-packages/werkzeug/local.py",
>> line 368, in <lambda>
>> __getitem__ = lambda x, i: x._get_current_object()[i]
>> KeyError: '_id'
>>
>> My setup:
>> pgadmin4 v2.0 . The configuration is all defaults except
>> for LOG_FILE/SQLITE_PATH/SESSION_DB_PATH/STORAGE_DIR. That
>> means MAX_SESSION_IDLE_TIME is at its default of 60 (minutes).
>> pgadmin4 is in server mode with mod_wsgi as a host.
>> PostgreSQL 9.4.14 - from the postgres apt repository. No changes made to
>> timeouts or anything in the postgresql.conf , it's all defaults.
>> Python 2.7
>> psycopg2 2.7.3.1
>>
>> I can confirm that the apache process hosting pgadmin4 is running under
>> the right UNIX user account and that it seems to have good
>> access/permissions to its scratch files on disk. I see updates being made
>> to pgadmin4.db and the sessions directory.
>>
>> --
>> David Gilman
>> :DG<
>>
>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>