Re: pgAdmin4 - Session file name too large

On Sun, May 8, 2016 at 6:09 PM, eMerzh <merzhin(at)gmail(dot)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
<http://www.enterprisedb.com/>

*http://www.linkedin.com/in/asheshvashi*
<http://www.linkedin.com/in/asheshvashi>

> Regards,
>
> Brice
>
> 2016-04-17 13:02 GMT+02:00 Dave Page <dpage(at)pgadmin(dot)org>:
>
>> Ok, good. Please let us know if it reoccurs.
>>
>> Sent from my iPad
>>
>> On 17 Apr 2016, at 08:26, eMerzh <merzhin(at)gmail(dot)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(at)pgadmin(dot)org> a écrit :
>>
>> Hi
>>
>> Ashesh, can you look at this please? I cannot reproduce it.
>>
>>
>> On Friday, April 15, 2016, eMerzh <merzhin(at)gmail(dot)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
>>
>>
>