[#QA-27] ORA-00600 [kcbgcur_1] by PQ operation.

Questions & Answers

ORA-00600 [kcbgcur_1] by PQ operation.

Created: 15/Jul/07 05:56 PM Updated: 16/Sep/07 04:25 PM

Fix Version/s:

None

Product Version:	8.1.6.1.0
Operating System:	Linux
Operating System Version:	2.2.14-5.0

Description

« Hide

ORA-00600 [kcbgcur_1] by PQ operation.

All

Comments

Change History

Sort Order:

Ascending order - Click to sort in descending order

[ Permlink | « Hide ]

ubTools Support - 15/Jul/07 05:59 PM

Error code:

ORA-00600: internal error code, arguments: [kcbgcur_1], [], [], [], [], [], [], []

Oracle kernel function from which the problem is raised:

kcbgcur().

This function is a function of Oracle Cache Layer.

Undo block dump:

UNDO BLK:  
xid: 0x0005.05e.000000c4  seq: 0x8c  cnt: 0x31  irb: 0x19  icl: 0x0   flg: 0x0000

Rec Offset      Rec Offset      Rec Offset      Rec Offset      Rec Offset
---------------------------------------------------------------------------
0x01 0x1f38     0x02 0x1e88     0x03 0x1de4     0x04 0x1d3c     0x05 0x1c94    
0x06 0x1bf4     0x07 0x1b54     0x08 0x1ac4     0x09 0x1a20     0x0a 0x1978    
0x0b 0x18d4     0x0c 0x1820     0x0d 0x1784     0x0e 0x16e0     0x0f 0x1638    
0x10 0x1598     0x11 0x14e8     0x12 0x1448     0x13 0x13a4     0x14 0x1308    
0x15 0x126c     0x16 0x11d0     0x17 0x112c     0x18 0x1084     0x19 0x0fe0    
0x1a 0x0f0c     0x1b 0x0e60     0x1c 0x0db8     0x1d 0x0d28     0x1e 0x0c90    
0x1f 0x0bf0     0x20 0x0b28     0x21 0x0a88     0x22 0x09ec     0x23 0x0950    
0x24 0x08ac     0x25 0x0814     0x26 0x077c     0x27 0x06e4     0x28 0x0650    
0x29 0x05b4     0x2a 0x0524     0x2b 0x0480     0x2c 0x03f4     0x2d 0x035c    
0x2e 0x02c0     0x2f 0x0230     0x30 0x01a0     0x31 0x0108
...
*-----------------------------
* Rec #0x19  slt: 0x5e  objn: 0(0x00000000)  objd: 0  tblspc: 0(0x00000000)
*       Layer:  11 (Row)   opc: 1   rci 0x18  
Undo type:  Regular undo   Last buffer split:  No
Temp Object:  No
Tablespace Undo:  No
rdba: 0x00000000
*-----------------------------
KDO undo record:
KTB Redo
op: 0x02  ver: 0x01  
op: C  uba: 0x00c0083d.008c.18
KDO Op code: IRP  xtype: XA  bdba: 0x0040760a  hdba: 0x004075d9
itli: 1  ispac: 0  maxfr: 4863
tabn: 0 slot: 130(0x82) size/delt: 56
fb: --H-FL-- lb: 0x0 cc: 4
null: ----
col  0: [ 3]  37 34 34
col  1: [20]  45 6c 65 63 74 72 6f 6e 69 63 20 73 74 72 75 63 74 75 72 65
col  2: [ 0]
col  3: [ 0]
*-----------------------------
...

Problem explanation:

irb points the first undo record in undo block to begin rollback. So, the record 0x19 is your first undo record. The object number of the block, and the object number of the block undo applied to are 0. I think this may be your problem. Oracle may not be able to know the real object number during this rollback.

Bug:

It looks like:

Bug:984947 A PARALLEL QUERY SLAVE GOT ORA-600[KCBGCUR_1]

[ Show » ]