Re: Informix shutdown abnormally

Posted in 2000

Obnoxio The Clown — Sat, 06 May 2000 20:30:35 BST — source: Informix-list mailing list archive (1991-1998)

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