Re: [pgAdmin4][Patch]: RM #1513 - Unable to do max selection to drop tables/sequences/functions

On Mon, Oct 8, 2018 at 12:50 PM Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:

Hi Dave,

On Mon, Oct 8, 2018 at 3:47 PM Dave Page <dpage@pgadmin.org> wrote:

Hi

On Fri, Oct 5, 2018 at 12:28 PM Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:

Hi,

Please find the attached updated patch with the fixes.

Whenever I run the python tests, I get the following errors (even after manually deleting all test tablespaces):

I am not getting this error. My test cases are passing successfully.

Do you have this issue on particular server or all the server?

I'm just testing on PG10 at the moment (and have run the tests multiple times).

 

Which python version?

3.6.6.

 

 

======================================================================

ERROR: runTest (pgadmin.browser.server_groups.servers.tablespaces.tests.test_tbspc_delete_multiple.TableSpaceDeleteTestCase)

Delete Multiple Tablespaces

----------------------------------------------------------------------

Traceback (most recent call last):

  File "/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups/servers/tablespaces/tests/utils.py", line 59, in create_tablespace

    (test_tablespace_name, server['tablespace_path']))

psycopg2.OperationalError: directory "/Library/PostgreSQL/tablespaces/10/PG_10_201707211" already in use as a tablespace

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

  File "/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups/servers/tablespaces/tests/test_tbspc_delete_multiple.py", line 44, in setUp

    self.server, self.tablespace_names[1])

  File "/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups/servers/tablespaces/tests/utils.py", line 74, in create_tablespace

    raise Exception("Error while creating tablespace. %s" % exception)

Exception: Error while creating tablespace. directory "/Library/PostgreSQL/tablespaces/10/PG_10_201707211" already in use as a tablespace

======================================================================

ERROR: runTest (pgadmin.browser.server_groups.servers.tablespaces.tests.test_tbspc_get.TablespaceGetTestCase)

Check Tablespace Node

----------------------------------------------------------------------

Traceback (most recent call last):

  File "/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups/servers/tablespaces/tests/utils.py", line 59, in create_tablespace

    (test_tablespace_name, server['tablespace_path']))

psycopg2.OperationalError: directory "/Library/PostgreSQL/tablespaces/10/PG_10_201707211" already in use as a tablespace

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

  File "/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups/servers/tablespaces/tests/test_tbspc_get.py", line 36, in setUp

    self.server, self.tablespace_name)

  File "/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups/servers/tablespaces/tests/utils.py", line 74, in create_tablespace

    raise Exception("Error while creating tablespace. %s" % exception)

Exception: Error while creating tablespace. directory "/Library/PostgreSQL/tablespaces/10/PG_10_201707211" already in use as a tablespace

======================================================================

ERROR: runTest (pgadmin.browser.server_groups.servers.tablespaces.tests.test_tbspc_put.TableSpaceUpdateTestCase)

Check Tablespace Node

----------------------------------------------------------------------

Traceback (most recent call last):

  File "/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups/servers/tablespaces/tests/utils.py", line 59, in create_tablespace

    (test_tablespace_name, server['tablespace_path']))

psycopg2.OperationalError: directory "/Library/PostgreSQL/tablespaces/10/PG_10_201707211" already in use as a tablespace

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

  File "/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups/servers/tablespaces/tests/test_tbspc_put.py", line 36, in setUp

    self.server, self.tablespace_name)

  File "/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups/servers/tablespaces/tests/utils.py", line 74, in create_tablespace

    raise Exception("Error while creating tablespace. %s" % exception)

Exception: Error while creating tablespace. directory "/Library/PostgreSQL/tablespaces/10/PG_10_201707211" already in use as a tablespace

 

--

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

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

--

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

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