Chinaunix

标题: 宕机了,原因不明 [打印本页]

作者: antyison    时间: 2009-12-08 10:43
标题: 宕机了,原因不明
18:46:56  Maximum server connections 862
18:51:56  Fuzzy Checkpoint Completed:  duration was 0 seconds, 315 buffers not flushed.
18:51:56  Checkpoint loguniq 97896, logpos 0x4a36178, timestamp: 0xd83115ca

18:51:56  Maximum server connections 862
18:52:08  stack trace for pid 409750 written to /ln/dump/af.241fde57
18:52:08  Assert Failed: No Exception Handler
18:52:08  IBM Informix Dynamic Server Version 9.40.FC8X4  
18:52:08   Who: Session(7803, lnslapp@100.0.1.6, 2437488, 70000008660010
                Thread(8247, sqlexec, 700000088d5abb0, 1)
                File: mtex.c Line: 435
18:52:08   Results: Exception Caught. Type: MT_EX_OS, Context: mem
18:52:08   Action: Please notify IBM Informix Technical Support.
18:52:08  stack trace for pid 409750 written to /ln/dump/af.241fde57
18:52:08   See Also: /ln/dump/af.241fde57, shmem.241fde57.0
18:53:08  mtex.c, line 435, thread 8247, proc id 409750, No Exception Handler.
18:53:09  The Master Daemon Died
18:53:09  Fatal error in ADM VP at mt.c:12419
18:53:09  Unexpected virtual processor termination, pid = 544896, exit = 0x100

18:53:09  PANIC: Attempting to bring system down
19:05:52  IBM Informix Dynamic Server Started.

Mon Dec  7 19:05:57 2009

19:05:57  Warning: ONCONFIG dump directory (DUMPDIR) '/ln/dump' has insecure permissions
19:05:57  Event alarms enabled.  ALARMPROG = '/informix/etc/log_full_ln.sh'
19:05:57  Booting Language <c> from module <>
19:05:57  Loading Module <CNULL>
19:05:57  Booting Language <builtin> from module <>
19:05:57  Loading Module <BUILTINNULL>
19:06:02  AIX MP latch code enabled
19:06:02  IBM Informix Dynamic Server Version 9.40.FC8X4   Software Serial Number AAA#B000000
19:06:03  IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.

19:06:03  Physical Recovery Started at Page (2:181753).
19:06:04  Physical Recovery Complete: 512 Pages Examined, 512 Pages Restored.
19:06:04  Logical Recovery Started.
19:06:04  10 recovery worker threads will be started.
19:06:24  Fast Recovery Switching to Log 97896
19:06:49  Logical Recovery has reached the transaction cleanup phase.
19:06:49  Logical Recovery Complete.
          26069 Committed, 21666 Rolled Back, 0 Open, 0 Bad Locks

19:06:50  Dataskip is now OFF for all dbspaces
19:06:50  (116) connection rejected - no calls allowed for sqlexec
19:06:50  listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.

19:06:50  (117) connection rejected - no calls allowed for sqlexec
19:06:50  listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.

19:06:50  WARNING: Next backup of DBspace rootdbs must be level-0 backup.
19:06:50  WARNING: Next backup of DBspace phydbs must be level-0 backup.
19:06:50  WARNING: Next backup of DBspace logdbs must be level-0 backup.
19:06:50  WARNING: Next backup of DBspace datadbs must be level-0 backup.
19:06:50  Checkpoint Completed:  duration was 0 seconds.
19:06:50  Checkpoint loguniq 97896, logpos 0x4c9f4b8, timestamp: 0x3a0ed402

19:06:50  Maximum server connections 0
19:06:50  (11 connection rejected - no calls allowed for srvinfx
19:06:50  listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.

19:06:50  On-Line Mode
19:07:19  Checkpoint Completed:  duration was 0 seconds.
19:07:19  Checkpoint loguniq 97896, logpos 0x4ca0018, timestamp: 0x3a0ed480

19:07:19  Maximum server connections 3
19:08:30  Booting Language <spl> from module <>
19:08:30  Loading Module <SPLNULL>
19:12:19  Checkpoint Completed:  duration was 0 seconds.






===========------------- - - - - - -
/informix/bin/onstat -g ses 7803:

IBM Informix Dynamic Server Version 9.40.FC8X4   -- On-Line -- Up 3 days 01:09:28 -- 2541344 Kbytes

session                                      #RSAM    total      used       dynamic
id       user     tty      pid      hostname threads  memory     memory     explain
7803     lnslapp  -        2437488  100.0.1. 1        409600     123968     off

tid      name     rstcb            flags    curstk   status
8247     sqlexec  700000088d5abb0  ---P---  2091447696 running

Memory pools    count 2
name         class addr              totalsize  freesize   #allocfrag #freefrag
7803         V     7000000890d7040  405504     284784     298        153      
7803*O0      V     70000008a37b040  4096       848        1          1         

name           free       used           name           free       used      
overhead       0          6496           scb            0          144      
opentable      0          26352          filetable      0          4312      
ru             0          600            log            0          4232      
temprec        0          10104          keys           0          5640      
ralloc         0          11976          gentcb         0          1600      
ostcb          0          3456           sort           0          104      
sqscb          0          34408          sql            0          72        
rdahead        0          224            hashfiletab    0          552      
osenv          0          3248           sqtcb          0          8064      
fragman        0          2240           sapi           0          64        

sqscb info
scb              sqscb            optofc   pdqpriority sqlstats optcompind  directives
70000008392d370  7000000890d8028  0        0           0        2           1         

Sess  SQL            Current            Iso Lock       SQL  ISAM F.E.
Id    Stmt type      Database           Lvl Mode       ERR  ERR  Vers Explain   
7803  SELECT         -                  -   Not Wait   0    0    9.03 Off        

Current statement name : curmioitem

Current SQL statement :
  SELECT distinct mio_item_code,'' FROM MixMioItemNew

Last parsed SQL statement :
  SELECT distinct mio_item_code,'' FROM MixMioItemNew



===========------------- - - - - - -
/informix/bin/onstat -g sql 7803:

IBM Informix Dynamic Server Version 9.40.FC8X4   -- On-Line -- Up 3 days 01:09:28 -- 2541344 Kbytes

Sess  SQL            Current            Iso Lock       SQL  ISAM F.E.
Id    Stmt type      Database           Lvl Mode       ERR  ERR  Vers Explain   
7803  SELECT         -                  -   Not Wait   0    0    9.03 Off        

Current statement name : curmioitem

Current SQL statement :
  SELECT distinct mio_item_code,'' FROM MixMioItemNew

Last parsed SQL statement :
  SELECT distinct mio_item_code,'' FROM MixMioItemNew


哪位大哥帮忙分析一下,谢谢了。 具体的af文件见附件

af.rar

467.61 KB, 下载次数: 17


作者: antyison    时间: 2009-12-08 13:15
ids 9.4FC8X4     
会不会是BUG呢?!
作者: antyison    时间: 2009-12-09 08:56
请问宕机后重启为什么会提示
19:06:50  WARNING: Next backup of DBspace rootdbs must be level-0 backup.
作者: koolkite    时间: 2009-12-09 09:07
标题: 回复 #3 antyison 的帖子
这个应该是与你所用的系统备份策略有关,日志很明显是提示你下次数据库备份,你需要做0级备份




欢迎光临 Chinaunix (http://bbs.chinaunix.net/) Powered by Discuz! X3.2