Re: database meltdown on RAID
Thanks for the tip. Informix tech support has nothing to say about corruption problems with IDS, Solaris 2.6 and RAID. I disabled KAIO on the servers, based on your suggestion. Now I have to wait a week or so and if the root dbspace remains intact. It turns out the Solaris specific environment variable to disable KAIO is KAIOOFF=1, instead of KAIO_OFF which is used on some other platforms. - Jay In article <B9H+AZAvilD4EwTQ@smooth1.demon.co.uk>, David Williams <djw@smooth1.demon.co.uk> wrote: > In article <7ulji9$ur4$1@nnrp1.deja.com>, jshaley@my-deja.com writes > >We have a serious problem setting up two database servers > >with Informix Dynamic Server 7.31.uc2xf using raw (non-unix) disk space > >on RAID 5 devices. Root dbspace pages get corrupted intermittantly > >sometimes crashing the DB immediately, and sometimes just damaging it > >so that it can't be restarted if brought down. > > > >The corruption is sometimes extensive, like all (2k) pages from 4-100 > >set to zeroes, and sometimes more subtle. > > > >I am trying to set up Enterprise replication between the two servers, > >but don't see a clear pattern of ER causing the problem. > > > >The RAID is an Adjile Systems SCSI device. The disk format info shows: > > <CMDTECH-CRD-5440-1-C1-8 cyl 26047 alt 2 hd 16 sec 64> > > /sbus@3,0/SUNW,fas@3,8800000/sd@0,0 > > > >The corruption only occurrs in dbspace defined in partition 1 > >of the disk. A second DB instance defined in partition 2 on the > >same disk is rock steady. > > > >Our system administrator has applied all the Solaris 2.6 patches he > >could > >find, and upgraded the firmware in the RAID. Informix tech support says > >it's hardware - not their problem. The hardware vendors say it's > >Informix. > > > >If anyone has any ideas, or knows anybody who might have > >an idea please send me a note or post a reply. > > > >Thanks, Jay Haley > > > > > >Sent via Deja.com http://www.deja.com/ > >Before you buy. > > He have seen Online corruption on ICL machines..try setting > > KAIO_OFF=1 > > before starting online. > > We found KAIO+Logical Volume Manager does not work... > > PS We had a Solaris 2.6 box which got a corrupted root filesysytem > after upgrading Informix recently...Restoring from backup+reupgrading > fixed it..(??!!!). > > Try turning off KAIO as above.. > > -- > David Williams > Sent via Deja.com http://www.deja.com/ Before you buy.
On Thu, 21 Oct 1999 19:49:12 GMT, jshaley@my-deja.com wrote: >Thanks for the tip. Informix tech support has nothing to say about >corruption problems with IDS, Solaris 2.6 and RAID. I disabled KAIO on >the servers, based on your suggestion. Now I have to wait a week or so >and if the root dbspace remains intact. > >It turns out the Solaris specific environment variable to disable KAIO >is KAIOOFF=1, instead of KAIO_OFF which is used on some other platforms. we use Solaris2.7 x86-IDS 7.30. can I use KAIOOFF=1 ? //////////////////////////////////////////////////////////////// Sa-Lu Tung's Hospital ,Taichung Taiwan Bill Wang binary@ms1.hinet.net t1716@sltung.com.tw