Environment: docker container with centos 7, diskquota 2.2.2, gpdb 6.21.3. It seem

Sure: <div class="snippet-clipboard-content notranslate position-relative overflow

It seems that there are only two segments on your GP cluster. <div class="snippet-

Unit, regress tests completion,about greenplum-db/diskquota

Comments (8)

zhrt123 commented on August 10, 2024

Could you please show regression.diffs? I need more information.

from diskquota.

kishenkoilya commented on August 10, 2024

Sure:

+++ \/home\/gpadmin\/rpmbuild\/BUILD\/tests\/isolation2\/results\/test_fast_quota_view\.out     2023-09-12 08:16:23.279000000 +0000
@@ -71,12 +71,12 @@
 2: SELECT schema_name, quota_in_mb, nspsize_in_bytes FROM diskquota.show_fast_schema_quota_view;
  schema_name | quota_in_mb | nspsize_in_bytes
 -------------+-------------+------------------
- s1          | 100         | 3932160
+ s1          | 100         | 3833856
 (1 row)
 2: SELECT schema_name, tablespace_name, quota_in_mb, nspsize_tablespace_in_bytes FROM diskquota.show_fast_schema_tablespace_quota_view;
  schema_name | tablespace_name | quota_in_mb | nspsize_tablespace_in_bytes
 -------------+-----------------+-------------+-----------------------------
- s2          | spc1            | 100         | 3932160
+ s2          | spc1            | 100         | 3833856
 (1 row)

 1: COMMIT;
@@ -89,12 +89,12 @@
 2: SELECT schema_name, quota_in_mb, nspsize_in_bytes FROM diskquota.show_fast_schema_quota_view;
  schema_name | quota_in_mb | nspsize_in_bytes
 -------------+-------------+------------------
- s1          | 100         | 3932160
+ s1          | 100         | 3833856
 (1 row)
 2: SELECT schema_name, tablespace_name, quota_in_mb, nspsize_tablespace_in_bytes FROM diskquota.show_fast_schema_tablespace_quota_view;
  schema_name | tablespace_name | quota_in_mb | nspsize_tablespace_in_bytes
 -------------+-----------------+-------------+-----------------------------
- s2          | spc1            | 100         | 3932160
+ s2          | spc1            | 100         | 3833856
 (1 row)

 -- login r to test role quota view
@@ -124,12 +124,12 @@
 2: SELECT role_name, quota_in_mb, rolsize_in_bytes FROM diskquota.show_fast_role_quota_view;
  role_name | quota_in_mb | rolsize_in_bytes
 -----------+-------------+------------------
- r         | 100         | 7864320
+ r         | 100         | 7667712
 (1 row)
 2: SELECT role_name, tablespace_name, quota_in_mb, rolsize_tablespace_in_bytes FROM diskquota.show_fast_role_tablespace_quota_view;
  role_name | tablespace_name | quota_in_mb | rolsize_tablespace_in_bytes
 -----------+-----------------+-------------+-----------------------------
- r         | spc2            | 100         | 3932160
+ r         | spc2            | 100         | 3833856
 (1 row)

 1: COMMIT;
@@ -142,12 +142,12 @@
 2: SELECT role_name, quota_in_mb, rolsize_in_bytes FROM diskquota.show_fast_role_quota_view;
  role_name | quota_in_mb | rolsize_in_bytes
 -----------+-------------+------------------
- r         | 100         | 7864320
+ r         | 100         | 7667712
 (1 row)
 2: SELECT role_name, tablespace_name, quota_in_mb, rolsize_tablespace_in_bytes FROM diskquota.show_fast_role_tablespace_quota_view;
  role_name | tablespace_name | quota_in_mb | rolsize_tablespace_in_bytes
 -----------+-----------------+-------------+-----------------------------
- r         | spc2            | 100         | 3932160
+ r         | spc2            | 100         | 3833856
 (1 row)

 DROP TABLE IF EXISTS s1.t;

======================================================================

--- \/home\/gpadmin\/rpmbuild\/BUILD\/tests\/isolation2\/expected\/test_relation_size\.out      2023-09-12 08:16:24.888000000 +0000
+++ \/home\/gpadmin\/rpmbuild\/BUILD\/tests\/isolation2\/results\/test_relation_size\.out       2023-09-12 08:16:24.888000000 +0000
@@ -14,7 +14,7 @@
 SELECT diskquota.relation_size('t_dropped');
  relation_size
 ---------------
- 98304
+ 65536
 (1 row)

 -- Inject 'suspension' to servers.
@@ -23,8 +23,7 @@
 --------------------------
  Success:
  Success:
- Success:
-(3 rows)
+(2 rows)

 -- Session 1 will hang before applying stat(2) to the physical file.
 1&: SELECT diskquota.relation_size('t_dropped');  <waiting ...>
@@ -36,8 +35,7 @@
 -------------------------------
  Success:
  Success:
- Success:
-(3 rows)
+(2 rows)
 -- Drop the table.
 DROP TABLE t_dropped;
 DROP
@@ -47,8 +45,7 @@
 --------------------------
  Success:
  Success:
- Success:
-(3 rows)
+(2 rows)
 -- Session 1 will continue and returns 0.
 1<:  <... completed>
  relation_size

======================================================================

--- \/home\/gpadmin\/rpmbuild\/BUILD\/tests\/isolation2\/expected\/test_vacuum\.out     2023-09-12 08:16:44.446000000 +0000
+++ \/home\/gpadmin\/rpmbuild\/BUILD\/tests\/isolation2\/results\/test_vacuum\.out      2023-09-12 08:16:44.455000000 +0000
@@ -30,23 +30,21 @@
 SELECT pg_table_size('dummy_t1');
  pg_table_size
 ---------------
- 98304
+ 65536
 (1 row)
 SELECT tableid::regclass, size, segid FROM diskquota.table_size WHERE tableid='dummy_t1'::regclass ORDER BY segid;
  tableid  | size  | segid
 ----------+-------+-------
- dummy_t1 | 98304 | -1
+ dummy_t1 | 65536 | -1
  dummy_t1 | 32768 | 0
  dummy_t1 | 32768 | 1
- dummy_t1 | 32768 | 2
-(4 rows)
+(3 rows)
 SELECT gp_inject_fault_infinite('object_access_post_alter', 'suspend', dbid) FROM gp_segment_configuration WHERE role='p' AND content<>-1;
  gp_inject_fault_infinite
 --------------------------
  Success:
  Success:
- Success:
-(3 rows)
+(2 rows)
 SELECT diskquota.wait_for_worker_new_epoch();
  wait_for_worker_new_epoch
 ---------------------------
@@ -58,8 +56,7 @@
 -------------------------------
  Success:
  Success:
- Success:
-(3 rows)
+(2 rows)
 -- Wait for the diskquota bgworker 'consumes' the newly created relfilenode from shmem.
 SELECT diskquota.wait_for_worker_new_epoch();
  wait_for_worker_new_epoch
@@ -71,8 +68,7 @@
 --------------------------
  Success:
  Success:
- Success:
-(3 rows)
+(2 rows)
 1<:  <... completed>
 VACUUM

@@ -94,7 +90,6 @@
  dummy_t1 | 0    | -1
  dummy_t1 | 0    | 0
  dummy_t1 | 0    | 1
- dummy_t1 | 0    | 2
-(4 rows)
+(3 rows)
 DROP TABLE dummy_t1;
 DROP

