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 <[email protected]>
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)
