hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yi Jin (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HAWQ-1433) ALTER RESOURCE QUEUE DDL does not check the format of attribute MEMORY_CLUSTER_LIMIT
Date Thu, 13 Apr 2017 06:39:41 GMT
Yi Jin created HAWQ-1433:
----------------------------

             Summary: ALTER RESOURCE QUEUE DDL does not check the format of attribute MEMORY_CLUSTER_LIMIT
                 Key: HAWQ-1433
                 URL: https://issues.apache.org/jira/browse/HAWQ-1433
             Project: Apache HAWQ
          Issue Type: Bug
          Components: Resource Manager
            Reporter: Yi Jin
            Assignee: Ed Espino
             Fix For: 2.3.0.0-incubating


Shubham Sharma <topologicalqubit@gmail.com>
2:11 PM (2 hours ago)

to user, sebastiao.gone. 
Hello Sebastio, I think you have encountered the following issue - 

1 - Problem -  alter resource queue pg_default with (CORE_LIMIT_CLUSTER/MEMORY_LIMIT_CLUSTER=90);

gpadmin=# select * from pg_resqueue;
  rsqname   | parentoid | activestats | memorylimit | corelimit | resovercommit | allocpolicy
| vsegresourcequota | nvsegupperlimit | nvseglowerlimit | nvseg
upperlimitperseg | nvseglowerlimitperseg | creationtime |          updatetime           |
status 
------------+-----------+-------------+-------------+-----------+---------------+-------------+-------------------+-----------------+-----------------+------
-----------------+-----------------------+--------------+-------------------------------+--------
 pg_root    |         0 |          -1 | 100%        | 100%      |             2 | even   
    |                   |               0 |               0 |      
               0 |                     0 |              |                               |
branch
 pg_default |      9800 |          20 | 50%         | 50%       |             2 | even   
    | mem:256mb         |               0 |               0 |      
               0 |                     0 |              | 2017-04-12 22:45:55.056102+01 |

(2 rows)

gpadmin=# alter resource queue pg_default with (CORE_LIMIT_CLUSTER=90);
ALTER QUEUE

gpadmin=# select * from test;
 a 
---
(0 rows)
gpadmin=# \q

2 - restart hawq cluster

3 - ERROR

[gpadmin@hdp3 ~]$ psql
psql (8.2.15)
Type "help" for help.
gpadmin=# select * from test;
WARNING:  FD 31 having errors raised. errno 104
ERROR:  failed to register in resource manager, failed to receive content (pquery.c:787)

3 - alter resource queue pg_default with (CORE_LIMIT_CLUSTER/MEMORY_LIMIT_CLUSTER=50%); --Let's
switch back
! Not allowed !
alter resource queue pg_default with (CORE_LIMIT_CLUSTER=50%);
WARNING:  FD 33 having errors raised. errno 104
ERROR:  failed to register in resource manager, failed to receive content (resqueuecommand.c:364)

4 -  How to fix - Please be extra careful while using this.
gpadmin=# begin;
BEGIN
gpadmin=# set allow_system_table_mods='dml';
SET
gpadmin=# select * from pg_resqueue where corelimit=90;
  rsqname   | parentoid | activestats | memorylimit | corelimit | resovercommit | allocpolicy
| vsegresourcequota | nvsegupperlimit | nvseglowerlimit | nvseg
upperlimitperseg | nvseglowerlimitperseg | creationtime |          updatetime           |
status 
------------+-----------+-------------+-------------+-----------+---------------+-------------+-------------------+-----------------+-----------------+------
-----------------+-----------------------+--------------+-------------------------------+--------
 pg_default |      9800 |          20 | 50%         | 90        |             2 | even   
    | mem:256mb         |               0 |               0 |      
               0 |                     0 |              | 2017-04-12 22:59:30.092823+01 |

(1 row)
gpadmin=# update pg_resqueue set corelimit='50%' where corelimit=90;
UPDATE 1
gpadmin=# commit;
COMMIT

5 - System should be back to normal

gpadmin=# select * from test;
 a 
---
(0 rows)


Regards,
Shubh




--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message