暂无图片
返回问答列表
分享
gelyon
2020-03-31
ora-600 [kkpofpcd3]
oracle

AIX下，一套oracleRAC 12.2.0.1.191015，在数据库自动收集统计信息的时候，后台alert日志报错：
Incident 216419 created, dump file: /u01/app/oracle/diag/rdbms/cctestdb/cctestdb4/incident/incdir_216419/cctestdb4_j001_13370288_i216419.trc
ORA-00600: internal error code, arguments: [kkpofpcd3], [], [], [], [], [], [], [], [], [], [], []
ORA-06512: at “SYS.DBMS_STATS”, line 1690
ORA-06512: at “SYS.DBMS_STATS”, line 15275
ORA-06512: at “SYS.DBMS_STATS”, line 27774
ORA-06512: at “SYS.DBMS_STATS”, line 37263
ORA-06512: at “SYS.DBMS_STATS”, line 47109
ORA-06512: at “SYS.DBMS_STATS”, line 47175

trc跟踪文件分析，就是在进行数据库统计信息收集过程发生的ORA600.
估计是命中了bug，mos上我查了只找到Bug 25583657 - ALTER TABLE MERGE PARTITIONS ONLINE MAY FAIL WITH ORA-600: [KKPOFPCD3] (Doc ID 25583657.8) ，感觉不是很相似

收藏
分享
6条回答
默认
最新
gelyon
上传附件：cctestdb4_j001_13370288_i216417.rar
暂无图片 评论
暂无图片 有用 0
盖国强

命中了 BUG：
Bug 25583657 ALTER TABLE MERGE PARTITIONS ONLINE MAY FAIL WITH ORA-600: [KKPOFPCD3]

fetched: partnum=0, dictnum=98, objn=63117

在 Fetch Partion Num 和切换时发生了错误，在 18c 中修复了。

*** 2020-03-29T22:19:10.011884+08:00
*** SESSION ID:(1569.3211) 2020-03-29T22:19:10.011901+08:00
*** CLIENT ID:() 2020-03-29T22:19:10.011909+08:00
*** SERVICE NAME:(SYS$USERS) 2020-03-29T22:19:10.011916+08:00
*** MODULE NAME:(DBMS_SCHEDULER) 2020-03-29T22:19:10.011925+08:00
*** ACTION NAME:(ORA$AT_OS_OPT_SY_565) 2020-03-29T22:19:10.011933+08:00
*** CLIENT DRIVER:() 2020-03-29T22:19:10.011941+08:00
*** CONTAINER ID:(1) 2020-03-29T22:19:10.011949+08:00
 
[TOC00000]
Jump to table of contents
Dump continued from file: /u01/app/oracle/diag/rdbms/cctestdb/cctestdb4/trace/cctestdb4_j001_13370288.trc
[TOC00001]
ORA-00600: internal error code, arguments: [kkpofpcd3], [], [], [], [], [], [], [], [], [], [], []

[TOC00001-END]
[TOC00002]
========= Dump for incident 216417 (ORA 600 [kkpofpcd3]) ========
[TOC00003]
----- Beginning of Customized Incident Dump(s) -----
fetched: partnum=0, dictnum=98, objn=63117
  Owner              = 0
  Name               = WRH$_FILESTATXS_PK
  SubName            = WRH$_FILESTATXS_1263135530_266
  objn_kkpacfrag     = 63117
  objd_kkpacfrag     = 63117
  tsn_kkpacfrag      = 1
  dba_kkpacfrag      = 0x00000000
  fragnum_kkpacfrag  = 0
  dictnum_kkpacfrag  = 98
  status_kkpacfrag   = 0x0
  flags_kkpacfrag    = 0x0
  fragtype_kkpacfrag = 0
  hibnd_kkpacfrag    = "MAXVALUE, MAXVALUE"
  bhibnd_kkpacfrag   : len=0, key=
