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

Hi Dave,

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

>
>
> 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.
>
>
I have found the issue.
For every new table-space, different path is required. We give the
table-space path in the test_config.json file.
Now to test the multiple delete, we need to give multiple paths.
So, Should I configure the multiple paths in the test_config.json file or
skip the multile delete tablespace test case?

Thanks,
Khushboo

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