======================================================================

--- \/home\/gpadmin\/rpmbuild\/BUILD\/tests\/isolation2\/expected\/test_truncate\.out   2023-09-12 08:16:46.025000000 +0000
+++ \/home\/gpadmin\/rpmbuild\/BUILD\/tests\/isolation2\/results\/test_truncate\.out    2023-09-12 08:16:46.064000000 +0000
@@ -16,24 +16,22 @@
 SELECT pg_table_size('dummy_t1');
  pg_table_size
 ---------------
- 98304
+ 65536
 (1 row)
 SELECT tableid::regclass, size, segid FROM diskquota.table_size WHERE tableid='dummy_t1'::regclass ORDER BY segid;
  tableid  | size  | segid
 ----------+-------+-------
- dummy_t1 | 98304 | -1
+ dummy_t1 | 65536 | -1
  dummy_t1 | 32768 | 0
  dummy_t1 | 32768 | 1
- dummy_t1 | 32768 | 2
-(4 rows)
+(3 rows)

 SELECT gp_inject_fault_infinite('diskquota_after_smgrcreate', 'suspend', dbid) FROM gp_segment_configuration WHERE role='p' AND content<>-1;
  gp_inject_fault_infinite
 --------------------------
  Success:
  Success:
- Success:
-(3 rows)
+(2 rows)
 SELECT diskquota.wait_for_worker_new_epoch();
  wait_for_worker_new_epoch
 ---------------------------
@@ -45,8 +43,7 @@
 -------------------------------
  Success:
  Success:
- Success:
-(3 rows)
+(2 rows)
 -- Wait for the diskquota bgworker 'consumes' the newly created relfilenode from shmem.
 SELECT diskquota.wait_for_worker_new_epoch();
  wait_for_worker_new_epoch
@@ -58,8 +55,7 @@
 --------------------------
  Success:
  Success:
- Success:
-(3 rows)
+(2 rows)
 1<:  <... completed>
 TRUNCATE

@@ -81,7 +77,6 @@
  dummy_t1 | 0    | -1
  dummy_t1 | 0    | 0
  dummy_t1 | 0    | 1
- dummy_t1 | 0    | 2
-(4 rows)
+(3 rows)
 DROP TABLE dummy_t1;
 DROP

======================================================================

--- \/home\/gpadmin\/rpmbuild\/BUILD\/tests\/isolation2\/expected\/test_ereport_from_seg\.out   2023-09-12 08:17:13.610000000 +0000
+++ \/home\/gpadmin\/rpmbuild\/BUILD\/tests\/isolation2\/results\/test_ereport_from_seg\.out    2023-09-12 08:17:13.610000000 +0000
@@ -20,7 +20,7 @@
 SELECT schema_name, quota_in_mb, nspsize_in_bytes FROM diskquota.show_fast_schema_quota_view WHERE schema_name = 'efs1';
  schema_name | quota_in_mb | nspsize_in_bytes
 -------------+-------------+------------------
- efs1        | 1           | 688128
+ efs1        | 1           | 589824
 (1 row)

 -- Enable check quota by relfilenode on seg0.
@@ -47,7 +47,7 @@
 SELECT schema_name, quota_in_mb, nspsize_in_bytes FROM diskquota.show_fast_schema_quota_view WHERE schema_name = 'efs1';
  schema_name | quota_in_mb | nspsize_in_bytes
 -------------+-------------+------------------
- efs1        | 1           | 1081344
+ efs1        | 1           | 950272
 (1 row)

 DROP TABLE efs1.t;

======================================================================

from diskquota.

zhrt123 commented on August 10, 2024

It seems that there are only two segments on your GP cluster.

@@ -81,7 +77,6 @@
  dummy_t1 | 0    | -1
  dummy_t1 | 0    | 0
  dummy_t1 | 0    | 1
- dummy_t1 | 0    | 2
-(4 rows)

from diskquota.

kishenkoilya commented on August 10, 2024

well yeah, since in order to start tests i had to download gpdb source files, build and install them, so i have only what i have built. I wasn't able to run tests on cluster created from my gpdb rpm, because there were erros about missing gpdb src files. Also it's a test server, so i didn't think that i should have more than 2 segments.

from diskquota.

zhrt123 commented on August 10, 2024

The diskquota tests are based on the 3-segment cluster, so some tests will fail on the 2-segment cluster.

from diskquota.

kishenkoilya commented on August 10, 2024

So i need a 3 or more segment cluster? I think you should add that information to readme. It's not really obvious how to run those tests correctly. Meanwhile i will try 3 segment cluster.

from diskquota.

kishenkoilya commented on August 10, 2024

This test group is done, but there are problems with next. Now test cluster has 3 segments. Primary run on port 6000, master 5432.

test config                   ... ok (9.75 sec)  (diff:0.13 sec)
test test_create_extension    ... ok (1.88 sec)  (diff:0.13 sec)
test test_readiness_logged    ... ok (16.10 sec)  (diff:0.18 sec)
test test_init_table_size_table ... ok (5.13 sec)  (diff:0.13 sec)
test test_relation_size       ... ok (3.49 sec)  (diff:0.10 sec)
test test_relation_cache      ... ok (2.27 sec)  (diff:0.10 sec)
test test_uncommitted_table_size ... ok (4.90 sec)  (diff:0.12 sec)
test test_pause_and_resume    ... ok (1.70 sec)  (diff:0.11 sec)
test test_pause_and_resume_multiple_db ... ok (43.63 sec)  (diff:0.11 sec)
test test_drop_after_pause    ... ok (23.15 sec)  (diff:0.23 sec)
test test_show_status         ... ok (9.17 sec)  (diff:0.17 sec)
test test_update_db_cache     ... ok (14.32 sec)  (diff:0.19 sec)
test test_quota_view_no_table ... ok (2.31 sec)  (diff:0.14 sec)
test test_fast_disk_check     ... ok (2.73 sec)  (diff:0.10 sec)
test test_worker_not_ready    ... ok (7.75 sec)  (diff:0.18 sec)
parallel group (19 tests):  test_mistake test_copy test_update test_delete_quota test_column test_drop_table test_reschema test_temp_role test_truncate test_rename test_role test_schema test_index test_recreate test_tablespace_schema test_tablespace_role_perseg test_tablespace_schema_perseg test_tablespace_role test_toast
     test_role                ... ok (25.54 sec)  (diff:0.13 sec)
     test_schema              ... ok (27.77 sec)  (diff:0.08 sec)
     test_drop_table          ... ok (16.84 sec)  (diff:0.11 sec)
     test_column              ... ok (16.58 sec)  (diff:0.09 sec)
     test_copy                ... ok (13.92 sec)  (diff:0.10 sec)
     test_update              ... ok (14.21 sec)  (diff:0.10 sec)
     test_toast               ... ok (106.69 sec)  (diff:0.09 sec)
     test_truncate            ... ok (17.27 sec)  (diff:0.07 sec)
     test_reschema            ... ok (16.92 sec)  (diff:0.10 sec)
     test_temp_role           ... ok (17.09 sec)  (diff:0.07 sec)
     test_rename              ... ok (25.11 sec)  (diff:0.10 sec)
     test_delete_quota        ... ok (15.94 sec)  (diff:0.08 sec)
     test_mistake             ... ok (8.88 sec)  (diff:0.09 sec)
     test_tablespace_role     ... ok (47.83 sec)  (diff:0.18 sec)
     test_tablespace_schema   ... ok (42.56 sec)  (diff:0.10 sec)
     test_tablespace_role_perseg ... ok (45.95 sec)  (diff:0.09 sec)
     test_tablespace_schema_perseg ... ok (46.97 sec)  (diff:0.11 sec)
     test_index               ... ok (38.29 sec)  (diff:0.09 sec)
     test_recreate            ... ok (40.83 sec)  (diff:0.07 sec)