kkpodDumpOcd begin: hd=0
ocd=7000101de49eba0
    parttype_kkpacocd    = 1
    subptype_kkpacocd    = 0
    partcnt_kkpacocd     = 10
    flags_kkpacocd       = 0x3
    mflags_kkpacocd      = 0x0
    status_kkpacocd      = 0x0
    hidPartcnt_kkpacocd  = 0
    hasSageTsn_kkpacocd  = 0
    hasExadoopTsn_kkpaco = 0
    noDMOffload_kkpacocd = 0
    noDIDTSOffload_kkpac = 0
    noXMLOffload_kkpacoc = 0
    noJSONOffload_kkpaco = 0
    noVGBYOffload_kkpaco = 0
    partKCols_kkpacocd:
        colCnt=2
        [0] id=2, knl=2, dty=2, usr=2, csid=0, csform=0
        [1] id=1, knl=1, dty=2, usr=1, csid=0, csform=0
    pcd=7000101de49f080, partnum=1, dictnum=10, objn=62637
        Owner              = 0
        Name               = WRH$_FILESTATXS_PK
        SubName            = WRH$_FILESTATXS_1263135530_0
        objn_kkpacfrag     = 62637
        objd_kkpacfrag     = 62637
        tsn_kkpacfrag      = 1
        dba_kkpacfrag      = 0x00c17b12
        fragnum_kkpacfrag  = 1
        dictnum_kkpacfrag  = 10
        status_kkpacfrag   = 0x0
        flags_kkpacfrag    = 0x0
        fragtype_kkpacfrag = 1
        hibnd_kkpacfrag    = "1263135530, 30"
        bhibnd_kkpacfrag   : len=0, key=
        subpcnt_kkpacpcd   = 0
        status_kkpacpcd    = 0
    pcd=7000101de49f218, partnum=2, dictnum=11, objn=62900
        Owner              = 0
        Name               = WRH$_FILESTATXS_PK
        SubName            = WRH$_FILESTATXS_1263135530_30
        objn_kkpacfrag     = 62900
        objd_kkpacfrag     = 62900
        tsn_kkpacfrag      = 1
        dba_kkpacfrag      = 0x00c2489a
        fragnum_kkpacfrag  = 2
        dictnum_kkpacfrag  = 11
        status_kkpacfrag   = 0x0
        flags_kkpacfrag    = 0x0
        fragtype_kkpacfrag = 1
        hibnd_kkpacfrag    = "1263135530, 76"
        bhibnd_kkpacfrag   : len=0, key=
        subpcnt_kkpacpcd   = 0
        status_kkpacpcd    = 0
    pcd=7000101de49f3b0, partnum=3, dictnum=13, objn=62901
        Owner              = 0
        Name               = WRH$_FILESTATXS_PK
        SubName            = WRH$_FILESTATXS_1263135530_76
        objn_kkpacfrag     = 62901
        objd_kkpacfrag     = 62901
        tsn_kkpacfrag      = 1
        dba_kkpacfrag      = 0x00c248a2
        fragnum_kkpacfrag  = 3
        dictnum_kkpacfrag  = 13
        status_kkpacfrag   = 0x0
        flags_kkpacfrag    = 0x0
        fragtype_kkpacfrag = 1
        hibnd_kkpacfrag    = "1263135530, MAXVALUE"
        bhibnd_kkpacfrag   : len=0, key=
        subpcnt_kkpacpcd   = 0
        status_kkpacpcd    = 0
    pcd=7000101de49f550, partnum=4, dictnum=22, objn=63066
        Owner              = 0
        Name               = WRH$_FILESTATXS_PK
        SubName            = WRH$_FILESTATXS_MXDB_MXSN
        objn_kkpacfrag     = 63066
        objd_kkpacfrag     = 63066
        tsn_kkpacfrag      = 1
        dba_kkpacfrag      = 0x00c2806a
        fragnum_kkpacfrag  = 4
        dictnum_kkpacfrag  = 22
        status_kkpacfrag   = 0x0
        flags_kkpacfrag    = 0x0
        fragtype_kkpacfrag = 1
        hibnd_kkpacfrag    = "1263135530, 122"
        bhibnd_kkpacfrag   : len=0, key=
        subpcnt_kkpacpcd   = 0
        status_kkpacpcd    = 0
    pcd=7000101de49f6e8, partnum=5, dictnum=33, objn=63076
        Owner              = 0
        Name               = WRH$_FILESTATXS_PK
        SubName            = WRH$_FILESTATXS_1263135530_122
        objn_kkpacfrag     = 63076
        objd_kkpacfrag     = 63076
        tsn_kkpacfrag      = 1
        dba_kkpacfrag      = 0x00c2807a
        fragnum_kkpacfrag  = 5
        dictnum_kkpacfrag  = 33
        status_kkpacfrag   = 0x0
        flags_kkpacfrag    = 0x0
        fragtype_kkpacfrag = 1
        hibnd_kkpacfrag    = "1263135530, 146"
        bhibnd_kkpacfrag   : len=0, key=
        subpcnt_kkpacpcd   = 0
        status_kkpacpcd    = 0
    pcd=7000101de49f880, partnum=6, dictnum=44, objn=63080
        Owner              = 0
        Name               = WRH$_FILESTATXS_PK
        SubName            = WRH$_FILESTATXS_1263135530_146
        objn_kkpacfrag     = 63080
        objd_kkpacfrag     = 63080
        tsn_kkpacfrag      = 1
        dba_kkpacfrag      = 0x00c2870a
        fragnum_kkpacfrag  = 6
        dictnum_kkpacfrag  = 44
        status_kkpacfrag   = 0x0
        flags_kkpacfrag    = 0x0
        fragtype_kkpacfrag = 1
        hibnd_kkpacfrag    = "1263135530, 170"
        bhibnd_kkpacfrag   : len=0, key=
        subpcnt_kkpacpcd   = 0
        status_kkpacpcd    = 0
    pcd=7000101de4a1468, partnum=7, dictnum=55, objn=63084
        Owner              = 0
        Name               = WRH$_FILESTATXS_PK
        SubName            = WRH$_FILESTATXS_1263135530_170
        objn_kkpacfrag     = 63084
        objd_kkpacfrag     = 63084
        tsn_kkpacfrag      = 1
        dba_kkpacfrag      = 0x00c2871a
        fragnum_kkpacfrag  = 7
        dictnum_kkpacfrag  = 55
        status_kkpacfrag   = 0x0
        flags_kkpacfrag    = 0x0
        fragtype_kkpacfrag = 1
        hibnd_kkpacfrag    = "1263135530, 194"
        bhibnd_kkpacfrag   : len=0, key=
        subpcnt_kkpacpcd   = 0
        status_kkpacpcd    = 0
    pcd=7000101de4a1600, partnum=8, dictnum=66, objn=63088
        Owner              = 0
        Name               = WRH$_FILESTATXS_PK
        SubName            = WRH$_FILESTATXS_1263135530_194
        objn_kkpacfrag     = 63088
        objd_kkpacfrag     = 63088
        tsn_kkpacfrag      = 1
        dba_kkpacfrag      = 0x00c295ba
        fragnum_kkpacfrag  = 8
        dictnum_kkpacfrag  = 66
        status_kkpacfrag   = 0x0
        flags_kkpacfrag    = 0x0
        fragtype_kkpacfrag = 1
        hibnd_kkpacfrag    = "1263135530, 218"
        bhibnd_kkpacfrag   : len=0, key=
        subpcnt_kkpacpcd   = 0
        status_kkpacpcd    = 0
    pcd=7000101de4a1798, partnum=9, dictnum=77, objn=63112
        Owner              = 0
        Name               = WRH$_FILESTATXS_PK
        SubName            = WRH$_FILESTATXS_1263135530_218
        objn_kkpacfrag     = 63112
        objd_kkpacfrag     = 63112
        tsn_kkpacfrag      = 1
        dba_kkpacfrag      = 0x00c299a2
        fragnum_kkpacfrag  = 9
        dictnum_kkpacfrag  = 77
        status_kkpacfrag   = 0x0
        flags_kkpacfrag    = 0x0
        fragtype_kkpacfrag = 1
        hibnd_kkpacfrag    = "1263135530, 242"
        bhibnd_kkpacfrag   : len=0, key=
        subpcnt_kkpacpcd   = 0
        status_kkpacpcd    = 0
    pcd=7000101de4a1930, partnum=10, dictnum=88, objn=63116
        Owner              = 0
        Name               = WRH$_FILESTATXS_PK
        SubName            = WRH$_FILESTATXS_1263135530_242
        objn_kkpacfrag     = 63116
        objd_kkpacfrag     = 63116
        tsn_kkpacfrag      = 1
        dba_kkpacfrag      = 0x00c299c2
        fragnum_kkpacfrag  = 10
        dictnum_kkpacfrag  = 88
        status_kkpacfrag   = 0x0
        flags_kkpacfrag    = 0x0
        fragtype_kkpacfrag = 1
        hibnd_kkpacfrag    = "1263135530, 266"
        bhibnd_kkpacfrag   : len=0, key=
        subpcnt_kkpacpcd   = 0
        status_kkpacpcd    = 0
