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=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
這個問題對應的 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 Tables Brief Description: If you get ORA-600: [KKPOFPCD3] while doing merge partition online, then its likely that you have hit this bug. Rediscovery Notes If you get ORA-600: [KKPOFPCD3] while doing merge partition online, then its likely that you have hit this bug. Workaround NONE
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/31556440/viewspace-2684319/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 當心ORACLE 12.2 RAC新特性引入的BUG導致ORA-4031Oracle
- Oracle 12.2之後ALTER TABLE .. MODIFY轉換非分割槽表為分割槽表Oracle
- ORACLE 分割槽索引UNUSABLE導致的DML操作失敗引起的血案Oracle索引
- Oracle分割槽表基礎運維-07增加分割槽(2 HASH分割槽)Oracle運維
- Oracle分割槽表基礎運維-09刪除分割槽Oracle運維
- Oracle分割槽表基礎運維-05組合分割槽Oracle運維
- Oracle分割槽表基礎運維-02範圍分割槽Oracle運維
- Oracle分割槽表基礎運維-03HASH分割槽Oracle運維
- Oracle分割槽表基礎運維-07增加分割槽(1範圍分割槽)Oracle運維
- Oracle分割槽表基礎運維-04列表分割槽Oracle運維
- Oracle資料庫分割槽表SPLIT操作導致歸檔瘋漲Oracle資料庫
- Oracle分割槽表基礎運維-07增加分割槽(3列表分割槽)Oracle運維
- Oracle分割槽表基礎運維-06分割槽表索引Oracle運維索引
- [oracle] expdp 匯出分割槽表的分割槽Oracle
- Oracle分割槽表基礎運維-01分割槽表分類Oracle運維
- hash group by導致ORA-600
- Oracle分割槽表基礎運維-07增加分割槽(4 RANGE_HASH)Oracle運維
- Oracle分割槽表基礎運維-07增加分割槽(5RANGE_LIST)Oracle運維
- Oracle分割槽表基礎運維-07增加分割槽(6RANGE_RANGE)Oracle運維
- oracle分割槽表和分割槽表exchangeOracle
- 【ASK_ORACLE】Oracle 12.2 Bug導致網路卡出現故障後RAC庫未向TCP註冊本地VIP監聽OracleTCP
- oracle分割槽表和非分割槽表exchangeOracle
- oracle 分割槽表move和包含分割槽表的lob moveOracle
- Oracle分割槽表基礎運維-08Coalescing PartitionsOracle運維
- 分而治之：Oracle 18c及12.2分割槽新特性的N種優化實踐Oracle優化
- 重灌系統導致分割槽丟失的資料恢復案例資料恢復
- 【12.2】Oracle 12C R2新特性-外部表支援分割槽了（Partitioning External Tables）Oracle
- ORACLE分割槽表梳理系列Oracle
- 對oracle分割槽表的理解整理Oracle
- 伺服器重灌系統導致分割槽丟失的恢復方法伺服器
- Oracle12c：建立主分割槽、子分割槽，實現自動分割槽插入效果Oracle
- 重建Windows引導分割槽Windows
- Oracle 12.1.0.2 expdp匯出分割槽表資料遇到BUG慢的原因和解決方法Oracle
- 淺複製導致的bug
- 從10046看Oracle分割槽裁剪Oracle
- Oracle RAC日常運維-NetworkManager導致叢集故障Oracle運維
- oracle分割槽表的分類及測試Oracle
- 一個bug引發的Android分割槽儲存的思考Android