RE: IDS crashes on Windows

Posted in 2005

Everett Mills — Wed, 30 Nov 2005 12:11:15 -0600 — source: Usenet: comp.databases.informix

Thanks Guy- I'll check into that. Strange that it would run for four years before it's become a problem, though. --EEM > -----Original Message----- > From: Guy Bowerman [mailto:gbowerman@yahoo.com] > Sent: Tuesday, November 29, 2005 10:22 PM > To: informix-list@iiug.org > Subject: Re: IDS crashes on Windows > > Everett, > > The symptoms you describe indicate a resource leak. There may well be > bugs in the IDS version you have that leak handles (like PTS 169797 - > SET DEBUG FILE STATEMENT CAUSES MEMORY LEAK ON WINDOWS - HANDLE COUNT > GROWS - fixed in 9.40.TC6). > > To confirm a handle count leak, open the Windows Task Manager and > highlight the oninit.exe process. Then pick View->Select Columns and > check "Handle Count". > > If the handle count for the oninit process is going up with time then it > is probably what is causing your problem. > > Be aware that in addition to the bug mentioned above there is also one > new resource leak that was introduced in 9.40.TC5: > PTS 174339 CONSOLE MESSAGES ARE NOT WRITTEN ON WINDOWS AND FILE HANDLE > IS NOT CLOSED CAUSING RESOURCE LEAK. > > This one is fixed in 9.40.TC8. > > Regards > Guy > > Everett Mills wrote: > > 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 sending to informix-list