GaussDB-GLOBAL_BAD_BLOCK_INFO
GLOBAL_BAD_BLOCK_INFO is executed on the CN to collect statistics on damaged data pages of all instances. The queried result displays basic information about damaged pages. The execution result on the DN is empty. Based on the information, you can use the page detection and repair function in Data Damage Detection and Repair Functions to perform further repair operations. By default, only initial users, users with the system administrator permission, users with the O&M administrator permission in the O&M mode, and monitoring users can view the information. Other users can view the information only after being granted with permissions.
| Name | Type | Description |
|---|---|---|
| node_name | text | Node information of the damaged page. |
| spc_node | oid | ID of the tablespace corresponding to the damaged page. |
| db_node | oid | ID of the database corresponding to the damaged page. |
| rel_node | oid | relfilenode of the relation corresponding to the damaged page. |
| bucket_node | integer | Bucket node of the damaged page. This column is used to specify whether a table is a segment-page table during repair.- -1: non-segment page table. |
- Non-zero value: segment-page table. | | block_num | oid | Number of the damaged page. | | fork_num | integer | File forknum of the damaged page. | | file_path | text | Relative path of the damaged page. The logical path instead of the actual file is displayed for a segment-page table. | | check_time | timestamp with time zone | Time when a fault is detected on the damaged page. | | repair_time | timestamp with time zone | Time when the damaged page is repaired. |
更多详情请参考GaussDB 文档中心：doc.hcs.huawei.com/db/zh-cn/ga…