test test_ctas_no_preload_lib ... ok (20.64 sec)  (diff:0.11 sec)
test test_ctas_before_set_quota ... ok (1.00 sec)  (diff:0.12 sec)
test test_truncate            ... ok (1.11 sec)  (diff:0.10 sec)
test test_delete_quota        ... ok (0.97 sec)  (diff:0.14 sec)
test test_partition           ... ok (1.69 sec)  (diff:0.11 sec)
test test_vacuum              ... ok (1.38 sec)  (diff:0.13 sec)
test test_primary_failure     ... FAILED (4.02 sec)  (diff:0.35 sec)
test test_extension           ... FAILED (8.89 sec)  (diff:0.26 sec) (test process exited with exit code 2)
test test_activetable_limit   ... ok (26.37 sec)  (diff:0.19 sec)
test test_many_active_tables  ... ok (99.95 sec)  (diff:0.22 sec)
test test_fetch_table_stat    ... ok (0.62 sec)  (diff:0.16 sec)
test test_appendonly          ... ok (1.81 sec)  (diff:0.12 sec)
test test_rejectmap           ... FAILED (3.08 sec)  (diff:0.24 sec)
test test_clean_rejectmap_after_drop ... ok (11.03 sec)  (diff:0.17 sec)
test test_rejectmap_mul_db    ... ok (26.27 sec)  (diff:0.17 sec)
test test_ctas_pause          ... ok (19.51 sec)  (diff:0.09 sec)
test test_ctas_role           ... ok (5.54 sec)  (diff:0.13 sec)
test test_ctas_schema         ... ok (4.83 sec)  (diff:0.09 sec)
test test_ctas_tablespace_role ... ok (6.27 sec)  (diff:0.13 sec)
test test_ctas_tablespace_schema ... ok (5.89 sec)  (diff:0.14 sec)
test test_default_tablespace  ... ok (25.15 sec)  (diff:0.15 sec)
test test_tablespace_diff_schema ... ok (5.05 sec)  (diff:0.10 sec)
test test_worker_schedule     ... ok (260.38 sec)  (diff:0.25 sec)
test test_worker_schedule_exception ... ok (44.47 sec)  (diff:0.17 sec)
test test_dbname_encoding     ... ok (8.91 sec)  (diff:0.16 sec)
test test_drop_extension      ... ok (4.02 sec)  (diff:0.10 sec)
test reset_config             ... ok (1.51 sec)  (diff:0.09 sec)

=======================
 3 of 61 tests failed.
=======================

+++ \/home\/gpadmin\/rpmbuild\/BUILD\/tests\/regress\/results\/test_primary_failure\.out        2023-09-13 12:54:00.183000000 +0000
@@ -78,20 +78,18 @@
 select content, preferred_role, role, status, mode from gp_segment_configuration where content = 0;
  content | preferred_role | role | status | mode
 ---------+----------------+------+--------+------
-       0 | m              | p    | u      | n
-       0 | p              | m    | d      | n
-(2 rows)
+       0 | p              | p    | u      | n
+(1 row)

 -- expect insert fail
 INSERT INTO a SELECT 2, generate_series(1,100);
 ERROR:  schema's disk space quota exceeded with name: ftsr
 -- increase quota
 SELECT diskquota.set_schema_quota('ftsr', '200 MB');
- set_schema_quota
-------------------
-
-(1 row)
-
+ERROR:  Error on receive from seg0 : server closed the connection unexpectedly
+       This probably means the server terminated abnormally
+       before or while processing the request.
+DETAIL:  SQL statement "select state from diskquota.state"
 SELECT diskquota.wait_for_worker_new_epoch();
  wait_for_worker_new_epoch
 ---------------------------
@@ -100,6 +98,7 @@

 -- expect insert success
 INSERT INTO a SELECT 2, generate_series(1,10000);
+ERROR:  schema's disk space quota exceeded with name: ftsr
 SELECT diskquota.wait_for_worker_new_epoch();
  wait_for_worker_new_epoch
 ---------------------------
@@ -109,14 +108,11 @@
 -- check whether monitored_dbid_cache is refreshed in mirror
 -- diskquota.table_size should be updated
 SELECT tableid::regclass, size, segid FROM diskquota.table_size WHERE tableid = 'a'::regclass ORDER BY segid;
- tableid |  size   | segid
----------+---------+-------
- a       | 4096000 |    -1
- a       | 4096000 |     0
- a       |       0 |     1
- a       |       0 |     2
-(4 rows)
-
+ERROR:  failed to acquire resources on one or more segments
+DETAIL:  could not connect to server: Connection refused
+       Is the server running on host "172.17.0.2" and accepting
+       TCP/IP connections on port 6000?
+ (seg0 172.17.0.2:6000)
 -- pull up failed primary
 GP_IGNORE:-- start_ignore
 GP_IGNORE:select pg_recoverseg((select datadir from gp_segment_configuration c where c.role='p' and c.content=-1), 'a');
@@ -288,14 +194,26 @@
 (1 row)

 SELECT quota_in_mb, nspsize_in_bytes from diskquota.show_fast_schema_quota_view where schema_name='ftsr';
- quota_in_mb | nspsize_in_bytes
--------------+------------------
-         200 |          4096000
-(1 row)
-
+ERROR:  failed to acquire resources on one or more segments
+DETAIL:  could not connect to server: Connection refused
+       Is the server running on host "172.17.0.2" and accepting
+       TCP/IP connections on port 6000?
+ (seg0 172.17.0.2:6000)
 INSERT INTO a SELECT 2, generate_series(1,100);
+ERROR:  schema's disk space quota exceeded with name: ftsr
 DROP TABLE a;
+ERROR:  failed to acquire resources on one or more segments
+DETAIL:  could not connect to server: Connection refused
+       Is the server running on host "172.17.0.2" and accepting
+       TCP/IP connections on port 6000?
+ (seg0 172.17.0.2:6000)
 DROP SCHEMA ftsr CASCADE;
-NOTICE:  drop cascades to 2 other objects
+NOTICE:  drop cascades to 3 other objects
 DETAIL:  drop cascades to function pg_ctl(text,text,text)
 drop cascades to function pg_recoverseg(text,text)
+drop cascades to table a
+ERROR:  failed to acquire resources on one or more segments
+DETAIL:  could not connect to server: Connection refused
+       Is the server running on host "172.17.0.2" and accepting
+       TCP/IP connections on port 6000?
+ (seg0 172.17.0.2:6000)

======================================================================

--- \/home\/gpadmin\/rpmbuild\/BUILD\/tests\/regress\/expected\/test_extension\.out     2023-09-13 12:54:09.329000000 +0000
+++ \/home\/gpadmin\/rpmbuild\/BUILD\/tests\/regress\/results\/test_extension\.out      2023-09-13 12:54:09.329000000 +0000
@@ -2,50 +2,101 @@
 -- NOTE: when test this script, you must make sure that there is no diskquota
 -- worker process.
 CREATE DATABASE dbx0 ;
