[Patch][pgAdmin4]: RM1519 - Error running VACUUM FULL FREEZE ANALYZE VERBOSE

From: Surinder Kumar <surinder(dot)kumar(at)enterprisedb(dot)com>
To: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: [Patch][pgAdmin4]: RM1519 - Error running VACUUM FULL FREEZE ANALYZE VERBOSE
Date: 2016-08-04 09:59:28
Message-ID: CAM5-9D8_CDrMGu_m1ZRsceHRHgK=W_ea-tueMSZFo7Be-FD-pg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

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

Attachment Content-Type Size
RM1519.patch application/octet-stream 569 bytes

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2016-08-04 10:31:26 pgAdmin 4 commit: Fix display of numerics in the query tool. Fixes #146
Previous Message Harshal Dhumal 2016-08-04 09:52:01 RM1492 [pgadmin4]