kkpodDumpOcd end: hd=0
----- End of Customized Incident Dump(s) -----
[TOC00003-END]

*** 2020-03-29T22:19:10.018710+08:00
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
[TOC00004]
----- Current SQL Statement for this session (sql_id=c3zymn7x3k6wy) -----
select obj#, dataobj#, part#, hiboundlen, hiboundval, flags, ts#, file#, block#, pctfree$, initrans, maxtrans, analyzetime, samplesize, rowcnt, blevel, leafcnt, distkey, lblkkey, dblkkey, clufac, pctthres$, length(bhiboundval), bhiboundval from indpart$ where bo# = :1 order by part#
[TOC00005]
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
70001019dada7a8      1690  package body SYS.DBMS_STATS.SET_INDEX_STATS_CALLOUT
70001019dada7a8     15275  package body SYS.DBMS_STATS.SET_INDEX_STATS_AUX
70001019dada7a8     27774  package body SYS.DBMS_STATS.GATHER_INDEX_STATS_AUX
70001019dada7a8     37263  package body SYS.DBMS_STATS.GATHER_GROUP_STATS
70001019dada7a8     47109  package body SYS.DBMS_STATS.GATHER_DB_STATS_JOB_PROC_AUX
70001019dada7a8     47175  package body SYS.DBMS_STATS.GATHER_DATABASE_STATS_JOB_PROC
[TOC00005-END]
暂无图片 评论
暂无图片 有用 0
gelyon

谢谢盖总，我当时也时认为是命中了这个bug，但表现形式跟Bug 25583657有点差异，Mos上说Bug 25583657是在分区表alter partition切换的时候发生，我这个感觉是在分区的索引WRH$_FILESTATXS_PK上的问题，所以当时不敢确定。

暂无图片 评论
暂无图片 有用 0
盖国强

分区自动维护时就可能发生，主要是在分区不可见和可见的切换中出现了 BUG，这一类有很多种情况。

不一定和确定 BUG 的情形完全相同，但是，属于同一个问题。

暂无图片 评论
暂无图片 有用 0
gelyon

嗯，知道了，谢谢老大

暂无图片 评论
暂无图片 有用 0
gelyon
问题已关闭: 问题已经得到解决
暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
附件列表
请登录之后查看
邀请回答
暂无人订阅该标签，敬请期待~~
暂无图片墨值悬赏