[ https://issues.apache.org/jira/browse/HAWQ-1615?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Lin Wen reassigned HAWQ-1615: ----------------------------- Assignee: Lin Wen (was: Lei Chang) > Access Invalid Memory When Run a Hash-join query with Bloomfilter Enable. > ------------------------------------------------------------------------- > > Key: HAWQ-1615 > URL: https://issues.apache.org/jira/browse/HAWQ-1615 > Project: Apache HAWQ > Issue Type: Bug > Components: Query Execution > Reporter: Lin Wen > Assignee: Lin Wen > Priority: Major > Fix For: 2.4.0.0-incubating > > > How to reproduce: > 1. set hawq_hashjoin_bloomfilter=true; > 2. run a query on TPCH database(1 master and 3 segments): select count(*) > from part, lineitem where p_partkey = l_partkey and p_brand = 'Brand#23' and > p_container = 'MED BOX'; > The QE process accessed invalid memory. > 2018-05-16 06:27:40.010566 GMT,,,p567902,th0,,,2018-05-16 06:26:43 > GMT,0,con21,cmd5,seg1,slice2,,,,"PANIC","XX000","Unexpected internal error: > Segment process received signal SIGSEGV",,,,,,,0,,,,"1 0x969adb postgres > <symbol not found> + 0x969adb > 2 0x969ce4 postgres StandardHandlerForSigillSigsegvSigbus_OnMainThread + > 0x2b > 3 0x88540b postgres CdbProgramErrorHandler + 0xf1 > 4 0x7ff663359370 libpthread.so.0 <symbol not found> + 0x63359370 > 5 0x7221ff postgres ExecEndTableScan + 0x2f > 6 0x6e5864 postgres ExecEndNode + 0x2b1 > 7 0x70cffb postgres ExecEndHashJoin + 0xdb > 8 0x6e5963 postgres ExecEndNode + 0x3b0 > 9 0x704455 postgres ExecEndAgg + 0x104 > 10 0x6e59a7 postgres ExecEndNode + 0x3f4 > 11 0x71613d postgres ExecEndMotion + 0x87 > 12 0x6e5a0d postgres ExecEndNode + 0x45a > 13 0x704455 postgres ExecEndAgg + 0x104 > 14 0x6e59a7 postgres ExecEndNode + 0x3f4 > 15 0x6de6a5 postgres ExecEndPlan + 0x4b > 16 0x6dc139 postgres ExecutorEnd + 0x2fc -- This message was sent by Atlassian JIRA (v7.6.3#76005)