[
https://issues.apache.org/jira/browse/HAWQ-1433?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15975968#comment-15975968
]
Xiang Sheng commented on HAWQ-1433:
-----------------------------------
[~outofmemory]
Yes this is the reason why the resqueue ddl fails, but the real reason is that
the resqueueMgr allow percentage and value when checking format, but only
support percentage when update. So the ddl passed the format check but cannot
be executed right.
So, I remove the format checking part when it's not percentage. It won't pass
format check now and we will change the format checking and this update else
block when we support value in the resqueue ddl.
> ALTER RESOURCE QUEUE DDL does not check the format of attribute
> MEMORY_CLUSTER_LIMIT and CORE_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: Xiang Sheng
> Fix For: 2.3.0.0-incubating
>
>
> Shubham Sharma <topologicalqu...@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)
