ORA-00600: [ktsscrsegfmt:objdchk_kcbnew_3]错误

wangzk0206

数据库： oracle11g 3节点RAC.
报错信息:  ORA-00600: internal error code, arguments: [ktsscrsegfmt:objdchk_kcbnew_3], [0], [273070], [4],
报错语句:
insert /*+append*/ into a select /*+parallel(t,4)*/ * from if_t t;
if_t是个外部表，不知道昨天晚上程序为什么会报这个错误，而现在执行这个语句又对了。


生成的trace文件如下：
LIncident 12425 created, dump file: /oracle/app/oracle/diag/rdbms/musicdw/musicdw3/incident/incdir_12425/musicdw3_ora_10682664_i12425.trc
ORA-00600: internal error code, arguments: [ktsscrsegfmt:objdchk_kcbnew_3], [0], [273070], [4], [], [], [], [], [], [], [], []

qerpxFetch
        rwsrid:2 pxid:1 qbas:0:err:600
----- Explain Plan Dump -----
----- Compact Format (Stream) -----


Dumping stream from 0 to 150
----------------------------------

0000: 143 137  23   1   1   0  25   0   0   0   1   0   0   0   0  54   9   4   6   7    ...............6....
0020:  30  10 106 131 240 131 241 224 168  38 227  54 224 168  38 227 131 245 131 243    ..j......&.6..&.....
0040:   1 131 243   2   2   2   2   3   2   1   1   4   0   0 143   7   2   2  89   0    ..................Y.
0060:   0   0   0 143 193  32 100   3   3  88  89  14 224  40  63 143  14 192 127 232    ..... d..XY..(?.....
0080: 225  51  70  88 131 232   4   5   6   0   0 143 193  32   4   4   4  90  53  14    .3FX......... ...Z5.
0100: 224  40  63 143  14 192 127 232 225  51  70  88 131 232   3   0 143 193  38 116    .(?......3FX......&t
0120:   5   5  69  24  14 224  40  63 143  14 192 127 232 225  51  70  88 131 232   2    ..E...(?......3FX...
0140:   1   7   8 196 152 233   1   4  14 142                                            ..........
----- Plan Table -----

============
Plan Table
===========

Liu Maclean(刘相兵

请把 /oracle/app/oracle/diag/rdbms/musicdw/musicdw3/incident/incdir_12425/musicdw3_ora_10682664_i12425.trc 和 alert.log 以附件形式上传

wangzk0206

刘大，我发邮件给你了。

Liu Maclean(刘相兵

今后不用发邮件了 直接上传附件

Liu Maclean(刘相兵

wangzk0206 发表于 2012-12-4 15:06
刘大，我发邮件给你了。

11.2.0.3.0+　 AIX　６.１　RAC

1. 
   
2. *** 2012-12-04 03:01:38.098
   
3. *** SESSION ID:(1435.6395) 2012-12-04 03:01:38.098
   
4. *** CLIENT ID:() 2012-12-04 03:01:38.098
   
5. *** SERVICE NAME:(musicdw) 2012-12-04 03:01:38.098
   
6. *** MODULE NAME:(python@db1 (TNS V1-V3)) 2012-12-04 03:01:38.098
   
7. *** ACTION NAME:() 2012-12-04 03:01:38.098
   
8. 
   
9. Dump continued from file: /oracle/app/oracle/diag/rdbms/musicdw/musicdw3/trace/musicdw3_ora_10682664.trc
   
10. ORA-00600: internal error code, arguments: [ktsscrsegfmt:objdchk_kcbnew_3], [0], [273070], [4], [], [], [], [], [], [], [], []
    
11. 
    
12.     SO: 0x700000393d66780, type: 4, owner: 0x7000003990ee390, flag: INIT/-/-/0x00 if: 0x3 c: 0x3
    
13.      proc=0x7000003990ee390, name=session, file=ksu.h LINE:12624 ID:, pg=0
    
14.     (session) sid: 1435 ser: 6395 trans: 0x70000038526a838, creator: 0x7000003990ee390
    
15.               flags: (0x8000045) USR/- flags_idl: (0x1) BSY/-/-/-/-/-
    
16.               flags2: (0x40009) -/-/INC
    
17.               DID: , short-term DID:
    
18.               txn branch: 0x0
    
19.               oct: 2, prv: 0, sql: 0x700000364fb9268, psql: 0x700000367db87d8, user: 89/SMELTER
    
20.     ksuxds FALSE at location: 0
    
21.     service name: musicdw
    
22.     client details:
    
23.       O/S info: user: etl, term: , ospid: 24772772
    
24.       machine: db1 program: python@db1 (TNS V1-V3)
    
25.       application name: python@db1 (TNS V1-V3), hash value=2797334376
    
26.     Current Wait Stack:
    
27.       Not in wait; last wait ended 1.989002 sec ago
    
28.     Wait State:
    
29.       fixed_waits=0 flags=0x21 boundary=0x0/-1
    
30.     Session Wait History:
    
31.         elapsed time of 1.989038 sec since last wait
    
32.      0: waited for 'Disk file operations I/O'
    
33.         FileOperation=0x5, fileno=0x0, filetype=0x3
    
34.         wait_id=1135 seq_num=1231 snap_id=2
    
35.         wait times: snap=0.000033 sec, exc=0.000498 sec, total=0.000787 sec
    
36.         wait times: max=infinite
    
37.         wait counts: calls=0 os=0
    
38.         occurred after 0.000000 sec of elapsed time
    
39.      1: waited for 'ASM file metadata operation'
    
40.         msgop=0x12, locn=0x0, =0x0
    
41.         wait_id=1136 seq_num=1230 snap_id=3
    
42.         wait times: snap=0.000002 sec, exc=0.000006 sec, total=0.000289 sec
    
43.         wait times: max=infinite
    
44.         wait counts: calls=0 os=0
    
45.         occurred after 0.000000 sec of elapsed time
    
46.      2: waited for 'KSV master wait'
    
47.         =0x0, =0x0, =0x0
    
48.         wait_id=1138 seq_num=1229 snap_id=1
    
49.         wait times: snap=0.000212 sec, exc=0.000212 sec, total=0.000212 sec
    
50.         wait times: max=infinite
    
51.         wait counts: calls=1 os=1
    
52.         occurred after 0.000000 sec of elapsed time
    
53.      3: waited for 'ASM file metadata operation'
    
54.         msgop=0x12, locn=0x0, =0x0
    
55.         wait_id=1136 seq_num=1228 snap_id=2
    
56.         wait times: snap=0.000002 sec, exc=0.000004 sec, total=0.000075 sec
    
57.         wait times: max=infinite
    
58. 
    
59. 
    
60.      SO: 0x70000031e3fb0b8, type: 78, owner: 0x700000393d66780, flag: INIT/-/-/0x00 if: 0x3 c: 0x3
    
61.        proc=0x7000003990ee390, name=LIBRARY OBJECT LOCK, file=kgl.h LINE:8548 ID:, pg=0
    
62. 
    
63.       LibraryObjectLock:  Address=70000031e3fb0b8 Handle=700000364fb9268 Mode=N CanBeBrokenCount=1 Incarnation=1 ExecutionCount=1         
    
64.         
    
65.         User=700000393d66780 Session=700000393d66780 ReferenceCount=1 Flags=CNB/[0001] SavepointNum=50bcf710
    
66.       LibraryHandle:  Address=700000364fb9268 Hash=46aee9cb LockMode=N PinMode=0 LoadLockMode=0 Status=VALD
    
67.         ObjectName:  Name=insert /*+append*/ into musicdw.ODS_SEARCH_N_SST select /*+parallel(t,4)*/ * from IF_ODS_SEARCH_N_SST_1207   t
    
68.           FullHashValue=808b4c289b6734cae065bc8546aee9cb Namespace=SQL AREA(00) Type=CURSOR(00) Identifier=1185868235 OwnerIdn=89
    
69.         Statistics:  InvalidationCount=3 ExecutionCount=4 LoadCount=5 ActiveLocks=1 TotalLockCount=8 TotalPinCount=1
    
70.         Counters:  BrokenCount=1 RevocablePointer=1 KeepDependency=1 BucketInUse=7 HandleInUse=7 HandleReferenceCount=0
    
71.         Concurrency:  DependencyMutex=700000364fb9318(0, 97, 0, 0) Mutex=700000364fb9398(0, 915, 1, 0)
    
72.         Flags=RON/PIN/TIM/PN0/DBN/[10012841]
    
73.         WaitersLists:  
    
74.           Lock=700000364fb92f8[700000364fb92f8,700000364fb92f8]
    
75.           Pin=700000364fb92d8[700000364fb92d8,700000364fb92d8]
    
76.           LoadLock=700000364fb9350[700000364fb9350,700000364fb9350]
    
77.         Timestamp:  Current=11-30-2012 03:01:32
    
78.         HandleReference:  Address=700000364fb9470 Handle=0 Flags=[00]
    
79.         LibraryObject:  Address=7000003632592b0 HeapMask=0000-0001-0001-0000 Flags=EXS[0000] Flags2=[0000] PublicFlags=[0000]
    
80.           ChildTable:  size='16'
    
81.             Child:  id='0' Table=70000036325a160 Reference=700000363259bb0 Handle=700000364fb5480
    
82.         NamespaceDump:  
    
83.           Parent Cursor:  sql_id=f0tdwhp3axufb parent=700000363259350 maxchild=1 plk=y ppn=n   
    

复制代码

该session当时在运行 insert /*+append*/ into musicdw.ODS_SEARCH_N_SST select /*+parallel(t,4)*/ * from IF_ODS_SEARCH_N_SST_1207   t  并 出现 ORA-600  [ktsscrsegfmt:objdchk_kcbnew_3]

stack call 为

ktssctr_segment=> ktssctr_segment1=>ktsscrseg=>ktsscrsegfmt=>kcbnew=>dbgeEndDDEInvocation报错

Liu Maclean(刘相兵

BUG 11936157 - ORA 600 [KTSSCRSEGFMT:OBJDCHK_KCBNEW_3] ON CREATE INDEX NOLOGGING

该BUG似乎只在 PARALLEL并行执行情况下触发 ， 已知该BUG在11.2.0.2 上发生，11.2.0.3 认为已修复，但是你在11.2.0.3 上仍遇到。


方案：

1. LOG 一个SR 要求FIX


Workaround:

1.考虑降低并行度或者 不并行绕过该问题

wangzk0206

谢谢刘大回复