求救！！数据库 oninit 时一直在fork oninit进程，资源耗尽！

alain_lee

我用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                 

怎么回事啊？急！明天就要上线运行了，突然出现这个问题。怎么办啊？！哪位高人帮看看啊！先谢了！

大梦

NUMAIOVPS不要为空或零

wolfop

VPCLASS 'cpu' not enough physical procs for affinity
你设定了多少个CPUVP要绑定？系统多少CPU？

大梦

AIX不支持绑定

wolfop

呵呵，IDS 9.4在AIX上面能够绑定，9.3之前的不行。

大梦

http://publib.boulder.ibm.com/epubs/html/25122000.html
AIX5L的支持！
AIX4.3.3的不支持！

wolfop

不是OS问题，这个绝对是INFORMIX自己版本的问题，我在一台测试机上用AIX 4.3.3+ids 9.40fc2，完全可以绑定。