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 >
