public inbox for [email protected]  

help / color / mirror / Atom feed

From: Dave Page <[email protected]>
To: Surinder Kumar <[email protected]>
Cc: pgadmin-hackers <[email protected]>
Subject: Re: [Patch][pgAdmin4]: RM1519 - Error running VACUUM FULL FREEZE ANALYZE VERBOSE
Date: Thu, 4 Aug 2016 12:14:12 +0100
Message-ID: <CA+OCxozca6a5H8=ze8WsjVZyLrADcpnKD_yQVsiAaBadQ3MabQ@mail.gmail.com> (raw)
In-Reply-To: <CAM5-9D8_CDrMGu_m1ZRsceHRHgK=W_ea-tueMSZFo7Be-FD-pg@mail.gmail.com>
References: <CAM5-9D8_CDrMGu_m1ZRsceHRHgK=W_ea-tueMSZFo7Be-FD-pg@mail.gmail.com>
List-Unsubscribe:  <mailto:[email protected]?body=unsub%20pgadmin-hackers>

Thanks, applied.

On Thu, Aug 4, 2016 at 10:59 AM, Surinder Kumar
<[email protected]> wrote:
> Hi
>
> This issue is reproduced to me with following steps.:
> 1) When the query "VACUUM FULL FREEZE ANALYZE VERBOSE" is run for first
> time, it runs without error.
> 2) then the query "SELECT 1" is executed. no error.
> 3) But when query in step #1 is run again, it throws an error:
> TypeError: cannot concatenate 'str' and 'NoneType' objects
>
> 4) Now executing query in step #2 throws following error:
> Error Message:execute cannot be used while an asynchronous query is
> underway********** Error **********
>
> Reason:
> When the query in step #1 is run for second time as in step #3, it fails due
> to python error thus loading spinner stops and run query button is enabled.
> but the query is still running in background.
>
> then on running query in step #4 throws error with message "asynchronous
> query is underway" because last run query is not yet finished.
>
> Solution:
> This is due to python error.
> String type and NoneType is now formatted properly which resolves the issue.
>
> Please find attached patch and review.
>
>
> Thanks,
> Surinder Kumar
>
>
> --
> Sent via pgadmin-hackers mailing list ([email protected])
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-hackers
>



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

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


-- 
Sent via pgadmin-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: [Patch][pgAdmin4]: RM1519 - Error running VACUUM FULL FREEZE ANALYZE VERBOSE
  In-Reply-To: <CA+OCxozca6a5H8=ze8WsjVZyLrADcpnKD_yQVsiAaBadQ3MabQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox