{"id":185,"date":"2011-10-07T23:54:09","date_gmt":"2011-10-07T15:54:09","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=185"},"modified":"2011-10-08T01:21:29","modified_gmt":"2011-10-07T17:21:29","slug":"ora-7445qeshihinsertprowinbkt%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=185","title":{"rendered":"ORA-7445(qeshIHInsertPRowInBkt)\u9519\u8bef"},"content":{"rendered":"

\u5ba2\u6237\u6570\u636e\u5e93\u544a\u8b66\u65e5\u5fd7\u51fa\u73b0\u4e86\u8fd9\u4e2a\u9519\u8bef\u4fe1\u606f\u3002
\n\u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n

Fri Mar 18 09:52:26 2011\r\n Errors in file \/oracle\/db\/admin\/B1EDB\/udump\/b1edb_ora_20076.trc:\r\n ORA-07445: exception encountered: core dump [qeshIHInsertPRowInBkt()+48] [SIGSEGV] [Address not mapped to object] [0x000B2B7B0] [] []<\/pre>\n
\u5bf9\u5e94\u7684TRACE\u6587\u4ef6\u4fe1\u606f\u4e3a\uff1a<\/p>\n
\/oracle\/db\/admin\/B1EDB\/udump\/b1edb_ora_20076.trc\r\n Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production\r\n With the Partitioning, OLAP, Data Mining and Real Application Testing options\r\n ORACLE_HOME = \/oracle\/db\r\n System name: HP-UX\r\n Node name: EDB\r\n Release: B.11.23\r\n Version: U\r\n Machine: ia64\r\n Instance name: B1EDB\r\n Redo thread mounted by this instance: 1\r\n Oracle process number: 36\r\n Unix process pid: 20076, image: oracle@EDB\r\n\r\n*** 2011-03-18 09:52:26.338\r\n *** ACTION NAME:() 2011-03-18 09:52:26.261\r\n *** MODULE NAME:(busobj.exe) 2011-03-18 09:52:26.261\r\n *** SERVICE NAME:(B1EDB) 2011-03-18 09:52:26.261\r\n *** SESSION ID:(501.23160) 2011-03-18 09:52:26.261\r\n Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0xb2b7b0, PC: [0x4000000002d51390, qeshIHInsertPRowInBkt()+48]\r\n   r1: 60000000000b5e18       r20:                1       br5:                0\r\n   r2: c000000040e04000       r21: 9fffffffab91bd50       br6: c000000000369bd0\r\n   r3:             f04b       r22: 9fffffffbbc4a01f       br7: c000000000218e60\r\n   r4:                0       r23:             1fd6        ip: 4000000002d51390\r\n   r5: c000000000000408       r24: 9fffffffbf251110      iipa:                0\r\n   r6: c000000000043810       r25:                8       cfm:             4b1e\r\n   r7: 9fffffffbf7f8de8       r26:                7        um:               1a\r\n   r8: 9fffffffab91bd69       r27: 9fffffffab91bd50       rsc:               1f\r\n   r9:           1fffff       r28:                4       bsp: 9fffffffbf800600\r\n  r10:             1fd2       r29: 9fffffffbf250100  bspstore: 9fffffffbf800600\r\n  r11: 9fffffffab91bd88       r30:             1fdc      rnat: c0000002d4fd7b88\r\n  r12: 9fffffffffff5e20       r31: 9fffffffab91bd00       ccv:                0\r\n  r13: 9fffffffbf455430      NaTs:                0      unat:                0\r\n  r14: 9fffffffab91bd88       PRs:             c84f      fpsr:    9804c8e76433f\r\n  r15:             1f9f       br0: 4000000002cb5b70       pfs: c00000000000038e\r\n  r16: 9fffffffbbc4a023       br1: c000000000218e60        lc:                0\r\n  r17: 9fffffffab91bd50       br2:                0        ec:                0\r\n  r18: 9fffffffbbc4a056       br3:                0       isr: 9fffffffbf800600\r\n  r19:             1fd2       br4:                0       ifa:                0\r\n Reason code: 0008\r\n *** 2011-03-18 09:52:26.393\r\n ksedmp: internal or fatal error\r\n ORA-07445: exception encountered: core dump [qeshIHInsertPRowInBkt()+48] [SIGSEGV] [Address not mapped to object] [0x000B2B7B0] [] []\r\n Current SQL statement for this session:\r\n SELECT    \r\n  EDS_LOT_RUN.EQPID, \r\n  SUM((to_date(EDS_LOT_RUN.TRACK_OUT_TIME, 'YYYYMMDD HH24MISS')  - to_date(EDS_LOT_RUN.TRACK_IN_TIME ,'YYYYMMDD HH24MISS')) * 24*60), \r\n  substr(EDS_LOT_EVENT_HIST.EVENT_TIME,1,8) ||' '|| substr(EDS_LOT_EVENT_HIST.EVENT_TIME,9,6)\r\n FROM \r\n  EDS_LOT_RUN, \r\n  EDS_LOT_EVENT_HIST, \r\n  EDS_LOT \r\nWHERE \r\n  ( EDS_LOT.LINE=EDS_LOT_EVENT_HIST.LINE AND \r\nEDS_LOT.FACTORY = EDS_LOT_EVENT_HIST.FACTORY AND \r\nEDS_LOT.LOTID= EDS_LOT_EVENT_HIST.LOTID  ) \r\n  AND  ( EDS_LOT.LINE=EDS_LOT_RUN.LINE and  EDS_LOT.LOTID=EDS_LOT_RUN.LOTID  ) \r\n  AND  ( EDS_LOT_RUN.EVENT = 'TRACKOUT'  ) \r\nGROUP BY \r\n  EDS_LOT_RUN.EQPID,  \r\n  substr(EDS_LOT_EVENT_HIST.EVENT_TIME,1,8) ||' '|| substr(EDS_LOT_EVENT_HIST.EVENT_TIME,9,6) \r\n----- Call Stack Trace -----\r\n calling              call     entry                argument values in hex      \r\nlocation             type     point                (? means dubious value)     \r\n-------------------- -------- -------------------- ----------------------------\r\n ksedst()+64          call     ksedst1()            000000001 ? 000000001 ?\r\n ksedmp()+2176        call     ksedst()             000000001 ?\r\n                                                    C000000000000C9F ?\r\n                                                    400000000404CC40 ?\r\n                                                    000000000 ? 000000000 ?\r\n                                                    000000000 ?\r\n ssexhd()+1264        call     ksedmp()             000000003 ?\r\n                                                    9FFFFFFFFFFECBA0 ?\r\n                                                    60000000000B5E18 ?\r\n                                                    9FFFFFFFFFFED170 ?\r\n                                                    C000000000000B9F ?\r\n                                                    400000000696A380 ?\r\n                                                    00000B6CD ?\r\n                                                    60000000000C2ED0 ?\r\n              call     ssexhd()             C00000033F4BF750 ?\r\n                                                    60000000000C4DC0 ?\r\n                                                    C000000040E0B7C0 ?\r\n                                                    60000000000B5E18 ?\r\n qeshIHInsertPRowInB  call                  9FFFFFFFFFFF1000 ?\r\n kt()+48                                            000000000 ? 000000000 ?\r\n                                                    000000000 ? 000000000 ?\r\n                                                    000000000 ? 000000000 ?\r\n                                                    000000000 ?\r\n qeshIHInsertPRow()+  call     qeshIHInsertPRowInB  9FFFFFFFBF331430 ?\r\n 80                            kt()                 9FFFFFFFBF256438 ?\r\n                                                    05C1656F6 ? 0001656F6 ?\r\n                                                    000B2B7B0 ?\r\n                                                    9FFFFFFFAB91BD68 ?\r\n                                                    000000000 ?\r\n qeshHDGrow()+1200    call     qeshIHInsertPRow()   9FFFFFFFBF331430 ?\r\n                                                    9FFFFFFFBF256438 ?\r\n                                                    05C1656F6 ?\r\n                                                    9FFFFFFFAB91BD68 ?\r\n                                                    000000000 ?\r\n                                                    C00000000000091A ?\r\n                                                    4000000005DEF540 ?\r\n                                                    000000000 ?\r\n $cold_qeshPTInsertU  call     qeshHDGrow()         9FFFFFFFBF3307B8 ?\r\n RowForGBY()+256                                    9FFFFFFFBF251518 ?\r\n                                                    9FFFFFFFFFFF5E48 ?\r\n                                                    9FFFFFFFFFFF5E50 ?\r\n                                                    60000000000B5E18 ?\r\n                                                    000000000 ?\r\n                                                    C000000000000B1D ?\r\n qeshLoadRowForGBY()  call     $cold_qeshPTInsertU  9FFFFFFFFFFF5FE0 ?\r\n +544                          RowForGBY()          9FFFFFFFFFFF6040 ?\r\n                                                    9FFFFFFFBF251518 ?\r\n                                                    9FFFFFFFFFFF5FE0 ?\r\n                                                    9FFFFFFFBF3307B8 ?\r\n                                                    9FFFFFFFBF251548 ?\r\n                                                    000030E3C ?\r\n                                                    9FFFFFFF881971E0 ?\r\n qerghRowP()+992      call     qeshLoadRowForGBY()  9FFFFFFFBF3307B8 ?\r\n                                                    9FFFFFFFBF3CB860 ?\r\n                                                    000000005 ?\r\n                                                    60000000000B5E18 ?\r\n                                                    C000000000000EA5 ?\r\n                                                    4000000002EEBE20 ?\r\n                                                    9FFFFFFFFFFF6040 ?\r\n                                                    9FFFFFFFBF330850 ?\r\n qerhjWalkHashBucket  call     qerghRowP()          C0000002D4071220 ?\r\n 2()+1632                                           000007FFF ?\r\n                                                    60000000000B5E18 ?\r\n                                                    C000000000001026 ?\r\n                                                    4000000007E45220 ?\r\n                                                    00000814B ?\r\n qerhjFetchPhase2()+  call     qerhjWalkHashBucket  C0000002D40714F8 ?\r\n 1536                          2()                  4000000001C184B0 ?\r\n                                                    C0000002D4071220 ?\r\n                                                    000007FFF ?\r\n                                                    9FFFFFFFBF3CB490 ?\r\n                                                    9FFFFFFFFFFF6180 ?\r\n                                                    000000000 ?\r\n $cold_qerhjFetch()+  call     qerhjFetchPhase2()   C0000002D40714F8 ?\r\n 4080                                               4000000001C184B0 ?\r\n                                                    C0000002D4071220 ?\r\n                                                    000007FFF ?\r\n                                                    60000000000A5B28 ?\r\n                                                    C000000000000F24 ?\r\n qerghFetch()+528     call     $cold_qerhjFetch()   C0000002D40714F8 ?\r\n                                                    4000000001C184B0 ?\r\n                                                    C0000002D4071220 ?\r\n                                                    000007FFF ?\r\n                                                    60000000000B5E18 ?\r\n opifch2()+9632       call     qerghFetch()         C0000002D4071220 ?\r\n                                                    4000000001C47AD0 ?\r\n                                                    9FFFFFFFFFFF6550 ?\r\n                                                    0000000C9 ?\r\n                                                    60000000000B5E18 ?\r\n                                                    C000000000001F46 ?\r\n                                                    4000000002EB3640 ?\r\n                                                    000018375 ?\r\n kpoal8()+6240        call     opifch2()            9FFFFFFFFFFF7510 ?\r\n                                                    4000000002AE5700 ?\r\n                                                    00001E80B ?\r\n                                                    9FFFFFFFFFFF63C0 ?\r\n                                                    60000000000B5E18 ?\r\n                                                    C0000000000015B3 ?\r\n                                                    60000000000314F0 ?\r\n                                                    040002D91 ?\r\n opiodr()+2128        call     kpoal8()             9FFFFFFFFFFF7C40 ?\r\n                                                    C000000000001530 ?\r\n                                                    000000000 ?\r\n                                                    9FFFFFFFFFFF7560 ?\r\n                                                    60000000000B5E18 ?\r\n                                                    9FFFFFFFBF3CCE40 ?\r\n ttcpip()+3088        call     opiodr()             00000005E ? 000000017 ?\r\n                                                    4000000001B5F640 ?\r\n                                                    0000046B0 ?\r\n                                                    9FFFFFFFFFFF7C50 ?\r\n                                                    60000000000B5E18 ?\r\n                                                    9FFFFFFFFFFF9DC0 ?\r\n                                                    C000000000001430 ?\r\n opitsk()+2336        call     ttcpip()             600000000003D0F0 ?\r\n                                                    9FFFFFFFFFFFA278 ?\r\n                                                    9FFFFFFFFFFFA320 ?\r\n                                                    0000001AF ?\r\n                                                    9FFFFFFFFFFFA490 ?\r\n                                                    9FFFFFFFFFFFA284 ?\r\n                                                    4000000001C45750 ?\r\n                                                    000000000 ?\r\n opiino()+1840        call     opitsk()             000000000 ? 000000000 ?\r\n                                                    60000000000B5E18 ?\r\n                                                    4000000002851570 ?\r\n                                                    0000180CD ?\r\n                                                    4000000001B5F658 ?\r\n opiodr()+2128        call     opiino()             00000003C ?\r\n                                                    9FFFFFFFFFFFCCE0 ?\r\n                                                    9FFFFFFFFFFFF480 ?\r\n                                                    9FFFFFFFFFFFC1A0 ?\r\n                                                    60000000000B5E18 ?\r\n                                                    C000000000001530 ?\r\n opidrv()+1088        call     opiodr()             00000003C ? 000000004 ?\r\n                                                    4000000001B5F0F0 ?\r\n                                                    0000046B0 ?\r\n                                                    9FFFFFFFFFFFCCF0 ?\r\n                                                    60000000000B5E18 ?\r\n sou2o()+336          call     opidrv()             00000003C ?\r\n                                                    9FFFFFFFFFFFF480 ?\r\n                                                    60000000000C2790 ?\r\n opimai_real()+224    call     sou2o()              9FFFFFFFFFFFF4A0 ?\r\n                                                    00000003C ? 000000004 ?\r\n                                                    9FFFFFFFFFFFF480 ?\r\n main()+368           call     opimai_real()        000000000 ?\r\n                                                    9FFFFFFFFFFFF4D0 ?\r\n main_opd_entry()+80  call     main()               000000002 ?\r\n                                                    9FFFFFFFFFFFF978 ?\r\n                                                    60000000000B5E18 ?\r\n                                                    C000000000000004 ?\r\n .\r\n .\r\n .\r\n ============\r\n Plan Table\r\n ============\r\n ------------------------------------------+--------------------------------+---------------+\r\n | Id| Operation               | Name              |Rows |Bytes|Cost |Time    |Pstart|Pstop |\r\n ------------------------------------------+--------------------------------+---------------+\r\n | 0 | SELECT STATEMENT        |                   |     |     | 922K|        |      |      |\r\n | 1 |  HASH GROUP BY          |                   |  25M|2876M| 922K|03:09:50|      |      |\r\n | 2 |   HASH JOIN             |                   |  25M|2876M| 259K|00:53:59|      |      |\r\n | 3 |    HASH JOIN            |                   |2734K| 216M|  61K|00:13:32|      |      |\r\n | 4 |     PARTITION RANGE ALL |                   | 940K|  19M| 6167|00:01:15 | 1    | 16   |\r\n | 5 |      TABLE ACCESS FULL  | EDS_LOT           | 940K|  19M| 6167|00:01:15 | 1    | 16   |\r\n | 6 |     PARTITION RANGE ALL |                   |2734K| 160M|  44K|00:09:05 | 1    | 16   |\r\n | 7 |      TABLE ACCESS FULL  | EDS_LOT_RUN       |2734K| 160M|  44K|00:09:05 | 1    | 16   |\r\n | 8 |    PARTITION RANGE ALL  |                   |  17M| 624M| 145K|00:30:41 | 1    | 16   |\r\n | 9 |     TABLE ACCESS FULL   | EDS_LOT_EVENT_HIST|  17M| 624M| 145K|00:30:41 | 1    | 16   |\r\n -------------------------------------------+-------------------------------+---------------+<\/pre>\n
\u6839\u636eTRACE\u4fe1\u606f\u548c\u6267\u884c\u8ba1\u5212\u5206\u6790\uff0c\u8fd9\u4e2a\u95ee\u9898\u662fMOS\u6587\u6863ID 6818207.8\u63cf\u8ff0\u7684Bug 6818207 – Intermittent Wrong Results\/Dump (qeshIHInsertPRowInBkt) using hash GROUP BY of large dataset\u3002<\/p>\n
\u4ece\u6267\u884c\u8ba1\u5212\u4e0d\u96be\u770b\u51fa\uff0cHASH GROUP BY\u8981\u5904\u7406\u7684\u6570\u636e\u91cf\u5f88\u5927\uff0c\u9884\u8ba1\u8fd0\u884c\u65f6\u95f4\u4e5f\u5f88\u957f\uff0c\u6240\u6709\u56e0\u7d20\u90fd\u6709bug\u76f8\u5173\u63cf\u8ff0\u76f8\u7b26\uff0c\u8fd9\u4e2abug\u572811.2.0.2\u4e2d\u88abFIXED\uff0c\u5728\u5f53\u524d\u7248\u672c\u4e2d\uff0c\u53ef\u4ee5\u901a\u8fc7\u8bbe\u7f6e”_gby_hash_aggregation_enabled”\u9690\u60a3\u51fd\u6570\u4e3aFALSE\uff0c\u6765\u7981\u6b62HASH GROUP BY\u6267\u884c\u8ba1\u5212\uff0c\u4ece\u800c\u907f\u514d\u9519\u8bef\u7684\u4ea7\u751f\u3002<\/p>\n
\u5982\u679c\u9519\u8bef\u53d1\u751f\u9891\u7387\u5f88\u4f4e\uff0c\u4e5f\u53ef\u4ee5\u901a\u8fc7\u4f18\u5316SQL\u7684\u65b9\u5f0f\u89e3\u51b3\u6216\u8005\u7b80\u5355\u5ffd\u7565\u4e4b\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5ba2\u6237\u6570\u636e\u5e93\u544a\u8b66\u65e5\u5fd7\u51fa\u73b0\u4e86\u8fd9\u4e2a\u9519\u8bef\u4fe1\u606f\u3002 \u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a Fri Mar 18 09:52:26 2011 Errors in file \/oracle\/db\/admin\/B1EDB\/udump\/b1edb_ora_20076.trc: ORA-07445: exception encountered: core dump [qeshIHInsertPRowInBkt()+48] [SIGSEGV] [Address not mapped to object] [0x000B2B7B0] [] [] \u5bf9\u5e94\u7684TRACE\u6587\u4ef6\u4fe1\u606f\u4e3a\uff1a \/oracle\/db\/admin\/B1EDB\/udump\/b1edb_ora_20076.trc Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production With the … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[127,118,126,128],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-2Z","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/185"}],"collection":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=185"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/185\/revisions"}],"predecessor-version":[{"id":186,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/185\/revisions\/186"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=185"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=185"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=185"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}