+ERROR:  failed to acquire resources on one or more segments
+DETAIL:  could not connect to server: Connection refused
+       Is the server running on host "172.17.0.2" and accepting
+       TCP/IP connections on port 6000?
+ (seg0 172.17.0.2:6000)
 CREATE DATABASE dbx1 ;
+ERROR:  failed to acquire resources on one or more segments
+DETAIL:  could not connect to server: Connection refused
+       Is the server running on host "172.17.0.2" and accepting
+       TCP/IP connections on port 6000?
+ (seg0 172.17.0.2:6000)
 CREATE DATABASE dbx2 ;
+ERROR:  failed to acquire resources on one or more segments
+DETAIL:  could not connect to server: Connection refused
+       Is the server running on host "172.17.0.2" and accepting
+       TCP/IP connections on port 6000?
+ (seg0 172.17.0.2:6000)
 CREATE DATABASE dbx3 ;
+ERROR:  failed to acquire resources on one or more segments
+DETAIL:  could not connect to server: Connection refused
+       Is the server running on host "172.17.0.2" and accepting
+       TCP/IP connections on port 6000?
+ (seg0 172.17.0.2:6000)
 CREATE DATABASE dbx4 ;
+ERROR:  failed to acquire resources on one or more segments
+DETAIL:  could not connect to server: Connection refused
+       Is the server running on host "172.17.0.2" and accepting
+       TCP/IP connections on port 6000?
+ (seg0 172.17.0.2:6000)
 CREATE DATABASE dbx5 ;
+ERROR:  failed to acquire resources on one or more segments
+DETAIL:  could not connect to server: Connection refused
+       Is the server running on host "172.17.0.2" and accepting
+       TCP/IP connections on port 6000?
+ (seg0 172.17.0.2:6000)
 CREATE DATABASE dbx6 ;
+ERROR:  failed to acquire resources on one or more segments
+DETAIL:  could not connect to server: Connection refused
+       Is the server running on host "172.17.0.2" and accepting
+       TCP/IP connections on port 6000?
+ (seg0 172.17.0.2:6000)
 CREATE DATABASE dbx7 ;
+ERROR:  failed to acquire resources on one or more segments
+DETAIL:  could not connect to server: Connection refused
+       Is the server running on host "172.17.0.2" and accepting
+       TCP/IP connections on port 6000?
+ (seg0 172.17.0.2:6000)
 CREATE DATABASE dbx8 ;
+ERROR:  failed to acquire resources on one or more segments
+DETAIL:  could not connect to server: Connection refused
+       Is the server running on host "172.17.0.2" and accepting
+       TCP/IP connections on port 6000?
+ (seg0 172.17.0.2:6000)
 CREATE DATABASE dbx9 ;
+ERROR:  failed to acquire resources on one or more segments
+DETAIL:  could not connect to server: Connection refused
+       Is the server running on host "172.17.0.2" and accepting
+       TCP/IP connections on port 6000?
+ (seg0 172.17.0.2:6000)
 CREATE DATABASE dbx10 ;
+ERROR:  failed to acquire resources on one or more segments
+DETAIL:  could not connect to server: Connection refused
+       Is the server running on host "172.17.0.2" and accepting
+       TCP/IP connections on port 6000?
+ (seg0 172.17.0.2:6000)
 GP_IGNORE:--start_ignore
 GP_IGNORE:\! gpconfig -c diskquota.max_workers -v 20 --skipvalidation
-GP_IGNORE:20220802:15:47:27:028366 gpconfig:wxiaoran-a01:xiwang-[INFO]:-completed successfully with parameters '-c diskquota.max_workers -v 20 --skipvalidation'
+GP_IGNORE:20230913:12:54:02:030589 gpconfig:458b2a1b7e03:gpadmin-[INFO]:-completed successfully with parameters '-c diskquota.max_workers -v 20 --skipvalidation'
 GP_IGNORE:\! gpstop -arf
