ext4_dx_add_entry:2024: Directory index full!
http://blog.chinaunix.net/uid-23284114-id-5749136.html
巡檢時，一臺oracle資料庫作業系統/var/log/message日誌中有大量如下warning：
Aug 4 09:18:23 your_hostname kernel: EXT4-fs warning (device sda5): ext4_dx_add_entry:2024: Directory index full!
Aug 4 09:18:23 your_hostname kernel: EXT4-fs warning (device sda5): ext4_dx_add_entry:2024: Directory index full!
Aug 4 09:18:23 your_hostname kernel: EXT4-fs warning (device sda5): ext4_dx_add_entry:2024: Directory index full!
Aug 4 09:18:25 your_hostname kernel: EXT4-fs warning (device sda5): ext4_dx_add_entry:2024: Directory index full!
Aug 4 09:18:25 your_hostname kernel: EXT4-fs warning (device sda5): ext4_dx_add_entry:2024: Directory index full!
Aug 4 09:18:25 your_hostname kernel: EXT4-fs warning (device sda5): ext4_dx_add_entry:2024: Directory index full!
Aug 4 09:18:25 your_hostname kernel: EXT4-fs warning (device sda5): ext4_dx_add_entry:2024: Directory index full!
Aug 4 09:18:25 your_hostname kernel: EXT4-fs warning (device sda5): ext4_dx_add_entry:2024: Directory index full!
產生warning原因如下：
單個目錄下的子目錄和檔案超過64k個。
經排查，Oracle的adump目錄下有9113975個.aud檔案，將檔案刪除後，warning不再產生。
涉及命令：
1) 統計當前資料夾下檔案的個數
ls -l |grep "^-"|wc -l
2) 統計當前資料夾下目錄的個數
ls -l |grep "^d"|wc -l
3) 統計當前資料夾下檔案的個數，包括子資料夾裡的
ls -lR|grep "^-"|wc -l
4) 統計資料夾下目錄的個數，包括子資料夾裡的
ls -lR|grep "^d"|wc -l
巡檢時，一臺oracle資料庫作業系統/var/log/message日誌中有大量如下warning：
Aug 4 09:18:23 your_hostname kernel: EXT4-fs warning (device sda5): ext4_dx_add_entry:2024: Directory index full!
Aug 4 09:18:23 your_hostname kernel: EXT4-fs warning (device sda5): ext4_dx_add_entry:2024: Directory index full!
Aug 4 09:18:23 your_hostname kernel: EXT4-fs warning (device sda5): ext4_dx_add_entry:2024: Directory index full!
Aug 4 09:18:25 your_hostname kernel: EXT4-fs warning (device sda5): ext4_dx_add_entry:2024: Directory index full!
Aug 4 09:18:25 your_hostname kernel: EXT4-fs warning (device sda5): ext4_dx_add_entry:2024: Directory index full!
Aug 4 09:18:25 your_hostname kernel: EXT4-fs warning (device sda5): ext4_dx_add_entry:2024: Directory index full!
Aug 4 09:18:25 your_hostname kernel: EXT4-fs warning (device sda5): ext4_dx_add_entry:2024: Directory index full!
Aug 4 09:18:25 your_hostname kernel: EXT4-fs warning (device sda5): ext4_dx_add_entry:2024: Directory index full!
產生warning原因如下：
單個目錄下的子目錄和檔案超過64k個。
經排查，Oracle的adump目錄下有9113975個.aud檔案，將檔案刪除後，warning不再產生。
涉及命令：
1) 統計當前資料夾下檔案的個數
ls -l |grep "^-"|wc -l
2) 統計當前資料夾下目錄的個數
ls -l |grep "^d"|wc -l
3) 統計當前資料夾下檔案的個數，包括子資料夾裡的
ls -lR|grep "^-"|wc -l
4) 統計資料夾下目錄的個數，包括子資料夾裡的
ls -lR|grep "^d"|wc -l
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/31397003/viewspace-2153463/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- rowid,index,INDEX FULL SCAN,INDEX FAST FULL SCAN|IndexAST
- Index Full Scan vs Index Fast Full ScanIndexAST
- Index Full Scans和Index Fast Full ScansIndexAST
- Index Full Scan 與 Index Fast Full ScanIndexAST
- INDEX UNIQUE SCAN，INDEX FULL SCAN和INDEX FAST FULL SCANIndexAST
- Index的掃描方式：index full scan/index fast full scanIndexAST
- INDEX FULL SCAN和INDEX FAST FULL SCAN區別IndexAST
- index full scan 和 index FAST full scan 區別IndexAST
- Index Full Scan 與 Index Fast Full Scan (Final)IndexAST
- INDEX FULL SCAN和INDEX FAST FULL SCAN的區別IndexAST
- index full scan 和 index fast full scan （IFS,FFS）的不同IndexAST
- Index Full Scan和Index Fast Full Scan行為差異分析（上）IndexAST
- Index Full Scan和Index Fast Full Scan行為差異分析（下）IndexAST
- MySQL 建表DATA DIRECTORY 、INDEX DIRECTORY 簡介MySqlIndex
- index fast full scan 和 nullIndexASTNull
- Fast full index scan 淺析ASTIndex
- 收集full table / index scan sqlIndexSQL
- Fast Full Index Scans的特點！ASTIndex
- [總結]關於index range scans & INDEX (FAST FULL SCAN)IndexAST
- oracle hint之full,index,index_asc,index_desc,index_combile示例OracleIndex
- index range scan,index fast full scan,index skip scan發生的條件IndexAST
- 【SqlServer】管理全文索引（FULL TEXT INDEX）SQLServer索引Index
- FBI? MAX? INDEX FULL SCAN (MIN/MAX)?Index
- SELECT COUNT(*) 索引會走 index fast full scan索引IndexAST
- Oracle學習系列—資料庫最佳化—Full Scans和Fast Full Index ScansOracle資料庫ASTIndex
- 【優化】INDEX FULL SCAN (MIN/MAX)訪問路徑優化Index
- index fast full scan不能使用並行的實驗IndexAST並行
- 【最佳化】INDEX FULL SCAN (MIN/MAX)訪問路徑Index
- 【TUNE_ORACLE】列出走了INDEX FULL SCAN的SQL參考OracleIndexSQL
- oracle實驗記錄（INDEX fast full scan 的成本計算）OracleIndexAST
- 20180316不使用INDEX FULL SCAN (MIN/MAX)Index
- (轉)索引掃描還是全表掃描（Index Scan Or Full Table Scan）索引Index
- 轉)索引掃描還是全表掃描（Index Scan Or Full Table Scan）索引Index
- zookeeper報錯 service not available now, maybe disk full, CL: 0.95 CQ: 0.95 INDEX: 0.95, maybeAIIndex
- Oracle ASM User Directory and Group DirectoryOracleASM
- 【SQLServer】Filegroup is fullSQLServer
- create directory in OracleOracle
- oracle full database backupOracleDatabase