Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1azTa2-0001Gn-M3 for pgadmin-hackers@arkaria.postgresql.org; Sun, 08 May 2016 18:37:26 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1azTa2-0007zO-8q for pgadmin-hackers@arkaria.postgresql.org; Sun, 08 May 2016 18:37:26 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1azTa1-0007zI-GY for pgadmin-hackers@postgresql.org; Sun, 08 May 2016 18:37:25 +0000 Received: from mail-io0-x22c.google.com ([2607:f8b0:4001:c06::22c]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1azTZt-000276-Ta for pgadmin-hackers@postgresql.org; Sun, 08 May 2016 18:37:24 +0000 Received: by mail-io0-x22c.google.com with SMTP id 190so155465956iow.1 for ; Sun, 08 May 2016 11:37:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=T6Hkqrauj2iCTSguAEhkArcH0joAGNrF7LXEek25LOc=; b=TDxgadgSg5xwGTE8M70V9xR9CwpANrZqXz+cnoh0/Gl2QM+rrBcT/gKCAcPCzr8mtz 4EYQfp8DAxMSadnNkScxsPrnctGy6nJoSY228xVuSRHlstLmnRYZxiZL0XAlasJoqIKn 13X4EFWNSVfFKh9SikoOV9VLHs8f5BX3TTOuU3yvSaxTLcjB8gW7W9e6VsOH1GfJVoVc 5QK7i/z2WVvWbTSlpfE+Dlp1xjrAMKlGWAUVK/urqUrtAbd9xZIYnd8ib5043qpbJpoc crsg9aVzYfyN3KYA9Rpnt93V0Zz3cRQ1ZNK2a+EJBZr2E1SySsOW/xwbUonM8oWj3ACD opsg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=T6Hkqrauj2iCTSguAEhkArcH0joAGNrF7LXEek25LOc=; b=KcvTstuAYstuVYxs3Vke0hger77AB2hkUNMHjRo5CuqHjbSNi2pCt44amWepxSWWV3 auYVsa9iGmkPnnxP1S4e0nIgm7rXhQLsMRxNvvBUkQEtYWI9tLjgBV742BnhGgelmAAU PClNzXEBeKmhRcytTnjVOnlFqb/CVBlWP3N6ED8atms5jm8NSp4h3m8JSCXMZfnwzegl tEt8OZNTFkRCpAy4ajMIab0mC5w3ui3GBBrZ5aFQ3ULpl/uBWPPD3tdiOHvZm4OX4qB0 eh2rPG6EMBXVNJzVtG6wBg5zgYfWiYYNZp8FeP7c5TIG974ruiKawiHSLbkt9rqSNCA9 wekA== X-Gm-Message-State: AOPr4FVGryBB1zH2Vd+13/PnUOtC0yyfvcwdKRuyPs4XxKuftIRF/HcEvFZ+ldZO54joKQLNfgC8ExZXfCHIyhlv X-Received: by 10.107.187.198 with SMTP id l189mr35378507iof.149.1462732637100; Sun, 08 May 2016 11:37:17 -0700 (PDT) MIME-Version: 1.0 Received: by 10.107.39.5 with HTTP; Sun, 8 May 2016 11:36:57 -0700 (PDT) In-Reply-To: References: <8BE41B9F-05BD-44D5-A2F1-EC85EEF80F7E@pgadmin.org> From: Ashesh Vashi Date: Mon, 9 May 2016 00:06:57 +0530 Message-ID: Subject: Re: pgAdmin4 - Session file name too large To: eMerzh Cc: Dave Page , pgadmin-hackers Content-Type: multipart/alternative; boundary=94eb2c05d4743caa56053258fbd4 X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgadmin-hackers Precedence: bulk Sender: pgadmin-hackers-owner@postgresql.org --94eb2c05d4743caa56053258fbd4 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable On Sun, May 8, 2016 at 6:09 PM, eMerzh 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) whe= n > 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 =3D 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.linkedin.com/in/asheshvashi* > Regards, > > Brice > > 2016-04-17 13:02 GMT+02:00 Dave Page : > >> Ok, good. Please let us know if it reoccurs. >> >> Sent from my iPad >> >> On 17 Apr 2016, at 08:26, eMerzh 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" a =C3=A9crit : >> >> Hi >> >> Ashesh, can you look at this please? I cannot reproduce it. >> >> >> On Friday, April 15, 2016, eMerzh 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/serv= ing.py", >>>> line 177, in run_wsgi >>>> execute(self.server.app) >>>> File >>>> "/Users/myuser/pgadmin4/venv/lib/python2.7/site-packages/werkzeug/serv= ing.py", >>>> line 165, in execute >>>> application_iter =3D 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 =3D 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, i= n >>>> __init__ >>>> sess_db =3D 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 >> >> > --94eb2c05d4743caa56053258fbd4 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

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

Hi gu= ys,

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

it seems that the issue happend every time (o= r at least really often) when i pull new changes.
so it might stil= l 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/pga= dmin/utils/session.py", line 60, in __init__
=C2=A0=C2=A0=C2=A0 ses= s_db =3D os.open(self.path, os.O_CREAT, int("600", 8))
=

I am surprised to see the beha= viour.
I've committed a probable fix to handle the case.=C2= =A0


hope this helps :)
=C2=A0<= /div>
Thanks for the report.

--

Thanks & Regards,

Ashesh Vashi<= /span>
Ent= erpriseDB INDIA:=C2=A0Enterprise PostgreSQL Company


R= egards,

Brice

2016-04-1= 7 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=C2=A0 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=C2=A017 avr. 2016 12:55 AM, "Dave Page&q= uot; <dpage@pgadm= in.org> a =C3=A9crit=C2=A0:
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 e210d= 2b5809355a334508436d9f128b78338dfd3
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/p= ython2.7/site-packages/werkzeug/serving.py", line 177, in run_wsgi
= execute(self.server.app)
File "/Users/myuser/pgadmin4/venv/li= b/python2.7/site-packages/werkzeug/serving.py", line 165, in execute application_iter =3D app(environ, start_response)
File "/Us= ers/myuser/pgadmin4/venv/lib/python2.7/site-packages/flask/app.py", li= ne 1836, in __call__
return self.wsgi_app(environ, start_response) File "/Users/myuser/pgadmin4/venv/lib/python2.7/site-packages/flas= k/app.py", line 1813, in wsgi_app
ctx.push()
File "/U= sers/myuser/pgadmin4/venv/lib/python2.7/site-packages/flask/ctx.py", l= ine 321, in push
self.session =3D self.app.open_session(self.request= )
File "/Users/myuser/pgadmin4/venv/lib/python2.7/site-packages/f= lask/app.py", line 825, in open_session
return self.session_int= erface.open_session(self, request)
File "/Users/myuser/pgadmin4/w= eb/pgadmin/utils/session.py", line 209, in open_session
return = SqliteSessionStorage(self.directory, sid)
File "/Users/myuser/pga= dmin4/web/pgadmin/utils/session.py", line 60, in __init__
sess_= db =3D os.open(self.path, os.O_CREAT, int("600", 8))
OSError: = [Errno 63] File name too long: '/Users/myuser/.pgadmin/sessions/.eJxNkU= tvozAUhf_KyOto....'

let me know if i ca= n provide you more informations.

Regards,

<= div>Brice


--
Dave PageBlog: http://pg= snake.blogspot.com
Twitter: @pgsnake

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



--94eb2c05d4743caa56053258fbd4--