IDS crashes on Windows
Posted in 2005
Guys-
I've been seeing these error messages show up in my online log.
Several occur in a row, and either clear themselves up or crash the
engine. I am thinking that the RAID1 Array running the database is
getting flakey, but how can you tell which drive, or if it's the RAID
card? I am running IDS 9.30.TC2 (old, I know. I'll be installing
9.40.TC5 over Christmas) on Windows 2000 server. We have enabled the
Windows hardware monitoring, but nothing ever shows up in the event log.
I have run defrags and thorough scandisks. I have also blown away all
of the chunks, recreated the files and restored a backup. The effect
remains the same, every four or five days, it starts to generate errors
and eventually dies. Here is an extract from my online.log:
19:41:08 KAIO: error in kaio_WRITE, kaiocbp = 0x14ffe1c8, errno = 0
19:41:08 fildes = 480 (gfd 6), buf = 0x147A7000, nbytes = 4096, offset= 126353408
19:41:09 KAIO: error in kaio_WRITE, kaiocbp = 0x14feee94, errno = 0
19:41:09 fildes = 480 (gfd 6), buf = 0x156BC000, nbytes = 4096, offset= 190603264
19:41:09 KAIO: error in kaio_WRITE, kaiocbp = 0x1528506c, errno = 0
19:41:09 fildes = 480 (gfd 6), buf = 0x15287000, nbytes = 32768, offset= 225316864
19:41:09 KAIO: error in kaio_WRITE, kaiocbp = 0x14ffe280, errno = 0
19:41:09 fildes = 480 (gfd 6), buf = 0x0EE73000, nbytes = 4096, offset= 560599040
19:41:09 KAIO: error in kaio_WRITE, kaiocbp = 0x14ffe110, errno = 0
19:41:09 fildes = 480 (gfd 6), buf = 0x13EF3000, nbytes = 4096, offset= 593719296
19:41:10 Checkpoint Completed: duration was 1 seconds.
19:41:10 Checkpoint loguniq 140098, logpos 0x1a3018
19:41:10 Maximum server connections 13
19:45:39 KAIO: error in kaio_WRITE, kaiocbp = 0x14ff382c, errno = 0
19:45:39 fildes = 448 (gfd 14), buf = 0x0D8EB000, nbytes = 4096, offset= 169680896
19:46:09 Checkpoint Completed: duration was 0 seconds.
19:46:10 Checkpoint loguniq 140098, logpos 0x1a9018
19:46:10 Maximum server connections 13
<<Informix Dynamic Server>>> Logical Log 140098 Complete.
19:48:03 Logical Log 140098 Complete.
19:51:14 Checkpoint Completed: duration was 0 seconds.
19:51:14 Checkpoint loguniq 140099, logpos 0xcb018
19:51:15 Maximum server connections 13
19:52:08 KAIO: error in kaio_WRITE, kaiocbp = 0x14fed49c, errno = 0
19:52:08 fildes = 468 (gfd 4), buf = 0x0D8DA000, nbytes = 36864, offset
= 3375104
19:52:09 KAIO: error in kaio_WRITE, kaiocbp = 0x14fed49c, errno = 0
19:52:09 fildes = 468 (gfd 4), buf = 0x0D8DA000, nbytes = 36864, offset
= 3375104
19:52:09 Assert Failed: I/O error, Mirror Chunk
'C:\\IFMXDATA\\DDGPLC\\rootdbs_dat.000' -- Offline
19:52:09 Informix Dynamic Server Version 9.30.TC2
19:52:09 Who: Session(34969,
plcdata@nbpdc-cs1.corpnbp.nationalbeef.com, 118028, 0)
Thread(34986, sqlexec, 0, 1)
File: rsbuff.c Line: 4086
19:52:09 Results: Chunk is now unusable
19:52:10 Action: Repair and restore from mirror or archive
19:52:10 stack trace for pid 10112 written to C:\\tmp\\af.8c92b448
19:52:17 See Also: C:\\tmp\\af.8c92b448
19:52:17 I/O error, Mirror Chunk 'C:\\IFMXDATA\\DDGPLC\\rootdbs_dat.000'
-- Offline
19:52:17 I/O error, Mirror Chunk 'C:\\IFMXDATA\\DDGPLC\\rootdbs_dat.000'
-- Offline
19:52:19 Assert Failed: Chunk 1 is being taken OFFLINE.
19:52:19 Informix Dynamic Server Version 9.30.TC2
19:52:19 Who: Session(34969,
plcdata@nbpdc-cs1.corpnbp.nationalbeef.com, 118028, 0)
Thread(34986, sqlexec, 0, 1)
File: rsmirror.c Line: 1766
19:52:19 Results: Dynamic Server must abort
19:52:19 Action: Reinitialize shared memory
19:52:19 stack trace for pid 10112 written to C:\\tmp\\af.8c92b448
19:52:25 See Also: C:\\tmp\\af.8c92b448
19:52:25 Chunk 1 is being taken OFFLINE.
19:52:25 Chunk 1 is being taken OFFLINE.
19:52:25 Assert Failed: INFORMIX-OnLine Must ABORT
Critical media failure.
The af files contain the same info. I'll be calling tech support, as
well.
Thanks in advance, if someone
has any ideas.
--EEM
sending to informix-list