Re: HELP! Online Logical Logs are full.

Niels Berner <berner@proinf.dk> writes: >I have a serious problem, with Informix Online, and I hope that someone >on the mailing-list is able to help me. > >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. > [stuff deleted] Niels, This problem appeared for us in June 1990. Although we were able to identify the circumstances that caused it, and thus avoid it in the future, I don't believe there is a solution once you enter the situation you describe above. In our case, we found that if an UPDATE STATISTICS statement is issued by SQL or 4GL when lock mode has been set to wait, the process will hang. If this happens when the logical logs are full a deadlock occurs that cannot be recovered from. I believe, from discussions with Informix, that the process is waiting for logical log space before it can finish, but OnLine is waiting for the process to finish before it can complete a checkpoint. We reported the problem to Informix and it was subsequently given bug number B7433. We discovered it in OnLine V4.00.UD2 but I believe it is still there... Having lost one development database I'm not game to find out :-( If your problem has been caused in the same way as ours, the workaround for _avoiding_ the problem is to remove all instances of UPDATE STATISTICS in SQL scripts or 4GL programs. Do UPDATE STATISTICS manually when 1) lock mode is not set to wait and 2) the logical logs are not full. Sorry I can't offer more help about how to get out of the deadlock. In our case we reinitialised the root dbspace and recovered from there. Regards, Ron Lees +-------------------------------------------------------------------+ | Ron Lees | | NEC Information Systems Australia Pty Ltd | | Software Development Centre (Canberra) | | | | Email: rlees@pdact.pd.necisa.oz.au | | Snail: PO Box 244, Belconnen ACT 2616, AUSTRALIA | | Voice: + 61 6 251 6411 | | Fax: + 61 6 251 6947 | +-------------------------------------------------------------------+