You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hawq.apache.org by wormwang <wo...@yahoo.com.INVALID> on 2016/02/16 15:59:46 UTC
Error when run simple query
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.
Re: Error when run simple query
Posted by Lei Chang <le...@apache.org>.
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 <wo...@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.
>>
>>
>>
>>
>
Re: Error when run simple query
Posted by wormwang <wo...@yahoo.com.INVALID>.
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.
>
>
>