-GP_IGNORE:20220802:16:43:25:058210 gpstop:wxiaoran-a01:xiwang-[INFO]:-Starting gpstop with args: -arf
-GP_IGNORE:20220802:16:43:25:058210 gpstop:wxiaoran-a01:xiwang-[INFO]:-Gathering information and validating the environment...
-GP_IGNORE:20220802:16:43:25:058210 gpstop:wxiaoran-a01:xiwang-[INFO]:-Obtaining Greenplum Master catalog information
-GP_IGNORE:20220802:16:43:25:058210 gpstop:wxiaoran-a01:xiwang-[INFO]:-Obtaining Segment details from master...
-GP_IGNORE:20220802:16:43:25:058210 gpstop:wxiaoran-a01:xiwang-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.20.3+dev.5.g4bc90eab02 build dev'
-GP_IGNORE:20220802:16:43:25:058210 gpstop:wxiaoran-a01:xiwang-[INFO]:-Commencing Master instance shutdown with mode='fast'
-GP_IGNORE:20220802:16:43:25:058210 gpstop:wxiaoran-a01:xiwang-[INFO]:-Master segment instance directory=/Users/xiwang/gpdb/gpAux/gpdemo/datadirs/qddir/demoDataDir-1/
-GP_IGNORE:20220802:16:43:25:058210 gpstop:wxiaoran-a01:xiwang-[INFO]:-Attempting forceful termination of any leftover master process
-GP_IGNORE:20220802:16:43:25:058210 gpstop:wxiaoran-a01:xiwang-[INFO]:-Terminating processes for segment /Users/xiwang/gpdb/gpAux/gpdemo/datadirs/qddir/demoDataDir-1/
-GP_IGNORE:20220802:16:43:25:058210 gpstop:wxiaoran-a01:xiwang-[INFO]:-Stopping master standby host wxiaoran-a01.vmware.com mode=fast
-GP_IGNORE:20220802:16:43:26:058210 gpstop:wxiaoran-a01:xiwang-[INFO]:-Successfully shutdown standby process on wxiaoran-a01.vmware.com
-GP_IGNORE:20220802:16:43:26:058210 gpstop:wxiaoran-a01:xiwang-[INFO]:-Targeting dbid [2, 5, 3, 6, 4, 7] for shutdown
-GP_IGNORE:20220802:16:43:26:058210 gpstop:wxiaoran-a01:xiwang-[INFO]:-Commencing parallel primary segment instance shutdown, please wait...
-GP_IGNORE:20220802:16:43:26:058210 gpstop:wxiaoran-a01:xiwang-[INFO]:-0.00% of jobs completed
-GP_IGNORE:20220802:16:43:28:058210 gpstop:wxiaoran-a01:xiwang-[INFO]:-100.00% of jobs completed
-GP_IGNORE:20220802:16:43:28:058210 gpstop:wxiaoran-a01:xiwang-[INFO]:-Commencing parallel mirror segment instance shutdown, please wait...
-GP_IGNORE:20220802:16:43:28:058210 gpstop:wxiaoran-a01:xiwang-[INFO]:-0.00% of jobs completed
-GP_IGNORE:20220802:16:43:29:058210 gpstop:wxiaoran-a01:xiwang-[INFO]:-100.00% of jobs completed
-GP_IGNORE:20220802:16:43:29:058210 gpstop:wxiaoran-a01:xiwang-[INFO]:-----------------------------------------------------
-GP_IGNORE:20220802:16:43:29:058210 gpstop:wxiaoran-a01:xiwang-[INFO]:-   Segments stopped successfully      = 6
-GP_IGNORE:20220802:16:43:29:058210 gpstop:wxiaoran-a01:xiwang-[INFO]:-   Segments with errors during stop   = 0
-GP_IGNORE:20220802:16:43:29:058210 gpstop:wxiaoran-a01:xiwang-[INFO]:-----------------------------------------------------
-GP_IGNORE:20220802:16:43:29:058210 gpstop:wxiaoran-a01:xiwang-[INFO]:-Successfully shutdown 6 of 6 segment instances
-GP_IGNORE:20220802:16:43:29:058210 gpstop:wxiaoran-a01:xiwang-[INFO]:-Database successfully shutdown with no errors reported
-GP_IGNORE:20220802:16:43:29:058210 gpstop:wxiaoran-a01:xiwang-[INFO]:-Cleaning up leftover gpmmon process
-GP_IGNORE:20220802:16:43:29:058210 gpstop:wxiaoran-a01:xiwang-[INFO]:-No leftover gpmmon process found
-GP_IGNORE:20220802:16:43:29:058210 gpstop:wxiaoran-a01:xiwang-[INFO]:-Cleaning up leftover gpsmon processes
-GP_IGNORE:20220802:16:43:29:058210 gpstop:wxiaoran-a01:xiwang-[INFO]:-No leftover gpsmon processes on some hosts. not attempting forceful termination on these hosts
-GP_IGNORE:20220802:16:43:29:058210 gpstop:wxiaoran-a01:xiwang-[INFO]:-Cleaning up leftover shared memory
-GP_IGNORE:20220802:16:43:30:058210 gpstop:wxiaoran-a01:xiwang-[INFO]:-Restarting System...
+GP_IGNORE:20230913:12:54:02:030707 gpstop:458b2a1b7e03:gpadmin-[INFO]:-Starting gpstop with args: -arf
+GP_IGNORE:20230913:12:54:02:030707 gpstop:458b2a1b7e03:gpadmin-[INFO]:-Gathering information and validating the environment...
+GP_IGNORE:20230913:12:54:02:030707 gpstop:458b2a1b7e03:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
+GP_IGNORE:20230913:12:54:02:030707 gpstop:458b2a1b7e03:gpadmin-[INFO]:-Obtaining Segment details from master...
+GP_IGNORE:20230913:12:54:02:030707 gpstop:458b2a1b7e03:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.21.3 build dev'
+GP_IGNORE:20230913:12:54:02:030707 gpstop:458b2a1b7e03:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='fast'
+GP_IGNORE:20230913:12:54:02:030707 gpstop:458b2a1b7e03:gpadmin-[INFO]:-Master segment instance directory=/data/master/gpseg-1
+GP_IGNORE:20230913:12:54:03:030707 gpstop:458b2a1b7e03:gpadmin-[INFO]:-Attempting forceful termination of any leftover master process
+GP_IGNORE:20230913:12:54:03:030707 gpstop:458b2a1b7e03:gpadmin-[INFO]:-Terminating processes for segment /data/master/gpseg-1
+GP_IGNORE:20230913:12:54:03:030707 gpstop:458b2a1b7e03:gpadmin-[INFO]:-No standby master host configured
+GP_IGNORE:20230913:12:54:03:030707 gpstop:458b2a1b7e03:gpadmin-[INFO]:-Targeting dbid [2, 3, 4] for shutdown
+GP_IGNORE:20230913:12:54:03:030707 gpstop:458b2a1b7e03:gpadmin-[INFO]:-Commencing parallel segment instance shutdown, please wait...
+GP_IGNORE:20230913:12:54:03:030707 gpstop:458b2a1b7e03:gpadmin-[INFO]:-0.00% of jobs completed
+GP_IGNORE:20230913:12:54:03:030707 gpstop:458b2a1b7e03:gpadmin-[INFO]:-100.00% of jobs completed
+GP_IGNORE:20230913:12:54:03:030707 gpstop:458b2a1b7e03:gpadmin-[INFO]:-----------------------------------------------------
+GP_IGNORE:20230913:12:54:03:030707 gpstop:458b2a1b7e03:gpadmin-[INFO]:-   Segments stopped successfully      = 3
+GP_IGNORE:20230913:12:54:03:030707 gpstop:458b2a1b7e03:gpadmin-[INFO]:-   Segments with errors during stop   = 0
+GP_IGNORE:20230913:12:54:03:030707 gpstop:458b2a1b7e03:gpadmin-[INFO]:-----------------------------------------------------
+GP_IGNORE:20230913:12:54:03:030707 gpstop:458b2a1b7e03:gpadmin-[INFO]:-Successfully shutdown 3 of 3 segment instances
+GP_IGNORE:20230913:12:54:03:030707 gpstop:458b2a1b7e03:gpadmin-[INFO]:-Database successfully shutdown with no errors reported
+GP_IGNORE:20230913:12:54:03:030707 gpstop:458b2a1b7e03:gpadmin-[INFO]:-Cleaning up leftover gpmmon process
+GP_IGNORE:20230913:12:54:03:030707 gpstop:458b2a1b7e03:gpadmin-[INFO]:-No leftover gpmmon process found
+GP_IGNORE:20230913:12:54:03:030707 gpstop:458b2a1b7e03:gpadmin-[INFO]:-Cleaning up leftover gpsmon processes
+GP_IGNORE:20230913:12:54:04:030707 gpstop:458b2a1b7e03:gpadmin-[INFO]:-No leftover gpsmon processes on some hosts. not attempting forceful termination on these hosts
+GP_IGNORE:20230913:12:54:04:030707 gpstop:458b2a1b7e03:gpadmin-[INFO]:-Cleaning up leftover shared memory
+GP_IGNORE:20230913:12:54:04:030707 gpstop:458b2a1b7e03:gpadmin-[INFO]:-Restarting System...
 GP_IGNORE:--end_ignore
 \c
 show max_worker_processes;
@@ -67,468 +118,4 @@
 (1 row)

 \c dbx0
