Re: Bug # 11718

Posted in 1997

Tony Tyrwhitt-Drake — Tue, 04 Mar 1997 22:59:57 GMT — source: Informix-list mailing list archive (1991-1998)

Edmund Nigel Gall <ngall@stratis-caribbean.com> wrote in article <5fhdku$c43@cssun.mathcs.emory.edu>... > <clipped> > ...the software refused to run > due to bug # 11718, "The Twin Problem, Adjacent Key Locking & Key Value > Locking." .... <much more clipped> Adjacent key locking is not actually a bug, but part of the design of version 5 and earlier. It is used to address the problem of rows that have been deleted but not committed ( and hence the delete might be rolled back). Version 6 onwards have a different design which uses a different strategy to address the problem. If you must use version 5, and you are using package software that does not allow you to alter the way locking is addressed, try running the database un-logged.