Re: pgAdmin4 - Session file name too large - Mailing list pgadmin-hackers

From Ashesh Vashi
Subject Re: pgAdmin4 - Session file name too large
Date
Msg-id CAG7mmoxxbaXyj9qwOb-XffbUP3zPHM4CCMuufV9yiDXUK_rnXw@mail.gmail.com
Whole thread Raw
In response to pgAdmin4 - Session file name too large  (eMerzh <merzhin@gmail.com>)
List pgadmin-hackers

On Sun, May 8, 2016 at 6:09 PM, eMerzh <merzhin@gmail.com> wrote:

Hi guys,

i was just updating my working copy of git, and got the same issue again.

it seems that the issue happend every time (or at least really often) when i pull new changes.
so it might still be some issues with the session management.

to hel you understand my workflow, here are the step that i did:
a couple of days ago i've tested pgAdmin...
so today i did a git pull
...
Updating 07e0de5..c8406a5
...
then activate my venv,
then python web/pgAdmin4.py
and then i got the error :
OSError: [Errno 63] File name too long: ...
web/pgadmin/utils/session.py", line 60, in __init__
    sess_db = os.open(self.path, os.O_CREAT, int("600", 8))

I am surprised to see the behaviour.
I've committed a probable fix to handle the case. 


hope this helps :)
 
Thanks for the report.

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


Regards,

Brice

2016-04-17 13:02 GMT+02:00 Dave Page <dpage@pgadmin.org>:
Ok, good. Please let us know if it reoccurs.

Sent from my iPad

On 17 Apr 2016, at 08:26, eMerzh <merzhin@gmail.com> wrote:

Ok guys I think  I found a way to pass the error.
It seems that it was caused by a previous session cookie that was too long or smth.
Deleting my cookies make the app work again :-)

Le 17 avr. 2016 12:55 AM, "Dave Page" <dpage@pgadmin.org> a écrit :
Hi

Ashesh, can you look at this please? I cannot reproduce it.


On Friday, April 15, 2016, eMerzh <merzhin@gmail.com> wrote:
Hi,

I was testing pgAdmin4 rev e210d2b5809355a334508436d9f128b78338dfd3
on osx python python 2.7,
but when i tried to log in, i got a error :


2016-04-15 13:31:47,820: ERROR werkzeug: Error on request:
Traceback (most recent call last):
File "/Users/myuser/pgadmin4/venv/lib/python2.7/site-packages/werkzeug/serving.py", line 177, in run_wsgi
execute(self.server.app)
File "/Users/myuser/pgadmin4/venv/lib/python2.7/site-packages/werkzeug/serving.py", line 165, in execute
application_iter = app(environ, start_response)
File "/Users/myuser/pgadmin4/venv/lib/python2.7/site-packages/flask/app.py", line 1836, in __call__
return self.wsgi_app(environ, start_response)
File "/Users/myuser/pgadmin4/venv/lib/python2.7/site-packages/flask/app.py", line 1813, in wsgi_app
ctx.push()
File "/Users/myuser/pgadmin4/venv/lib/python2.7/site-packages/flask/ctx.py", line 321, in push
self.session = self.app.open_session(self.request)
File "/Users/myuser/pgadmin4/venv/lib/python2.7/site-packages/flask/app.py", line 825, in open_session
return self.session_interface.open_session(self, request)
File "/Users/myuser/pgadmin4/web/pgadmin/utils/session.py", line 209, in open_session
return SqliteSessionStorage(self.directory, sid)
File "/Users/myuser/pgadmin4/web/pgadmin/utils/session.py", line 60, in __init__
sess_db = os.open(self.path, os.O_CREAT, int("600", 8))
OSError: [Errno 63] File name too long: '/Users/myuser/.pgadmin/sessions/.eJxNkUtvozAUhf_KyOto....'

let me know if i can provide you more informations.

Regards,

Brice


--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

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



pgadmin-hackers by date:

Previous
From: Ashesh Vashi
Date:
Subject: pgAdmin 4 commit: Do not honour the session-id, longer than 40 characte
Next
From: Murtuza Zabuawala
Date:
Subject: Re: [pgAdmin4] [Patch]: Foreign Table Module