RE: is anybody listening

Harold, Thanks for the response. Ok, here are the 'af...' files. The file 'af.46c840d', from 3/15, reboot was temporary fix to get on-line. 13:39:38 13:39:38 Assert Failed: WARNING! Internal Error - Arithmetic Exception 13:39:38 Who: Session(921, pin@admsrv1.sph.hrs, 10196, 17) Thread(1047, sqlexec, 82f8e0, 1) 13:39:38 Results: Internally corrected 13:39:38 See Also: /tmp/af.46c840d 13:39:38 ------------------ End of assertion failure 0 ----------------- The file 'af.4733cc1', from 3/29, I had to do a restore from backup to get on-line. Yuck, it's been 12 yrs since I looked at machine code. 13:06:07 logwrite: Bad page (0) in log bufferpg 00aba800: 00000000 00000000 00000002 00000000 ........ ........ 00aba810: 00000000 00000000 00000000 00000000 ........ ........ 00aba820 * logp 00816b90: 00000000 00000000 00000000 00000000 ........ ........ 00816ba0 * 00816c00: b005ca00 00000000 106f8100 00000000 ........ .o...... 00816c10: 00000000 00000000 00000000 00000000 ........ ........ 00816c20 * 00816c30: 1d020000 d2070000 6c6f6700 00000000 ........ log..... 00816c40: 00000000 00000000 00000000 00000000 ........ ........ 00816c50: 986c8100 00000000 e06c8100 00000000 .l...... .l...... 00816c60: 00a8ab00 00000000 c4f78b00 00000000 ........ ........ 00816c70: 01000100 00000000 00a8ab00 00000000 ........ ........ 00816c80: 20cc8200 00000000 00000000 00000000 ....... ........ 00816c90: b005ca00 00000000 e06c8100 00000000 ........ .l...... 00816ca0: 506c8100 00000000 0028ac00 00000000 Pl...... .(...... 00816cb0: e0f78b00 00000000 02000000 00000000 ........ ........ 00816cc0: 0028ac00 00000000 00000000 00000000 .(...... ........ 00816cd0: 00000000 00000000 2806ca00 00000000 ........ (....... 00816ce0: 506c8100 00000000 986c8100 00000000 Pl...... .l...... 00816cf0: 00a8ac00 00000000 00000000 00000000 ........ ........ 00816d00: 00000000 00000000 00a8ac00 00000000 ........ ........ 00816d10: 00000000 00000000 00000000 00000000 ........ ........ 00816d20: a006ca00 00000000 10000000 00000000 ........ ........ 00816d30: 986c8100 00000000 00000000 00000000 .l...... ........ 00816d40: 00000000 00000000 00000000 00000000 ........ ........ 00816d50: 00000000 00000000 ........ logf 008bf7c4: 08001300 bf3c7304 0fc1ff36 d40a0000 .....<s. ...6.... 008bf7d4: 25121000 fa000000 a3000000 %....... .... bip 00816c50: 986c8100 00000000 e06c8100 00000000 .l...... .l...... 00816c60: 00a8ab00 00000000 c4f78b00 00000000 ........ ........ 00816c70: 01000100 00000000 00a8ab00 00000000 ........ ........ 00816c80: 20cc8200 00000000 00000000 00000000 ....... ........ 00816c90: b005ca00 00000000 ........ $ What can I do to prevent this in the future? > -----Original Message----- snip > > Please help. I am running Informix v7.1 under UNIX on a digital 1000 > server. > > We have been running fine for several years, with the 'normal' bumps and > > grinds. Lately, checkpoints will stop and then online froze, a reboot > has > > helped as a Band-Aid only. The other morning, noticing checkpoints had > > stopped and the system was froze, I tried a force checkpoint but it > froze - > > waited 30 minutes. Tried to take it off-line without success, finally > had to > > shut down the server. On reboot it froze in recovery mode saying to > check > > online-log. It said... > > 13:04:44 DR: DRAUTO is 0 (Off) > > 13:04:59 INFORMIX-on-line Initialized -- Shared Memory Initialized. > > 13:04:59 Physical Recovery Started. > > 13:04:59 Physical Recovery Complete: 21 Pages Restored. > > 13:04:59 Logical Recovery Started. > > 13:04:59 Logical Recovery allocating 10 worker threads > > ('OFF_RECVRY_THREADS'). > > 13:06:07 Logical Log 2772 - Backup Started > > 13:06:07 Logical Log 2772 - Backup Completed > > 13:17:55 The Master Daemon Died > > 13:17:55 PANIC: Attempting to bring system down> > > > It looks like a bad log file. So how do I get rid of a bad logical log > file > > from off-line mode? snip > > This particular Informix instance is small, just 2 dbspaces and 2 active > > databases with maybe 15 users entering data, and a dozen just browsing, > plus > > 3 other databases for archival and testing purposes residing here. And > there > > is no testing going on, Only I do that. > > I am self taught and on my own here, befuddled, so what should I be > looking > > for? > > What could cause the checkpoints to just stop? > > > >