KAIO: error in kaio_READ

Posted in 2009

DANIEL GILLIéRON — Thu, 26 Feb 2009 08:34:01 — source: IIUG Forums & Mailing Lists

Hi all, We are working with Informix 9.4.UC6 and AIX 5.3.0.0 and we have the following problem with a simple select statement on the Informix DB via the Oracle Transparent Gateway : 02:54:17 shmat: [EMFILE][24]: out of shared memory segments, check system SHMSEG 02:54:17 out of virtual shared memory I have found this IBM Technote : http://www-01.ibm.com/support/docview.wss?rs=631&context=SSGHZP&dc=DB520&uid=swg 21157040&loc=en_US&cs=UTF-8&lang=en&rss=ct631db2 and after changing the Parameter EXTSHM = ON in the. PROFILE Informix don't start. Here the error in ONLINE.LOG : 20:28:17 Event alarms enabled. ALARMPROG = '/Kygpxya1/soft/informix/etc/log_full.sh' 20:28:17 Booting Language <c> from module <> 20:28:17 Loading Module <CNULL> 20:28:17 Booting Language <builtin> from module <> 20:28:17 Loading Module <BUILTINNULL> 20:28:22 AIX MP latch code enabled 20:28:22 Requested shared memory segment size rounded from 5400KB to 5408KB 20:28:22 IBM Informix Dynamic Server Version 9.40.UC6 Software Serial Number AAA#B000000 20:28:24 KAIO: error in kaio_READ, kaiocbp = 0xb32d87c8, errno = 14 20:28:24 fildes = 256 (gfd 3), buf = 0xb3b1b400, nbytes = 4096, offset = 0 20:28:24 Assert Warning: chunk failed sanity check 20:28:24 IBM Informix Dynamic Server Version 9.40.UC6 20:28:24 Who: Session(1, informix@ygsv027s, 0, b1ac4018) Thread(7, main_loop(), b1a93018, 3) File: rspartn.c Line: 7812 20:28:24 Results: Chunk 1 is being taken OFFLINE. 20:28:24 Action: Restore chunk from archive. 20:28:24 stack trace for pid 589882 written to /tmp/af.3ef4a58 20:28:24 See Also: /tmp/af.3ef4a58 20:28:24 chunk failed sanity check 20:28:25 I/O error, Primary Chunk '/Kygpxya1/soft/informix/ifxdata/root_ch' -- Offline (sanity) 20:29:39 IBM Informix Dynamic Server Started. For information, the Asynchronous I/O is set on the server. thank you very much for your help Daniel