aix环境下informix经常宕机
以下是宕机日志，请各位高手帮忙看看，谢谢，这是我的生产系统，几乎2天就宕一次，重新启动就好了，帮忙看看那里配置有问题，多谢15:29:21Maximum server connections 74
15:34:21Fuzzy Checkpoint Completed:duration was 0 seconds, 472 buffers not flushed,
timestamp: 0xe2cd05e4.
15:34:21Checkpoint loguniq 11616, logpos 0xc00358, timestamp: 0xe2cd05e4
15:34:21Maximum server connections 74
15:36:28Dynamically allocated new virtual shared memory segment (size 4189952KB)
15:36:35Requested shared memory segment size rounded from 4193444KB to 4193456KB
15:36:35Dynamically allocated new virtual shared memory segment (size 4193456KB)
15:36:43Assert Failed: No Exception Handler
15:36:43IBM Informix Dynamic Server Version 9.40.FC6
15:36:43 Who: Session(94, nmgamis@20.1.47.45, -1, 7000001a4f32d38)
Thread(160, sqlexec, 7000001a4f092f0, 4)
File: mtex.c Line: 431
15:36:43 Results: Exception Caught. Type: MT_EX_OS, Context: mem
15:36:43 Action: Please notify IBM Informix Technical Support.
15:36:43stack trace for pid 352386 written to /tmp/af.488330b
15:36:43 See Also: /tmp/af.488330b, shmem.488330b.0
15:37:27Error writing '/tmp/shmem.488330b.0' errno = 28
15:37:27mtex.c, line 431, thread 160, proc id 352386, No Exception Handler.
15:37:27Fatal error in ADM VP at mt.c:12358
15:37:27Unexpected virtual processor termination, pid = 352386, exit = 0x100
15:37:27PANIC: Attempting to bring system down 补充一下机器配置
我的机器是aix5.3，informix9.40
8cpu,32G内存 把/tmp/af.488330b 打包帖上来~~或者发给IBM fujian 回复 4# laike
估计是如此变态的语句导致了内存问题(可能是个BUG)
===========------------- - - - - - -
/informix/bin/onstat -g ses 94:
IBM Informix Dynamic Server Version 9.40.FC6 -- On-Line -- Up 22:54:08 -- 15868240 Kbytes
session #RSAM total used dynamic
id user tty pid hostname threadsmemory memory explain
94 nmgamis- -1 20.1.47. 1 -3276800 -3427960 off
tid name rstcb flags curstk status
160 sqlexec7000001a4f092f0--BP----1752189440 running
Memory pools count 1
name class addr totalsizefreesize #allocfrag #freefrag
94 V 7000001a7ae5040-3276800 151160 3237 43
name free used name free used
overhead 0 3248 scb 0 144
opentable 0 564096 filetable 0 6016
ru 0 600 log 0 4232
temprec 0 16248 keys 0 16064
ralloc 0 8585620336 gentcb 0 1600
ostcb 0 3456 sort 0 112
sqscb 0 95528 sql 0 72
rdahead 0 1120 hashfiletab 0 552
osenv 0 2472 sqtcb 0 22656
fragman 0 147592 udr 0 488
sqscb info
scb sqscb optofc pdqpriority sqlstats optcompinddirectives
7000001a7ac00b07000001a7ae60280 0 0 2 1
SessSQL Current Iso Lock SQLISAM F.E.
Id Stmt type Database Lvl Mode ERRERRVers Explain
94 csmp CRNot Wait 0 0 9.03 Off
Current SQL statement :
insert into t_optlog (did,objno,btnid,memo,optid,optdate) values
(?,?,?,?,?,?);insert into t_optlog (did,objno,btnid,memo,optid,optdate)
values (?,?,?,?,?,?);insert into t_optlog
(did,objno,btnid,memo,optid,optdate) values (?,?,?,?,?,?);insert into
t_optlog (did,objno,btnid,memo,optid,optdate) values
(?,?,?,?,?,?);insert into t_optlog (did,objno,btnid,memo,optid,optdate)
values (?,?,?,?,?,?);insert into t_optlog
(did,objno,btnid,memo,optid,optdate) values (?,?,?,?,?,?);insert into
t_optlog (did,objno,btnid,memo,optid,optdate) values
(?,?,?,?,?,?);insert into t_optlog (did,objno,btnid,memo,optid,optdate)
values (?,?,?,?,?,?);insert into t_optlog
(did,objno,btnid,memo,optid,optdate) values (?,?,?,?,?,?);insert into
t_optlog (did,objno,btnid,memo,optid,optdate) values
(?,?,?,?,?,?);insert into t_optlog (did,objno,btnid,memo,optid,optdate)
values (?,?,?,?,?,?);insert into t_optlog
(did,objno,btnid,memo,optid,optdate) values (?,?,?,?,?,?);insert into
t_optlog (did,objno,btnid,memo,optid,optdate) values
(?,?,?,?,?,?);insert into t_optlog (did,objno,btnid,memo,optid,optdate)
values (?,?,?,?,?,?);insert into t_optlog
(did,objno,btnid,memo,optid,optdate) values (?,?,?,?,?,?);insert into
t_optlog (did,objno,btnid,memo,optid,optdate) values
(?,?,?,?,?,?);insert into t_optlog (did,objno,btnid,memo,optid,optdate)
values (?,?,?,?,?,?);--------------------省略64K字节~
15:36:28Dynamically allocated new virtual shared memory segment (size 4189952KB)
15:36:35Requested shared memory segment size rounded from 4193444KB to 4193456KB
15:36:35Dynamically allocated new virtual shared memory segment (size 4193456KB)
在短短7秒的时间内,要向系统申请两次共8G的内存...
页:
[1]