升级informix数据库到10.0出现KAIO错误的解决办法
原文地址：
http://space.itpub.net/312079/viewspace-245575
老数据库：
IBM Informix Dynamic Server Version 9.40.UC4W2
要升级的新数据库：
IBM Informix Dynamic Server Version 10.00.UC4
按照平时的升级步骤升级，当执行到oninit -v 时执行不过去。
[informix@tonykorn97 etc]$ oninit -v
Checking group membership to determine server run mode...succeeded
Reading configuration file '/home/informix/etc/tonykorn97.cfg'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Creating infos file "/home/informix/etc/.infos.ontonykorn97"...succeeded
Linking conf file "/home/informix/etc/.conf.ontonykorn97"...succeeded
Writing to infos file...succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 42630 kbytes...succeeded
Allocating 400016 kbytes for buffer pool of 2K page size...succeeded
Initializing rhead structure...succeeded
Initializing ASF...succeeded
Initializing Dictionary Cache and SPL Routine Cache...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Onlining 0 additional cpu vps...succeeded
Onlining 2 IO vps...succeeded
Initialization of Encryption...succeeded
Forking main_loop thread...succeeded
Initializing DR structures...succeeded
Forking 1 'soctcp' listener threads...succeeded
Starting tracing...succeeded
Initializing 1 flushers...succeeded
查看日志：
[informix@tonykorn97 ~]$ vi tonykorn97.log
23:15:25 IBM Informix Dynamic Server Started.
Thu Dec 28 23:15:26 2006
23:15:26 Warning: ONCONFIG dump directory (DUMPDIR) '/tmp' has insecure permissions
23:15:26 Event alarms enabled. ALARMPROG = '/home/informix/etc/log_full.sh'
23:15:26 Booting Language from module <>
23:15:26 Loading Module
23:15:26 Booting Language from module <>
23:15:26 Loading Module
23:15:31 DR: DRAUTO is 0 (Off)
23:15:31 IBM Informix Dynamic Server Version 10.00.UC4 Software Serial Number AAA#B000000
23:15:31 Assert Failed: initializing KAIO failed
23:15:31 IBM Informix Dynamic Server Version 10.00.UC4
23:15:31 Who: Session(1, [email]informix@tonykorn97.rrl.com[/email], 0, (nil))
Thread(11, kaio, 0, 1)
File: kaioapi.c Line: 246
23:15:31 Results: io_queue_init(32768) failed returning -22, errno = 0
23:15:31 stack trace for pid 3098 written to /tmp/af.3f3df93
23:15:31 See Also: /tmp/af.3f3df93, shmem.3f3df93.0
23:15:40 initializing KAIO failed
23:15:43 io_queue_init(32768) failed returning -22, errno = 0
23:15:43 Assert Failed: kaiothread() ERROR
23:15:43 IBM Informix Dynamic Server Version 10.00.UC4
23:15:43 Who: Session(1, [email]informix@tonykorn97.rrl.com[/email], 0, (nil))
Thread(11, kaio, 0, 1)
File: kaio.c Line: 2063
23:15:43 stack trace for pid 3098 written to /tmp/af.3f3df93
23:15:43 See Also: /tmp/af.3f3df93
23:15:45 kaio.c, line 2063, thread 11, proc id 3098, kaiothread() ERROR.
23:15:45 PANIC: Attempting to bring system down
23:15:45 semctl: errno = 22
23:15:45 semctl: errno = 22
查看日志中所提到的文件
[informix@tonykorn97 ~]$ vi /tmp/af.3f3df93
23:15:31
23:15:31 IBM Informix Dynamic Server Version 10.00.UC4 Software Serial Number AAA#B000000
23:15:31 Assert Failed: initializing KAIO failed
23:15:31 Who: Session(1, [email]informix@tonykorn97.rrl.com[/email], 0, (nil))
Thread(11, kaio, 0, 1)
File: kaioapi.c Line: 246
23:15:31 Results: io_queue_init(32768) failed returning -22, errno = 0
23:15:31 Stack for thread: 11 kaio
base: 0x5f924000
len: 36864
pc: 0x08786a17
tos: 0x5f92c890
state: running
vp: 1
0x08786a17 (oninit)afstack (0x5f871640, 0xc1a, 0x5f92c9a0, 0xf6, 0x0, 0x0)
0x087861b9 (oninit)afhandler(0x2, 0x8b1cf0d, 0x5f92cf20, 0x0, 0x401, 0x1)
0x0878565b (oninit)affail_interface(0x8b1cf0d, 0x5f92cf20, 0x0, 0x1, 0x8b1cf03, 0xf6)
0x08783ff3 (oninit)_aioinit(0x5f88fcf8, 0x0, 0x0, 0x0, 0x0, 0x0)
0x087822d7 (oninit)kaiothread(0x5f910078, 0x5f871640, 0x7, 0x0, 0x0, 0x0)
0x08767514 (oninit)startup (0x1b, 0x5f935818, 0x5f910480, 0x8818, 0xbf24e4b1, 0x0)
0x00000000 (*nosymtab*)0x0
23:15:31 See Also: /tmp/af.3f3df93, shmem.3f3df93.0
---------------------------------
Begin System Alarm Program Output
---------------------------------
经过查明，原来时操作系统版本的问题，
Red Hat Enterprise Linux AS release 4 (Nahant Update 1)
Kernel 2.6.9-11.ELsmp on an x86_64
这个就有这个问题！
Red Hat Enterprise Linux AS release 4 (Nahant Update 3)
Kernel 2.6.9-34.ELsmp on an i686
这个没有！
处理办法：
在informix的环境变量中增加一行：
export KAIOOFF=1
http://space.itpub.net/312079/viewspace-245575
老数据库：
IBM Informix Dynamic Server Version 9.40.UC4W2
要升级的新数据库：
IBM Informix Dynamic Server Version 10.00.UC4
按照平时的升级步骤升级，当执行到oninit -v 时执行不过去。
[informix@tonykorn97 etc]$ oninit -v
Checking group membership to determine server run mode...succeeded
Reading configuration file '/home/informix/etc/tonykorn97.cfg'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Creating infos file "/home/informix/etc/.infos.ontonykorn97"...succeeded
Linking conf file "/home/informix/etc/.conf.ontonykorn97"...succeeded
Writing to infos file...succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 42630 kbytes...succeeded
Allocating 400016 kbytes for buffer pool of 2K page size...succeeded
Initializing rhead structure...succeeded
Initializing ASF...succeeded
Initializing Dictionary Cache and SPL Routine Cache...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Onlining 0 additional cpu vps...succeeded
Onlining 2 IO vps...succeeded
Initialization of Encryption...succeeded
Forking main_loop thread...succeeded
Initializing DR structures...succeeded
Forking 1 'soctcp' listener threads...succeeded
Starting tracing...succeeded
Initializing 1 flushers...succeeded
查看日志：
[informix@tonykorn97 ~]$ vi tonykorn97.log
23:15:25 IBM Informix Dynamic Server Started.
Thu Dec 28 23:15:26 2006
23:15:26 Warning: ONCONFIG dump directory (DUMPDIR) '/tmp' has insecure permissions
23:15:26 Event alarms enabled. ALARMPROG = '/home/informix/etc/log_full.sh'
23:15:26 Booting Language
23:15:26 Loading Module
23:15:26 Booting Language
23:15:26 Loading Module
23:15:31 DR: DRAUTO is 0 (Off)
23:15:31 IBM Informix Dynamic Server Version 10.00.UC4 Software Serial Number AAA#B000000
23:15:31 Assert Failed: initializing KAIO failed
23:15:31 IBM Informix Dynamic Server Version 10.00.UC4
23:15:31 Who: Session(1, [email]informix@tonykorn97.rrl.com[/email], 0, (nil))
Thread(11, kaio, 0, 1)
File: kaioapi.c Line: 246
23:15:31 Results: io_queue_init(32768) failed returning -22, errno = 0
23:15:31 stack trace for pid 3098 written to /tmp/af.3f3df93
23:15:31 See Also: /tmp/af.3f3df93, shmem.3f3df93.0
23:15:40 initializing KAIO failed
23:15:43 io_queue_init(32768) failed returning -22, errno = 0
23:15:43 Assert Failed: kaiothread() ERROR
23:15:43 IBM Informix Dynamic Server Version 10.00.UC4
23:15:43 Who: Session(1, [email]informix@tonykorn97.rrl.com[/email], 0, (nil))
Thread(11, kaio, 0, 1)
File: kaio.c Line: 2063
23:15:43 stack trace for pid 3098 written to /tmp/af.3f3df93
23:15:43 See Also: /tmp/af.3f3df93
23:15:45 kaio.c, line 2063, thread 11, proc id 3098, kaiothread() ERROR.
23:15:45 PANIC: Attempting to bring system down
23:15:45 semctl: errno = 22
23:15:45 semctl: errno = 22
查看日志中所提到的文件
[informix@tonykorn97 ~]$ vi /tmp/af.3f3df93
23:15:31
23:15:31 IBM Informix Dynamic Server Version 10.00.UC4 Software Serial Number AAA#B000000
23:15:31 Assert Failed: initializing KAIO failed
23:15:31 Who: Session(1, [email]informix@tonykorn97.rrl.com[/email], 0, (nil))
Thread(11, kaio, 0, 1)
File: kaioapi.c Line: 246
23:15:31 Results: io_queue_init(32768) failed returning -22, errno = 0
23:15:31 Stack for thread: 11 kaio
base: 0x5f924000
len: 36864
pc: 0x08786a17
tos: 0x5f92c890
state: running
vp: 1
0x08786a17 (oninit)afstack (0x5f871640, 0xc1a, 0x5f92c9a0, 0xf6, 0x0, 0x0)
0x087861b9 (oninit)afhandler(0x2, 0x8b1cf0d, 0x5f92cf20, 0x0, 0x401, 0x1)
0x0878565b (oninit)affail_interface(0x8b1cf0d, 0x5f92cf20, 0x0, 0x1, 0x8b1cf03, 0xf6)
0x08783ff3 (oninit)_aioinit(0x5f88fcf8, 0x0, 0x0, 0x0, 0x0, 0x0)
0x087822d7 (oninit)kaiothread(0x5f910078, 0x5f871640, 0x7, 0x0, 0x0, 0x0)
0x08767514 (oninit)startup (0x1b, 0x5f935818, 0x5f910480, 0x8818, 0xbf24e4b1, 0x0)
0x00000000 (*nosymtab*)0x0
23:15:31 See Also: /tmp/af.3f3df93, shmem.3f3df93.0
---------------------------------
Begin System Alarm Program Output
---------------------------------
经过查明，原来时操作系统版本的问题，
Red Hat Enterprise Linux AS release 4 (Nahant Update 1)
Kernel 2.6.9-11.ELsmp on an x86_64
这个就有这个问题！
Red Hat Enterprise Linux AS release 4 (Nahant Update 3)
Kernel 2.6.9-34.ELsmp on an i686
这个没有！
处理办法：
在informix的环境变量中增加一行：
export KAIOOFF=1