Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eWkuS-0006II-Eh for pgadmin-hackers@arkaria.postgresql.org; Wed, 03 Jan 2018 15:24:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eWkuR-0006E9-Rn for pgadmin-hackers@arkaria.postgresql.org; Wed, 03 Jan 2018 15:24:51 +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 1eWkuR-0006Dt-M9 for pgadmin-hackers@lists.postgresql.org; Wed, 03 Jan 2018 15:24:51 +0000 Received: from mail-qk0-x22e.google.com ([2607:f8b0:400d:c09::22e]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1eWkuJ-0000Jf-L5 for pgadmin-hackers@postgresql.org; Wed, 03 Jan 2018 15:24:51 +0000 Received: by mail-qk0-x22e.google.com with SMTP id j137so1922727qke.10 for ; Wed, 03 Jan 2018 07:24:43 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pgadmin-org.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=nU5b6F4yyfPtseyhb9KpfWcnujur0l7VC0Kfg3brhbo=; b=GBGyNn4+EZESgK8LgMH4V6gCEHdFScE0Wju++0Y9pAnhR9yH+U+qU8ul+5KKPy2aXh EE4Qt3BPtuutT7za9WoM2GTOPIrT/X7xiv9Npffs9f1HemR9QzynCqWIkOP1wxdW0QnG 7ubp6OVtVxz4Gnno4TiJryDBfrM0BLTPpEHE4QQJKScScxsm5lE07Ii0R8X8th6d94+o YUi/YOjnAXFAPdGYgDSvW8WfulGsSR4DNNeTHS5VruhJ87o62DN8FC9pY9emhIv1ek+B O33oannNa9b+cKvcC+N8AWE3L8yylRC9B7JE7myH+NG8xh5YddqDFukH1UL05agKPI8K 7Ccg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=nU5b6F4yyfPtseyhb9KpfWcnujur0l7VC0Kfg3brhbo=; b=tEk4u6NGE8iCZ5itXsHjgT2opDeEloinUE2wmLUtSW1UBKLDZJXSePWRdgidtnpChZ +ZelLX7IkIJqCYbEjsWTu1n4UXT0pNzPZlFwZ80Ih31/BJSyKKm1O72c8jNzoPCxrNCY SuCCwtkHx50871mzn8Pcf/zeDTiKpqaeYUIeMsFbM/Ad/DLHUB04D/3xDANF7kJcaveV sXLRPvRBzn/yylKf3D6zNKbi6B+kXyA+xart1jqnBXCFXJDCSWK0vQ1/6Cdg9RMApj03 O4Lek6WlzmmUBXpJweYTHbLwWTBfmmIYmUcAD/n6Myg0ybHrNAX5bPtDfAwmBSB0a7wX +GYw== X-Gm-Message-State: AKGB3mK6skZE6XRXjJcxqcfjzjklHvoQ6x4Zf7jDGspolz3xzK1s1LC7 a/4YLmZMrpQmhCS/sQjCs0GRvQ/gUw0JzbAfyycCLSapGGw= X-Google-Smtp-Source: ACJfBouzuexMoyjfbDa5gxpium/qfNPK2B8UfIt3zRf7T1PyBlun/VZ1cv6w3HqszGKgqyBXa2IYTllPZ1k36lHLhN8= X-Received: by 10.55.126.198 with SMTP id z189mr2192474qkc.100.1514993081745; Wed, 03 Jan 2018 07:24:41 -0800 (PST) MIME-Version: 1.0 Received: by 10.140.30.67 with HTTP; Wed, 3 Jan 2018 07:24:40 -0800 (PST) In-Reply-To: References: From: Dave Page Date: Wed, 3 Jan 2018 15:24:40 +0000 Message-ID: Subject: =?UTF-8?Q?Re=3A_=5BpgAdmin4=5D=5BPatch=5D=3A_RM_=232963_=2D_Backup_database=2C_R?= =?UTF-8?Q?estore_database_and_Maintenance_Database_failed_for_=C3=A9_objec?= =?UTF-8?Q?t=2E?= To: Khushboo Vashi Cc: pgadmin-hackers Content-Type: multipart/alternative; boundary="94eb2c05ed34799bff0561e0d0c8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --94eb2c05ed34799bff0561e0d0c8 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi On Mon, Dec 25, 2017 at 11:03 AM, Khushboo Vashi < khushboo.vashi@enterprisedb.com> wrote: > Hi, > > Please find the attached patch to fix RM #2963: Backup database, Restore > database and Maintenance Database failed for =C3=A9 object. > With the patch applied, I get: 2018-01-03 15:23:00,110: INFO pgadmin: Executing the process executor with the arguments: ['/Users/dpage/.virtualenvs/pgadmin4/bin/python', '/Users/dpage/git/pgadmin4/web/pgadmin/misc/bgprocess/process_executor.py', '/usr/local/pgsql/bin/pg_dump', u'--file', u'/Users/dpage/e.sql', u'--host', u'localhost', u'--port', '5432', u'--username', u'postgres', u'--no-password', u'--verbose', u'--format=3Dc', u'--blobs', u'\xe9'] 2018-01-03 15:23:00,117: INFO werkzeug: 127.0.0.1 - - [03/Jan/2018 15:23:00] "POST /backup/job/1/object HTTP/1.1" 200 - Exception in thread Thread-6: Traceback (most recent call last): File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/thr= eading.py", line 810, in __bootstrap_inner self.run() File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/thr= eading.py", line 763, in run self.__target(*self.__args, **self.__kwargs) File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/Soc= ketServer.py", line 602, in process_request_thread self.handle_error(request, client_address) File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/Soc= ketServer.py", line 599, in process_request_thread self.finish_request(request, client_address) File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/Soc= ketServer.py", line 334, in finish_request self.RequestHandlerClass(request, client_address, self) File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/Soc= ketServer.py", line 655, in __init__ self.handle() File "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/werkzeug/se= rving.py", line 200, in handle rv =3D BaseHTTPRequestHandler.handle(self) File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/Bas= eHTTPServer.py", line 340, in handle self.handle_one_request() File "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/werkzeug/se= rving.py", line 235, in handle_one_request return self.run_wsgi() File "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/werkzeug/se= rving.py", line 177, in run_wsgi execute(self.server.app) File "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/werkzeug/se= rving.py", line 165, in execute application_iter =3D app(environ, start_response) File "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.p= y", line 2000, in __call__ return self.wsgi_app(environ, start_response) File "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.p= y", line 1991, in wsgi_app response =3D self.make_response(self.handle_exception(e)) File "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.p= y", line 1567, in handle_exception reraise(exc_type, exc_value, tb) File "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.p= y", line 1988, in wsgi_app response =3D self.full_dispatch_request() File "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.p= y", line 1641, in full_dispatch_request rv =3D self.handle_user_exception(e) File "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.p= y", line 1544, in handle_user_exception reraise(exc_type, exc_value, tb) File "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.p= y", line 1639, in full_dispatch_request rv =3D self.dispatch_request() File "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.p= y", line 1625, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask_login= .py", line 792, in decorated_view return func(*args, **kwargs) File "/Users/dpage/git/pgadmin4/web/pgadmin/misc/bgprocess/__init__.py", line 62, in index return make_response(response=3DBatchProcess.list()) File "/Users/dpage/git/pgadmin4/web/pgadmin/misc/bgprocess/processes.py", line 512, in list desc =3D loads(p.desc) File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/pic= kle.py", line 1381, in loads file =3D StringIO(str) UnicodeEncodeError: 'ascii' codec can't encode character u'\ufffd' in position 138: ordinal not in range(128) --=20 Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company --94eb2c05ed34799bff0561e0d0c8 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi

On Mon, Dec 25, 2017 at 11:03 AM, Khushboo Vashi <khushboo= .vashi@enterprisedb.com> wrote:
Hi,

Please find= the attached patch to fix RM #2963:=C2=A0Backup database, Restore database= and Maintenance Database failed for =C3=A9 object.

With the patch applied, I get:

2018-01-03 15:23:00,110: INFO pgad= min: Executing the process executor = with the arguments: ['/Users/dpage/.virtualenvs/pgadmin4/bin/python'= ;, '/Users/dpage/git/pgadmin4/web/pgadmin/misc/bgprocess/process_execut= or.py', '/usr/local/pgsql/bin/pg_dump', u'--file', u= 9;/Users/dpage/e.sql', u'--host', u'localhost', u'-= -port', '5432', u'--username', u'postgres', u&#= 39;--no-password', u'--verbose', u'--format=3Dc', u'= ;--blobs', u'\xe9']
2018-01-03 15:23:00,117: INFO werkzeug: 127.0.0.1 - - [03/Jan/2018 15:23:00] "POST /backup/job/1/obj= ect HTTP/1.1" 200 -
Exception in thread Thread-6:
= Traceback (most recent call last):
=C2=A0 File "/System/Libr= ary/Frameworks/Python.framework/Versions/2.7/lib/python2.7/threading.py&quo= t;, line 810, in __bootstrap_inner
=C2=A0 =C2=A0 self.run()
=
=C2=A0 File "/System/Library/Frameworks/Python.framework/Versions= /2.7/lib/python2.7/threading.py", line 763, in run
=C2=A0 = =C2=A0 self.__target(*self.__args, **self.__kwargs)
=C2=A0 File &= quot;/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7= /SocketServer.py", line 602, in process_request_thread
=C2= =A0 =C2=A0 self.handle_error(request, client_address)
=C2=A0 File= "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2= .7/SocketServer.py", line 599, in process_request_thread
=C2= =A0 =C2=A0 self.finish_request(request, client_address)
=C2=A0 Fi= le "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/pytho= n2.7/SocketServer.py", line 334, in finish_request
=C2=A0 = =C2=A0 self.RequestHandlerClass(request, client_address, self)
= =C2=A0 File "/System/Library/Frameworks/Python.framework/Versions/2.7/= lib/python2.7/SocketServer.py", line 655, in __init__
=C2=A0= =C2=A0 self.handle()
=C2=A0 File "/Users/dpage/.virtualenvs= /pgadmin4/lib/python2.7/site-packages/werkzeug/serving.py", line 200, = in handle
=C2=A0 =C2=A0 rv =3D BaseHTTPRequestHandler.handle(self= )
=C2=A0 File "/System/Library/Frameworks/Python.framework/V= ersions/2.7/lib/python2.7/BaseHTTPServer.py", line 340, in handle
=C2=A0 =C2=A0 self.handle_one_request()
=C2=A0 File "/= Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/werkzeug/serv= ing.py", line 235, in handle_one_request
=C2=A0 =C2=A0 retur= n self.run_wsgi()
=C2=A0 File "/Users/dpage/.virtualenvs/pga= dmin4/lib/python2.7/site-packages/werkzeug/serving.py", line 177, in r= un_wsgi
=C2=A0 =C2=A0 execute(self.server.app)
=C2=A0 F= ile "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/we= rkzeug/serving.py", line 165, in execute
=C2=A0 =C2=A0 appli= cation_iter =3D app(environ, start_response)
=C2=A0 File "/U= sers/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py&q= uot;, line 2000, in __call__
=C2=A0 =C2=A0 return self.wsgi_app(e= nviron, start_response)
=C2=A0 File "/Users/dpage/.virtualen= vs/pgadmin4/lib/python2.7/site-packages/flask/app.py", line 1991, in w= sgi_app
=C2=A0 =C2=A0 response =3D self.make_response(self.handle= _exception(e))
=C2=A0 File "/Users/dpage/.virtualenvs/pgadmi= n4/lib/python2.7/site-packages/flask/app.py", line 1567, in handle_exc= eption
=C2=A0 =C2=A0 reraise(exc_type, exc_value, tb)
= =C2=A0 File "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-pac= kages/flask/app.py", line 1988, in wsgi_app
=C2=A0 =C2=A0 re= sponse =3D self.full_dispatch_request()
=C2=A0 File "/Users/= dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",= line 1641, in full_dispatch_request
=C2=A0 =C2=A0 rv =3D self.ha= ndle_user_exception(e)
=C2=A0 File "/Users/dpage/.virtualenv= s/pgadmin4/lib/python2.7/site-packages/flask/app.py", line 1544, in ha= ndle_user_exception
=C2=A0 =C2=A0 reraise(exc_type, exc_value, tb= )
=C2=A0 File "/Users/dpage/.virtualenvs/pgadmin4/lib/python= 2.7/site-packages/flask/app.py", line 1639, in full_dispatch_request
=C2=A0 =C2=A0 rv =3D self.dispatch_request()
=C2=A0 File= "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask= /app.py", line 1625, in dispatch_request
=C2=A0 =C2=A0 retur= n self.view_functions[rule.endpoint](**req.view_args)
=C2=A0 File= "/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask= _login.py", line 792, in decorated_view
=C2=A0 =C2=A0 return= func(*args, **kwargs)
=C2=A0 File "/Users/dpage/git/pgadmin= 4/web/pgadmin/misc/bgprocess/__init__.py", line 62, in index
=C2=A0 =C2=A0 return make_response(response=3DBatchProcess.list())
=C2=A0 File "/Users/dpage/git/pgadmin4/web/pgadmin/misc/bgprocess/p= rocesses.py", line 512, in list
=C2=A0 =C2=A0 desc =3D loads= (p.desc)
=C2=A0 File "/System/Library/Frameworks/Python.fram= ework/Versions/2.7/lib/python2.7/pickle.py", line 1381, in loads
=
=C2=A0 =C2=A0 file =3D StringIO(str)
UnicodeEncodeError: = 9;ascii' codec can't encode character u'\ufffd' in position= 138: ordinal not in range(128)=C2=A0

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

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