Chinaunix

标题: 求救!!数据库 oninit 时一直在fork oninit进程,资源耗尽! [打印本页]

作者: alain_lee    时间: 2004-12-31 01:45
标题: 求救!!数据库 oninit 时一直在fork oninit进程,资源耗尽!
我用informix 用户启动数据库时,fork出很多oninit进程,用户也无法登陆了,提示不能fork更多进程(AIX系统)

数据库日志:
23:01:38  IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.

23:01:38  Physical Recovery Started at Page (1:6374).
23:01:39  Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
23:01:39  Logical Recovery Started.
23:01:39  10 recovery worker threads will be started.
23:01:42  Logical Recovery has reached the transaction cleanup phase.
23:01:42  Logical Recovery Complete.
          0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

23:01:43  Dataskip is now OFF for all dbspaces
23:01:43  Checkpoint Completed:  duration was 0 seconds.
23:01:43  Checkpoint loguniq 139, logpos 0xcb1018, timestamp: 0x40b80c6

23:01:43  Maximum server connections 0
23:01:43  On-Line Mode
23:01:43  VPCLASS 'cpu' not enough physical procs for affinity
23:02:23  Assert Failed: Unexpected virtual processor termination, pid = 1192058, exit = 0x90009

23:02:23  IBM Informix Dynamic Server Version 9.40.FC5   
23:02:23   Who: Session(2, informix@, 0, 0)
                Thread(8, sm_poll, 0, 1)
                File: mt.c Line: 12579
23:02:23  stack trace for pid 1228896 written to /tmp/af.3f0f97e
23:02:23   See Also: /tmp/af.3f0f97e, shmem.3f0f97e.0
23:05:33  Error writing '/tmp/shmem.3f0f97e.0' errno = 28
23:05:33  mt.c, line 12579, thread 8, proc id 1228896, Unexpected virtual processor termination, pid = 1192058, exit = 0x90009
.
23:05:33  invoke_alarm(): /bin/sh -c '/usr/informix/etc/alarmprogram.sh 5 6 "Internal Subsystem failure: 'MT'" "mt.c, line 12579, thread 8, proc id 1228896, Unexpected virtual processor termination, pid = 1192058, exit = 0x90009
." '
23:05:33  invoke_alarm(): mt_exec failed, status 127, errno 0
23:05:34  The Master Daemon Died
23:05:34  invoke_alarm(): /bin/sh -c '/usr/informix/etc/alarmprogram.sh 5 6 "Internal Subsystem failure: 'MT'" "The Master Daemon Died" '
23:05:34  invoke_alarm(): mt_exec failed, status 7168, errno 0
23:05:34  PANIC: Attempting to bring system down

/tmp下的af文件
23:21:35  
23:21:35  IBM Informix Dynamic Server Version 9.40.FC5     Software Serial Number AAA#B000000

23:21:35  Assert Failed: Unexpected virtual processor termination, pid = 762004, exit = 0x90009

23:21:35   Who: Session(2, informix@, 0, 0)
                Thread(8, sm_poll, 0, 1)
                File: mt.c Line: 12579
23:21:35  Stack for thread: 8 sm_poll

base: 0x0700000100ffa000
  len:   36864
   pc: 0x000000010004c0d8
  tos: 0x000000011021fdf0
state: running
   vp: 1

0x000000010004c248 (oninit)afstack (0x9350d8, 0x1000ac, 0x10220008, 0xf0b2, 0x0, 0x236f4c00, 0x0, 0x0)
0x000000010004dc8c (oninit)afhandler(0x102205d4, 0x102205d4, 0x0, 0x0, 0x0, 0x236f4c00, 0x933320, 0x0)
0x000000010003585c (oninit)vp_child_handler(0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
0x09000000001615e8 (*nosymtab*)0x1615e8(0x0, 0xf4, 0x1002db0, 0xf6, 0x15, 0xffffffff, 0x10000258, 0x1)
0x0700000101007028 (*nosymtab*)0x1007028(0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
0x00000001001b9294 (oninit)net_sm_poll_thread(0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
0x00000001008e24fc (oninit)startup (0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
0x0000000000000000                 

怎么回事啊?急!明天就要上线运行了,突然出现这个问题。怎么办啊?!哪位高人帮看看啊!先谢了!
作者: 大梦    时间: 2004-12-31 12:17
标题: 求救!!数据库 oninit 时一直在fork oninit进程,资源耗尽!
NUMAIOVPS不要为空或零
作者: wolfop    时间: 2004-12-31 22:06
标题: 求救!!数据库 oninit 时一直在fork oninit进程,资源耗尽!
VPCLASS 'cpu' not enough physical procs for affinity
你设定了多少个CPUVP要绑定?系统多少CPU?
作者: 大梦    时间: 2005-01-01 18:13
标题: 求救!!数据库 oninit 时一直在fork oninit进程,资源耗尽!
AIX不支持绑定
作者: wolfop    时间: 2005-01-01 18:26
标题: 求救!!数据库 oninit 时一直在fork oninit进程,资源耗尽!
呵呵,IDS 9.4在AIX上面能够绑定,9.3之前的不行。
作者: 大梦    时间: 2005-01-02 00:48
标题: 求救!!数据库 oninit 时一直在fork oninit进程,资源耗尽!
http://publib.boulder.ibm.com/epubs/html/25122000.html
AIX5L的支持!
AIX4.3.3的不支持!
作者: wolfop    时间: 2005-01-02 18:03
标题: 求救!!数据库 oninit 时一直在fork oninit进程,资源耗尽!
不是OS问题,这个绝对是INFORMIX自己版本的问题,我在一台测试机上用AIX 4.3.3+ids 9.40fc2,完全可以绑定。
作者: czw1413_cn    时间: 2005-01-03 14:20
提示: 作者被禁止或删除 内容自动屏蔽




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