Re: Full Online Logical Logs

Niels Berner <berner@diku.dk> writes: > The problem is that my logical logs are full. When I try to enter quiescent > mode, the Online-engine is trying to do a fast-recovery, which dosn't seem > to end. As long as i can't enter quiescent-mode, I'm not able to backup my > logical logs. When I enter tbmonitor the mode is recovery. > > The Online log file is as follows: > > 15:18:21 INFORMIX-Online Initialized -- Shared Memory Initialized > 15:18:21 Physical Recovery Started > 15:18:28 Checkpoint Completed > 15:18:28 Physical Recovery Completed: 160 Pages Restored > 15:18:28 Aborting Long Transaction: pid = 0, uid = 206 > 15:18:46 Logical Log Files are Full -- Backup is Needed I've seen this a couple of times, and not found a solution yet. In general, with no free log space, you can't do anything and the next step is initialization of the db spaces. Not nice, and I'd very much like a fix too (are you listening, Informix ?). Last time I did it I was up all night with backup tapes and considered myself lucky in that we had backups. There is a problem in that if you've only got small logs, you can start a decent-sized transaction (something as simple as "DELETE FROM foo") and, with normal system activity occurring at the same time, you stand a very good chance of blowing up the system. The txn gets killed when OnLine makes it into the last log, but if there isn't space left for the rollback there's nothing you can do apart from restore from tape. Blecch. Those long lines of dots are always a bad sign: sorry. Try to go for big logs and small transactions if at all possible. > the users are getting pretty pissed. It means something else over here (but I suspect it's still true). -- Cheers - Tony. ____________________________________________________________________________ Tony Heskett: theskett@lhr-sys.ssf-sys.dhl.com | Vox: (+44) 81 747 8330 DHL Systems : Kings House, Great West Road, TW8 9HS | Fax: (+44) 81 747 0875