Re: Log Message - Retun code 142

Posted in 2003

malcolm.iiug — Wed, 17 Sep 2003 15:43:44 +0100 — source: Usenet: comp.databases.informix

Kalpana, you should understand that logs will still fill up. You have chosen not to save the logs but they are still recorded so that they can be used by ROLLBACK statements. Also be aware that any changes to the database schema, including creation of temp tables other than in a temp dbspace, are recorded to the log regardless of database logging. So, whatever you do logs will still fill up occasionally. It looks to me as though you have logging turned on for the database as to fill a 1 Mbyte logs (1000 pages) would take a little time. In your case the log filled in 17 seconds. Were you doing some form of batch update, alter table, batch delete, etc? regards Malcolm ----- Original Message ----- From: "KalpanaPai" <kalpanapai@hotmail.com> To: <informix-list@iiug.org> Sent: Wednesday, September 17, 2003 1:04 AM Subject: Log Message - Retun code 142 > Hi All > > As we are not using onbar or ontape, and LTAPEDEV is set to > /dev/null, > but i find the following msg in the log sometimes . > May i know what needs to be set in onconfig, i have 128 logs and > chkpoint is 60 sec > logsize is 1000, BUFFERS 200000, PHYBUFF 32 , LOGBUFF 32 and LOGSMAX > 256. > > > Logical Log 785 Complete. > 11:39:53 Process exited with return code 142: /bin/sh /bin/sh -c > /usr/informix/etc/log_full.sh 2 23 "Logical Log 785 Complete."> "Logical Log 785 Complete." > 11:40:09 Logical Log 786 Complete. > 11:40:10 Process exited with return code 142: /bin/sh /bin/sh -c > /usr/informix/etc/log_full.sh 2 23 "Logical Log 786 Complete."> "Logical Log 786 Complete." > 11:40:42 Fuzzy Checkpoint Completed: duration was 0 seconds, 29> buffers not flushed. > 11:40:42 Checkpoint loguniq 787, logpos 0x12f124 > > 11:41:42 Fuzzy Checkpoint Completed: duration was 0 seconds, 9> buffers not flushed. > 11:41:42 Checkpoint loguniq 787, logpos 0x136084 > > 11:42:42 Fuzzy Checkpoint Completed: duration was 0 seconds, 10> buffers not flushed. > 11:42:42 Checkpoint loguniq 787, logpos 0x14008c> > Thanks Heaps!!!!! > kalpana sending to informix-list