ORA-600 kdsgrp1

ORA-600 kdsgrp1

修复数据库后, 告警日志报错

Errors in file /home/oracle/app/oracle/admin/s10/udump/s10_ora_23209.trc:
ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], []

跟踪文件显示:

*** SESSION ID:(1620.1) 2009-01-25 02:21:07.036
row 0281ec7f.4a continuation at
file# 10 block# 126079 slot 75 not found
**************************************************
KDSTABN_GET: 0 ..... ntab: 1
curSlot: 75 ..... nrows: 74
**************************************************
*** 2009-01-25 02:21:07.043
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], []
Current SQL statement for this session:
SELECT ID, LOCAL_UID, BYTES_ID, CHECKSUM, MIME_TYPE, PHYSICAL_CONTENT_ID, ASSET_TYPE, SOURCE_URL FROM ASSET WHERE LOCAL_UID =
(SELECT LOCAL_UID FROM DP_FEED_IMAGE WHERE FEED_IMAGE_ID=:1 AND SOURCE_URL IS NOT NULL)
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+31 call ksedst1() 000000000 ? 000000001 ?
7FFF96BEC710 ? 7FFF96BEC770 ?
7FFF96BEC6B0 ? 000000000 ?
ksedmp()+610 call ksedst() 000000000 ? 000000001 ?
7FFF96BEC710 ? 7FFF96BEC770 ?
7FFF96BEC6B0 ? 000000000 ?
ksfdmp()+21 call ksedmp() 000000003 ? 000000001 ?
7FFF96BEC710 ? 7FFF96BEC770 ?
7FFF96BEC6B0 ? 000000000 ?
kgerinv()+161 call ksfdmp() 000000003 ? 000000001 ?
7FFF96BEC710 ? 7FFF96BEC770 ?
7FFF96BEC6B0 ? 000000000 ?
kgeasnmierr()+163 call kgerinv() 006217D40 ? 01B5B28B0 ?
7FFF96BEC770 ? 7FFF96BEC6B0 ?
000000000 ? 000000000 ?
kdsgrp()+764 call kgeasnmierr() 006217D40 ? 01B5B28B0 ?
7FFF96BEC770 ? 7FFF96BEC6B0 ?
000000000 ? 000000001 ?
kdsfbr()+228 call kdsgrp() 000000000 ? 000000000 ?
2B2815CA49B0 ? 7FFF96BEC6B0 ?
000000000 ? 000000001 ?
qertbFetchByRowID() call kdsfbr() 2B2815CA49B0 ? 00000004B ?
+895 000000000 ? 000000001 ?
000000000 ? 0000000FD ?
subsr1()+515 call qertbFetchByRowID() 066C88320 ? 000000000 ?
000000000 ? 000000001 ?
000000000 ? 0000000FD ?
evaopn2()+4067 call subsr1() 066C88010 ? 000000000 ?
000000000 ? 000000001 ?
000000000 ? 0000000FD ?
qerixTunnelGetKey() call evaopn2() 066C87F20 ? 2B2815CA4BB8 ?
+1030 000000000 ? 000000001 ?
2B2815CBF9C0 ? 0000000FD ?
qerixStart()+1293 call qerixTunnelGetKey() 066C87F20 ? 2B2815CA4BB8 ?
000000000 ? 000000001 ?
2B2815CBF9C0 ? 066C87F20 ?
qertbStart()+956 call qerixStart() 066C87AA0 ? 2B2815CA4BB8 ?
2B2815CAF000 ? 000000001 ?
2B2815CBF9C0 ? 066C87F20 ?
selexe()+667 call qertbStart() 066C878A8 ? 000000001 ?
2B2815CAF000 ? 2B2815CAF468 ?
000000000 ? 066C87F20 ?
opiexe()+4671 call selexe() 066C8BE28 ? 7FFF96BEEBA8 ?
7FFF96BEEBA8 ? 066C8BE28 ?
000000000 ? 066C87F20 ?
kpoal8()+2273 call opiexe() 000000049 ? 000000003 ?
7FFF96BEF070 ? 00000000E ?
000000000 ? 066C87F20 ?
opiodr()+984 call kpoal8() 00000005E ? 000000017 ?
7FFF96BF1F50 ? 00000000E ?
000000001 ? 066C87F20 ?
ttcpip()+1012 call opiodr() 00000005E ? 000000017 ?
7FFF96BF1F50 ? 00000000E ?
005444950 ? 066C87F20 ?
opitsk()+1322 call ttcpip() 00621FA10 ? 7FFF96BEFF38 ?
7FFF96BF1F50 ? 000000000 ?
7FFF96BF1A48 ? 7FFF96BF20B8 ?
opiino()+1026 call opitsk() 000000003 ? 000000000 ?
7FFF96BF1F50 ? 000000001 ?
000000000 ? 48E082200000001 ?
opiodr()+984 call opiino() 00000003C ? 000000004 ?
7FFF96BF3118 ? 000000000 ?
000000000 ? 48E082200000001 ?
opidrv()+547 call opiodr() 00000003C ? 000000004 ?
7FFF96BF3118 ? 000000000 ?
005444400 ? 48E082200000001 ?
sou2o()+114 call opidrv() 00000003C ? 000000004 ?
7FFF96BF3118 ? 000000000 ?
005444400 ? 48E082200000001 ?
opimai_real()+163 call sou2o() 7FFF96BF30F0 ? 00000003C ?
000000004 ? 7FFF96BF3118 ?
005444400 ? 48E082200000001 ?
main()+116 call opimai_real() 000000002 ? 7FFF96BF3180 ?
000000004 ? 7FFF96BF3118 ?
005444400 ? 48E082200000001 ?
__libc_start_main() call main() 000000002 ? 7FFF96BF3180 ?
+244 000000004 ? 7FFF96BF3118 ?
005444400 ? 48E082200000001 ?
_start()+41 call __libc_start_main() 0006E8898 ? 000000002 ?
7FFF96BF32D8 ? 000000000 ?
005444400 ? 000000002 ?

