{"id":1180,"date":"2012-09-14T23:57:47","date_gmt":"2012-09-14T15:57:47","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=1180"},"modified":"2012-10-29T18:58:49","modified_gmt":"2012-10-29T10:58:49","slug":"ora-7445kkfipbr%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=1180","title":{"rendered":"ORA-7445(kkfipbr)\u9519\u8bef"},"content":{"rendered":"<p>\u5728\u5ba2\u6237\u768410.2.0.4 RAC for X86-64\u73af\u5883\u4e2d\u78b0\u5230\u4e86\u8fd9\u4e2a\u9519\u8bef\u3002<br \/>\n\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a<\/p>\n<pre lang='SQL'>Fri Apr 27 13:40:20 2012\r\nErrors in file \/opt\/app\/oracle\/admin\/ora\/udump\/ora1_ora_1851.trc:\r\nORA-07445: exception encountered: core dump [kkfipbr()+8] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []<\/pre>\n<p>\u5bf9\u5e94\u7684TRACE\u6587\u4ef6\u5185\u5bb9\u4e3a\uff1a<\/p>\n<pre lang='SQL'>*** 2012-04-27 13:40:20.422\r\nksedmp: internal or fatal error\r\nORA-07445: exception encountered: core dump [kkfipbr()+8] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []\r\nCurrent SQL statement for this session:\r\nselect * from (select pagetable.*,rownum recordid from (select s.id sid,p.id pid,p.name pname, \u2026 where rownum <= 7) where recordid >0\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                                                   2A97153D50 ? 2A97153DB0 ?\r\n                                                   2A97153CF0 ? 000000000 ?\r\nksedmp()+610         call     ksedst()             000000000 ? 000000001 ?\r\n                                                   2A97153D50 ? 2A97153DB0 ?\r\n                                                   2A97153CF0 ? 000000000 ?\r\nssexhd()+629         call     ksedmp()             000000003 ? 000000001 ?\r\n                                                   2A97153D50 ? 2A97153DB0 ?\r\n                                                   2A97153CF0 ? 000000000 ?\r\n__funlockfile()+64   call     ssexhd()             00000000B ? 2A97154D70 ?\r\n                                                   2A97154C40 ? 2A97153DB0 ?\r\n                                                   2A97153CF0 ? 000000000 ?\r\nkkfipbr()+8          signal   __funlockfile()      2A976A69B8 ? 000000000 ?\r\n                                                   7FBFFF7C10 ? 000000038 ?\r\n                                                   000000000 ? 000000000 ?\r\nkkfiPatchQbc()+235   call     kkfipbr()            2A976A69B8 ? 000000000 ?\r\n                                                   7FBFFF7C10 ? 000000038 ?\r\n                                                   000000000 ? 000000000 ?\r\nqkadrv()+554         call     kkfiPatchQbc()       2A976A69B8 ? 000000000 ?\r\n                                                   7FBFFF7C10 ? 000000038 ?\r\n                                                   000000000 ? 000000000 ?\r\nqkadrv()+6219        call     qkadrv()             2A972E9D08 ? 000000001 ?\r\n                                                   7FBFFF7C10 ? 000000038 ?\r\n                                                   000000000 ? 000000000 ?\r\nopitca()+1875        call     qkadrv()             2A972EAAB8 ? 000000001 ?\r\n                                                   7FBFFF7C10 ? 000000038 ?\r\n                                                   000000000 ? 000000000 ?\r\nkksLoadChild()+9360  call     opitca()             2A9779FF20 ? 319327A70 ?\r\n                                                   7FBFFF7C10 ? 000000038 ?\r\n                                                   000000000 ? 000000000 ?\r\nkxsGetRuntimeLock()  call     kksLoadChild()       0067B4700 ? 259299DD8 ?\r\n+1353                                              7FBFFFA4D0 ? 000000000 ?\r\n                                                   30DD70C10 ? 2A9779FF20 ?\r\nkksfbc()+15084       call     kxsGetRuntimeLock()  0067B4700 ? 2A9779FF20 ?\r\n                                                   7FBFFFA4D0 ? 000000000 ?\r\n                                                   30DD70C10 ? 2A9779FF20 ?\r\nkkspsc0()+1548       call     kksfbc()             2A9779FF20 ? 000000003 ?\r\n                                                   000000108 ? 2A975D2188 ?\r\n                                                   00000070D ? 000000000 ?\r\nkksParseCursor()+14  call     kkspsc0()            2A97311D08 ? 2A975D2188 ?\r\n2                                                  00000070D ? 000000003 ?\r\n                                                   300A400000006 ? 0000300A4 ?\r\nopiosq0()+1641       call     kksParseCursor()     7FBFFFAF18 ? 2A975D2188 ?\r\n                                                   00000070D ? 000000003 ?\r\n                                                   300A400000006 ? 0000300A4 ?\r\nkpooprx()+315        call     opiosq0()            000000003 ? 00000000E ?\r\n                                                   7FBFFFB108 ? 0000000A4 ?\r\n                                                   300A400000006 ? 0000300A4 ?\r\nkpoal8()+799         call     kpooprx()            7FBFFFE2B4 ? 2A975D2188 ?\r\n                                                   00000070C ? 000000001 ?\r\n                                                   000000000 ? 0000300A4 ?\r\nopiodr()+984         call     kpoal8()             00000005E ? 000000017 ?\r\n                                                   7FBFFFE2B0 ? 000000001 ?\r\n                                                   000000001 ? 0000300A4 ?\r\nttcpip()+1012        call     opiodr()             00000005E ? 000000017 ?\r\n                                                   7FBFFFE2B0 ? 000000000 ?\r\n                                                   0059DF750 ? 0000300A4 ?\r\nopitsk()+1322        call     ttcpip()             0067BC3D0 ? 000000003 ?\r\n                                                   7FBFFFE2B0 ? 000000000 ?\r\n                                                   7FBFFFDDA8 ? 7FBFFFE418 ?\r\nopiino()+1026        call     opitsk()             000000003 ? 000000000 ?\r\n                                                   7FBFFFE2B0 ? 000000001 ?\r\n                                                   000000000 ? 683197600000001 ?\r\nopiodr()+984         call     opiino()             00000003C ? 000000004 ?\r\n                                                   7FBFFFF478 ? 000000000 ?\r\n                                                   000000000 ? 683197600000001 ?\r\nopidrv()+547         call     opiodr()             00000003C ? 000000004 ?\r\n                                                   7FBFFFF478 ? 000000000 ?\r\n                                                   0059DF200 ? 683197600000001 ?\r\nsou2o()+114          call     opidrv()             00000003C ? 000000004 ?\r\n                                                   7FBFFFF478 ? 000000000 ?\r\n                                                   0059DF200 ? 683197600000001 ?\r\nopimai_real()+163    call     sou2o()              7FBFFFF450 ? 00000003C ?\r\n                                                   000000004 ? 7FBFFFF478 ?\r\n                                                   0059DF200 ? 683197600000001 ?\r\nmain()+116           call     opimai_real()        000000002 ? 7FBFFFF4E0 ?\r\n                                                   000000004 ? 7FBFFFF478 ?\r\n                                                   0059DF200 ? 683197600000001 ?\r\n__libc_start_main()  call     main()               000000002 ? 7FBFFFF4E0 ?\r\n+219                                               000000004 ? 7FBFFFF478 ?\r\n                                                   0059DF200 ? 683197600000001 ?\r\n_start()+42          call     __libc_start_main()  0007139F8 ? 000000002 ?\r\n                                                   7FBFFFF628 ? 0052B4BD0 ?\r\n                                                   000000000 ? 000000002 ?\r\n--------------------- Binary Stack Dump ---------------------<\/pre>\n<p>\u5bfc\u81f4\u9519\u8bef\u7684\u539f\u56e0\u662f\u7531\u4e8eSQL\u8bed\u53e5\u4e2d\u51fa\u73b0\u4e86ROWNUM\uff0c\u56e0\u6b64Oracle\u5c1d\u8bd5\u4f7f\u7528FIRST_ROW_N\u4f18\u5316\u6a21\u5f0f\u6765\u8fdb\u884cCBO\u6267\u884c\u8ba1\u5212\u7684\u8bc4\u4f30\uff0c\u5e76\u5bfc\u81f4\u4e86\u9519\u8bef\u3002Oracle\u5728\u6587\u6863Bug 7378625 &#8211; Assorted Dumps and Wrong Results from first_rows_k optimization [ID 7378625.8]\u5bf9\u8fd9\u4e2a\u95ee\u9898\u8fdb\u884c\u4e86\u63cf\u8ff0\u3002<br \/>\n\u8be5\u95ee\u9898\u786e\u8ba4\u5f71\u54cd10.2.0.4\u548c11.1.0.7\u7248\u672c\uff0c\u5e76\u572811.2.0.1\u548c10.2.0.5\u4e2d\u8fdb\u884c\u4e86\u89e3\u51b3\u3002\u9664\u4e86\u6309\u7167\u8865\u4e01\u5916\uff0c\u5bf9\u4e8e\u51fa\u73b0ROWNUM\u7684\u67e5\u8be2\u60c5\u51b5\uff0c\u53ef\u4ee5\u8003\u8651\u8bbe\u7f6e\u9690\u542b\u53c2\u6570_optimizer_rownum_pred_based_fkr\u4e3aFALSE\u6765\u89e3\u51b3\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5728\u5ba2\u6237\u768410.2.0.4 RAC for X86-64\u73af\u5883\u4e2d\u78b0\u5230\u4e86\u8fd9\u4e2a\u9519\u8bef\u3002 \u9519\u8bef\u4fe1\u606f\u4e3a\uff1a Fri Apr 27 13:40:20 2012 Errors in file \/opt\/app\/oracle\/admin\/ora\/udump\/ora1_ora_1851.trc: ORA-07445: exception encountered: core dump [kkfipbr()+8] [SIGSEGV] [Address not mapped to object] [0x000000000] [] [] \u5bf9\u5e94\u7684TRACE\u6587\u4ef6\u5185\u5bb9\u4e3a\uff1a *** 2012-04-27 13:40:20.422 ksedmp: internal or fatal error ORA-07445: exception &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=1180\">Continue reading <span class=\"meta-nav\">&rarr;<\/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":[1035,1037,118,28,1036],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-j2","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1180"}],"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=1180"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1180\/revisions"}],"predecessor-version":[{"id":1183,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1180\/revisions\/1183"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1180"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1180"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1180"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}