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 > Mobile: +92-333-5409707 > Skype ID: syed.fahar.abbas > Website: www.enterprisedb.com >
RM1679_v16.patch
Description: Binary data
-- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
