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

Hi
On Fri, Oct 5, 2018 at 12:28 PM Khushboo Vashi <
khushboo(dot)vashi(at)enterprisedb(dot)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):

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

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