-CREATE EXTENSION diskquota;
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-CREATE SCHEMA SX;
-CREATE TABLE SX.a(i int) DISTRIBUTED BY (i);
-SELECT diskquota.set_schema_quota('SX', '1MB');
- set_schema_quota
-------------------
-
-(1 row)
-
-INSERT INTO SX.a values(generate_series(0, 100000));
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-INSERT INTO SX.a values(generate_series(0, 10));
-ERROR:  schema's disk space quota exceeded with name: sx
-DROP TABLE SX.a;
-\c dbx1
-CREATE SCHEMA SX;
-CREATE TABLE SX.a(i int) DISTRIBUTED BY (i);
-INSERT INTO SX.a values(generate_series(0, 100000));
-CREATE EXTENSION diskquota;
-WARNING:  [diskquota] diskquota is not ready because current database is not empty
-HINT:  please run 'SELECT diskquota.init_table_size_table();' to initialize diskquota
-SELECT diskquota.init_table_size_table();
- init_table_size_table
------------------------
-
-(1 row)
-
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-SELECT diskquota.set_schema_quota('SX', '1MB');
- set_schema_quota
-------------------
-
-(1 row)
-
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-INSERT INTO SX.a values(generate_series(0, 10));
-ERROR:  schema's disk space quota exceeded with name: sx
-DROP TABLE SX.a;
-\c dbx2
-CREATE EXTENSION diskquota;
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-CREATE SCHEMA SX;
-CREATE TABLE SX.a(i int) DISTRIBUTED BY (i);
-SELECT diskquota.set_schema_quota('SX', '1MB');
- set_schema_quota
-------------------
-
-(1 row)
-
-INSERT INTO SX.a values(generate_series(0, 100000));
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-INSERT INTO SX.a values(generate_series(0, 10));
-ERROR:  schema's disk space quota exceeded with name: sx
-DROP TABLE SX.a;
-\c dbx3
-CREATE EXTENSION diskquota;
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-CREATE SCHEMA SX;
-CREATE TABLE SX.a(i int) DISTRIBUTED BY (i);
-SELECT diskquota.set_schema_quota('SX', '1MB');
- set_schema_quota
-------------------
-
-(1 row)
-
-INSERT INTO SX.a values(generate_series(0, 100000));
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-INSERT INTO SX.a values(generate_series(0, 10));
-ERROR:  schema's disk space quota exceeded with name: sx
-DROP TABLE SX.a;
-\c dbx4
-CREATE EXTENSION diskquota;
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-CREATE SCHEMA SX;
-CREATE TABLE SX.a(i int) DISTRIBUTED BY (i);
-SELECT diskquota.set_schema_quota('SX', '1MB');
- set_schema_quota
-------------------
-
-(1 row)
-
-INSERT INTO SX.a values(generate_series(0, 100000));
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-INSERT INTO SX.a values(generate_series(0, 10));
-ERROR:  schema's disk space quota exceeded with name: sx
-DROP TABLE SX.a;
-\c dbx5
-CREATE EXTENSION diskquota;
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-CREATE SCHEMA SX;
-CREATE TABLE SX.a(i int) DISTRIBUTED BY (i);
-SELECT diskquota.set_schema_quota('SX', '1MB');
- set_schema_quota
-------------------
-
-(1 row)
-
-INSERT INTO SX.a values(generate_series(0, 100000));
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-INSERT INTO SX.a values(generate_series(0, 10));
-ERROR:  schema's disk space quota exceeded with name: sx
-DROP TABLE SX.a;
-\c dbx6
-CREATE EXTENSION diskquota;
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-CREATE SCHEMA SX;
-CREATE TABLE SX.a(i int) DISTRIBUTED BY (i);
-SELECT diskquota.set_schema_quota('SX', '1MB');
- set_schema_quota
-------------------
-
-(1 row)
-
-INSERT INTO SX.a values(generate_series(0, 100000));
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-INSERT INTO SX.a values(generate_series(0, 10));
-ERROR:  schema's disk space quota exceeded with name: sx
-DROP TABLE SX.a;
-\c dbx7
-CREATE EXTENSION diskquota;
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-CREATE SCHEMA SX;
-CREATE TABLE SX.a(i int) DISTRIBUTED BY (i);
-SELECT diskquota.set_schema_quota('SX', '1MB');
- set_schema_quota
-------------------
-
-(1 row)
-
-INSERT INTO SX.a values(generate_series(0, 100000));
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-INSERT INTO SX.a values(generate_series(0, 10));
-ERROR:  schema's disk space quota exceeded with name: sx
-DROP TABLE SX.a;
-\c dbx8
-CREATE EXTENSION diskquota;
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-CREATE SCHEMA SX;
-CREATE TABLE SX.a(i int) DISTRIBUTED BY (i);
-SELECT diskquota.set_schema_quota('SX', '1MB');
- set_schema_quota
-------------------
-
-(1 row)
-
-INSERT INTO SX.a values(generate_series(0, 100000));
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-INSERT INTO SX.a values(generate_series(0, 10));
-ERROR:  schema's disk space quota exceeded with name: sx
-DROP TABLE SX.a;
-\c dbx9
-CREATE EXTENSION diskquota;
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-\c dbx10
-CREATE EXTENSION diskquota;
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-\c dbx0
-SELECT diskquota.pause();
- pause
--------
-
-(1 row)
-
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-DROP EXTENSION diskquota;
-\c dbx1
-SELECT diskquota.pause();
- pause
--------
-
-(1 row)
-
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-DROP EXTENSION diskquota;
-\c dbx2
-SELECT diskquota.pause();
- pause
--------
-
-(1 row)
-
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-DROP EXTENSION diskquota;
-\c dbx3
-SELECT diskquota.pause();
- pause
--------
-
-(1 row)
-
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-DROP EXTENSION diskquota;
-\c dbx4
-SELECT diskquota.pause();
- pause
--------
-
-(1 row)
-
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-DROP EXTENSION diskquota;
-\c dbx5
-SELECT diskquota.pause();
- pause
--------
-
-(1 row)
-
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-DROP EXTENSION diskquota;
-\c dbx6
-SELECT diskquota.pause();
- pause
--------
-
-(1 row)
-
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-DROP EXTENSION diskquota;
-\c dbx7
-SELECT diskquota.pause();
- pause
--------
-
-(1 row)
-
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-DROP EXTENSION diskquota;
-\c dbx8
-SELECT diskquota.pause();
- pause
--------
-
-(1 row)
-
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-DROP EXTENSION diskquota;
-\c dbx9
-SELECT diskquota.pause();
- pause
--------
-
-(1 row)
-
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-DROP EXTENSION diskquota;
-\c dbx10
-SELECT diskquota.pause();
- pause
--------
-
-(1 row)
-
-SELECT diskquota.wait_for_worker_new_epoch();
- wait_for_worker_new_epoch
----------------------------
- t
-(1 row)
-
-DROP EXTENSION diskquota;
-\c contrib_regression
-DROP DATABASE dbx0 ;
-DROP DATABASE dbx1 ;
-DROP DATABASE dbx2 ;
-DROP DATABASE dbx3 ;
-DROP DATABASE dbx4 ;
-DROP DATABASE dbx5 ;
-DROP DATABASE dbx6 ;
-DROP DATABASE dbx7 ;
-DROP DATABASE dbx8 ;
-DROP DATABASE dbx9 ;
-DROP DATABASE dbx10 ;
-GP_IGNORE:--start_ignore
-GP_IGNORE:\! gpconfig -c diskquota.max_workers -v 1 --skipvalidation
-GP_IGNORE:20220802:15:49:09:029439 gpconfig:wxiaoran-a01:xiwang-[INFO]:-completed successfully with parameters '-c diskquota.max_workers -v 1 --skipvalidation'
-GP_IGNORE:\! gpstop -arf;
-GP_IGNORE:20220802:16:32:34:046832 gpstop:wxiaoran-a01:xiwang-[INFO]:-Starting gpstop with args: -arf
-GP_IGNORE:20220802:16:32:34:046832 gpstop:wxiaoran-a01:xiwang-[INFO]:-Gathering information and validating the environment...
-GP_IGNORE:20220802:16:32:34:046832 gpstop:wxiaoran-a01:xiwang-[INFO]:-Obtaining Greenplum Master catalog information
-GP_IGNORE:20220802:16:32:34:046832 gpstop:wxiaoran-a01:xiwang-[INFO]:-Obtaining Segment details from master...
-GP_IGNORE:20220802:16:32:34:046832 gpstop:wxiaoran-a01:xiwang-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.20.3+dev.5.g4bc90eab02 build dev'
-GP_IGNORE:20220802:16:32:34:046832 gpstop:wxiaoran-a01:xiwang-[INFO]:-Commencing Master instance shutdown with mode='fast'
-GP_IGNORE:20220802:16:32:34:046832 gpstop:wxiaoran-a01:xiwang-[INFO]:-Master segment instance directory=/Users/xiwang/gpdb/gpAux/gpdemo/datadirs/qddir/demoDataDir-1/
-GP_IGNORE:20220802:16:32:35:046832 gpstop:wxiaoran-a01:xiwang-[INFO]:-Attempting forceful termination of any leftover master process
-GP_IGNORE:20220802:16:32:35:046832 gpstop:wxiaoran-a01:xiwang-[INFO]:-Terminating processes for segment /Users/xiwang/gpdb/gpAux/gpdemo/datadirs/qddir/demoDataDir-1/
-GP_IGNORE:20220802:16:32:36:046832 gpstop:wxiaoran-a01:xiwang-[INFO]:-Stopping master standby host wxiaoran-a01.vmware.com mode=fast
-GP_IGNORE:20220802:16:32:37:046832 gpstop:wxiaoran-a01:xiwang-[INFO]:-Successfully shutdown standby process on wxiaoran-a01.vmware.com
-GP_IGNORE:20220802:16:32:37:046832 gpstop:wxiaoran-a01:xiwang-[INFO]:-Targeting dbid [2, 5, 3, 6, 4, 7] for shutdown
-GP_IGNORE:20220802:16:32:37:046832 gpstop:wxiaoran-a01:xiwang-[INFO]:-Commencing parallel primary segment instance shutdown, please wait...
-GP_IGNORE:20220802:16:32:37:046832 gpstop:wxiaoran-a01:xiwang-[INFO]:-0.00% of jobs completed
-GP_IGNORE:20220802:16:32:40:046832 gpstop:wxiaoran-a01:xiwang-[INFO]:-100.00% of jobs completed
-GP_IGNORE:20220802:16:32:40:046832 gpstop:wxiaoran-a01:xiwang-[INFO]:-Commencing parallel mirror segment instance shutdown, please wait...
-GP_IGNORE:20220802:16:32:40:046832 gpstop:wxiaoran-a01:xiwang-[INFO]:-0.00% of jobs completed
-GP_IGNORE:20220802:16:32:41:046832 gpstop:wxiaoran-a01:xiwang-[INFO]:-100.00% of jobs completed
-GP_IGNORE:20220802:16:32:41:046832 gpstop:wxiaoran-a01:xiwang-[INFO]:-----------------------------------------------------
-GP_IGNORE:20220802:16:32:41:046832 gpstop:wxiaoran-a01:xiwang-[INFO]:-   Segments stopped successfully      = 6
-GP_IGNORE:20220802:16:32:41:046832 gpstop:wxiaoran-a01:xiwang-[INFO]:-   Segments with errors during stop   = 0
-GP_IGNORE:20220802:16:32:41:046832 gpstop:wxiaoran-a01:xiwang-[INFO]:-----------------------------------------------------
-GP_IGNORE:20220802:16:32:41:046832 gpstop:wxiaoran-a01:xiwang-[INFO]:-Successfully shutdown 6 of 6 segment instances
-GP_IGNORE:20220802:16:32:41:046832 gpstop:wxiaoran-a01:xiwang-[INFO]:-Database successfully shutdown with no errors reported
-GP_IGNORE:20220802:16:32:41:046832 gpstop:wxiaoran-a01:xiwang-[INFO]:-Cleaning up leftover gpmmon process
-GP_IGNORE:20220802:16:32:42:046832 gpstop:wxiaoran-a01:xiwang-[INFO]:-No leftover gpmmon process found
-GP_IGNORE:20220802:16:32:42:046832 gpstop:wxiaoran-a01:xiwang-[INFO]:-Cleaning up leftover gpsmon processes
-GP_IGNORE:20220802:16:32:42:046832 gpstop:wxiaoran-a01:xiwang-[INFO]:-No leftover gpsmon processes on some hosts. not attempting forceful termination on these hosts
-GP_IGNORE:20220802:16:32:42:046832 gpstop:wxiaoran-a01:xiwang-[INFO]:-Cleaning up leftover shared memory
-GP_IGNORE:20220802:16:32:44:046832 gpstop:wxiaoran-a01:xiwang-[INFO]:-Restarting System...
-GP_IGNORE:--end_ignore
-\c
-show diskquota.max_workers;
- diskquota.max_workers
------------------------
- 1
-(1 row)
-
+\connect: FATAL:  database "dbx0" does not exist

