hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lei Chang <lei_ch...@apache.org>
Subject Re: Error when run simple query
Date Wed, 17 Feb 2016 00:50:33 GMT
looks there are 3 segments down. you can see the segment status by running:

select * from gp_segment_configuration.

And you can check further segment log on why segments are down.

Thanks
Lei



On Wed, Feb 17, 2016 at 12:09 AM, wormwang <wormwang@yahoo.com.invalid>
wrote:

> attached all log file gz.
>
>
> On 2016/2/16 22:59, wormwang wrote:
>
>> Hadoop , Hortonworks HDP 2.3.x, Redhat RHEL 6.x, HAWQ compiled from github
>>
>> Error log snap:
>>
>> CST,44433,con22,cmd10,seg-10000,,,x44433,sx1,"LOG","00000","AsyncComm
>> framework receives message 2307 from FD 40",,,,,,"select * from test limit
>> 10;",0,,"rmcomm_Message.c",100,
>> 2016-02-16 17:23:19.696819
>> CST,"gpadmin","gpadmin",p198524,th1219315936,"[local]",,2016-02-16 17:23:07
>> CST,44433,con22,cmd10,seg-10000,,,x44433,sx1,"ERROR","XX000","failed to
>> acquire resource from resource manager, 3 of 8 segments are unavailable
>> (pquery.c:806)",,,,,,"select * from test limit
>> 10;",0,,"pquery.c",806,"Stack trace:
>> 1    0x8759f2 postgres errstart (??:0)
>> 2    0x7b33af postgres AllocateResource (??:0)
>> 3    0x9ad86f postgres calculate_planner_segment_num (??:0)
>> 4    0x728721 postgres planner (??:0)
>> 5    0x7ac63e postgres pg_plan_queries (??:0)
>> 6    0x7ad7c5 postgres <symbol not found> (postgres.c:0)
>> 7    0x7aef02 postgres PostgresMain (??:0)
>> 8    0x76528a postgres <symbol not found> (postmaster.c:0)
>> 9    0x766fb6 postgres PostmasterMain (??:0)
>> 10   0x6c088a postgres main (??:0)
>> 11   0x3bd481ed1d libc.so.6 __libc_start_main (??:0)
>> 12   0x4a08e9 postgres <symbol not found> (??:0)
>> "
>>
>> all log is attached.
>>
>>
>>
>>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message