docker启动容器报错：Error response from daemon task xxxx already exists
现象由于主机磁盘空间不足，但是经过查询，docker并没有占用很大空间，也就是说du和df查出来的空间差异很大，这可能是deleted的文件很多导致，只能重启docker或重启主机了。这里，我强制重启docker后，就不能启动容器，报错 ... 阅读全文
标签： 故障处理
ssh连接远程欧拉系统时报错Unable to negotiate with 100.194.18.75 port 22: no matching host key type found. Their offer: ssh-rsa
现象在openeuler 22.03中，通过ssh连接远程欧拉服务器报错[root@mdw ~]# ssh gpadmin@sdwUnable to negotiate with 100.194. ... 阅读全文
GreenPlum严重故障导致不能启库的解决办法
现象GP的某个实例报错如下，导致整个GP不能启动2024-01-28 08:25:30.644871 CST,,,p11917,th-1607219072,,,,0,,,seg7,,,,," ... 阅读全文
使用postgres_fdw从GreenPlum中抽数据到PostgreSQL中，报错：ERROR schema ht_hdw is not present on foreign server hdw_link
现象导入报错-- 1、创建扩展create extension postgres_fdw;-- 2、创建外部数据库连接create server hdw_linforeign data wrapp ... 阅读全文
初始化GreenPlum数据库实例时报错ssh_exchange_identification: connection reset by peer
现象初始化实例的时候报错ssh_exchange_identification: connection reset by peessh_exchange_identification: conne ... 阅读全文
pip3安装psycopg2和powa-collector报错./psycopg/psycopg.h:35:20: fatal error: Python.h: No such file or directory
现象[postgres@lhrpowa ~]$ pip3 install psycopgCollecting psycopgUsing cached https://files.pythonhos ... 阅读全文
GreenPlum安装gpcc报错rsync: [sender] write error: Broken pipe (32)
现象[gpadmin@mdw ~]$ cd /sof[gpadmin@mdw soft]$ cd greenplum-cc-web-6.10.0-gp6-rhel7-x86_64[gpadmin@ ... 阅读全文
GreenPlum添加standby master报错Error initializing standby master ExecutionError non-zero rc 2
现象[gpadmin@mdw gppkg]$ gpinitstandby -s smdw -S /opt/greenplum/data/master/gpseg-1 -P 54320240117:1 ... 阅读全文
GreenPlum删除了pg_xlog文件夹内容报错could not locate a valid checkpoint record
现象直接删除GreenPlum下pg_xlog的目录文件内容[gpadmin@gpdb6 pg_xlog]$ rm -rf /opt/greenplum/data/primary/gpseg1/pg ... 阅读全文
GreenPlum查询状态报错 [WARNING]:-could not query segment
现象[gpadmin@mdw ~]$ gpstate -20231229:17:05:24:3562260 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate ... 阅读全文
