Re: Why this Long Transaction?

Posted in 1994

Stuart Litel — 2 Feb 94 16:12:45 GMT — source: Informix-list mailing list archive (1991-1998)

This sounds like you could be having the famous bug that it cannot rollback due to it thinking it does not have enough log space. If this is the case, you must call Informix Tech Support and have them dial in. They must tweak a few bits to try and recover the database. This problem occurs in pre 5.0 versions of Online and I believe is in some ports of 5.0 version of Online. I strongly suggest if a "revovery" takes more than short period of time you could be encountering this famous bug. The other alternative - you do not want to hear - you must re-initialize your DBSPACE and restore from a backup.