# 进程异常分析处理脚本

#!/bin/bash
# process_exception_analysis.sh
# from:www.itpux.com.qq113257174.wx:itpux-com
# web: `http://www.fgedu.net.cn`
# 配置信息
DB_USER=”system”
DB_PASSWORD=”kingbase”
ALERT_EMAIL=”admin@fgedu.net.cn”
LOG_FILE=”/var/log/kingbase/process_exception.log”
echo “===== 进程异常分析处理脚本 =====” >> $LOG_FILE
echo “执行时间: $(date)” >> $LOG_FILE
# 检查金仓数据库进程
echo “检查金仓数据库进程…” >> $LOG_FILE
KINGBASE_PROCS=$(ps -ef | grep kingbase | grep -v grep | wc -l)
if [ $KINGBASE_PROCS -eq 0 ]; then
echo “金仓数据库进程不存在，启动数据库…” >> $LOG_FILE
systemctl start kingbase
if [ $? -eq 0 ]; then
echo “数据库启动成功” >> $LOG_FILE
echo “金仓数据库进程不存在，已启动数据库” | mail -s “数据库进程异常告警” $ALERT_EMAIL
else
echo “数据库启动失败” >> $LOG_FILE
echo “金仓数据库进程不存在，启动失败” | mail -s “数据库进程异常告警” $ALERT_EMAIL
fi
else
echo “金仓数据库进程存在，检查进程状态…” >> $LOG_FILE
# 检查进程CPU使用率
echo “检查进程CPU使用率…” >> $LOG_FILE
CPU_USAGE=$(top -b -n 1 | grep kingbase | awk ‘{print $9}’ | sort -nr | head -n 1)
if (( $(echo “$CPU_USAGE > 90” | bc -l) )); then
echo “CPU使用率过高: $CPU_USAGE%” >> $LOG_FILE
echo “检查高CPU使用率的查询…” >> $LOG_FILE
HIGH_CPU_QUERY=$(/kingbase/app/bin/ksql -U $DB_USER -d fgedudb -c “SELECT pid, usename, query, state FROM pg_stat_activity WHERE state = ‘active’ ORDER BY now() – query_start DESC LIMIT 5;”)
echo “高CPU使用率的查询: $HIGH_CPU_QUERY” >> $LOG_FILE
echo “金仓数据库进程CPU使用率过高: $CPU_USAGE%” | mail -s “数据库进程异常告警” $ALERT_EMAIL
fi
# 检查进程内存使用率
echo “检查进程内存使用率…” >> $LOG_FILE
MEM_USAGE=$(ps aux | grep kingbase | grep -v grep | awk ‘{print $4}’ | sort -nr | head -n 1)
if (( $(echo “$MEM_USAGE > 80” | bc -l) )); then
echo “内存使用率过高: $MEM_USAGE%” >> $LOG_FILE
echo “金仓数据库进程内存使用率过高: $MEM_USAGE%” | mail -s “数据库进程异常告警” $ALERT_EMAIL
fi
# 检查数据库连接数
echo “检查数据库连接数…” >> $LOG_FILE
CONNECTION_COUNT=$(/kingbase/app/bin/ksql -U $DB_USER -d fgedudb -c “SELECT count(*) FROM pg_stat_activity;”)
echo “数据库连接数: $CONNECTION_COUNT” >> $LOG_FILE
# 检查死锁
echo “检查死锁…” >> $LOG_FILE
DEADLOCKS=$(/kingbase/app/bin/ksql -U $DB_USER -d fgedudb -c “SELECT * FROM pg_stat_activity WHERE waiting = true;”)
if [ -n “$DEADLOCKS” ]; then
echo “发现死锁: $DEADLOCKS” >> $LOG_FILE
echo “金仓数据库发现死锁” | mail -s “数据库进程异常告警” $ALERT_EMAIL
fi
fi
echo “===== 进程异常分析处理脚本执行完成 =====” >> $LOG_FILE