--------------------- Binary Stack Dump ---------------------
...

可能是因为表和索引数据不一致造成的

检验表结构
set time on timing on
analyze table s3test.asset validate structure cascade;
analyze table s3test.dp_feed_image validate structure cascade;

12:22:38 SQL> set time on timing on
12:22:44 SQL> analyze table s3test.asset validate structure cascade;

Table analyzed.

Elapsed: 00:16:52.28
12:39:37 SQL>
13:00:57 SQL> analyze table s3test.dp_feed_image validate structure cascade;
analyze table s3test.dp_feed_image validate structure cascade
*
ERROR at line 1:
ORA-01499: table/index cross reference failure - see trace file


Elapsed: 00:05:44.41
13:09:11 SQL>

跟踪文件显示

Table/Index row count mismatch
table 1022161 : index 1022167, 0
Index root = tsn: 11 rdba: 0x02c0dd0c

查询是哪个索引坏了
col segment_name for a30
select owner, segment_name, segment_type
from dba_segments
where header_file = dbms_utility.data_block_address_file(to_number('02c0dd0c','xxxxxxxxx'))
and header_block = dbms_utility.data_block_address_block(to_number('02c0dd0c','xxxxxxxxx'));

SQL> col segment_name for a30
SQL> select owner, segment_name, segment_type
from dba_segments
where header_file = dbms_utility.data_block_address_file(to_number('02c0dd0c','xxxxxxxxx'))
and header_block = dbms_utility.data_block_address_block(to_number('02c0dd0c','xxxxxxxxx'));
2 3 4
OWNER SEGMENT_NAME SEGMENT_TYPE
------------------------------ ------------------------------ ------------------
S3TEST DP_FC_LOCAL_UID INDEX

SQL>

重建索引
set time on timing on
alter index s3test.dp_fc_local_uid rebuild online;

SQL> set time on timing on
13:35:45 SQL> alter index s3test.dp_fc_local_uid rebuild online;

Index altered.

Elapsed: 00:00:18.17
13:36:07 SQL>

问题解决
analyze table s3test.dp_feed_image validate structure cascade;

13:36:23 SQL> analyze table s3test.dp_feed_image validate structure cascade;

Table analyzed.

Elapsed: 00:06:50.82
13:43:15 SQL>

外部链接:
ORA-600 [kdsgrp1]
ORA-1499. Table/Index row count mismatch




-fin-