Oracle 12.2 BUG :分区维护导致的 ORA-600 KKPOFPCD3
发表于:2024-10-23 作者:千家信息网编辑
千家信息网最后更新 2024年10月23日,原文链接: https://www.modb.pro/db/23449?xy摘要:在 Oracle 12.2 中,因为在线的分区合并、维护等工作导致了一个BUG的引入。在 Oracle 12.2 中,
千家信息网最后更新 2024年10月23日Oracle 12.2 BUG :分区维护导致的 ORA-600 KKPOFPCD3
原文链接: https://www.modb.pro/db/23449?xy
摘要:在 Oracle 12.2 中,因为在线的分区合并、维护等工作导致了一个BUG的引入。在 Oracle 12.2 中,因为在线的分区合并、维护等工作导致了一个BUG的引入。
错误是 ORA-600 错误体现出来的,错误信息类似如下:
ORA-00600: internal error code, arguments: [kkpofpcd3], [], [], [], [], [], [], [], [], [], [], []
引发错误的SQL类似如下:
----- 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]
关键的错误信息如下,核心是 Fetch Partnum DictNum 这部分:
========= 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=0ocd=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 = 0kkpodDumpOcd end: hd=0
这个问题对应的 BUG是:
Bug 25583657 ALTER TABLE MERGE PARTITIONS ONLINE MAY FAIL WITH ORA-600: [KKPOFPCD3]
这个 BUG 在 18.1 中被修正,官方的描述如下:
Description
This bug is only relevant when using Partitioned TablesBrief Description:If you get ORA-600: [KKPOFPCD3] while doing merge partition online, then its likely that you have hit this bug. Rediscovery NotesIf you get ORA-600: [KKPOFPCD3] while doing merge partition online, then its likely that you have hit this bug. WorkaroundNONE
错误
信息
在线
工作
关键
原文
官方
摘要
核心
链接
问题
数据库的安全要保护哪些东西
数据库安全各自的含义是什么
生产安全数据库录入
数据库的安全性及管理
数据库安全策略包含哪些
海淀数据库安全审计系统
建立农村房屋安全信息数据库
易用的数据库客户端支持安全管理
连接数据库失败ssl安全错误
数据库的锁怎样保障安全
英语角主题软件开发
学校网络安全监测预警通报落实
天津腾讯网络技术有限
cdn测试服务器
校园网络安全隐患及解决方案
厦门检测设备软件开发
dell 服务器开机f1
免费软件开发服务好不好
商场疫情防控数据库需求分析
网络安全的主要问题是什么
云服务软件开发
曙光服务器管理口用户密码
内蒙古水性软件开发发展现状
服务器主机一直滴滴响不开机
数据库表分区怎么分
埃森哲软件开发岗位面试
网络安全中命名实体识别算法
东莞微商软件开发哪家好
大学生对于软件开发的目标
服务器连电脑网线插哪个口
电力系统软件开发 上市公司
网络安全构成体系中的响应
哪个服务器的英雄联盟人多
在国内服务器
上海傲玩网络技术有限公司电话
上海软件开发有前景吗
闵行区网络技术开发介绍
数据库的事物用法
软件开发工作计划及任务分解
系统调出数据库表关系图