You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hawq.apache.org by Twelfth Man <be...@gmail.com> on 2016/06/16 02:20:26 UTC
HAWQ + ORCA cause core dump
Hello HAWQ community,
We have no problem to build and deploy a local hawq instance for
experiment. But we have no luck to make ORCA work. I wonder any one here
had similar experience before and like to share.
What we see:
create a test table T;
insert some data into table T;
select count(*) from T;
it works with no any problem.
set optimizer=on;
select count(*) from T;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
on the server side, we found the following stack trace from master server
log under pg_log/
2016-06-03 02:37:36.993438 CST,,,p26361,th0,,,2016-06-03 02:37:36
CST,0,con19,cmd1,seg-10000,,,,,"PANIC","XX000","Unexpected internal error:
Master process received signal SIGSEGV",,,,,,,0,,,,"1 0x95daf1 postgres
<symbol not found> + 0x95daf1
2 0x95dcfd postgres StandardHandlerForSigillSigsegvSigbus_OnMainThread +
0x2b
3 0x879c4f postgres CdbProgramErrorHandler + 0xf4
4 0x7f1950045be0 libpthread.so.0 <symbol not found> + 0x50045be0
5 0x7f194bf3a9a0 libnaucrates.so.3 InitDXL + 0x40
6 0x7f19502f64ed libdxltranslators.so _ZN9COptTasks7ExecuteEPFPvS0_ES0_
+ 0x3d
7 0x7f19502f7a56 libdxltranslators.so
_ZN9COptTasks15PplstmtOptimizeEP5QueryPb + 0x36
8 0x7df4df postgres <symbol not found> + 0x7df4df
9 0x7df8dc postgres planner + 0x3cb
10 0x875958 postgres pg_plan_query + 0x51
11 0x875a63 postgres pg_plan_queries + 0x8e
12 0x876efb postgres <symbol not found> + 0x876efb
The 12th Man
Re: HAWQ + ORCA cause core dump
Posted by Xin Zhang <xz...@pivotal.io>.
Jesse and Venky, can you guys help?
Seems like some build environment issue.
Thanks,
Shin
On Wed, Jun 29, 2016 at 8:42 PM, 陶征霖 <zt...@apache.org> wrote:
> If you have already enabled core dump, you can check the core file to
> debug.
>
> 2016-06-30 11:17 GMT+08:00 Guo Gang <pa...@gmail.com>:
>
>> CC-ing gporca developer.
>>
>> 2016-06-16 10:20 GMT+08:00 Twelfth Man <be...@gmail.com>:
>>
>> > Hello HAWQ community,
>> >
>> > We have no problem to build and deploy a local hawq instance for
>> > experiment. But we have no luck to make ORCA work. I wonder any one
>> here
>> > had similar experience before and like to share.
>> >
>> > What we see:
>> >
>> > create a test table T;
>> > insert some data into table T;
>> >
>> > select count(*) from T;
>> >
>> > it works with no any problem.
>> >
>> > set optimizer=on;
>> > select count(*) from T;
>> >
>> > server closed the connection unexpectedly
>> > This probably means the server terminated abnormally
>> > before or while processing the request.
>> >
>> > on the server side, we found the following stack trace from master
>> server
>> > log under pg_log/
>> >
>> > 2016-06-03 02:37:36.993438 CST,,,p26361,th0,,,2016-06-03 02:37:36
>> > CST,0,con19,cmd1,seg-10000,,,,,"PANIC","XX000","Unexpected internal
>> error:
>> > Master process received signal SIGSEGV",,,,,,,0,,,,"1 0x95daf1
>> postgres
>> > <symbol not found> + 0x95daf1
>> > 2 0x95dcfd postgres
>> StandardHandlerForSigillSigsegvSigbus_OnMainThread +
>> > 0x2b
>> > 3 0x879c4f postgres CdbProgramErrorHandler + 0xf4
>> > 4 0x7f1950045be0 libpthread.so.0 <symbol not found> + 0x50045be0
>> > 5 0x7f194bf3a9a0 libnaucrates.so.3 InitDXL + 0x40
>> > 6 0x7f19502f64ed libdxltranslators.so
>> _ZN9COptTasks7ExecuteEPFPvS0_ES0_
>> > + 0x3d
>> > 7 0x7f19502f7a56 libdxltranslators.so
>> > _ZN9COptTasks15PplstmtOptimizeEP5QueryPb + 0x36
>> > 8 0x7df4df postgres <symbol not found> + 0x7df4df
>> > 9 0x7df8dc postgres planner + 0x3cb
>> > 10 0x875958 postgres pg_plan_query + 0x51
>> > 11 0x875a63 postgres pg_plan_queries + 0x8e
>> > 12 0x876efb postgres <symbol not found> + 0x876efb
>> >
>> > The 12th Man
>> >
>>
>
>
--
SHIN
Re: HAWQ + ORCA cause core dump
Posted by 陶征霖 <zt...@apache.org>.
If you have already enabled core dump, you can check the core file to debug.
2016-06-30 11:17 GMT+08:00 Guo Gang <pa...@gmail.com>:
> CC-ing gporca developer.
>
> 2016-06-16 10:20 GMT+08:00 Twelfth Man <be...@gmail.com>:
>
> > Hello HAWQ community,
> >
> > We have no problem to build and deploy a local hawq instance for
> > experiment. But we have no luck to make ORCA work. I wonder any one here
> > had similar experience before and like to share.
> >
> > What we see:
> >
> > create a test table T;
> > insert some data into table T;
> >
> > select count(*) from T;
> >
> > it works with no any problem.
> >
> > set optimizer=on;
> > select count(*) from T;
> >
> > server closed the connection unexpectedly
> > This probably means the server terminated abnormally
> > before or while processing the request.
> >
> > on the server side, we found the following stack trace from master server
> > log under pg_log/
> >
> > 2016-06-03 02:37:36.993438 CST,,,p26361,th0,,,2016-06-03 02:37:36
> > CST,0,con19,cmd1,seg-10000,,,,,"PANIC","XX000","Unexpected internal
> error:
> > Master process received signal SIGSEGV",,,,,,,0,,,,"1 0x95daf1
> postgres
> > <symbol not found> + 0x95daf1
> > 2 0x95dcfd postgres
> StandardHandlerForSigillSigsegvSigbus_OnMainThread +
> > 0x2b
> > 3 0x879c4f postgres CdbProgramErrorHandler + 0xf4
> > 4 0x7f1950045be0 libpthread.so.0 <symbol not found> + 0x50045be0
> > 5 0x7f194bf3a9a0 libnaucrates.so.3 InitDXL + 0x40
> > 6 0x7f19502f64ed libdxltranslators.so
> _ZN9COptTasks7ExecuteEPFPvS0_ES0_
> > + 0x3d
> > 7 0x7f19502f7a56 libdxltranslators.so
> > _ZN9COptTasks15PplstmtOptimizeEP5QueryPb + 0x36
> > 8 0x7df4df postgres <symbol not found> + 0x7df4df
> > 9 0x7df8dc postgres planner + 0x3cb
> > 10 0x875958 postgres pg_plan_query + 0x51
> > 11 0x875a63 postgres pg_plan_queries + 0x8e
> > 12 0x876efb postgres <symbol not found> + 0x876efb
> >
> > The 12th Man
> >
>
Re: HAWQ + ORCA cause core dump
Posted by 陶征霖 <zt...@apache.org>.
If you have already enabled core dump, you can check the core file to debug.
2016-06-30 11:17 GMT+08:00 Guo Gang <pa...@gmail.com>:
> CC-ing gporca developer.
>
> 2016-06-16 10:20 GMT+08:00 Twelfth Man <be...@gmail.com>:
>
> > Hello HAWQ community,
> >
> > We have no problem to build and deploy a local hawq instance for
> > experiment. But we have no luck to make ORCA work. I wonder any one here
> > had similar experience before and like to share.
> >
> > What we see:
> >
> > create a test table T;
> > insert some data into table T;
> >
> > select count(*) from T;
> >
> > it works with no any problem.
> >
> > set optimizer=on;
> > select count(*) from T;
> >
> > server closed the connection unexpectedly
> > This probably means the server terminated abnormally
> > before or while processing the request.
> >
> > on the server side, we found the following stack trace from master server
> > log under pg_log/
> >
> > 2016-06-03 02:37:36.993438 CST,,,p26361,th0,,,2016-06-03 02:37:36
> > CST,0,con19,cmd1,seg-10000,,,,,"PANIC","XX000","Unexpected internal
> error:
> > Master process received signal SIGSEGV",,,,,,,0,,,,"1 0x95daf1
> postgres
> > <symbol not found> + 0x95daf1
> > 2 0x95dcfd postgres
> StandardHandlerForSigillSigsegvSigbus_OnMainThread +
> > 0x2b
> > 3 0x879c4f postgres CdbProgramErrorHandler + 0xf4
> > 4 0x7f1950045be0 libpthread.so.0 <symbol not found> + 0x50045be0
> > 5 0x7f194bf3a9a0 libnaucrates.so.3 InitDXL + 0x40
> > 6 0x7f19502f64ed libdxltranslators.so
> _ZN9COptTasks7ExecuteEPFPvS0_ES0_
> > + 0x3d
> > 7 0x7f19502f7a56 libdxltranslators.so
> > _ZN9COptTasks15PplstmtOptimizeEP5QueryPb + 0x36
> > 8 0x7df4df postgres <symbol not found> + 0x7df4df
> > 9 0x7df8dc postgres planner + 0x3cb
> > 10 0x875958 postgres pg_plan_query + 0x51
> > 11 0x875a63 postgres pg_plan_queries + 0x8e
> > 12 0x876efb postgres <symbol not found> + 0x876efb
> >
> > The 12th Man
> >
>
Re: HAWQ + ORCA cause core dump
Posted by Guo Gang <pa...@gmail.com>.
CC-ing gporca developer.
2016-06-16 10:20 GMT+08:00 Twelfth Man <be...@gmail.com>:
> Hello HAWQ community,
>
> We have no problem to build and deploy a local hawq instance for
> experiment. But we have no luck to make ORCA work. I wonder any one here
> had similar experience before and like to share.
>
> What we see:
>
> create a test table T;
> insert some data into table T;
>
> select count(*) from T;
>
> it works with no any problem.
>
> set optimizer=on;
> select count(*) from T;
>
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
>
> on the server side, we found the following stack trace from master server
> log under pg_log/
>
> 2016-06-03 02:37:36.993438 CST,,,p26361,th0,,,2016-06-03 02:37:36
> CST,0,con19,cmd1,seg-10000,,,,,"PANIC","XX000","Unexpected internal error:
> Master process received signal SIGSEGV",,,,,,,0,,,,"1 0x95daf1 postgres
> <symbol not found> + 0x95daf1
> 2 0x95dcfd postgres StandardHandlerForSigillSigsegvSigbus_OnMainThread +
> 0x2b
> 3 0x879c4f postgres CdbProgramErrorHandler + 0xf4
> 4 0x7f1950045be0 libpthread.so.0 <symbol not found> + 0x50045be0
> 5 0x7f194bf3a9a0 libnaucrates.so.3 InitDXL + 0x40
> 6 0x7f19502f64ed libdxltranslators.so _ZN9COptTasks7ExecuteEPFPvS0_ES0_
> + 0x3d
> 7 0x7f19502f7a56 libdxltranslators.so
> _ZN9COptTasks15PplstmtOptimizeEP5QueryPb + 0x36
> 8 0x7df4df postgres <symbol not found> + 0x7df4df
> 9 0x7df8dc postgres planner + 0x3cb
> 10 0x875958 postgres pg_plan_query + 0x51
> 11 0x875a63 postgres pg_plan_queries + 0x8e
> 12 0x876efb postgres <symbol not found> + 0x876efb
>
> The 12th Man
>