Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1azfxO-0006RU-03 for pgadmin-hackers@arkaria.postgresql.org; Mon, 09 May 2016 07:50:22 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1azfxN-00022A-JB for pgadmin-hackers@arkaria.postgresql.org; Mon, 09 May 2016 07:50:21 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1azO08-0004wc-PJ for pgadmin-hackers@postgresql.org; Sun, 08 May 2016 12:40:00 +0000 Received: from mail-wm0-x22c.google.com ([2a00:1450:400c:c09::22c]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1azO04-00033l-Mc for pgadmin-hackers@postgresql.org; Sun, 08 May 2016 12:40:00 +0000 Received: by mail-wm0-x22c.google.com with SMTP id a17so144550859wme.0 for ; Sun, 08 May 2016 05:39:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=M+7dpgE/RLUCqkPQyAyXh0uiaLCOwr5IKzoHEsTpKH8=; b=CFA19IT56qA0UBPTRcfJVAIqtkPs97h2crNNnFkumqbIooYZUJupelc19vV1NpzLug S7/fNE1QrWMinppzYy3Jal+Q/AqQclV6v05CV/KptJcg9Om+QNmSPBk6s4DlQF2WbZ+g zGou1bIoh1BTbQyBL9igfV5UwDw9qIv3ZlTgOSo8uXbTwemmDZFicRnzwOMWunYn/b18 4ADJxTUn2+p/FovWSlxZLH+5CMBkxtT2xZHWqhhJ55JDm5OflC4WtWkH/ROqo8nrq03w GEY6vM2ON3PsnmvGhA67s3raqtoNlOHYkRhJo7WXV/lQVWRiAX+/83/a2S0fGpxGtonr Ua5Q== 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=M+7dpgE/RLUCqkPQyAyXh0uiaLCOwr5IKzoHEsTpKH8=; b=TJ9d/crCqaPREJjJyc8I6vnyIWPmTH5dZBbugLin39SrupdPCIEzb7HWv49YK8HSGL DdQ1Ome5f6DZPWg4seVf40r9dm5sHZSIx6v/MI8eAtXeYZ08eV9AOPqmt58QWniCYyUE M6biMwS7JGrPO1GUvcVMd7cdeIP7lqAWJm8Uxr5pu57mPdY9w7t4SsqNwU7WB/rOGO/k 5lg4oPR6suSZJw/q4SI8yYCBq44enQiAZ+o0IFmRSvtgb9qXB9Ez3FywHJj9QdkyfxCW /kjUAM6yAiq4d1LRCoGquMi5NjIk9Its5OIacX4WQVhhZaYCJ0lelNCkjzwkftCOavGT tsMA== X-Gm-Message-State: AOPr4FUrpmQBP3nXRIbtRjp2ALHwOHSA6eo7l/jksPCDbmfzQbB10PcOXNeM2wvXg3yur/qSe/6V6L3rqbEw1Q== X-Received: by 10.28.125.138 with SMTP id y132mr6261947wmc.90.1462711195352; Sun, 08 May 2016 05:39:55 -0700 (PDT) MIME-Version: 1.0 Received: by 10.194.82.234 with HTTP; Sun, 8 May 2016 05:39:35 -0700 (PDT) In-Reply-To: <8BE41B9F-05BD-44D5-A2F1-EC85EEF80F7E@pgadmin.org> References: <8BE41B9F-05BD-44D5-A2F1-EC85EEF80F7E@pgadmin.org> From: eMerzh Date: Sun, 8 May 2016 14:39:35 +0200 Message-ID: Subject: Re: pgAdmin4 - Session file name too large To: Dave Page Cc: pgadmin-hackers@postgresql.org, Ashesh Vashi Content-Type: multipart/alternative; boundary=001a1141fa60354722053253fdca X-Pg-Spam-Score: -2.7 (--) 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 --001a1141fa60354722053253fdca Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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 =3D 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 : > 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 lon= g > 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/servi= ng.py", >>> line 177, in run_wsgi >>> execute(self.server.app) >>> File >>> "/Users/myuser/pgadmin4/venv/lib/python2.7/site-packages/werkzeug/servi= ng.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, i= n >>> open_session >>> return SqliteSessionStorage(self.directory, sid) >>> File "/Users/myuser/pgadmin4/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/.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 > > --001a1141fa60354722053253fdca Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi guys,

<= /div>i was just updating my working copy of git, and got the same issue aga= in.

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

to hel you understand m= y workflow, here are the step that i did:
a couple of days ago i&#= 39;ve tested pgAdmin...
so today i did a git pull
...
Updating 07= e0de5..c8406a5
...
then activate my venv,
then p= ython web/pgAdmin4.py
and then i got the error :
OSError: = [Errno 63] File name too long: ...
web/pgadmin/utils/session.py", l= ine 60, in __init__
=C2=A0=C2=A0=C2=A0 sess_db =3D 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 <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:

<= div>

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.<= div>

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

I wa= s 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 c= all last):
File "/Users/myuser/pgadmin4/venv/lib/python2.7/site-p= ackages/werkzeug/serving.py", line 177, in run_wsgi
execute(sel= f.server.app)
File "/Users/myuser/pgadmin4/venv/lib/python2.7/sit= e-packages/werkzeug/serving.py", line 165, in execute
applicati= on_iter =3D app(environ, start_response)
File "/Users/myuser/pgad= min4/venv/lib/python2.7/site-packages/flask/app.py", line 1836, in __c= all__
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/pga= dmin4/venv/lib/python2.7/site-packages/flask/ctx.py", line 321, in pus= h
self.session =3D self.app.open_session(self.request)
File &qu= ot;/Users/myuser/pgadmin4/venv/lib/python2.7/site-packages/flask/app.py&quo= t;, line 825, in open_session
return self.session_interface.open_ses= sion(self, request)
File "/Users/myuser/pgadmin4/web/pgadmin/util= s/session.py", line 209, in open_session
return SqliteSessionSt= orage(self.directory, sid)
File "/Users/myuser/pgadmin4/web/pgadm= in/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/.eJxNkUtvozAUhf_KyOto.= ...'

let me know if i can provide you m= ore informations.

Regards,

Brice
<= /div>


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

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


--001a1141fa60354722053253fdca--