You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Lei Chang (JIRA)" <ji...@apache.org> on 2016/01/06 10:17:39 UTC
[jira] [Commented] (HAWQ-323) Cannot query when cluster include
more than 1 segment
[ https://issues.apache.org/jira/browse/HAWQ-323?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15085273#comment-15085273 ]
Lei Chang commented on HAWQ-323:
--------------------------------
Looks there are a lot of segments down.
1. can you paste the results of this table: select * from gp_segment_configuration;
2. uploading your segment log and master log will be helpful for debugging.
3. use "ps -eaf | grep postgres" on failed nodes to see whether segment is still alive.
4. please also check you network works from segment to master.
> Cannot query when cluster include more than 1 segment
> -----------------------------------------------------
>
> Key: HAWQ-323
> URL: https://issues.apache.org/jira/browse/HAWQ-323
> Project: Apache HAWQ
> Issue Type: Bug
> Components: Core, Resource Manager
> Affects Versions: 2.0.0-beta-incubating
> Reporter: zharui
> Assignee: Lei Chang
>
> The version I use is 2.0.0-beta-RC2. I can query data normally when cluster just have 1 segment. Once the cluster have more then 1 segments online, I cannot finish any query and being informed that "ERROR: failed to acquire resource from resource manager, 7 of 8 segments are unavailable (pquery.c:788)".
> I have read the segment logs and the source code about resource manager. I guess this issue is because of the communication failure between segment instance and resource manager server. I can find the logs of the segment connect to resource manager successfully such as "AsyncComm framework receives message 518 from FD5" and "Resource enforcer increases memory quota to: total memory quota=65536 MB, delta memory quota = 65536 MB", but the other online segments have no these log.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)