活动专区

活动公告

上车！GBase 8a开发者联盟发车了 技术福利、人脉资源全都有！

认证培训专区

认证培训资料

GBase 8s GDCA 认证培训课前准备

GBase 8a

其他

物化视图报错：references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

01-GBase 8s 事务型数据库 安装与卸载

GBase 8s

适配迁移

[GBase 8s 教程]GBase 8s 常用函数、表达式

检查GBase 8s HDR集群运行状态最简便的方式是使用onstat -g dri命令
```text
GBase Database Server Version 12.10.FC4G1AEE -- On-Line (Prim) -- Up 00:28:21 -- 627616 Kbytes

Data Replication at 0x47588028:
  Type           State        Paired server        Last DR CKPT (id/pg)    Supports Proxy Writes
  primary        on           gbase32                       4 / 14         NA

  DRINTERVAL   0
  DRTIMEOUT    30
  DRAUTO       0
  DRLOSTFOUND  /home/gbase30/etc/dr.lostfound
  DRIDXAUTO    0
  ENCRYPT_HDR  0
  Backlog      0
  Last Send    2019/05/06 09:09:42
  Last Receive 2019/05/06 09:09:42
  Last Ping    2019/05/06 09:09:36
  Last log page applied(log id,page): 4,15
```



如果不适应使用onstat命令方式，也可通过sysadmin api来实现，语句为：EXECUTE FUNCTION task("onstat","-g dri");
```text
> EXECUTE FUNCTION task("onstat","-g dri");


(expression)
GBase Database Server Version 12.10.FC4G1AEE -- On-Line (Prim) -- Up 00:32:15 -- 627616 Kbytes

Data Replication at 0x47588028:

  Type           State        Paired server        Last DR CKPT (id/pg)    Supports Proxy Writes
  primary        on           gbase32                       4 / 22         NA
  DRINTERVAL   0
  DRTIMEOUT    30
  DRAUTO       0
  DRLOSTFOUND  /home/gbase30/etc/dr.lostfound
  DRIDXAUTO    0
  ENCRYPT_HDR  0
  Backlog      0
  Last Send    2019/05/06 09:13:36
  Last Receive 2019/05/06 09:13:36
  Last Ping    2019/05/06 09:13:07
  Last log page applied(log id,page): 4,23


1 row(s) retrieved.
```
如果需要只通过sql语句来实现，则需要查询sysmaster库，现有的系统表或者视图有简单的状态信息
```text
> select * from sysdri;



type       Primary
state      On
name       gbase32
intvl      0
timeout    30
lostfound  /home/gbase30/etc/dr.lostfound
drauto     0
dridxauto  0

1 row(s) retrieved.
```
如果需要更多的信息，需要自定义查询语句，如：
```text
-- SQL语句, 查询sysmaster库
select b.txt as type, c.txt as state , dbservername as localserver, a.name as pairserver, a.intvl as interval, a.timeout as timeout, DBINFO('utc_to_datetime',pingtime) as lastpingtime, current year to second as currenttime
from sysmaster:sysdrcb a, sysmaster:flags_text b, sysmaster:flags_text c
where a.type = b.flags
  and b.tabname = 'sysdrcb'
  and a.state = c.flags
  and c.tabname = 'sysdrcb';
  
-- 主机Primary显示， 首先判断正常的是 state， 状态应是 On， 然后currenttime - lastpingtime 的差值应小于 4 * timeout
type          Primary
state         On
localserver   gbase31                -- 本机服务名称（实例名）
pairserver    gbase32                -- 对端服务名称（实例名）
interval      0
timeout       30                     -- 超时时间，3次超时将会出现异常
lastpingtime  2019-05-06 09:00:36    -- 最后一次正确ping成功的时间
currenttime   2019-05-06 09:01:00    -- 当前时间

-- 备机Secondary显示， 首先判断正常的是 state， 状态应是 On， 然后currenttime - lastpingtime 的差值应小于 4 * timeout
type          Secondary
state         On
localserver   gbase32
pairserver    gbase31
interval      0
timeout       30
lastpingtime  2019-05-06 09:01:06
currenttime   2019-05-06 09:01:08
```

运维管理

通过SQL检查GBase 8s HDR运行状态

通过SQL检查GBase 8s HDR运行状态

评论

热门帖子