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 Mobile: +92-333-5409707 Skype ID: syed.fahar.abbas Website: www.enterprisedb.com
