{"id":492,"date":"2012-01-17T15:01:30","date_gmt":"2012-01-17T07:01:30","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=492"},"modified":"2012-01-17T15:01:30","modified_gmt":"2012-01-17T07:01:30","slug":"ora-60013030%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=492","title":{"rendered":"ORA-600(13030)\u9519\u8bef"},"content":{"rendered":"<p>\u5728ITPUB\u4e0a\u770b\u5230\u7684\u4e00\u4e2aUPDATE RETURN\u5f15\u53d1\u7684ORA-600\u9519\u8bef\u3002<br \/>\n\u544a\u8b66\u65e5\u5fd7\u4e2d\u9519\u8bef\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>Mon Jan 16 09:50:13 2012\r\nErrors in file \/data\/dir1\/app\/oracle\/admin\/moyzkf1\/udump\/moyzkf1_ora_27801.trc:\r\nORA-00600: internal error code, arguments: [13030], [1], [], [], [], [], [], []<\/pre>\n<p>\u4ece\u5bf9\u5e94\u7684TRACE\u4e2d\u53ef\u4ee5\u770b\u51fa\uff0c\u6267\u884c\u7684\u662f\u4e00\u4e2aUPDATE RETURN\u8bed\u53e5\uff1a<\/p>\n<pre lang='SQL'>*** 2012-01-16 09:50:13.236\r\n*** SERVICE NAME:(moyzkf1) 2012-01-16 09:50:13.179\r\n*** SESSION ID:(1981.62963) 2012-01-16 09:50:13.179\r\nupdrow: CR error table 0 - rowid: 0001b9c9.0360371b.2 code 1\r\n*** 2012-01-16 09:50:13.236\r\nksedmp: internal or fatal error\r\nORA-00600: internal error code, arguments: [13030], [1], [], [], [], [], [], []\r\nCurrent SQL statement for this session:\r\nUPDATE T_Y_CN20111002_PRIZE SET REMAIN = REMAIN - 1 WHERE ID = (SELECT ID FROM (SELECT ID FROM T_Y_CN20111002_PRIZE WHERE GRADE = :B3 AND REMAIN > 0 AND :B2 BETWEEN BEGINDATE AND ENDDATE AND INSTR(NVL(COVEREDPROVINCES, ',' || :B1 || ','), ',' || :B1 || ',') > 0 ORDER BY DBMS_RANDOM.VALUE(1, 100000)) WHERE ROWNUM < 2) AND REMAIN > 0 AND CAST(DBMS_RANDOM.VALUE(1, PROBABILITY) AS INTEGER) = CAST(DBMS_RANDOM.VALUE(1, PROBABILITY) AS INTEGER) RETURN ID, TITLE, PRESENTFIGURES INTO :O0 ,:O1 ,:O2 \r\n----- PL\/SQL Call Stack -----\r\n  object      line  object\r\n  handle    number  name\r\n0x24fdcddf8      1007  package body P_YZKF.PKG_Y_CN20111002\r\n0x29bb96108         1  anonymous block\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                                                   7FFFCCDF1840 ? 7FFFCCDF18A0 ?\r\n                                                   7FFFCCDF17E0 ? 000000000 ?\r\nksedmp()+610         call     ksedst()             000000000 ? 000000001 ?\r\n                                                   7FFFCCDF1840 ? 7FFFCCDF18A0 ?\r\n                                                   7FFFCCDF17E0 ? 000000000 ?\r\nksfdmp()+21          call     ksedmp()             000000003 ? 000000001 ?\r\n                                                   7FFFCCDF1840 ? 7FFFCCDF18A0 ?\r\n                                                   7FFFCCDF17E0 ? 000000000 ?\r\nkgeriv()+176         call     ksfdmp()             000000003 ? 000000001 ?\r\n                                                   7FFFCCDF1840 ? 7FFFCCDF18A0 ?\r\n                                                   7FFFCCDF17E0 ? 000000000 ?\r\nkgesiv()+119         call     kgeriv()             006728580 ? 01D3DFEA0 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   7FFFCCDF17E0 ? 000000000 ?\r\nksesic1()+215        call     kgesiv()             006728580 ? 01D3DFEA0 ?\r\n                                                   0000032E6 ? 000000001 ?\r\n                                                   7FFFCCDF25C0 ? 000000000 ?\r\nupdrow()+4930        call     ksesic1()            0000032E6 ? 000000000 ?\r\n                                                   000000001 ? 000000000 ?\r\n                                                   000000000 ? 000000001 ?\r\nqerupRowProcedure()  call     updrow()             25EC23040 ? 000007FFF ?\r\n+80                                                2B16DFD2A018 ? 000000000 ?\r\n                                                   000000000 ? 000000001 ?\r\nqerupFetch()+667     call     qerupRowProcedure()  25EC23040 ? 000007FFF ?\r\n                                                   2B16DFD2A018 ? 000000000 ?\r\n                                                   000000000 ? 000000001 ?\r\nupdaul()+1065        call     qerupFetch()         000000001 ? 000000000 ?\r\n                                                   25EC1AC58 ? 000007FFF ?\r\n                                                   000000000 ? 25EC1AF18 ?\r\nupdThreePhaseExe()+  call     updaul()             25EC23040 ? 7FFFCCDF3850 ?\r\n3016                                               000000000 ? 2B16DFA5AC78 ?\r\n                                                   000000000 ? 25EC1AF18 ?<\/pre>\n<p>\u67e5\u8be2MOS\u786e\u8ba4\u611f\u89c9\u548cORA-600 [13030] On Update Statement [ID 744937.1]\u63cf\u8ff0\u7684Bug 7411865 &#8211; OERI:13030 \/ ORA-1407 \/ block corruption from UPDATE .. RETURNING DML with trigger\u975e\u5e38\u63a5\u8fd1\uff0c\u53ea\u6709\u4e00\u70b9\u611f\u89c9\u6709\u6240\u51fa\u5165\uff0c\u5c31\u662f\u5f53\u524d\u7684\u7248\u672c\u662f10203\uff0c\u800cBug 7411865\u662f10204\u8865\u4e01\u96c6\u89e3\u51b3bug 5115882\u65f6\uff0c\u5f15\u5165\u7684\u65b0\u7684\u9519\u8bef\u3002\u56e0\u6b64\uff0c\u5982\u679c\u5f53\u524d\u768410203\u6ca1\u6709\u4e13\u95e8\u53d6\u5e94\u7528patch 5115882\uff0c\u90a3\u4e48\u5e94\u4e0d\u4f1a\u78b0\u5230\u8fd9\u4e2a\u9519\u8bef\u3002<br \/>\n\u56e0\u6b64\u6839\u636e\u8fd9\u4e2a\u63a8\u65ad\uff0cBug 4549673  ORA-30926 \/ OERI:13030 during update\u63cf\u8ff0\u7684\u5c31\u66f4\u4e3a\u63a5\u8fd1\u4e00\u4e9b\u3002<br \/>\n\u5224\u65ad\u5230\u5e95\u662f\u54ea\u4e2a\u95ee\u9898\u5176\u5b9e\u5e76\u4e0d\u590d\u6742\uff0c\u53ea\u9700\u8981\u5c06\u6570\u636e\u5e93\u5347\u7ea7\u523010.2.0.4\u65e2\u53ef\u3002\u572810204\u4e2dBug 4549673\u88abfixed\uff0c\u800c7411865\u5219\u4ecd\u7136\u5b58\u5728\u3002<br \/>\n\u5982\u679c\u5c06\u7248\u672c\u5347\u7ea7\u523010.2.0.4.2\u621610.2.0.5\u5219\u8fd9\u4e24\u4e2abug\u90fd\u4f1a\u88abfixed\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5728ITPUB\u4e0a\u770b\u5230\u7684\u4e00\u4e2aUPDATE RETURN\u5f15\u53d1\u7684ORA-600\u9519\u8bef\u3002 \u544a\u8b66\u65e5\u5fd7\u4e2d\u9519\u8bef\u5982\u4e0b\uff1a Mon Jan 16 09:50:13 2012 Errors in file \/data\/dir1\/app\/oracle\/admin\/moyzkf1\/udump\/moyzkf1_ora_27801.trc: ORA-00600: internal error code, arguments: [13030], [1], [], [], [], [], [], [] \u4ece\u5bf9\u5e94\u7684TRACE\u4e2d\u53ef\u4ee5\u770b\u51fa\uff0c\u6267\u884c\u7684\u662f\u4e00\u4e2aUPDATE RETURN\u8bed\u53e5\uff1a *** 2012-01-16 09:50:13.236 *** SERVICE NAME:(moyzkf1) 2012-01-16 09:50:13.179 *** SESSION ID:(1981.62963) 2012-01-16 09:50:13.179 &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=492\">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":[387,8,318,315],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-7W","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/492"}],"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=492"}],"version-history":[{"count":2,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/492\/revisions"}],"predecessor-version":[{"id":494,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/492\/revisions\/494"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=492"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=492"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=492"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}