IT行业疑难杂症终极解决之道
大法1：重启O1、有的系统参数或系统变更只有重启OS后才能生效大法2：重启软件、重启数据库等1、配置文件是否生效，有时需要重启软件才可以，例如OGG的进程参数文件，在修改之后必须重启进程才可以大法3：重装软件，甚至重装O ... 阅读全文
标签： 故障处理
GreenPlum 6中启用资源组后，报错 ERROR: insufficient memory reserved for statement (execHHashagg.c:1400)
现象在GP6中，启用资源组后，查询报错SELECT current_database(),bdinspname,bdirelname,bdirelpages,bdiexppages,caswhe ... 阅读全文
pgbouncer启动报错evdns_base_new failed Segmentation fault (core dumped)
现象[gpadmin@mdw pgbouncer]$ pgbouncer pgbouncer.ini -2025-01-08 15:44:31.518 CST [180197] DEBUG pars ... 阅读全文
psql中的错误“psql: error: could not connect to server”的常见原因（PGHOST变量）
现象[pgsql@lhrpg ~]$ psqpsql: error: could not connect to server: No such file or directorIs the ser ... 阅读全文
could not load library "/usr/local/greenplum-cc-6.10.0/lib/gp_browser.so": libpq.so.5: cannot open shared object file: No such file or directory (seg19 12.17.163.53:6019 pid=3773909)
现象gpcc的告警日志报错could not load library "/usr/local/greenplum-cc-6.10.0/lib/gp_browser.so": l ... 阅读全文
Linux创建定时任务crontab报错You (gpadmin) are not allowed to access to (crontab ) because of pam configuration
现象You (gpadmin) are not allowed to access to (crontab ) because of pam configuration.PAM unable to d ... 阅读全文
GreenPlum做gpcheckcat报错Connected as user 'gpadmin' to database 'ABT', port '5432', gpdb version '6.28'
现象[gpadmin@mdw gpseg-1]$ gpcheckcat -A -B 16 -Connected as user 'gpadmin' to database � ... 阅读全文
GreenPlum查询报错 interconnect error Could not set up udp listener socket bind Address already in use
现象[gpadmin@mdw ~]$ gpconfig -s gp_fts_replication_attempt_coun20241206:12:34:35:4137119 gpconfig:md ... 阅读全文
ping: connect: Resource temporarily unavailable
现象[root@sdw2 ~]# ping sdwping: connect: Resource temporarily unavailabl[root@sdw2 ~]# ping sdwpin ... 阅读全文
Linux卸载目录时报错 umount: /dfdata: target is busy. (In some cases useful info about processes that use the device is found by lsof(8) or fuser(1))
现象[root@sdw2 ~]# umount /dataumount: /data: target is busy.(In some cases useful info about proces ... 阅读全文
