Linux中某个进程卡住，strace返回wait4(-1的解决办法
现象[root@localhost ~]# ps -ef | grep prroot 38899 37747 0 12:27 pts/1 00:00:00 bash run_ ... 阅读全文
标签： 原创
PG执行计划性能分析神器之PEV2（Postgres Explain Visualizer 2） 介绍
简介https://github.com/dalibo/pev使用方法在线访问在线访问：https://explain.dalibo.compev2.html单独访问下载 https://www ... 阅读全文
密码保护canceling statement due to user request的几种情况
无法提供摘要，因为这是一篇受保护的文章。
rpm安装报错Thread died in Berkeley DB library DB_RUNRECOVERY Fatal error, run database recovery
错误[root@sdw1 ~]# rpm -vih /tmp/sysstat-10.1.5-20.el7_9.x86_64.rperror: rpmdb: BDB0113 Thread/proces ... 阅读全文
scp命令拷贝文件报错scp: Connection closed
现象[root@localhost soft]# scp unrar root@smdw:/tmpAuthorized users only. All activities may be monit ... 阅读全文
WordPress搜索报错Warning: mysqli_query(): (HY000/3024): Query execution was interrupted, maximum statement execution time exceeded in /www/wwwroot/my.dbaup.com/wp-includes/class-wpdb.php on line 2351
现象Warning: mysqli_query(): (HY000/3024): Query execution was interrupted, maximum statement executio ... 阅读全文
密码保护GreenPlum启用gp_wlm、gpcc_wlm的schema、工作负载管理规则功能
无法提供摘要，因为这是一篇受保护的文章。
PG删除pg_wal文件夹后启动数据库报错could not locate a valid checkpoint record和invalid primary checkpoint record
现象PG删除pg_wal文件夹后启动数据库报错could not locate a valid checkpoint recorinvalid primary checkpoint recor解决 ... 阅读全文
带参数的 PostgreSQL 函数返回多行多列
示例CREATE OR REPLACE FUNCTION get_multiple_rowsp_min_id integer DEFAULT NULL, -- 可选参数：最小Ip_n ... 阅读全文
