load数据时,informix数据库宕掉,急!
Fri Sep 18 15:32:01 200915:32:01Event alarms enabled.ALARMPROG = '/opt/informix/etc/log_full.sh'
15:32:01Booting Language <c> from module <>
15:32:01Loading Module <CNULL>
15:32:01Booting Language <builtin> from module <>
15:32:01Loading Module <BUILTINNULL>
15:32:06IBM 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:44listener-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:45listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.
15:32:45(8) connection rejected - no calls allowed for sqlexec
15:32:45listener-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:45listener-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:45IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.
15:32:45listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.
15:32:45Physical Recovery Started at Page (2:19814).
15:32:46Physical Recovery Complete: 310 Pages Examined, 310 Pages Restored.
15:32:46Logical Recovery Started.
15:32:4610 recovery worker threads will be started.
15:32:48Assert Failed: No Exception Handler
15:32:48IBM Informix Dynamic Server Version 9.40.FC4
15:32:48 Who: Session(13, informix@dxcdb, 0, c00000001048f9c8)
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:48stack trace for pid 16449 written to /tmp/af.557379f
15:32:48 See Also: /tmp/af.557379f, shmem.557379f.0
15:32:59Error writing '/tmp/shmem.557379f.0' errno = 28
15:32:59mtex.c, line 431, thread 367, proc id 16449, No Exception Handler.
15:32:59Fatal error in ADM VP at mt.c:12298
15:32:59Unexpected virtual processor termination, pid = 16449, exit = 0x100
15:32:59PANIC: Attempting to bring system down
15:32:59semctl: errno = 22
数据库宕机,load数据时,突然就宕掉了,请各位指点! semctl: errno = 22
这个是谁KILL掉了一个oninit 进程 ..
BTW:从日志上看,你的数据库都还没启动完成.....你怎么可能可以导数据呢? 之前数据库是正常启动的,也可以导入数据,不知道怎么,导入这个数据库表数据时,总是宕掉.Fast Recovery状态,停也停不掉,起也起不来.不知道是什么原因.
这种状态,都是什么原因引起的呢?请指教!
数据库宕掉以后,发现/tmp目录空间满了,还提示过逻辑日志空间不足等问题,弄糊涂了,不知道是那的问题?
回复 #3 msinfo32 的帖子
Fast Recovery 只是数据库启动到online的一个中间状态....表明数据库还没启动完成../tmp空间满,只因为数据库挂了后抛出的af以及shm文件占用了空间...这些文件是用来查明数据库异常原因的..
逻辑日志不足?~?配置的PHYFILE太小~
页:
[1]