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(dot)vashi(at)enterprisedb(dot)com> wrote:

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

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