load数据时,informix数据库宕掉,急!

msinfo32

Fri Sep 18 15:32:01 2009

15:32:01  Event alarms enabled.  ALARMPROG = '/opt/informix/etc/log_full.sh'
15:32:01  Booting Language <c> from module <>
15:32:01  Loading Module <CNULL>
15:32:01  Booting Language <builtin> from module <>
15:32:01  Loading Module <BUILTINNULL>
15:32:06  IBM Informix Dynamic Server Version 9.40.FC4     Software Serial Number AAA#B000000
15:32:44  (5) connection rejected - no calls allowed for sqlexec
15:32:44  listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.

15:32:45  (7) connection rejected - no calls allowed for sqlexec
15:32:45  listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.

15:32:45  ( connection rejected - no calls allowed for sqlexec
15:32:45  listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.

15:32:45  (9) connection rejected - no calls allowed for sqlexec
15:32:45  listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.

15:32:45  (10) connection rejected - no calls allowed for sqlexec
15:32:45  IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.

15:32:45  listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.

15:32:45  Physical Recovery Started at Page (2:19814).
15:32:46  Physical Recovery Complete: 310 Pages Examined, 310 Pages Restored.
15:32:46  Logical Recovery Started.
15:32:46  10 recovery worker threads will be started.
15:32:48  Assert Failed: No Exception Handler
15:32:48  IBM Informix Dynamic Server Version 9.40.FC4
15:32:48   Who: Session(13, informix@dxcdb, 0, c00000001048f9c
                Thread(367, xchg_1.2, c000000010451a20, 1)
                File: mtex.c Line: 431
15:32:48   Results: Exception Caught. Type: MT_EX_OS, Context: mem
15:32:48   Action: Please notify IBM Informix Technical Support.
15:32:48  stack trace for pid 16449 written to /tmp/af.557379f
15:32:48   See Also: /tmp/af.557379f, shmem.557379f.0
15:32:59  Error writing '/tmp/shmem.557379f.0' errno = 28
15:32:59  mtex.c, line 431, thread 367, proc id 16449, No Exception Handler.
15:32:59  Fatal error in ADM VP at mt.c:12298
15:32:59  Unexpected virtual processor termination, pid = 16449, exit = 0x100

15:32:59  PANIC: Attempting to bring system down
15:32:59  semctl: errno = 22
数据库宕机,load数据时,突然就宕掉了,请各位指点!

liaosnet

semctl: errno = 22

这个是谁KILL掉了一个oninit 进程 ..

BTW:从日志上看,你的数据库都还没启动完成.....你怎么可能可以导数据呢?

msinfo32

之前数据库是正常启动的,也可以导入数据,不知道怎么,导入这个数据库表数据时,总是宕掉.Fast Recovery状态,停也停不掉,起也起不来.不知道是什么原因.
这种状态,都是什么原因引起的呢?请指教!
数据库宕掉以后,发现/tmp目录空间满了,还提示过逻辑日志空间不足等问题,弄糊涂了,不知道是那的问题?

liaosnet

Fast Recovery 只是数据库启动到online的一个中间状态....表明数据库还没启动完成..

/tmp空间满,只因为数据库挂了后抛出的af以及shm文件占用了空间...这些文件是用来查明数据库异常原因的..

逻辑日志不足?~?配置的PHYFILE太小~