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

Hi Dave,

On Mon, Oct 8, 2018 at 3:47 PM Dave Page <dpage(at)pgadmin(dot)org> wrote:

> 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):
>
> I am not getting this error. My test cases are passing successfully.
Do you have this issue on particular server or all the server?
Which python version?

> ======================================================================
>
> 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
>