{"id":843,"date":"2012-05-16T23:46:21","date_gmt":"2012-05-16T15:46:21","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=843"},"modified":"2012-05-17T19:23:25","modified_gmt":"2012-05-17T11:23:25","slug":"ora-600kjbrrefpkey%e5%92%8cora-600kjbmprlstshadow%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=843","title":{"rendered":"ORA-600(kjbrrefp:key)\u548cORA-600(kjbmprlst:shadow)\u9519\u8bef"},"content":{"rendered":"<p>\u8fd9\u4e24\u4e2a\u9519\u8bef\u662f\u7531\u540c\u4e00\u4e2aBUG\u5bfc\u81f4\u7684\u3002<br \/>\n\u6570\u636e\u5e93\u73af\u588311.2.0.2 RAC for Solaris sparc\uff0c\u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>2012-01-29 06:15:10.168000 +08:00\r\nErrors in file \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_lms3_81.trc (incident=384590):\r\nORA-00600: internal error code, arguments: [kjbrref:pkey], [332269], [202], [137064], [0], [], [], [], [], [], [], []\r\nIncident details in: \/app\/diag\/rdbms\/orcl\/orcl1\/incident\/incdir_384590\/orcl1_lms3_81_i384590.trc\r\nUse ADRCI or Support Workbench to package the incident.\r\nSee Note 411.1 at My Oracle Support for error and packaging details.\r\n2012-01-29 06:15:11.923000 +08:00\r\nDumping diagnostic data in directory=[cdmp_20120129061511], requested by (instance=1, osid=81 (LMS3)), summary=[incident=384590].\r\nSweep [inc][384590]: completed\r\nSweep [inc2][384590]: completed\r\n2012-01-29 06:15:17.289000 +08:00\r\nErrors in file \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_lms3_81.trc:\r\nORA-00600: internal error code, arguments: [kjbrref:pkey], [332269], [202], [137064], [0], [], [], [], [], [], [], []\r\nLMS3 (ospid: 81): terminating the instance due to error 484\r\n2012-01-29 06:15:20.910000 +08:00\r\nORA-1092 : opitsk aborting process\r\n2012-01-29 06:15:22.384000 +08:00\r\n.\r\n.\r\n.\r\n2012-04-17 04:26:44.373000 +08:00\r\nErrors in file \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_lms1_8678.trc (incident=432578):\r\nORA-00600: internal error code, arguments: [kjbmprlst:shadow], [], [], [], [], [], [], [], [], [], [], []\r\nIncident details in: \/app\/diag\/rdbms\/orcl\/orcl1\/incident\/incdir_432578\/orcl1_lms1_8678_i432578.trc\r\nUse ADRCI or Support Workbench to package the incident.\r\nSee Note 411.1 at My Oracle Support for error and packaging details.\r\n2012-04-17 04:26:45.864000 +08:00\r\nDumping diagnostic data in directory=[cdmp_20120417042645], requested by (instance=1, osid=8678 (LMS1)), summary=[incident=432578].\r\nErrors in file \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_lms1_8678.trc:\r\nORA-00600: internal error code, arguments: [kjbmprlst:shadow], [], [], [], [], [], [], [], [], [], [], []\r\n2012-04-17 04:26:47.359000 +08:00\r\nSweep [inc][432578]: completed\r\nSweep [inc2][432578]: completed\r\n2012-04-17 04:26:53.095000 +08:00\r\nErrors in file \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_lms1_8678.trc:\r\nORA-00600: internal error code, arguments: [kjbmprlst:shadow], [], [], [], [], [], [], [], [], [], [], []\r\nLMS1 (ospid: 8678): terminating the instance due to error 484\r\n2012-04-17 04:26:56.593000 +08:00\r\nORA-1092 : opitsk aborting process\r\n2012-04-17 04:26:58.088000 +08:00\r\nInstance terminated by LMS1, pid = 8678<\/pre>\n<p>\u53ef\u4ee5\u770b\u5230\uff0c\u65e0\u8bba\u662fkjbrref:pkey\u9519\u8bef\u7684\u51fa\u73b0\u8fd8\u662fkjbmprlst:shadow\u9519\u8bef\u7684\u51fa\u73b0\uff0c\u90fd\u76f4\u63a5\u5bfc\u81f4\u4e86\u5b9e\u4f8b\u7684CRASH\u3002\u53ef\u4ee5\u8bf4\u8fd9\u4e24\u4e2a\u9519\u8bef\u90fd\u662f\u975e\u5e38\u4e25\u91cd\u7684\u95ee\u9898\u3002\u800c\u4e14\u4e8c\u8005\u90fd\u53d1\u751f\u5728LMSn\u8fdb\u7a0b\u4e0a\u3002<\/p>\n<pre lang='SQL'>*** 2012-01-29 06:15:10.194\r\n*** SESSION ID:(1009.1) 2012-01-29 06:15:10.194\r\n*** CLIENT ID:() 2012-01-29 06:15:10.194\r\n*** SERVICE NAME:(SYS$BACKGROUND) 2012-01-29 06:15:10.194\r\n*** MODULE NAME:() 2012-01-29 06:15:10.194\r\n*** ACTION NAME:() 2012-01-29 06:15:10.194\r\nDump continued from file: \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_lms3_81.trc\r\nORA-00600: internal error code, arguments: [kjbrref:pkey], [332269], [202], [137064], [0], [], [], [], [], [], [], []\r\n========= Dump for incident 384590 (ORA 600 [kjbrref:pkey]) ========\r\n----- Beginning of Customized Incident Dump(s) -----\r\n GCS RESOURCE 0xb92d0cfa0 hashq [0xbb35eddc8,0xc0f9b1f60] name[0x511ed.ca] pkey 136931.0\r\n   grant 0xb94a7e8f8 cvt 0x0 send 0x0@1,0 write 0x0,0@65536\r\n   flag 0x2 mdrole 0x1 mode 1 scan 0.0 role LOCAL\r\n   disk: 0x0000.00000000 write: 0x0000.00000000 cnt 0x0 hist 0x0\r\n   xid 0x0000.000.00000000 sid 3 pkwait 0s rmacks 0\r\n   refpcnt 0 weak: 0x0000.00000000\r\n   pkey 136931.0\r\n   hv 91 [stat 0x0, 1->1, wm 32768, RMno 0, reminc 12, dom 0]\r\n   kjga st 0x4, step 0.35.0, cinc 18, rmno 6345, flags 0x20\r\n   lb 16384, hb 32767, myb 16957, drmb 16957, apifrz 1\r\n   GCS SHADOW 0xb94a7e8f8,626 resp[0xb92d0cfa0,0x511ed.ca] pkey 136931.0\r\n     grant 1 cvt 0 mdrole 0x1 st 0x100 lst 0x40 GRANTQ rl LOCAL\r\n     master 1 owner 2 sid 3 remote[0x68fde3ef0,11] hist 0x10c30086180431f\r\n     history 0x1f.0x6.0x1.0xc.0x6.0x1.0xc.0x6.0x1.0x0.\r\n     cflag 0x0 sender 0 flags 0x0 replay# 0 abast 0x0.x0.1 dbmap 0x0\r\n     disk: 0x0000.00000000 write request: 0x0000.00000000\r\n     pi scn: 0x0000.00000000 sq[0xb92d0cfd0,0xb92d0cfd0]\r\n     msgseq 0x1 updseq 0x0 reqids[11,0,0] infop 0x0 lockseq x67d9\r\n   GCS SHADOW END\r\n GCS RESOURCE END\r\n----- End of Customized Incident Dump(s) -----\r\n*** 2012-01-29 06:15:10.261\r\ndbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)\r\n----- SQL Statement (None) -----\r\nCurrent SQL information unavailable - no cursor.\r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex      \r\nlocation             type     point                (? means dubious value)     \r\n-------------------- -------- -------------------- ----------------------------\r\nksedst1()+96         CALL     skdstdst()           FFFFFFFF7FFF4C00 ?\r\n                                                   100670460 ? 000000000 ?\r\n                                                   00000000A ? 000000001 ?\r\n                                                   10BD552E0 ?\r\nksedst()+60          CALL     ksedst1()            000000000 ? 000000001 ?\r\n                                                   00010C1D1 ? 00010C000 ?\r\n                                                   10C1CA000 ? 00010C1CA ?\r\ndbkedDefDump()+2032  CALL     ksedst()             000000000 ? 10B21A000 ?\r\n                                                   10B21AA90 ? 10C1D2000 ?\r\n                                                   00010B000 ? 00010C1D2 ?\r\ndbgexPhaseII()+1800  PTR_CALL dbkedDefDump()       000000003 ? 000000002 ?\r\n                                                   10A6ABAA8 ? 0000014B0 ?\r\n                                                   10C1C9000 ? 000000003 ?\r\ndbgexExplicitEndInc  CALL     dbgexPhaseII()       10C373D30 ?\r\n()+728                                             FFFFFFFF7A634920 ?\r\n                                                   FFFFFFFF7FFF8FDC ?\r\n                                                   0018E0001 ? 10A6A2D98 ?\r\n                                                   000001C00 ?\r\ndbgeEndDDEInvocatio  CALL     dbgexExplicitEndInc  10A6A2C50 ?\r\nnImpl()+704                   ()                   FFFFFFFF7A634920 ?\r\n                                                   FFFFFFFF7FFF8F28 ?\r\n                                                   FFFFFFFF7FFFC620 ?\r\n                                                   000000000 ?\r\n                                                   FFFFFFFFFE4E26A0 ?\r\nkjbrref()+1496       CALL     dbgeEndDDEInvocatio  10C373D30 ? 001B1D800 ?\r\n                              n()                  FFFFFFFFFEC0AF31 ?\r\n                                                   FFFFFFFF7FFFC620 ?\r\n                                                   000002868 ? 0018E0001 ?\r\nkjblreplay()+7380    CALL     kjbrref()            000002868 ? 10C1CA3E0 ?\r\n                                                   000021768 ? A681AFA10 ?\r\n                                                   B92D0CFA0 ? C0F96F920 ?\r\nkjbldrmrpst()+4864   CALL     kjblreplay()         000000000 ? 000000001 ?\r\n                                                   10C1CA0A0 ? BDA03C9B8 ?\r\n                                                   000000000 ? 10C1E8890 ?\r\nkjmprcfgsync()+1424  CALL     kjbldrmrpst()        A681AFA10 ? 000000001 ?<\/pre>\n<p>\u53e6\u4e00\u4e2atrace\u6587\u4ef6\uff1a<\/p>\n<pre lang='SQL'>*** 2012-04-17 04:26:44.389\r\n*** SESSION ID:(673.1) 2012-04-17 04:26:44.389\r\n*** CLIENT ID:() 2012-04-17 04:26:44.389\r\n*** SERVICE NAME:(SYS$BACKGROUND) 2012-04-17 04:26:44.389\r\n*** MODULE NAME:() 2012-04-17 04:26:44.389\r\n*** ACTION NAME:() 2012-04-17 04:26:44.389\r\nDump continued from file: \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_lms1_8678.trc\r\nORA-00600: internal error code, arguments: [kjbmprlst:shadow], [], [], [], [], [], [], [], [], [], [], []\r\n========= Dump for incident 432578 (ORA 600 [kjbmprlst:shadow]) ========\r\n----- Beginning of Customized Incident Dump(s) -----\r\n FUSION MSG 0xffffffff79c40b80,39 from 2 spnum 14 ver[38,11161] ln 144 sq[2,8]\r\n        REPLAY 1 [0x103699.c7, 151132.0] c[0x7e7bd3240,55] [0x494e,x38]\r\n        grant 2 convert 0 role x0\r\n        pi [0x0.0x0] flags 0x0 state 0x100\r\n        disk scn 0x0.0 writereq scn 0x0.0 rreqid x0\r\n        msgRM# 11161 bkt# 18131 drmbkt# 18131\r\n    pkey 151132.0 undo 0 stat 5 masters[32768, 2->32768] reminc 38 RM# 11152\r\n flg x0 type x0 afftime x8517cf38\r\n nreplays by lms 0 = 4046 \r\n nreplays by lms 1 = 4105 \r\n nreplays by lms 2 = 4176 \r\n nreplays by lms 3 = 4214 \r\n nreplays by lms 4 = 4158 \r\n nreplays by lms 5 = 4162 \r\n   hv 125 [stat 0x0, 1->1, wm 32768, RMno 0, reminc 36, dom 0]\r\n   kjga st 0x4, step 0.36.0, cinc 38, rmno 11161, flags 0x20\r\n   lb 16384, hb 32767, myb 18131, drmb 18131, apifrz 1\r\n FUSION MSG DUMP END\r\n GCS RESOURCE 0xbb93a40e8 hashq [0xba8f40298,0xc27d16700] name[0x103699.c7] pkey 151008.0\r\n   grant 0xb99d64f38 cvt 0x0 send 0x0@1,0 write 0x0,0@65536\r\n   flag 0x2 mdrole 0x1 mode 1 scan 0.0 role LOCAL\r\n   disk: 0x0000.00000000 write: 0x0000.00000000 cnt 0x0 hist 0x0\r\n   xid 0x0000.000.00000000 sid 1 pkwait 0s rmacks 0\r\n   refpcnt 0 weak: 0x0000.00000000\r\n   pkey 151008.0\r\n   hv 125 [stat 0x0, 1->1, wm 32768, RMno 0, reminc 36, dom 0]\r\n   kjga st 0x4, step 0.36.0, cinc 38, rmno 11161, flags 0x20\r\n   lb 16384, hb 32767, myb 18131, drmb 18131, apifrz 1\r\n   GCS SHADOW 0xb99d64f38,42 resp[0xbb93a40e8,0x103699.c7] pkey 151008.0\r\n     grant 1 cvt 0 mdrole 0x1 st 0x100 lst 0x40 GRANTQ rl LOCAL\r\n     master 1 owner 2 sid 1 remote[0x85fed2220,13] hist 0xb93e302087234c9f\r\n     history 0x1f.0x19.0xd.0x39.0x8.0x4.0xc.0x1f.0x39.0x1.\r\n     cflag 0x0 sender 0 flags 0x0 replay# 0 abast 0x0.x0.1 dbmap 0x0\r\n     disk: 0x0000.00000000 write request: 0x0000.00000000\r\n     pi scn: 0x0000.00000000 sq[0xbb93a4118,0xbb93a4118]\r\n     msgseq 0x1 updseq 0x0 reqids[13,0,0] infop 0x0 lockseq xf0d1\r\n   GCS SHADOW END\r\n GCS RESOURCE END\r\n----- End of Customized Incident Dump(s) -----\r\n*** 2012-04-17 04:26:44.478\r\ndbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)\r\n----- SQL Statement (None) -----\r\nCurrent SQL information unavailable - no cursor.\r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex      \r\nlocation             type     point                (? means dubious value)     \r\n-------------------- -------- -------------------- ----------------------------\r\nksedst1()+96         CALL     skdstdst()           FFFFFFFF7FFF4D20 ?\r\n                                                   100670460 ? 000000000 ?\r\n                                                   00000000A ? 000000001 ?\r\n                                                   10BD552E0 ?\r\nksedst()+60          CALL     ksedst1()            000000000 ? 000000001 ?\r\n                                                   00010C1D1 ? 00010C000 ?\r\n                                                   10C1CA000 ? 00010C1CA ?\r\ndbkedDefDump()+2032  CALL     ksedst()             000000000 ? 10B21A000 ?\r\n                                                   10B21AA90 ? 10C1D2000 ?\r\n                                                   00010B000 ? 00010C1D2 ?\r\ndbgexPhaseII()+1800  PTR_CALL dbkedDefDump()       000000003 ? 000000002 ?\r\n                                                   10A6ABAA8 ? 0000014B0 ?\r\n                                                   10C1C9000 ? 000000003 ?\r\ndbgexExplicitEndInc  CALL     dbgexPhaseII()       10C373D30 ?\r\n()+728                                             FFFFFFFF7A634920 ?\r\n                                                   FFFFFFFF7FFF90FC ?\r\n                                                   0018E0001 ? 10A6A2D98 ?\r\n                                                   000001C00 ?\r\ndbgeEndDDEInvocatio  CALL     dbgexExplicitEndInc  10A6A2C50 ?\r\nnImpl()+704                   ()                   FFFFFFFF7A634920 ?\r\n                                                   FFFFFFFF7FFF9048 ?\r\n                                                   FFFFFFFF7FFFC740 ?\r\n                                                   000000000 ?\r\n                                                   FFFFFFFFFE4E26A0 ?\r\nkjbmprlst()+13504    CALL     dbgeEndDDEInvocatio  10C373D30 ? 001B1D800 ?\r\n                              n()                  FFFFFFFFFEC0AF31 ?\r\n                                                   FFFFFFFF7FFFC740 ?\r\n                                                   0013F5000 ? 0018E0001 ?\r\nkjmxmpm()+796        PTR_CALL kjbmprlst()          101782000 ? 00010C1CA ?\r\n                                                   10C1EA000 ? 10C1CA000 ?\r\n                                                   10A6A3000 ? 10A6A3000 ?\r\nkjmpbmsg()+4584      CALL     kjmxmpm()            00010A400 ? 000000000 ?\r\n                                                   0852DA2C5 ? 00010C000 ?\r\n                                                   10A7EE000 ? BE22AF0C0 ?\r\nkjmsm()+11308        CALL     kjmpbmsg()           00010A400 ? 00000009C ?\r\n                                                   00010C000 ? 10A7EE000 ?\r\n                                                   000000001 ? 000000027 ?\r\nksbrdp()+1236        PTR_CALL kjmsm()              000001888 ? 25916872D1 ?\r\n                                                   000002000 ? 000000000 ?\r\n                                                   00000024B ? 000001000 ?\r\nopirip()+1008        CALL     ksbrdp()             10BB56000 ? BD8C0B680 ?\r\n                                                   000000001 ? 000001400 ?\r\n                                                   00010B800 ? 10AC212D8 ?\r\nopidrv()+780         CALL     opirip()             10A6A3000 ? 380013D50 ?\r\n                                                   000380002 ? 3800055C0 ?\r\n                                                   380002000 ? 00010C000 ?\r\nsou2o()+92           CALL     opidrv()             000000032 ? 000000004 ?\r\n                                                   FFFFFFFF7FFFF780 ?\r\n                                                   0001EA190 ?\r\n                                                   FFFFFFFF7AF42F10 ?\r\n                                                   FFFFFFFF7FFFFBB8 ?\r\nopimai_real()+516    CALL     sou2o()              FFFFFFFF7FFFF758 ?<\/pre>\n<p>\u53ef\u4ee5\u770b\u5230\uff0c\u4e24\u4e2aTRACE\u6587\u4ef6\u4e5f\u975e\u5e38\u63a5\u8fd1\uff0c\u800c\u4e14\u8fde\u62a5\u9519\u7684\u524d\u51e0\u4e2a\u5806\u6808\u51fd\u6570\u7684\u540d\u79f0\u90fd\u5b8c\u5168\u4e00\u6837\u3002<br \/>\n\u67e5\u8be2MOS\uff0c\u786e\u8ba4\u4e3aBug 12834027  ORA-600 [kjbmprlst:shadow] \/ ORA-600 [kjbrasr:pkey] with RAC read mostly locking\uff0c\u8fd9\u4e2a\u95ee\u9898\u5728\u6700\u65b0\u768411.2.0.3.1PSU\u4e2d\u88abFIXED\uff0c\u9664\u4e86\u6253\u8865\u4e01\u4e4b\u5916\uff0c\u8fd8\u53ef\u4ee5\u8003\u8651\u901a\u8fc7\u9690\u542b\u53c2\u6570&#8221;_gc_read_mostly_locking&#8221;=FALSE\u6765\u7981\u6b62READ-MOSTLY OBJECT LOCKING\u3002\u6b64\u5916\uff0c\u7981\u6b62DRM\u4e5f\u53ef\u4ee5\u907f\u514d\u8be5\u9519\u8bef\u7684\u4ea7\u751f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u8fd9\u4e24\u4e2a\u9519\u8bef\u662f\u7531\u540c\u4e00\u4e2aBUG\u5bfc\u81f4\u7684\u3002 \u6570\u636e\u5e93\u73af\u588311.2.0.2 RAC for Solaris sparc\uff0c\u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a 2012-01-29 06:15:10.168000 +08:00 Errors in file \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_lms3_81.trc (incident=384590): ORA-00600: internal error code, arguments: [kjbrref:pkey], [332269], [202], [137064], [0], [], [], [], [], [], [], [] Incident details in: \/app\/diag\/rdbms\/orcl\/orcl1\/incident\/incdir_384590\/orcl1_lms3_81_i384590.trc Use ADRCI or Support Workbench &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=843\">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":[490,714,713,712,177,8,180,715],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-dB","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/843"}],"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=843"}],"version-history":[{"count":2,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/843\/revisions"}],"predecessor-version":[{"id":846,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/843\/revisions\/846"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=843"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=843"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=843"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}