Jesse and Venky, can you guys help? Seems like some build environment issue.
Thanks, Shin On Wed, Jun 29, 2016 at 8:42 PM, 陶征霖 <[email protected]> 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 <[email protected]>: > >> CC-ing gporca developer. >> >> 2016-06-16 10:20 GMT+08:00 Twelfth Man <[email protected]>: >> >> > 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