======================================================================

--- \/home\/gpadmin\/rpmbuild\/BUILD\/tests\/regress\/expected\/test_rejectmap\.out     2023-09-13 12:56:22.070000000 +0000
+++ \/home\/gpadmin\/rpmbuild\/BUILD\/tests\/regress\/results\/test_rejectmap\.out      2023-09-13 12:56:22.090000000 +0000
@@ -93,8 +93,10 @@
   WHERE rel.relfilenode=be.relnode AND be.relnode<>0 AND rel.gp_segment_id=be.segid;
   relname   |   target_type   | namespace_matched
 ------------+-----------------+-------------------
+ a          | NAMESPACE_QUOTA | t
+ a          | NAMESPACE_QUOTA | t
  blocked_t1 | NAMESPACE_QUOTA | t
-(1 row)
+(3 rows)

 -- Insert an entry for blocked_t1 to rejectmap on seg0.
 SELECT block_relation_on_seg0('blocked_t1'::regclass, 'ROLE'::text);
@@ -108,10 +110,12 @@
   FROM gp_dist_random('pg_class') AS rel,
        gp_dist_random('diskquota.rejectmap') AS be
   WHERE rel.relfilenode=be.relnode AND be.relnode<>0 AND rel.gp_segment_id=be.segid;
-  relname   | target_type | owner_matched
-------------+-------------+---------------
- blocked_t1 | ROLE_QUOTA  | t
-(1 row)
+  relname   |   target_type   | owner_matched
+------------+-----------------+---------------
+ a          | NAMESPACE_QUOTA | f
+ a          | NAMESPACE_QUOTA | f
+ blocked_t1 | ROLE_QUOTA      | t
+(3 rows)

 -- Create a tablespace to test the rest of blocking types.
 \! mkdir -p /tmp/blocked_space
@@ -133,8 +137,10 @@
   WHERE rel.relfilenode=be.relnode AND be.relnode<>0 AND rel.gp_segment_id=be.segid;
   relname   |        target_type         | namespace_matched | tablespace_matched
 ------------+----------------------------+-------------------+--------------------
+ a          | NAMESPACE_QUOTA            | t                 | t
+ a          | NAMESPACE_QUOTA            | t                 | t
  blocked_t1 | NAMESPACE_TABLESPACE_QUOTA | t                 | t
-(1 row)
+(3 rows)

 -- Insert an entry for blocked_t1 to rejectmap on seg0.
 SELECT block_relation_on_seg0('blocked_t1'::regclass, 'ROLE_TABLESPACE'::text);
@@ -152,8 +158,10 @@
   WHERE rel.relfilenode=be.relnode AND be.relnode<>0 AND rel.gp_segment_id=be.segid;
   relname   |      target_type      | owner_matched | tablespace_matched
 ------------+-----------------------+---------------+--------------------
+ a          | NAMESPACE_QUOTA       | f             | t
+ a          | NAMESPACE_QUOTA       | f             | t
  blocked_t1 | ROLE_TABLESPACE_QUOTA | t             | t
