gx遗留问题
问题描述:数据两台主机有重启现像,其中172.20.216.28于3日早上约6点半左右重启。172.20.216.29于5日下午16点半左右重启。
172.20.216.28日志
Jan 3 00:30:01 db1 su: pam_tally2(su-l:account): unknown option: reset
Jan 3 00:30:01 db1 su: (to cyrus) root on none
Jan 3 00:30:02 db1 syslog-ng[8850]: Log statistics; dropped='pipe(/dev/xconsole)=0', dropped='pipe(/dev/tty10)=0', dropped='udp(AF_INET(172.20.216.28:514))=0', processed='center(queued)=1977', processed='center(received)=1175', processed='destination(messages)=1078', processed='destination(mailinfo)=0', processed='destination(mailwarn)=0', processed='destination(localmessages)=0', processed='destination(newserr)=0', processed='destination(mailerr)=97', processed='destination(netmgm)=0', processed='destination(warn)=691', processed='destination(console)=6', processed='destination(null)=0', processed='destination(mail)=97', processed='destination(xconsole)=6', processed='destination(firewall)=0', processed='destination(acpid)=0', processed='destination(allmessages)=2', processed='destination(newscrit)=0', processed='destination(newsnotice)=0', processed='source(src)=1175'
Jan 3 00:30:02 db1 ctl_mboxlist[6023]: DBERROR: reading /var/lib/imap/db/skipstamp, assuming the worst: No such file or directory
Jan 3 00:30:02 db1 ctl_mboxlist[6023]: skiplist: recovered /var/lib/imap/mailboxes.db (0 records, 144 bytes) in 0 seconds
Jan 3 00:40:01 db1 /usr/sbin/cron[17195]: pam_tally2(crond:account): unknown option: reset
Jan 3 00:40:01 db1 /usr/sbin/cron[17196]: (root) CMD ([ -x /usr/lib64/sa/sa1 ] && exec /usr/lib64/sa/sa1 -S ALL 1 1)
172.20.216.29日志
Jan 5 12:00:02 db2 su: pam_tally2(su-l:account): unknown option: reset
Jan 5 12:00:02 db2 su: (to cyrus) root on none
Jan 5 12:00:02 db2 ctl_mboxlist[21189]: DBERROR: reading /var/lib/imap/db/skipstamp, assuming the worst: No such file or directory
Jan 5 12:00:02 db2 ctl_mboxlist[21189]: skiplist: recovered /var/lib/imap/mailboxes.db (0 records, 144 bytes) in 0 seconds
Jan 5 12:00:02 db2 syslog-ng[8531]: Log statistics; dropped='pipe(/dev/xconsole)=0', dropped='pipe(/dev/tty10)=0', dropped='udp(AF_INET(172.20.216.29:514))=0', processed='center(queued)=31380', processed='center(received)=18070', processed='destination(messages)=16766', processed='destination(mailinfo)=0', processed='destination(mailwarn)=0', processed='destination(localmessages)=1', processed='destination(newserr)=0', processed='destination(mailerr)=1304', processed='destination(netmgm)=0', processed='destination(warn)=11344', processed='destination(console)=277', processed='destination(null)=0', processed='destination(mail)=1304', processed='destination(xconsole)=277', processed='destination(firewall)=0', processed='destination(acpid)=0', processed='destination(allmessages)=107', processed='destination(newscrit)=0', processed='destination(newsnotice)=0', processed='source(src)=18070'
Jan 5 12:10:01 db2 /usr/sbin/cron[32445]: pam_tally2(crond:account): unknown option: reset
Jan 5 15:00:01 db2 /usr/sbin/cron[27194]: (oracle) CMD (sh /home/oracle/shsnc/dbstat.sh)
Jan 5 15:00:02 db2 syslog-ng[8531]: Log statistics; dropped='pipe(/dev/xconsole)=0', dropped='pipe(/dev/tty10)=0', dropped='udp(AF_INET(172.20.216.29:514))=0', processed='center(queued)=31499', processed='center(received)=18141', processed='destination(messages)=16831', processed='destination(mailinfo)=0', processed='destination(mailwarn)=0', processed='destination(localmessages)=1', processed='destination(newserr)=0', processed='destination(mailerr)=1310', processed='destination(netmgm)=0', processed='destination(warn)=11386', processed='destination(console)=277', processed='destination(null)=0', processed='destination(mail)=1310', processed='destination(xconsole)=277', processed='destination(firewall)=0', processed='destination(acpid)=0', processed='destination(allmessages)=107', processed='destination(newscrit)=0', processed='destination(newsnotice)=0', processed='source(src)=18141'
Jan 5 15:10:01 db2 /usr/sbin/cron[5981]: pam_tally2(crond:account): unknown option: reset
Jan 5 15:10:01 db2 /usr/sbin/cron[5983]: (root) CMD ([ -x /usr/lib64/sa/sa1 ] && exec /usr/lib64/sa/sa1 -S ALL 1 1)
Jan 5 15:15:01 db2 /usr/sbin/cron[11680]: pam_tally2(crond:account): unknown option: reset
Jan 5 15:20:01 db2 /usr/sbin/cron[17153]: pam_tally2(crond:account): unknown option: reset
Jan 5 15:20:01 db2 /usr/sbin/cron[17154]: (root) CMD ([ -x /usr/lib64/sa/sa1 ] && exec /usr/lib64/sa/sa1 -S ALL 1 1)
Jan 5 15:30:01 db2 /usr/sbin/cron[28101]: pam_tally2(crond:account): unknown option: reset
Jan 5 15:30:01 db2 /usr/sbin/cron[28102]: pam_tally2(crond:account): unknown option: reset
Jan 5 15:30:01 db2 /usr/sbin/cron[28105]: (root) CMD ([ -x /usr/lib64/sa/sa1 ] && exec /usr/lib64/sa/sa1 -S ALL 1 1)
Jan 5 15:40:01 db2 /usr/sbin/cron[6865]: pam_tally2(crond:account): unknown option: reset
Jan 5 15:40:01 db2 /usr/sbin/cron[6866]: (root) CMD ([ -x /usr/lib64/sa/sa1 ] && exec /usr/lib64/sa/sa1 -S ALL 1 1)
Jan 5 15:45:01 db2 /usr/sbin/cron[12455]: pam_tally2(crond:account): unknown option: reset
Jan 5 15:50:01 db2 /usr/sbin/cron[17936]: pam_tally2(crond:account): unknown option: reset
Jan 5 15:50:01 db2 /usr/sbin/cron[17937]: (root) CMD ([ -x /usr/lib64/sa/sa1 ] && exec /usr/lib64/sa/sa1 -S ALL 1 1)
Jan 5 17:09:13 db2 syslog-ng[8638]: syslog-ng starting up; version='2.0.9'
Jan 5 17:09:13 db2 auditd[8655]: Started dispatcher: /sbin/audispd pid: 8657
现在有两种说法,一种说是数据库配置问题,再次重启就好,不影响使用。如果频繁出现,就需要找配置数据库的人看一下,改了哪些系统参数,具体分析,明天我问一下数据库的同事。一种是硬盘坏道,你那边从硬件上分析一下,看看有没有告警。
数据库同事也没遇到过~~~怀疑是安装有邮件服务器类似的软件,还是要找部署数据库的人确认。
SUSE 9 数据库是oracle
相关问题
http://bbs.chinaunix.net/thread-2055436-1-1.html
https://www.experts-exchange.com/questions/24327176/DBERROR-reading-var-lib-imap-db-skipstamp-assuming-the-worst-No-such-file-or-directory.html