\u5ba2\u6237\u6570\u636e\u5e93\u51fa\u73b0ORA-600(19004)\u9519\u8bef\u3002
\n\u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n
ORA-00600: internal error code, arguments: [19004], [], [], [], [], [], [], []<\/pre>\n\u5bf9\u5e94\u7684\u8be6\u7ec6TRACE\u4e3a\uff1a<\/p>\n
*** 2012-03-15 13:10:31.283\r\nksedmp: internal or fatal error\r\nORA-00600: internal error code, arguments: [19004], [], [], [], [], [], [], []\r\nCurrent SQL statement for this session:\r\nselect distinct loc.id as col_0_0_, temp2_.id as col_1_0_, bloc.routeIndex as col_2_0_, loc.id as id32_, loc.createdTime as createdT2_32_, loc.CREATOR_ID as CREATOR3_32_, loc.DOMAIN_ID as DOMAIN4_32_, loc.lockVersion as lockVers5_32_, loc.reMark as reMark32_, loc.status_id as status85_32_, loc.udf1 as udf7_32_, loc.udf2 as udf8_32_, loc.udf3 as udf9_32_, loc.udf4 as udf10_32_, loc.udf5 as udf11_32_, loc.udf6 as udf12_32_, loc.udf7 as udf13_32_, loc.udf8 as udf14_32_, loc.updatedTime as updated15_32_, loc.UPDATOR_ID as UPDATOR16_32_, loc.fixCreatedTime as fixCrea17_32_, loc.fixCreatedTimeForDisp as fixCrea18_32_, loc.fixExpiredTime as fixExpi19_32_, loc.fixExpiredTimeForDisp as fixExpi20_32_, loc.fixStatus_id as fixStatus87_32_, loc.fixStatusForDisp as fixStat21_32_, loc.lotAtt01 as lotAtt22_32_, loc.lotAtt01ForDisp as lotAtt23_32_, loc.lotAtt02 as lotAtt24_32_, loc.lotAtt02ForDisp as lotAtt25_32_, loc.lotAtt03 as lotAtt26_32_, loc.lotAtt03ForDisp as lotAtt27_32_, loc.lotAtt04 as lotAtt28_32_, loc.lotAtt04ForDisp as lotAtt29_32_, loc.lotAtt05 as lotAtt30_32_, loc.lotAtt05ForDisp as lotAtt31_32_, loc.lotAtt06 as lotAtt32_32_, loc.lotAtt06ForDisp as lotAtt33_32_, loc.lotAtt07 as lotAtt34_32_, loc.lotAtt07ForDisp as lotAtt35_32_, loc.lotAtt08 as lotAtt36_32_, loc.lotAtt08ForDisp as lotAtt37_32_, loc.lotAtt09 as lotAtt38_32_, loc.lotAtt09ForDisp as lotAtt39_32_, loc.lotAtt10 as lotAtt40_32_, loc.lotAtt10ForDisp as lotAtt41_32_, loc.lotAtt11 as lotAtt42_32_, loc.lotAtt11ForDisp as lotAtt43_32_, loc.lotAtt12 as lotAtt44_32_, loc.lotAtt12ForDisp as lotAtt45_32_, loc.lotHeader_id as lotHeader89_32_, loc.asnTraceId as asnTraceId32_, loc.cubicEach as cubicEach32_, loc.cubicUom as cubicUom32_, loc.customer_id as customer86_32_, loc.grossWeightEach as grossWe49_32_, loc.grossWeightUom as grossWe50_32_, loc.inboundTime as inbound51_32_, loc.location_id as location83_32_, loc.manufacturer_id as manufac88_32_, loc.netWeightEach as netWeig52_32_, loc.netWeightUom as netWeig53_32_, loc.org_id as org82_32_, loc.packCode as packCode32_, loc.priceEach as priceEach32_, loc.priceUom as priceUom32_, loc.qtyAllocatedEach as qtyAllo57_32_, loc.qtyAllocatedUom as qtyAllo58_32_, loc.qtyConfirmEach as qtyConf59_32_, loc.qtyConfirmUom as qtyConf60_32_, loc.qtyEach as qtyEach32_, loc.qtyHold4PaEach as qtyHold62_32_, loc.qtyHold4PaUom as qtyHold63_32_, loc.qtyLendEach as qtyLend64_32_, loc.qtyLendUom as qtyLendUom32_, loc.qtyLockEach as qtyLock66_32_, loc.qtyLockUom as qtyLockUom32_, loc.qtyMendEach as qtyMend68_32_, loc.qtyMendUom as qtyMendUom32_, loc.qtyOnHoldEach as qtyOnHo70_32_, loc.qtyOnHoldUom as qtyOnHo71_32_, loc.qtyPickedEach as qtyPick72_32_, loc.qtyPickedUom as qtyPick73_32_, loc.qtyTempEach as qtyTemp74_32_, loc.qtyTempUom as qtyTempUom32_, loc.qtyUom as qtyUom32_, loc.qtyUseEach as qtyUseEach32_, loc.qtyUseUom as qtyUseUom32_, loc.sku_id as sku84_32_, loc.traceCode as traceCode32_, loc.uom_id as uom80_32_, loc.warehouse_id as warehouse81_32_ from LOC loc, BLOC bloc, OD od, TEMP temp2_ where loc.location_id=bloc.id and od.id=temp2_.id and loc.lotHeader_id=od.lotHeader_id and (od.fixCreatedTime is null or od.fixCreatedTime=loc.fixCreatedTime) and (od.fixExpiredTime is null or od.fixExpiredTime=loc.fixExpiredTime) and (od.fixStatus_id is null or od.fixStatus_id=loc.fixStatus_id) and (od.lotAtt01 is null or od.lotAtt01=loc.lotAtt01) and (od.lotAtt02 is null or od.lotAtt02=loc.lotAtt02) and (od.lotAtt03 is null or od.lotAtt03=loc.lotAtt03) and (od.lotAtt04 is null or od.lotAtt04=loc.lotAtt04) and (od.lotAtt05 is null or od.lotAtt05=loc.lotAtt05) and (od.lotAtt06 is null or od.lotAtt06=loc.lotAtt06) and (od.lotAtt07 is null or od.lotAtt07=loc.lotAtt07) and (od.lotAtt08 is null or od.lotAtt08=loc.lotAtt08) and (od.lotAtt09 is null or od.lotAtt09=loc.lotAtt09) and (od.lotAtt10 is null or od.lotAtt10=loc.lotAtt10) and (od.lotAtt11 is null or od.lotAtt11=loc.lotAtt11) and (od.lotAtt12 is null or od.lotAtt12=loc.lotAtt12) and case when od.picLocation_id is null then loc.location_id else od.picLocation_id end=loc.location_id and od.sku_id=loc.sku_id and loc.uom_id=od.uom_id and loc.warehouse_id=od.wh_id and loc.customer_id=od.customer_id and loc.qtyUseUom>0 order by loc.qtyUseUom desc, bloc.routeIndex asc, loc.id asc\r\n----- Call Stack Trace -----\r\ncalling call entry argument values in hex \r\nlocation type point (? means dubious value) \r\n-------------------- -------- -------------------- ----------------------------\r\nksedst()+31 call ksedst1() 000000000 ? 000000001 ?\r\n 7FBFFF0300 ? 7FBFFF0360 ?\r\n 7FBFFF02A0 ? 000000000 ?\r\nksedmp()+610 call ksedst() 000000000 ? 000000001 ?\r\n 7FBFFF0300 ? 7FBFFF0360 ?\r\n 7FBFFF02A0 ? 000000000 ?\r\nksfdmp()+21 call ksedmp() 000000003 ? 000000001 ?\r\n 7FBFFF0300 ? 7FBFFF0360 ?\r\n 7FBFFF02A0 ? 000000000 ?\r\nkgeriv()+176 call ksfdmp() 000000003 ? 000000001 ?\r\n 7FBFFF0300 ? 7FBFFF0360 ?\r\n 7FBFFF02A0 ? 000000000 ?\r\nkgesiv()+119 call kgeriv() 0066876E0 ? 00673CEE0 ?\r\n 000000000 ? 000000000 ?\r\n 7FBFFF02A0 ? 000000000 ?\r\nksesic0()+209 call kgesiv() 0066876E0 ? 00673CEE0 ?\r\n 000004A3C ? 000000000 ?\r\n 7FBFFF1080 ? 000000000 ?\r\nkkejeq()+5152 call ksesic0() 000004A3C ? 2A97403DB0 ?\r\n 0000000CA ? 2A97403DB0 ?\r\n 000000002 ? 000000000 ?\r\nkkeEqJoinSel()+2602 call kkejeq() 2A973C2930 ? 2A97403DB0 ?\r\n 000000000 ? 2A97403DB0 ?\r\n 000000002 ? 000000000 ?\r\nkkepsl()+10561 call kkeEqJoinSel() 7FBFFF1BB0 ? 7FBFFF1BD0 ?\r\n 7FBFFF1BC0 ? 7FBFFF1BE0 ?\r\n 2A971E68F8 ? 2A00000002 ?\r\nkkeasl()+2125 call kkepsl() 2A971E68F8 ? 7FBFFF2438 ?\r\n 000000002 ? 2A971EFB30 ?\r\n 2A971E68F8 ? 2A00000002 ?\r\nkkeosl()+1447 call kkeasl() 2A971E6970 ? 7FBFFF3DB8 ?\r\n 000000002 ? 000000000 ?\r\n 000000000 ? 2A971EFB30 ?\r\nkkejcd()+1466 call kkeosl() 2A971E6BF0 ? 7FBFFF4010 ?\r\n 000000002 ? 000000000 ?\r\n 000000000 ? 2A971EFB30 ?\r\nkkojnp()+3920 call kkejcd() 2A973CF670 ? 2A973D3628 ?\r\n 2A974407E8 ? 000000016 ?\r\n 2A973D5008 ? 000000003 ?\r\nkkocnp()+166 call kkojnp() 2A973D5008 ? 000000000 ?\r\n 2A974407E8 ? 000000016 ?\r\n 2A973D5008 ? 000000000 ?\r\nkkooqb()+2258 call kkocnp() 2A973D5008 ? 000000001 ?\r\n 2A974407E8 ? 000000016 ?\r\n 2A973D5008 ? 000000000 ?\r\nkkoqbc()+2083 call kkooqb() 000000000 ? 000000001 ?\r\n 0000007D0 ? 000000004 ?\r\n 2A00000000 ? 2A00000006 ?\r\napakkoqb()+170 call kkoqbc() 7FBFFF7D80 ? 2A97393428 ?\r\n 0000007D0 ? 000000001 ?\r\n 2A00000000 ? 000000000 ?\r\napaqbdDescendents() call apakkoqb() 7FBFFF7D80 ? 2A97393428 ?\r\n+399 1D23E4740 ? 000000001 ?\r\n 2A00000000 ? 000000000 ?\r\napaqbdListReverse() call apaqbdDescendents() 7FBFFF7D80 ? 2A97393428 ?\r\n+68 1D23E4740 ? 000000001 ?\r\n 2A00000000 ? 000000000 ?\r\napadrv()+586 call apaqbdListReverse() 7FBFFF7D80 ? 2A97393428 ?\r\n 1D23E4740 ? 000000001 ?\r\n 2A00000000 ? 000000000 ?\r\nopitca()+1512 call apadrv() 1D23E4740 ? 2A97393428 ?\r\n 1D23E4740 ? 000000001 ?\r\n 2A00000000 ? 000000000 ?\r\nkksFullTypeCheck()+ call opitca() 2A972335A8 ? 1D23E4740 ?\r\n30 1D23E4740 ? 000000001 ?\r\n 2A00000000 ? 000000000 ?\r\nrpiswu2()+420 call kksFullTypeCheck() 7FBFFF9328 ? 1D23E4740 ?\r\n 1D23E4740 ? 000000001 ?\r\n 2A00000000 ? 000000000 ?\r\nkksLoadChild()+9500 call rpiswu2() 1F736B950 ? 00000003A ?\r\n 1DFC84F24 ? 000000009 ?\r\n 1DFAD88E0 ? 10000003A ?\r\nkxsGetRuntimeLock() call kksLoadChild() 0066876E0 ? 1FAB8C5C0 ?\r\n+1353 7FBFFFA7C0 ? 000000000 ?\r\n 1DFC84DC0 ? 2A972335A8 ?\r\nkksfbc()+15084 call kxsGetRuntimeLock() 0066876E0 ? 2A972335A8 ?\r\n 7FBFFFA7C0 ? 000000000 ?\r\n 1DFC84DC0 ? 2A972335A8 ?\r\nkkspsc0()+1548 call kksfbc() 2A972335A8 ? 000000003 ?\r\n 000000108 ? 2A97203D18 ?\r\n 0000016A6 ? 000000000 ?\r\nkksParseCursor()+14 call kkspsc0() 2A97211788 ? 2A97203D18 ?\r\n2 0000016A6 ? 000000003 ?\r\n E77100A400000006 ?\r\n 1E77100A4 ?\r\nopiosq0()+1641 call kksParseCursor() 7FBFFFB208 ? 2A97203D18 ?\r\n 0000016A6 ? 000000003 ?\r\n E77100A400000006 ?\r\n 1E77100A4 ?\r\nkpooprx()+315 call opiosq0() 000000003 ? 00000000E ?\r\n 7FBFFFB3F8 ? 0000000A4 ?\r\n E77100A400000006 ?\r\n 1E77100A4 ?\r\nkpoal8()+799 call kpooprx() 7FBFFFE5A4 ? 2A97203D18 ?\r\n 0000016A5 ? 000000001 ?\r\n 000000000 ? 1E77100A4 ?\r\nopiodr()+984 call kpoal8() 00000005E ? 000000017 ?\r\n 7FBFFFE5A0 ? 000000001 ?\r\n 000000001 ? 1E77100A4 ?\r\nttcpip()+1012 call opiodr() 00000005E ? 000000017 ?\r\n 7FBFFFE5A0 ? 000000000 ?\r\n 0059B1310 ? 1E77100A4 ?\r\nopitsk()+1322 call ttcpip() 00668F3B0 ? 000000003 ?\r\n 7FBFFFE5A0 ? 000000000 ?\r\n 7FBFFFE098 ? 7FBFFFE708 ?\r\nopiino()+1026 call opitsk() 000000003 ? 000000000 ?\r\n 7FBFFFE5A0 ? 000000001 ?\r\n 000000000 ? 67502D200000001 ?\r\nopiodr()+984 call opiino() 00000003C ? 000000004 ?\r\n 7FBFFFF768 ? 000000000 ?\r\n 000000000 ? 67502D200000001 ?\r\nopidrv()+547 call opiodr() 00000003C ? 000000004 ?\r\n 7FBFFFF768 ? 000000000 ?\r\n 0059B0DC0 ? 67502D200000001 ?\r\nsou2o()+114 call opidrv() 00000003C ? 000000004 ?\r\n 7FBFFFF768 ? 000000000 ?\r\n 0059B0DC0 ? 67502D200000001 ?\r\nopimai_real()+163 call sou2o() 7FBFFFF740 ? 00000003C ?\r\n 000000004 ? 7FBFFFF768 ?\r\n 0059B0DC0 ? 67502D200000001 ?\r\nmain()+116 call opimai_real() 000000002 ? 7FBFFFF7D0 ?\r\n 000000004 ? 7FBFFFF768 ?\r\n 0059B0DC0 ? 67502D200000001 ?\r\n__libc_start_main() call main() 000000002 ? 7FBFFFF7D0 ?\r\n+219 000000004 ? 7FBFFFF768 ?\r\n 0059B0DC0 ? 67502D200000001 ?\r\n_start()+42 call __libc_start_main() 000713988 ? 000000002 ?\r\n 7FBFFFF918 ? 005288D70 ?\r\n 000000000 ? 000000002 ?\r\n--------------------- Binary Stack Dump ---------------------<\/pre>\n\u8fd9\u4e2aSQL\u8bed\u53e5\u5f88\u957f\uff0c\u67e5\u8be2\u4e86\u5927\u91cf\u7684\u5217\uff0c\u4e14\u4f7f\u7528\u4e86DISTINCT\uff0c\u800c\u4e14\u5173\u8054\u6761\u4ef6\u663e\u5f97\u5341\u5206\u590d\u6742\uff0c\u6240\u4ee5\u51fa\u73b0ORA-600\u9519\u8bef\u4e5f\u4e0d\u5947\u602a\u3002
\n\u68c0\u67e5MOS\u53d1\u73b0\uff0c\u95ee\u9898\u548cBug 9022470 – Query optimization fails with OERI[19004] [ID 9022470.8]\u6bd4\u8f83\u7c7b\u4f3c\uff0c\u9664\u4e86\u5f53\u524d\u768410204\u7248\u672c\u7b26\u5408\u8fd9\u4e2abug\u5f71\u54cd\u7684\u7248\u672c\u5916\uff0c\u5806\u6808\u4fe1\u606f\u9519\u8bef\u5b8c\u5168\u7b26\u5408\u8fd9\u4e2abug\u7684\u62a5\u9519\u4fe1\u606f\uff0c\u800c\u4e14\u5728\u8fd9\u4e2a\u67e5\u8be2\u4e2d\uff0c\u5176\u4e2d\u4e00\u4e2a\u5217\u786e\u5b9e\u5728\u8fde\u63a5\u67e5\u8be2\u4e2d\u51fa\u73b0\u4e86\u591a\u6b21\uff0c\u8fd9\u4e5f\u540c\u6837\u7b26\u5408bug\u7684\u63cf\u8ff0\u3002
\n\u8fd9\u4e2a\u9519\u8bef\u5f71\u54cd\u7684\u7248\u672c\u5305\u62ec10.2.0.4\u300111.1.0.7\u548c11.2.0.1\uff0cOracle\u572811.2.0.2\u4e2d\u4fee\u590d\u4e86\u8fd9\u4e2abug\u3002
\n\u5bf9\u4e8e\u8fd9\u4e2a\u9519\u8bef\uff0c\u5982\u679c\u65e0\u6cd5\u5347\u7ea7\u89e3\u51b3\uff0c\u90a3\u4e48\u53ea\u80fd\u901a\u8fc7\u4fee\u6539SQL\u8bed\u6cd5\uff0c\u6216\u8005\u5c1d\u8bd5\u964d\u4f4eOPTIMIER_FEATURES_ENABLE\u7684\u503c\u6765\u89e3\u51b3\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5ba2\u6237\u6570\u636e\u5e93\u51fa\u73b0ORA-600(19004)\u9519\u8bef\u3002 \u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a ORA-00600: internal error code, arguments: [19004], [], [], [], [], [], [], [] \u5bf9\u5e94\u7684\u8be6\u7ec6TRACE\u4e3a\uff1a *** 2012-03-15 13:10:31.283 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [19004], [], [], [], [], [], [], [] Current SQL statement … Continue reading