{"id":805,"date":"2012-05-01T23:30:18","date_gmt":"2012-05-01T15:30:18","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=805"},"modified":"2012-05-03T22:30:42","modified_gmt":"2012-05-03T14:30:42","slug":"ora-600ktspfupdst-1%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=805","title":{"rendered":"ORA-600(ktspfupdst-1)\u9519\u8bef"},"content":{"rendered":"<p>\u5ba2\u62379208\u6570\u636e\u5e93\u51fa\u73b0ORA-600[ktspfupdst-1]\u9519\u8bef\u3002<br \/>\n\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a<\/p>\n<pre lang='SQL'>Sat Mar 31 02:50:48 2012\r\nErrors in file \/oracle\/app\/admin\/orcl\/udump\/orcl1_ora_1896900.trc:\r\nORA-00600: internal error code, arguments: [ktspfupdst-1], [], [], [], [], [], [], []\r\nORA-00604: error occurred at recursive SQL level 1\r\nORA-01013: user requested cancel of current operation<\/pre>\n<p>\u5176\u5b9e\u4ece\u9519\u8bef\u4fe1\u606f\u672c\u8eab\u5c31\u53ef\u4ee5\u521d\u6b65\u5224\u65ad\uff0c\u95ee\u9898\u5e94\u8be5\u548c\u7528\u6237\u53d6\u6d88\u5f53\u524d\u7684\u64cd\u4f5c\u6709\u5173\u3002\u95ee\u9898\u591a\u534a\u662f\u7531\u4e8e\u7528\u6237\u53d6\u6d88\u5f53\u524d\u64cd\u4f5c\u540e\uff0cOracle\u5728\u8fdb\u884c\u6062\u590d\u5904\u7406\u65f6\uff0c\u5f15\u53d1\u4e86\u5f02\u5e38\u3002<br \/>\n\u8be6\u7ec6TRACE\u4fe1\u606f\u4e3a\uff1a<\/p>\n<pre lang='SQL'>*** 2012-03-31 02:50:48.509\r\nksedmp: internal or fatal error\r\nORA-00600: internal error code, arguments: [ktspfupdst-1], [], [], [], [], [], [], []\r\nORA-00604: error occurred at recursive SQL level 1\r\nORA-01013: user requested cancel of current operation\r\nCurrent SQL statement for this session:\r\nINSERT INTO TAB001_3\r\n(\r\n  COL_CODE      ,\r\n  A_CODE          ,\r\n  C_CODE        ,\r\n  S_ID            ,\r\n  SER_NUM        ,\r\n  S_TYPE          ,\r\n  C_ID            ,\r\n  A_ID            ,\r\n  N_TYPE           ,\r\n  B_ID           ,\r\n  P_ID            , \r\n  P_ID_N       ,\r\n  S_STAT        ,\r\n  U_TIME        ,\r\n  P_MODE           ,\r\n  S_KIND          ,\r\n  V_TYPE         ,\r\n  O_MODE          ,\r\n  A_TIME       ,\r\n  C_TIME      ,\r\n  AC_TIME        ,\r\n  A_R_TIME   ,\r\n  S_MODE          ,\r\n  T_CODE      ,\r\n  S_NUMBER         ,\r\n  P_CODE       ,\r\n  D_CODE      ,\r\n  S_FLAG      ,\r\n  S_TIME      ,\r\n  DE_CODE     ,\r\n  D_C_CODE  ,\r\n  D_STAFF         ,\r\n  CI_TYPE       ,\r\n  O_TIME          ,\r\n  SU_FLAG          ,\r\n  SU_FLAG       ,\r\n  D_A_CODE,\r\n  CH_CODE          ,\r\n  GR_ID           ,\r\n  RE_CODE        )\r\nSELECT '30',c.b_region,'',a.id_no,trim(a.p_no),'',a.c_id,a.c_no,'',a.s_code,'',\r\n       '',decode(substr(a.r_code,2,1),'A','1','K','1','C','2','I','4','J','4','a','5','b','5','3'),\r\n       to_char(a.r_time,'yyyymmddhh24miss'),decode(b.c_flag,'A','2','B','1'),\r\n       '','01','1',to_char(a.o_time,'yyyymmddhh24miss'),to_char(a.o_time,'yyyymmddhh24miss'),'',to_char(a.o_time,'yyyymmddhh24miss'),\r\n       'S','','','','','2','',\r\n       '','','','',to_char(a.o_time,'yyyymmddhh24miss'),'U',decode(substr(a.r_code,2,1),'A','0','K','0','1'),\r\n       c.b_region,'',a.g_id,c.r_code\r\n  FROM tab2 a,tab3 b, tab4 c\r\n WHERE a.s_code = b.s_code\r\n   AND substr(a.b_code,0,2) = b.r_code\r\n   AND b.r_code = c.r_code\r\n   AND mod(a.id_no,10) = 3\r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex\r\nlocation             type     point                (? means dubious value)\r\n-------------------- -------- -------------------- ----------------------------\r\nksedmp+0148          bl       ksedst               1029746FC ?\r\nksfdmp+0018          bl       01FD4014\r\nkgerinv+00e8         bl       _ptrgl\r\nkgeasnmierr+004c     bl       kgerinv              000000001 ? 000000000 ?\r\n                                                   000000005 ? 000000001 ?\r\n                                                   000000001 ?\r\nktspfupdst+0540      bl       kgeasnmierr          110006308 ? 1103994E8 ?\r\n                                                   102A9239C ? 000000000 ?\r\n                                                   000000005 ? 000000010 ?\r\n                                                   000000020 ? 000000006 ?\r\nktspstchg+00e4       bl       ktspfupdst           000000060 ? 300000004 ?\r\n                                                   FFFFFFFFFFF6E48 ?\r\n                                                   50601CE000000ED ?\r\n                                                   3B401B34C5D02F2A ?\r\n                                                   B92000004000020 ?\r\nkdoiur+062c          bl       ktspstchg            000000000 ? 700000C39D779E8 ?\r\n                                                   000000000 ?\r\nkcoubk+00e4          bl       _ptrgl\r\nktundo+0988          bl       kcoubk               1010CCD80 ? FFFFFFFFFFF76C0 ?\r\n                                                   100ED51C0 ? FFFFFFFFFFF7150 ?\r\n                                                   1101FAF78 ? 1102567C0 ?\r\n                                                   700000C396A1300 ? 000000002 ?\r\nktubko+03bc          bl       ktundo               1840DFB30 ?\r\n                                                   3B401B3400000002 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   FFFFFFFFFFF85D8 ?\r\n                                                   700000C80A1E880 ? 2FFFF8540 ?\r\n                                                   FFFFFFFFFFF8780 ?\r\nktuabt+0638          bl       ktubko               DF000000DF ?\r\n                                                   FFFFFFFFFFF8690 ? 000000000 ?\r\n                                                   FFFFFFFFFFF85D8 ? 102973880 ?\r\n                                                   700000C844FA418 ?\r\nktcrab+02b4          bl       ktuabt               700000C80A1E840 ? 200017CD8 ?\r\nktcrsp+026c          bl       ktcrab               100F698E4 ? 000000001 ?\r\nksures+0074          bl       ktcrsp               700000C844FA448 ?\r\nopiexe+3380          bl       01FD4138\r\nopiall0+102c         bl       opiexe               400000000 ? 110002A48 ?\r\n                                                   FFFFFFFFFFFA0A0 ?\r\nkpoal8+0a78          bl       opiall0              5EFFFFBED4 ? 22103A43F8 ?\r\n                                                   FFFFFFFFFFFA5B8 ? 000000000 ?\r\n                                                   FFFFFFFFFFFA508 ? 1103A4B00 ?\r\n                                                   6FF00000738 ?\r\n                                                   24000000007FFF ?\r\nopiodr+08cc          bl       _ptrgl\r\nttcpip+0cc4          bl       _ptrgl\r\nopitsk+0d60          bl       ttcpip               11000CF90 ? 000000000 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   000000000 ? 000000000 ?\r\nopiino+0758          bl       opitsk               000000000 ? 000000000 ?\r\nopiodr+08cc          bl       _ptrgl\r\nopidrv+032c          bl       opiodr               3C00000018 ? 4101FAF78 ?\r\n                                                   FFFFFFFFFFFF7B0 ? 0A000F350 ?\r\nsou2o+0028           bl       opidrv               3C0C000000 ? 4A00E8B50 ?\r\n                                                   FFFFFFFFFFFF7B0 ?\r\nmain+0138            bl       01FD3A28\r\n__start+0098         bl       main                 000000000 ? 000000000 ?<\/pre>\n<p>\u53ef\u4ee5\u770b\u5230\uff0c\u5f53\u524d\u6267\u884c\u7684\u662f\u4e00\u6761\u63d2\u5165\u8bed\u53e5\u3002\u67e5\u8be2MOS\u53d1\u73b0\uff0c\u95ee\u9898\u548cORA-00600 [ktspfupdst-1] During DML on ASSM Segment [ID 388599.1]\u63cf\u8ff0\u7684\u5b8c\u5168\u4e00\u81f4\u3002<br \/>\n\u9996\u5148\u5f53\u524d\u63d2\u5165\u7684\u8868\u6240\u5728\u8868\u7a7a\u95f4\u4f7f\u7528\u7684\u662fASSM\uff0c\u5176\u6b21\u8fd9\u4e2a\u63d2\u5165\u64cd\u4f5c\u88ab\u53d6\u6d88\uff0c\u800c\u4e14\u6240\u6709\u5806\u6808\u4fe1\u606f\u4e0ebug 3370468\u63cf\u8ff0\u7684\u5b8c\u5168\u4e00\u81f4\u3002<br \/>\n\u867d\u7136\u8fd9\u4e2abug\u57289.2.0.5\u88abfixed\uff0c\u4f46\u662f\u4e0d\u6392\u9664\u57289.2.0.8\u88ab\u91cd\u65b0\u5f15\u5165\u7684\u53ef\u80fd\u6027\u3002Oracle\u7ed9\u51fa\u7684\u89e3\u51b3\u65b9\u6848\u9664\u4e86\u5347\u7ea7\u523010.2\u4ee5\u53ca10.1.0.3\u4ee5\u4e0a\u5916\uff0c\u8fd8\u53ef\u4ee5\u5c1d\u8bd5\u7528dbms_repair.segment_fix_status\u8fc7\u7a0b\u6765\u4fee\u6b63\u95ee\u9898\u5bf9\u8c61\u3002<br \/>\n\u5982\u679c\u53ea\u662f\u5355\u6b21\u7684\u95ee\u9898\uff0c\u4e14\u65e0\u6cd5\u91cd\u73b0\uff0c\u6700\u7b80\u5355\u7684\u65b9\u6cd5\u83ab\u8fc7\u4e8e\u76f4\u63a5MOVE\uff0c\u786e\u4fddASSM\u7a7a\u95f4\u7ba1\u7406\u7684\u5f02\u5e38\u4e0d\u4f1a\u5bfc\u81f4\u8868\u4e2d\u540e\u7eed\u6570\u636e\u7684\u63d2\u5165\u548c\u8bfb\u53d6\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5ba2\u62379208\u6570\u636e\u5e93\u51fa\u73b0ORA-600[ktspfupdst-1]\u9519\u8bef\u3002 \u9519\u8bef\u4fe1\u606f\u4e3a\uff1a Sat Mar 31 02:50:48 2012 Errors in file \/oracle\/app\/admin\/orcl\/udump\/orcl1_ora_1896900.trc: ORA-00600: internal error code, arguments: [ktspfupdst-1], [], [], [], [], [], [], [] ORA-00604: error occurred at recursive SQL level 1 ORA-01013: user requested cancel of current operation \u5176\u5b9e\u4ece\u9519\u8bef\u4fe1\u606f\u672c\u8eab\u5c31\u53ef\u4ee5\u521d\u6b65\u5224\u65ad\uff0c\u95ee\u9898\u5e94\u8be5\u548c\u7528\u6237\u53d6\u6d88\u5f53\u524d\u7684\u64cd\u4f5c\u6709\u5173\u3002\u95ee\u9898\u591a\u534a\u662f\u7531\u4e8e\u7528\u6237\u53d6\u6d88\u5f53\u524d\u64cd\u4f5c\u540e\uff0cOracle\u5728\u8fdb\u884c\u6062\u590d\u5904\u7406\u65f6\uff0c\u5f15\u53d1\u4e86\u5f02\u5e38\u3002 &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=805\">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":[183,662,131,313,661,8,663],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-cZ","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/805"}],"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=805"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/805\/revisions"}],"predecessor-version":[{"id":807,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/805\/revisions\/807"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=805"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=805"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=805"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}