-(1 row)
+(3 rows)

 --
 -- 2. Test that the relfilenodes of toast relation together with its
@@ -176,13 +184,14 @@
        gp_dist_random('diskquota.rejectmap') AS be
   WHERE rel.relfilenode=be.relnode AND be.relnode<>0 AND rel.gp_segment_id=be.segid
   ORDER BY rel.relname DESC;
- replace_oid_with_relname  | relkind |   target_type   | namespace_matched
----------------------------+---------+-----------------+-------------------
- blocked_t2                | r       | NAMESPACE_QUOTA | t
- pg_toast_blocked_t2       | t       | NAMESPACE_QUOTA | f
- pg_toast_blocked_t2_index | i       | NAMESPACE_QUOTA | f
-(3 rows)
-
+ERROR:  invalid input syntax for type oid: ""
+DETAIL:  SQL statement "SELECT COALESCE(
+      REGEXP_REPLACE(given_name,
+         '^(pg_toast_|pg_aoseg_|pg_aovisimap_|pg_aoblkdir_|pg_aocsseg_)\d+',
+         '\1' ||
+        (SELECT relname FROM pg_class
+          WHERE oid=REGEXP_REPLACE(given_name, '\D', '', 'g')::oid), 'g'), given_name)"
+PL/pgSQL function replace_oid_with_relname(text) line 3 at RETURN
 --
 -- 3. Test that the relfilenodes of appendonly relation (row oriented) together with its
 --    auxiliary relations are blocked on seg0.
@@ -205,16 +214,14 @@
        gp_dist_random('diskquota.rejectmap') AS be
   WHERE rel.relfilenode=be.relnode AND be.relnode<>0 AND rel.gp_segment_id=be.segid
   ORDER BY rel.relname DESC;
-   replace_oid_with_relname    | relkind |   target_type   | namespace_matched
--------------------------------+---------+-----------------+-------------------
- blocked_t3                    | r       | NAMESPACE_QUOTA | t
- pg_aoblkdir_blocked_t3        | b       | NAMESPACE_QUOTA | f
- pg_aoblkdir_blocked_t3_index  | i       | NAMESPACE_QUOTA | f
- pg_aoseg_blocked_t3           | o       | NAMESPACE_QUOTA | f
- pg_aovisimap_blocked_t3       | M       | NAMESPACE_QUOTA | f
- pg_aovisimap_blocked_t3_index | i       | NAMESPACE_QUOTA | f
-(6 rows)
-
+ERROR:  invalid input syntax for type oid: ""
+DETAIL:  SQL statement "SELECT COALESCE(
+      REGEXP_REPLACE(given_name,
+         '^(pg_toast_|pg_aoseg_|pg_aovisimap_|pg_aoblkdir_|pg_aocsseg_)\d+',
+         '\1' ||
+        (SELECT relname FROM pg_class
+          WHERE oid=REGEXP_REPLACE(given_name, '\D', '', 'g')::oid), 'g'), given_name)"
+PL/pgSQL function replace_oid_with_relname(text) line 3 at RETURN
 --
 -- 4. Test that the relfilenodes of appendonly relation (column oriented) together with its
 --    auxiliary relations are blocked on seg0.
@@ -237,16 +244,14 @@
        gp_dist_random('diskquota.rejectmap') AS be
   WHERE rel.relfilenode=be.relnode AND be.relnode<>0 AND rel.gp_segment_id=be.segid
   ORDER BY rel.relname DESC;
-   replace_oid_with_relname    | relkind |   target_type   | namespace_matched
--------------------------------+---------+-----------------+-------------------
- blocked_t4                    | r       | NAMESPACE_QUOTA | t
- pg_aoblkdir_blocked_t4        | b       | NAMESPACE_QUOTA | f
- pg_aoblkdir_blocked_t4_index  | i       | NAMESPACE_QUOTA | f
- pg_aocsseg_blocked_t4         | o       | NAMESPACE_QUOTA | f
- pg_aovisimap_blocked_t4       | M       | NAMESPACE_QUOTA | f
- pg_aovisimap_blocked_t4_index | i       | NAMESPACE_QUOTA | f
-(6 rows)
-
+ERROR:  invalid input syntax for type oid: ""
+DETAIL:  SQL statement "SELECT COALESCE(
+      REGEXP_REPLACE(given_name,
+         '^(pg_toast_|pg_aoseg_|pg_aovisimap_|pg_aoblkdir_|pg_aocsseg_)\d+',
+         '\1' ||
+        (SELECT relname FROM pg_class
+          WHERE oid=REGEXP_REPLACE(given_name, '\D', '', 'g')::oid), 'g'), given_name)"
+PL/pgSQL function replace_oid_with_relname(text) line 3 at RETURN
 --
 -- 5. Test that the relfilenodes of toast appendonly relation (row oriented) together with its
 --    auxiliary relations are blocked on seg0.
@@ -269,18 +274,14 @@
        gp_dist_random('diskquota.rejectmap') AS be
   WHERE rel.relfilenode=be.relnode AND be.relnode<>0 AND rel.gp_segment_id=be.segid
   ORDER BY rel.relname DESC;
-   replace_oid_with_relname    | relkind |   target_type   | namespace_matched
--------------------------------+---------+-----------------+-------------------
- blocked_t5                    | r       | NAMESPACE_QUOTA | t
- pg_aoblkdir_blocked_t5        | b       | NAMESPACE_QUOTA | f
- pg_aoblkdir_blocked_t5_index  | i       | NAMESPACE_QUOTA | f
- pg_aocsseg_blocked_t5         | o       | NAMESPACE_QUOTA | f
- pg_aovisimap_blocked_t5       | M       | NAMESPACE_QUOTA | f
- pg_aovisimap_blocked_t5_index | i       | NAMESPACE_QUOTA | f
- pg_toast_blocked_t5           | t       | NAMESPACE_QUOTA | f
- pg_toast_blocked_t5_index     | i       | NAMESPACE_QUOTA | f
-(8 rows)
-
+ERROR:  invalid input syntax for type oid: ""
+DETAIL:  SQL statement "SELECT COALESCE(
+      REGEXP_REPLACE(given_name,
+         '^(pg_toast_|pg_aoseg_|pg_aovisimap_|pg_aoblkdir_|pg_aocsseg_)\d+',
+         '\1' ||
+        (SELECT relname FROM pg_class
+          WHERE oid=REGEXP_REPLACE(given_name, '\D', '', 'g')::oid), 'g'), given_name)"
+PL/pgSQL function replace_oid_with_relname(text) line 3 at RETURN
 -- Do some clean-ups.
 DROP FUNCTION replace_oid_with_relname(text);
 DROP FUNCTION block_relation_on_seg0(regclass, text);

======================================================================

from diskquota.

kishenkoilya commented on August 10, 2024

Figured it out. Mirrors are needed too for tests. So to summarize for installcheck one needs: gpdb source code built and installed, cluster with minimum 3 segments, with mirroring.

from diskquota.

Unit, regress tests completion about diskquota HOT 8 CLOSED

Comments (8)

Related Issues (20)

Recommend Projects

React

Vue.js

Typescript

TensorFlow

Django

Laravel

D3

Recommend Topics

javascript

web

server

Machine learning

Visualization

Game

Recommend Org

Facebook

Microsoft

Google

Alibaba

D3

Tencent