Thanks - applied with some minor UI and string tweaks. On Fri, Feb 3, 2017 at 3:40 PM, Ashesh Vashi <ashesh.va...@enterprisedb.com> wrote:
> Hi Dave, > > Please find the patch with fix for the 2144. > > -- > > 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> > > On Fri, Feb 3, 2017 at 11:02 AM, Fahar Abbas <fahar.ab...@enterprisedb.com > > wrote: > >> RM reported: >> https://redmine.postgresql.org/issues/2144 >> >> >> On Fri, Feb 3, 2017 at 10:11 AM, Ashesh Vashi < >> ashesh.va...@enterprisedb.com> wrote: >> >>> Can you please create a separate RM for the same, and assign it to me? >>> And, please attach the pgadmin logs (only the relevant logs). >>> >>> -- >>> >>> 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> >>> >>> On Fri, Feb 3, 2017 at 10:36 AM, Fahar Abbas < >>> fahar.ab...@enterprisedb.com> wrote: >>> >>>> Hi Ashesh, >>>> >>>> I tested this patch with Import/Export table, backup database, backup >>>> table, backup server and Backup global, it working fine. While in case of >>>> Restore database, it failed and "sequence item 6: expected string or >>>> Unicode, int found" message displayed. >>>> >>>> Kind Regards >>>> >>>> On Thu, Feb 2, 2017 at 9:14 PM, Ashesh Vashi < >>>> ashesh.va...@enterprisedb.com> wrote: >>>> >>>>> On Thu, Feb 2, 2017 at 6:19 PM, Fahar Abbas < >>>>> fahar.ab...@enterprisedb.com> wrote: >>>>> >>>>>> Hi, >>>>>> >>>>>> Currently Ashesh is working for the particular issue on my machine >>>>>> and he will share the updated patch on tomorrow. >>>>>> >>>>> Thanks Fahar for your help to figure out the actual issue. >>>>> >>>>> Please find the updated patch. >>>>> I've added logging functionality in the process executor permanently. >>>>> >>>>> Working as expected with the latest patch on my systems (OSX, and >>>>> Window 10). >>>>> >>>>> -- >>>>> Thanks & Regards, >>>>> >>>>> Ashesh Vashi >>>>> >>>>>> >>>>>> Kind Regards, >>>>>> >>>>>> On Thu, Feb 2, 2017 at 11:22 AM, Fahar Abbas < >>>>>> fahar.ab...@enterprisedb.com> wrote: >>>>>> >>>>>>> Sure Ashesh, >>>>>>> >>>>>>> I will test and update the testing status accordingly. >>>>>>> >>>>>>> On Thu, Feb 2, 2017 at 11:17 AM, Ashesh Vashi < >>>>>>> ashesh.va...@enterprisedb.com> wrote: >>>>>>> >>>>>>>> Hi Fahar, >>>>>>>> >>>>>>>> Can you please test the updated patch? >>>>>>>> I have fixed one issue on windows, and also added logging >>>>>>>> information in the background process execution for future issue >>>>>>>> analysis. >>>>>>>> >>>>>>>> -- >>>>>>>> >>>>>>>> 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> >>>>>>>> >>>>>>>> On Mon, Jan 23, 2017 at 12:19 PM, Fahar Abbas < >>>>>>>> fahar.ab...@enterprisedb.com> wrote: >>>>>>>> >>>>>>>>> Hi Murtaza, >>>>>>>>> >>>>>>>>> I am using Administrator user on 2012 server . Can you please >>>>>>>>> check this behavior on my machine through skype or google talk? >>>>>>>>> >>>>>>>>> Regards, >>>>>>>>> >>>>>>>>> >>>>>>>>> On Mon, Jan 23, 2017 at 10:07 AM, Murtuza Zabuawala < >>>>>>>>> murtuza.zabuaw...@enterprisedb.com> wrote: >>>>>>>>> >>>>>>>>>> I tested with Python-2.7 on Windows10 (32-bit) & on MacOS I >>>>>>>>>> tested with Python3.5 (64-bit), It is working as expected, >>>>>>>>>> >>>>>>>>>> I suspect that as you are running with Server 2012, permissions >>>>>>>>>> might be the issue, Can you try running with Administrator? >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> Regards, >>>>>>>>>> Murtuza Zabuawala >>>>>>>>>> EnterpriseDB: http://www.enterprisedb.com >>>>>>>>>> The Enterprise PostgreSQL Company >>>>>>>>>> >>>>>>>>>> On Sat, Jan 21, 2017 at 1:18 AM, Fahar Abbas < >>>>>>>>>> fahar.ab...@enterprisedb.com> wrote: >>>>>>>>>> >>>>>>>>>>> I tested in Google chrome Windows 2012 R2 64 with Python 2.7.11. >>>>>>>>>>> It might be possible that you tested on Python 3+. >>>>>>>>>>> >>>>>>>>>>> Please confirm? >>>>>>>>>>> >>>>>>>>>>> On Fri, Jan 20, 2017 at 6:49 PM, Murtuza Zabuawala < >>>>>>>>>>> murtuza.zabuaw...@enterprisedb.com> wrote: >>>>>>>>>>> >>>>>>>>>>>> That's strange. >>>>>>>>>>>> >>>>>>>>>>>> I tested in Chrome, Need check in IE. >>>>>>>>>>>> >>>>>>>>>>>> Meanwhile can try with Chrome/Firefox? >>>>>>>>>>>> >>>>>>>>>>>> -- >>>>>>>>>>>> Regards, >>>>>>>>>>>> Murtuza Zabuawala >>>>>>>>>>>> EnterpriseDB: http://www.enterprisedb.com >>>>>>>>>>>> The Enterprise PostgreSQL Company >>>>>>>>>>>> >>>>>>>>>>>> On Fri, Jan 20, 2017 at 7:01 PM, Fahar Abbas < >>>>>>>>>>>> fahar.ab...@enterprisedb.com> wrote: >>>>>>>>>>>> >>>>>>>>>>>>> Hi Murtaza, >>>>>>>>>>>>> >>>>>>>>>>>>> I just applied this patch and issue is still not resolved. >>>>>>>>>>>>> >>>>>>>>>>>>> In case of Maintenance DB and Backup database message, >>>>>>>>>>>>> *Maintenance >>>>>>>>>>>>> job created* and *Backup job created* displayed but no other >>>>>>>>>>>>> dialogue box displayed either process is completed or not. >>>>>>>>>>>>> >>>>>>>>>>>>> Screen-shot and pgadmin.log file is attached. >>>>>>>>>>>>> >>>>>>>>>>>>> Kind Regards, >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> On Fri, Jan 20, 2017 at 5:35 PM, Murtuza Zabuawala < >>>>>>>>>>>>> murtuza.zabuaw...@enterprisedb.com> wrote: >>>>>>>>>>>>> >>>>>>>>>>>>>> Hi Fahar, >>>>>>>>>>>>>> >>>>>>>>>>>>>> Could you please test this updated patch? >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> -- >>>>>>>>>>>>>> Regards, >>>>>>>>>>>>>> Murtuza Zabuawala >>>>>>>>>>>>>> EnterpriseDB: http://www.enterprisedb.com >>>>>>>>>>>>>> The Enterprise PostgreSQL Company >>>>>>>>>>>>>> >>>>>>>>>>>>>> On Tue, Jan 17, 2017 at 3:45 PM, Fahar Abbas < >>>>>>>>>>>>>> fahar.ab...@enterprisedb.com> wrote: >>>>>>>>>>>>>> >>>>>>>>>>>>>>> Thanks Dave. >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> On Tue, Jan 17, 2017 at 3:07 PM, Dave Page < >>>>>>>>>>>>>>> dp...@pgadmin.org> wrote: >>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> Not surprising. Don't bother testing that any more for now >>>>>>>>>>>>>>>> thanks. I suspect it's a simple bug that Ashesh can fix pronto. >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> On Tue, Jan 17, 2017 at 10:02 AM, Fahar Abbas < >>>>>>>>>>>>>>>> fahar.ab...@enterprisedb.com> wrote: >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> Issue is also reproducible with PG-9.6 server. >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> Regards, >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> On Tue, Jan 17, 2017 at 2:55 PM, Fahar Abbas < >>>>>>>>>>>>>>>>> fahar.ab...@enterprisedb.com> wrote: >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> Please attached the log files output from the terminal >>>>>>>>>>>>>>>>>> and pgAdmin4.log. >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> Kind Regards, >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> On Tue, Jan 17, 2017 at 2:46 PM, Dave Page < >>>>>>>>>>>>>>>>>> dp...@pgadmin.org> wrote: >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> Thanks. What log output do you get? >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> On Tue, Jan 17, 2017 at 9:44 AM, Fahar Abbas < >>>>>>>>>>>>>>>>>>> fahar.ab...@enterprisedb.com> wrote: >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> Hi Dave. >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> After applying this patch on Windows 2012 server 64 >>>>>>>>>>>>>>>>>>>> with Python 2.7.11 on EPAS-9.6 server, Maintenance DB and >>>>>>>>>>>>>>>>>>>> Backup database >>>>>>>>>>>>>>>>>>>> failed. >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> Please find attached the snapshot. >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> Kind Regards, >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> On Wed, Jan 11, 2017 at 6:19 PM, Dave Page < >>>>>>>>>>>>>>>>>>>> dp...@pgadmin.org> wrote: >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> Hi >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> On Wed, Jan 11, 2017 at 12:28 PM, Ashesh Vashi < >>>>>>>>>>>>>>>>>>>>> ashesh.va...@enterprisedb.com> wrote: >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> Hi Dave, >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> On Wed, Jan 11, 2017 at 12:03 PM, Dave Page < >>>>>>>>>>>>>>>>>>>>>> dp...@pgadmin.org> wrote: >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>> KeyError: u'end_time' >>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>> The status file contains: >>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>> {"start_time": "2017-01-11 06:27:20.939703 +0000", >>>>>>>>>>>>>>>>>>>>>>> "pid": 49363, "exit_code": 0, "end_time": "2017-01-11 >>>>>>>>>>>>>>>>>>>>>>> 06:27:28.613456 >>>>>>>>>>>>>>>>>>>>>>> +0000"} >>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> Thanks for reviewing the patch. >>>>>>>>>>>>>>>>>>>>>> Please find the updated patch. >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> Changes: >>>>>>>>>>>>>>>>>>>>>> - Using now ValueError instead of >>>>>>>>>>>>>>>>>>>>>> json.JSONDecodeError, which is subclass of ValueError, >>>>>>>>>>>>>>>>>>>>>> to allow to it to >>>>>>>>>>>>>>>>>>>>>> work with 2.6+ python. >>>>>>>>>>>>>>>>>>>>>> - Checking the existence of value in dict before >>>>>>>>>>>>>>>>>>>>>> accessing it. >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> That seems to work for me in a brief test on my Mac. >>>>>>>>>>>>>>>>>>>>> :-) >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> Fahar; are you able to apply and test this patch on >>>>>>>>>>>>>>>>>>>>> Windows and Linux, in server and desktop modes? Basically >>>>>>>>>>>>>>>>>>>>> all the external >>>>>>>>>>>>>>>>>>>>> processes should be tested - backup, restore & >>>>>>>>>>>>>>>>>>>>> maintenance (vacuum) etc). I >>>>>>>>>>>>>>>>>>>>> don't have any VMs available at the moment due to travel. >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> -- >>>>>>>>>>>>>>>>>>>>> Dave Page >>>>>>>>>>>>>>>>>>>>> Blog: http://pgsnake.blogspot.com >>>>>>>>>>>>>>>>>>>>> Twitter: @pgsnake >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> EnterpriseDB UK: http://www.enterprisedb.com >>>>>>>>>>>>>>>>>>>>> The Enterprise PostgreSQL Company >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> >>>>> >>>> >>>> >>>> -- >>>> Syed Fahar Abbas >>>> Quality Management Group >>>> >>>> EnterpriseDB Corporation >>>> Phone Office: +92-51-835-8874 >>>> Phone Direct: +92-51-8466803 <(051)%208466803> >>>> Mobile: +92-333-5409707 <0333%205409707> >>>> Skype ID: syed.fahar.abbas >>>> Website: www.enterprisedb.com >>>> >>> >>> >> >> >> -- >> Syed Fahar Abbas >> Quality Management Group >> >> EnterpriseDB Corporation >> Phone Office: +92-51-835-8874 >> Phone Direct: +92-51-8466803 <+92%2051%208466803> >> Mobile: +92-333-5409707 <+92%20333%205409707> >> Skype ID: syed.fahar.abbas >> Website: www.enterprisedb.com >> > > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company