Hi On Tue, Oct 9, 2018 at 8:03 AM Khushboo Vashi < khushboo.va...@enterprisedb.com> wrote:
> Hi Dave, > > On Mon, Oct 8, 2018 at 5:35 PM Dave Page <dp...@pgadmin.org> wrote: > >> >> >> On Mon, Oct 8, 2018 at 12:50 PM Khushboo Vashi < >> khushboo.va...@enterprisedb.com> wrote: >> >>> Hi Dave, >>> >>> On Mon, Oct 8, 2018 at 3:47 PM Dave Page <dp...@pgadmin.org> wrote: >>> >>>> Hi >>>> On Fri, Oct 5, 2018 at 12:28 PM Khushboo Vashi < >>>> khushboo.va...@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. >> >> > 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? > Can we create multiple sub-directories under the specified path? > > > 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 >> > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company