节点待回收删除存储-SYS_DROPPED_STORES
📄字数 1.7K
👁️阅读量 加载中...
功能描述
SYS_DROPPED_GSTORES系统表用于管理当前节点的待回收的删除的存储信息。
字段说明
- 详见SYS_STORES。
应用举例
- 查询系统表
sql
SQL> SELECT * FROM SYS_DROPPED_STORES LIMIT 3;
+--------+----------+---------+---------+---------+----------+----------+---------+----------+------------+-------------+------------+-----------+------------+-------------+-------------+-------------+-------------+---------+---------+-----+------------+-------------+-----------+-----------+
| NODEID | STORE_NO | PREV_NO | NEXT_NO | GSTO_NO | CHUNK_NO | BLK_SIZE | BLK_NUM | SPACE_ID | HOT_BLK_NO | ROOT_BLK_NO | STORE_TYPE | STORE_STA | MIRROR_STA | MIRROR_NID1 | MIRROR_NID2 | MIRROR_STO1 | MIRROR_STO2 | ROW_NUM | DEL_NUM | LSN | DELAY_DROP | MEDIA_ERROR | OV_STO_NO | OV_BLK_NO |
+--------+----------+---------+---------+---------+----------+----------+---------+----------+------------+-------------+------------+-----------+------------+-------------+-------------+-------------+-------------+---------+---------+-----+------------+-------------+-----------+-----------+
| 1 | 1210 | 0 | 1252 | 0 | 294 | 8192 | 1024 | 261 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 44671 | 0 | 0 | F | F | 0 | 0 |
| 1 | 1252 | 0 | 1208 | 0 | 305 | 8192 | 1024 | 261 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 44671 | 0 | 0 | F | F | 0 | 0 |
| 1 | 1208 | 0 | 1206 | 0 | 293 | 8192 | 1024 | 259 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 44671 | 0 | 0 | F | F | 0 | 0 |
+--------+----------+---------+---------+---------+----------+----------+---------+----------+------------+-------------+------------+-----------+------------+-------------+-------------+-------------+-------------+---------+---------+-----+------------+-------------+-----------+-----------+- 删除对象后查询系统表
sql
-- 创表
SQL> CREATE TABLE tab_drop(c1 INT);
-- 查询出全局存储号
SQL> SELECT t1.* FROM SYS_GSTORES t1 JOIN SYS_TABLES t2 ON t1.db_id=t2.db_id and t2.table_id=t1.obj_id WHERE t2.table_name='tab_drop';
+---------+---------+---------+---------+-----------+-----------+-----------+----------+----------+----------+-----------+-----------+-----------+-----+-------+---------+----------+---------+--------+
| GSTO_NO | HEAD_NO | TAIL_NO | NEXT_NO | SPLIT_NUM | STORE_STA | STORE_NUM | NODE_ID1 | NODE_ID2 | NODE_ID3 | STORE_NO1 | STORE_NO2 | STORE_NO3 | LSN | DB_ID | OBJ_ID | ENCRY_ID | ZONE_ID | NODEID |
+---------+---------+---------+---------+-----------+-----------+-----------+----------+----------+----------+-----------+-----------+-----------+-----+-------+---------+----------+---------+--------+
| 201 | 201 | 201 | 0 | 0 | 41 | 3 | 1 | 3 | 2 | 113 | 113 | 113 | 1 | 1 | 1048577 | 0 | 0 | 1 |
+---------+---------+---------+---------+-----------+-----------+-----------+----------+----------+----------+-----------+-----------+-----------+-----+-------+---------+----------+---------+--------+
-- 根据全局存储号查询局部存储号
SQL> SELECT * FROM SYS_STORES WHERE gsto_no=201;
+--------+----------+---------+---------+---------+----------+----------+---------+----------+------------+-------------+------------+-----------+------------+-------------+-------------+-------------+-------------+---------+---------+-----+------------+-------------+-----------+-----------+
| NODEID | STORE_NO | PREV_NO | NEXT_NO | GSTO_NO | CHUNK_NO | BLK_SIZE | BLK_NUM | SPACE_ID | HOT_BLK_NO | ROOT_BLK_NO | STORE_TYPE | STORE_STA | MIRROR_STA | MIRROR_NID1 | MIRROR_NID2 | MIRROR_STO1 | MIRROR_STO2 | ROW_NUM | DEL_NUM | LSN | DELAY_DROP | MEDIA_ERROR | OV_STO_NO | OV_BLK_NO |
+--------+----------+---------+---------+---------+----------+----------+---------+----------+------------+-------------+------------+-----------+------------+-------------+-------------+-------------+-------------+---------+---------+-----+------------+-------------+-----------+-----------+
| 1 | 113 | 0 | 0 | 201 | 20 | 8192 | 1024 | 262 | -1 | -1 | 0 | 1 | 10 | 3 | 2 | 113 | 113 | 0 | 0 | 1 | F | F | 0 | 0 |
+--------+----------+---------+---------+---------+----------+----------+---------+----------+------------+-------------+------------+-----------+------------+-------------+-------------+-------------+-------------+---------+---------+-----+------------+-------------+-----------+-----------+
-- 当前局部存储未进入SYS_DROPPED_STORES系统部
SQL> SELECT * FROM SYS_DROPPED_STORES WHERE store_no=113;
+--------+----------+---------+---------+---------+----------+----------+---------+----------+------------+-------------+------------+-----------+------------+-------------+-------------+-------------+-------------+---------+---------+-----+------------+-------------+-----------+-----------+
| NODEID | STORE_NO | PREV_NO | NEXT_NO | GSTO_NO | CHUNK_NO | BLK_SIZE | BLK_NUM | SPACE_ID | HOT_BLK_NO | ROOT_BLK_NO | STORE_TYPE | STORE_STA | MIRROR_STA | MIRROR_NID1 | MIRROR_NID2 | MIRROR_STO1 | MIRROR_STO2 | ROW_NUM | DEL_NUM | LSN | DELAY_DROP | MEDIA_ERROR | OV_STO_NO | OV_BLK_NO |
+--------+----------+---------+---------+---------+----------+----------+---------+----------+------------+-------------+------------+-----------+------------+-------------+-------------+-------------+-------------+---------+---------+-----+------------+-------------+-----------+-----------+
+--------+----------+---------+---------+---------+----------+----------+---------+----------+------------+-------------+------------+-----------+------------+-------------+-------------+-------------+-------------+---------+---------+-----+------------+-------------+-----------+-----------+
-- 删表
SQL> DROP TABLE tab_drop;
-- 删表后，该表的局部存储进入了SYS_DROPPED_STORES系统表
SQL> SELECT * FROM SYS_DROPPED_STORES WHERE store_no=113;
+--------+----------+---------+---------+---------+----------+----------+---------+----------+------------+-------------+------------+-----------+------------+-------------+-------------+-------------+-------------+---------+---------+-----+------------+-------------+-----------+-----------+
| NODEID | STORE_NO | PREV_NO | NEXT_NO | GSTO_NO | CHUNK_NO | BLK_SIZE | BLK_NUM | SPACE_ID | HOT_BLK_NO | ROOT_BLK_NO | STORE_TYPE | STORE_STA | MIRROR_STA | MIRROR_NID1 | MIRROR_NID2 | MIRROR_STO1 | MIRROR_STO2 | ROW_NUM | DEL_NUM | LSN | DELAY_DROP | MEDIA_ERROR | OV_STO_NO | OV_BLK_NO |
+--------+----------+---------+---------+---------+----------+----------+---------+----------+------------+-------------+------------+-----------+------------+-------------+-------------+-------------+-------------+---------+---------+-----+------------+-------------+-----------+-----------+
| 1 | 113 | 0 | 0 | 0 | 20 | 8192 | 1024 | 262 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 25 | 0 | 0 | F | F | 0 | 0 |
+--------+----------+---------+---------+---------+----------+----------+---------+----------+------------+-------------+------------+-----------+------------+-------------+-------------+-------------+-------------+---------+---------+-----+------------+-------------+-----------+-----------+