Re: Informix shutdown abnormally

do you think the server has not enough logical log to rollback the long transaction and shutdown itself ? the current high water mark setting is 50 % exclusive access 60 % --- Obnoxio The Clown <obnoxio@hotmail.com> wrote: > From: Lee Kwong Hong <kh71@pd.jaring.my> > > > >hey guys, > > > >recently our Informix server shutdown abnormally > two days in a roll with > >the following error message on the > >log file. > > > >09:03:49 Logical Log 32012 - Backup Completed > >09:04:31 Checkpoint Completed: duration was 14 > seconds. > >09:09:01 Checkpoint Completed: duration was 13 > seconds. > >09:09:01 Aborting Long Transaction: tx 0xd02482b8 > username: product uid: > >2107 > >09:11:31 Checkpoint Completed: duration was 6 > seconds. > >09:11:32 Informix Dynamic Server Stopped. > >09:24:47 Segment locked: addr=0xd35bc000, > size=290979840 > > > > > >Any idea what causing this ? > > Well, I certainly don't believe that a long > transaction should shut your > instance down. But a work around would clearly be to > add more logical log > space or to identify what is causing the long > transaction and restructure > that operation into smaller chunks. > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at > http://www.hotmail.com > __________________________________________________ Do You Yahoo!? Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/