宕机了，原因不明
18:46:56Maximum server connections 86218:51:56Fuzzy Checkpoint Completed:duration was 0 seconds, 315 buffers not flushed.
18:51:56Checkpoint loguniq 97896, logpos 0x4a36178, timestamp: 0xd83115ca
18:51:56Maximum server connections 862
18:52:08stack trace for pid 409750 written to /ln/dump/af.241fde57
18:52:08Assert Failed: No Exception Handler
18:52:08IBM Informix Dynamic Server Version 9.40.FC8X4
18:52:08 Who: Session(7803, lnslapp@100.0.1.6, 2437488, 700000086600108)
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:08stack trace for pid 409750 written to /ln/dump/af.241fde57
18:52:08 See Also: /ln/dump/af.241fde57, shmem.241fde57.0
18:53:08mtex.c, line 435, thread 8247, proc id 409750, No Exception Handler.
18:53:09The Master Daemon Died
18:53:09Fatal error in ADM VP at mt.c:12419
18:53:09Unexpected virtual processor termination, pid = 544896, exit = 0x100
18:53:09PANIC: Attempting to bring system down
19:05:52IBM Informix Dynamic Server Started.
Mon Dec7 19:05:57 2009
19:05:57Warning: ONCONFIG dump directory (DUMPDIR) '/ln/dump' has insecure permissions
19:05:57Event alarms enabled.ALARMPROG = '/informix/etc/log_full_ln.sh'
19:05:57Booting Language <c> from module <>
19:05:57Loading Module <CNULL>
19:05:57Booting Language <builtin> from module <>
19:05:57Loading Module <BUILTINNULL>
19:06:02AIX MP latch code enabled
19:06:02IBM Informix Dynamic Server Version 9.40.FC8X4 Software Serial Number AAA#B000000
19:06:03IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.
19:06:03Physical Recovery Started at Page (2:181753).
19:06:04Physical Recovery Complete: 512 Pages Examined, 512 Pages Restored.
19:06:04Logical Recovery Started.
19:06:0410 recovery worker threads will be started.
19:06:24Fast Recovery Switching to Log 97896
19:06:49Logical Recovery has reached the transaction cleanup phase.
19:06:49Logical Recovery Complete.
26069 Committed, 21666 Rolled Back, 0 Open, 0 Bad Locks
19:06:50Dataskip is now OFF for all dbspaces
19:06:50(116) connection rejected - no calls allowed for sqlexec
19:06:50listener-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:50listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.
19:06:50WARNING: Next backup of DBspace rootdbs must be level-0 backup.
19:06:50WARNING: Next backup of DBspace phydbs must be level-0 backup.
19:06:50WARNING: Next backup of DBspace logdbs must be level-0 backup.
19:06:50WARNING: Next backup of DBspace datadbs must be level-0 backup.
19:06:50Checkpoint Completed:duration was 0 seconds.
19:06:50Checkpoint loguniq 97896, logpos 0x4c9f4b8, timestamp: 0x3a0ed402
19:06:50Maximum server connections 0
19:06:50(118) connection rejected - no calls allowed for srvinfx
19:06:50listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.
19:06:50On-Line Mode
19:07:19Checkpoint Completed:duration was 0 seconds.
19:07:19Checkpoint loguniq 97896, logpos 0x4ca0018, timestamp: 0x3a0ed480
19:07:19Maximum server connections 3
19:08:30Booting Language <spl> from module <>
19:08:30Loading Module <SPLNULL>
19:12:19Checkpoint 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 threadsmemory memory explain
7803 lnslapp- 2437488100.0.1. 1 409600 123968 off
tid name rstcb flags curstk status
8247 sqlexec700000088d5abb0---P---2091447696 running
Memory pools count 2
name class addr totalsizefreesize #allocfrag #freefrag
7803 V 7000000890d7040405504 284784 298 153
7803*O0 V 70000008a37b0404096 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 optcompinddirectives
70000008392d3707000000890d80280 0 0 2 1
SessSQL Current Iso Lock SQLISAM F.E.
Id Stmt type Database Lvl Mode ERRERRVers Explain
7803SELECT - - 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
SessSQL Current Iso Lock SQLISAM F.E.
Id Stmt type Database Lvl Mode ERRERRVers Explain
7803SELECT - - 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文件见附件:) ids 9.4FC8X4
会不会是BUG呢？！ 请问宕机后重启为什么会提示
19:06:50WARNING: Next backup of DBspace rootdbs must be level-0 backup.
回复 #3 antyison 的帖子
这个应该是与你所用的系统备份策略有关，日志很明显是提示你下次数据库备份，你需要做0级备份
页:
[1]