public inbox for [email protected]  
help / color / mirror / Atom feed
pgAdmin4 - Session file name too large
5+ messages / 3 participants
[nested] [flat]

* pgAdmin4 - Session file name too large
@ 2016-04-15 17:59  eMerzh <[email protected]>
  0 siblings, 1 reply; 5+ messages in thread

From: eMerzh @ 2016-04-15 17:59 UTC (permalink / raw)
  To: pgadmin-hackers

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


^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: pgAdmin4 - Session file name too large
@ 2016-04-16 22:55  Dave Page <[email protected]>
  parent: eMerzh <[email protected]>
  0 siblings, 1 reply; 5+ messages in thread

From: Dave Page @ 2016-04-16 22:55 UTC (permalink / raw)
  To: eMerzh <[email protected]>; +Cc: pgadmin-hackers; Ashesh Vashi <[email protected]>

Hi

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

On Friday, April 15, 2016, eMerzh <[email protected]> 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


^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: pgAdmin4 - Session file name too large
@ 2016-04-17 11:02  Dave Page <[email protected]>
  parent: Dave Page <[email protected]>
  0 siblings, 1 reply; 5+ messages in thread

From: Dave Page @ 2016-04-17 11:02 UTC (permalink / raw)
  To: eMerzh <[email protected]>; +Cc: pgadmin-hackers; Ashesh Vashi <[email protected]>

Ok, good. Please let us know if it reoccurs.

Sent from my iPad

> On 17 Apr 2016, at 08:26, eMerzh <[email protected]> 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" <[email protected]> a écrit :
> Hi
> 
> Ashesh, can you look at this please? I cannot reproduce it.
> 
> 
>> On Friday, April 15, 2016, eMerzh <[email protected]> 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
> 


^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: pgAdmin4 - Session file name too large
@ 2016-05-08 12:39  eMerzh <[email protected]>
  parent: Dave Page <[email protected]>
  0 siblings, 1 reply; 5+ messages in thread

From: eMerzh @ 2016-05-08 12:39 UTC (permalink / raw)
  To: Dave Page <[email protected]>; +Cc: pgadmin-hackers; Ashesh Vashi <[email protected]>

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))


hope this helps :)
Regards,

Brice

2016-04-17 13:02 GMT+02:00 Dave Page <[email protected]>:

> Ok, good. Please let us know if it reoccurs.
>
> Sent from my iPad
>
> On 17 Apr 2016, at 08:26, eMerzh <[email protected]> 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" <[email protected]> a écrit :
>
> Hi
>
> Ashesh, can you look at this please? I cannot reproduce it.
>
>
> On Friday, April 15, 2016, eMerzh <[email protected]> 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
>
>


^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: pgAdmin4 - Session file name too large
@ 2016-05-08 18:36  Ashesh Vashi <[email protected]>
  parent: eMerzh <[email protected]>
  0 siblings, 0 replies; 5+ messages in thread

From: Ashesh Vashi @ 2016-05-08 18:36 UTC (permalink / raw)
  To: eMerzh <[email protected]>; +Cc: Dave Page <[email protected]>; pgadmin-hackers

On Sun, May 8, 2016 at 6:09 PM, eMerzh <[email protected]> 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 <[email protected]>:
>
>> Ok, good. Please let us know if it reoccurs.
>>
>> Sent from my iPad
>>
>> On 17 Apr 2016, at 08:26, eMerzh <[email protected]> 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" <[email protected]> a écrit :
>>
>> Hi
>>
>> Ashesh, can you look at this please? I cannot reproduce it.
>>
>>
>> On Friday, April 15, 2016, eMerzh <[email protected]> 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
>>
>>
>


^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2016-05-08 18:36 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-04-15 17:59 pgAdmin4 - Session file name too large eMerzh <[email protected]>
2016-04-16 22:55 ` Dave Page <[email protected]>
2016-04-17 11:02   ` Dave Page <[email protected]>
2016-05-08 12:39     ` eMerzh <[email protected]>
2016-05-08 18:36       ` Ashesh Vashi <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox