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@pgadmin.org> wrote:

On Mon, Oct 8, 2018 at 12:50 PM Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:

Hi Dave,

On Mon, Oct 8, 2018 at 3:47 PM Dave Page <dpage@pgadmin.org> wrote:

Hi

On Fri, Oct 5, 2018 at 12:28 PM Khushboo Vashi <khushboo.vashi@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?

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