加入 Gitee

与超过 1200万开发者一起发现、参与优秀开源项目，私有仓库也完全免费：）

克隆/下载

GLOBAL_STAT_BAD_BLOCK.md 8.04 KB

# GLOBAL\_STAT\_BAD\_BLOCK<a name="ZH-CN_TOPIC_0245374718"></a>

获得各节点的表、索引等文件的读取失败信息。

**表 1**  GLOBAL\_STAT\_BAD\_BLOCK字段

<a name="zh-cn_topic_0237122614_table18298154691411"></a>
<table><thead align="left"><tr id="zh-cn_topic_0237122614_row123931646151415"><th class="cellrowborder" valign="top" width="18.61%" id="mcps1.2.4.1.1"><a name="zh-cn_topic_0237122614_p339344618143"></a><a name="zh-cn_topic_0237122614_p339344618143"></a><a name="zh-cn_topic_0237122614_b139315469143"></a><a name="zh-cn_topic_0237122614_b139315469143"></a>名称
</th>
<th class="cellrowborder" valign="top" width="29.220000000000002%" id="mcps1.2.4.1.2"><a name="zh-cn_topic_0237122614_p9393446121418"></a><a name="zh-cn_topic_0237122614_p9393446121418"></a><a name="zh-cn_topic_0237122614_b11393346121419"></a><a name="zh-cn_topic_0237122614_b11393346121419"></a>类型
</th>
<th class="cellrowborder" valign="top" width="52.17%" id="mcps1.2.4.1.3"><a name="zh-cn_topic_0237122614_p10394164619144"></a><a name="zh-cn_topic_0237122614_p10394164619144"></a><a name="zh-cn_topic_0237122614_b173941946151412"></a><a name="zh-cn_topic_0237122614_b173941946151412"></a>描述
</th>
</tr>
</thead>
<tbody><tr id="zh-cn_topic_0237122614_row139424691413"><td class="cellrowborder" valign="top" width="18.61%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122614_p13949467149"></a><a name="zh-cn_topic_0237122614_p13949467149"></a>node_name
</td>
<td class="cellrowborder" valign="top" width="29.220000000000002%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122614_p14394114681416"></a><a name="zh-cn_topic_0237122614_p14394114681416"></a>text
</td>
<td class="cellrowborder" valign="top" width="52.17%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122614_p1539434651417"></a><a name="zh-cn_topic_0237122614_p1539434651417"></a>数据库进程名称。
</td>
</tr>
<tr id="zh-cn_topic_0237122614_row4394446181414"><td class="cellrowborder" valign="top" width="18.61%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122614_p5394646171414"></a><a name="zh-cn_topic_0237122614_p5394646171414"></a>databaseid
</td>
<td class="cellrowborder" valign="top" width="29.220000000000002%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122614_p15394114612146"></a><a name="zh-cn_topic_0237122614_p15394114612146"></a>integer
</td>
<td class="cellrowborder" valign="top" width="52.17%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122614_p03941546201417"></a><a name="zh-cn_topic_0237122614_p03941546201417"></a>database的oid。
</td>
</tr>
<tr id="zh-cn_topic_0237122614_row163942468146"><td class="cellrowborder" valign="top" width="18.61%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122614_p143956468143"></a><a name="zh-cn_topic_0237122614_p143956468143"></a>tablespaceid
</td>
<td class="cellrowborder" valign="top" width="29.220000000000002%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122614_p153951046131419"></a><a name="zh-cn_topic_0237122614_p153951046131419"></a>integer
</td>
<td class="cellrowborder" valign="top" width="52.17%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122614_p20395446111415"></a><a name="zh-cn_topic_0237122614_p20395446111415"></a>tablespace的oid。
</td>
</tr>
<tr id="zh-cn_topic_0237122614_row173959468144"><td class="cellrowborder" valign="top" width="18.61%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122614_p63959465146"></a><a name="zh-cn_topic_0237122614_p63959465146"></a>relfilenode
</td>
<td class="cellrowborder" valign="top" width="29.220000000000002%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122614_p539524641412"></a><a name="zh-cn_topic_0237122614_p539524641412"></a>integer
</td>
<td class="cellrowborder" valign="top" width="52.17%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122614_p239534671415"></a><a name="zh-cn_topic_0237122614_p239534671415"></a>relation的file node。
</td>
</tr>
<tr id="zh-cn_topic_0237122614_row103951846121417"><td class="cellrowborder" valign="top" width="18.61%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122614_p10395154617148"></a><a name="zh-cn_topic_0237122614_p10395154617148"></a>forknum
</td>
<td class="cellrowborder" valign="top" width="29.220000000000002%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122614_p1739524613149"></a><a name="zh-cn_topic_0237122614_p1739524613149"></a>integer
</td>
<td class="cellrowborder" valign="top" width="52.17%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122614_p9396174615146"></a><a name="zh-cn_topic_0237122614_p9396174615146"></a>fork编号。
</td>
</tr>
<tr id="zh-cn_topic_0237122614_row8396124616142"><td class="cellrowborder" valign="top" width="18.61%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122614_p939654611415"></a><a name="zh-cn_topic_0237122614_p939654611415"></a>error_count
</td>
<td class="cellrowborder" valign="top" width="29.220000000000002%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122614_p03961046151413"></a><a name="zh-cn_topic_0237122614_p03961046151413"></a>integer
</td>
<td class="cellrowborder" valign="top" width="52.17%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122614_p10396646141411"></a><a name="zh-cn_topic_0237122614_p10396646141411"></a>error的数量。
</td>
</tr>
<tr id="zh-cn_topic_0237122614_row139614611415"><td class="cellrowborder" valign="top" width="18.61%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122614_p11396164661415"></a><a name="zh-cn_topic_0237122614_p11396164661415"></a>first_time
</td>
<td class="cellrowborder" valign="top" width="29.220000000000002%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122614_p1396204619142"></a><a name="zh-cn_topic_0237122614_p1396204619142"></a>timestamp with time zone
</td>
<td class="cellrowborder" valign="top" width="52.17%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122614_p13396164611140"></a><a name="zh-cn_topic_0237122614_p13396164611140"></a>坏块第一次出现的时间。
</td>
</tr>
<tr id="zh-cn_topic_0237122614_row16396174691416"><td class="cellrowborder" valign="top" width="18.61%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122614_p133968462148"></a><a name="zh-cn_topic_0237122614_p133968462148"></a>last_time
</td>
<td class="cellrowborder" valign="top" width="29.220000000000002%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122614_p03973466147"></a><a name="zh-cn_topic_0237122614_p03973466147"></a>timestamp with time zone
</td>
<td class="cellrowborder" valign="top" width="52.17%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122614_p13971846141417"></a><a name="zh-cn_topic_0237122614_p13971846141417"></a>坏块最后出现的时间。
</td>
</tr>
</tbody>
</table>

一键复制编辑原始数据按行查看历史

提交于 2020-11-09 15:59 . sync dts

GLOBAL_STAT_BAD_BLOCK

获得各节点的表、索引等文件的读取失败信息。

表 1 GLOBAL_STAT_BAD_BLOCK字段

名称	类型	描述
node_name	text	数据库进程名称。
databaseid	integer	database的oid。
tablespaceid	integer	tablespace的oid。
relfilenode	integer	relation的file node。
forknum	integer	fork编号。
error_count	integer	error的数量。
first_time	timestamp with time zone	坏块第一次出现的时间。
last_time	timestamp with time zone	坏块最后出现的时间。

https://gitee.com/opengauss/docs.git

git@gitee.com:opengauss/docs.git

opengauss

docs

3.0.0

openGauss / docs

GLOBAL_STAT_BAD_BLOCK

简介

发行版

贡献者

近期动态

openGauss / docs .gitee-modal { width: 500px !important; }

GLOBAL_STAT_BAD_BLOCK

简介

发行版

开源评估指数源自 OSS-Compass 评估体系，评估体系围绕以下三个维度对项目展开评估：

贡献者

近期动态

搜索帮助

openGauss / docs